please weote the functions for the green parts and drag the rest

AutoSave OFF BE FRM Excel Assignment Modue 4 (Empty).xls W Home Insert Draw Page Layout Formulas Data Review View Tell me Times New Roman 12 ' Currency Paste BIU uv a . $ %, 8-98 D143 Xfx F G Loan Balance 0 A B C D E 121 Interest Rate 4% 122 Years After Original Maturity 12 123 124 125 13. Complete the amortization schedule below for a fixed rate, fully amortizing 126 mortgage loan for $300,000 at 5% annual interest for 15 years. 127 128 Loan Amount $300,000.00 129 Annual Interest Rate 5% 130 Periods Per Year 12 131 Number of Years 15 132 Monthly Payment $2,378.64 133 134 Amortization Schedule 135 Month Payment Interest Principal 136 0 0 137 138 2 139 3 140 4 141 142 6 7 144 8 145 9 146 10 147 11 148 12 13 150 14 151 15 16 FRM + 0- ano 143 149 152 Ready