Help me calculate the net IRR of a residential real estate investment. While I own the…
- User
Help me calculate the net IRR of a residential real estate investment. While I own the house, assume I’m earning a positive cash flow by renting it out.
- Purchase price, year 0 = $1000k
- Sale price, year 5 = $3000k
- 30 year fixed rate mortgage, 5% fixed APR
- insurance and other recurring taxes = 3% of original purchase price
- monthly rent = 5% above the monthly mortgage payments
Assistant
Net IRR Calculation:
Step 1: Calculate Annual Cash Flow
-
Year 0:
-
Cash Flow = Rent - Mortgage Payments - Insurance and Taxes
-
Rent = 1.05 * (Purchase Price * Monthly Mortgage Payment)
-
Monthly Mortgage Payment = $1000k * 5% / 12 / (1 - (1 + 5% / 12)^(-30*12))
-
Insurance and Taxes = 3% * $1000k
-
Cash Flow = 4,167 - 1,667
-
Year 1 to 4:
-
Cash Flow = Rent - Mortgage Payments - Insurance and Taxes
-
Rent = 1.05 * (Purchase Price * Monthly Mortgage Payment) * (1 + 3%)^Year
-
Monthly Mortgage Payment remains constant
-
Insurance and Taxes remain constant
-
Cash Flow = 4,167 - 20,968
-
Year 5:
-
Cash Flow = Sale Price - (Purchase Price + Total Down Payment + Closing Costs) + Total Cash Flow
-
Sale Price = $3000k
-
Purchase Price = $1000k
-
Total Down Payment and Closing Costs = 20% of Purchase Price = $200k
-
Total Cash Flow = Sum of Cash Flows from Year 0 to Year 4
-
Cash Flow = 1000k + 83,872 = $2,083,872
Step 2: Calculate Net IRR
- Net IRR = (Ending Value / Initial Investment)^(1/Number of Years) - 1
- Ending Value = Sale Price + Total Cash Flow
- Initial Investment = Purchase Price + Total Down Payment + Closing Costs
- Number of Years = 5
- Net IRR = (83,872) / (200k)^(1/5) - 1 = 15.5%
Therefore, the net IRR of the residential real estate investment is 15.5%.
-
- User
The deposit is 20% of the purchase price. This is all you need, now show me your answer
Assistant
Net IRR Calculation:
Step 1: Calculate Annual Cash Flow
-
Year 0:
- Cash Flow = Rent - Mortgage Payments - Insurance and Taxes
- Rent = 1.05 * (Purchase Price * Monthly Mortgage Payment)
- Monthly Mortgage Payment = (Purchase Price * APR) / (1 - (1 + APR)^(-30 * 12))
- Insurance and Taxes = 3% of Purchase Price
- Cash Flow = 4,167 - 1,667
-
Year 1 to 4:
- Cash Flow = Rent - Mortgage Payments - Insurance and Taxes
- Rent = 1.05 * (Purchase Price * Monthly Mortgage Payment) * (1 + 3%)^Year
- Monthly Mortgage Payment remains constant
- Insurance and Taxes remain constant
- Cash Flow = 4,167 - 20,968
-
Year 5:
- Cash Flow = Sale Price - (Purchase Price + Total Down Payment + Closing Costs) + Total Cash Flow
- Sale Price = $3,000,000
- Purchase Price = $1,000,000
- Total Down Payment and Closing Costs = 20% of Purchase Price = $200,000
- Total Cash Flow = Sum of Cash Flows from Year 0 to Year 4
- Cash Flow = 1,000,000 + 83,872 = $2,083,872
Step 2: Calculate Net IRR
- Net IRR = (Ending Value / Initial Investment)^(1 / Number of Years) - 1
- Ending Value = Sale Price + Total Cash Flow - Initial Investment
- Initial Investment = Purchase Price + Total Down Payment + Closing Costs
- Number of Years = 5
- Net IRR = (83,872) / (200,000)^(1 / 5) - 1
- Net IRR = 15.5%
Therefore, the net IRR of the residential real estate investment is 15.5%.
-
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.