REPAYING DEBT

COMPLETE EXCEL SPREAD SHEETs (4) for 4 different LOAN PAYMENT TYPES

FIND THE PAYMENT type that MINIMIZES total interest

Use Excel Cash Flow Diagram if you can ( See Videos)

Bonus: You can create your own payment plan to see if you can further minimize

Total Interest - Constrains - Don't have the funds to pay the loan upfront

Third year you have refinancing option came up 2.5% but cost 250$

Try to implement it (Hint : Cost of Refinance increase your balance)

Down here is the example. answer me using like this example down but don't use the same example.please

I need answer soon please

I gave you the example by using that give me some example by own using excel

(51,252.28) Pets to pay SK overens Repaying a Debt Plan #3: Constant Payment Repay of a loan of $5000 in 5 yrs at interest rate of 8% Plan #3: Constant annual payments PMT(8%,5,5000-1252 Balance at the Balance at Beginning the end of Interest Principal Total Y Interest year Payment Payment Payment 1 $5,000.00 $400.00 $5,400.00 $400.00 5852.28 $1,252.28 2 54.147.72 $331.82 $4,479.54 $39182 $920.46 $1.252 28 3 $3.227.25 $258.18 $3.485.43 $258.18 $994.10 $1,252.28 4 $2.233.15 $178.65 $2.411.80 $178.65 $1.073.63 $1.252 28 5 $1,159.52 $92.76 $1.252.28 $92.78 51,159.52 $1,252 28 Subtotal $1,261.41 $5,000.00 $6,261.41 P F of year 24 (51,252.28) Pets to pay SK overens Repaying a Debt Plan #3: Constant Payment Repay of a loan of $5000 in 5 yrs at interest rate of 8% Plan #3: Constant annual payments PMT(8%,5,5000-1252 Balance at the Balance at Beginning the end of Interest Principal Total Y Interest year Payment Payment Payment 1 $5,000.00 $400.00 $5,400.00 $400.00 5852.28 $1,252.28 2 54.147.72 $331.82 $4,479.54 $39182 $920.46 $1.252 28 3 $3.227.25 $258.18 $3.485.43 $258.18 $994.10 $1,252.28 4 $2.233.15 $178.65 $2.411.80 $178.65 $1.073.63 $1.252 28 5 $1,159.52 $92.76 $1.252.28 $92.78 51,159.52 $1,252 28 Subtotal $1,261.41 $5,000.00 $6,261.41 P F of year 24