document.write( "Question 1202788: A. The Taylors have purchased a $240,000 house. They made an initial down payment of $10,000 and secured a mortgage with interest charged at the rate of 5%/year on the unpaid balance. Interest computations are made at the end of each month. If the loan is to be amortized over 30 years, what monthly payment will the Taylors be required to make? (Round your answer to the nearest cent.)\r
\n" );
document.write( "\n" );
document.write( "$ \r
\n" );
document.write( "
\n" );
document.write( "\n" );
document.write( "B. What is their equity (disregarding appreciation) after 5 years? After 10 years? After 20 years? (Round your answers to the nearest cent.)
\n" );
document.write( "5 years $
\n" );
document.write( "10 years $
\n" );
document.write( "20 years $
\n" );
document.write( "
\n" );
document.write( "This question has two parts since part b requires part a and I'm confused on what I am doing wrong cause my part a is wrong to which leads my part b wrong too. \n" );
document.write( "
Algebra.Com's Answer #837884 by math_tutor2020(3817)![]() ![]() ![]() You can put this solution on YOUR website! \n" ); document.write( "Part A\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Monthly payment formula \n" ); document.write( "P = (L*i)/( 1-(1+i)^(-n) ) \n" ); document.write( "where, \n" ); document.write( "P = monthly payment \n" ); document.write( "L = loan amount \n" ); document.write( "i = monthly interest rate in decimal form \n" ); document.write( "n = number of months\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "In this case
\n" ); document.write( "P = (L*i)/( 1-(1+i)^(-n) ) \n" ); document.write( "P = (230000*0.004166667)/( 1-(1+0.004166667)^(-360) ) \n" ); document.write( "P = 1234.6897891544 \n" ); document.write( "P = 1234.69\r \n" ); document.write( " \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Answer: \n" ); document.write( "Monthly Payment = $1234.69\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "You can use a calculator like this to confirm the answer. \n" ); document.write( "https://www.calculator.net/loan-calculator.html \n" ); document.write( "The calculator will provide the monthly payment. \n" ); document.write( "Also, it provides the amortization table which will come in handy for part B\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "==========================================================================================================================================\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Part B\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "I'll be using the 2nd formula mentioned at this link \n" ); document.write( "https://www.mtgprofessor.com//formulas.htm\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "That formula is \n" ); document.write( "B = L * [ (1+c)^n - (1+c)^p ] / [ (1+c)^n - 1 ] \n" ); document.write( "it calculates the remaining balance. \n" ); document.write( "It's the amount the Taylors still owe at any given month p.\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "We have a giant single fraction \n" ); document.write( "numerator = L*((1+c)^n - (1+c)^p) \n" ); document.write( "denominator = (1+c)^n - 1\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "L = loan amount \n" ); document.write( "c = monthly interest rate in decimal form \n" ); document.write( "n = number of months of entire mortgage \n" ); document.write( "p = current month number\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "We have \n" ); document.write( "L = 230,000 \n" ); document.write( "c = 0.004166667 approximately \n" ); document.write( "n = 360 months \n" ); document.write( "as calculated earlier in part A.\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "If 5 years, aka 5*12 = 60 months, elapse then p = 60 \n" ); document.write( "B = L * [ (1+c)^n - (1+c)^p ] / [ (1+c)^n - 1 ] \n" ); document.write( "B = 230000 * [ (1+0.004166667)^360 - (1+0.004166667)^60 ] / [ (1+0.004166667)^360 - 1 ] \n" ); document.write( "B = 211,206.084993819 \n" ); document.write( "B = 211,206.08\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "The Taylors still owe $211,206.08 after 5 years (aka 60 months) have elapsed. \n" ); document.write( "This can be confirmed with the amortization table (refer to the 1st link mentioned earlier).\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Their equity at this point in time is 240,000 - 211,206.08 = $28,793.92\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Formula: \n" ); document.write( "Equity = (home value) - (remaining balance)\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Side note: A mortgage is considered \"underwater\" when the remaining balance exceeds the home value; which leads to negative equity. \r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Let's see how much the Taylors would still owe at the p = 120 month marker (120 months = 120/12 = 10 years) \n" ); document.write( "B = L * [ (1+c)^n - (1+c)^p ] / [ (1+c)^n - 1 ] \n" ); document.write( "B = 230000 * [ (1+0.004166667)^360 - (1+0.004166667)^120 ] / [ (1+0.004166667)^360 - 1 ] \n" ); document.write( "B = 187,086.750587192 \n" ); document.write( "B = 187,086.75\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Then subtract that from the home value \n" ); document.write( "240,000 - 187,086.75 = 52,913.25\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "I'll skip the steps for the \"20 years\" subsection. But it'll be the same idea, except you'll use p = 240 months.\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Keep in mind that each equity calculation uses the stagnant home price of $240,000. \n" ); document.write( "This is what your teacher refers to when mentioning the phrase \"disregarding appreciation\". \n" ); document.write( "Realistically the home price will fluctuate. \r \n" ); document.write( " \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "Answers: \n" ); document.write( "Equity at 5 years: $28,793.92 \n" ); document.write( "Equity at 10 years: $52,913.25 \n" ); document.write( "Equity at 20 years: $123,591.78 \n" ); document.write( " \n" ); document.write( " \n" ); document.write( " |