show everything in excel with cell reference

1 As beginning from Poll 2016), Jame expects to borrow $10,000 per year in unsubsidized student loans. Asume all loan occur on Augustifonch of her four year in college Interest accrues at the rate of 4.9 from the time her dom is received, but one does not pay interest while school. This interest ride applies throughout the form of Jane' student loan deb Jaunie must begin repaying her loans on August 1, 2022: Ame her repayment term is 10 years, 1. What is the balance ou Sone's loan at the time she begins repayment? 1 What is Jane's monthly payment? c. If Jane winhes to pay off her loan in 5 years, what should she pay ench month? 2. Horace has a credit card with a balance of S12.000. The annual interest rate is 18%. The terms of the credit state that a minimum payment of of the outstanding balance must be paid each month, but no less than $35.00 must be paid each month 2. Horace las a credit card with a balace of 512.000. The mal interest rate is 18%. The terms of the credit state that a minimum payment of 3% of the outstanding balance must be paid each month, but no less than $35.00 must be paid each month Horace plans to stop ming the credit card and pay off the balance according to the terms of the credit a. How many years will it take to pay off the balance, assuming Horace only pays the minimum required payment? b. How long will it take to pay off the balance if Horace pays an extra $50.00 per month c. How much in addition to the required minimum payments must Horace pay each month if he wishes to pay off the balance is 5 years