chap6_ho4_amortization_solution

chap6_ho4_amortization_solution - Amortization Schedule...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Amortization Schedule Enter Loan Parameters as Indicated Loan Summary Information Principal $400,000 Monthly Payment $2,462.87 Annual Interest 6.25% Scheduled Payments 360 Date of First Payment 2/1/2008 TRUE Normal Payoff Date 1/1/2038 Term of Loan (years) 30 Actual Number of Payments 294 Extra Payment Every Period $200 Actual Payoff Date Err:502 I think I have the right fomula here, but I have no idea why it cannot calculate the right date Your Last Name Ruofan Teng Total of Extra Payments $58,800.00 Purpose of Loan Mortgage Total of All Interest Payments $381,683.75 Date Interest Principal Extra Payment 1 2/1/2008 $400,000 $2,462.87 $2,083.33 $379.54 200 $399,420.46 2 3/1/2008 $399,420.46 $2,462.87 $2,080.31 $382.55 200 $398,837.91 3 4/1/2008 $398,837.91 $2,462.87 $2,077.28 $385.59 200 $398,252.32 4 5/1/2008 $398,252.32 $2,462.87 $2,074.23 $388.64 200 $397,663.68 5 6/1/2008 $397,663.68 $2,462.87 $2,071.17 $391.70 200 $397,071.98 6 7/1/2008 $397,071.98 $2,462.87 $2,068.08 $394.79 200 $396,477.20 7 8/1/2008 $396,477.20 $2,462.87 $2,064.99 $397.88 200 $395,879.31 8 9/1/2008 $395,879.31 $2,462.87 $2,061.87 $401.00 200 $395,278.31 9 10/1/2008 $395,278.31 $2,462.87 $2,058.74 $404.13 200 $394,674.19 10 11/1/2008 $394,674.19 $2,462.87 $2,055.59 $407.27 200 $394,066.91 11 12/1/2008 $394,066.91 $2,462.87 $2,052.43 $410.44 200 $393,456.48 12 1/1/2009 $393,456.48 $2,462.87 $2,049.25 $413.62 200 $392,842.86 13 2/1/2009 $392,842.86 $2,462.87 $2,046.06 $416.81 200 $392,226.05 14 3/1/2009 $392,226.05 $2,462.87 $2,042.84 $420.02 200 $391,606.02 15 4/1/2009 $391,606.02 $2,462.87 $2,039.61 $423.25 200 $390,982.77 16 5/1/2009 $390,982.77 $2,462.87 $2,036.37 $426.50 200 $390,356.27 17 6/1/2009 $390,356.27 $2,462.87 $2,033.11 $429.76 200 $389,726.50 18 7/1/2009 $389,726.50 $2,462.87 $2,029.83 $433.04 200 $389,093.46 19 8/1/2009 $389,093.46 $2,462.87 $2,026.53 $436.34 200 $388,457.12 20 9/1/2009 $388,457.12 $2,462.87 $2,023.21 $439.65 200 $387,817.47 21 10/1/2009 $387,817.47 $2,462.87 $2,019.88 $442.99 200 $387,174.48 22 11/1/2009 $387,174.48 $2,462.87 $2,016.53 $446.34 200 $386,528.15 23 12/1/2009 $386,528.15 $2,462.87 $2,013.17 $449.70 200 $385,878.44 24 1/1/2010 $385,878.44 $2,462.87 $2,009.78 $453.09 200 $385,225.36 25 2/1/2010 $385,225.36 $2,462.87 $2,006.38 $456.49 200 $384,568.87 26 3/1/2010 $384,568.87 $2,462.87 $2,002.96 $459.91 200 $383,908.97 27 4/1/2010 $383,908.97 $2,462.87 $1,999.53 $463.34 200 $383,245.62 28 5/1/2010 $383,245.62 $2,462.87 $1,996.07 $466.80 200 $382,578.83 29 6/1/2010 $382,578.83 $2,462.87 $1,992.60 $470.27 200 $381,908.55 30 7/1/2010 $381,908.55 $2,462.87 $1,989.11 $473.76 200 $381,234.79 31 8/1/2010 $381,234.79 $2,462.87 $1,985.60 $477.27 200 $380,557.52 32 9/1/2010 $380,557.52 $2,462.87 $1,982.07 $480.80 200 $379,876.72 33 10/1/2010 $379,876.72 $2,462.87 $1,978.52 $484.34 200 $379,192.38 34 11/1/2010 $379,192.38 $2,462.87 $1,974.96 $487.91 200 $378,504.47 35 12/1/2010 $378,504.47 $2,462.87 $1,971.38 $491.49 200 $377,812.98 36 1/1/2011...
View Full Document

Page1 / 7

chap6_ho4_amortization_solution - Amortization Schedule...

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