Answer:
Calculating the bill total for the week:
The Sum Function in excel is a very easy mathematical operation to sum the daily bill amounts. In the cell for the sum, you can manually enter the sum function by typing (=sum), then you define the parameters (=sum(C50:I50). One you press the "enter" the result is automatically displayed. This can also be automatically done by pressing the Sum Function on the Ribbon or Alt + =.
Explanation:
In Microsoft Excel, the Sum Function is a mathematical operation or syntax that provides the formula for adding, subtracting, or getting the total numerical content of indicated cells. With the Sum Function of Excel you can add, subtract, multiply, and divide, for example A1 * A4, C20/A2, A4 - A5, and so on.
Answer: The parliament is likely to allocate £ 1,23,93,800.62
We arrive at the answer as follows:
Amount allocated by President Obama $100,000,000
Amount England wants to contribute 20% of President Obama's allocation
Amount England wants to contribute in USD =
Exchange Rate $1. 61371/1 pound sterling
We can read the problem as if $1.61371 is equal to 1 pound sterling, how many pound sterlings are equal to $2,00,00,000?
Let number of pound sterlings be x
So, 
Answer:
The debit adjustment to equipment would be $30,000.
Explanation:
Amount received for the equipment by Mortar from Granite - $370,000
Purchase price of the equipment = $400,000
Debit adjustment to equipment = Purchase price of the equipment - Amount received for the equipment by Mortar from Granite = $400,000 - $370,000 = $30,000
Therefore, the debit adjustment to equipment would be $30,000.
Answer:
$143,750
Explanation:
We have to first calculate the present value of the bargain purchase option:
PV = $200,000 / (1 + 6%)⁵ = $149,451.63
net lease amount = $790,000 - $149,452 = $640,548
PVIF Annuity due, 6%, 5 payments = 4.546
Annual payment = $640,548 / 4.456 = $143,750
