Mortgage payable is the liability of business when a business takes the loan purchases or construction of long term assets by giving his other owned assets as security. Businessman has to pay the principle plus interest on the mortgage. Both are the part of mortgage payable amount.

Following are the simple steps of calculating the mortgage payable amount

1. Calculate the Total Mortgage Payable

First calculate the total amount of mortgage payable. It will show your beginning balance sheet or find from mortgage agreement document. For example it is \$ 1,00,000

2. Calculate First Month Interest and Principle Payament

Read the terms and conditions. For example rate of interest may be 12% per year on the balance mortgage payable. (But, in your case it may be fix or with changing rate per year. So, mortgage payable amount will be different in your case). It means per year interest payable is \$ 12,000. Per month interest payable is \$ 1000. Now, per month repayment installment. For example, it may be \$ 1500. Now, deduct per month interest from this. So, first payment of principle of mortgage is \$ 500 and interest payment is \$ 1000.

3. Calculate the Balance Amount of Principle

Now, deduct first month paid principle from total amount of payable principle of mortgage. In our case, we had total mortgage principle is \$ 1,00,000. But, we have paid first month small part of this principle. So, we will deduct this. \$ 1,00,000 - \$ 500 = Now, we have \$ 99500 as balance of mortgage payable. Now, calculate the interest on it for one year. If we calculate interest will be \$ 11940 annual. Per month interest will be \$ 995 and second  month's mortgage payment will be calculate by deducting \$995 from \$ 1500 and it will be \$ 505. Now, above steps will be repeated for calculating mortgage payable in accounting which you can calculate use of ms excel.

For calculating monthly installment for repayment of mortgage+ interest, you can use following formula.

P = iA / [1 − (1+i)^-N]

References : .

## \$type=three\$a=hide\$cm=hide\$s=hide\$show=/2019/06/10-steps-to-become-better-investor.html\$l=hide

Name

false
ltr
item
Accounting Education: How to Calculate Mortgage Payable in Accounting
How to Calculate Mortgage Payable in Accounting
http://2.bp.blogspot.com/-9U1_g7LOKG4/UuNPbcuK3aI/AAAAAAAAMrY/IQN6pvkJlUQ/s1600/mortgage+payable.PNG
http://2.bp.blogspot.com/-9U1_g7LOKG4/UuNPbcuK3aI/AAAAAAAAMrY/IQN6pvkJlUQ/s72-c/mortgage+payable.PNG
Accounting Education
https://www.svtuition.org/2014/01/how-to-calculate-mortgage-payable-in.html
https://www.svtuition.org/
http://www.svtuition.org/
http://www.svtuition.org/2014/01/how-to-calculate-mortgage-payable-in.html
true
2410664366776677676
UTF-8