I am looking for an excel template to calculate these loan payoff. 2,750 at 3.4%

Question

I am looking for an excel template to calculate these loan payoff.

2,750 at 3.4% interest rate

1000 at 4.5% interest rate

4500 at 4.5% interest rate

5506.75 at 6.8% interest rate

2741.39 at 5.6% interest rate

1166 at 6.8% interest rate

2263.90 at 6.8% interest rate

1619.46 at 6.8% interest rate

I want to pay them off in five years. If I start paying in january, I think I can do $200 a month. I need to know how much interest I would have accumulated in the five years. I know I can use excel's goal seek but I am not 100% sure how to use all the functions."

Explanation / Answer

if u want to pay them off in 5 years, $200 is not going to be enough. If you just wanna pay the interest of $6053 of all the above then you can pay them in around 2yrs and 5 months. but if u wanna pay the total amount of $27400(approx)(included interest) then u will need around 11 years and 5 months if u can make around $200 a month

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.