Model - Financial

profileBatman007
Innovare-SocialInnovationPartners_StatementofCashFlows1.xlsx

Statement of Cash Flows

Innovare - Social Innovation Partners
Statement of Cash Flows
July 2020 - June 2021
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
Saturday, Jul 17, 2021 02:19:00 PM GMT-7