WEEKETT

Cash Flow Forecast

Forecast month 1 2 3 4 5
Status Actual Actual Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast Forecast
Week Ending Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Cash Bal: Beg of month 96,095.18 106,845.59 45,031.24 35,632.77 6,130.42 15,488.58 4,137.98 #REF! #REF! #REF! #REF!

INCOME
Amazon Seller 6,312.27 2,618.28 1,288.33 304.49 (119.20) 39.43 -
Amazon Vendor 57,729.84 16,960.32 7,463.64 14,283.98 50,761.22 27,332.95 18,118.53
eBay 1,035.43 808.07 1,863.03 423.10 1,057.75 269.85 340.77
OnBuy 94.99
Shopify 4,059.68 7,094.33 6,064.47 1,018.34 1,649.87 3,337.04 1,867.50
Refunds (672.94) (219.26) (305.57) (313.86) (45.55) (89.99) (199.72)
Discounts - - - - (128.76) (49.58) (86.66)
Other Income 1,000.00 1,000.00
TOTAL INCOME 68,559.27 27,261.74 17,373.90 15,716.05 53,175.33 31,839.70 20,040.42 - - - - -

COST OF SALES

Cost of Sales
Amazon Seller Charges 53.62 94.71 15.83 2.29 - - 17.34
Amazon Vendor Charges 2,838.64 1,000.50 1,498.48 4,692.24 3,238.24 2,260.75 3,417.46
Cost of goods sold 5,916.62 8,353.92 24,156.16 7,457.11 2,248.84 16,000.66 3,708.80
ebay Charges 174.38 152.06 260.85 154.55 56.32 47.63 55.74
OnBuy Charges 19.00 - - 19.00 19.00 19.00 19.00
Other direct cost 100.00
Paypal fees 65.68 90.54 59.72 14.87 27.64 44.68 18.04
Platform Subscription fee 24.15
Postage 359.37 523.39 568.98 449.07 176.63 182.00 557.19
Purchases (3,243.88)
Shipping, Freight and Delivery 1,374.03 1,208.17 715.35 4,850.64 673.12 2,534.37
Shopify -Shipping (6.50)
Shopify Fee 91.70 136.60 79.89 5.13 13.83 47.35 20.01
Subcontractor Costs 578.44 789.49 2,977.02 995.02 1,634.02 2,085.68 4,561.33
TOTAL COST OF SALES 10,097.45 12,515.24 30,925.10 14,504.63 9,021.28 21,360.87 14,926.93 - - - - -

GROSS PROFIT 58,461.82 14,746.50 (13,551.20) 1,211.42 44,154.05 10,478.83 5,113.49 - - - - -

GROSS PROFIT (%) 85.27% 54.09% -78.00% 7.71% 83.03% 32.91% 25.52% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

EXPENSES
Accommodation and meals 434.90 141.43 197.39 187.81 135.50 358.78

Advertising
Amazon 2,868.19 3,262.55 8,559.97 9,769.69 5,600.20 2,036.25 4,065.19
Facebook 134.51 315.46 90.03 70.00 100.00 847.22
Google 2,342.36 3,440.53 2,919.98 1,257.55 1,950.18 1,246.70 1,307.69
TikTok (71.24) (63.32) 197.93
Total advertising 5,210.55 6,837.59 11,724.17 11,053.95 7,620.38 3,382.95 6,418.03 - - - - -

Financial Expense
Bank charges 42.00 7.00 37.00 14.00 7.00 7.00
Bounce Back loan Interest 25.79 49.86 46.69 25.13 22.19
Total financial income 67.79 7.00 86.86 - 60.69 32.13 29.19 - - - - -

Klarna Fee 26.65 89.13 113.66 35.48 40.34 38.74 51.81

Office equipment 25.95 108.09 329.56
Office expenses, repairs & maintenance 3.07

Operational Expense
Directors' remuneration 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
Employer's NI contributions - - - - - - -
Insurance 40.00 40.00 80.00 40.00 40.00 20.00 26.60
Payroll Expenses 1,213.36 1,213.36 1,213.36 1,213.36 1,277.64 1,580.40 1,580.40
Software IT 393.46 293.62 77.58 75.60 176.25 259.55 100.55
Stationery 85.00
Storage 205.54 880.67 531.54 505.17 164.00 144.78 1,143.58
Subscriptions 886.74 86.52 360.95 94.28 339.16 48.23
Travelling expenses 195.36 1,641.11 87.49 386.35 412.27 212.31
Total Operational Expense 3,739.10 3,623.01 4,715.11 3,282.57 3,138.52 3,756.16 4,111.67 - - - - -

Packaging 437.50 - - - - -

Professional Services
Accountancy 234.16 2,014.16 1,214.16 234.16 524.44 234.16 234.16
Advisory 400.00 400.00 400.00 400.00 400.00 400.00 400.00
Legal 250.00 921.00
Marketing 1,500.00 1,111.87 2,203.79 903.66 1,024.99 1,250.56 750.00
Total Professional Services 2,134.16 3,526.03 3,817.95 1,537.82 1,949.43 2,134.72 2,305.16 - - - - -

Facilities
Rent 421.50
Telephone 16.68 8.34 8.34 8.34 8.34
Total Facilities - 438.18 8.34 8.34 - 8.34 8.34 - - - - -

Discount Credit Received 14.00 14.00

TOTAL EXPENSES 11,178.25 14,981.79 20,715.61 16,115.55 13,329.80 9,474.54 13,706.48 - - - - -

NET PROFIT 47,283.57 (235.29) (34,266.81) (14,904.13) 30,824.25 1,004.29 (8,592.99) - - - - -

BALANCE SHEET ADJUSTMENTS

Increase/(decrease) in Credit Card balances 1,446.14 4,461.32 967.93 (2,964.95) (4,654.24) 1,181.51
(Increase)/decrease in trade debtors - (1,000.00) 827.00 (251.76) (1,251.76) 748.24
(Increase)/decrease in fixed assets - (1,218.99)
(Increase)/decrease in current assets 12,385.51 24,232.18 8,319.18 (53,184.95) 15,952.88 (790.87)
Increase/(decrease) in Trade Creditors 10.00 (3,243.89)
Increase/(decrease) in Current Liabilities 1,408.83 (1,469.62) (383.26) 3,310.96 2,351.78 103.51
Increase/(decrease) in Creditors 225.18 (225.19)
Increase/(decrease) in Director's current account (3,045.80) (53,996.60) (4,000.00) (3,992.01) (4,044.79) (4,000.00)
Total balance sheet adjustments - 10,985.69 (27,547.54) 5,505.66 (60,326.60) 8,353.87 (2,757.61) - - - - -

Net cash inflow/(outflow) 47,283.57 10,750.40 (61,814.35) (9,398.47) (29,502.35) 9,358.16 (11,350.60) - - - - -

Ending Cash 96,095.18 106,845.59 45,031.24 35,632.77 6,130.42 15,488.58 4,137.98 #REF! #REF! #REF! #REF! #REF!
 Ending Cash Balance by Month
Actual + Forecast

120,000

106,845.59

100,000
96,095.18

80,000

60,000

45,031.24

40,000
35,632.77

20,000
15,488.58

6,130.42
4,137.98

-
Aug

Nov
May
Apr
Mar
Feb

Jun

Sep

Oct

Dec
Jul
44927