Answer:
Mortgage Payable Table is prepared in an MS Excel file which is attached with this answer, please find it
Explanation:
The loan which is received by a person for purchase of real estate property or alternatively existing property owner to raise fund from the property. The mortgage are paid with interest over a specific period of time in installment of monthly quarterly semiannually or yearly.
Installment includes both principal payment and Interest Payment.
In this question The first payment on December 31, 2018 included
Total Payment = $37,092
Interest Payment = 385,000 x 5% = $19,250
Principal Payment = $37,092 - $19,250 = $17,842
