I need help with thises question, please use excel and formula.

42 43 YOU MUST EITHER USE AN EXCEL FORMULA OR DESCRIBE THE CALCULATIONS USED TO EARN CREDIT (insert rows where needed): 7. What is the future value of a single $6,000 investment made today invested for 10 years at 9.5% 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 right size, number of bedrooms, and neighborhood for your needs costs $285,000 although Zillow project that prices will increase by an average of 3.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 3.75% per year over that time. Today, she gave you the proceeds of that investment which is now worth $41,763. How much did she originally invest? 10. In 2020 , you earned a base salary of $52,000. If you expect to receive 4% raises every year on January 1 , what do will anticipate your earned salary will be in 2027? 11. A company will need $400,000 five years from now in order to replace to purchase a new CRM system. How much money must be set aside today for this purpose if it wants to fund this in full today and it can earn 8.25% 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 15 years from now. If the relevant annual discount rate is 7.35%, what is the present value of this liability? 13. You put away $8,000 sixteen years ago. Today, that single investment is now worth $28,651. What is the average annual rate of return you earned on your single investment? 14. Your college student needs a gently-used car and you believe you can afford $250 a month for a 5-year car loan with no money down. If the interest rate on a used-car loan is 4.5% percent, what is the maximum price for the car you can afford? 15. You contribute $200 per month to your retirement plan and your employer matches 50% of that amount every month. Assume that you work for this employer for 10 years and the applicable discount rate is 7.25% per year. Given these assumptions, what is 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 ner vear but rather $400 ner month) for the next 7 vears. If the comnanv earns 8.25% ner vear on its monev. 17. You are borrowing $18,750 with no money down to buy a new car. The terms of the loan call for equal monthly payments for for 5 years at 3.25% 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 of the next 20 years and you anticipate being able to earn 10% per year on your investments. Assuming annual compounding and no distributions from this account, how much do you expect to have in your Schwab account after 20 years? 19. Your company takes out a 8-year term loan to borrow $2,575,000 to finance a building expansion. The annual interest rate on the loan is 4.6% 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