excel7.Using a Spreadsheet to Calculate Mortgage Payments: What is the monthly payment on a $150,000, 30-year mortgage if the mortgage rate is 5.75 percent? 6.25 percent? 7.5 percent? 9 percent? (LG 7-4)PeriodsPresentInterestRateThe PaymentWill BeValue$150,00030 x 125.75%/12150,00030 x 126.25%/12150,000150,00030 x 1230 x 127.50%/129.00%/12$ 875.36923.581,048.821,206.93

Let's calculate the monthly payments for a $150,000, 30-year mortgage at different interest rates…

Answered: excel 7. Using a Spreadsheet to…

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

Let's assume you took out a $300,000, 30-year mortgage with an annual interest rate of 8% and monthly payments of $2,201.29. Because you have made 15 years worth of payments (that's 180 monthly payments = [15 x 12|) there are another 180 monthly payments left before your mortgage will be totally paid off. How much do you still owe on your mortgage? Activate Windows Go to Settings to activate Windows 豆 :Notes 7:31 12/17 Print Screen Sys Rq Soroll Lock Pause Break F6 F8 F9 F10 F11 F12
Use chart
You get a 7.125% mortgage loan with front-end loan charges of $3,800. Will your APR be: (a) less than 7.125% (b) exactly 7.125% (c) greater than 7.125%
hh. Subject :- Accounting
Consider a $100,000 30-year, fixed-rate mortgage with an annual interest rate of 5.50% and monthly payments. How much of the total expenses on mortgage payments go toward interest during the first three years (round to the nearest dollar)?$2, 540 $10, 220 $15,858 S4,274 $16, 167 $19, 172 $3,583
Intro You take out a 360-month fixed-rate mortgage for $100,000 with a monthly interest rate of 0.4%. Part 1 What is the monthly payment? 0+ decimals Submit
V4. A $200,000 30 year mortgage with a contract rate of 8.94%, $3000 closing costs (lawyer, appraisal, and transfer tax) and $1,000 in discount points (i.e mortgage setup fee). The monthly mortgage payment is determined to be $1600. what will be the effective borrowing rate if the borrower decides to pay off the loan at the end of year 8? Assume that the mortgage is based on monthly compounding.
*13.4.7 Find the monthly payment needed to amortize principal and interest for the fixed-rate mortgage. Use either the regular monthly payment formula or the given table Loan Amount Interest Rate $85,000 Term Real Estate Amortization Table 6% 20 years E Click the icon to view the Real Estate Amortization Table. Monthly payments to Repay Principal and Interest on a ST000 mortgage The monthly payment is $ (Round to the nearest cent as needed.) Term of Mortgage (years) Annual rate 5. 10 15 20 25 30 40 3.0% 17.96869 9.65607 6.90582 5.54598 4.74211 4.21604 3.57984 3.5% 18.19174 9.88859 7.14883 5.79960 5.00624 4.49045 3.87391 4.0% 18.41652 10.12451 7.39688 6.05980 5.27837 4.77415 4.17938 4.5% 18.64302 10.36384 7.64993 6.32649 5.55832 5.06685 4.49563 5.0% 18.87123 10.60655 7.90794 6.59956 5.84590 5.36822 4.82197 5.5% 19.10116 10.85263 8.17083 6.87887 6.14087 5.67789 5.15770 6.0% 19.33280 11.10205 8.43857 7.16431 6.44301 5.99551 5.50214 6.5% 19.56615 11.35480 8.71107 7.45573 6.75207 6.32068…
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
What interest rate would it take for a 30 year mortgage to buy a $415,000 house with a $2,000 monthly payment? 3. A) 3.636% 4. B) 4.078% 5. C) 4.276% 6. D) 4.897% N= 360
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.
Please show how to solve using an excel spreadsheet: Suppose you borrow $250,000 PLAM (Price Level Adjusted Mortgage) for 30 years, monthly payments with $6,000 origination cost. The mortgage rate is 6% with annual outstanding balance adjustments based on the following inflation information in the table attached.

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