In Excel Please show how to solve this and please show step by step how to solve to answer questions A. and B. . You borrow a Graduated Payment Mortgage (GPM) of $400,000 with monthly payments and 15-year term. The annual interest rate is 4%. The lender allows you to pay only 0.5 monthly PMT for the first 5 years and pay full monthly PMT thereafter. In other words, your payment factors are as follows: month 1-month 60: 50%; and month 61- month 180: 100%. Suppose that the origination cost of the loan is $5,000, please answer the following questions: A. What is your monthly payment for the first 5 years? B. What is your annual effective cost of the GPM if you hold the loan for an entire term?

In Excel Please show how to solve this and please show step by step how to solve to answer questions A. and B. . You borrow a Graduated Payment Mortgage (GPM) of $400,000 with monthly payments and 15-year term. The annual interest rate is 4%. The lender allows you to pay only 0.5 monthly PMT for the first 5 years and pay full monthly PMT thereafter. In other words, your payment factors are as follows: month 1-month 60: 50%; and month 61- month 180: 100%. Suppose that the origination cost of the loan is $5,000, please answer the following questions: A. What is your monthly payment for the first 5 years? B. What is your annual effective cost of the GPM if you hold the loan for an entire term?

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

Can you please show me how to do this question, please?
Can you please show the step-by-step solution. please do not skip steps. Explain how you got the answer you did
Please give me a specific solution don't use excel. 1. You took out a loan that must be repaid with level payments at the end of each year. The loan has an annual effective rate of interest of 6%. The outstanding balance at the end of the seventh year was $22,000 and the outstanding balance at the end of the tenth year was $18,000. What is your payment on the loan? Round your answers to two decimal places. 2.You take out a loan that must be repaid with level payments made at the end of each of the next 14 years. The loan has an annual effective rate of interest of 7%. You know that P8 = $854.50. Compute the following. Round your answers to two decimal places. a) Payment ? b) Loan Amount ?
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $989 per month, and the total finance charge is $9,504. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) Need Help? Read It Watch It Master 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: $
Suppose you secure a home improvement loan in the amount of $5,000 from a local bank. The loan officer gives you the following loan terms:• Contract amount = $5,000• Contract period = 24 months• Annual percentage rate = 12%• Monthly installment = $235 .37Shown is the cash flow diagram for this loan. Construct the loan payment schedule by showing the remaining balance, interest payment, and principal payment at the end of each period over the life of the loan.
Please explain each step, step by step
Suppose that you decide to borrow $15,000 for a new car. You can select one of the following loans, each requiring regular monthly payments. Installment Loan A: three-year loan at 6.3% Installment Loan B: five-year loan at 4.8% PA [¹-(1+] Use PMT= -nt7 to complete parts (a) through (c) below. a. Find the monthly payments and the total interest for Loan A. The monthly payment for Loan A is $. (Do not round until the final answer. Then round to the nearest cent as needed.)
Please answer
Give typing answer with explanation and conclusion Suppose your gross monthly income is $5,900 and your current monthly payments are $575. If the bank will allow you to pay up to 36% of gross monthly income (less current monthly payments) for a monthly house payment, what is the maximum loan you can obtain if the rate for a 30-year mortgage is 4.65%? (Round your answer to the nearest cent.)
Please show all steps and formulas in an excel spreadsheet to answer a. through g. using the information below! You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
Suppose you take out a $185,500 mortgage for 30 years at 5.15% interest. (a) Find the monthly payment on this mortgage. S (b) Fill out the first two rows of the amortization schedule below. Round your answers to the nearest dollar. Payment Number Interest Payment Principal Payment Balance of Loan 1 2 Question Help: D Video M Message instructor D Post to forum