i need help creating formulas for this

Home F136 Excel 133 134 135 136 137 138 139 140 141 AutoSave 142 143 144 145 146 147 148 149 150 151 Edit File Insert 126 127 Loan Amount 128 Annual Interest Rate 129 Periods Per Year 130 Number of Years 131 Monthly Payment 132 x fx A OFF FRM View Insert Format 885. Draw Page Layout + (300000-1122.44) B 122 123 124 13. Complete the amortization schedule below for a fixed rate, fully amortizing mortgage 125 loan for $300,000 at 5% annual interest for 15 years. $300,000.00 0% 12 15 $2,372.44 Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Formulas 15 16 45 FRM Excel Assig....xlsx Data Tools 0 Data Review D Help Window Amortization Schedule Payment Interest Principal 0 E $2,372.44 $1,250.00 $2,372.44 $1,250.00 $2,372.44 $1,250,00 $2,372.44 $1,250.00 $2,372.44 $1,250,00 $2,372.44 $1,250.00 $2,372.44 $1,250.00 $2,372.44 $1,250,00 $2,372.44 $1,250,00 $2,372.44 $1,250,00 $2,372.44 $1,250.00 $2,372.44 $1,250.00 $2,372.44 $1,250.00 $2,372.44 $1,250.00 $2,372.44 $1,250.00 $2,372.44 $1,250.00 Lan 10 0 FRM Excel Assignment Module 4 (c View Tell me F Loan Balance $300,000.00 FRM Excel Assig....xlsx $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) $1,122.44 (300000-1122.44) PLISS Tennan G H FRM Excel Assig