Case 01Real estateInvestment planning
Serviced Apartment Development: Room Configuration Analysis
Financial model and project coordination for a serviced apartment development, comparing six- and eight-room configurations while design approval and construction pricing were being finalised.
RoleExecutive Assistant to CEO
CompanyKAN Investment
Period2026, ongoing
Horizon10-year cash flow
Responsibilities
- 1Financial model. Five-month construction budget, funding schedule and ten-year cash flow for each option.
- 2Investment metrics. NPV, IRR, payback and terminal value for both configurations.
- 3Cost and contractor review. Turnkey and structural quotations; 34 contractors and supervisors tracked.
- 4Project readiness. Permits, design dependencies and operations set-up across 12 milestones.
Evidence · option comparison
Model dashboardVND bn
| Metric | 6 rooms | 8 rooms |
|---|---|---|
| Total investment | 3.69 | 4.20 |
| Year 1 operating cash flow | 0.18 | 0.32 |
| NPV (12% discount rate) | −0.59 | 0.83 |
| IRR | 9.45% | 14.82% |
| Payback year | 10 | 9 |
Result
9.45% → 14.82%Projected IRR, 6 vs 8 rooms
+VND 510mAdditional investment for the eight-room option
+VND 138mAdditional Year 1 operating cash flow
ExcelNPV / IRRCapex budgetingProcurement