Ch 05 Loan Amortization Finished

Ch 05 Loan Amortization Finished - 7.00% $21,000 $20,778...

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

View Full Document Right Arrow Icon
Basics and Sensitivity Analysis Inputs Present value $300,000 30 Interest rate / year 8.00% 8 Number of years 30 30 Outputs Year 1 2 3 4 5 6 7 8 9 Beg. Principal Balance $300,000 $297,352 $294,492 $291,403 $288,067 $284,464 $280,573 $276,370 $271,832 Payment $26,648 $26,648 $26,648 $26,648 $26,648 $26,648 $26,648 $26,648 $26,648 Interest Component $24,000 $23,788 $23,559 $23,312 $23,045 $22,757 $22,446 $22,110 $21,747 Principal Component $2,648 $2,860 $3,089 $3,336 $3,603 $3,891 $4,202 $4,539 $4,902 Data Table: Sensitivity of the Interest Component to the Interest Rate / Year Input Values for Output Formula: Interest Component Interest rate / year $24,000 $23,788 $23,559 $23,312 $23,045 $22,757 $22,446 $22,110 $21,747
Background image of page 1

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

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

Unformatted text preview: 7.00% $21,000 $20,778 $20,540 $20,285 8.00% $24,000 $23,788 $23,559 $23,312 L OAN A MORTIZATION 5 10 15 20 25 30 $0 $10,000 $20,000 $30,000 $40,000 $50,000 Loan Amortization Payment Interest Com-ponent Principal Component Year Data Table: Sensitivity of the Principal Component to the Interest Rate / Year Input Values for Output Formula: Principal Component Interest rate / year $2,648 $2,860 $3,089 $3,336 $3,603 $3,891 $4,202 $4,539 $4,902 7.00% $3,176 $3,398 $3,636 $3,891 8.00% $2,648 $2,860 $3,089 $3,336 5 10 15 20 25 30 $0 $5,000 $10,000 $15,000 $20,000 $25,000 Principal And Interest Payments Over Time Time (Years) Principal And Interest Components...
View Full Document

This note was uploaded on 09/08/2010 for the course BUS 170 at San Jose State.

Page1 / 2

Ch 05 Loan Amortization Finished - 7.00% $21,000 $20,778...

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

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