dynamic investment calculator Dashboard
- Apr 26
- 6 min read
Project Abstract
This investment model is designed to be fully adaptable to client requirements. The current configuration is set to an investment amount of 3.5 million and an investment cycle of 8 quarters. Both parameters can be easily adjusted upon request, ensuring flexibility and responsiveness to diverse client objectives. All analyses and dashboards are dynamically structured to update instantly—requiring only the input of the desired investment amount and period—providing tailored insights in seconds.
the data used for this production is from 12 project with 63 unit, and it was built in 2023 but can easily be adjusted with the recent data.
Methodology
Data Sources (📊)
data was collected intently from different developers which the company was dealing with in regular sales.
Tools and Technologies (🔧)
Excel was used as a data base data was stored after collecting form different sources.
and as we see power bi "my favorite tool" was used to analyze and visualize the data after it was prepared on Excel.
Workflow (🛠️)
data was collected including every project with different unit types and historical prices for each type.
the pattern for price increase was detected from the price changing during the quarters.
the prediction was made after studding the pricing pattern.
Introduction
This project presents a dynamic investment model built to deliver fast, data‑driven insights across multiple real‑estate opportunities. Using a consolidated dataset of 12 projects and 63 units, the model is preconfigured with an invested amount of EGP 3.50M and an investment cycle of 8 quarters, both of which can be adjusted instantly to reflect client targets. All analytical outputs and visual dashboards update automatically when the investment amount or period is changed, enabling tailored scenario analysis in seconds.
The model synthesizes three complementary views — Overview, Investment by Quarter, and ROI & Cash Flow — to give stakeholders a clear picture of projected prices, profit, return on investment, and cash‑flow dynamics. It highlights comparative performance across projects, surfaces high‑return opportunities, and separates rate‑of‑return metrics from cash‑flow volumes so users can evaluate both profitability and liquidity.
Designed for portfolio presentations and client discussions, this tool streamlines decision making by converting configurable inputs into actionable visualizations and concise summary metrics. It is ideal for investors and advisors who need rapid, repeatable scenario testing and a professional, presentation‑ready output for reports or LinkedIn sharing.
SLIDE 1: OVERVIEW
Description:
Portfolio overview dashboard showing 8 investment projects across 22 units with total invested capital of EGP 3.50M. Left side displays key metrics (invested amount, project count, unit count). Center shows total cost for investment cycle by project (horizontal bar chart) ranging from EGP 1.5M (Veda) to EGP 3.4M (Valory Antonyadus/Muruj). Right side shows total projected ROI by project (vertical bar chart) with percentages displayed below—highest ROI is Valory Antonyadus (85.3%), lowest is Veda (27.5%). Bottom table details each project's unit count, yearly increase rate, installment years, predicted price, and profit amount. Model was built in 2023 for real investment scenario planning.
Key Insights:
Portfolio Composition & Diversification:
8 projects, 22 units, EGP 3.50M capital allocation
Project costs vary 2.3x (Veda EGP 1.5M vs. Valory/Muruj EGP 3.4M each)
Portfolio weighted toward higher-cost premium projects (Valory, Muruj, Palm Hills = 71% of capital)
ROI Performance Variability:
ROI spread: 27.5% (Veda) to 85.3% (Valory Antonyadus)—3.1x difference
Top performers: Valory Antonyadus (85.3%), Sawary 11 (65%), Sawary Saluja (60.5%)
Underperformers: Veda (27.5%), Parco (27.5%)—despite equal capital, lower returns
Average Yearly Appreciation vs. ROI Correlation:
Valory Antonyadus: 52.66% yearly increase → 85.3% ROI (highest efficiency)
Palm Hills Alexandria: 37.68% yearly increase → 55.4% ROI (moderate efficiency)
Veda: Not shown in table but chart indicates weakest performance
Insight: Higher appreciation rates don't guarantee proportional ROI—installment years and payment structure matter
Investment Cycle Structure:
Average installment period: 4-7 years across projects
Longer installment periods (Palm Hills = 7 years) generate lower annual ROI but still profitable
Shorter cycles (Valory = 4 years) maximize ROI velocity
Strategic Allocation Insight:
Portfolio is not equally weighted—deliberate concentration in high-ROI projects
3 projects (Valory, Sawary 11, Sawary Saluja) generate 60%+ ROI each = core portfolio
Veda/Parco (27.5% each) serve as diversification/stability anchors, not growth drivers
Summary: "Dynamic investment portfolio model allocating EGP 3.50M across 8 Alexandria residential projects (22 units total). Portfolio demonstrates strategic concentration in high-appreciation assets (Valory Antonyadus, Sawary projects) generating 60-85% ROI, balanced with lower-volatility holdings (Veda, Parco) at 27.5% ROI. Model accounts for variable installment periods (4-7 years) and project-specific appreciation rates (36-52% annually), optimizing capital allocation for blended risk-return profile."
SLIDE 2: QUARTERLY PERFORMANCE (INV BY QUARTER)
Description:
Quarterly investment performance dashboard filtered to show 3 projects (Muruj, Palm Hills Alexandria, Valory Antonyadus) which are meeting the conditions, over 8-quarter investment cycle. Left panel shows invested amount (EGP 3.50M) and investment cycle duration (8 quarters). Center displays number of quarters applicable to investment cycle (all three projects = 8.0 quarters each, indicating full-cycle commitment). Top-right shows predicted price by end of investment cycle: Valory Antonyadus (EGP 6.32M, highest), Palm Hills Alexandria (EGP 5.40M), Muruj (EGP 5.12M). Center-right shows predicted profit by project: Muruj (EGP 2.91M, 52.4% ROI), Palm Hills Alexandria (EGP 1.92M, 55.4% ROI), Valory Antonyadus (EGP 1.76M, 85.3% ROI). Bottom table breaks down each project: 1 unit each, average total investment ~EGP 3.4-3.47M, monthly increase rates (6.55-10.67%), predicted price increases (52-85%), and final predicted prices.
Key Insights:
Quarterly Growth Rate Variability:
Valory Antonyadus: 10.67% average monthly increase (highest velocity)
Palm Hills Alexandria: 6.92% monthly increase (moderate)
Muruj: 6.55% monthly increase (steady but slower)
Insight: Valory's 10.67% monthly rate compounds to 85.33% predicted increase—aggressive appreciation
Price Appreciation vs. Absolute Profit Disconnect:
Valory: 85.33% increase → EGP 1.76M profit (highest % but not highest cash)
Muruj: 52.39% increase → EGP 2.91M profit (lower % but higher absolute cash)
Why: Initial investment base differs—Muruj's larger base (EGP 3.36M) generates more absolute profit despite lower % gain
8-Quarter Cycle Universality:
All three projects align to 8-quarter investment cycle (standardized model assumption)
Real-world implication: Investor commits to 2-year holding period across all assets
Uniformity simplifies cash flow planning but ignores project-specific delivery timelines
ROI Efficiency Analysis:
Palm Hills Alexandria: 55.4% ROI (best balance of appreciation + absolute profit)
Muruj: 52.4% ROI with highest cash profit (EGP 2.91M)—best for liquidity-focused investors
Valory: 85.3% ROI but lower cash (EGP 1.76M)—best for % return maximization
Investment Concentration Risk:
Each project = 1 unit only (no diversification within project)
Total investment ~EGP 3.4M per project = high single-asset exposure
Risk: If one project delays or underperforms, significant capital at risk
Monthly Appreciation Compounding Effect:
6.55% monthly (Muruj) → 52.39% cumulative over 8 quarters
10.67% monthly (Valory) → 85.33% cumulative
Insight: Small differences in monthly rates (4% spread) compound to 33% spread in final ROI
Summary: "Quarterly performance analysis for 3-unit subset of portfolio demonstrates ROI variance driven by monthly appreciation rates (6.55-10.67%) compounding over 8-quarter investment cycle. Valory Antonyadus achieves highest percentage ROI (85.3%) via 10.67% monthly appreciation, while Muruj generates highest absolute profit (EGP 2.91M) due to larger investment base. Model reveals strategic trade-off: percentage maximization (Valory) vs. cash profit maximization (Muruj) vs. balanced efficiency (Palm Hills at 55.4%)."
SLIDE 3: ROI & CASH FLOW
Description:
ROI and cash flow projection dashboard for 3 projects (Muruj, Palm Hills Alexandria, Valory Antonyadus) with EGP 3.50M invested over 8-quarter cycle. Top-left shows yearly ROI pie chart: Valory Antonyadus (42.66%), Palm Hills Alexandria (27.68%), Muruj (26.20%). Top-right shows half-yearly ROI: Valory (21.33%), Palm Hills (13.84%), Muruj (13.10%). Center-right displays total half-yearly cash flow (all three projects ~EGP 1.5-1.6M each). Bottom-right shows total yearly cash flow (all three projects ~EGP 2.1-2.2M each). Bottom table details: 3 units total, average yearly increase 42.18%, average installment period 5.67 years, average yearly ROI EGP 694,347, and average half-yearly profit rate 32.18%.
Key Insights:
ROI Decomposition: Yearly vs. Half-Yearly:
Valory yearly ROI (42.66%) = 2× half-yearly ROI (21.33%)—linear compounding
Palm Hills yearly (27.68%) vs. half-yearly (13.84%)—consistent doubling pattern
Muruj yearly (26.20%) vs. half-yearly (13.10%)—same pattern
Insight: No acceleration/deceleration detected—appreciation is steady, not seasonal
Cash Flow Uniformity Across Projects:
Half-yearly cash flow: EGP 1.5-1.6M per project (minimal variance)
Yearly cash flow: EGP 2.1-2.2M per project (also uniform)
Conclusion: Despite different ROI percentages (26-42%), absolute cash flows converge
Why: Investment amounts and payment structures are balanced to normalize cash needs
Average Portfolio Metrics:
42.18% average yearly increase across 3 projects
5.67 years average installment period
EGP 694,347 average yearly ROI per project
32.18% average half-yearly profit rate
Insight: Portfolio-level returns smooth out individual project volatility
Cash Flow Planning Insight:
Predictable half-yearly cash out: ~EGP 1.5M per project
Predictable yearly cash out: ~EGP 2.1M per project
Investor implication: Can forecast liquidity needs 2 years ahead with confidence
Uniform cash flow enables reinvestment strategy (use Muruj cash to fund new projects)
ROI Contribution Imbalance:
Valory contributes 42.66% of yearly portfolio ROI (disproportionately high)
Muruj + Palm Hills combined = 53.88% (rest of portfolio)
Strategic insight: Valory is the "anchor asset"—drives majority of returns despite being 1 of 3 projects
Half-Yearly Profit Rate (32.18%) Context:
Annualized: ~64% ROI (double the half-yearly rate)
Compares favorably to Egyptian inflation (~15-20%) and USD appreciation (~5-10%)
Positioning: Real estate significantly outpaces inflation as hedge
Summary: "Cash flow and ROI projection model reveals balanced liquidity profile across 3-project subset: uniform half-yearly cash flows (EGP 1.5-1.6M per project) despite ROI variance (26-42%). Valory Antonyadus contributes 42.66% of total portfolio yearly ROI, establishing it as anchor asset. Average portfolio metrics (42.18% yearly appreciation, 32.18% half-yearly profit rate) demonstrate real estate significantly outpaces Egyptian inflation (15-20%), validating asset class as effective hedge. Predictable cash flow structure enables strategic reinvestment planning over 8-quarter cycle."
Amazing