Ch5LoanAmortization-SM

Ch5LoanAmortization-SM - Input Values for Output Formula:...

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 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
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: Input Values for Output Formula: Interest Component Interest rate / year 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 5 10 15 20 25 30 5000 10000 15000 20000 25000 Principal And Interest Payments Over Time Time (Years) Principal And Interest Components...
View Full Document

Page1 / 2

Ch5LoanAmortization-SM - Input Values for Output Formula:...

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