In: Finance
You are valuing an investment that will pay you $26,000 per year for the first 14 years, $34,000 per year for the next 10 years, and $47,000 per year the following 11 years (payments are at the end of each year). Another similar risk investment alternative is an account with a quoted annual interest rate of 7.50% with MONTHLY compounding of interest. What is the value in today's dollars of the set of cash flows you have been offered?
(If possible please solve in excel) :)