You decide to buy a $210,000 home. If you make a 30% down payment, you can geta 35-year mortgage at 4%, but if you make a 16% down payment, you can get a20-year mortgage at 7.5%. Which is the better option? Round final answers to twodecimal places. Do not round intermediate calculations.Formula for Computing Monthly Payments on a MortgageP(G)1 (116)"R =R- regular monthly paymentP = amount financed, or principalT= rale wrillen as a decimaln= number of payments per year1 = riumber of yearsThe total interest that would be paid on the 35-year loan with a 30% down paymentis SThe total interest that would be paid on the 20-year loan with a 16% down paymentis SThe better option would be the 30% down payment.

The PMT function or concept can be used to determine the periodic payments required to accumulate a…

Answered: You decide to buy a $210,000 home. If…

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

Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission. $808.28 $853.18 $527.78
In terms of paying less in interest, which is more economical for a $140,000 mortgage: a 30-year fixed-rate at 7.5% or a 15-year fixed-rate at 7%? How much is saved in interest? Use the following formula to determine the regular payment amount. PMT= PA [¹-(1+) -nt7 Select the correct choice below and fill in the answer box within your choice. (Do not round until the final answer. Then round to the nearest thousand dollars.) O A. The 15-year 7% loan is more economical. The buyer will save approximately $ OB. The 30-year 7.5% loan is more economical. The buyer will save approximately $ in interest. in interest.
Suppose you are buying your first condo for $250,000, and you will make a $7,500 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations but you must list the inputs used such as N, PV, FV, etc. O $1,000.00 O $1,088.93 O $1,122.61
also find the monthly payment
You are considering purchasing a new home. You will need to borrow $280,000 to purchase the home. A mortgage company offers you a 20-year fixed rate mortgage (240 months) at 9% APR (0.75% month). If you borrow the money from this mortgage company, your monthly mortgage payment will be closest to: O A. $2,015 В. $3,527 C. $4,030 D. $2,519
Suppose you are buying your first home for $144,000, and you have $17,000 for your down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a 6.40% nominal interest rate, with the first payment due in one month. What will your monthly payments be? Group of answer choices $831.93 $857.64 $753.30 $714.27 $794.39
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: $
es You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30-year mortgage for 80 percent of the $3,200,000 purchase price. The monthly payment on this loan will be $17,300. a. What is the APR on this loan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What is the EAR on this loan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) a. Annual percentage rate b. Effective annual rate % % 8 # Next >
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 show how to solve this unsing excel and please show all formulas in the spreadsheet. You decide to buy a house with price of $500,000, You put 20% down payment and consider a 15-year fixed rate mortgage to pay the remaining balance. The lender offers you three choices of the mortgage with monthly payments shown in the table as a., b., and c. Assume that the origination cost is $8,000. A. If the loan will be outstanding for 15 years, what is the effective cost for each choice? Which choice is most ideal? explain? B. Which mortgage choices are not properly priced? explain?
Q18 Say that you purchase a house for $206,000 by getting a mortgage for $185,000 and paying a $21,000 down payment. If you get a 25-year mortgage with an interest rate of 6 percent, what are the monthly payments? (Do not round intermediate calculations and round your final answer to 2 decimal places.)PAYMENT? What would the loan balance be in ten years? (Round the payment amount to the nearest cent but do not round any other interim calculations. Round your final answer to 2 decimal places.)LOAN BALANCE? If the house appreciates at 2 percent per year, what will be the value of the house in ten years? (Do not round intermediate calculations and round your final answer to 2 decimal places.)FUTURE VALUE? How much of this value is your equity? (Do not round intermediate calculations and round your final answer to 2 decimal places.)Equity?
PA Use PMT= to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $217,000. The bank requires a 20% down payment and three points at the time of closing. The cost of the home is financed with a 30-year fixed-rate mortgage at 7%. Complete parts (a) through (e) below. a. Find the required down payment. $ b. Find the amount of the mortgage. c. How much must be paid for the three points at closing? S (Round to the nearest dollar as needed.) d. Find the monthly payment (excluding escrowed taxes and insurance). S (Round to the nearest dollar as needed.) e. Find the total cost of interest over 30 years. (Round to the nearest dollar as needed.)

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