chap6_ho4_amortization_solution

chap6_ho4_amortization_solution - A 1 2 3 4 5 6 7 8 9 10 11...

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

View Full Document Right Arrow Icon
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 Pry, John 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 $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
Background image of page 1

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

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

This note was uploaded on 04/28/2010 for the course 4 4 taught by Professor 4 during the Spring '10 term at Alfred State College.

Page1 / 5

chap6_ho4_amortization_solution - A 1 2 3 4 5 6 7 8 9 10 11...

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