Suppose you take out a 45-year $125,000 mortgage with an APR of 6%. You make payments for 5 years (60 monthly payments) and then consider refinancing the original loan. The new loan would have a term of 15 years, have an APR of 5.2%, and be in the amount of the unpaid balance on the original loan. (The amount you borrow on the new loan would be used to pay off the balance on the original loan.) The administrative cost of taking out the second loan would be $2500. Use the information to complete parts (a) through (e) below.a. What are the monthly payments on the original loan?$____ (Round to the nearest cent as needed.)

The given problem can be solved using PMT function in excel. PMT function computes installment…

pose you take out a 45-year $125,000 mortgage with an APR of 6%. You make payments for 5 y PR of 5.2%, and be in the amount of the unpaid balance on the original loan. (The amount you b ond loan would be $2500. Use the information to complete parts (a) through (e) below. /hat are the monthly payments on the original loan? (Round to the nearest cent as needed)

pose you take out a 45-year $125,000 mortgage with an APR of 6%. You make payments for 5 y PR of 5.2%, and be in the amount of the unpaid balance on the original loan. (The amount you b ond loan would be $2500. Use the information to complete parts (a) through (e) below. /hat are the monthly payments on the original loan? (Round to the nearest cent as needed)

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

Help O You take out a 30-year $150,000 mortgage loan with an APR of 12% and monthly payments. In 11 years, you decide to sell your house and pay off the mortgage. What is the principal balance on the loan? Note: Round the monthly loan payment to 2 decimal places when computing the answer. Round your answer to 2 decimal places. Principal balance on the loan Save & Exi Submit
Find the monthly payment for a 289,500.00 home with 20% down payment. The terms of the mortgage are 8.5% for 25 years. Note:Find the down payment and use a 'Monthly Payment of Mortgage' table. 8 Extra: Find the monthly payment for that home for any combination of terms: 8.5% & 9.5%, 20 & 25 years, 20% & 25% down payment. Compare with given.
Use PMT = to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $181,000. The bank requires a 20% down payment and three points at the time of closing. The cost of 1- the horme is financed with a 30-year fixed-rate mortgage at 7.5%. 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? $ (Round to the nearest dollar as needed.) d. Find the monthly payment (excluding escrowed taxes and insurance). $ (Round to the nearest dollar as needed.) e. Find the total cost of interest over 30 years. $ (Round to the nearest dollar as needed.) Next MacBook Air 8884 %23 24 % & * 2 3 4 5 6 8. 9. R. T Y D K F. S'
Loan Basics Inputs Present value 325,000 Interest rate/year Number of years 4.00% 30 Present Value using a Time Line Year 10 15 20 25 30 Beginning Principal Balance Payment Interest component Principal component
A fully amortizing mortgage is made for $112,000 at 6.5 percent interest. Required: If the monthly payments are $1,060 per month, when will the loan be repaid? (Round up your answer to the nearest whole number)
Use an amortization table to solve the problem. Round to the nearest cent. A 7000 debt is to be amortized in 15 equal payments of 504.87 at 1% interest per month on the unpaid balance. What is the unpaid balance after the second payment? Show your table belove include columns for each of the following Loan Balance Payment Interest amount amount principle decrease new balance
(a) Find the monthly mortgage payment on a $170000 15-year mortgage if the interest rate on the loan is 3.81%. (b) How much will you pay in interest over the life of the loan if you pay the minimum monthly payment each month?
Erindale Bank offers you a $58,000, four-year term loan at 7.0% annual Interest. What will your annual loan payment be? (Do not round Intermediate calculations. Round the final answer to 2 decimal places.) Annual loan payment HURD $ SAN RACE CL
You want to take a $172260 mortgage at j2 = 11.59 % and can afford topay up to $5030 per quartely. What repayment period in the whole years should you request ? What will be your payment year to repay mortgage in calculatednumber of years ?
You borrow $300,000 to buy a house; if the annual interest rate is 4% and the term of the loan is 20 years, what is the annual payment required to retire the mortgage loan? Complete the loan amortization schedule for the first payment: Payment Interest Portion Principal Portion Ending Balance #1
Show the first two lines of the amortization table for your new home mortgage, assuming a sellingprice of $118,500, a down payment of 6%, annual interest rate 5.3% compounded monthly, andmonthly payments on a 30-year mortgage. (Please help by solving through calculator)
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 >

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

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

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