How can i solve the following problem using excel what are


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?

Request for Solution File

Ask an Expert for Answer!!
Financial Management: How can i solve the following problem using excel what are
Reference No:- TGS01236596

Expected delivery within 24 Hours