An investment will pay you $45,000 in 6 years. If the appropriate discount rate is 8% compounded daily, what is the present value?
Solve using a spreadsheet.
The solution presents a spreadsheet with clear explanations of how to use the Excel functions to solve the problem. Then the amounts are given for this problem to be inserted into the functions.