(TCO B) You just won $25,000 in the lottery. You decide you want to buy a sportscar. You don’t want to buy the car now but want to wait for 5 years when you will be 25 and your insurance premiums will be affordable. You think you can earn 8% on the money. How much will you be able to spend on the sportscar in five years?
Ignore taxes. Show your work. If you use Excel, show the formula with the parameters, and the answer. If you use a formula, provide the standard formula, the formula with terms substituted, and the answer. If you use a calculator, show the inputs and the answer.
(TCO B) You have a student loan of $75,000. The interest rate is 8.6% per year. You have been out of school for 6 months and are ready to start making payments. You want to use the maximum allowed of 10 years to pay off the loan by making equal monthly payments. How much are the monthly payments?
Ignore taxes. Show your work. If you use Excel, show the formula with the parameters, and the answer. If you use a formula, provide the standard formula, the formula with terms substituted, and the answer. If you use a calculator, show the inputs and the answer.
(TCO B) You want to have $1,000,000 in 30 years. You already have $50,000. You think you can get a 7% annual return on your money. How much per year will you have to save to get to $1,000,000?
Ignore taxes. Show your work. If you use Excel, show the formula with the parameters, and the answer. If you use a formula, provide the standard formula, the formula with terms substituted, and the answer. If you use a calculator, show the inputs and the answer.
