Smith is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $450,000. Mortgage A has a 4.25% interest rate and requires Smith to pay 1.5 points upfront. Mortgage B has a 5% interest rate and requires Smith to pay zero fees upfront. Assuming Smith makes payments for 2 years before she sells the house and pays the bank the balance, what is Smith's Annualized IRR from mortgage A? Please Use Excel to Solve

Smith is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $450,000. Mortgage A has a 4.25% interest rate and requires Smith to pay 1.5 points upfront. Mortgage B has a 5% interest rate and requires Smith to pay zero fees upfront. Assuming Smith makes payments for 2 years before she sells the house and pays the bank the balance, what is Smith's Annualized IRR from mortgage A? Please Use Excel to Solve

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 24PROB

See similar textbooks

Similar questions

Cost of Bank Loan Mary Jones recently obtained an equipment loan from a local bank. The loan is for 15,000 with a nominal interest rate of 11%. However, this is an installment loan, so the bank also charges add-on interest. Mary must make monthly payments on the loan, and the loan is to be repaid in 1 year. What is the effective annual rate on the loan (assuming a 365-day year)?
Calculating single-payment loan amount due at maturity. Stanley Price plans to borrow 8,000 for five years. The loan will be repaid with a single payment after five years, and the interest on the loan will be computed using the simple interest method at an annual rate of 6 percent. How much will Stanley have to pay in five years? How much will he have to pay at maturity if hes required to make annual interest payments at the end of each year?
Present Values Krista Kellman has an opportunity to purchase a government security that will pay $200,000 in 5 years. Required: Note: Round answers to two decimal places. 1. Calculate what Krista would pay for the security if the appropriate interest (discount) rate is 6% compounded annually. 2. Calculate what Krista would pay for the security if the appropriate interest (discount) rate is 10% compounded annually. 3. Calculate what Krista would pay for the security if the appropriate interest (discount) rate is 6% compounded semiannually.
ExerciseInstallment Notes ABC bank loans $250,000 to Yossarian to purchase a new home. Yossarian will repay the note in equal monthly payments over a period of 30 years. The interest rate is 12%. Required: If the monthly payment is $2,571.53, how much of the first payment is interest expense and how much is principal repayment? (Note: Round to the nearest cent.)
Compound Interest Issues You are given the following situations: 1. Thomas Petty owes a debt of 7,000 from the purchase of a boat. The debt bears 12% interest payable annually. Thomas will pay the debt and interest in 5 annual installments beginning in 1 year. Calculate the equal annual installments that will pay off the debt and interest at 12% on the unpaid balance. 2. On January 1, 2019, John Cothran offers to buy Ruth Houses used tractor and equipment for 4,000 payable in 12 equal semiannual installments which are to include payment of 10% interest on the unpaid balance and payment of a portion of the principal with the first installment to be made on January 1, 2019. Calculate the amount of each of these installments. 3. Nadine Love invests in a 60,000 annuity at 12% compounded annually on March 1, 2019. The first of 15 receipts from the annuity is payable to Love on March 1, 2029, 10 years after the annuity is purchased and on the date Love expects to retire. Calculate the amount of each of the 15 equal annual receipts. Required: Using the appropriate tables, solve each of the preceding situations.
Calculating and comparing add-on and simple interest loans. Eli Nelson is borrowing 10,000 for five years at 7 percent. Payments, which are made on a monthly basis, are determined using the add-on method. a. How much total interest will Eli pay on the loan if it is held for the full five-year term? b. What are Elis monthly payments? c. How much higher are the monthly payments under the add-on method than under the simple interest method?