You take out a 30-year mortgage for $70,000 at 9.45%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $

You take out a 30-year mortgage for $70,000 at 9.45%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $

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

We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $80,000 at 9.25%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
Suppose you take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…
you wish to purchase real property. the lender will give you a 250000 fixed rate 30 year mortgage at 3.5% per annum. suppose that before you can make any payments you receive a pay raise so you can pay an extra 200 per month with your normal payment. how many payments are required to fully amortize the loan assuming the extra 200 is paid each month?
You are planning on buying a new house and want to make sure you can afford the monthly payments. The house you picked will necessitate you borrow $300,000. You think you can get the following. mortgage terms: borrow $300,000 at a fixed quoted (nominal) annual rate of 3.775%; to be paid off in equal monthly payments over 15 years.Compute the required monthly payment, and prepare an amortization table, showing for each month the beginning balance, payment, payment applied to interest, payment applied to principal, and ending. balance. (Assume monthly compounding) (solution needs to be in excel)
Suppose you intend to purchase a house worth $239,900 with a 30-year fixed rate mortgage. You have a down payment of 15%. (a) How much are you planning to finance? (b) Find the monthly payment needed to amortize the loan, at a rate of 2.4% compounded monthly. (c) Approximately how much of the loan will remain after 12 years?
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
You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 10 years, and the nominal interest rate will be 8% with interest paid annually. 1: What will be the annual loan payment? 2: Construct Amortization Schedule Table.
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
You buy a rental property, taking out a 15 year loan with monthly payments and a mortgage rate of 4.7%. Your plan is to pay down the remaining balance after 7 years. How much will that balance be if the value of the loan is $250,000? (Answer to nearest dollar. HINT: you must find the payment before you can find the balance.)
Suppose that you take out a 40-year $175000 mortgage with an APR of 6%. You make payments for 3 years and then you consider refinancing the original loan. The new loan would have a term of 15 years, have and APR of 5.7% and be in the amount of the unpaid balance on the original loan. The administrative cost of taking out the second loan would be $1700. What are the monthly payments on the original loan? What would the monthly payment of the second loan be? What would the total amount you would pay if you continued with the original 40-year loan without refinancing? What would the total amount would you pay with the refinancing?
Suppose you want to buy a rent to own house worth P450,000. You made a down payment of 15% of the purchase price and take a 25 year mortgage for the balance. a. What is your down payment? b. What is your mortgage amount? c. What is the total interest charged over the life of the loan if your monthly payment is P2,200? Solve manually in a paper.
You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? how would i calculate this in excel?

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