Simple cash flow correction

Why is your monthly cash outflow are different from your monthly expenses. Write about the cash receivables and cash payables at the end of the year. Highlighted the correction and make connection.

Financial Planning
a. Start-Up Costs
category
Description
Salaries & Wages
Staff salaries and
benefits for various
departments
Office lease, utilities
(electricity, water, etc.)
Online advertising,
social media campaigns
Development and
maintenance of digital
platforms
Setup and maintenance
of charging stations
Purchase or lease of
electric vehicles
Regulatory approvals
and operating licenses
Liability, vehicle, and
operational insurance
Tools, devices, and
other operational
equipment
Legal services,
consulting, and advisory
fees
Office rental, utilities,
and maintenance
Launch marketing
campaigns, branding
materials
Reserve fund for
operational expenses
Permits, licenses,
miscellaneous expenses
Rent & Utilities
Marketing &
Advertising
Technology &
Software
Charging
Infrastructure
Vehicle Acquisition
Licensing and
Permits
Insurance
Operational
Equipment
Legal and
Consulting Fees
Office Space and
Utilities
Initial Marketing
Working Capital
Other
Sub-Total
One-Time Costs
Vehicle Charging
Infrastructure
Setup and installation of
charging stations
Monthly
Expenses
(SAR)
100,000
Cash Needed
to Start (SAR)
% of
Total
Source of Capital
300,000
6.54%
Equity/Debt
Financing
50,000
150,000
3.27%
80,000
240,000
5.23%
70,000
210,000
4.58%
Operating
Lease/Cash Flow
Marketing
Budget/Cash Flow
Equity/Debt
Financing
200,000
600,000
13.07%
400,000
1,200,000
26.14%
20,000
60,000
1.31%
30,000
90,000
1.96%
40,000
120,000
2.61%
60,000
180,000
3.92%
Equity/Debt
Financing
50,000
150,000
3.27%
100,000
300,000
6.54%
300,000
900,000
19.61%
30,000
90,000
1.95%
Operating
Lease/Cash Flow
Marketing
Budget/Debt
Financing
Debt Financing/Line
of Credit
Operating
Budget/Cash Flow
1,530,000
4,590,000
100%
500,000
500,000
13.51%
Equity/Debt
Financing
Equity/Debt
Financing
Operating Reserves
Operating
Budget/Cash Flow
Operating
Budget/Cash Flow
Equity/Debt
Financing
Vehicle Acquisition
Technology &
Software
Website
Development
Initial Marketing
Working Capital
Other
Purchase or lease of
electric vehicles
Development and
maintenance of digital
platforms
Design and
development of
company website
Launch marketing
campaigns, branding
materials
Reserve fund for
operational expenses
Permits, licenses, other
one-time expenses
Sub Total for (one
time investment)
Grand total
1,000,000
1,000,000
27.03%
Equity/Debt
Financing
Equity/Debt
Financing
300,000
300,000
8.11%
100,000
100,000
2.70%
Equity/Debt
Financing
200,000
200,000
5.41%
1,500,000
1,500,000
40.54%
100,000
100,000
2.70%
Marketing
Budget/Debt
Financing
Debt Financing/Line
of Credit
Operating
Budget/Cash Flow
3,700,000
3,700,000
100%
1,63,000
82,90,000
b. Financial Projection
i. Sales Forecast
Customer Segment
Urban Professionals
Tourist Segment
Corporate
Clients/Events
Subtotal
Vehicle Rentals
Shuttle Services
Total Potential
Revenue
Monthly
Customers
500
300
10
–
Average Revenue per
Customer (SAR)
200
300
5,000
Monthly Revenue
(SAR)
100,000
90,000
50,000
Yearly Revenue
(SAR)
1,200,000
1,080,000
600,000
–
240,000
50,000
30,000
320,000
2,880,000
600,000
360,000
3,840,000
iii. Cash Flow Forecast
Month
Month 1
Month 2
Month 3
Cash Inflow (SAR)
80,000
100,000
120,000
Cash Outflow (SAR)
96,000
102,000
108,000
Net Cash Flow (SAR)
-16,000
-2,000
12,000
Cumulative Cash Flow (SAR)
-16,000
-18,000
-6,000
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
140,000
160,000
180,000
200,000
220,000
240,000
260,000
280,000
300,000
114,000
120,000
126,000
132,000
138,000
144,000
150,000
156,000
162,000
26,000
40,000
54,000
68,000
82,000
96,000
110,000
124,000
138,000
20,000
60,000
114,000
182,000
264,000
360,000
470,000
594,000
732,000