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

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

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