2010-08-17_235406_Amort

2010-08-17_235406_Amort - Ans a Monthly Income Car payments...

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 45000.00 40500 7% 60 Home 280000.00 271600 4.88% 360 Amortization for Car Loan Affordable Should be PMT 400.00 $801.95 Month Opening balance Interest PMT Principal Closing Balance 1 $40,500 236.25 $400.00 $163.75 $40,336.25 2 $40,336.25 235.29 $400.00 $164.71 $40,171.54 3 $40,171.54 234.33 $400.00 $165.67 $40,005.88 4 $40,005.88 233.37 $400.00 $166.63 $39,839.25 5 $39,839.25 232.40 $400.00 $167.60 $39,671.64 6 $39,671.64 231.42 $400.00 $168.58 $39,503.06 7 $39,503.06 230.43 $400.00 $169.57 $39,333.49 8 $39,333.49 229.45 $400.00 $170.55 $39,162.94 9 $39,162.94 228.45 $400.00 $171.55 $38,991.39 10 $38,991.39 227.45 $400.00 $172.55 $38,818.84 11 $38,818.84 226.44 $400.00 $173.56 $38,645.28 12 $38,645.28 225.43 $400.00 $174.57 $38,470.71 13 $38,470.71 224.41 $400.00 $175.59 $38,295.13 14 $38,295.13 223.39 $400.00 $176.61 $38,118.51 15 $38,118.51 222.36 $400.00 $177.64 $37,940.87 16 $37,940.87 221.32 $400.00 $178.68 $37,762.19 17 $37,762.19 220.28 $400.00 $179.72 $37,582.47 18 $37,582.47 219.23 $400.00 $180.77 $37,401.70 19 $37,401.70 218.18 $400.00 $181.82 $37,219.88 20 $37,219.88 217.12 $400.00 $182.88 $37,037.00 21 $37,037.00 216.05 $400.00 $183.95 $36,853.05 22 $36,853.05 214.98 $400.00 $185.02 $36,668.02 23 $36,668.02 213.90 $400.00 $186.10 $36,481.92 24 $36,481.92 212.81 $400.00 $187.19 $36,294.73 25 $36,294.73 211.72 $400.00 $188.28 $36,106.45 26 $36,106.45 210.62 $400.00 $189.38 $35,917.07 27 $35,917.07 209.52 $400.00 $190.48 $35,726.59 28 $35,726.59 208.41 $400.00 $191.59 $35,534.99 29 $35,534.99 207.29 $400.00 $192.71 $35,342.28 30 $35,342.28 206.16 $400.00 $193.84 $35,148.44 31 $35,148.44 205.03 $400.00 $194.97 $34,953.48 32 $34,953.48 203.90 $400.00 $196.10 $34,757.37 33 $34,757.37 202.75 $400.00 $197.25 $34,560.12 34 $34,560.12 201.60 $400.00 $198.40 $34,361.72 35 $34,361.72 200.44 $400.00 $199.56 $34,162.17
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
36 $34,162.17 199.28 $400.00 $200.72 $33,961.45 37 $33,961.45 198.11 $400.00 $201.89 $33,759.55 38 $33,759.55 196.93 $400.00 $203.07 $33,556.48 39 $33,556.48 195.75 $400.00 $204.25 $33,352.23 40 $33,352.23 194.55 $400.00 $205.45 $33,146.79 41 $33,146.79 193.36 $400.00 $206.64 $32,940.14 42 $32,940.14 192.15 $400.00 $207.85 $32,732.29 43 $32,732.29 190.94 $400.00 $209.06 $32,523.23 44 $32,523.23 189.72 $400.00 $210.28 $32,312.95 45 $32,312.95 188.49 $400.00 $211.51 $32,101.44 46 $32,101.44 187.26 $400.00 $212.74 $31,888.70 47 $31,888.70 186.02 $400.00 $213.98 $31,674.72 48 $31,674.72 184.77 $400.00 $215.23 $31,459.49 49 $31,459.49 183.51 $400.00 $216.49 $31,243.00 50 $31,243.00 182.25 $400.00 $217.75 $31,025.25 51 $31,025.25 180.98 $400.00 $219.02 $30,806.23 52 $30,806.23 179.70 $400.00 $220.30 $30,585.94 53 $30,585.94 178.42 $400.00 $221.58 $30,364.35 54 $30,364.35 177.13 $400.00 $222.87 $30,141.48 55 $30,141.48 175.83 $400.00 $224.17 $29,917.30 56 $29,917.30 174.52 $400.00 $225.48 $29,691.82 57 $29,691.82 173.20 $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.

{[ snackBarMessage ]}

Page1 / 16

2010-08-17_235406_Amort - Ans a Monthly Income Car payments...

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