loan -amort - 1 50,000-4,000-5,000-9,000 2...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
5,000.00 4.00 0.08 Year 1.00 5,000.00 -400.00 -1,109.60 2.00 3,890.40 -311.23 -1,198.37 3.00 2,692.02 -215.36 -1,294.24 4.00 1,397.78 -111.82 -1,397.78 Totals -1,038.42 -5,000.00 Remarks: -1,509.60=PMT(0.08,4,5000,0, -1,109.60=PPMT(0.08,A4,4,50 0.08=RATE(4,-1509.6,500 4.00=NPER(0.08,-1509.6, Loan Number Interest Beginning Balance Interest Payment Principal Payment
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
-1,509.60 3,890.40 -1,509.60 2,692.02 -1,509.60 1,397.78 -1,509.60 0.00 -6,038.42 ,0) 000,0,0) 00,0,0,0.1) ,5000,0,0) Total Payment Ending Balance
Background image of page 2
50,000.00 10.00 0.08 Year
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 50,000-4,000-5,000-9,000 2 45,000-3,600-5,000-8,600 3 40,000-3,200-5,000-8,200 4 35,000-2,800-5,000-7,800 5 30,000-2,400-5,000-7,400 6 25,000-2,000-5,000-7,000 7 20,000-1,600-5,000-6,600 8 15,000-1,200-5,000-6,200 9 10,000-800-5,000-5,800 10 5,000-400-5,000-5,400 Loan amount Number of period Interest rate Beginning Balance Interest Payment Principal Payment Total Payment 45,000 40,000 35,000 30,000 25,000 20,000 15,000 10,000 5,000 Ending Balance...
View Full Document

{[ snackBarMessage ]}

Page1 / 4

loan -amort - 1 50,000-4,000-5,000-9,000 2...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online