Model - Financial
Teams
| Function |
| C-level |
| Marketing |
| Sales |
| Customer Success |
| R&D |
| Operations |
| General |
Assumptions
Income Statement
| Innovare - Social Innovation Partners | |||||||||||||
| HISTORICAL | |||||||||||||
| Jul 2020 | Aug 2020 | Sep 2020 | Oct 2020 | Nov 2020 | Dec 2020 | Jan 2021 | Feb 2021 | Mar 2021 | Apr 2021 | May 2021 | Jun 2021 | Total | |
| Income | |||||||||||||
| Sales of Product Income | 150,000.00 | 150,000.00 | |||||||||||
| NFP | 0.00 | ||||||||||||
| New | 25,000.00 | 55,000.00 | 0.00 | 12,500.00 | 9,250.00 | 101,750.00 | |||||||
| Total NFP | $0.00 | $0.00 | $0.00 | $0.00 | $25,000.00 | $55,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $12,500.00 | $9,250.00 | $101,750.00 |
| School | 0.00 | ||||||||||||
| New | 25,000.00 | 32,500.00 | 7,500.00 | 55,000.00 | 15,000.00 | 7,500.00 | 60,384.00 | 62,500.00 | 265,384.00 | ||||
| Renewal | 15,000.00 | 25,000.00 | 63,500.00 | 15,000.00 | 106,500.00 | 30,000.00 | 24,000.00 | 15,000.00 | 75,000.00 | 7,500.00 | 376,500.00 | ||
| Total School | $15,000.00 | $25,000.00 | $88,500.00 | $47,500.00 | $114,000.00 | $85,000.00 | $39,000.00 | $15,000.00 | $7,500.00 | $60,384.00 | $137,500.00 | $7,500.00 | $641,884.00 |
| Total Sales of Product Income | $15,000.00 | $25,000.00 | $88,500.00 | $47,500.00 | $139,000.00 | $140,000.00 | $39,000.00 | $15,000.00 | $157,500.00 | $60,384.00 | $150,000.00 | $16,750.00 | $893,634.00 |
| Service Income | 0.00 | ||||||||||||
| NFP | 0.00 | ||||||||||||
| New | 75,000.00 | 17,000.00 | 32,500.00 | 45,800.00 | 170,300.00 | ||||||||
| Renewal | 25,500.00 | 25,000.00 | 50,500.00 | ||||||||||
| Total NFP | $0.00 | $0.00 | $0.00 | $25,500.00 | $75,000.00 | $0.00 | $0.00 | $17,000.00 | $25,000.00 | $32,500.00 | $45,800.00 | $0.00 | $220,800.00 |
| School | 0.00 | ||||||||||||
| New | 17,500.00 | 17,500.00 | |||||||||||
| Total School | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $17,500.00 | $0.00 | $17,500.00 |
| Total Service Income | $0.00 | $0.00 | $0.00 | $25,500.00 | $75,000.00 | $0.00 | $0.00 | $17,000.00 | $25,000.00 | $32,500.00 | $63,300.00 | $0.00 | $238,300.00 |
| xDiscounts given | -5,000.00 | -5,000.00 | -125,000.00 | -15,000.00 | -15,000.00 | -2,500.00 | -14,750.00 | -39,550.00 | -221,800.00 | ||||
| xOther Income | 0.00 | ||||||||||||
| Professional Development | 200.00 | 200.00 | |||||||||||
| Total xOther Income | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $200.00 | $0.00 | $0.00 | $0.00 | $0.00 | $200.00 |
| Total Income | $15,000.00 | $25,000.00 | $83,500.00 | $68,000.00 | $89,000.00 | $125,000.00 | $24,000.00 | $32,200.00 | $180,000.00 | $78,134.00 | $173,750.00 | $16,750.00 | $910,334.00 |
| Cost of Goods Sold | |||||||||||||
| Customer Support (After Sale) | 0.00 | ||||||||||||
| Labor | 0.00 | ||||||||||||
| Contractors | 346.55 | 346.55 | |||||||||||
| Team Building & Training | 55.96 | 55.96 | |||||||||||
| Total Labor | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $402.51 | $0.00 | $0.00 | $0.00 | $0.00 | $402.51 |
| Total Customer Support (After Sale) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $402.51 | $0.00 | $0.00 | $0.00 | $0.00 | $402.51 |
| Inventory Shrinkage (deleted) | 0.00 | 0.00 | |||||||||||
| Research & Development (COGS) | 0.00 | ||||||||||||
| Data Infrastructure Base | 272.60 | 279.07 | 278.95 | 281.62 | 275.25 | 281.59 | 282.85 | 281.08 | 293.15 | 2,526.16 | |||
| Data Infrastructure Incremental | 113.95 | 113.95 | 113.95 | 341.85 | |||||||||
| Labor | 1,500.00 | 7,200.00 | 8,700.00 | ||||||||||
| Contractors | 3,000.00 | 3,000.00 | |||||||||||
| Total Labor | $0.00 | $3,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,500.00 | $7,200.00 | $11,700.00 |
| Software | 785.95 | 113.95 | 113.95 | 113.95 | 113.95 | 7,227.82 | 113.95 | 214.35 | 214.35 | 3,088.40 | 100.40 | 100.40 | 12,301.42 |
| Total Research & Development (COGS) | $1,058.55 | $3,393.02 | $392.90 | $395.57 | $389.20 | $7,509.41 | $396.80 | $495.43 | $507.50 | $3,202.35 | $1,714.35 | $7,414.35 | $26,869.43 |
| Total Cost of Goods Sold | $1,058.55 | $3,393.02 | $392.90 | $395.57 | $389.20 | $7,509.41 | $396.80 | $897.94 | $507.50 | $3,202.35 | $1,714.35 | $7,414.35 | $27,271.94 |
| Gross Profit | $13,941.45 | $21,606.98 | $83,107.10 | $67,604.43 | $88,610.80 | $117,490.59 | $23,603.20 | $31,302.06 | $179,492.50 | $74,931.65 | $172,035.65 | $9,335.65 | $883,062.06 |
| Expenses | |||||||||||||
| Digital Sales & Marketing | 0.00 | ||||||||||||
| Marketing Expenses | 0.00 | ||||||||||||
| Labor | 390.00 | 1,573.00 | 1,573.00 | 949.00 | 1,573.00 | 975.00 | 2,288.00 | 1,347.00 | 10,946.75 | 6,263.27 | 702.00 | 2,182.50 | 30,762.52 |
| Operating | 0.00 | ||||||||||||
| Design/Content Creation | 832.00 | 0.00 | 29.00 | 41.95 | 117.95 | 117.95 | 117.95 | 117.95 | 117.95 | 645.00 | 2,094.50 | 4,232.20 | |
| Facebook Spend | 16.90 | 3.00 | 775.00 | 1,367.38 | 673.40 | -178.66 | 2,657.02 | ||||||
| LinkedIn Spend | 87.19 | 87.19 | 87.19 | 87.19 | 87.19 | 174.38 | 261.57 | 261.57 | 261.57 | 1,198.83 | 261.57 | 2,855.44 | |
| Software | 390.21 | 440.27 | 454.20 | 693.70 | 767.03 | 1,175.87 | 770.02 | 881.56 | 843.89 | 843.45 | 865.39 | 1,082.20 | 9,207.79 |
| Twitter Spend | 130.75 | 130.75 | |||||||||||
| Website | 59.00 | 59.00 | 59.00 | 179.00 | 179.00 | 179.00 | 179.00 | 179.00 | 179.00 | 179.00 | 179.00 | 179.00 | 1,788.00 |
| Total Operating | $1,281.21 | $603.36 | $600.39 | $991.89 | $1,980.92 | $2,927.39 | $1,914.75 | $1,261.42 | $1,402.41 | $1,401.97 | $2,888.22 | $3,617.27 | $20,871.20 |
| Travel & Meals | 1,850.00 | 1,850.00 | |||||||||||
| Total Marketing Expenses | $1,671.21 | $2,176.36 | $2,173.39 | $1,940.89 | $3,553.92 | $3,902.39 | $4,202.75 | $2,608.42 | $12,349.16 | $7,665.24 | $3,590.22 | $7,649.77 | $53,483.72 |
| Sales Expenses | 0.00 | ||||||||||||
| Labor | 0.00 | ||||||||||||
| Contractors | 678.09 | 390.55 | 1,566.51 | 5,558.25 | 2,331.21 | 2,387.50 | 1,807.67 | 3,640.78 | 328.95 | 694.50 | 1,650.89 | 3,717.14 | 24,752.04 |
| Team Building & Training | 10.00 | 5.00 | 15.00 | ||||||||||
| Total Labor | $678.09 | $390.55 | $1,566.51 | $5,558.25 | $2,331.21 | $2,387.50 | $1,807.67 | $3,640.78 | $338.95 | $694.50 | $1,655.89 | $3,717.14 | $24,767.04 |
| Total Sales Expenses | $678.09 | $390.55 | $1,566.51 | $5,558.25 | $2,331.21 | $2,387.50 | $1,807.67 | $3,640.78 | $338.95 | $694.50 | $1,655.89 | $3,717.14 | $24,767.04 |
| Total Digital Sales & Marketing | $2,349.30 | $2,566.91 | $3,739.90 | $7,499.14 | $5,885.13 | $6,289.89 | $6,010.42 | $6,249.20 | $12,688.11 | $8,359.74 | $5,246.11 | $11,366.91 | $78,250.76 |
| Direct Sales & Marketing | 0.00 | ||||||||||||
| Marketing Expenses | 0.00 | ||||||||||||
| Operating | 9,577.90 | 9,577.90 | |||||||||||
| Collateral (Banners, Pens, Swag) | 61.59 | 119.75 | 1,155.27 | 19.12 | 494.89 | 45.33 | 1,895.95 | ||||||
| Event Sponsorship | 2,400.00 | 2,500.00 | 737.00 | 5,637.00 | |||||||||
| Market Research | 520.00 | 520.00 | |||||||||||
| Partnerships/Dues/Subscriptions | 5,000.00 | 5,950.00 | 2,500.00 | 3,500.00 | 16,950.00 | ||||||||
| Software | 191.92 | 191.92 | 191.92 | 191.92 | 191.92 | 191.92 | 191.92 | 191.92 | 209.19 | 209.19 | 209.19 | 2,162.93 | |
| Total Operating | $773.51 | $191.92 | $191.92 | $191.92 | $12,169.82 | $7,811.67 | $191.92 | $5,950.00 | $3,847.19 | $3,728.31 | $704.08 | $991.52 | $36,743.78 |
| Travel & Meals | 90.00 | 47.00 | 585.89 | 722.89 | |||||||||
| Total Marketing Expenses | $773.51 | $191.92 | $191.92 | $191.92 | $12,259.82 | $7,858.67 | $191.92 | $5,950.00 | $3,847.19 | $3,728.31 | $704.08 | $1,577.41 | $37,466.67 |
| Sales Expenses | 0.00 | ||||||||||||
| Labor | 540.00 | 540.00 | |||||||||||
| Contractors | 899.00 | 2,500.00 | 3,500.00 | 432.00 | 7,331.00 | ||||||||
| Team Building & Training | 169.15 | 102.04 | 271.19 | ||||||||||
| Total Labor | $899.00 | $169.15 | $0.00 | $0.00 | $2,500.00 | $102.04 | $0.00 | $3,500.00 | $0.00 | $0.00 | $540.00 | $432.00 | $8,142.19 |
| Operating | 0.00 | ||||||||||||
| Software | 20.13 | 20.13 | 20.13 | 20.13 | 20.13 | 26.18 | 26.18 | 26.18 | 29.21 | 29.21 | 29.21 | 29.21 | 296.03 |
| Total Operating | $20.13 | $20.13 | $20.13 | $20.13 | $20.13 | $26.18 | $26.18 | $26.18 | $29.21 | $29.21 | $29.21 | $29.21 | $296.03 |
| Travel & Meals | 0.00 | ||||||||||||
| Air Travel | 69.95 | 547.90 | 92.10 | 246.59 | 1,325.69 | 2,282.23 | |||||||
| Hotel | 1,247.62 | 1,292.96 | 2,540.58 | ||||||||||
| Incidentals | 39.98 | 39.98 | |||||||||||
| Internet | 22.29 | 20.00 | 172.50 | 214.79 | |||||||||
| Meals | 60.42 | 138.21 | 101.03 | 60.18 | 95.83 | 112.13 | 16.80 | 256.80 | 35.49 | 1,328.05 | 447.24 | 2,652.18 | |
| Transportation (Land) | 84.68 | 139.03 | 93.67 | 47.72 | 169.72 | 306.75 | 571.44 | 253.53 | 414.39 | 187.55 | 835.48 | 808.15 | 3,912.11 |
| Travel Meals | 0.00 | 0.00 | |||||||||||
| Total Travel & Meals | $167.39 | $297.24 | $194.70 | $107.90 | $265.55 | $418.88 | $658.19 | $510.33 | $1,170.28 | $279.65 | $3,657.74 | $3,914.02 | $11,641.87 |
| Total Sales Expenses | $1,086.52 | $486.52 | $214.83 | $128.03 | $2,785.68 | $547.10 | $684.37 | $4,036.51 | $1,199.49 | $308.86 | $4,226.95 | $4,375.23 | $20,080.09 |
| Total Direct Sales & Marketing | $1,860.03 | $678.44 | $406.75 | $319.95 | $15,045.50 | $8,405.77 | $876.29 | $9,986.51 | $5,046.68 | $4,037.17 | $4,931.03 | $5,952.64 | $57,546.76 |
| General/Admin | 2,158.00 | 2,158.00 | |||||||||||
| Labor | 0.00 | ||||||||||||
| Contractors | 494.40 | 15.00 | 270.71 | 90.74 | 298.28 | 1,892.59 | 932.70 | 800.00 | 800.00 | 600.00 | 1,080.00 | 2,950.85 | 10,225.27 |
| Recruiting | 100.00 | 25.00 | 125.00 | ||||||||||
| Team Building & Training | 1,239.00 | 2,270.97 | 64.00 | 1,919.00 | 380.99 | 64.00 | 378.98 | 316.99 | 3,703.95 | 39.00 | 139.98 | 378.00 | 10,894.86 |
| Total Labor | $1,733.40 | $2,285.97 | $334.71 | $2,009.74 | $779.27 | $1,956.59 | $1,336.68 | $1,116.99 | $4,503.95 | $639.00 | $1,219.98 | $3,328.85 | $21,245.13 |
| Operating | 0.00 | ||||||||||||
| Bank & Processing Fees | 25.00 | 25.00 | 25.00 | 25.00 | 194.00 | 190.00 | 484.00 | ||||||
| Bank Charges | -0.01 | 11.99 | 11.98 | ||||||||||
| Total Bank & Processing Fees | $25.00 | $25.00 | $24.99 | $25.00 | $11.99 | $0.00 | $0.00 | $0.00 | $194.00 | $190.00 | $0.00 | $0.00 | $495.98 |
| Donations | 200.00 | 2,500.00 | 15.00 | 15.00 | 2,515.00 | 15.00 | 15.00 | 15.00 | 15.00 | 15.00 | 478.78 | 5,798.78 | |
| Dues & Subscriptions | 596.45 | 159.00 | 250.00 | 1,005.45 | |||||||||
| Equipment | 137.48 | 1,520.14 | 2,158.83 | 4.25 | 859.48 | 7,592.54 | 65.10 | 2,560.53 | 9.99 | 2,641.00 | 9.99 | 243.28 | 17,802.61 |
| Gifts | 31.60 | 42.26 | 175.80 | 103.79 | 801.67 | 284.66 | 1,439.78 | ||||||
| Insurance | 129.51 | 129.51 | 129.48 | 129.48 | 800.96 | 129.51 | 259.02 | 143.11 | 286.22 | 2,136.80 | |||
| Interest Paid | 925.17 | 801.04 | 864.67 | 630.64 | 569.15 | 656.24 | 561.61 | 619.19 | 599.24 | 694.98 | 849.26 | 1,042.11 | 8,813.30 |
| Legal & Professional Services | 474.00 | 599.00 | 1,073.00 | ||||||||||
| Accounting | 1,642.50 | 1,290.50 | 700.00 | 1,250.00 | 2,200.00 | 5,250.00 | 12,333.00 | ||||||
| Legal | 239.99 | 39.99 | 39.99 | 4,498.98 | 39.99 | 39.99 | 362.99 | -60.01 | 68,424.99 | 73,626.90 | |||
| Total Legal & Professional Services | $713.99 | $1,682.49 | $1,330.49 | $5,198.98 | $39.99 | $1,289.99 | $2,562.99 | -$60.01 | $69,023.99 | $0.00 | $0.00 | $5,250.00 | $87,032.90 |
| Office Supplies | 178.96 | 86.22 | 344.62 | -10.05 | 1.99 | 139.95 | 741.69 | ||||||
| Other Business Expenses | 100.00 | 395.00 | 75.22 | 570.22 | |||||||||
| Rent & Lease | 245.00 | 45.00 | 45.00 | 75.00 | 410.00 | ||||||||
| Shipping | 215.89 | 11.85 | 11.97 | 7.62 | 173.60 | 464.95 | 250.75 | 1,136.63 | |||||
| Software | 1,367.14 | 799.80 | 801.37 | 813.37 | 2,530.44 | 1,240.18 | 1,086.41 | 1,208.58 | 1,117.98 | 11,393.25 | 1,413.75 | 1,534.86 | 25,307.13 |
| Taxes & Licenses | 76.69 | 26.00 | 102.69 | ||||||||||
| Total Operating | $4,138.14 | $5,717.25 | $8,500.71 | $6,895.21 | $4,026.05 | $14,106.88 | $4,596.42 | $4,877.69 | $71,532.77 | $15,152.56 | $3,879.62 | $9,370.66 | $152,793.96 |
| Travel & Meals | 19.63 | 19.63 | |||||||||||
| Meals & Entertainment | 53.80 | 106.49 | 74.60 | 104.93 | 20.57 | 3,272.85 | 3,633.24 | ||||||
| Total Travel & Meals | $0.00 | $19.63 | $0.00 | $53.80 | $0.00 | $0.00 | $106.49 | $74.60 | $104.93 | $0.00 | $20.57 | $3,272.85 | $3,652.87 |
| Total General/Admin | $8,029.54 | $8,022.85 | $8,835.42 | $8,958.75 | $4,805.32 | $16,063.47 | $6,039.59 | $6,069.28 | $76,141.65 | $15,791.56 | $5,120.17 | $15,972.36 | $179,849.96 |
| Payroll Expenses | 0.00 | ||||||||||||
| Company Benefits & Contributions | 0.00 | ||||||||||||
| Athletic Facilities | 383.50 | 21.00 | 58.82 | 68.91 | 21.00 | 201.00 | 231.00 | 231.00 | 231.00 | 244.79 | 231.00 | 376.78 | 2,299.80 |
| Cell Service | 537.35 | 436.01 | 451.35 | 732.51 | 378.43 | 396.76 | 396.76 | 322.56 | 416.61 | 416.10 | 416.10 | 4,900.54 | |
| Medical Benefits | 3,087.40 | 396.60 | 2,510.10 | 3,342.19 | 2,375.06 | 4,033.16 | 4,737.85 | 6,586.01 | 4,757.59 | 3,827.01 | 4,487.67 | 6,005.98 | 46,146.62 |
| Retirement Benefits | 3,048.85 | 3,048.85 | |||||||||||
| Total Company Benefits & Contributions | $7,057.10 | $853.61 | $3,020.27 | $4,143.61 | $2,774.49 | $4,630.92 | $5,365.61 | $7,139.57 | $5,405.20 | $4,487.90 | $5,134.77 | $6,382.76 | $56,395.81 |
| Company Contributions | 0.00 | ||||||||||||
| Retirement | 487.50 | 1,055.78 | 1,583.67 | 1,055.78 | 1,881.36 | 1,448.07 | 1,564.02 | 1,951.54 | 2,500.95 | 1,773.81 | 1,787.70 | 17,090.18 | |
| Total Company Contributions | $0.00 | $487.50 | $1,055.78 | $1,583.67 | $1,055.78 | $1,881.36 | $1,448.07 | $1,564.02 | $1,951.54 | $2,500.95 | $1,773.81 | $1,787.70 | $17,090.18 |
| Reimbursements | 649.99 | 649.99 | |||||||||||
| Salary & Wages | 0.00 | ||||||||||||
| C-level - Salaries | 15,769.22 | 31,538.44 | 31,538.44 | 78,846.10 | |||||||||
| Marketing - Salaries | 5,384.62 | 19,126.94 | 16,512.90 | 41,024.46 | |||||||||
| Operations - Salaries | 3,076.92 | 6,153.84 | 6,153.84 | 15,384.60 | |||||||||
| Sales - Salaries | 2,692.31 | 5,384.62 | 5,384.62 | 13,461.55 | |||||||||
| Total Salary & Wages | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $26,923.07 | $62,203.84 | $59,589.80 | $148,716.71 |
| Taxes | 2,843.33 | 1,440.46 | 2,966.37 | 4,282.74 | 2,773.18 | 5,407.45 | 4,605.98 | 5,101.67 | 4,908.69 | 6,163.59 | 4,809.94 | 4,565.66 | 49,869.06 |
| Wages | 37,115.37 | 18,173.08 | 35,192.32 | 52,788.48 | 35,192.32 | 64,461.56 | 48,269.24 | 58,288.44 | 58,897.83 | 53,365.37 | 461,744.01 | ||
| Total Payroll Expenses | $47,665.79 | $20,954.65 | $42,234.74 | $62,798.50 | $41,795.77 | $76,381.29 | $59,688.90 | $72,093.70 | $71,163.26 | $93,440.88 | $73,922.36 | $72,325.92 | $734,465.76 |
| Research & Development | 0.00 | ||||||||||||
| Operating | 0.00 | ||||||||||||
| Research | 53.11 | 285.07 | 293.42 | 293.31 | 924.91 | ||||||||
| Total Operating | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $53.11 | $0.00 | $0.00 | $285.07 | $293.42 | $293.31 | $924.91 |
| Total Research & Development | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $53.11 | $0.00 | $0.00 | $285.07 | $293.42 | $293.31 | $924.91 |
| Total Expenses | $59,904.66 | $32,222.85 | $55,216.81 | $79,576.34 | $67,531.72 | $107,140.42 | $72,668.31 | $94,398.69 | $165,039.70 | $121,914.42 | $89,513.09 | $105,911.14 | $1,051,038.15 |
| Net Operating Income | -$45,963.21 | -$10,615.87 | $27,890.29 | -$11,971.91 | $21,079.08 | $10,350.17 | -$49,065.11 | -$63,096.63 | $14,452.80 | -$46,982.77 | $82,522.56 | -$96,575.49 | -$167,976.09 |
| Other Expenses | |||||||||||||
| Other Miscellaneous Expense | -7,500.00 | 7,500.00 | 0.00 | ||||||||||
| Total Other Expenses | $0.00 | $0.00 | $0.00 | -$7,500.00 | $7,500.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Other Income | $0.00 | $0.00 | $0.00 | $7,500.00 | -$7,500.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income | -$45,963.21 | -$10,615.87 | $27,890.29 | -$4,471.91 | $13,579.08 | $10,350.17 | -$49,065.11 | -$63,096.63 | $14,452.80 | -$46,982.77 | $82,522.56 | -$96,575.49 | -$167,976.09 |
| FORECAST | |||||||||||||
| Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Total | |
| Income | |||||||||||||
| Sales of Product Income | |||||||||||||
| NFP | |||||||||||||
| New | |||||||||||||
| Total NFP | |||||||||||||
| School | |||||||||||||
| New | |||||||||||||
| Renewal | |||||||||||||
| Total School | |||||||||||||
| Total Sales of Product Income | |||||||||||||
| Service Income | |||||||||||||
| NFP | |||||||||||||
| New | |||||||||||||
| Renewal | |||||||||||||
| Total NFP | |||||||||||||
| School | |||||||||||||
| New | |||||||||||||
| Total School | |||||||||||||
| Total Service Income | |||||||||||||
| xDiscounts given | |||||||||||||
| xOther Income | |||||||||||||
| Professional Development | |||||||||||||
| Total xOther Income | |||||||||||||
| Total Income | |||||||||||||
| Cost of Goods Sold | |||||||||||||
| Customer Support (After Sale) | |||||||||||||
| Labor | |||||||||||||
| Contractors | |||||||||||||
| Team Building & Training | |||||||||||||
| Total Labor | |||||||||||||
| Total Customer Support (After Sale) | |||||||||||||
| Inventory Shrinkage (deleted) | |||||||||||||
| Research & Development (COGS) | |||||||||||||
| Data Infrastructure Base | |||||||||||||
| Data Infrastructure Incremental | |||||||||||||
| Labor | |||||||||||||
| Contractors | |||||||||||||
| Total Labor | |||||||||||||
| Software | |||||||||||||
| Total Research & Development (COGS) | |||||||||||||
| Total Cost of Goods Sold | |||||||||||||
| Gross Profit | |||||||||||||
| Expenses | |||||||||||||
| Digital Sales & Marketing | |||||||||||||
| Marketing Expenses | |||||||||||||
| Labor | |||||||||||||
| Operating | |||||||||||||
| Design/Content Creation | |||||||||||||
| Facebook Spend | |||||||||||||
| LinkedIn Spend | |||||||||||||
| Software | |||||||||||||
| Twitter Spend | |||||||||||||
| Website | |||||||||||||
| Total Operating | |||||||||||||
| Travel & Meals | |||||||||||||
| Total Marketing Expenses | |||||||||||||
| Sales Expenses | |||||||||||||
| Labor | |||||||||||||
| Contractors | |||||||||||||
| Team Building & Training | |||||||||||||
| Total Labor | |||||||||||||
| Total Sales Expenses | |||||||||||||
| Total Digital Sales & Marketing | |||||||||||||
| Direct Sales & Marketing | |||||||||||||
| Marketing Expenses | |||||||||||||
| Operating | |||||||||||||
| Collateral (Banners, Pens, Swag) | |||||||||||||
| Event Sponsorship | |||||||||||||
| Market Research | |||||||||||||
| Partnerships/Dues/Subscriptions | |||||||||||||
| Software | |||||||||||||
| Total Operating | |||||||||||||
| Travel & Meals | |||||||||||||
| Total Marketing Expenses | |||||||||||||
| Sales Expenses | |||||||||||||
| Labor | |||||||||||||
| Contractors | |||||||||||||
| Team Building & Training | |||||||||||||
| Total Labor | |||||||||||||
| Operating | |||||||||||||
| Software | |||||||||||||
| Total Operating | |||||||||||||
| Travel & Meals | |||||||||||||
| Air Travel | |||||||||||||
| Hotel | |||||||||||||
| Incidentals | |||||||||||||
| Internet | |||||||||||||
| Meals | |||||||||||||
| Transportation (Land) | |||||||||||||
| Travel Meals | |||||||||||||
| Total Travel & Meals | |||||||||||||
| Total Sales Expenses | |||||||||||||
| Total Direct Sales & Marketing | |||||||||||||
| General/Admin | |||||||||||||
| Labor | |||||||||||||
| Contractors | |||||||||||||
| Recruiting | |||||||||||||
| Team Building & Training | |||||||||||||
| Total Labor | |||||||||||||
| Operating | |||||||||||||
| Bank & Processing Fees | |||||||||||||
| Bank Charges | |||||||||||||
| Total Bank & Processing Fees | |||||||||||||
| Donations | |||||||||||||
| Dues & Subscriptions | |||||||||||||
| Equipment | |||||||||||||
| Gifts | |||||||||||||
| Insurance | |||||||||||||
| Interest Paid | |||||||||||||
| Legal & Professional Services | |||||||||||||
| Accounting | |||||||||||||
| Legal | |||||||||||||
| Total Legal & Professional Services | |||||||||||||
| Office Supplies | |||||||||||||
| Other Business Expenses | |||||||||||||
| Rent & Lease | |||||||||||||
| Shipping | |||||||||||||
| Software | |||||||||||||
| Taxes & Licenses | |||||||||||||
| Total Operating | |||||||||||||
| Travel & Meals | |||||||||||||
| Meals & Entertainment | |||||||||||||
| Total Travel & Meals | |||||||||||||
| Total General/Admin | |||||||||||||
| Payroll Expenses | |||||||||||||
| Company Benefits & Contributions | |||||||||||||
| Athletic Facilities | |||||||||||||
| Cell Service | |||||||||||||
| Medical Benefits | |||||||||||||
| Retirement Benefits | |||||||||||||
| Total Company Benefits & Contributions | |||||||||||||
| Company Contributions | |||||||||||||
| Retirement | |||||||||||||
| Total Company Contributions | |||||||||||||
| Reimbursements | |||||||||||||
| Salary & Wages | |||||||||||||
| C-level - Salaries | |||||||||||||
| Marketing - Salaries | |||||||||||||
| Operations - Salaries | |||||||||||||
| Sales - Salaries | |||||||||||||
| Total Salary & Wages | |||||||||||||
| Taxes | |||||||||||||
| Wages | |||||||||||||
| Total Payroll Expenses | |||||||||||||
| Research & Development | |||||||||||||
| Operating | |||||||||||||
| Research | |||||||||||||
| Total Operating | |||||||||||||
| Total Research & Development | |||||||||||||
| Total Expenses | |||||||||||||
| Net Operating Income | |||||||||||||
| Other Expenses | |||||||||||||
| Other Miscellaneous Expense | |||||||||||||
| Total Other Expenses | |||||||||||||
| Net Other Income | |||||||||||||
| Net Income |
Balance Sheet
| Innovare - Social Innovation Partners | ||||||||||||
| Balance Sheet | ||||||||||||
| HISTORICAL | ||||||||||||
| Jul 2020 | Aug 2020 | Sep 2020 | Oct 2020 | Nov 2020 | Dec 2020 | Jan 2021 | Feb 2021 | Mar 2021 | Apr 2021 | May 2021 | Jun 2021 | |
| ASSETS | ||||||||||||
| Current Assets | ||||||||||||
| Bank Accounts | ||||||||||||
| TOTAL BUS CHK (8622) | 161,779.73 | 163,344.81 | 261,609.75 | 251,327.59 | 267,084.79 | 294,518.66 | 383,910.71 | 351,842.79 | 329,517.02 | 257,450.87 | 205,219.94 | 188,930.64 |
| Total Bank Accounts | $161,779.73 | $163,344.81 | $261,609.75 | $251,327.59 | $267,084.79 | $294,518.66 | $383,910.71 | $351,842.79 | $329,517.02 | $257,450.87 | $205,219.94 | $188,930.64 |
| Accounts Receivable | ||||||||||||
| Accounts Receivable (A/R) | 132,500.00 | 103,750.00 | 166,000.00 | 184,000.00 | 195,000.00 | 213,500.00 | 79,000.00 | 56,000.00 | 180,000.00 | 233,134.00 | 379,384.00 | 282,634.00 |
| Total Accounts Receivable | $132,500.00 | $103,750.00 | $166,000.00 | $184,000.00 | $195,000.00 | $213,500.00 | $79,000.00 | $56,000.00 | $180,000.00 | $233,134.00 | $379,384.00 | $282,634.00 |
| Other Current Assets | ||||||||||||
| Inventory Asset | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Undeposited Funds | 0.00 | 0.00 | 6,250.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total Other Current Assets | $0.00 | $0.00 | $6,250.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total Current Assets | $294,279.73 | $267,094.81 | $433,859.75 | $435,327.59 | $462,084.79 | $508,018.66 | $462,910.71 | $407,842.79 | $509,517.02 | $490,584.87 | $584,603.94 | $471,564.64 |
| TOTAL ASSETS | $294,279.73 | $267,094.81 | $433,859.75 | $435,327.59 | $462,084.79 | $508,018.66 | $462,910.71 | $407,842.79 | $509,517.02 | $490,584.87 | $584,603.94 | $471,564.64 |
| LIABILITIES AND EQUITY | ||||||||||||
| Liabilities | ||||||||||||
| Current Liabilities | ||||||||||||
| Accounts Payable | ||||||||||||
| Accounts Payable (A/P) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,000.00 |
| Total Accounts Payable | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,000.00 |
| Credit Cards | ||||||||||||
| Chase Credit Cards | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Chase Ink (9835) | 27,508.13 | 23,976.40 | 15,953.02 | 17,147.04 | 18,984.65 | 24,430.60 | 25,624.37 | 29,006.92 | 33,782.04 | 47,948.28 | 49,311.47 | 49,277.43 |
| SWA VISA (4463) | 21,065.87 | 17,696.43 | 13,006.54 | 14,708.05 | 23,201.10 | 15,324.15 | 15,854.24 | 15,648.83 | 15,943.31 | 15,781.93 | 15,711.67 | 17,065.28 |
| United Credit Card (7341) | 13,727.89 | 10,978.43 | 7,743.02 | 7,739.98 | 7,676.42 | 2,864.63 | 2,899.24 | 2,958.05 | 2,928.02 | 6,100.31 | 7,248.05 | 7,175.35 |
| Total Chase Credit Cards | $62,301.89 | $52,651.26 | $36,702.58 | $39,595.07 | $49,862.17 | $42,619.38 | $44,377.85 | $47,613.80 | $52,653.37 | $69,830.52 | $72,271.19 | $73,518.06 |
| CitiBusiness / AAdvantage Platinum (1195) | 2,737.67 | 3,445.50 | 1,844.43 | 170.10 | 3,593.22 | 1,352.63 | 739.47 | 684.87 | 2,347.96 | 203.19 | 2,430.91 | 4,831.24 |
| Divvy CC | 2,172.04 | 1,199.00 | 2,849.85 | 3,183.53 | 2,827.37 | 5,778.65 | 3,504.45 | 2,364.42 | 1,690.66 | 4,611.91 | 2,386.76 | 6,437.80 |
| Total Credit Cards | $67,211.60 | $57,295.76 | $41,396.86 | $42,948.70 | $56,282.76 | $49,750.66 | $48,621.77 | $50,663.09 | $56,691.99 | $74,645.62 | $77,088.86 | $84,787.10 |
| Other Current Liabilities | ||||||||||||
| Direct Deposit Payable | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Payroll Liabilities | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| CO Income Tax | 73.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| CO Local Tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| CO Unemployment Tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| CT Income Tax | 0.00 | 0.00 | 0.00 | 0.00 | 358.33 | 615.59 | 486.96 | 486.96 | 744.22 | 1,001.48 | -77.65 | |
| CT Paid Family and Medical Leave | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 26.92 | 53.84 | 80.76 | 40.38 | 67.30 | 91.40 | |
| CT Unemployment Tax | 0.00 | 0.00 | 0.00 | 0.00 | 228.31 | 400.62 | 572.93 | 480.00 | 0.00 | 0.00 | 0.00 | |
| Federal Taxes (941/944) | 3,089.29 | 0.00 | 0.00 | 4,792.65 | 4,792.57 | 0.00 | 0.00 | 0.00 | 0.00 | 7,502.47 | 8,185.74 | 0.00 |
| Federal Unemployment (940) | 0.00 | 23.66 | 82.38 | 84.00 | 84.00 | 168.00 | 444.70 | 554.42 | 158.62 | 158.62 | 200.62 | 200.62 |
| IL Income Tax | 1,562.10 | 650.72 | 1,301.44 | 1,952.16 | 1,301.44 | 1,986.04 | 1,415.19 | 1,586.13 | 1,587.28 | 2,395.49 | 1,612.86 | 1,612.86 |
| IL Unemployment Tax | 0.00 | 16.23 | 48.68 | 30.95 | 30.95 | 30.95 | 200.72 | 394.98 | 452.95 | 21.15 | 21.15 | 21.15 |
| MA Income Tax | 62.11 | 310.65 | 434.92 | 434.92 | 764.36 | 999.54 | 519.01 | 204.25 | 536.83 | 1,053.39 | 432.25 | |
| MA Paid Family and Medical Leave | 10.10 | 50.50 | 70.70 | 70.70 | 97.67 | 118.03 | 91.22 | 106.08 | 75.54 | 127.49 | 171.69 | |
| MA Unemployment Tax | 5.33 | 168.27 | 230.09 | 230.09 | 393.91 | 517.55 | 405.97 | 4.83 | 4.83 | 14.19 | 4.45 | |
| MD Income Tax | 0.00 | 0.00 | 413.86 | 827.72 | 1,241.58 | 1,448.51 | 1,448.51 | 0.00 | 0.00 | 0.00 | 0.00 | |
| MD Unemployment Tax | 0.00 | 0.00 | 140.00 | 221.00 | 221.00 | 361.00 | 442.00 | 221.00 | 0.00 | 0.00 | 0.00 | |
| NY MCTMT Employer Tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| NYS Employment Taxes | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 196.93 | 377.60 | 0.00 | 0.00 | 0.00 | |
| NYS Income Tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 312.30 | 624.60 | 468.45 | 780.75 | 312.30 | |
| SMPLIRA | 3,611.85 | 914.88 | 4,594.66 | 2,795.16 | 2,795.16 | -1,585.80 | 2,488.96 | 8,011.98 | -2,013.88 | 972.50 | 8,959.85 | -2,013.88 |
| TX Unemployment Tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total Payroll Liabilities | $8,336.24 | $1,683.03 | $6,556.58 | $10,944.49 | $10,788.55 | $3,904.35 | $9,037.33 | $15,077.18 | $2,771.05 | $12,920.48 | $22,024.82 | $755.19 |
| Total Other Current Liabilities | $8,336.24 | $1,683.03 | $6,556.58 | $10,944.49 | $10,788.55 | $3,904.35 | $9,037.33 | $15,077.18 | $2,771.05 | $12,920.48 | $22,024.82 | $755.19 |
| Total Current Liabilities | $75,547.84 | $58,978.79 | $47,953.44 | $53,893.19 | $67,071.31 | $53,655.01 | $57,659.10 | $65,740.27 | $59,463.04 | $87,566.10 | $99,113.68 | $86,542.29 |
| Long-Term Liabilities | ||||||||||||
| Notes Payable | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| CHICAGO ERF | 0.00 | 0.00 | 0.00 | 0.00 | 50,000.00 | 49,953.07 | 49,900.61 | 49,852.27 | 49,799.83 | 49,748.76 | 45,856.34 | |
| SBA EIDL | 0.00 | 149,900.00 | 149,900.00 | 149,900.00 | 149,900.00 | 149,900.00 | 149,900.00 | 149,900.00 | 149,900.00 | 149,900.00 | 149,900.00 | |
| SBA PPP | 80,000.00 | 80,000.00 | 80,000.00 | 80,000.00 | 80,000.00 | 80,000.00 | 80,000.00 | 80,000.00 | 173,547.00 | 173,547.00 | 173,547.00 | 173,547.00 |
| Total Notes Payable | $80,000.00 | $80,000.00 | $229,900.00 | $229,900.00 | $229,900.00 | $279,900.00 | $279,853.07 | $279,800.61 | $373,299.27 | $373,246.83 | $373,195.76 | $369,303.34 |
| Total Long-Term Liabilities | $80,000.00 | $80,000.00 | $229,900.00 | $229,900.00 | $229,900.00 | $279,900.00 | $279,853.07 | $279,800.61 | $373,299.27 | $373,246.83 | $373,195.76 | $369,303.34 |
| Total Liabilities | $155,547.84 | $138,978.79 | $277,853.44 | $283,793.19 | $296,971.31 | $333,555.01 | $337,512.17 | $345,540.88 | $432,762.31 | $460,812.93 | $472,309.44 | $455,845.63 |
| Equity | ||||||||||||
| Opening Balance Equity | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 | -10,903.87 |
| Owner's Equity | -526.85 | -526.85 | -526.85 | -526.85 | -526.85 | -1,526.85 | -1,526.85 | -1,526.85 | -1,526.85 | -1,526.85 | -1,526.85 | -1,526.85 |
| Retained Earnings | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 | 196,125.82 |
| Net Income | -45,963.21 | -56,579.08 | -28,688.79 | -33,160.70 | -19,581.62 | -9,231.45 | -58,296.56 | -121,393.19 | -106,940.39 | -153,923.16 | -71,400.60 | -167,976.09 |
| Total Equity | $138,731.89 | $128,116.02 | $156,006.31 | $151,534.40 | $165,113.48 | $174,463.65 | $125,398.54 | $62,301.91 | $76,754.71 | $29,771.94 | $112,294.50 | $15,719.01 |
| TOTAL LIABILITIES AND EQUITY | $294,279.73 | $267,094.81 | $433,859.75 | $435,327.59 | $462,084.79 | $508,018.66 | $462,910.71 | $407,842.79 | $509,517.02 | $490,584.87 | $584,603.94 | $471,564.64 |
| FORECAST | ||||||||||||
| Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | |
| ASSETS | ||||||||||||
| Current Assets | ||||||||||||
| Bank Accounts | ||||||||||||
| TOTAL BUS CHK (8622) | ||||||||||||
| Total Bank Accounts | ||||||||||||
| Accounts Receivable | ||||||||||||
| Accounts Receivable (A/R) | ||||||||||||
| Total Accounts Receivable | ||||||||||||
| Other Current Assets | ||||||||||||
| Inventory Asset | ||||||||||||
| Undeposited Funds | ||||||||||||
| Total Other Current Assets | ||||||||||||
| Total Current Assets | ||||||||||||
| TOTAL ASSETS | ||||||||||||
| LIABILITIES AND EQUITY | ||||||||||||
| Liabilities | ||||||||||||
| Current Liabilities | ||||||||||||
| Accounts Payable | ||||||||||||
| Accounts Payable (A/P) | ||||||||||||
| Total Accounts Payable | ||||||||||||
| Credit Cards | ||||||||||||
| Chase Credit Cards | ||||||||||||
| Chase Ink (9835) | ||||||||||||
| SWA VISA (4463) | ||||||||||||
| United Credit Card (7341) | ||||||||||||
| Total Chase Credit Cards | ||||||||||||
| CitiBusiness / AAdvantage Platinum (1195) | ||||||||||||
| Divvy CC | ||||||||||||
| Total Credit Cards | ||||||||||||
| Other Current Liabilities | ||||||||||||
| Direct Deposit Payable | ||||||||||||
| Payroll Liabilities | ||||||||||||
| CO Income Tax | ||||||||||||
| CO Local Tax | ||||||||||||
| CO Unemployment Tax | ||||||||||||
| CT Income Tax | ||||||||||||
| CT Paid Family and Medical Leave | ||||||||||||
| CT Unemployment Tax | ||||||||||||
| Federal Taxes (941/944) | ||||||||||||
| Federal Unemployment (940) | ||||||||||||
| IL Income Tax | ||||||||||||
| IL Unemployment Tax | ||||||||||||
| MA Income Tax | ||||||||||||
| MA Paid Family and Medical Leave | ||||||||||||
| MA Unemployment Tax | ||||||||||||
| MD Income Tax | ||||||||||||
| MD Unemployment Tax | ||||||||||||
| NY MCTMT Employer Tax | ||||||||||||
| NYS Employment Taxes | ||||||||||||
| NYS Income Tax | ||||||||||||
| SMPLIRA | ||||||||||||
| TX Unemployment Tax | ||||||||||||
| Total Payroll Liabilities | ||||||||||||
| Total Other Current Liabilities | ||||||||||||
| Total Current Liabilities | ||||||||||||
| Long-Term Liabilities | ||||||||||||
| Notes Payable | ||||||||||||
| CHICAGO ERF | ||||||||||||
| SBA EIDL | ||||||||||||
| SBA PPP | ||||||||||||
| Total Notes Payable | ||||||||||||
| Total Long-Term Liabilities | ||||||||||||
| Total Liabilities | ||||||||||||
| Equity | ||||||||||||
| Opening Balance Equity | ||||||||||||
| Owner's Equity | ||||||||||||
| Retained Earnings | ||||||||||||
| Net Income | ||||||||||||
| Total Equity | ||||||||||||
| TOTAL LIABILITIES AND EQUITY |
Statement of Cash Flows
| Innovare - Social Innovation Partners | |||||||||||||
| Statement of Cash Flows | |||||||||||||
| HISTORICAL | |||||||||||||
| Jul 2020 | Aug 2020 | Sep 2020 | Oct 2020 | Nov 2020 | Dec 2020 | Jan 2021 | Feb 2021 | Mar 2021 | Apr 2021 | May 2021 | Jun 2021 | Total | |
| OPERATING ACTIVITIES | |||||||||||||
| Net Income | -45,963.21 | -10,615.87 | 27,890.29 | -4,471.91 | 13,579.08 | 10,350.17 | -49,065.11 | -63,096.63 | 14,452.80 | -46,982.77 | 82,522.56 | -96,575.49 | -167,976.09 |
| Adjustments to reconcile Net Income to Net Cash provided by operations: | 0.00 | ||||||||||||
| Accounts Receivable (A/R) | -6,000.00 | 28,750.00 | -62,250.00 | -18,000.00 | -11,000.00 | -18,500.00 | 134,500.00 | 23,000.00 | -124,000.00 | -53,134.00 | -146,250.00 | 96,750.00 | -156,134.00 |
| Inventory Asset | 0.00 | 0.00 | |||||||||||
| Accounts Payable (A/P) | 1,000.00 | 1,000.00 | |||||||||||
| Chase Credit Cards:Chase Ink (9835) | 2,984.73 | -3,531.73 | -8,023.38 | 1,194.02 | 1,837.61 | 5,445.95 | 1,193.77 | 3,382.55 | 4,775.12 | 14,166.24 | 1,363.19 | -34.04 | 24,754.03 |
| Chase Credit Cards:SWA VISA (4463) | 2,197.73 | -3,369.44 | -4,689.89 | 1,701.51 | 8,493.05 | -7,876.95 | 530.09 | -205.41 | 294.48 | -161.38 | -70.26 | 1,353.61 | -1,802.86 |
| Chase Credit Cards:United Credit Card (7341) | 278.00 | -2,749.46 | -3,235.41 | -3.04 | -63.56 | -4,811.79 | 34.61 | 58.81 | -30.03 | 3,172.29 | 1,147.74 | -72.70 | -6,274.54 |
| CitiBusiness / AAdvantage Platinum (1195) | 706.62 | 707.83 | -1,601.07 | -1,674.33 | 3,423.12 | -2,240.59 | -613.16 | -54.60 | 1,663.09 | -2,144.77 | 2,227.72 | 2,400.33 | 2,800.19 |
| Divvy CC | 2,172.04 | -973.04 | 1,650.85 | 333.68 | -356.16 | 2,951.28 | -2,274.20 | -1,140.03 | -673.76 | 2,921.25 | -2,225.15 | 4,051.04 | 6,437.80 |
| Direct Deposit Payable | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Payroll Liabilities:CO Income Tax | -91.00 | -73.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | -164.00 |
| Payroll Liabilities:CO Local Tax | -19.50 | -19.50 | |||||||||||
| Payroll Liabilities:CO Unemployment Tax | 0.00 | 0.00 | |||||||||||
| Payroll Liabilities:CT Income Tax | 358.33 | 257.26 | -128.63 | 0.00 | 257.26 | 257.26 | -1,079.13 | -77.65 | |||||
| Payroll Liabilities:CT Paid Family and Medical Leave | 26.92 | 26.92 | 26.92 | -40.38 | 26.92 | 24.10 | 91.40 | ||||||
| Payroll Liabilities:CT Unemployment Tax | 228.31 | 172.31 | 172.31 | -92.93 | -480.00 | 0.00 | 0.00 | 0.00 | |||||
| Payroll Liabilities:Federal Taxes (941/944) | 3,089.29 | -3,089.29 | 0.00 | 4,792.65 | -0.08 | -4,792.57 | 0.00 | 0.00 | 0.00 | 7,502.47 | 683.27 | -8,185.74 | 0.00 |
| Payroll Liabilities:Federal Unemployment (940) | 0.00 | 23.66 | 58.72 | 1.62 | 0.00 | 84.00 | 276.70 | 109.72 | -395.80 | 0.00 | 42.00 | 0.00 | 200.62 |
| Payroll Liabilities:IL Income Tax | 502.12 | -911.38 | 650.72 | 650.72 | -650.72 | 684.60 | -570.85 | 170.94 | 1.15 | 808.21 | -782.63 | 0.00 | 552.88 |
| Payroll Liabilities:IL Unemployment Tax | 0.00 | 16.23 | 32.45 | -17.73 | 0.00 | 0.00 | 169.77 | 194.26 | 57.97 | -431.80 | 0.00 | 0.00 | 21.15 |
| Payroll Liabilities:MA Income Tax | 62.11 | 248.54 | 124.27 | 0.00 | 329.44 | 235.18 | -480.53 | -314.76 | 332.58 | 516.56 | -621.14 | 432.25 | |
| Payroll Liabilities:MA Paid Family and Medical Leave | 10.10 | 40.40 | 20.20 | 0.00 | 26.97 | 20.36 | -26.81 | 14.86 | -30.54 | 51.95 | 44.20 | 171.69 | |
| Payroll Liabilities:MA Unemployment Tax | 5.33 | 162.94 | 61.82 | 0.00 | 163.82 | 123.64 | -111.58 | -401.14 | 0.00 | 9.36 | -9.74 | 4.45 | |
| Payroll Liabilities:MD Income Tax | 413.86 | 413.86 | 413.86 | 206.93 | 0.00 | -1,448.51 | 0.00 | 0.00 | 0.00 | ||||
| Payroll Liabilities:MD Unemployment Tax | 140.00 | 81.00 | 0.00 | 140.00 | 81.00 | -221.00 | -221.00 | 0.00 | |||||
| Payroll Liabilities:NY MCTMT Employer Tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||
| Payroll Liabilities:NYS Employment Taxes | 196.93 | 180.67 | -377.60 | 0.00 | 0.00 | 0.00 | |||||||
| Payroll Liabilities:NYS Income Tax | 312.30 | 312.30 | -156.15 | 312.30 | -468.45 | 312.30 | |||||||
| Payroll Liabilities:SMPLIRA | 3,611.85 | -2,696.97 | 3,679.78 | -1,799.50 | 0.00 | -4,380.96 | 4,074.76 | 5,523.02 | -10,025.86 | 2,986.38 | 7,987.35 | -10,973.73 | -2,013.88 |
| Payroll Liabilities:TX Unemployment Tax | 0.00 | 0.00 | 0.00 | ||||||||||
| Total Adjustments to reconcile Net Income to Net Cash provided by operations: | $9,431.88 | $12,180.95 | -$73,275.35 | -$12,060.25 | $2,178.12 | -$31,916.30 | $138,504.09 | $31,081.17 | -$130,277.23 | -$25,030.94 | -$134,702.42 | $84,178.61 | -$129,707.67 |
| Net cash provided by operating activities | -$36,531.33 | $1,565.08 | -$45,385.06 | -$16,532.16 | $15,757.20 | -$21,566.13 | $89,438.98 | -$32,015.46 | -$115,824.43 | -$72,013.71 | -$52,179.86 | -$12,396.88 | -$297,683.76 |
| FINANCING ACTIVITIES | |||||||||||||
| Notes Payable:CHICAGO ERF | 50,000.00 | -46.93 | -52.46 | -48.34 | -52.44 | -51.07 | -3,892.42 | 45,856.34 | |||||
| Notes Payable:SBA EIDL | 149,900.00 | 149,900.00 | |||||||||||
| Notes Payable:SBA PPP | 93,547.00 | 93,547.00 | |||||||||||
| Opening Balance Equity | 26.90 | 26.90 | |||||||||||
| Owner's Equity | -1,000.00 | -1,000.00 | |||||||||||
| Net cash provided by financing activities | $26.90 | $0.00 | $149,900.00 | $0.00 | $0.00 | $49,000.00 | -$46.93 | -$52.46 | $93,498.66 | -$52.44 | -$51.07 | -$3,892.42 | $288,330.24 |
| Net cash increase for period | -$36,504.43 | $1,565.08 | $104,514.94 | -$16,532.16 | $15,757.20 | $27,433.87 | $89,392.05 | -$32,067.92 | -$22,325.77 | -$72,066.15 | -$52,230.93 | -$16,289.30 | -$9,353.52 |
| FORECAST | |||||||||||||
| Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Total | |
| OPERATING ACTIVITIES | |||||||||||||
| Net Income | |||||||||||||
| Adjustments to reconcile Net Income to Net Cash provided by operations: | |||||||||||||
| Accounts Receivable (A/R) | |||||||||||||
| Inventory Asset | |||||||||||||
| Accounts Payable (A/P) | |||||||||||||
| Chase Credit Cards:Chase Ink (9835) | |||||||||||||
| Chase Credit Cards:SWA VISA (4463) | |||||||||||||
| Chase Credit Cards:United Credit Card (7341) | |||||||||||||
| CitiBusiness / AAdvantage Platinum (1195) | |||||||||||||
| Divvy CC | |||||||||||||
| Direct Deposit Payable | |||||||||||||
| Payroll Liabilities:CO Income Tax | |||||||||||||
| Payroll Liabilities:CO Local Tax | |||||||||||||
| Payroll Liabilities:CO Unemployment Tax | |||||||||||||
| Payroll Liabilities:CT Income Tax | |||||||||||||
| Payroll Liabilities:CT Paid Family and Medical Leave | |||||||||||||
| Payroll Liabilities:CT Unemployment Tax | |||||||||||||
| Payroll Liabilities:Federal Taxes (941/944) | |||||||||||||
| Payroll Liabilities:Federal Unemployment (940) | |||||||||||||
| Payroll Liabilities:IL Income Tax | |||||||||||||
| Payroll Liabilities:IL Unemployment Tax | |||||||||||||
| Payroll Liabilities:MA Income Tax | |||||||||||||
| Payroll Liabilities:MA Paid Family and Medical Leave | |||||||||||||
| Payroll Liabilities:MA Unemployment Tax | |||||||||||||
| Payroll Liabilities:MD Income Tax | |||||||||||||
| Payroll Liabilities:MD Unemployment Tax | |||||||||||||
| Payroll Liabilities:NY MCTMT Employer Tax | |||||||||||||
| Payroll Liabilities:NYS Employment Taxes | |||||||||||||
| Payroll Liabilities:NYS Income Tax | |||||||||||||
| Payroll Liabilities:SMPLIRA | |||||||||||||
| Payroll Liabilities:TX Unemployment Tax | |||||||||||||
| Total Adjustments to reconcile Net Income to Net Cash provided by operations: | |||||||||||||
| Net cash provided by operating activities | |||||||||||||
| FINANCING ACTIVITIES | |||||||||||||
| Notes Payable:CHICAGO ERF | |||||||||||||
| Notes Payable:SBA EIDL | |||||||||||||
| Notes Payable:SBA PPP | |||||||||||||
| Opening Balance Equity | |||||||||||||
| Owner's Equity | |||||||||||||
| Net cash provided by financing activities | |||||||||||||
| Net cash increase for period |
FTE
| Assist Projections | Fringe Benefits/Mo. - Employee | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Staffing and Consulting Details | Education | $ 100.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Fitness or Diet | $ 100.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Clear Membership | $ 50.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| est. rate incr. | Phone Allowance | $ 100.00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Salaries & Wages Total | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Department | Type | Name | Start Date | Base Salary | Est Commissions (Driven by commission tab) | Bonus | Total Comp | Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Total | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Staffing | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Admin | A Employee | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Executive | E Employee | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sales | S Employee | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| - 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 | - 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 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Employee Position | Headcount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Admin | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Executive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sales | 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 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total FTEs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||