•Assume that you have saved money for a down payment on your dream house, but you still need to borrow Php500,000 from your bank to complete the deal. The bank offers you a 5-year mortgage at an annual rate of 6%. a) Compute for the Monthly payment. b) Construct an Amortization schedule. (6 months

•Assume that you have saved money for a down payment on your dream house, but you still need to borrow Php500,000 from your bank to complete the deal. The bank offers you a 5-year mortgage at an annual rate of 6%. a) Compute for the Monthly payment. b) Construct an Amortization schedule. (6 months

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

A. Solve the following problems and show your complete solution. 1. Anna bought a diamond necklace worth P185,000. Securing 15% down payment, they agreed to pay the remaining for 1 year with 12% annual interest rate. a. How much is the down payment? b. How much is the mortgage loan? 00 c. How much is the monthly amortization? d. Create an amortization table. HRISTIA
3) Your father planned for your study at BUC and saved for 5 years before your registration OMR 1200 each year at Nizwa Bank. Suppose that the Interest Rate on such deposit was 11% annually. Questions: a. Set up the time line b. What is the FV of those payments?
if your bank approves a $300,000 mortagage for your new home, at an annual percentage rate of 4.5 % and with a monthly payment of $1800 What will be the remaining mortgage amount after you make 4 monthly payments
Watch the video and then solve the problem given below. Click here to watch the video. You are considering a loan with an annual rate of 8%. The mortgage is $130,000 with 180 monthly payments of $1242.35 for 15 years. Complete the first two months of the amortization table. (Simplify your answers. Round to the nearest cent as needed.) Payment number Interest payment Principal payment Balance of loan 1
You want to get a commercial real estate mortgage of $6875599. You are offered a monthly payment loan with 5.75% interest and a 25 year amortization schedule with a balloon payment at the end of 7 years. What will be your monthly mortgage payment? State your answer as a number rounded to two decimal points
7. Lisa has decided to purchase a seaside villa in Tobago and is considering borrowing $800,000 from a local bank. The 15 year mortgage would have an interest rate of 6% per annum. Monthly payments are expected to be made on the loan. Required: b) Prepare an Amortization Schedule in the form of a table showing monthly interest payment over the first 3 months of the loan. Please answer this question showing all working.
You plan to purchase a $160,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.75 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 20th payment c. Calculate the amount of interest and, separately, principal paid in the 150th payment d. Calculate the amount of interest paid over the life of this mortgage. (For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) a. Monthly payment b. Amount of interest Amount of principal C. Amount of interest Amount of principal d. Amount of interest paid Amount
Suppose a.home owner has an existing mortgage loan with these terms: remaining balance of Sh. 50,000, interest rate of 8% and remaining term of 10 years (monthly payments). The loan can be replaced by a loan at an interest rate of 6% at a cost of 8% of the outstanding loan amount Should the home owner refinance? What difference would it make if the home owner expecis to be in the home for only five more years?.
If Your bank _offers to lend y~u $100,000 at_ an 8.5% annual interest rate to start your new business. The terms reqwre you to amortize the loan with 10 equal end-of-year payments. How much interest would you be paying in Year 2?
K Erin took out a 15-year mortgage with an annual interest rate of 6% to purchase a house for $220,000 with a down payment of $20,000. Find the amount of the monthly payment needed to amortize this loan. The amount of the monthly payment needed to amortize this loan is $1687.71 (Round to the nearest cent as needed.)
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
As a graduating senior with a promising career in finance, Central Bank offers you a mortgage of $200,000. You may choose between a 30-year mortgage with an interest rate of 4.375% or a 15-year mortgage at 3.500%. Both interest rates are annual stated rates with interest compounded monthly. Assume that for 30-year mortgage, the bank requires you to pay 1% point. Compute an amortization table that shows the amount of interest you can report for taxes and amount of principal payment each year for each loan. Use two different ways to do it as we did in class: with and without using the functions PPMT and IPMT. PLEASE USE EXCEL and show functions.

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