Hi,

I need help with these questions, I keep getting the wrong answer.

please provide an excel function for the answer hint(the answer is on cell highlight with red)

125 13. Complete the amortization schedule below for a fixed rate, fully amortizing mortgage 126 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,372.38 133 134 Amortization Schedule 135 Month Payment Interest Principal Loan Balance 136 0 0 0 $300,000.00 137 1 $2,372.38 138 2 139 3 140 4 141 5 142 6 143 7 144 8 145 9 146 10 147 11 148 12 149 13 150 14 151 15 152 16 153 17 154 18 155 19 156 20 157 21 158 22 159 23 160 24 161 25 162 26