1. You have just obtained a commercial mortgage for $6.25M with a 5-year term, 25-year amortization period and 6.50% mortgage interest rate. (a) Construct an amortization table for the term of the loan assuming annual payments. What is the annual payment? What is the balance at maturity? (b) What is the e¤ective cost of borrowing if the borrower pays an origination fee of $30,000? (c) The borrower can repay the balance of the loan at any time prior to its maturity, but must pay a penalty of 5% of the outstanding balance. What is the cost of borrowing if the borrower pays an origination fee of $30,000 and pays off the remaining balance of the loan after making payments for 4 years?

1. You have just obtained a commercial mortgage for $6.25M with a 5-year term, 25-year amortization period and 6.50% mortgage interest rate. (a) Construct an amortization table for the term of the loan assuming annual payments. What is the annual payment? What is the balance at maturity? (b) What is the e¤ective cost of borrowing if the borrower pays an origination fee of $30,000? (c) The borrower can repay the balance of the loan at any time prior to its maturity, but must pay a penalty of 5% of the outstanding balance. What is the cost of borrowing if the borrower pays an origination fee of $30,000 and pays off the remaining balance of the loan after making payments for 4 years?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter7: Using Consumer Loans

Section: Chapter Questions

Problem 7FPE: Calculating interest and APR of installment loan. Assuming that interest is the only finance charge,...

See similar textbooks

Similar questions

A mortgage has the following terms: Amount: $750,000 Rate: 6.25% Amortization (Years): 30 Term (Years): 20 Please determine the following: What is the Monthly Payment? In preparing an Income Statement, what is the Interest Expense for years 1 – 5? What is the Principal Balance at the end of year 6? What is the value of the loan at the expiration? If rates remain constant (flat), what would the benefit be to refinance this loan after year 10? do all the questions 1-5 and show the formulas in excel and show how you got it
Suppose you purchase a home and obtain a 15-year fixed-rate loan of $195,000 at an annual interest rate of 6.0%. a) What is your monthly payment? N: months I %: P.V: $ PMT: $ F.V: 0 P/Y: 12 C/Y: 12 b) Of the first month's mortgage payment, how much is interest? HINT: I=Prt Interest: I=$ c) Of the first month's mortgage payment, how much is applied to the principal? HINT: PMT - Interest Amount Applied to Principal: $ d) How much is your outstanding balance after the first month’s payment? HINT: Principal - Amount Applied to Principal Outstanding Balance after first payment: $
1. Let's assume that a loan of $100,000 with an annual interest rate of 6% over 30 years pays monthly payments of $500. a. Calculate the accumulation rate b. Calculate the payment rate . c. Answer : How will the balance of the principal be at the end of the loan in relation to the original amount of the loan? Less, equal or greater? Provide calculations.
4) I have an NOI of$172,400. The lender indicated that I can borrow funds at a 7.0% interest rate with a 25 year amortization and 5 year term at a 1.20 Debt Service Ratio(DCR). The lender will charge 2 points. a. What is the monthly payment? b.What is the APR (annual percentage rate) if fully amortized? C.What is the APR at the end of the loan term? d.What if I pay the loan off at the end of the second year, what is my APR? e.What if there was a prepayment penalty of 1.5% at the end of year 4, what is myAPR?
a. What will be the monthly payment on a 30-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded monthly? How much interest is paid over the life of the loan? b. What will be the monthly payment on a 30-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded continuously? How much interest is paid over the life of the loan? c. What will be the monthly payment on a 15-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded monthly? How much interest is paid over the life of the loan?
1. Assuming the cost of mortgage is $400,000, and the owner of the house makes a down payment of $40,000, with 8% interest rate and 10 years repayment plan. a. calculate the total amount of loan, monthly rate, number of payment periods, monthly payment, total interest paid, and amount borrowed. b. With the aid of what PMT function in a one variable condition, calculate monthly payment, total amount payable, total interest payable for: 12 yrs, 16 yrs, 20 yrs ,25 yrs, 30 yrs, 35 yrs mortgage.
TOTAL INTEREST PAID. You are considering purchasing a home that requires $450,000 mortgage at 5.25%. Using a simple interest Loan amortization schedule:A) What is the total amount that you would pay for the 30 year mortgage, including interest?B) What is the total amount that you would pay for the 15 year mortgage, including interest?C) What is the difference in the total interest paid between the two different maturities?
9) Mortgage Payment You take out a 20-year fixed mortgage. The annual interest rate is ? = 0.10 and the monthly payment is $4,000. a. What is the total amount of this Mortgage? E.g., What is the PV of this mortgage payment stream? b. If you make an additional payment of $4,000 in period t=1 and period t=2, how long will it take to repay the mortgage?
2. A mortgage has the following terms: Amount: $750,000 Rate: 6.25% Amortization (Years): 30 Term (Years): 20 Please determine the following: A. What is the Monthly Payment? B. In preparing an Income Statement, what is the Interest Expense for years 1-5? C. What is the Principal Balance at the end of year 6? D. What is the value of the loan at the expiration? E. If rates remain constant (flat), what would the benefit be to refinance this loan after year 10?
Give typing answer with explanation and conclusion If the annual payment mortgage constant for an amortizing loan is 10.6%, and the loan amount is $25,000,000, what is the annual payment?
What was the interest rate on a 3.5-year loan, $1000 loan if the simple interest paid was $297.50?
2. If the interest rate on a 30-year mortgage is fixed at 4% and if a monthly payment of $900 is the maximum that the buyer can afford, what is the maximum mortgage load that can be made under these conditions? Write out a difference equation modeling the scenario and show all work to receive full credit.