Calculate Principal and interest paid using traditional formulas NOT built in Excel formulas.

BC Mortgage Calculation Table 4 House Price 5 Down Payment 6 Amount Borrowed $400,000.00 $35,000.00 $365,000.00 Terms of Loan 9.00% 15 180 (Months) Interest Rate Years Payment Periods 7 8 Monthly Payments 9 Total Amount Paid $3,702.07 $666,373.15 10 12 Breakdown of Payment: 13 Payment Period 14 Principal Paid 15 Interest Paid