HW7 - Loan Information Customer Name Purchase Price Down...

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

View Full Document Right Arrow Icon
Loan Information Customer Name Paul Benario Payment: $1,366.29 per month Purchase Price $178,348 Interest Rate: 6.25% per year Down Payment $19,000 Loan Amt. $159,348.00 Loan Term 15 (years) Loan Analysis Query End of Year Total Principal Total Interest Remaining Balance Total Paid 15 $159,348.00 $86,583.51 ($0.00) $245,931.51 Payment Principal Paid Interest Paid Total Interest 1 $159,348.00 $536.35 $829.94 $536.35 $829.94 $158,811.65 2 $158,811.65 $539.14 $827.14 $1,075.49 $1,657.08 $158,272.51 3 $158,272.51 $541.95 $824.34 $1,617.44 $2,481.42 $157,730.56 4 $157,730.56 $544.77 $821.51 $2,162.21 $3,302.93 $157,185.79 5 $157,185.79 $547.61 $818.68 $2,709.82 $4,121.61 $156,638.18 6 $156,638.18 $550.46 $815.82 $3,260.29 $4,937.43 $156,087.71 7 $156,087.71 $553.33 $812.96 $3,813.62 $5,750.39 $155,534.38 8 $155,534.38 $556.21 $810.07 $4,369.83 $6,560.46 $154,978.17 9 $154,978.17 $559.11 $807.18 $4,928.94 $7,367.64 $154,419.06 10 $154,419.06 $562.02 $804.27 $5,490.96 $8,171.91 $153,857.04 11 $153,857.04 $564.95 $801.34 $6,055.90 $8,973.25 $153,292.10 12 $153,292.10 $567.89 $798.40 $6,623.79 $9,771.64 $152,724.21 13 $152,724.21 $570.85 $795.44 $7,194.64 $10,567.08 $152,153.36 14 $152,153.36 $573.82 $792.47 $7,768.46 $11,359.55 $151,579.54 15 $151,579.54 $576.81 $789.48 $8,345.27 $12,149.02 $151,002.73 16 $151,002.73 $579.81 $786.47 $8,925.08 $12,935.49 $150,422.92 17 $150,422.92 $582.83 $783.45 $9,507.92 $13,718.95 $149,840.08 18 $149,840.08 $585.87 $780.42 $10,093.79 $14,499.36 $149,254.21 19 $149,254.21 $588.92 $777.37 $10,682.71 $15,276.73 $148,665.29 20 $148,665.29 $591.99 $774.30 $11,274.70 $16,051.03 $148,073.30 21 $148,073.30 $595.07 $771.22 $11,869.77 $16,822.24 $147,478.23 22 $147,478.23 $598.17 $768.12 $12,467.94 $17,590.36 $146,880.06 23 $146,880.06 $601.29 $765.00 $13,069.22 $18,355.36 $146,278.78 24 $146,278.78 $604.42 $761.87 $13,673.64 $19,117.23 $145,674.36 25 $145,674.36 $607.57 $758.72 $14,281.21 $19,875.95 $145,066.79 26 $145,066.79 $610.73 $755.56 $14,891.94 $20,631.51 $144,456.06 27 $144,456.06 $613.91 $752.38 $15,505.85 $21,383.88 $143,842.15 28 $143,842.15 $617.11 $749.18 $16,122.95 $22,133.06 $143,225.05 29 $143,225.05 $620.32 $745.96 $16,743.28 $22,879.02 $142,604.72 30 $142,604.72 $623.55 $742.73 $17,366.83 $23,621.76 $141,981.17 31 $141,981.17 $626.80 $739.49 $17,993.63 $24,361.24 $141,354.37 32 $141,354.37 $630.07 $736.22 $18,623.70 $25,097.46 $140,724.30 33 $140,724.30 $633.35 $732.94 $19,257.04 $25,830.40 $140,090.96 34 $140,090.96 $636.65 $729.64 $19,893.69 $26,560.04 $139,454.31 35 $139,454.31 $639.96 $726.32 $20,533.65 $27,286.37 $138,814.35 36 $138,814.35 $643.29 $722.99 $21,176.95 $28,009.36 $138,171.05 37 $138,171.05 $646.65 $719.64 $21,823.59 $28,729.00 $137,524.41 38 $137,524.41 $650.01 $716.27 $22,473.60 $29,445.27 $136,874.40 39 $136,874.40 $653.40 $712.89 $23,127.00 $30,158.16 $136,221.00 Beginning Balance Total Principal Ending Balance
Background image of page 1

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

View Full DocumentRight Arrow Icon
Payment Principal Paid Interest Paid Total Interest Beginning Balance Total Principal
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 / 4

HW7 - Loan Information Customer Name Purchase Price Down...

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