An investor is looking for a loan for an investment property that he has found. He can afford a monthlypayment of $1,475. The interest rated quoted to him was 7.25%. He built the following table from thatinformation.A$74,049$125,638$161,580t51015a) A(5) =b) If the investment property cost $161,580, how many years must the investor make monthly payments?t202530A$186,620$204,066$216,220

A mortgage is a covered loan taken out to purchase a property, with the property itself acting as…

Answered: An investor is looking for a loan for…

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

You have been asked to determine whether it is beneficial for a homeowner to refinance their current mortgage loan. Their loan for 200,000 was originated three years ago and was a 30 year FRM with an interest rate of 7.5%. Their mortgage payment is currently $1,398.43. This loan now currently has 27 years remaining, and the homeowner is looking to refinance their current balance (i.e. the balance at the end of month 36) into a new 27 year FRM with an interest rate of 5.5%. How much will the homeowner save in interest over the 27 years remaining, assuming no prepayments? Round to the nearest dollar.
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
A young executive is going to purchase a vacation property for investment purposes. She needs to borrow $103,000.00 for 27 years at a 4.1% annual interest rate, with interest compounded monthly, and will make monthly payments of $526.17. (Round all answers to 2 decimal places.) Create an amortization table to answer the following: a) What is the unpaid balance after 11 months? $ 100410.01 b) Over the 11 months in part (a), how much total interest did she pay? S
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?.
What formula do I utilize to find out the annual net revenue I'll receive for a property? For example, If I were to purchase a commercial property for $8,950,000 with an interest rate of 3.5% and a term of 30 years. I put down 25% which is $2,237,500, which would make my loan amount equate to $6,712,500. This particular commercial real estate property has a NOI (Net Operating Income) of $494,040yr, the debt service is $361,705yr, and the cashflow is $132,335yr. Would my net revenue equate to $494,040yr or $132,335yr?
Suppose you took out a 25 year mortgage at 2.32% to purchase a home, making monthly payments of $2100. After 5 years and 6 months you are able to refinance for 20 years at 2.15%, making monthly payments of $1950. How much do you save on interest by refinancing?
the price of a house is $400,000. Then, you make a down payment of $130,000 and take a 30-year mortgage for the balance. (a) what is your down payment? (b) what is your mortgage ? (c) what is the total interest charged over the life of the loan if your monthly payment is 1350 dollars?
A property has a FMV of $7,500,000. If the property owner can only secure a loan with an LTV of 70%, a loan amortization of 30 years, and an interest rate of 8.125%, then a) What is the monthly payment for this loan? and b) What is the outstanding balance on the loan after eight years?
You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. Please show all steps and formulas in an excel spreadsheet. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
am. 08.
You bought a house for $1,000,000. You paid 20% as the down payment and financed the rest. The mortgage loan has 30 years maturity and 4% APR which is compounded monthly. Use Excel Spread sheet to amortize the loan and find out the monthly principle and interest payments through out the life of this loan. I need this on an excel spreadsheet
1. Assuming the cost of mortgage is $400,000, and the owner of the house makes a down payment of $40,000, with 8% interest rate and 10 years repayment plan. a. calculate the total amount of loan, monthly rate, number of payment periods, monthly payment, total interest paid, and amount borrowed. b. With the aid of what PMT function in a one variable condition, calculate monthly payment, total amount payable, total interest payable for: 12 yrs, 16 yrs, 20 yrs ,25 yrs, 30 yrs, 35 yrs mortgage.

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