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.
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).
Create your account
Always verify citation format against your institution’s current style guide requirements.