Please use excel file to work out the time value examples in the slides for chapter $4$ 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 your company expects to increase unit sales of widgets by $15\%$ per year for the next $5$ years. If you currently sell $3$ million widgets in one year, how many widgets do you expect to sell during the fifth year?

You want to begin saving for your daughter's college education and you estimate that she will need $$150,000$ in $17$ years. If you feel confident that you can earn $8\%$ per year, how much do you need to invest today?

Suppose you have a $1-$year old son and you want to provide $$75,000$ in $17$ years toward his college education. You currently have $$5,000$ to invest. What interest rate must you earn to have the $$75,000$ when you need it$?$