Exam 19: Investment Decisions: NPV and IRR

Given the following information, calculate the NPV for this property. Initial cash outflow: $200,000, Discount rate: 15%, CF for year 1: $25,876, CF for year 2: $23,998, CF for year 3: $23,013, CF for year 4: $22,105, CF for year 5: $144,670.

Changes in the discount rate used to complete net present value analysis can have a significant impact on the estimated value of the investment and therefore affect the overall investment decision. As the required internal rate of return (IRR) increases, the net present value will:

To overcome the potential shortcomings of single-year decision making metrics, many investors in real estate also perform multiyear discounted cash flow (DCF) valuation. DCF valuation differs from the single-year ratio analysis in all of the following ways EXCEPT:

Determine the net present value (NPV) of an investment decision to purchase a property for $90,000 that will generate annual cash flows of $10,000 per year for eight years and sell for $80,000 at the end of the eight year holding period, if the appropriate discount rate is 10%? (Note: assume payments are made at end of year)

Given the following information regarding an income producing property, determine the after tax internal rate of return (IRR). Expected Holding Period: 5 years; 1ˢᵗ year Expected BTCF: $30,656; 2ⁿᵈ year Expected BTCF: $33,329; 3ʳᵈ year Expected BTCF: $36,082; 4ᵗʰ year Expected BTCF: $38,918; 5ᵗʰ year Expected BTCF: $41,839; 1ˢᵗ year Expected Tax Liability: $7,645; 2ⁿᵈ year Expected Tax Liability: $8,658; 3ʳᵈ year Expected Tax Liability: $9,708; 4ᵗʰ year Expected Tax Liability: $10,798; 5ᵗʰ year Expected Tax Liability: $6,951; Estimated Before Tax Equity Reversion at end of year 5: $343,674; Expected Taxes Due on Sale at end of year 5: $32,032; Required equity investment: $241,163

Net present value (NPV) is interpreted using the following decision rule: The investor will purchase the property as long as the NPV is:

Given the following information, calculate the appropriate after-tax discount rate. Tax rate on comparable risk investment: 35%, Investor's before-tax opportunity cost: 12%, Capitalization rate: 8%.

The internal rate of return (IRR) on a proposed investment is the discount rate that makes the net present value of the investment:

Given the following information, calculate the going-out cap rate. Estimated holding period: 5 years, NOI for year 1: $120,000, NOI for year 5: $150,000, NOI for year 6: $155,250, Expected sale price at end of year 5: $1,350,000.

Given the following expected cash flow stream, determine the NPV of the proposed investment in an income producing property and determine whether or not the investment should be pursued. Investment Horizon: 5 years; Expected Yearly Cash Flow in each of the next five years: $127,628. Expected Sale Price at end of 5 years: $1,595,350; Opportunity Cost of Investment 6%; Current Market Price of Property: $1,750,000

Given the following information regarding an income producing property, determine the after tax net present value (NPV). Expected Holding Period: 5 years; 1ˢᵗ year Expected BTCF: $30,656; 2ⁿᵈ year Expected BTCF: $33,329; 3ʳᵈ year Expected BTCF: $36,082; 4ᵗʰ year Expected BTCF: $38,918; 5ᵗʰ year Expected BTCF: $41,839; 1ˢᵗ year Expected Tax Liability: $7,645; 2ⁿᵈ year Expected Tax Liability: $8,658; 3ʳᵈ year Expected Tax Liability: $9,708; 4ᵗʰ year Expected Tax Liability: $10,798; 5ᵗʰ year Expected Tax Liability: $6,951; Estimated Before Tax Equity Reversion at end of year 5: $343,674; Expected Taxes Due on Sale at end of year 5: $32,032; Required equity investment: $241,163; After Tax Opportunity Cost: 11.2%

The use of financial leverage when investing in real estate is a double-edged sword. While increased leverage may allow the investor to "purchase" higher expected returns, the "price" of doing so is an increase in which of the following risks?