Model - Financial

profileBatman007
Innovare-SocialInnovationPartners_BalanceSheet1.xlsx

Balance Sheet

Innovare - Social Innovation Partners
Balance Sheet
As of June 30, 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
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
Saturday, Jul 17, 2021 02:17:11 PM GMT-7 - Accrual Basis