chap6_ho4_amortization_solution (1)

chap6_ho4_amortization_solution (1) - 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 7/1/2032 Your Last Name Jinyao Zhao Total of Extra Payments $58,800.00 Purpose of Loan Mortgage Total of Al 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 $377,812.98 $2,462.87 $1,967.78 $495.09 200 $377,117.89 37 2/1/2011 $377,117.89 $2,462.87 $1,964.16 $1,964....
View Full Document

This note was uploaded on 02/18/2011 for the course 06K 070 taught by Professor Yvonnegalusha during the Spring '11 term at University of Iowa.

Page1 / 6

chap6_ho4_amortization_solution (1) - 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