Question
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
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.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 right size, number of bedrooms, and neighborhood for your needs costs $425,000 although Zillow project that prices will increase by an average of 5.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.75% per year over that time. Today, she gave 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 do will 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 money must be set aside today for this purpose if it wants to fund this in full today and it can earn 8.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 from now. If the relevant annual discount rate is 7.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 rate of 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 no money down. If the interest rate on a used-car loan is 8.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. Assume that you work for this employer for 8 years and the applicable discount rate is 7.55% 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 per year but rather $400 per month) for the next 7 years. If the company earns 8.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 for for 5 years at 6.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 of the next 22 years and you anticipate being able to earn 8% 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 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 rate on the loan is 6.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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started