Studying for an excel exam for a financial modeling course. Teachers goes extremely fast and not sure how to go about this question. Im off several...

Studying for an excel exam for a financial modeling course. Teachers goes extremely fast and not sure how to go about this question. Im off several numbers excel sheet is a must HELP !!

You are valuing an investment that will pay you$26,000 per year for the first 9 years, $34,000 per year for the next 11 years, and $47,000 per year the following 14 years (all payments are at the end of each year). Another similar risk investment alternative is an account with a quoted annual interest rate of 9.00% with monthly compounding of interest. What is the value in today's dollars of the set of cash flows you

have been offered?