DATA INPUT SHEET

Year-1
Price
Customers 650 748 860

Total Year 1 Total Year 2 Total Year 3

Sales Per Month

Starter #REF! #REF! #REF!
Essential #REF! #REF! #REF!
Plus #REF! #REF! #REF!
Custome #REF! #REF! #REF!

Total Sales Revenue #REF! #REF! #REF!

EXPENSES
Maintenance Cost
Starter #REF! 42000 142800
Essential #REF! 60000 204000
Plus #REF! 53280 216000
Engineering Fee 1296000 1296000 1296000
Product Development #REF! #REF! #REF!
Building and Training #REF! #REF! #REF!
Marketing and advertising #REF! #REF! #REF!
Rent Expense #REF! #REF! #REF!
Business Fairs #REF! #REF! #REF!
Advertising Campaign 1000
Marketing Campaign 3500
PR Campaign 2500
SEO Marketing 1500
Flyers 500
Business Cards 300
Legal 12500
Utilities 2100
Insurance 500
Business Licenses 800
Office space 11500
Rent 36500
Office Equipment 4500
Office Furniture 5000
Office Supplies 1700
Computers 12500
Desk 2500
Chairs 8400
Telephones 4500
Internet 1500
Web Maintenance 1500
Web Development 1500
Web Design 2500
Web Hosting 500
Salaries 100000
Consultants 10500
Employees 100500
Mobile App Development 1500
Mobile App Design 1500
Mobile App Maintenance 1800

Total #REF! #REF! #REF!

FINANCIAL MODEL DASH
3 YEARS PROJECTIONS
Net Cash Flows and Closing Cash Analysis
12

10 12

8 10

8
6

6
4

4
2

2
0
1 2 3

Cashflow Surplus/Deficit (-) Linear ( Cashflow Surplus/Deficit (-) ) 0

Closing cash balance Year 1
L MODEL DASHBOARD
3 YEARS PROJECTIONS

Revenue and Net Income Forecast

12

10

0
Year 1 Year 2 Year 3
3-Years Projected Profit and Loss

Year 1 Year 2 Year 3

Subscription Revenue #REF! #REF! #REF!
Net Revenue #REF! #REF! #REF!
Cost of Services - - -
Gross Profit #REF! #REF! #REF!
%age of Gross Profit #REF! #REF! #REF!
EXPENSES
Maintenance Cost
Starter #REF! $42,000 $142,800
Essential #REF! $60,000 $204,000
Plus #REF! $53,280 $216,000
Engineering Fee $1,296,000 $1,296,000 $1,296,000
Product Development #REF! #REF! #REF!
Building and Training #REF! #REF! #REF!
Marketing and advertising #REF! #REF! #REF!
Rent Expense #REF! #REF! #REF!
Business Fairs #REF! #REF! #REF!
#NAME? #NAME? #NAME? #NAME?
Total Expenses #REF! #REF! #REF!
Projected Cash fows for Year 1-Year 5

Year 1 Year 2 Year 3

Profit Before tax #REF! #REF! #REF!

Adjustments for non-cash

Depreciation $0 $0 $0

Cash flows before working capital requirements #REF! #REF! #REF!

Working Capital - - -
Income tax paid - - -
Net Working Capital - - -

Net Cash flows from Operations #REF! #REF! #REF!

Cash flows from Investing Activities

Computers and related equipments - - -

Furniture and fixtures - - -
Electric Equipments - - -
Vehicle - - -
Other investing activities - - -
Net Cash flows from investing activities $0 $0 $0

Cash flows from Financing activites

Debt -Financial Institution - - -

Repayment of Debt - - -
Capital Introduced $0 $0 $0

Net cash flows from financing activites $0 $0 $0

Net cash flows during the year #REF! #REF! #REF!

Cash and cash equivalance at start of year - #REF! #REF!
Cash and cash equivalance at end of year #REF! #REF! #REF!
Monthly Projected Profit and Loss

0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

Sales Per Month
Starter #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Essential #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Plus #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Custome #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

Total Sales Revenue #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

EXPENSES
Maintenance Cost #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Starter #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Essential #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Plus #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Engineering Fee #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Product Development #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Building and Training #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Marketing and advertising #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Rent Expense #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Business Fairs #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

Total #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

Profit/(Loss) befor Tax #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

Tax Expense $ - $ - $ - $ - $ - $ -

Profit/(loss) after tax #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Total

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? $ -

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? $ 1,296,000
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!

$ - $ - $ - $ - $ - $ - $ -

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #REF!

5 Years Cashflow Projections
Year Year 1 Year 2 Year 3

Receipts
Sales Revenue #REF! #REF! #REF!
Capital introduced (owner) £ - £ - £ -
Capital introduced (investor etc) £ - £ - £ -
Loans received £ - £ - £ -
Total Receipts #REF! #REF! #REF!

Total Payments #REF! #REF! #REF!

Cashflow Surplus/Deficit (-) #REF! #REF! #REF!

Opening Cash Balance £ - #REF! #REF!

Closing cash balance #REF! #REF! #REF!

Break-Even Analysis Year 1 Year 2 Year 3

Sale Price Per Unit/Client #NAME? #NAME? #NAME?

Variable Cost per Unit $0 $0 $0

Contribution margin #NAME? #NAME? #NAME?

Fixed Cost
Total Fixed Cost #REF! #REF! #REF!

Break-Even Analysis Year 1 Year 2 Year 3

Break even Customers (Average) #REF! #REF! #REF!
Break Even Sale #REF! #REF! #REF!

Bankable Month Started from last weekdays of June or July 2022 July