Scribd
Upload
58 views1 page

For Ammortilization Table Example

Uploaded by

Suneung Luncio
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
58 views1 page

For Ammortilization Table Example

Uploaded by

Suneung Luncio
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

AMMORTILIZATION TABLE FOR BAJAJ MAXIMA

AMMOUNT BORROWED 203,888 (Price-DP)


PERIODS 12
RATE 0.57% (6.8%/12)
PAYMENT ₱ 17,622.97 (=pmt,rate,Period,fv)
Annual rate 6%
Down payment 30,000
LCP(Price unit) 230,888
PERIODS LOAN PMT INTEREST PRINCIPAL BALANCE
1 ₱ 203,888.00 ₱ 17,622.97 ₱ 1,155.37 ₱ 16,467.60 ₱ 187,420.40
2 ₱ 187,420.40 ₱ 17,622.97 ₱ 1,062.05 ₱ 16,560.92 ₱ 170,859.48
3 ₱ 170,859.48 ₱ 17,622.97 ₱ 968.20 ₱ 16,654.77 ₱ 154,204.71
4 ₱ 154,204.71 ₱ 17,622.97 ₱ 873.83 ₱ 16,749.14 ₱ 137,455.57
5 ₱ 137,455.57 ₱ 17,622.97 ₱ 778.91 ₱ 16,844.06 ₱ 120,611.51
6 ₱ 120,611.51 ₱ 17,622.97 ₱ 683.47 ₱ 16,939.50 ₱ 103,672.01
7 ₱ 103,672.01 ₱ 17,622.97 ₱ 587.47 ₱ 17,035.50 ₱ 86,636.51
8 ₱ 86,636.51 ₱ 17,622.97 ₱ 490.94 ₱ 17,132.03 ₱ 69,504.48
9 ₱ 69,504.48 ₱ 17,622.97 ₱ 393.86 ₱ 17,229.11 ₱ 52,275.37
10 ₱ 52,275.37 ₱ 17,622.97 ₱ 296.23 ₱ 17,326.74 ₱ 34,948.63
11 ₱ 34,948.63 ₱ 17,622.97 ₱ 198.04 ₱ 17,424.93 ₱ 17,523.70
12 ₱ 17,523.70 ₱ 17,623.00 ₱ 99.30 ₱ 17,523.70 ₱ 0.00

You might also like