Have no idea what I am doing wrong but I can't get the calculations correct.
Compute and show your work for the following scenarios:
Calculate the present value of the following lump sums:
$100,000 to be received five years from now with a 5% annual interest rate
$200,000 to be received 10 years from now with a 10% annual interest rate
Calculate the future value of the following lump sums:
$100,000 if invested for five years at a 5% annual interest rate
$200,000 if invested for 10 years at a 10% annual interest rate
Calculate the present value of these ordinary annuities:
$100,000 to be received each year for five years with a 5% annual interest rate
$200,000 to be received each year for 10 years with a 10% annual interest rate
Calculate the future value of these ordinary annuities:
$100,000 if invested each year for five years at a 5% annual interest rate
$200,000 if invested each year for 10 years at a 10% annual interest rate
Calculate the present value of these perpetuities:
$100,000 to be received each year forever with a 5% annual interest rate
$200,000 to be received each year forever with a 10% annual interest rate
Computations (use Excel).
Show the computations as required above.
Summarize the results in an easy to read table at the top of the spreadsheet or on a clearly labeled separate tab.