CAN YOU SHOW HOW YOU DO THIS ON EXCEL?

TVM Problems Present Value of Uneven Cash Flows Company Madeline launches a new product that will produce the following cash flows: Year 1 - Year 2- Year 3- $ $ $ 5,000 7,500 12,000 The company's interest rate is 12% What is the value of the new product? Other TVM Problems: 1) You just purchased a house for $ 160,000, in 5 years it's market value will be $175,000. What will be the rate of return on your house? (what retum (annual) will you eam on your investment?). 2) You can save $1,500 per year - you want to save a total of $20,000. You can eam 8% on your savings - how long will you need to save? 3) You are purchasing a home. The cost of the home (and the amount of your loan) is $250,000 The rate on your mortgage is 6% (compounded monthly) and the loan is for 30 years. What will be your monthly house payment