YOU MUST USE EXCEL'S FUNCTIONALITY TO PERFORM ALL CALCULATIONS TO EARN CREDIT $($insert rows as needed$)$DO NOT MERELY TYPE IN NUMBERS OR IMPORT TEXT FROM OTHER SOURCES:$7.$ What is the future value of a single $$6,000$ investment made today invested for $10$ years at $9\mathrm{.}75\%$ compounded annually?$8.$ You would like to move out of a rental apartment and buy a new home $4$ years from now. Today, a typical home with the rightsize, number of bedrooms, and neighborhood for your needs costs $$425,000$ although Zillow project that prices will increase by anaverage of $5\mathrm{.}5\%$ per year over the next $4$ years. How much should you plan on the house costing by the time you are ready to buy it$?9.$ Your grandmother invested a lump sum for you $20$ years ago earning an average of $5\mathrm{.}75\%$ per year over that time. Today, shegave you the proceeds of that investment which is now worth $$79,539.$ How much did she originally invest?$10.$ In $2023,$ you earned a base salary of $$57,000.$ If you expect to receive $4\%$ raises every year on January $1,$ what dowill anticipate your earned salary will be in $2033?11.$ A company will need $$400,000$ five years from now in order to replace to purchase a new CRM system. How much moneymust be set aside today for this purpose if it wants to fund this in full today and it can earn $8\mathrm{.}2\%$ per year on its investments?$12.$ Norris Lowe Industries has an unfunded waste site cleanup liability of $$5$ million that must be paid out in full $16$ years fromnow. If the relevant annual discount rate is $7\mathrm{.}75\%,$ what is the present value of this liability?$13.$ You put away $$9,000$ eighteen years ago. Today, that single investment is now worth $$29,932.$ What is the average annual rateof return you earned on your single investment?$14.$ Your college student needs a gently$-$used car and you believe you can afford $$270$ a month for a $5-$year car loan with nomoney down. If the interest rate on a used$-$car loan is $8\mathrm{.}5\%$ percent, what is the maximum price for the car you can afford?$15.$ You contribute $$250$ per month to your retirement plan and your employer matches $50\%$ of that amount every month. Assumethat you work for this employer for $8$ years and the applicable discount rate is $7\mathrm{.}55\%$ per year. Given these assumptions, whatis this benefit worth to you in today's dollars?$16.$ Your company is scheduled to earn a stream of royalty payments from a distributor in the amount of $$400$ per month$($NOT $$4,800$ per year but rather $$400$ per month$)$ for the next $7$ years. If the company earns $8\mathrm{.}25\%$ per year on its money,what is this total royalty stream worth to the company today?$17.$ You are borrowing $$25,750$ with no money down to buy a new car. The terms of the loan call for equal monthly payments forfor $5$ years at $6\mathrm{.}75\%$ annual interest. What is the amount of each monthly payment?$18.$ You anticipate being able to put an extra $$2,500$ at the end of each year into your Schwab investment account for EACH ofthe next $22$ years and you anticipate being able to earn $8\%$ per year on your investments. Assuming annual compounding andno distributions from this account, how much do you expect to have in your Schwab account after $22$ years?$19.$ Your company takes out a $8-$year term loan to borrow $$3,600,000$ to finance a building expansion. The annual interest rateon the loan is $6\mathrm{.}7\%$ and equal payments are made monthly. How much will the monthly payment be$?20.$ Referring back to question #$19,$ how much total interest will the company be paying over the life of the term loan?