Explore BrainMass
Share

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
https://brainmass.com/business/finance/calculate-the-present-value-of-an-investment-that-is-compounded-daily-2357

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.

$2.19
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