5 Construct an amortization schedule for the mortgage If the Halls would pay extra payment of $150 a month starting 49th month, how quickly will they able to payoff the mortgage Be sure to have a zero balance at the end of amortization Loan Amount 180,576 Loan Length in months 240 Interest (APR) 4 250 Total interest payment Hint Be sure to compute the total interest payments using Sum() function Prepayment $150 Total of pmts with prepay With the prepayments, note that your payments will be shortened Month Beginning Principal Monthly Payment Interest Principal pmt Outstanding Balance 1 180,576

The Answer is in the image, click to view ...

Question: 5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of $150 a month starting 49th month, how quickly will

5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of $150 a month starting 49th month, how quickly will they able to payoff the mortgage? Be sure to have a zero balance at the end of amortization.

Loan Amount	180,576	Loan Length in months	240
Interest (APR)	4.250%	Total interest payment		Hint: Be sure to compute the total interest payments using "Sum()" function.
Prepayment	$150	Total # of pmts with prepay		With the prepayments, note that your payments will be shortened.

Month	Beginning Principal	Monthly Payment	Interest	Principal pmt	Outstanding Balance
1	180,576

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

7 5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of $150 a month starting 73th month, how quickly will they able to payoff the mortgage? Be sure to have...

A borrower has taken out a 30-year mortgage for $93,000 at an annual rate of 10%. Part A is already figured out. For part B: What would be the first three lines of an amortization schedule for this...

65. A borrower has taken out a 30-year mortgage for $110,000 at an annual rate of 5%. a. Use the table to find the monthly payment for this mortgage. b. Construct the first three lines of an...

*8.5.17 :3 Question Help A borrower has taken out a 30-year mortgage for $116,000 at an annual rate of 8%. a. Use the table to find the monthly payment for this mortgage. b. Construct the first three...

Please answer all of it. If not, please skip! Also SHOW WORK Please! 7. You want to purchase an automobile for $24,172. The dealer offers you 0% financing for 48 months or a $4,371 rebate You can...

UPIN18 2020 In order to receive credit for your answers, use Excel Financial Functions or Algebraic Time Value of Money Equations to answer these questions in your spreadsheet. See General Guide-...

A borrower has taken out a 10-year mortgage for $102,000 at an annual rate of 8%. For part A: What would their monthly payment be for this mortgage? Use the table below. For part B: What would be the...

Hi again. Please help me once more with my study information. I have provided three assignments. Let me know if you need additional information. \fFINANCIAL AND MANAGERIAL ACCOUNTING - Fifth Edition...

borrower has taken out a 30-year mortgage for 599,000 at an annual rate of 6% Use the table to find the monthly payment for this mortgage b. Construct the first three lines of an amortization...

A potentiometer wire of length 100 cm has a resistance of 102. It is connected in series with resistance (shown in figure) and a cell of emf 2V and negligible resistance. A source of emf 10 mV is...

Calculate the final velocity right after a 115-kg rugby player who is initially running at 7.35 m/s collides head-on with a padded goalpost and experiences a backward force of 1.81 x 104 N for 5.50 x...

2 0 . According to the PowerPoint Part I What are mortgage - backed securities or MBS ? A ) These are simply 3 0 - year mortgage loans made by banks. The banks then wait for the next 3 0 - years as...

Skills necessary for success in marketing include Multiple select question. analytical thinking advertising industry experience infallibility ability to work with others

2. Many organizations are concerned about the rising cost of employee benefits and question their value to the organization and to the employees. a. In your opinion, what benefits are of greatest...

OUTCOME 2 Describe the measures managers and employees can take to create a safe work environment.

OUTCOME 2 Identify and explain the privacy rights of employees.