Answer:
iii
Explanation:
Most of the time hotels will charge more when more rooms are booked, so when you book your hotel room, and many rooms are booked, most people do get charged more.
Answer:
MIRR = 4.32%
Explanation:
year cash flow
0 -$795,000
1 $375,000
2 -$500,000
3 $600,000
4 $400,000
Since there are 2 cash outflows, the IRR calculation would result in two different answers (1 for every cash outflow), that is why we use the MIRR function in excel.
=MIRR (cash flows, finance rate, reinvestment rate)
=MIRR (-795000 to 400000, 5.5%, 5.5%)
Since we are only given one interest rate, we will use it as our finance rate and our reinvestment rate.
MIRR = 4.32%
Answer:
the formula in cell F5 =IF(AND(B5="FT",C5>0),0.07*(D5-E5),0.05*(D5-E5))
Explanation
Check attachment for the given data and solution data