Fiat LuxNew Deal Analysis

$
SF

$

GPR: $360.0K/yr

EGI: $342.0K/yr

$500.0K down, $1.50M loan

yrs

yrs

$6,250/yr

Total at Exit (10yr):$62.5K

IRR

39.77%

Equity Multiple

11.18x

Cash-on-Cash (Yr 1)

27.85%

NPV

$2.6M

Gross Potential Rent

$360.0K

Effective Gross Income

$342.0K

Operating Expenses

$75.9K

21.08% of GPR

Net Operating Income

$266.1K

Going-In Cap Rate

13.30%

Exit Cap Rate

6.00%

Price per SF

$80

Purchase price per square foot

Terminal Value

$5.7M

Down Payment

$500.0K

Loan Amount

$1.5M

75.00% LTV

Annual Debt Service

$113.8K

$9.5K/month

DSCR

2.34

Healthy coverage

Year 1 Cash Flow

$152.3K

Total Closing Costs

$47.0K

Total Equity Required

$547.0K

Down payment + closing costs

Price per Unit

$100.0K

Purchase price per unit

Data Quality Assessment

1 warning
Cap Rate Assumption: Exit cap rate (6.00%) is lower than going-in (13.30%). Cap rate compression assumption may be optimistic.

These checks help identify assumptions that may need review. They do not invalidate the analysis.

Assumptions Summary

24 assumptions

Review all inputs and assumptions driving your investment analysis

Sensitivity Analysis

See how IRR changes when vacancy rate varies from baseline

Change in Vacancy Rate
-5%
-2.5%
+0%
+2.5%
+5%
+7.5%
+10%
42.7%
+2.9%
41.2%
+1.5%
39.8%
38.3%
-1.5%
36.8%
-3.0%
35.3%
-4.5%
33.8%
-6.0%
Worst Case
33.8%
Base Case
39.8%
Best Case
42.7%

Cash Flow Projections

Visualize your investment performance over the hold period ($ US Dollar)

Investors

Add investors and their ownership percentages. Total must equal 100%.

Total Ownership: 100.0%

Total Equity Required: 547.0K

Allocated SF: 0 SFof 25,000 SF

Market Rate: $1.20/SF/month

Investment

$547.0K

IRR

33.17%

Equity Multiple

5.79x

Cash-on-Cash

26.71%

Total Cash Flow

$1.8M

Share of Sale

$1.3M

Total Return

$2.6M

Principal Payback Date

3.5 years from closing

Closing Costs

One-time costs incurred when purchasing the property

15.0K
10.0K
5,000
3,500
7,500
2,500
3,000
500
Total Closing Costs47.0K

Notes