amortization schedule for bond and loan

amortization schedule for bond and loan - Amortization...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Amortization Schedule for revenue bond Amortization Schedule for $4 mil ion loan from First National Bond rate $1,700,000 Bond rate $5,000,000 Term in Years (240 months) 20 years Term in Year 20 years (240 months) Annual interest rate 6.25% Annual Interest rate 7% Payment 12,425.78 Total Payments (monthly) Payment $38,765.95 Bond 12,425.78 Month 1 primary bond Loan 38,765.95 Month 1 primary bond Payment (PMT) Total 40,191.73 Payment (PMT) Payment-Interest Payment-Interest Balance x(Annual interest rate/number of months in a year) Balance x(Annual interest rate/number of months in a year) principal principal interest interest payment payment Months 2-240 Months 2-240 Prior Months Balance-Principal Prior Months Balance-Principal Payment (PMT) Payment (PMT) Payment-Interest Payment-Interest Balance x (annual interest rate/ number of months in a year) Balance x (annual interest rate/ number of months in a year) principal principal total interest from prior month + interest from cur ent month total interest from prior month + interest from cur ent month total payments from prior month + payment from cur ent month total payments from prior month + payment from cur ent month (Monthly) (Monthly) Payment Amount Principal Interest Balance Payment Amount Principal Interest Balance 1 $12,425.78 $3,571.61 $8,854.17 $1,696,428.39 1 $38,764.95 $9,598.28 $29,166.67 $4,990,401.72 2 $12,425.78 $3,590.21 $8,835.56 $1,692,838.17 2 $38,764.95 $9,654.27 $29,110.68 $4,980,747.45 3 $12,425.78 $3,608.91 $8,816.87 $1,689,229.26 3 $38,764.95 $9,710.59 $29,054.36 $4,971,036.86 4 $12,425.78 $3,627.71 $8,798.07 $1,685,601.55 4 $38,764.95 $9,767.23 $28,997.72 $4,961,269.63 5 $12,425.78 $3,646.60 $8,779.17 $1,681,954.94 5 $38,764.95 $9,824.21 $28,940.74 $4,951,445.42 6 $12,425.78 $3,665.60 $8,760.18 $1,678,289.35 6 $38,764.95 $9,881.52 $28,883.43 $4,941,563.91 7 $12,425.78 $3,684.69 $8,741.09 $1,674,604.66 7 $38,764.95 $9,939.16 $28,825.79 $4,931,624.75 8 $12,425.78 $3,703.88 $8,721.90 $1,670,900.78 8 $38,764.95 $9,997.14 $28,767.81 $4,921,627.62 9 $12,425.78 $3,723.17 $8,702.61 $1,667,177.61 9 $38,764.95 $10,055.45 $28,709.49 $4,911,572.16 10 $12,425.78 $3,742.56 $8,683.22 $1,663,435.04 10 $38,764.95 $10,114.11 $28,650.84 $4,901,458.05 11 $12,425.78 $3,762.06 $8,663.72 $1,659,672.99 11 $38,764.95 $10,173.11 $28,591.84 $4,891,284.95 12 $12,425.78 $3,781.65 $8,644.13 $1,655,891.34 12 $38,764.95 $10,232.45 $28,532.50 $4,881,052.50 13 $12,425.78 $3,801.35 $8,624.43 $1,652,089.99 13 $38,764.95 $10,292.14 $28,472.81 $4,870,760.35 14 $12,425.78 $3,821.14 $8,604.64 $1,648,268.85 14 $38,764.95 $10,352.18 $28,412.77 $4,860,408.18 15 $12,425.78 $3,841.05 $8,584.73 $1,644,427.80 15 $38,764.95 $10,412.57 $28,352.38 $4,849,995.61 16 $12,425.78 $3,861.05 $8,564.73 $1,640,566.75 16 $38,764.95 $10,473.31 $28,291.64 $4,839,522.30 17 $12,425.78 $3,881.16 $8,544.62 $1,636,685.59 17 $38,764.95 $10,534.40 $28,230.55 $4,828,987.90 18 $12,425.78 $3,901.38 $8,524.40 $1,632,784.22 18 $38,764.95
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/25/2012 for the course SPM 6106 taught by Professor Trevorbopp during the Fall '11 term at University of Florida.

Ask a homework question - tutors are online