Based on Exhibit 7-7, what would be the monthly mortgage payments for each of the following situations? (Round your answers to 2decimal places.)a A $160.000, 15-year loan at 4.5 percent.b. A $215,000, 30-year loan at 5 percent.c. A $190,000, 20-year loan at 6 percent.+

Step 1: Step 2: Step 3: Step 4:

Answered: Based on Exhibit 7-7, what would be the…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? How do I round time value factor and final answers to 2 decimal places? What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment?
Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round time value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? a. $61,000, 15-year loan at 7.50 percent. b. $151,000, 30-year loan at 8.00 percent. c. $88,000, 20-year loan at 6.50 percent. d-1. Longer mortgage terms mean a d-2. For increase in mortgage rate Monthly Mortgage Payment monthly payment. monthly payment is required.
Based on Exhibit 9.9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round tin value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? a $120,000, 15-year loan at 5 percent b. $86,000, 30-year loan at 4.5 percent. c$105,000, 20-year loan at 4 percent d-1. Longer mortgage terms mean a d-2 For increase in mortgage rate Monthly Mortgage Payment monthly payment monthly payment is required
Based on Exhibit 9-9 or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round time value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? a $119,000, 15-year loan at 6.00 percent. b. $103,000, 30-year loan at 8.00 percent. c. $96,000, 20-year loan at 5.00 percent. d-1. Longer mortgage terms mean a d-2. For increase in mortgage rate Monthly Mortgage Payment [lower higher monthly payment. monthly payment is required. Term Rate 3.0% 30 years $ 4.22 25 years 20 years 15 years $ 4.74 $ 5.55 $ 6.91 3.5 4.49 5.01 5.80 7.15 4.0 4.77 5.28 6.06 7.40 4.5 5.07 5.56 6.33 7.65 5.0 5.37 5.85 6.60 7.91 5.5 5.68 6.14 6.88 8.17 6.0 6.00 6.44 7.16 8.44 6.5 6.32 6.75 7.46 8.71 7.0 6.65 7.07 7.75 8.99 7.5 6.99 7.39 8.06 9.27 8.0 7.34 7.72 8.36 9.56
Please eolve this question on excell and show formulas please.
i need the answer quickly
Manshuk
4 (5) Assume a 30-year mortgage loan for $250,000 for 30 years at an annual rate of 6%. What would be your fixed annual and monthly payments? Enter the inputs into the appropriate cells 5 in column B and set this up so that your answers are displayed as positive values. Round all values to two places after the decimal point. 6 (6) For the loan in #5 , prepare the first two monthly payment rows of the amortization table. 7 8 LOAN AMOUNT 9 TERM OF LOAN N YEARS 10 ANNUAL INTEREST RATE 11 TERM OF LOAN IN MONTHS 12 MONTHLY INTEREST RATE 13 FIXED LOAN PAYMENT (ANNUAL) 14 FIXED LOAN PAYMENT (MONTHLY) 15 16 17 18 19 20 21 22 AMORTIZATION TABLE PAYMENT 1 2 BEGINNING BALANCE FIXED PAYMENT INTEREST PRINCIPAL ENDING BALANCE
Based on Exhibit 7-8, what would be the monthly mortgage payments for each of the following situations? (Round mortgage payment factors and final answers to 2 decimal places. Omit the "$" sign in your response.) a) A $123,000, 15-year loan at 6.0 percent APR compounded semi - annually b) A $165, 000, 25- year loan at 7.5 percent APR compounded semi- annually c) A $68, 000, 20-year loan at 7.5 percent APR compounded semi - annually.
Complete the following table, which shows the monthly payments on a $100,000, 30-year mortgage at the interest rates shown. Use this information to answer the following questions. (Round your answers to the nearest cent.) Amount ofMortgage ($) InterestRate (%) MonthlyPayment ($) 100,000 3 421.60 100,000 4 100,000 5 100,000 6 100,000 7 100,000 8 733.76 (a) What is the difference in monthly payments between a $100,000, 30-year mortgage secured at 7%/year and one secured at 3%/year? $ (b) Use the table to calculate the monthly mortgage payments on a $170,000 mortgage at 4%/year over 30 years. $ Use the table to calculate the monthly mortgage payments on a $40,000 mortgage at 4%/year over 30 years.
6. Based on Exhibit 7-7, or use of a financial calculator, what would be the monthly mortgage payments for each of the following situations? (LO7.3) a. A $160,000,15-year loan at 4.5 percent. b. A $215,000, 30-year loan at 5 percent. c. A $190,000, 20-year loan at 6 percent.
Based on Exhibit 7-8, what would be the monthly mortgage payments for each of the following situations? (Round mortgage payment factors and final answers to 2 decimal places. Omit the "$" sign in your response.) a) A $85,000, 15-year loan at 9.5 percent APR compounded semi-annually b) A $171,000, 25-year loan at 4.5 percent APR compounded semi-annually c) A $129,000, 20-year loan at 9.0 percent APR compounded semi-annually.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

Based on Exhibit 7-7, what would be the monthly mortgage payments for each of the following situations? (Round your answers to 2 decimal places.) a A $160.000, 15-year loan at 4.5 percent. b. A $215,000, 30-year loan at 5 percent. c. A $190,000, 20-year loan at 6 percent. +