Block 2: P&L
Block 2: P&L
Monthly channel revenue follows each channel’s ramp to maximum capacity. Channel gross margin equals revenue times its source margin rate. Total gross margin is the channel sum; profit is gross margin plus negative overheads, calculated from full-capacity costs times each month’s Overheads%. Yearly columns sum monthly values.
| Line item | Year 1 | Year 2 | Year 3 | Total | M1 Jan 27 | M2 Feb 27 | M3 Mar 27 | M4 Apr 27 | M5 May 27 | M6 Jun 27 | M7 Jul 27 | M8 Aug 27 | M9 Sep 27 | M10 Oct 27 | M11 Nov 27 | M12 Dec 27 | M13 Jan 28 | M14 Feb 28 | M15 Mar 28 | M16 Apr 28 | M17 May 28 | M18 Jun 28 | M19 Jul 28 | M20 Aug 28 | M21 Sep 28 | M22 Oct 28 | M23 Nov 28 | M24 Dec 28 | M25 Jan 29 | M26 Feb 29 | M27 Mar 29 | M28 Apr 29 | M29 May 29 | M30 Jun 29 | M31 Jul 29 | M32 Aug 29 | M33 Sep 29 | M34 Oct 29 | M35 Nov 29 | M36 Dec 29 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue — DirectSalesSubcontr | $1'108'750 | $0 | $0 | $1'108'750 | $0 | $55'438 | $110'875 | $166'313 | $221'750 | $221'750 | $221'750 | $110'875 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Revenue — DirectSales | $997'875 | $2'661'000 | $2'661'000 | $6'319'875 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $110'875 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 | $221'750 |
| Revenue — BrandSales | $20'248 | $708'668 | $728'916 | $1'457'832 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $20'248 | $40'495 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 | $60'743 |
| Revenue — OtherSales | $1'792'239 | $4'779'303 | $4'779'303 | $11'350'845 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $199'138 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 | $398'275 |
| Total Revenue | $3'919'111 | $8'148'972 | $8'169'219 | $20'237'302 | $0 | $55'438 | $110'875 | $166'313 | $221'750 | $221'750 | $221'750 | $420'888 | $620'025 | $620'025 | $620'025 | $640'273 | $660'521 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 | $680'768 |
| GM — DirectSalesSubcontr | $110'875 | $0 | $0 | $110'875 | $0 | $5'544 | $11'088 | $16'631 | $22'175 | $22'175 | $22'175 | $11'088 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| GM — DirectSales | $498'938 | $1'330'500 | $1'330'500 | $3'159'938 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $55'438 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 | $110'875 |
| GM — BrandSales | $2'025 | $70'867 | $72'892 | $145'783 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2'025 | $4'050 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 | $6'074 |
| GM — OtherSales | $358'448 | $955'861 | $955'861 | $2'270'169 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $39'828 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 | $79'655 |
| Gross Margin | $970'285 | $2'357'227 | $2'359'252 | $5'686'765 | $0 | $5'544 | $11'088 | $16'631 | $22'175 | $22'175 | $22'175 | $106'353 | $190'530 | $190'530 | $190'530 | $192'555 | $194'580 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 | $196'604 |
| Overheads | -$1'058'815 | -$1'320'005 | -$1'320'005 | -$3'698'826 | -$68'248 | -$68'248 | -$68'248 | -$74'086 | -$81'176 | -$82'276 | -$88'267 | -$88'267 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 |
| Profit | -$88'530 | $1'037'222 | $1'039'247 | $1'987'938 | -$68'248 | -$62'704 | -$57'160 | -$57'454 | -$59'001 | -$60'101 | -$66'092 | $18'086 | $80'530 | $80'530 | $80'530 | $82'554 | $84'579 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 |
Block 3: Cash Flow
Block 3: Cash Flow
Operations equals monthly profit. Investment is CAPEX allocated across months 1–12, zero afterward. Financial activity is the editable initial investment inflow in month 1, zero afterward. Net cash flow sums these three; closing balance is opening balance plus net cash flow. Yearly opening and closing values are the first and last balances of each period.
| Line item | Year 1 | Year 2 | Year 3 | Total | M1 Jan 27 | M2 Feb 27 | M3 Mar 27 | M4 Apr 27 | M5 May 27 | M6 Jun 27 | M7 Jul 27 | M8 Aug 27 | M9 Sep 27 | M10 Oct 27 | M11 Nov 27 | M12 Dec 27 | M13 Jan 28 | M14 Feb 28 | M15 Mar 28 | M16 Apr 28 | M17 May 28 | M18 Jun 28 | M19 Jul 28 | M20 Aug 28 | M21 Sep 28 | M22 Oct 28 | M23 Nov 28 | M24 Dec 28 | M25 Jan 29 | M26 Feb 29 | M27 Mar 29 | M28 Apr 29 | M29 May 29 | M30 Jun 29 | M31 Jul 29 | M32 Aug 29 | M33 Sep 29 | M34 Oct 29 | M35 Nov 29 | M36 Dec 29 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash opening balance | $0 | $311'470 | $1'348'692 | $0 | $0 | $751'752 | $629'049 | $451'889 | $364'434 | $305'433 | $245'332 | $179'240 | $197'326 | $277'856 | $358'386 | $378'915 | $311'470 | $396'049 | $482'653 | $569'256 | $655'860 | $742'464 | $829'068 | $915'672 | $1'002'276 | $1'088'880 | $1'175'484 | $1'262'088 | $1'348'692 | $1'435'295 | $1'521'899 | $1'608'503 | $1'695'107 | $1'781'711 | $1'868'315 | $1'954'919 | $2'041'523 | $2'128'127 | $2'214'730 | $2'301'334 |
| CF Operations | -$88'530 | $1'037'222 | $1'039'247 | $1'987'938 | -$68'248 | -$62'704 | -$57'160 | -$57'454 | -$59'001 | -$60'101 | -$66'092 | $18'086 | $80'530 | $80'530 | $80'530 | $82'554 | $84'579 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 |
| CF Investment | -$600'000 | $0 | $0 | -$600'000 | -$180'000 | -$60'000 | -$120'000 | -$30'000 | $0 | $0 | $0 | $0 | $0 | $0 | -$60'000 | -$150'000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| CF Financial activity | $1'000'000 | $0 | $0 | $1'000'000 | $1'000'000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Net Cash Flow | $311'470 | $1'037'222 | $1'039'247 | $2'387'938 | $751'752 | -$122'704 | -$177'160 | -$87'454 | -$59'001 | -$60'101 | -$66'092 | $18'086 | $80'530 | $80'530 | $20'530 | -$67'446 | $84'579 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 | $86'604 |
| Cash closing balance | $311'470 | $1'348'692 | $2'387'938 | $2'387'938 | $751'752 | $629'049 | $451'889 | $364'434 | $305'433 | $245'332 | $179'240 | $197'326 | $277'856 | $358'386 | $378'915 | $311'470 | $396'049 | $482'653 | $569'256 | $655'860 | $742'464 | $829'068 | $915'672 | $1'002'276 | $1'088'880 | $1'175'484 | $1'262'088 | $1'348'692 | $1'435'295 | $1'521'899 | $1'608'503 | $1'695'107 | $1'781'711 | $1'868'315 | $1'954'919 | $2'041'523 | $2'128'127 | $2'214'730 | $2'301'334 | $2'387'938 |
Overheads breakdown
Overheads breakdown
Items and monthly amounts come from the source Overheads sheet. Each month’s modeled overheads (full-capacity Overheads × Overheads%) are split across items by their share in that month of the sheet; from month 13 the month-12 structure applies. Totals therefore always match the P&L Overheads line.
| Item | Basis | Year 1 | Year 2 | Year 3 | Total | M1 Jan 27 | M2 Feb 27 | M3 Mar 27 | M4 Apr 27 | M5 May 27 | M6 Jun 27 | M7 Jul 27 | M8 Aug 27 | M9 Sep 27 | M10 Oct 27 | M11 Nov 27 | M12 Dec 27 | M13 Jan 28 | M14 Feb 28 | M15 Mar 28 | M16 Apr 28 | M17 May 28 | M18 Jun 28 | M19 Jul 28 | M20 Aug 28 | M21 Sep 28 | M22 Oct 28 | M23 Nov 28 | M24 Dec 28 | M25 Jan 29 | M26 Feb 29 | M27 Mar 29 | M28 Apr 29 | M29 May 29 | M30 Jun 29 | M31 Jul 29 | M32 Aug 29 | M33 Sep 29 | M34 Oct 29 | M35 Nov 29 | M36 Dec 29 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MT team | 180'000 AED/month | -$588'155 | -$588'155 | -$588'155 | -$1'764'466 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 | -$49'013 |
| Supervisor | 30'000 AED/month | -$98'026 | -$98'026 | -$98'026 | -$294'078 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 | -$8'169 |
| Other personnel | 60'000 AED/month | -$98'026 | -$196'052 | -$196'052 | -$490'129 | $0 | $0 | $0 | $0 | -$5'446 | -$5'446 | -$10'892 | -$10'892 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 | -$16'338 |
| Rent Warehouse | 60'000 AED/year | -$16'338 | -$16'338 | -$16'338 | -$49'013 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 | -$1'361 |
| Rent of Production facility | 300'000 AED/year | -$61'266 | -$81'688 | -$81'688 | -$224'643 | $0 | $0 | $0 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 | -$6'807 |
| Energy | 200'000 AED/year | -$31'653 | -$54'459 | -$54'459 | -$140'571 | -$500 | -$500 | -$500 | -$1'000 | -$2'000 | -$3'000 | -$3'000 | -$3'000 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 | -$4'538 |
| Repairs of equipment | 60'000 USD/year | -$20'000 | -$60'000 | -$60'000 | -$140'000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 | -$5'000 |
| Office expenses | 36'000 USD/year | -$26'000 | -$36'000 | -$36'000 | -$98'000 | -$3'000 | -$3'000 | -$3'000 | -$1'000 | -$1'000 | -$1'000 | -$1'000 | -$1'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 | -$3'000 |
| Other | % of other items | -$119'352 | -$189'288 | -$189'288 | -$497'928 | -$6'204 | -$6'204 | -$6'204 | -$6'735 | -$7'380 | -$7'480 | -$8'024 | -$8'024 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 | -$15'774 |
| Total overheads | -$1'058'815 | -$1'320'005 | -$1'320'005 | -$3'698'826 | -$68'248 | -$68'248 | -$68'248 | -$74'086 | -$81'176 | -$82'276 | -$88'267 | -$88'267 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 | -$110'000 |
Client & Partner Directory
Client & Partner Directory
Monthly revenue equals the client’s listed yearly turnover divided by 12. GP equals revenue multiplied by the tier’s editable GP/Revenue rate. Totals reflect the selected tiers.
Gross Profit (GP) = Revenue − Direct labor & Materials. Revenue and GP are monthly.
| Client | Tier | Revenue, $ | GP/Revenue, % | GP, $ |
|---|---|---|---|---|
| Air Arabia | Direct Airline/MRO | $100'000 | 50.0% | $50'000 |
| Jetex | Direct Airline/MRO | $10'000 | 50.0% | $5'000 |
| Salam Air | Direct Airline/MRO | $10'000 | 50.0% | $5'000 |
| Saudia Technic | Direct Airline/MRO | $10'000 | 50.0% | $5'000 |
| Joramco | Direct Airline/MRO | $10'000 | 50.0% | $5'000 |
| ATS Technic | Direct Airline/MRO | $10'000 | 50.0% | $5'000 |
| Gama Aviation | Direct Airline/MRO | $10'000 | 50.0% | $5'000 |
| AeroGulf Services | Direct Airline/MRO | $7'500 | 50.0% | $3'750 |
| Royal Aircraft Maintenance Company | Direct Airline/MRO | $5'000 | 50.0% | $2'500 |
| Dubai Royal Air Wing | Direct Airline/MRO | $15'000 | 50.0% | $7'500 |
| Nile Air | Direct Airline/MRO | $6'250 | 50.0% | $3'125 |
| Customer 1 | Direct Airline/MRO | $7'000 | 50.0% | $3'500 |
| Customer 2 | Direct Airline/MRO | $7'000 | 50.0% | $3'500 |
| Customer 3 | Direct Airline/MRO | $7'000 | 50.0% | $3'500 |
| Customer 4 | Direct Airline/MRO | $7'000 | 50.0% | $3'500 |
| Hydro | Brand OEM | $3'750 | 10.0% | $375 |
| AGSA | Brand OEM | $11'500 | 10.0% | $1'150 |
| DEDIENNE AEROSPACE | Brand OEM | $16'250 | 10.0% | $1'625 |
| TronAir | Brand OEM | $9'250 | 10.0% | $925 |
| Charlatte Manutention | Brand OEM | $19'993 | 10.0% | $1'999 |
| EAS Solutions (England, Andrew) | Distributor | $385'775 | 20.0% | $77'155 |
| NexaMumbai (India, Nikhel) | Distributor | — | 20.0% | — |
| China (Avenir Group Holding Limited) : Avenir | Distributor | $12'500 | 20.0% | $2'500 |
| Total (filtered) | $680'768 | 28.9% | $196'604 | |