Explore BrainMass

Calculate the present value of an investment that is compounded daily

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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

Solution Summary

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.

See Also This Related BrainMass Solution

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