# Navon Africa — Chart Recreation Prompts for Claude in Excel These prompts reference the actual sheets and data in `navon_africa_main-financial-model_v1.xlsx`. Copy-paste each prompt into Claude in Excel to recreate the chart. **CRITICAL RULE FOR ALL CHARTS:** Every single data value in the chart data tables must be a **formula linking back to the source sheet cell** (e.g. `='Consolidated P&L'!D13`), NOT a hardcoded number. This ensures the charts update automatically when the model changes. --- ## Chart 1 — Revenue Build by Segment (Stacked Bar) > Create a stacked column chart on a new sheet called "Revenue Build Chart". > > **IMPORTANT: Do NOT hardcode any numbers.** Every value in the chart's data range must be a formula referencing the source cell on the original sheet (e.g. `='Consolidated P&L'!D8`). The chart must update automatically if the model changes. > > **Data source:** Use the "Consolidated P&L" sheet. > - X-axis: Years 2026–2035 — link to row 4, columns D through M (e.g. `='Consolidated P&L'!D4` for 2026). > - Stacked segments (each a separate series, all linked via formulas): > - **Colocation** — link to 'Consolidated P&L'!D8:M8 > - **Cloud CPU Simulation** — link to 'Consolidated P&L'!D9:M9 > - **Cloud GPU Inference** — link to 'Consolidated P&L'!D10:M10 > - **Quantum Cybersecurity** — link to 'Consolidated P&L'!D12:M12 > - The sum of these equals GROUP REVENUE in row 13. > > **Chart type:** Stacked column chart. Stack order bottom-to-top: Colocation (largest base), Cloud CPU, Cloud GPU, Quantum Cyber. > > **Colors:** Navy (#1B2A4A) for Colocation, Teal (#2E8B8B) for Cloud CPU, Emerald (#2D6A4F) for Cloud GPU, Gold (#C4A35A) for Quantum Cyber. > > **Line overlay:** Add a line on a secondary axis linking to EBITDA Margin % from 'Consolidated P&L'!D26:M26, formatted as percentage. Line color: white or light grey, dashed. > > **Formatting:** Y-axis in $M with abbreviated labels. Chart title: "Group Revenue Build ($M)". Legend at bottom. Light grey gridlines. White background. Data labels showing total revenue on top of each stacked bar. --- ## Chart 2 — Capex Waterfall by Category > Create a waterfall chart on a new sheet called "Capex Waterfall Chart". > > **IMPORTANT: Do NOT hardcode any numbers.** Build a small data table on the new sheet where every value is a formula linking to the source cell on "Capex & Financing" (e.g. `='Capex & Financing'!I6`). The chart must update automatically if the model changes. > > **Data source:** Create a data table on the new sheet that pulls values via formulas from "Capex & Financing" sheet, column I (2031). Each row should have a label and a formula: > - Land & Site Preparation → `='Capex & Financing'!I6` > - Power Infrastructure → `='Capex & Financing'!I7` > - Network & Fibre → `='Capex & Financing'!I8` > - Civil Works → `='Capex & Financing'!I9` > - Water Infrastructure → `='Capex & Financing'!I10` > - Logistics & Shipping → `='Capex & Financing'!I11` > - Security Systems → `='Capex & Financing'!I12` > - Capitalised OPEX → `='Capex & Financing'!I13` > - DC Infrastructure Subtotal → `='Capex & Financing'!I14` (this is a subtotal anchor bar) > - Cloud Server Racks → `='Capex & Financing'!I18` > - TOTAL CAPEX → `='Capex & Financing'!I23` (this is the final total anchor bar) > > **Chart type:** Waterfall chart. Individual categories as incremental bars building up. Subtotal and Total as anchor/total bars. > > **Colors:** Teal (#2E8B8B) for DC infrastructure items, Emerald (#2D6A4F) for Cloud Racks, Dark navy (#1B2A4A) for total/subtotal anchor bars. > > **Formatting:** Y-axis in $M. Value labels on each bar. Chart title: "2031 Capex Breakdown ($M)". Connector lines between bars. White background, minimal gridlines. --- ## Chart 3 — Financing Structure (Debt vs Equity by Year) > Create a stacked bar chart on a new sheet called "Financing Chart". > > **IMPORTANT: Do NOT hardcode any numbers.** Every value must be a formula referencing the source cell (e.g. `='Capex & Financing'!D27`). The chart must update automatically if the model changes. > > **Data source:** Use the "Capex & Financing" sheet. Either reference the ranges directly in the chart series, or create a linked data table on the new sheet. > - X-axis: Years from 'Capex & Financing'!D4:M4 > - Series 1: **New Debt Drawn** — link to 'Capex & Financing'!D27:M27 > - Series 2: **New Equity Required** — link to 'Capex & Financing'!D28:M28 > > **Chart type:** Stacked column chart. Debt on bottom, Equity on top. > > **Colors:** Navy (#1B2A4A) for Debt (60%), Gold (#C4A35A) for Equity (40%). > > **Line overlay:** Add a line for **Cumulative Capex** linking to 'Capex & Financing'!D24:M24 on a secondary axis. Line color: Red (#C0392B), solid. > > **Formatting:** Y-axis in $M. Chart title: "Annual Financing — 60:40 Debt/Equity ($M)". Legend at bottom. Data labels showing values on each segment. White background. --- ## Chart 4 — Sensitivity Heatmap (WACC vs Exit Multiple) > Create a formatted heatmap table on a new sheet called "Sensitivity Heatmap". > > **IMPORTANT: Do NOT hardcode any numbers.** Every cell in the heatmap table must be a formula linking back to the "Sensitivity" sheet (e.g. `='Sensitivity'!B5` for the first data cell). Row and column headers must also be linked via formulas (e.g. `='Sensitivity'!A5` for the first WACC label, `='Sensitivity'!B4` for the first exit multiple label). This ensures the heatmap updates if the sensitivity analysis changes. > > **Data source — Table 1:** > - Row headers (WACC rates): link to 'Sensitivity'!A5:A11 > - Column headers (Exit multiples): link to 'Sensitivity'!B4:H4 > - Data values (Enterprise NPV $M): link to 'Sensitivity'!B5:H11 > > **Format:** This should be a formatted Excel table, NOT a chart. > > **Conditional formatting / heatmap:** Apply a 3-color gradient scale: > - Dark green (#2D6A4F) for highest values > - Amber (#F39C12) for mid values > - Red (#C0392B) for lowest values > > **Formatting:** > - Header row: Dark navy (#1B2A4A) background with white bold text > - Header column (WACC): Dark navy background with white bold text > - The base case cell (WACC 15%, Exit 12×) should have a thick black border to highlight it > - All values formatted as "$#,##0" with "M" suffix > - Title row: "Enterprise NPV ($M) — WACC vs Exit Multiple" > - Subtitle: link the base case value via formula: ="Base case: WACC 15%, Exit 12× → quot;&TEXT('Sensitivity'!D8,"#,##0")&"M" > > **Table 2 (below Table 1):** > - Row headers: link to 'Sensitivity'!A15:A19 > - Column headers: link to 'Sensitivity'!B14:F14 > - Data values (MOIC): link to 'Sensitivity'!B15:F19 > - Same heatmap coloring (green=high, red=low) > - Highlight base case cell (Colo $4.0M, Cloud $9.7M) with thick border > - Title: "Seed MOIC — Colo Rate vs Cloud Rate (Phase 1 Exit 2031)" --- ## Chart 5 — Consolidated P&L Summary (Grouped Bars + Margin Line) > Create a clustered column chart on a new sheet called "P&L Summary Chart". > > **IMPORTANT: Do NOT hardcode any numbers.** All chart series must reference the source sheet ranges directly (e.g. `='Consolidated P&L'!D13:M13`), or if you create a data table on the new sheet, every cell must be a formula linking back to the source. > > **Data source:** Use the "Consolidated P&L" sheet. > - X-axis: Years from 'Consolidated P&L'!D4:M4 > - Series (all linked via formulas): > - **Group Revenue** — 'Consolidated P&L'!D13:M13 > - **Group OPEX** — 'Consolidated P&L'!D23:M23 > - **Group EBITDA** — 'Consolidated P&L'!D25:M25 > > **Chart type:** Clustered (grouped) column chart. > > **Colors:** Navy (#1B2A4A) for Revenue, Slate grey (#7B8D9E) for OPEX, Emerald (#2D6A4F) for EBITDA. > > **Line overlay:** Add EBITDA Margin % linking to 'Consolidated P&L'!D26:M26 as a dashed line on a secondary axis. Line color: Gold (#C4A35A). Secondary axis formatted as percentage (0%–100%). > > **Formatting:** Y-axis in $M. Chart title: "Consolidated P&L — Revenue, OPEX & EBITDA ($M)". Legend at bottom. Phase labels from row 5 as secondary x-axis labels or as text annotations if possible. White background, light grey gridlines. --- ## Chart 6 — Free Cash Flow Waterfall > Create a waterfall chart on a new sheet called "FCF Waterfall Chart". > > **IMPORTANT: Do NOT hardcode any numbers.** Build a small data table on the new sheet where every value is a formula linking to the correct source sheet and cell. The chart must update automatically if the model changes. > > **Data source:** Create a data table on the new sheet that pulls 2031 values (column I) via formulas from multiple sheets. Each row should have a label and a formula: > - **Group Revenue** → `='Consolidated P&L'!I13` (green, anchor start) > - **DC/Cloud OPEX** → `=-'Consolidated P&L'!I20` (red, show as negative) > - **Quantum Cyber Costs** → `=-'Consolidated P&L'!I21` (red, show as negative) > - **Quantum Cyber Overhead** → `=-'Consolidated P&L'!I22` (red, show as negative) > - **= Group EBITDA** → `='Consolidated P&L'!I25` (navy subtotal anchor) > - **Interest Charge** → `=-'Debt Schedule'!I11` (red, show as negative) > - **Total Capex** → `=-'Capex & Financing'!I23` (red, show as negative) > - **= Free Cash Flow** → `='NPV & Returns'!I9` (navy total anchor) > > **Chart type:** Waterfall chart. > > **Colors:** Green (#2D6A4F) for revenue/inflows, Red (#C0392B) for costs/outflows, Dark navy (#1B2A4A) for anchor bars (EBITDA subtotal, FCF total). > > **Formatting:** Y-axis in $M. Value labels on each bar. Chart title: "2031 Cash Flow Bridge ($M)". Connector lines between bars. White background. --- ## Chart 7 — Investor KPI Dashboard > Create a KPI dashboard layout on a new sheet called "KPI Dashboard". > > **IMPORTANT: Do NOT hardcode any numbers.** Every metric value must be a formula linking to the source cell. For example, "2035 Group EBITDA" should be `='Consolidated P&L'!M25`, NOT the number 655.6. This ensures the dashboard updates automatically if the model changes. > > **Data source:** Create a structured grid on the new sheet. For each metric, put the label in one cell and the value in an adjacent cell as a FORMULA: > > | Metric | Formula for Value Cell | > |--------|----------------------| > | Total Raise (Seed) | `='Cover'!C10` | > | Investor Stake | `='Cover'!C11` | > | 2035 Group EBITDA | `='Consolidated P&L'!M25` | > | 2035 Group Revenue | `='Consolidated P&L'!M13` | > | EBITDA Margin (2035) | `='Consolidated P&L'!M26` | > | Total Capex (9yr) | `='Capex & Financing'!M24` | > | Debt : Equity | "60 : 40" (this one can be static text) | > | Exit EV @ 12× (2035) | `='Equity Waterfall'!M19` | > | Seed MOIC @ 12× (2035) | `='Equity Waterfall'!M29` | > | Phase 1 Exit MOIC (2031) | `='Equity Waterfall'!I29` | > | Enterprise NPV | `='NPV & Returns'!I19` | > | WACC | 15% (static, or link to Assumptions if stored there) | > | Interest Coverage (2035) | `='Debt Schedule'!M14` | > | Debt/EBITDA (2035) | `='Debt Schedule'!M15` | > | MW Deployed (2035) | `='DC-Cloud P&L'!M7` | > > **Layout:** Create a grid of metric cards (5 columns × 3 rows). Each card should have: > - Metric name (bold, 10pt, dark navy text) > - Current value (large, 18pt, bold) — must be a FORMULA, not a typed number > - A small note or comparison (e.g. a formula like `="vs "&TEXT('Consolidated P&L'!H25,"$#,##0.0")&"M in 2030"`) > > **Color coding:** > - Green (#2D6A4F) background accent for strong metrics (MOIC, EBITDA margin, coverage ratios above threshold) > - Gold (#C4A35A) for valuation metrics (NPV, Exit EV) > - Navy (#1B2A4A) for structural metrics (Capex, Debt:Equity, MW) > - Red (#C0392B) accent if any metric is below threshold (e.g. interest coverage below 3×) > > **Optional sparklines:** For key metrics, add Excel sparklines referencing the full 2026–2035 time series: > - Group Revenue sparkline → `='Consolidated P&L'!D13:M13` > - Group EBITDA sparkline → `='Consolidated P&L'!D25:M25` > - MW Deployed sparkline → `='DC-Cloud P&L'!D7:M7` > - EBITDA Margin sparkline → `='Consolidated P&L'!D26:M26` > > **Title:** "NAVON AFRICA — Key Investment Metrics". White background. --- ## Chart 8 (Bonus) — Scenario Comparison (Bear / Base / Bull) > Create a grouped bar chart on a new sheet called "Scenario Chart". > > **IMPORTANT: Do NOT hardcode any numbers.** All chart series must reference the "Scenarios" sheet ranges directly, or if you create a helper data table, every cell must be a formula (e.g. `='Scenarios'!D13`). > > **Data source:** Use the "Scenarios" sheet. > - X-axis: Years from 'Scenarios'!D4:M4 > - Three series for Group EBITDA across scenarios (all linked via formulas): > - **Conservative** — 'Scenarios'!D13:M13 > - **Base Case** — 'Scenarios'!D21:M21 > - **Bull Case** — 'Scenarios'!D29:M29 > > **Chart type:** Clustered column chart (3 bars per year). > > **Colors:** Slate grey (#7B8D9E) for Conservative, Navy (#1B2A4A) for Base Case, Emerald (#2D6A4F) for Bull Case. > > **Annotations:** Add text annotations for 2035 endpoints that reference the actual cells: > - "Bear: quot; & TEXT('Scenarios'!M13,"#,##0") & "M" > - "Base: quot; & TEXT('Scenarios'!M21,"#,##0") & "M" > - "Bull: quot; & TEXT('Scenarios'!M29,"#,##0") & "M" > > **Formatting:** Y-axis in $M. Chart title: "Scenario Analysis — Group EBITDA ($M)". Legend at bottom. White background. --- ## Chart 9 — Revenue Mix by Segment (100% Stacked Bar + Milestone Cards) > Create a 100% stacked column chart on a new sheet called "Revenue Mix Chart" showing how the revenue share shifts between Colocation, Cloud, and Cybersecurity over time. > > **IMPORTANT: Do NOT hardcode any numbers.** Build a helper data table on the new sheet where every value is a formula. The chart must update automatically if the model changes. > > **Data source:** Create a helper data table on the new sheet that calculates the percentage share for each segment. Pull raw revenue from "Consolidated P&L" and compute percentages via formulas. Use years 2027–2035 only (skip 2026 since all values are zero). > > **Helper table structure (each cell is a formula):** > - Row for Years: link to 'Consolidated P&L'!E4:M4 (2027–2035) > - Row for **Colocation %**: Each cell = `='Consolidated P&L'!E8/'Consolidated P&L'!E13` (for 2027), and so on through column M for 2035 > - Row for **Cloud %**: Each cell = `=('Consolidated P&L'!E9+'Consolidated P&L'!E10)/'Consolidated P&L'!E13` — this combines Cloud CPU Simulation (row 9) and Cloud GPU Inference (row 10) > - Row for **Cybersecurity %**: Each cell = `='Consolidated P&L'!E12/'Consolidated P&L'!E13` — Quantum Cybersecurity (row 12) divided by Group Revenue (row 13) > - Format all percentage cells as "0%" (no decimals) > > **Chart type:** 100% stacked column chart. Stack order bottom-to-top: Colocation (bottom), Cloud (middle), Cybersecurity (top). > > **Colors:** > - **Colocation** — Dark Navy (#1B2A4A) > - **Cloud** — Lime (#C8D830) > - **Cybersecurity** — Slate Grey (#7B8D9E) > > **Data labels:** Show the percentage value inside each segment of every bar (e.g. "62%", "10%", "29%" for 2027). White bold text for the navy segment, dark navy bold text for the lime and grey segments. > > **Y-axis:** 0% to 100%, with 10% increments. Light grey gridlines. > > **Milestone callout cards:** Above the chart area, create 4 formatted cell groups (styled as cards) in a horizontal row. Each card has a navy (#1B2A4A) background with lime (#C8D830) large text and white subtitle text: > > - **Card 1:** Title = formula: `=TEXT('Consolidated P&L'!E12/'Consolidated P&L'!E13,"0%")`, subtitle = "of group revenue", header = "CYBER 2027" > - **Card 2:** Title = formula: `=TEXT(('Consolidated P&L'!I9+'Consolidated P&L'!I10)/'Consolidated P&L'!I13,"0%")`, subtitle = "crossing the midpoint", header = "CLOUD 2031" > - **Card 3:** Title = formula: `=TEXT(('Consolidated P&L'!M9+'Consolidated P&L'!M10)/'Consolidated P&L'!M13,"0%")`, subtitle = "dominant revenue stream", header = "CLOUD 2035" > - **Card 4:** Title = formula: `='Consolidated P&L'!M26` (formatted as percentage), subtitle = "group EBITDA margin", header = "EBITDA 2035" > > **Card formatting:** Each card should be a merged cell block (~4 columns wide) with: > - Navy (#1B2A4A) cell fill > - Header text: lime (#C8D830), 9pt, bold, uppercase > - Main value: lime (#C8D830), 28pt, bold > - Subtitle: white, 9pt, regular > - Thin lime (#C8D830) top border accent on each card > > **Chart formatting:** No chart border. White background. Legend at the bottom showing: ■ Colocation ■ Cloud ■ Cybersecurity. No chart title needed (the milestone cards serve as the header). Make the chart presentation-ready at roughly 900×450px equivalent. --- ## Tips for Best Results in Claude in Excel 1. **Open the file first** — Make sure `navon_africa_main-financial-model_v1.xlsx` is open in Excel before running these prompts. 2. **Verify formulas, not values** — After each chart is created, click on a data cell and confirm it shows a formula like `='Consolidated P&L'!D13`, NOT a plain number. If any cell is hardcoded, ask Claude to "replace the hardcoded values with formulas linking to the source sheet." 3. **One chart at a time** — Copy one prompt, paste it into Claude in Excel, let it finish, then move to the next. 4. **If waterfall isn't available** — Ask Claude to "simulate the waterfall using a stacked bar chart with an invisible base series colored white/transparent". 5. **For the heatmap** — This is conditional formatting on cells, not a chart. Claude in Excel should apply it as cell formatting. 6. **To make charts PowerPoint-ready** — After creation, ask: "Remove the chart border, set background to white, title to 14pt bold, and make the chart 800×500px." 7. **If a cell reference is off** — Tell Claude: "The data seems to start one row lower, please adjust the formulas" — it will fix it. 8. **Test the links** — Change a number on a source sheet temporarily and confirm the chart/dashboard updates. Then undo.