Question: You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate is 5.25 percent. You will make

You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate is 5.25 percent. You will make a down payment of 20 percent of the purchase price.

a. Calculate your monthly payments on this mortgage.

b. Using an Excel Spreadsheet, construct the amortization schedule for the first 12 payments.

c. Compute a breakdown of the total payments of the mortgage into interest and principal payment.

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!

You own a construction company and have recently received a contract with the local school district to refurbish one of its elementary schools. You are given an up-front payment from the school...

You plan to purchase a house for $ 175,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 25 percent of the purchase price. You will not pay off the mortgage...

You plan to purchase a house for $175,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 25 percent of the purchase price and monthly payments. You will not...

You plan to purchase a house for $175,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 25 percent of the purchase price. You will not pay off the mortgage...

You plan to purchase a house for $270,000 using a 15-year mortgage obtained from your local bank. the mortgage rate offered to you in 5.00 percent. you will make a down payment of 20 percent of...

please show financial calculator work! You plan to purchase a house for $199,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase...

You plan to purchase a house for $145,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price. You will not pay off the mortgage...

You plan to purchase a house for $163.000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price. You will not pay off the mortgage...

You plan to purchase a house for $255.000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price. You will not pay off the mortgage...

You plan to purchase a house for $192,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 25 percent of the purchase price. You will not pay off the mortgage...

You plan to purchase a house for $183,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 10 percent of the purchase price. You will not pay off the mortgage...

Justin had loaned $6,800 to his brother Jeremy in 2015. Jeremy has never made a payment to Justin, nor has Justin attempted to collect from Jeremy. This year, Jeremy filed bankruptcy and told Justin...

How do disclosures required by GAAP affect the auditors responsibilities for related party and related party transaction information? Why is the auditor concerned if management makes disclosures...

Carlos bought a building for $ 1 1 0 , 0 0 0 in 2 0 2 0 . He added an addition to the building for $ 2 6 , 0 0 0 in 2 0 2 1 . In 2 0 2 4 , he sold it for $ 2 0 9 , 0 0 0 . What was his long - term...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

6. Describe how our cognitions about ourselves and our behavior affect our communication with others

4. Describe cultural differences that influence perception

5. Identify how our selfconcept who we think we areinfluences communication