please include functions used to solve.

PART 2 TVM Problems Enter answers here >>>>>> a 9. Amortization Table. You wish to buy a $40,000 car. The bank can finance you with b Show Table to the right--> Enter answers here TU. TOU JUST purchaSCU TUU VOU TOUSO and gave a 20% down payment. For the remaining portion you obtained a 30-year naala b C recently switched to a new job. You have $70,000 in the retirement plan from your 12. You have become a financial advisor and a new client has received a trust fund Enter answers here >>>>>> Enter answer here >>>>>> 749. Amortization Table. You wish to buy a $60.000 car. The bank can finnce you with a 3.year loan atau percent APR. If you make a $7.000 down payment on the 15 purchase. A) What are the monthly payments on your loan? B) How much will you pay in interest each year? C) How much of your second payment goes to the principal 16 Show the amortization table (use monthly payments). 17 18 49 20 21 23 4 10. You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion, you obtained a 30-year mortgage at a 6% interest rate. 25 A) What are the monthly payments on this mortgage? If the house appreciates at a 3 percentually, what will be the value of the house in ten years?) In ten years, how 6 much equity will you have on this home? 2 11. You have fumed 35 years old and have recently switched to a new job. You have $70,000 in the retirement plan from your former employer. You will roll that money into the retirement plan of the new employer. In addition, you will contribute $8,000 each year into your new employer's plan. If the rolled-over money and the new contributions both earn an 8 percent retum, how much money would you expect to have when you retire in 28 years? How much can you afford to withdraw monthly for the subsequent 25 years after you retire? That would be for the age of 63 until 88 years old, BE 0 2 312. You have become a financial advisor and a new client has received a trust find currently worth $500.000. However, she will not have access to the find until she turns 4 60 years old, which is in 20 years. At that time she can withdraw $10,000 per month. If the trust fund is invested at a 6 percent rate, compounded monthly, how many months 5 will last your clicut once he starts to withdraw the money