need help with a-e

a better picture

Atlas 3.0 cels Bask $35,000.00 1.06 Financial Stress and forbearance 2 years into an t month pouse buton interest repayment made Amount Needed Fee Percent Fee Loan Amount Analiseret Rate Tom Years of Payment pement 6.20W 10 Balance at 2 years 6 months interest New Balance Math remaining 30 11 12 Total cost of the 3.1 Calculate the loan fee, amount, and term a. After analyzing your situation, you conclude you have a financial need of $35,000 (C3). b. FSA will charge you a 1.06% fee (C4) before turning your case over to the financial institution servicing Periode interest Balance Rection Loan Balance 14 15 36 Paid after Pause New Count of the loan D 1 2 3 Added Cost 18 19 1 your loan. ? 3 9 10 12 13 14 c. In cell C5) calculate the amount of the fee. d. In cell C6) calculate the amount of the total loan amount required. e. In C9 calculate the number of monthly payments you will make. 15 16 17 18 19 20 Statistical Functions Student Loans 32 Calculate your monthly D Atlas 3.0 cells Am Needed Bank Loan 535.000.00 LOS Financial Stress and forbearance 2 Years into loan house button Interest actress payment made fee Loan Amount Annual rest Rate Terme of many Payments Payment 62 Banca Mt 2 years 6 months interest 10 10 11 Month remaining New Payment Total cost of the Loan Periode Interest Balance Reduction Lowlane Paid before pause Paid after Pause New Cost of the loan 2 15 16 17 11 19 20 Ad Cat 4 5 6 3. Calculate the loan fee, amount, and term. a. After analyzing your situation, you conclude you have a financial need of $35.000 (C3) b. FSA will charge you a 1.06% fee (C4) before turning your case over to the financial institution servicing your loan c. In cell C5) calculate the amount of the fee. d. In cell C6) calculate the amount of the total loan amount required e. In C9 calculate the number of monthly payments you will make 7 22 21 24 25 27 28 29 39 10 11 12 12 14 15 16 18 19 20 21 Formulas Statistical functions Student Loans 32 Calculate your monthly Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF BESU- Book5 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) V 12 ' Currency Paste BIEB $ % ) 8 og HII HI v 117 B D F G H Basic Loan $35,000.00 1.06% Financial Stress and Forbearance 2 Years into loan hit 6 month pause button Interest accrues - no payment made Amount Needed Fee Percent Fee Loan Amount Annual Interest Rate Term-Years of monthly Payments Payment 6.20% 10 Balance at 2 years 6 months Interest New Balance Months remaining New Payment 96 Total Cost of the Loan Periodi Interest Balance Reduction Loan Balance Paid before pause Paid after Pause New Cost of the Loan 0 Added Cost 1 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Formulas Statistical Functions Student Loans + Ready C eting Insert v Documents Ou 8 me Delete v Editing Ideas Sensitivity Atlas 3.0 Format v K L M Images Atlas 3.0 cells. i PDF Docume 3.1 Calculate the loan fee, amount, and term. a. After analyzing your situation, you conclude you have a financial need of $35,000 (C3). b. FSA will charge you a 1.06% fee ( C4)) before turning your case over to the financial institution servicing Screensha ses 141 your loan. c. In cell C5) calculate the amount of the fee. d. In cell C6 calculate the amount of the total loan amount required. e. In C9 calculate the number of monthly payments you will make. GRK 142 - ske outlines old docume (3) 3.2 Calculate your monthly + 100%