Please use Excel
Consider a 12-year ordinary annuity that pays $2,500 per month
with the first payment made one month from now. If the appropriate
discount rate is 14 percent compounded semiannually, what is the
value of this annuity 3 years from now?
Consider the series of uneven cash flows below:
End of Month
June
July
August
September
October
November
Cash Flow
$230,000
$160,000
$275,000
$320,000
$25,000
$773,000
If the effective annual rate (EAR) is 8.3 percent, what is the...