Ch5LoanAmortization-SM

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

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

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

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

View Full Document
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
Ask a homework question - tutors are online