Question

In: Finance

You obtain a loan of $300,000 at 5.75% amortized over thirty years with monthly payments.

Can you please help me the steps of this Finance Math problem?

You obtain a loan of $300,000 at 5.75% amortized over thirty years with monthly payments. You are required to pay closing costs and fees of 1.0% of the loan amount to the lender. What is the yield of the loan if paid off at maturity?

Solutions

Expert Solution

first calculate the monthly payments

PV = 300,000, FV = 0, rate = 5.75%/12, N = 360

use PMT function in Excel

monthly payments = 1,750.7186

PV = 300,000, FV = -0.01*300,000, PMT = -1750.7186 , N = 360

use rate funciton in Excel and multiply by 12

yield = 5.7664%


Related Solutions

Consider a mortgage loan of $300,000, to be amortized over thirty years with monthly payments. If...
Consider a mortgage loan of $300,000, to be amortized over thirty years with monthly payments. If the annual percentage rate on this mortgage is 4% : What is the monthly payment on this loan? What is the balance of this loan AFTER the 14th payment is made? How much of the 8th payment is allocated to interest? How much of the 19th payment is allocated to principal?
You obtain a loan of $150,000 at 5.875% amortized over thirty years with monthly payments.
You obtain a loan of $150,000 at 5.875% amortized over thirty years with monthly payments. You are required to pay closing costs and fees of 2.0% of the loan amount to the lender. What is the yield of the loan if paid off at the end of 5 years? 
You obtain a loan of $150,000 at 5.875% amortized over 30 years with monthly payments. You...
You obtain a loan of $150,000 at 5.875% amortized over 30 years with monthly payments. You are required to pay closing costs and fees of 2% of the loan amount to the lender. What is the yield of the loan if paid off at the end of 5 years?
A loan amount of L is amortized over six years with monthly payments (at the end...
A loan amount of L is amortized over six years with monthly payments (at the end of each month) at a nominal interest rate of i(12) compounded monthly. The first payment is 500 and is to be paid one month from the date of the loan. Each subsequent payment will be 1% larger than the prior payment. (a) If i(12) = 9%, find the principal repaid in the 25th payment. (b) If i(12) = 12%, find the amount of loan...
A loan is amortized over 7 years with monthly payments at a nominal interest rate of...
A loan is amortized over 7 years with monthly payments at a nominal interest rate of 9% compounded monthly. The first payment is $1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior payment. Calculate the outstanding loan balance immediately after the 68th payment is made.
Loan Amortization: A loan of $14 100.00 is amortized over 11 years by equal monthly payments...
Loan Amortization: A loan of $14 100.00 is amortized over 11 years by equal monthly payments at 5.4% compounded monthly. a) Find the outstanding balances after the payment 39 is done. b) Find the outstanding balances after the payment 129 is done. c) Find the amount of Final Payment and fill out the last row.
A loan is being amortized over​ n-years with monthly payments of​ $295.32. The rate of interest...
A loan is being amortized over​ n-years with monthly payments of​ $295.32. The rate of interest on the loan is j12=12%. The principal repaid in the 25th payment is​ $206.41.What is the size of the​ loan? ​
A loan is amortized over five years with monthly payments at an annual nominal interest rate...
A loan is amortized over five years with monthly payments at an annual nominal interest rate of 6% compounded monthly. The first payment is 1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
A mortgage of 198,000 is to be amortized by monthly payments over 22.5 years. If the...
A mortgage of 198,000 is to be amortized by monthly payments over 22.5 years. If the payments are mafe at the end of each month and interest is 8.75% compounded semi-amnually, what is the size of monthly payments?
Ali has a $35,000 student loan at 4.40% compounded monthly amortized over 10 years with payments...
Ali has a $35,000 student loan at 4.40% compounded monthly amortized over 10 years with payments made at the end of every quarter. a. What is the size of Ali's payments at the end of every quarter? b. What was the principal portion of payment 13? c. What was the size of Ali's' final payment?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT