How can I solve the following problem using excel? What are the financial formulas that I can use? Crystal has a total of $35,108.02 in loans. Below is a breakdown of the total loan:
Subsidized Principal $8,343.25 at 3.4% interest rate
Subsidized Principal $2,802.96 at 3.86% interest rate
Subsidized Principal $3,855 at 5.6% interest rate
Unsubsidized Principal $5,608 at 5.84% interest rate
Unsubsidized Principal $12,714.84 at 6.8% interest rate
Accrued Interest $1,783.97.
How can Crystal pay this loan off in 6 years? 10 years?