2010-07-12_064940_Jptse_-_Amort

2010-07-12_064940_Jptse_-_Amort - Ans a: Monthly Income Car...

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

View Full Document Right Arrow Icon
Ans a: Monthly Income 4000 Car payments 400 Mortgage payment 1120 Asset Price Loan amount Interest rate Term in month Car 40000.00 36000 6% 60 Home 250000.00 242500 4.50% 360 Amortization for Car Loan Affordable Should be PMT 400.00 $695.98 Month Opening balance Interest PMT Principal Closing Balance 1 $36,000 180.00 $400.00 $220.00 $35,780.00 2 $35,780.00 178.90 $400.00 $221.10 $35,558.90 3 $35,558.90 177.79 $400.00 $222.21 $35,336.69 4 $35,336.69 176.68 $400.00 $223.32 $35,113.38 5 $35,113.38 175.57 $400.00 $224.43 $34,888.94 6 $34,888.94 174.44 $400.00 $225.56 $34,663.39 7 $34,663.39 173.32 $400.00 $226.68 $34,436.71 8 $34,436.71 172.18 $400.00 $227.82 $34,208.89 9 $34,208.89 171.04 $400.00 $228.96 $33,979.93 10 $33,979.93 169.90 $400.00 $230.10 $33,749.83 11 $33,749.83 168.75 $400.00 $231.25 $33,518.58 12 $33,518.58 167.59 $400.00 $232.41 $33,286.18 13 $33,286.18 166.43 $400.00 $233.57 $33,052.61 14 $33,052.61 165.26 $400.00 $234.74 $32,817.87 15 $32,817.87 164.09 $400.00 $235.91 $32,581.96 16 $32,581.96 162.91 $400.00 $237.09 $32,344.87 17 $32,344.87 161.72 $400.00 $238.28 $32,106.59 18 $32,106.59 160.53 $400.00 $239.47 $31,867.13 19 $31,867.13 159.34 $400.00 $240.66 $31,626.46 20 $31,626.46 158.13 $400.00 $241.87 $31,384.59 21 $31,384.59 156.92 $400.00 $243.08 $31,141.52 22 $31,141.52 155.71 $400.00 $244.29 $30,897.23 23 $30,897.23 154.49 $400.00 $245.51 $30,651.71 24 $30,651.71 153.26 $400.00 $246.74 $30,404.97 25 $30,404.97 152.02 $400.00 $247.98 $30,156.99 26 $30,156.99 150.78 $400.00 $249.22 $29,907.78 27 $29,907.78 149.54 $400.00 $250.46 $29,657.32 28 $29,657.32 148.29 $400.00 $251.71 $29,405.61 29 $29,405.61 147.03 $400.00 $252.97 $29,152.63 30 $29,152.63 145.76 $400.00 $254.24 $28,898.40 31 $28,898.40 144.49 $400.00 $255.51 $28,642.89 32 $28,642.89 143.21 $400.00 $256.79 $28,386.10 33 $28,386.10 141.93 $400.00 $258.07 $28,128.03 34 $28,128.03 140.64 $400.00 $259.36 $27,868.67 35 $27,868.67 139.34 $400.00 $260.66 $27,608.02
Background image of page 1

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

View Full DocumentRight Arrow Icon
36 $27,608.02 138.04 $400.00 $261.96 $27,346.06 37 $27,346.06 136.73 $400.00 $263.27 $27,082.79 38 $27,082.79 135.41 $400.00 $264.59 $26,818.20 39 $26,818.20 134.09 $400.00 $265.91 $26,552.29 40 $26,552.29 132.76 $400.00 $267.24 $26,285.05 41 $26,285.05 131.43 $400.00 $268.57 $26,016.48 42 $26,016.48 130.08 $400.00 $269.92 $25,746.56 43 $25,746.56 128.73 $400.00 $271.27 $25,475.29 44 $25,475.29 127.38 $400.00 $272.62 $25,202.67 45 $25,202.67 126.01 $400.00 $273.99 $24,928.68 46 $24,928.68 124.64 $400.00 $275.36 $24,653.33 47 $24,653.33 123.27 $400.00 $276.73 $24,376.59 48 $24,376.59 121.88 $400.00 $278.12 $24,098.48 49 $24,098.48 120.49 $400.00 $279.51 $23,818.97 50 $23,818.97 119.09 $400.00 $280.91 $23,538.06 51 $23,538.06 117.69 $400.00 $282.31 $23,255.75 52 $23,255.75 116.28 $400.00 $283.72 $22,972.03 53 $22,972.03 114.86 $400.00 $285.14 $22,686.89 54 $22,686.89 113.43 $400.00 $286.57 $22,400.33 55 $22,400.33 112.00 $400.00 $288.00 $22,112.33 56 $22,112.33 110.56 $400.00 $289.44 $21,822.89 57 $21,822.89 109.11 $400.00
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 16

2010-07-12_064940_Jptse_-_Amort - Ans a: Monthly Income Car...

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

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