Hannah is planning to purchase her first home. She has spoken to the bank who has...

Hannah is planning to purchase her first home. She has spoken to the bank who has advised that she qualifies for a 25 year mortgage of $1,400,000 at an annual percentage rate of 6%. Payments will be made monthly and therefore interest will be compounded monthly. a. What is the effective annual rate on this loan?
1. Calculate her monthly payment.
2. Prepare an amortization schedule for the first two months of the loan.

Solutions

Expert Solution

Effective annual rate = (1 + Annual rate / n)ⁿ , where n is the number of compunding periods.

Since the loan is compounded monthly, n = 12

Annual rate = 6%

Effective annual rate = (1 + 0.06/12)¹² - 1 = 0.06168 or 6.618%

PV = P x [1 - (1 + r)^-n] / r

Where PV is the present value of the loan amount = 1,400,000

r is the monthly interest rate = 6/12 = 0.5%

n is the number of months = 25 x 12 = 300

P is the monthly payments

P = PV x r / [1 - (1 + r)^-n] = 1,400,000 x 0.005 / [1 - (1.005)^-300]

P = $9,020.22

	1	2
Principal Remaining	$1,400,000	$1,397,979.78
Monthly Payment	$9,020.22	$9,020.22
Interest Payment	$7,000.000	$6,989.899
Principal Repayment	$2,020.22	$2,030.32

Interest payment in month 1 is 1,400,000 x 0.005 = 7,000

Principal repayment in month 1 is Monthly payment - interest payment = 2,020.22

Principal remaining in month 2 = Principal remaining in month 1 - principal repayment in month 1 = 1,397,979.78

Interest payment = 1,397,979.78 x 0.005 = 6989.899

Principal repayment = 9,020.22 - 6989.899 = 2,030.32

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A woman is looking to purchase her primary home in the Cleveland Suburbs. She has enough...

A woman is looking to purchase her primary home in the Cleveland Suburbs. She has enough for a 20% down payment and an income of $40,000 per year. However, her FICO Score is 660. The prime Interest Rate for 30-year Mortgages is 4.75%. She has a car payment of $400 per month and a Student Loan Payment of $200 per month. The home she finds has 70 Effective Property Tax Mills and Homeowner’s Insurance Costs $50 per month on every...

Becca needs to borrow $143,000 to purchase a new home. The bank has given her two options;...

Becca needs to borrow $143,000 to purchase a new home. The bank has given her two options; the first is a 20 year loan at 4.35% or the second is a 30 year loan at 4.95%. How much is the payment for each of these loans? 20-year payment______________ 30-year payment ______________ What is the total cost of each mortgage? 20-year total cost______________ 30-year total cost ______________ How much will Becca save if she chooses the 20 year loan? _______________

Becca needs to borrow $143,000 to purchase a new home. The bank has given her two options;...

Hannah Legaleagle is an attorney. She is an Irish citizen who vacationed in the U.S. for...

Hannah Legaleagle is an attorney. She is an Irish citizen who vacationed in the U.S. for 14 days in 2017. Because of her fondness for living in the U.S., Hannah’s Irish employer law firm, gave her a temporary assignment in the U.S. from August 1 through December 31, 2018. She earned $120,000 while working in the U.S. , earned $220,000 for the year working in Ireland, and she also earned about $40,000 in interest and dividends, all from Irish banks...

Rosa is a single parent who maintains a home in Durham in which she and her...

Rosa is a single parent who maintains a home in Durham in which she and her 16-year-old daughter, Maria, reside. She also provides most of the support for her son, Carmelo, age 25, who is a full-time student at Duke Law School, lives at home, and earns $3,500 as a part-time waiter at a local diner. Which of the following statements is true of Rosa's tax return? a.Maria is a qualifying relative, while Carmelo is a qualifying child of Rosa....

Maria's home was damaged by an earthquake. As Maria has open-perils coverage on her home, she...

Maria's home was damaged by an earthquake. As Maria has open-perils coverage on her home, she was surprised to learn that her loss was not covered. Which section of a property insurance policy specifies which perils, property, and types of losses are not covered? A) the exclusions B) the declarations C) the conditions D) the insuring agreement

Hannah Ortega is considering expanding her business. She plans to hire a salesperson to cover trade...

Hannah Ortega is considering expanding her business. She plans to hire a salesperson to cover trade shows. Because of compensation, travel expenses, and booth rental, fixed costs for a trade show are expected to be $16,770. The booth will be open 39 hours during the trade show. Ms. Ortega also plans to add a new product line, ProOffice, which will cost $179 per package. She will continue to sell the existing product, EZRecords, which costs $105 per package. Ms. Ortega...

Hannah Ortega is considering expanding her business. She plans to hire a salesperson to cover trade...

Hannah Ortega is considering expanding her business. She plans to hire a salesperson to cover trade shows. Because of compensation, travel expenses, and booth rental, fixed costs for a trade show are expected to be $9,250. The booth will be open 25 hours during the trade show. Ms. Ortega also plans to add a new product line, ProOffice, which will cost $177 per package. She will continue to sell the existing product, EZRecords, which costs $101 per package. Ms. Garcia...

Hannah Ortega is considering expanding her business. She plans to hire a salesperson to cover trade...

Hannah Ortega is considering expanding her business. She plans to hire a salesperson to cover trade shows. Because of compensation, travel expenses, and booth rental, fixed costs for a trade show are expected to be $14,570. The booth will be open 31 hours during the trade show. Ms. Ortega also plans to add a new product line, ProOffice, which will cost $176 per package. She will continue to sell the existing product, EZRecords, which costs $103 per package. Ms. Ortega...

Linda comes home for Christmas after her first semester if college, where she lived in the...

Linda comes home for Christmas after her first semester if college, where she lived in the dorms. She develops a fever of 101 °F, a dry cough and is very tired. She has elevated white blood cell counts and procalcitonin levels of 1.5 micrograms/liter. What disease is she likely to have and what should the next step in diagnosis be?

Subjects