2. (2 points) In what month will the borrower begin paying more towards principal month than interest? 3. (2 points) What is the total amount of interest the borrower will pay over the life of this 30-year loan? 4. (2 points) Suppose the banker instead offers you the option of a 15-year loan at 3%. How much money will you save with this option? Hint: Interest of 30 year loan minus interest of 15 year loan. Problem #2 Ashley decides to go to the Nissan dealership to purchase a 2018 Altima. The cost of the car is $23,260.55. She puts down a $2,000 down payment, gets an additional $500 credit for being a recent college graduate, and finances the remainder of the cost at a 4.75% annual interest rate for 5 years. She will be making equal monthly payments on the car. Create an amortization table for this situation. The "Car loan problem" sheet in your Excel template should be used for this problem. Fill in the information given and use autofill to complete the amortization table, following the same procedure as in the example. 5. (3 points) Upload a copy of your completed Excel table to the dropbox on D2L. 6. (2 points) In what month will Ashley have paid off half of the principal? 7. (8 points) Suppose that, starting with her 25th payment, Ashley increases her payment amount to $450. To change this in your table, change cell D37 and all cells below it to "450". a. (3 points) Upload a copy of the updated Excel table to the dropbox on D2L. b. (2 points) In what month will Ashley finish paying off the car? c. (3 points) What should her final payment be in order to pay off the principal and the interest owed (it should be less than $450)? Problem #3 Ashley, being a recent college graduate, has also begun paying off her student loans. She has the following loans when she begins repayment: Set 1: $15,200, interest rate 4.45%, paid off over 10 years, monthly payments Set 2: 87,131, interest rate 6.23%, paid off over 10 years, monthly payments Use the "Student loans problem" worksheet for this question. Assume that she only makes the minimum payments to both loans (the monthly payment amounts are calculated using the same formula as in the last two problems). Complete both tables using the same procedure as in the previous problems. When finding the total interest and total payments, make sure to add amounts for BOTH loans. 8. (3 points) Upload this table to the Dropbox in D2L. 9. (2 points) How much total interest will Ashley pay over 10 years if she only makes minimum payments? 10. Ashley decides to pay $500 total to her student loans each month. She continues the minimum payment on the lower interest loan, and puts the rest of the $500 towards the higher interest loan until it's paid off. Then she puts all $500 towards the lower interest loan until it is paid off. (a) (3 points) Upload the updated table to the dropbox in D2L. (b) (2 points) How much total interest will Ashley pay in this scenario? (c) (2 points) How much does she save by increasing her payments in this way? PMT (1-(1+4)*). PV where PV is the starting amount of the account, or the principal of the loan . PMT is the payment that comes out of the account each period, or the payment towards the loan each period . r is the stated annual interest rate for the account, or the loan's stated annual interest rate . m is the number of times interest is compounded per year, or the number of payments per year t is the number of years until the account balance becomes $0, or the number of years to pay off the loan In the case of a loan, we probably know the principal, interest rate, number of payments per year, and number of years, but we do not know the payment amount. To find this, we rearrange to get PV) PMT 1 - (1+) mt Review Formulas View Insert Data Tell me Home Draw Page Layout X 11 v v 2 Wrap Text Calibri ' ' General v Paste $ % B V v Merge & Center Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. C6 x D E 1 Student loans problem 2 3 Loan Set 1 4 Total Loans 5 Annual Rate 6 No. of periods per year 7 Rate per interest period 8 Duration no. of periods) 9 Periodic Payment 10 11 12 Beginning Balance Interest Payment Amount to Principal Ending Balance 13 14 15 16 17 18 19 20 22 23 24 25 26 28 29 30 31 33 34 35 36 37 38 39 40 44 45 Instrictions Fyemple AutoSave LOFF Amortization Excel Ten ome Insert Draw Page Layout Formulas Data Review View Tell me X Calibri 11 ' == General Wrap Text Merge & Center Paste 3 B I U v DA $ -% 9 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 25 x fx A B D E Car loan problem 23260.55 2000 Total of all payments Total Interest Paid: Price Down Payment Principal Annual Interest Rate No. of periods per year Rate per interest period Duration (no. of periods) Periodic Payment 1 Beginning Balance Interest Payment Amount to Principal Ending Balance 3 4 5 6 7 8 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Amortization Excel Templat toSave OFF BES Insert Draw me Page Layout Formulas Data Review View Tell me = 11 ' 2 Wrap Text X IG Calibri General y ste B IVE Merge & Center $ % 9 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates x B c D E mortization Table Total of all payments Total Interest Paid: $178,744.29 $74,744.29 $74,744.29 rice Down Payment Principal Annual Interest Rate No. of periods per year Rate per interest period Duration no. of periods) Periodic Payment $130,000 $26,000 $104,000