Question

In: Finance

Sheet 5: Mortgage Payments This is a simplified version of a payment calculator. The purpose is...

Sheet 5: Mortgage Payments

This is a simplified version of a payment calculator. The purpose is to use the payment (PMT) function to illustrate various monthly payments on a mortgage loan with a 4% interest rate.

  • Insert the PMT function in cell B16.
    • Rate: The interest rate for the loan divided by the number of payments per year
    • Nper: The total number of payments for the loan
    • Pv: The principal
    • Use absolute cell references when entering the Rate and Nper
  • Copy the formula in cell B16 through B26 using the Fill Handle
  • Insert the PMT function in cell C16.
    • Rate: The interest rate for the loan divided by the number of payments per year
    • Nper: The total number of payments for the loan
    • Pv: The principal
    • Use absolute cell references when entering the Rate and Nper
  • Copy the formula in cell C16 through C26 using the Fill Handle
  • Format column A as Currency
  • Save your file
USA Loan Company
Monthly Payment Table
Percentage Rate 4.000%
Mortgage in Years
15 Years 30 Years
X X
12 Payments/Yr 12 Payments/Yr
180 360
Payments Payments
Principal 15 Years 30 Years
150000
175000
200000
225000
250000
275000
300000
325000
350000
375000
400000

Solutions

Expert Solution

The solution is as shown below:

Formulas:


Related Solutions

The following items are a simplified version of very recent balance sheet data relating to the...
The following items are a simplified version of very recent balance sheet data relating to the Federal Reserve Bank of the United States of America: Currency at issue $1,650bn Accounts due to foreign central banks and others $83bn Loans to private banks $130bn Government securities $3,850bn Government balance $407bn Exchange settlement account balances $1,867bn Net foreign currency reserves (and gold) $37bn Other assets $30bn Classify each of the above individually as either an asset or a liability of the Federal...
USING MATLAB: A simple mortgage calculator that will output the monthly payment, the remaining balance, and...
USING MATLAB: A simple mortgage calculator that will output the monthly payment, the remaining balance, and so on. years=30; annual_rate=0.04; % 2.75% annual rate house_value=500,000; downpayment=3.5; % 25% down and plot results
For this part you will need to use your calculator. What is the Monthly Mortgage Payment...
For this part you will need to use your calculator. What is the Monthly Mortgage Payment on a $125,000 Home with an 80% LTV with a 5% Interest Rate, 30-Year Fixed Rate Mortgage (Constant Payment Mortgage)? $536.82 What is the Monthly Mortgage Payment on a $125,000 Home with an 80% LTV with a 6% Interest Rate, 30-Year Fixed Rate Mortgage (Constant Payment Mortgage)? $599.55 How much more with the person with the mortgage in question #8 pay over the person...
Monthly Mortgage Payments The average monthly mortgage payment including principal and interest is 982 in the...
Monthly Mortgage Payments The average monthly mortgage payment including principal and interest is 982 in the United States. If the standard deviation is approximately 180 and the mortgage payments are approximately normally distributed, find the probabilities. Use a TI-83 Plus/TI-84 Plus calculator and round the answers to at least four decimal places. (a) (a)The selected monthly payment is more than $1400 (a)The selected monthly payment is more than 1400 P(Z>1400)= 2) Prison Sentences The average prison sentence for a person...
What is the monthly payment for a $800,000 mortgage for the first 119 payments that is...
What is the monthly payment for a $800,000 mortgage for the first 119 payments that is due in 10 years, has a 25 year amortization, at 5% interest? What is the amount of the 120th payment? Please use Excel and explain. Make sure that formulas are set to show in excel sheet.
Ann obtains a 30 year Fixed Rate, Constant Payment Mortgage with monthly payments for $4,500,000 at 4.38%. Her monthly payment is $20,000. What is the balloon payment for this mortgage after 360 payments are made?
Ann obtains a 30 year Fixed Rate, Constant Payment Mortgage with monthly payments for $4,500,000 at 4.38%. Her monthly payment is $20,000. What is the balloon payment for this mortgage after 360 payments are made?
Calculating the Payment for a Constant Payment Mortgage (CPM) $100000 Mortgage 5% Interest 20 Years Monthly...
Calculating the Payment for a Constant Payment Mortgage (CPM) $100000 Mortgage 5% Interest 20 Years Monthly Payments If he wants to pay off the loan after 8 years, what would be the outstanding balance on the loan? Present Value Method
Use your calculator to determine​ (1) the current mortgage payment​ (2) the total interest​ paid, (3)...
Use your calculator to determine​ (1) the current mortgage payment​ (2) the total interest​ paid, (3) the payment after the first adjustment and​ (4) the maximum payment for the following ​$156,000​, ​30-year mortgage. Assume that the initial interest rate is 6.90 percent. d. Fixed for 5 years and then adjustable every 5​ years, 3 percent per​ period, 6 percent lifetime cap. Assume also that rates increase at least 3 percent per year until they reach the lifetime cap and rates...
Use your calculator to determine​ (1) the current mortgage payment​ (2) the total interest​ paid, (3)...
Use your calculator to determine​ (1) the current mortgage payment​ (2) the total interest​ paid, (3) the payment after the first adjustment and​ (4) the maximum payment for each of the following ​$156,000​, ​30-year mortgages. Assume that the initial interest rate is 6.90 percent. a. Annually​ adjustable, 1 percent per​ year, 5 percent lifetime cap. Assume also that rates increase at least 1 percent per year until they reach the lifetime cap and rates never again drop below the lifetime...
Use your calculator to determine​ (1) the current mortgage payment​ (2) the total interest​ paid, (3)...
Use your calculator to determine​ (1) the current mortgage payment​ (2) the total interest​ paid, (3) the payment after the first adjustment and​ (4) the maximum payment for the following ​$193,300​, ​30-year mortgage. Assume that the initial interest rate is 6.50 percent. a. Annually​ adjustable, 1 percent per​ year, 5 percent lifetime cap. Assume also that rates increase at least 1 percent per year until they reach the lifetime cap and rates never again drop below the lifetime cap for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT