Rental Property Investment: NPV and IRR Scenario Analysis
This paper evaluates a $10,000 rental land investment across three financial scenarios that differ in rental duration and final sale price. Using net present value (NPV), internal rate of return (IRR), and related cost-effectiveness methods at a 12% discount rate, the analysis determines which scenario offers the greatest return. Scenario A rents for three years and sells in Year 4; Scenario B extends the rental through Year 5 and sells at a reduced price in Year 6; Scenario C rents for two years and sells at a premium in Year 3. Results consistently favor the longer-rental, lower-sale-price model, with Scenario B producing the highest NPV and IRR, while Scenario C yields a negative NPV.
- Introduction and Investment Overview: Defines the $10,000 land investment and 12% discount rate
- Scenario Definitions and Cash Flows: Details cash flows for all three rental scenarios
- Net Present Value Analysis: NPV results compared across three scenarios
- Internal Rate of Return Analysis: IRR values validate NPV rankings for each scenario
- Conclusions: Longer rental period yields best investment return
✍️ How to write this paper — guide, tools & examples ▾
What makes this paper effective
- The paper clearly defines all assumptions upfront — purchase price, discount rate, and the trade-off logic between rental duration and resale value — making the analysis transparent and easy to follow.
- Presenting three distinct scenarios in structured tables before the analysis allows readers to compare inputs at a glance and follow the financial logic without confusion.
- The conclusion draws directly from quantitative results (NPV and IRR values) rather than general claims, grounding the recommendation in evidence.
Key academic technique demonstrated
The paper demonstrates multi-criteria financial decision analysis: rather than relying on a single metric, it cross-validates findings using both NPV and IRR. This approach is standard in capital budgeting and engineering economics, and the agreement between the two methods strengthens the conclusion that Scenario B is optimal.
Structure breakdown
The paper opens with a problem statement and defines the shared investment parameters. It then specifies each scenario's cash flow structure in narrative and tabular form. The analytical sections address NPV first, then IRR, each reporting numerical results for all three scenarios before interpreting them. A brief conclusion synthesizes both methods into a clear investment recommendation. The structure mirrors a standard financial feasibility report.
Introduction and Investment Overview
This paper examines an investment in a rental real estate property. The investment involves a one-time purchase of $10,000 in land that can subsequently be rented for $3,500 per year over a period of several years. At the end of the rental period, the investor aims to sell the land. The longer the rental period, the more the land will degrade and, as a consequence, the lower its resale value will be at the end of the period.
The scenarios considered in this analysis therefore reflect a trade-off: a longer rental period generates more annual income but results in a lower final sale price, while a shorter rental period preserves land value but reduces total rental income. This paper examines three distinct scenarios, each analyzed using net present value (NPV), internal rate of return (IRR), and related cost-effectiveness and benefit-cost instruments. The conclusion identifies which scenario is optimal for the investor.
An important parameter common to all calculations is the discount rate, which is set equal to the cost of capital — that is, the rate at which the investor would borrow funds to finance the property purchase. For all scenarios in this paper, the discount rate is assumed to be 12% (0.12). All calculations were performed in Excel, with a separate worksheet created for each scenario.
Scenario Definitions and Cash Flows
Scenario A
The investment in the rental property is $10,000, recorded as a negative cash flow at Year 0. The property is rented for three years, generating $3,500 per year in Years 1, 2, and 3. In Year 4, the property is sold for $3,500 — a price reflecting the gradual depreciation that occurs during the rental period.
Scenario B
The investment in the rental property is again $10,000 at Year 0. The property is rented for five years, generating $3,500 per year in Years 1 through 5. The extended rental period results in greater wear on the property, so it can only be sold for $1,500 in Year 6, which is recorded as the cash flow for that year.
Scenario C
The investment in the rental property is $10,000 at Year 0. In this scenario, the property is rented for only two years, generating $3,500 in Years 1 and 2. Because the property has experienced less wear, it commands a higher resale price: it is sold in Year 3 for $4,500, which is recorded as the Year 3 cash flow.
Net Present Value Analysis
Net present value takes into account the present value of all future cash flows that a project is expected to generate. For each year in each scenario, the projected cash flow is discounted at the cost of capital (12%) to obtain its present value. The sum of all discounted future cash flows is then compared to the initial project cost of $10,000 (shown as −$10,000 in the calculations). A positive NPV indicates a profitable investment; a negative NPV indicates a loss in present-value terms.
The NPV can be calculated manually by dividing each year's cash flow by 1.12 raised to the power of the corresponding year (since 112% = 100% + the 12% discount rate), summing those present values, and subtracting the $10,000 initial investment. In this analysis, the built-in Excel NPV function was used for each scenario. The results are as follows:
These results are both conclusive and informative. Scenario B is the best-performing scenario, with Scenario A in second place and Scenario C not only ranking third but also producing a negative NPV — meaning the investment would be unprofitable under those conditions. Scenario B features the longest rental period (five years of income) and the lowest resale value, yet it generates the highest NPV by a significant margin. Scenario C, despite its higher resale price, yields a negative NPV because the shorter exploitation period does not generate sufficient total cash flow to justify the initial outlay. The intermediate case — Scenario A — confirms the trend: the longer the rental period, the more profitable the investment, even when the final sale price is lower.
Bibliography
Halpern, Paul et al. (1998). Managerial Finance. Dryden.
Main, M.A. Project Economics and Decision Analysis, Volume I: Deterministic Models.
Hazen, G.B. (2003). A new perspective on multiple internal rates of return. The Engineering Economist, 48(2).
Always verify citation format against your institution’s current style guide requirements.