| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||||||||||||||||
2 | How to use this template? | |||||||||||||||||||||||||||||||||||||||
3 | 1) Open LiveFlow -> Go to Extensions -> LiveFlow -> Get started | |||||||||||||||||||||||||||||||||||||||
4 | 2) Head over to the Manage Reports tab in LiveFlow. | |||||||||||||||||||||||||||||||||||||||
5 | 3) Click on the Profit & Loss and Balance Sheet -> Click "Change Company" -> Change it to your own company | |||||||||||||||||||||||||||||||||||||||
6 | 4) Add your opening cash balance in cell B16 | |||||||||||||||||||||||||||||||||||||||
7 | 5) Add your expected income (Cash inflow) and expenses (Cash outflow) for each month | |||||||||||||||||||||||||||||||||||||||
8 | 6) Consider adding a buffer account for unexpected expenses that might come up | |||||||||||||||||||||||||||||||||||||||
9 | 7) Your ending cash balance will automatically update and is a function of (Opening cash balance + Cash In - Cash Out) | |||||||||||||||||||||||||||||||||||||||
10 | ||||||||||||||||||||||||||||||||||||||||
11 | Last Updated • | 03/15/2023 07:39:31 | Jan, 2023 | |||||||||||||||||||||||||||||||||||||
12 | ||||||||||||||||||||||||||||||||||||||||
13 | Cash Flow Forecast | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | ||||||||||||||||||||||||||
14 | 1/9/2023 | 1/16/2023 | 1/23/2023 | 1/30/2023 | 2/6/2023 | 2/13/2023 | 2/20/2023 | 2/27/2023 | 3/6/2023 | 3/13/2023 | 3/20/2023 | 3/27/2023 | 4/3/2023 | |||||||||||||||||||||||||||
15 | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | Estimate | Actual | Variance | |
16 | Cash on hand (beginning of month) | $250,000 | $478,554,809 | $478,304,809 | $350,800 | $477,495,879 | $477,145,079 | $451,600 | $477,485,944 | $477,034,344 | $552,400 | $477,876,944 | $477,324,544 | $653,200 | $477,876,944 | $477,223,744 | $754,000 | $403,686,424 | $402,932,424 | $854,800 | $403,686,424 | $402,831,624 | $955,600 | $403,684,424 | $402,728,824 | $1,056,400 | $404,074,424 | $403,018,024 | $1,157,200 | $325,999,354 | $324,842,154 | $1,258,000 | $325,999,354 | $324,741,354 | $1,358,800 | $325,992,354 | $324,633,554 | $1,459,600 | $326,382,354 | $324,922,754 |
17 | ||||||||||||||||||||||||||||||||||||||||
18 | Cash Inflow | |||||||||||||||||||||||||||||||||||||||
19 | Select Profit & Loss accounts from the dropdown: | |||||||||||||||||||||||||||||||||||||||
20 | 4001 Online Sales | $350,000 | $0 | -$350,000 | $350,000 | $0 | -$350,000 | $350,000 | $200,000 | -$150,000 | $350,000 | $0 | -$350,000 | $350,000 | $0 | -$350,000 | $350,000 | $0 | -$350,000 | $350,000 | $0 | -$350,000 | $350,000 | $200,000 | -$150,000 | $350,000 | $100,000 | -$250,000 | $350,000 | $0 | -$350,000 | $350,000 | $0 | -$350,000 | $350,000 | $200,000 | -$150,000 | $350,000 | $100,000 | -$250,000 |
21 | 4002 Retail Sales | $250,000 | $0 | -$250,000 | $250,000 | $0 | -$250,000 | $250,000 | $160,000 | -$90,000 | $250,000 | $0 | -$250,000 | $250,000 | $0 | -$250,000 | $250,000 | $0 | -$250,000 | $250,000 | $0 | -$250,000 | $250,000 | $160,000 | -$90,000 | $250,000 | $80,000 | -$170,000 | $250,000 | $0 | -$250,000 | $250,000 | $0 | -$250,000 | $250,000 | $160,000 | -$90,000 | $250,000 | $80,000 | -$170,000 |
22 | 4003 SaaS | $40,000 | $0 | -$40,000 | $40,000 | $0 | -$40,000 | $40,000 | $30,000 | -$10,000 | $40,000 | $0 | -$40,000 | $40,000 | $0 | -$40,000 | $40,000 | $0 | -$40,000 | $40,000 | $0 | -$40,000 | $40,000 | $30,000 | -$10,000 | $40,000 | $15,000 | -$25,000 | $40,000 | $0 | -$40,000 | $40,000 | $0 | -$40,000 | $40,000 | $30,000 | -$10,000 | $40,000 | $15,000 | -$25,000 |
23 | 4020 Interest Earned | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $500 | -$500 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $250 | -$750 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $250 | -$750 |
24 | 4030 One-Off Income | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $500 | -$500 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $250 | -$750 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $0 | -$1,000 | $1,000 | $250 | -$750 |
25 | $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 | ||||||||||||||
26 | $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 | ||||||||||||||
27 | $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 | ||||||||||||||
28 | $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 | ||||||||||||||
29 | $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 | ||||||||||||||
30 | $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 | ||||||||||||||
31 | $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 | ||||||||||||||
32 | ||||||||||||||||||||||||||||||||||||||||
33 | ||||||||||||||||||||||||||||||||||||||||
34 | Non-Cash Income Items | |||||||||||||||||||||||||||||||||||||||
35 | $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 | ||||||||||||||
36 | $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 | ||||||||||||||
37 | ||||||||||||||||||||||||||||||||||||||||
38 | Select Balance Sheet accounts from the dropdown: | |||||||||||||||||||||||||||||||||||||||
39 | 3030 Common Stock | $200 | $0 | $200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 |
40 | 3050 Additional Paid-In Capital | $200 | $0 | $200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 |
41 | 2001 Credit Card | $200 | $0 | $200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 |
42 | 2030 Accrued Expenses | $200 | $0 | $200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 | $200 | $0 | -$200 |
43 | 2100 Notes Payable | $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 | |||||||||||||
44 | $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 | ||||||||||||||
45 | $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 | ||||||||||||||
46 | $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 | ||||||||||||||
47 | $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 | ||||||||||||||
48 | $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 | ||||||||||||||
49 | $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 | ||||||||||||||
50 | ||||||||||||||||||||||||||||||||||||||||
51 | Total Cash Inflow | $800 | $0 | $800 | $800 | $0 | -$800 | $800 | $391,000 | -$800 | $800 | $0 | -$800 | $800 | $0 | -$800 | $800 | $0 | -$800 | $800 | $0 | -$800 | $800 | $390,000 | -$800 | $800 | $195,500 | -$800 | $800 | $0 | -$800 | $800 | $0 | -$800 | $800 | $390,000 | -$800 | $800 | $195,500 | -$800 |
52 | ||||||||||||||||||||||||||||||||||||||||
53 | Cash Outflow | |||||||||||||||||||||||||||||||||||||||
54 | Select Profit & Loss accounts from the dropdown: | |||||||||||||||||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||||||||||||||||
56 | 5000 Cost of Goods Sold | $35,000,000 | $0 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $5,000 | -$34,995,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | |
57 | 5010 T-Shirts | $35,000,000 | $20,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $33,060,220 | -$1,939,780 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $35,060,220 | $60,220 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $0 | -$35,000,000 | $35,000,000 | $37,040,220 | $2,040,220 | |
58 | 5020 Shoes | $500,000 | $15,000 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $39,050,220 | $38,550,220 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $41,050,220 | $40,550,220 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $43,035,220 | $42,535,220 | |
59 | 5030 Delivery Fees | $500,000 | $10,000 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $290,220 | -$209,780 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $300,220 | -$199,780 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $0 | -$500,000 | $500,000 | $300,220 | -$199,780 | |
60 | 6010 Online Marketing | $52,000 | $170,110 | $52,000 | $0 | -$52,000 | $52,000 | $0 | -$52,000 | $52,000 | $0 | -$52,000 | $52,000 | $453,220 | $401,220 | $52,000 | $0 | -$52,000 | $52,000 | $0 | -$52,000 | $52,000 | $0 | -$52,000 | $52,000 | $463,220 | $411,220 | $52,000 | $0 | -$52,000 | $52,000 | $0 | -$52,000 | $52,000 | $0 | -$52,000 | $52,000 | $453,220 | $401,220 | |
61 | 6020 Subscriptions | $60,000 | $17,110 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $35,320 | -$24,680 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $37,320 | -$22,680 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $35,320 | -$24,680 | |
62 | 6030 Travel Expenses | $60,000 | $38,110 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $76,220 | $16,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $79,220 | $19,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $76,220 | $16,220 | |
63 | 6031 Flights | $60,000 | $0 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | |
64 | 6040 Computers & Equipment | $60,000 | $34,110 | $60,000 | $7,934 | -$52,066 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $68,220 | $8,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $72,220 | $12,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $68,220 | $8,220 | |
65 | 6050 Payroll | $60,000 | $445,110 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $890,220 | $830,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $925,220 | $865,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $890,220 | $830,220 | |
66 | 6060 Office | $60,000 | $56,110 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $112,220 | $52,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $118,220 | $58,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $112,220 | $52,220 | |
67 | 6070 Professional Services | $60,000 | $124,220 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $248,440 | $188,440 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $254,440 | $194,440 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $248,440 | $188,440 | |
68 | 6080 Legal | $60,000 | $3,800 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $7,600 | -$52,400 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $11,400 | -$48,600 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $7,600 | -$52,400 | |
69 | 6090 Depreciation | $60,000 | $0 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $20,000 | -$40,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $20,000 | -$40,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $20,000 | -$40,000 | |
70 | 6700 Uncategorized Expense | $60,000 | $0 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | |
71 | 9001 Home Office | $60,000 | $5,250 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $500 | -$59,500 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $750 | -$59,250 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $0 | -$60,000 | $60,000 | $500 | -$59,500 | |
72 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||||||||||||||||
77 | Non-Cash Expense Items | |||||||||||||||||||||||||||||||||||||||
78 | 6090 Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | -$20,000 | -$20,000 | $0 | $0 | $0 | $0 | $0 | $0 | -$20,000 | -$20,000 | $0 | $0 | $0 | $0 | $0 | $0 | -$20,000 | -$20,000 | ||||||||||||||
79 | $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 | |||||||||||||||
80 | $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 | |||||||||||||||
81 | ||||||||||||||||||||||||||||||||||||||||
82 | Select Balance Sheet accounts from the dropdown: | |||||||||||||||||||||||||||||||||||||||
83 | 1200 Furniture | $20,000 | $120,000 | -$100,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 |
84 | 1300 Security Deposits | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 |
85 | 1100 Inter-Company Receivable | $20,000 | $0 | $20,000 | $20,000 | $2,000 | $18,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $12,000 | $8,000 | $20,000 | $0 | $20,000 | $20,000 | $2,000 | $18,000 | $20,000 | $0 | $20,000 | $20,000 | $12,000 | $8,000 | $20,000 | $0 | $20,000 | $20,000 | $2,000 | $18,000 | $20,000 | $0 | $20,000 | $20,000 | $12,000 | $8,000 |
86 | 1096 Prepaid Expenses | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | -$114,100 | $134,100 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | -$114,100 | $134,100 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | -$114,100 | $134,100 |
87 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | $20,000 | $0 | $20,000 | |
88 | $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 | ||||||||||||||
89 | $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 | ||||||||||||||
90 | ||||||||||||||||||||||||||||||||||||||||
91 | Total Cash Outflow | $100,000 | $1,058,930 | -$20,000 | $100,000 | $9,934 | $98,000 | $100,000 | $0 | $100,000 | $100,000 | $0 | $100,000 | $100,000 | $74,190,520 | $202,100 | $100,000 | $0 | $100,000 | $100,000 | $2,000 | $98,000 | $100,000 | $0 | $100,000 | $100,000 | $78,270,570 | $202,100 | $100,000 | $0 | $100,000 | $100,000 | $7,000 | $98,000 | $100,000 | $0 | $100,000 | $100,000 | $82,165,520 | $202,100 |
92 | ||||||||||||||||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||||||||||||||
94 | Cash on hand (end of month) | $350,800 | $477,495,879 | -$477,145,079 | $451,600 | $477,485,944 | -$477,034,344 | $552,400 | $477,876,944 | -$477,324,544 | $653,200 | $477,876,944 | -$477,223,744 | $754,000 | $403,686,424 | -$402,932,424 | $854,800 | $403,686,424 | -$402,831,624 | $955,600 | $403,684,424 | -$402,728,824 | $1,056,400 | $404,074,424 | -$403,018,024 | $1,157,200 | $325,999,354 | -$324,842,154 | $1,258,000 | $325,999,354 | -$324,741,354 | $1,358,800 | $325,992,354 | -$324,633,554 | $1,459,600 | $326,382,354 | -$324,922,754 | $1,560,400 | $244,412,334 | -$242,851,934 |
95 | ||||||||||||||||||||||||||||||||||||||||
96 | Minimum Required Cash Balance | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | ||||||||||||||||||||||||||
97 | Cash Required Alert | $0 | $0 | -$477,145,079 | $0 | $0 | -$477,034,344 | $0 | $0 | -$477,324,544 | $0 | $0 | -$477,223,744 | $0 | $0 | -$402,932,424 | $0 | $0 | -$402,831,624 | $0 | $0 | -$402,728,824 | $0 | $0 | -$403,018,024 | $0 | $0 | -$324,842,154 | $0 | $0 | -$324,741,354 | $0 | $0 | -$324,633,554 | $0 | $0 | -$324,922,754 | $0 | $0 | -$242,851,934 |
98 | ||||||||||||||||||||||||||||||||||||||||
99 | Cash Balance As per Balance Sheet-> | |||||||||||||||||||||||||||||||||||||||
100 | Total Bank Accounts | $477,495,879 | $477,485,944 | $477,876,944 | $477,876,944 | $403,686,424 | $403,686,424 | $403,684,424 | $404,074,424 | $325,999,354 | $325,999,354 | $325,992,354 | $326,382,354 | $244,412,334 | ||||||||||||||||||||||||||