kdr18702PMT Fall 2007

kdr18702PMT Fall 2007 - Static & Dynamic PMT Worksheets...

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

View Full Document Right Arrow Icon
5/11/2009 14:33 by Krystal Raphael
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
  Target Used Car Year Make Model KBB Trade-In Value 1998 GMC Suburban $7,020.00 Target New Car Year Make Model MSRP 2008 $14,545.00 Hyundai  Accent GLS
Background image of page 3

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

View Full DocumentRight Arrow Icon
Limits =<$7500 Limits $12,500 to $35,500
Background image of page 4
 Static Monthly Payment Table  PMT Function Inputs Item Inputs, Constants & Calculations Interest Rate of Loan [%] 2.000% Years For Loan [2,3,4,5,6] 2 Total Loan Payments 24 New Car Cost $14,545.00 Sales Tax $1,199.96 Trade-In Car $7,020.00 $0.00 Total Amount Borrowed $8,724.96 Future Value of Loan $0.00 Type of Loan 0 PMT ($371.16) Total Cost ($8,907.89) Interest ($182.93) DMV Registration Fee $159.00 Ca $ h
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Explaination Rate $8,724.96 PV N of Years $- FV [0] Nper 0.00 Type [0,1] KBB [+] L.A. 8.25% Ventura 7.25% [+] Trade-In [-] Interest Extra Cash Down [-] Years Months 2.00% 2.50% 3.00% PV 2 24 ($371.16) ($373.08) ($375.01) FV [0] 3 36 ($249.91) ($251.81) ($253.73) Type [0,1] 4 48 ($189.29) ($191.20) ($193.12) Monthly Payment [-] 5 60 ($152.93) ($154.85) ($156.78) Monthly Payment times Line 6 6 72 ($128.70) ($130.62) ($132.56) Interest Isolated From Loan 7 84 ($111.40) ($113.33) ($115.29) Years Months 2 24 ($8,907.89) ($8,953.99) ($9,000.23) 3 36 ($8,996.60) ($9,065.32) ($9,134.37) 4 48 ($9,085.88) ($9,177.56) ($9,269.82) 5 60 ($9,175.74) ($9,290.70) ($9,406.57) 6 72 ($9,266.19) ($9,404.76) ($9,544.63) 7 84 ($9,357.21) ($9,519.71) ($9,683.99) Interest Isolated from the Total Loan Years Months Total Cost of the Loans
Background image of page 7

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

View Full DocumentRight Arrow Icon
2 24 $(182.93) $(229.03) $(275.26) 3 36 $(271.63) $(340.36) $(409.41) 4 48 $(360.92) $(452.60) $(544.85) 5 60 $(450.78) $(565.74) $(681.61) 6 72 $(541.23) $(679.79) $(819.66) 7 84 $(632.25) $(794.75) $(959.02) Daily Cost of Loan Years Months 2 24 $(12.20) $(12.27) $(12.33) 3 36 $(8.22) $(8.28) $(8.34) 4 48 $(6.22) $(6.29) $(6.35) 5 60 $(5.03) $(5.09) $(5.15) 6 72 $(4.23) $(4.29) $(4.36) 7 84 $(3.66) $(3.73) $(3.79) Cost to Operate Estimated Mileage 12,000 IRS Write-off $(0.55) Est Cost $(6,600.00) Daily Cost $(18.08) Years Months 2 24 $(30.28) $(30.35) $(30.41) 3 36 $(26.30) $(26.36) $(26.42) 4 48 $(24.31) $(24.37) $(24.43) 5 60 $(23.11) $(23.17) $(23.24) 6 72 $(22.31) $(22.38) $(22.44) 7 84 $(21.74) $(21.81) $(21.87)
Background image of page 8
3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% ($376.94) ($378.88) ($380.83) ($382.78) ($384.73) ($386.70) ($388.66) ($255.66) ($257.60) ($259.54) ($261.49) ($263.46) ($265.43) ($267.41) ($195.06) ($197.00) ($198.96) ($200.93) ($202.91) ($204.91) ($206.91) ($158.72) ($160.68) ($162.66) ($164.65) ($166.66) ($168.68) ($170.71) ($134.52) ($136.50) ($138.50) ($140.51) ($142.55) ($144.60) ($146.67) ($117.26) ($119.26) ($121.28) ($123.32) ($125.38) ($127.46) ($129.56) ($9,046.61) ($9,093.14) ($9,139.81) ($9,186.63) ($9,233.59) ($9,280.70) ($9,327.94) ($9,203.74) ($9,273.44) ($9,343.47) ($9,413.82) ($9,484.49) ($9,555.49) ($9,626.81) ($9,362.65) ($9,456.07) ($9,550.06) ($9,644.63) ($9,739.77) ($9,835.49) ($9,931.78) ($9,523.34) ($9,641.01)
Background image of page 9

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

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

kdr18702PMT Fall 2007 - Static &amp; Dynamic PMT Worksheets...

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

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