3.04.2015

Loan Amortization Schedule Sample


Here's the Loan Amortization Schedule for a loan amounting to 800,000 pesos.
It is to be paid over a period of 20 years or 240 months
with a fixed monthly payment of 8,808.68.

This is only a sample table...to illustrate where your first monthly payments are going.

Notice that in the first months and years, the bigger portion of the fixed monthly payment of 8,808.68 pesos is used to pay INTEREST and only a small portion is applied to reduce the LOAN PRINCIPAL

Note also that the monthly payment for Fire Insurance and Mortgage Redemption Insurance (MRI) was not yet included in this monthly payment of 8,808.68.
Monthly MRI payment for this loan is around 330 pesos and monthly Fire Insurance payment is around 27 pesos.

For actual Pag-ibig home loans, use this Pag-ibig housing loan amortization calculator:

To know your outstanding housing loan balance, go to this Pag-ibig Fund web page
and then click "Housing Loan Payment  Verification."

Fixed Monthly Payment:  8,808.68 pesos

PAYMENTINTEREST      PRINCIPAL      REMAINING
MONTH PAYMENTPAYMENTBALANCE
1st Month8,000.00808.68799,191.31
2nd Month7,991.91816.77798,374.53
3rd Month7,983.74824.94797,549.58
4th Month7,975.49833.19796,716.38
5th Month7,967.16841.52795,874.85
6th Month7,958.74849.94795,024.90
7th Month7,950.24858.44794,166.45
8th Month7,941.66867.02793,299.42
9th Month7,932.99875.69792,423.72
10th Month7,924.23884.45791,539.26
11th Month7,915.39893.29790,645.96
12th Month7,906.45902.22789,743.73
13th Month7,897.43911.25788,832.47
14th Month7,888.32920.36787,912.10
15th Month7,879.12929.56786,982.53
16th Month7,869.82938.86786,043.66
17th Month7,860.43948.25785,095.40
18th Month7,850.95957.73784,137.66
19th Month7,841.37967.31783,170.34
20th Month7,831.70976.98782,193.35
21st Month7,821.93986.75781,206.59
22nd Month7,812.06996.62780,209.96
23rd Month7,802.091,006.58779,203.37
24th Month7,792.031,016.65778,186.71
25th Month7,781.861,026.82777,159.88
26th Month7,771.591,037.09776,122.78
27th Month7,761.221,047.46775,075.31
28th Month7,750.751,057.93774,017.37
29th Month7,740.171,068.51772,948.85
30th Month7,729.481,079.20771,869.64
31st Month7,718.691,089.99770,779.64
32nd Month7,707.791,100.89769,678.74
33rd Month7,696.781,111.90768,566.83
34th Month7,685.661,123.02767,443.80
35th Month7,674.431,134.25766,309.54
36th Month7,663.091,145.59765,163.94
37th Month7,651.631,157.04764,006.89
38th Month7,640.061,168.62762,838.26
39th Month7,628.381,180.30761,657.95
40th Month7,616.571,192.10760,465.84
41st Month7,604.651,204.03759,261.80
42nd Month7,592.611,216.07758,045.72
43rd Month7,580.451,228.23756,817.48
44th Month7,568.171,240.51755,576.96
45th Month7,555.761,252.91754,324.04
46th Month7,543.241,265.44753,058.59
47th Month7,530.581,278.10751,780.48
48th Month7,517.801,290.88750,489.59
49th Month7,504.891,303.79749,185.79
50th Month7,491.851,316.83747,868.95
51st Month7,478.681,329.99746,538.95
52nd Month7,465.381,343.29745,195.65
53rd Month7,451.951,356.73743,838.91
54th Month7,438.381,370.29742,468.61
55th Month7,424.681,384.00741,084.60
56th Month7,410.841,397.84739,686.75
57th Month7,396.861,411.82738,274.92
58th Month7,382.751,425.93736,848.98
59th Month7,368.481,440.19735,408.78
60th Month      7,354.081,454.60733,954.17



229th Month991.37           7,817.30             91,320.67
230th Month913.207,895.4883,425.18
231st Month834.257,974.4375,450.74
232nd Month754.508,054.1867,396.55
233rd Month673.968,134.7259,261.82
234th Month592.618,216.0751,045.74
235th Month510.458,298.2342,747.50
236th Month427.478,381.2134,366.28
237th Month343.668,465.0225,901.25
238th Month259.018,549.6717,351.57
239th Month173.518,635.178,716.39
Last Month          87.168,721.52-5.13
Share:

0 comments:

Post a Comment

Copyright © PAG-IBIG Philippines | Powered by Blogger Design by ronangelo | Blogger Theme by NewBloggerThemes.com