C&P 8-3 Personal Auto Loan

C&P 8-3 Personal Auto Loan - 1400 0.11 5 Scenario...

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

View Full Document Right Arrow Icon
Loan Payment Calculator Interest Rate Schedule Car Honda Accord Monthly Payment Total Cost Total Interest Price $19,875.00 Interest $404.00 $25,639.91 $5,764.91 Down payment $1,400.00 6.00% 357.17 22,830.41 5,764.91 Interest rate 11.25% 6.50% 361.48 23,089.08 5,764.91 Years 5 7.00% 365.83 23,349.63 5,764.91 Loan amount $18,475.00 7.50% 370.20 23,612.07 5,764.91 Monthly payment $404.00 8.00% 374.61 23,876.38 5,764.91 8.50% 379.04 24,142.57 5,764.91 9.00% 383.51 24,410.64 5,764.91 9.50% 388.01 24,680.56 5,764.91 10.00% 392.54 24,952.35 5,764.91 10.50% 397.10 25,225.99 5,764.91 11.00% 401.69 25,501.48 5,764.91 11.50% 406.31 25,778.81 5,764.91
Background image of page 1

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

View Full Document Right Arrow Icon
Car 1 Page 2 Toyota Celica 22500 1000 0.1 5
Background image of page 2
Car 2 Page 3 Ford Taurus 23750 900 0.08 4
Background image of page 3

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

View Full Document Right Arrow Icon
Car 3 Page 4 Honda Accord 19875
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1400 0.11 5 Scenario Summary Current Values: Car 1 Car 2 Car 3 Changing Cells: Item Honda Accord Toyota Celica Ford Taurus Honda Accord Price $19,875.00 $22,500.00 $23,750.00 $19,875.00 Down_Payment $1,400.00 $1,000.00 $900.00 $1,400.00 Interest_Rate 11.25% 9.75% 8.25% 11.25% Years 5 5 4 5 Result Cells: Loan_Amount $18,475.00 $21,500.00 $22,850.00 $18,475.00 Monthly_Payment $404.00 $454.17 $560.52 $404.00 $G$5 $25,639.91 $28,250.27 $27,804.99 $25,639.91 $H$5 $5,764.91 $5,750.27 $4,054.99 $5,764.91 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray....
View Full Document

{[ snackBarMessage ]}

Page1 / 5

C&P 8-3 Personal Auto Loan - 1400 0.11 5 Scenario...

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

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