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.© BrainMass Inc. brainmass.com October 24, 2018, 5:07 pm ad1c9bdddf
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.
Effective annual rate (EAR) for investment choices
You have found three investment choices for a one-year deposit: 10% APR compounded monthly, 10% APR compounded annually, and 9% APR compounded daily. Compute the Effective Annual Rate (EAR) for each investment choice. (Assume that there are 365 days in the year). Please show in Excel.View Full Posting Details