Answer:
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
Explanation:
In MS Excel, on the left hand side below the tool bar there is a small box which tells the cell name where the cursor is clicked, the name of the cell can be changed from here easily, click on the desired cell and then by clicking on the box you can enter the name of the cell. After a cell is renamed the formula can be written by simply putting the name of the cell instead of the original e.g. E13
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
The cells provided in the formula above is just an example and more than two cells can be selected.
Answer:C. Real interest rates expected by British investors are 2 percentage points higher than the real interest rate expected by US investor.
Explanation:
The real interest rate is the market interest rate less the inflation rate.
The inflation rate always reduce the purchasing power of money which is the real measure of the purchasing power of money and not the money face value.
Answer:
The answer is $56.68
Explanation:
Solution
We recall that:
The firm paid a dividend of =$7.80
The projected growth of dividends is at a rate = 9.0%
The annual return = 24.0%
Now,
V = ($7.80 * (1.09)/(.24 - 0.9)
= (8.502)/(.24-0.9)
= (8.502) * (-0.66)
= $56.68
Therefore, this would be the most we would pay for the stock. If we paid less than that, our return would be above the 24%.
Answe and Explanation:
b) To find out the equilibrium interest we will equate the money demand function with the money supply:
1000 - 200(r) = 1200/2
r = 2%
c) If the price is fixed and if the supply of money of is increased from 1200 to 1400 then the supply of real balances will be 1400/2 = 700
The equilibrium interest would be:
1000 - 200(r) = 700
r = 1.5%
Thus, it shows that when the supply of money is increased and the price is fixed then the interest rate would fall from 2% to 1.5%
d) The supply of real balances would be 1600/2 = 800
Hence, the interest rate will be:
1000-200(r) = 800
r = 1%
As proved above, an increase in the money supply would decrease the interest rate keeping the price fixed.
e) If the Fed keeps the interest rate at 5% then,
1000 - 200(5) = Money supply/2
Money supply = 0
Reduce the money supply if the interest is increase from 2% to 5%
a) Picture is attached.
Answer:
The answer is: Chris should select Plan A if his total sales ≥ $7,900
Explanation:
Plan A = $320 + 8%s
Plan B = $715 + 3%s
where s = gross sales
To find at what point should Chris choose Plan A, we must solve the equations given that Plan A = Plan B
$320 + 8%s = $715 + 3%s
8%s - 3%s = $715 - $320
5%s = $395
s = $395 / 5% = $7,900