Question

Good evening, everyone , may someone answer this engineering economics question on excel spreadsheet?

Some years ago, Penny purchased the car of her dreams for $25,000 by paying 20% down at purchase time and taking a $20,000, 5-year, 6% per year, compounded monthly loan with 60 monthly payments of $386.66 each. She is examining her loan situation and would like to have some specific information. Help her obtain the following:

a) ) Verification of the current monthly payment amount.

b) Total amount she will pay over the 5 years.

c) ) Total interest she will pay over the 5 years and the percentage this represents of the original loan amount of $20,000.

d) ) After she missed payment #36 at the very end of the third year, according to the loan agreement, the interest rate increased from 6% to 10% per year, compounded monthly. Based on the remaining principal immediately after the late payment, determine the new monthly payment. Verify that this increased amount is necessary to pay off the loan at the increased rate.

e) ) Penny is now in her fourth year, has paid the increased payment for 12 payments, and wants to get rid of this loan completely. She wishes to know the remaining principal amount when payment #48 is due. There is no penalty for early repayment of principal.

Answer 1

annys oan amount potcmyecs S/ tj @cn ( forr. a) vaiGra bon ơt the cuST ent monthly Payment 786.13 To calrulateKe payment alaan houe L is the loan value, c is the nteest a n is the ferm andl pis tha umen Gd atts9% APR Paid Monthly.tht Peio d int MonMy payment CP): 丈20,00c Co.oosao.osya/mofr] Mon thy Monthly pa&204 Total aount she oiti Pay la-be oo vey the otal arrount She bil 伞286,66 6o ay

c) Total intaest penn bil pay ti Total ntee peny ntage th's inteest »epm 그/1996( re ankage thi'c inte.ert xpnacants o the diginal loan is, 99% d) fotal amount paid up hootanent lote. Kemaining Pnirripal at payment ,9- /2 Ramaining reny rent o tal amount penry of y moth hf S ircludythe balan amount ar inteest able at an inenaedat

cta e) ramarofng principl a the Pajmant Kematnirg prineifal amount pentyhay to pry a Geth payment ninci Ramainig Phireiount penry ha