Sample Trading Co
Financials
Sales
Expenses
Inventory
Payments
Banking
Planning
Reports
Data
Settings
Demo company
العربية
Home
Sales
Expenses
Pages
More
From
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
3 years
4 years
5 years
2027–2031
New plan
Make a copy
Delete
Demo: changes are kept until you leave the page.
1
Overview
2
Sales
EGP 12.7M
3
Costs
EGP 10.5M
4
Funding
EGP 0
5
Statements
6
Scenarios & risks
7
Report
Worst case
Base case
Best case
Sales in the last year
EGP 27.1M
21% a year from Y1
Net profit over the plan
EGP 16.8M
17.5% of sales
EBITDA in the last year
EGP 7.1M
26.2% of sales
Lowest cash
EGP 1.9M
Jan 2027
NPV
EGP 9.6M
IRR: no outlay to recover · at 20%
Payback
From the start
Break-even sales EGP 8.0M
Sales and profit
Figures
Sales
Net profit
EGP 0
EGP 5.0M
EGP 10.0M
EGP 15.0M
EGP 20.0M
EGP 25.0M
EGP 30.0M
2027
2028
2029
2030
2031
Plan check
Read the way a bank reads a plan
Cash stays above zero all through the plan (lowest EGP 1.9M in Jan 2027)
Profitable from the first year
Gross margin 45.5% in 2027
The loans are covered: debt service cover at least 19.08×
Worth more than it costs: net present value EGP 9.6M at 20%
Cash, month by month
Lowest EGP 1.9M in Jan 2027
Figures
EGP 0
EGP 5.0M
EGP 10.0M
EGP 15.0M
EGP 20.0M
Jan 27
Jun 27
Nov 27
Apr 28
Sep 28
Feb 29
Jul 29
Dec 29
May 30
Oct 30
Mar 31
Aug 31
Dec 31
From sales to net profit
2027
2027
2028
2029
2030
2031
Figures
0
5.0M
10.0M
15.0M
12.7M
Sales
Sales
-6.9M
Cost of sales
Cost of
sales
5.8M
Gross profit
Gross
profit
0
Staff
Staff
-3.6M
Overheads
Overheads
2.2M
EBITDA
EBITDA
-26.0K
Depreciation
Depreciat…
-35.4K
Interest
Interest
-478K
Income tax
Income tax
1.6M
Net profit
Net profit
Sales by product line
Figures
Oxygen Concentrator 10L
Oxygen Concentrator 5L
BiPAP Machine
Patient Monitor 7-inch
Hospital Bed Electric
CPAP Machine
Other
EGP 0
EGP 5.0M
EGP 10.0M
EGP 15.0M
EGP 20.0M
EGP 25.0M
EGP 30.0M
2027
2028
2029
2030
2031
Sources and uses of cash
Over the whole plan
Where the cash comes from
91%
Cash when the plan starts
EGP 1.7M
Cash from operations
EGP 17.7M
Where it goes
99%
Loans repaid
EGP 201K
Cash when the plan ends
EGP 19.2M
Next: Sales
→