Project 4 - Project 4 - 89,777.02 287,777.02 10 88,869.92...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
e-Money Lenders 285bfc2547cbfa6d8582247923f2e5121e571498.xls Loan Payment Calculator Amortization Schedule Date 12-May-2009 Rate 6.25% Year Item House Years 15 1 $173,000.00 $165,808.72 $7,191.28 $10,608.82 Price $198,000.00 Monthly Pymt $1,483.34 2 165,808.72 158,154.88 7,653.84 10,146.26 Down Pymt $25,000.00 Total Interest $94,001.48 3 158,154.88 150,008.74 8,146.15 9,653.95 Loan Amt $173,000.00 Total Cost $292,001.48 4 150,008.74 141,338.62 8,670.12 9,129.98 Interest Rate Schedule 5 141,338.62 132,110.82 9,227.80 8,572.30 Rate Monthly Pymt Total Interest Total Cost 6 132,110.82 122,289.47 9,821.35 7,978.75 $1,483.34 $94,001.48 $292,001.48 7 122,289.47 111,836.40 10,453.07 7,347.03 5.50% 1,413.55 81,439.79 279,439.79 8 111,836.40 100,710.96 11,125.43 6,674.66 5.75% 1,436.61 85,589.70 283,589.70 9 100,710.96 88,869.92 11,841.04 5,959.06 6.00% 1,459.87
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 89,777.02 287,777.02 10 88,869.92 76,267.24 12,602.68 5,197.42 6.25% 1,483.34 94,001.48 292,001.48 11 76,267.24 62,853.94 13,413.31 4,386.79 6.50% 1,507.02 98,262.83 296,262.83 12 62,853.94 48,577.86 14,276.08 3,524.02 6.75% 1,530.89 102,560.81 300,560.81 13 48,577.86 33,383.52 15,194.34 2,605.76 7.00% 1,554.97 106,895.12 304,895.12 14 33,383.52 17,211.86 16,171.67 1,628.43 7.25% 1,579.25 111,265.50 309,265.50 15 17,211.86 0.00 17,211.86 588.24 7.50% 1,603.73 115,671.65 313,671.65 Subtotal $173,000.00 $94,001.48 7.75% 1,628.41 120,113.27 318,113.27 Down Pymt $25,000.00 8.00% 1,653.28 124,590.06 322,590.06 Total Cost $292,001.48 Beginning Balance Ending Balance Paid On Principal Interest Paid...
View Full Document

Ask a homework question - tutors are online