SC_Excel2010_C4_L1a_JennaSicard_2

SC_Excel2010_C4_L1a_JennaSicard_2 - 8,146.35 263,231.10...

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

View Full Document Right Arrow Icon
SAM Projects Office 2010 EXCEL 2010 C4 L1a - Mortgage Analysis and Amortizat DO NOT DELETE--> %(01EA3486D896CC2B-3CE6DE39E44A6D51)% Author Jenna Sicard %(01EA3486D896CC2B-3CE6DE39E44A6D51)% mhqqdvlfdug Note: Do not edit this sheet. If your name does not appear in cel B4, please download a new copy of the start file from the SAM web site.
Background image of page 1

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

View Full DocumentRight Arrow Icon
WeSavU National Bank Subprime Loans for Everyone Price $430,000.00 Rate 8.75% Down Payment $110,000.00 Years 25 Loan Amount $320,000.00 Monthly Payment $2,630.86 Years Interest Paid 1 $320,000.00 $3,717.04 $316,282.96 $27,853.28 2 316,282.96 4,055.64 312,227.32 27,514.67 3 312,227.32 4,425.10 307,802.22 27,145.22 4 307,802.22 4,828.20 302,974.02 26,742.11 5 302,974.02 5,268.03 297,705.98 26,302.28 6 297,705.98 5,747.93 291,958.05 25,822.39 7 291,958.05 6,271.54 285,686.51 25,298.77 8 285,686.51 6,842.85 278,843.65 24,727.46 9 278,843.65 7,466.21 271,377.45 24,104.11 10 271,377.45
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 8,146.35 263,231.10 23,423.97 11 263,231.10 8,888.45 254,342.65 22,681.87 12 254,342.65 9,698.15 244,644.50 21,872.17 13 244,644.50 10,581.61 234,062.89 20,988.71 14 234,062.89 11,545.55 222,517.34 20,024.77 15 222,517.34 12,597.30 209,920.04 18,973.01 16 209,920.04 13,744.86 196,175.18 17,825.45 17 196,175.18 14,996.96 181,178.21 16,573.35 18 181,178.21 16,363.12 164,815.09 15,207.19 19 164,815.09 17,853.73 146,961.36 13,716.58 20 146,961.36 19,480.14 127,481.22 12,090.18 21 127,481.22 21,254.69 106,226.53 10,315.62 22 106,226.53 23,190.91 83,035.62 8,379.41 23 83,035.62 25,303.50 57,732.12 6,266.81 24 57,732.12 27,608.55 30,123.57 3,961.77 25 30,123.57 30,123.57 0.00 1,446.75 Paid on Principal $320,000.00 Total Interest Paid $469,257.89 Down Payment $110,000.00 Total Cost $899,257.89 Beginning Balance Paid on Principal Ending Balance...
View Full Document

Page1 / 2

SC_Excel2010_C4_L1a_JennaSicard_2 - 8,146.35 263,231.10...

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

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