Please give Step by Step AnswerOtherwise i give DISLIKE !! Use this information to analyze weather it is better to own or rent the property with the following financing and rent options. Create an Excel Model to analyze the trade-offs. Property infoPurchase price $1,000,000 Buying transaction fees: 15% of purchase price Initial rent: $85000/yr Rental growth rate: 5% Property appreciation rate: 6% Insurance: $4000/yr Maintenance: $4000/yrExpense growth: 3.5% Transaction fees for future sale: 12% of sale price Marginal tax rate: 30% Property tax: 2.0% of current property appraised value LTV: 80% Interest rate: 7% Loan Term: 30 yrLoan type: Annual pay CPM fully amortizing Tax exclusions: First $500,000 of gain on sale

Part 2: Explanation:Step 1: Determine the cash flows for owning the property. a. Calculate the…

Answered: Use this information to analyze weather…

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 real estate investor is considering the purchase of an apartment building that currently provides income of $30,000 and is expected to grow in income by 3% for the next 4 years. You would receive income from today, year 0, through year 4. At the end of year 4, they expect to sell the property for $800,000. The investor has a discount rate of 6%. How much should an investor be willing to pay for this property? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.Answer completely.You will get up vote for sure.
Zenith Investment Company is considering the purchase of an office property. It has done an extensive market analysis and has estimated that based on current market supply or demand relationships, rents, and its estimate of operating expenses, annual NOI will be as follows: Year NOI 1 $ 1,030,000 2 1,030,000 3 1,030,000 4 1,210,000 5 1,260,000 6 1,310,000 7 1,349,000 8 1,389,170 A market that is currently oversupplied is expected to result in cash flows remaining flat for the next three years at $1,030,000. During years 4, 5, and 6, market rents are expected to be higher. It is further expected that beginning in year 7 and every year thereafter, NOI will tend to reflect a stable, balanced market and should grow at 3 percent per year indefinitely. Zenith believes that investors should earn a 12 percent return (r) on an investment of this kind.Required: a. Assuming that the investment is expected to produce NOI in years 1 to 8 and is expected to be owned for…
Please show in excel with formulas. Athena Investment Company is considering the purchase of an office property. After a careful review of the market and the leases that are in place, Athena believes that next year’s cash flow will be $100,000. It also believes that the cash flow will rise in the amount of $7,800 each year for the foreseeable future. It plans to own the property for at least 10 years. Based on a review of sales of properties that are now 10 years older than the subject property, Athena has determined that cap rates are in a range of 0.10. Athena believes that it should earn an IRR (required return) of at least 11 percent. Required: a. What is the estimated value of this office property (assume a 0.10 terminal cap rate)? b. What is the current, or going-in, cap rate for this property?
Consider a new residential income producing property for sale to a potential investor. The sale price for the property is Sh. 1,250,000 of which building is Sh. 1 million and balance land. Building is depreciated over 50 years. Rent is estimated at Sh. 200,000 in the first year and is expected to grow at 3% p.a. thereafter. Vacancies and collection losses are expected to be 10% of rent. Operating expenses will be 31.5% of rent. A 70% mortgage loan can be obtained at 11% p.a. payable monthly for 30 years. The property is expected to appreciate in value at 3% per year and is expected to be owned for five years and then sold. Tax rate for both income and capital gains is 30%. Required Calculate the expected after tax IRR on equity invested. Is this investment viable if required rate of return is 15%?
Assuming that you would like to buy an equipment for your small business. Using the information below, calculate the Rate of Return and the Pay Back Period for the investment. After presenting your calculations, explain why you think this will (or will not) be a good investment. Here are the numbers: Cost of the investment is $100,000 Estimated depreciable life of investment is 5 years Annual depreciated charge is $15,000 Estimated average profit over depreciable life is $10,000.
A client has requested advice on a potential investment opportunity involving an income-producing property. She would like you to determine the internal rate of return of the investment opportunity based on the following information: expected holding period: years; end of first year NOI estimate: $113,900; NOI estimates in subsequent years will grow by 5 % per year; price at which the property is expected to be sold at the end of year 5: $1,615,205.22; current market price of the property: $1,475,667.71. A. 8.6% B. 9.86% C. 10% D -15.3%
You are considering buying an old warehouse that you will convert into anoffice building for rental. Assuming that you will own the property for 10 years, how much would you be willing to pay for the old house now given the following financial data?I. Remodeling cost at period 0 = $550,000;II. Annual rental income = $800,000;Ill. Annual upkeep costs (including taxes)= $80,000;lV. Estimated net property value (after taxes) at the end of 10 years = $2,225,000;V The time value of your money (interest rate)= 8% per year.(a) $4,445,770(b) $5,033,400(c) $5,311,865(d) $5,812,665
Zenith Investment Company is considering the purchase of an office property. It has done an extensive market analysis and has estimated that based on current market supply/demand relationships, rents, and its estimate of operating expenses, annual NOI will be as follows:Year ............................................................... NOI1 ......................................................... $1,000,0002 ........................................................... 1,000,0003 ........................................................... 1,000,0004 ........................................................... 1,200,0005 ........................................................... 1,250,0006 ........................................................... 1,300,0007 ........................................................... 1,339,0008 ........................................................... 1,379,170 A market that is currently oversupplied is expected to result in cash flows remaining…
Zenith Investment Company is considering the purchase of an office property. It has done an extensive market analysis and has estimated that based on current market supply/demand relationships, rents, and its estimate of operating expenses, annual NOI will be as follows:Year NOI1 $1,000,0002 1,000,0003 1,000,0004 1,200,0005 1,250,0006 1,300,0007 1,339,0008 1,379,170A market that is currently oversupplied is expected to result in cash flows remaining flat for the next three years at $1,000,000. During years 4, 5, and 6, market rents are expected to be higher. It is further expected that beginning in year 7 and every year thereafter, NOI will tend to reflecta stable, balanced market and…
An apartment building is generating income of $250000. Maintenance expenses total 40% of this income and vacancy loss is 12% of income. The market supports a capitalization rate of 12.75%. Using the income capitalization approach, what is the years to purchase? Please show formula for solution without using financial calculator or excel. I am using a texas instruments calculator.
You are considering buying an old warehouse that you will convert into anoffice building for rental. Assuming that you will own the property for 10 years, how much would you be willing to pay for the old house now given the following financial data?(i) Remodeling cost at period 0 = $550,000;(ii) Annual rental income = $800,000;(iii)Annual upkeep costs (including taxes)= $80,000;(iiii) Estimated net property value (after taxes) at the end of 10 years =$2,225,000;(iiiii)The time value of your money (interest rate)= 8% per year.(a) $4,445,770(b) $5,033,400(c) $5,311,865(d) $5,812,665
You have an opportunity to acquire a property from First Capital Bank. The bank recently obtained the property from a borrower who defaulted on his loan. First Capital is offering the property for $200,000. If you buy the property, you believe that you will have to spend (1) $10,500 on various acquisition-related expenses and (2) an average of $2,000 per monthduring the next 12 months for repair costs, etc., in order to prepare it for sale. Because First Capital Bank would like to sell the property as soon as possible, it is willing to provide $180,000 in financing at 8 percent interest for 12 months payable monthly (interest only). Your market research indicates that after you repair the property, it may sell for about $225,000 at the end of one year. Furthermore, you will probably have to pay about $3,000 in fees and selling expenses in order to sell the property at that time. If you wanted to earn a 20 percent return compounded monthly, do you believe that this would be a good…

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