3 essay questions

Your daughter has just given birth to your first grandchild. You decide to start a college fund for the child. You want the fund to have $300,000 in it when the child turns 18. You think you can get a return of 10% per year on your investment. How much should you deposit in the fund? 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. (Points : 5)

Question 2. 2. (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. (Points : 5)

Question 3. 3. (TCO B) Your cousin wants to buy a car but he really can’t afford it. He needs a loan of $22,000. The finance manager at the dealership offers him something like a loan in which your cousin will get the $22,000 and will pay $413 per month for the next 60 months with an additional payment of $3,000 (which the car will surely be worth!) in the 60th month. What interest rate is your cousin really going to pay? 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. (Points : 10)