Tara-Anderson-week 1 excel assignment

Tara-Anderson-week 1 excel assignment - TaraAnderson 1242...

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

View Full Document Right Arrow Icon
Tara Anderson 12-42 1) Amortization Schedule No. Due Date Payment Interest Principal Balance 800,000.00 1 12/31/08 211,037.98 80,000.00 131,037.98 668,962.02 2 12/31/09 211,037.98 66,896.20 144,141.78 524,820.24 3 12/31/10 211,037.98 52,482.02 158,555.96 366,264.28 4 12/31/11 211,037.98 36,626.43 174,411.55 191,852.73 5 12/31/12 211,038.00 19,185.27 191,852.73 0.00 2) Year Interest Principal 12/31/08 211,038.00 64,000.00 64,000.00 147,038.00 147,038.00 12/31/09 211,038.00 52,236.96 116,236.96 158,801.04 305,839.04 12/31/10 211,038.00 39,532.88 155,769.84 171,505.12 477,344.16 12/31/11 211,038.00 25,812.47 181,582.31 185,225.53 662,569.69 12/31/12 148,424.73 10,994.42 192,576.73 137,430.31 800,000.00 3) The two methods are quite different but the main reason for the  difference here is the interest. Depreciation does not have the interest as a loan will have and there for the amount you pay will always be a lot less.  Payment Amount Cumulative Interest Principal Paid
Background image of page 1

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

View Full DocumentRight Arrow Icon
Balance 800,000.00 652,962.00 494,160.96 322,655.84 137,430.31 0.00
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/29/2011 for the course EC 2011 taught by Professor Johnson during the Spring '11 term at FIT.

Page1 / 7

Tara-Anderson-week 1 excel assignment - TaraAnderson 1242...

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

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