Financial Modeling

developed a comprehensive financial model for a real estate investment company to evaluate the performance of its property portfolio and support strategic decision-making. The model included:

Revenue projections based on rental income, occupancy rates, and market trends

Operating expense forecasting including maintenance, utilities, and property management fees

Cash flow analysis with monthly breakdowns and scenario testing (best case, base case, worst case)

Discounted Cash Flow (DCF) valuation to estimate the present value of future returns

Sensitivity analysis to assess the impact of interest rate changes and inflation on profitability

The model was built using Excel and Power BI, integrated with ERP data exports, and designed to be user-friendly for finance and executive teams. It helped the client identify underperforming assets, optimize budget allocations, and prepare for investor presentations.

Tools Used: Excel, IFRS standards