Please use excel file to work out the time value examples in the slides for chapter $5$ and upload your excel file here. Please use all the cell reference and time value functions to do all the calculations inside the excel. Please lay out your input information separately and label it clearly.

Suppose you invest $$500$ in a mutual fund today and $$600$ in one year. If the fund pays $9\%$ annually, how much will you have in two years?

You are considering an investment that will pay you $$1,000$ in one year, $$2,000$ in two years and $$3,000$ in three years. If you want to earn $10\%$ on your money, how much would you be willing to pay?

A new ice cream machine for the Tech Farm Dairy will generate expected cash inflows of $$3,000$ each year for $10$ years. Similar risk projects pay $10\%$ per year. What is the fair price Tech Farms should offer for the machine?

Suppose you borrow $$10,000$ from parents to buy a car. You agree to pay $$207\mathrm{.}58$ per month for $60$ months. What is the monthly interest rate?

Suppose you want to buy a new computer system. The store will allow you to make monthly payments. The entire computer system costs $$3,500.$ The loan period is for $2$ years and the interest rate is $16\mathrm{.}9\%$ with monthly compounding. What is your monthly payment?