Please help with why not balancing:
Income Statement 2021 JUN JAN FEB MAR APR MAY JUL AUG SEP OCT NOV DEC Revenue Subscription Software Reven Refunds Discounts Net Revenue $37,600 -$1,880 -$3,008 $32,712 $50,760 -$2,538 -$4,061 $44,161 $68,526 -$3,426 -$5,482 $59,618 $92,510 -$4,626 -$7,401 $80,484 $124,889 -$6,244 -$9,991 $108,653 $168,600 -$8,430 -$13,488 $146,682 $227,610 -$11,380 -$18,209 $198,020 $307,273 -$15,364 -$24,582 $267,327 $414,818 -$20,741 -$33,185 $360,892 $560,005 -$28,000 -$44,800 $487,204 $756,007 -$37,800 -$60,481 $657,726 $1,020,609 -$51,030 -$81,649 $887,930 Cost of Goods Sold Merchant Services Hosting Total COGS $981 $2,000 $2,981 $1,325 $2,000 $3,325 $ $1,789 $2.000 $3,789 $2,415 $2,000 $4,415 $3,260 $2,000 $5,260 $4,400 $2,000 $6,400 $5,941 $2,000 $7,941 $8,020 $2,000 $10,020 $10,827 $2,000 $12,827 $14,616 $2,000 $16,616 $19,732 $2,000 $21,732 $ $26,638 $2,000 $28,638 Gross Margin GM% $29,731 90.89% $40,836 92.47% $55,829 93.65% $76,069 94.52% $103,394 95.16% $140,281 95.64% $190,080 95.99% $257,308 96.2596 $348,065 96.45 $470,588 96.59% $635,994 96.70% $859,292 96.7796 $8,333 $6,666 Operating Expenses CEO Salary coo Salary Developer Salary Jr Developer Salary Sales Associate Salary Assistant Salary ASSISL Rent Dues & Subscriptions Professional Fees Pole Utilities Misc. Depreciation Total OPEX 88 8 8 $5,000 $2,000 $4,000 $500 $1,000 $2,000 $29,499 $8,333 $6,666 0 0 0 0 $5,000 $2,000 $4,000 $500 $1,000 $2,000 $29,499 $8,333 $6,666 $5,000 $0 $0 $0 $5,000 $2,000 $4,000 $500 $1,000 $3,000 $35,499 $8,333 $6,666 $5,000 $0 $0 $0 $5,000 $2,000 $4,000 $500 $1,000 $3,000 $35,499 $8,333 $6,666 $5,000 $0 $0 $0 $5,000 $2,000 $4,000 $500 $1,000 $5,500 $ $37,999 $8,333 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 24,00 $4,000 $500 $1,000 $7,500 $46,665 $8,335 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 $4,000 $500 $1,000 $7,500 $46,665 $8,333 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 $4,000 $500 $1,000 $7,500 $46,665 $8,333 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 $4,000 $500 $1,000 $7,500 $46,665 $8,333 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 $4,000 $500 $1,000 $7,500 $46,665 $8,333 $6,666 $5,000 $3,333 $3,333 $2,500 $5,000 $2,000 $4,000 $500 $1,000 $8,500 $50,165 $8,333 $6,666 $5,000 $3,333 $3,333 $2,500 $5,000 $2,000 $4,000 $500 $1,000 $8,500 $50,165 Operating Income $231 $11,337 $20,330 $40,570 $65,394 $93,616 $143,414 $210,642 $301,400 $423,923 $585,829 $809,126 Interest 333.33 328.600894 324.23 319.63 315 310.35 305.66 300.94 296.18 291.4 286.58 281.73 NI Before Taxes -$102 $11,008 $20,006 $40,250 $65,079 $93,306 $143,109 $210,341 $301,104 $423,631 $585,542 $808,845 Taxes -$21.42 $2,311.77 $4,201.16 $8,452.57 $13,666.63 $19,594.17 $30,052.83 $44,171.67 $63,231.78 $88,962.58 $122,963.81 $169,857.38 Net Income NI % -$81 -0.25% $8,697 19.69% $15,804 26.51% $31,798 39.51% $51,413 47.32% $73,711 50.25% $113,056 57.09% $166,170 62.16% $ 237,872 65.91% $334,669 68.69% $462,578 70.33% $638,987 71.96% EBITDA $2,231 $13,337 $23,330 $43,570 $70,894 $101,116 $150,914 $218,142 $308,900 $431,423 $594,329 $817,626 Capex & Depreciation Useful Life (Years) 2021 JUN JAN FEB MAR APR MAY JUL AUG SEP OCT NOV DEC 8 $0 SO Capex Equipment Computers Total Capex 3 $0 $6,000 $6,000 So $0 $0 $0 $3,000 $3,000 SO $O SO $20,000 $0 $20,000 $o $6,000 $6,000 SO SO $0 so $0 $o $0 $0 SO SO SO $0 $3,000 $3,000 $0 SO Depreciation Equipment Computers Total D&A $0 $2,000 $2,000 $0 $2,000 $2,000 $0 $3,000 $3,000 $0 $3,000 $3,000 $2,500 $3,000 $5,500 $2,500 $5,000 $7,500 $2,500 $5,000 $7,500 $2,500 $5,000 $7,500 $2,500 $5,000 $7,500 $2,500 $5,000 $7,500 $2,500 $6,000 $8,500 $2,500 $6,000 $8,500 Balance Sheet Jan 1, Year 0 2021 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Assets Cash AR Total Current Assets $44,634 $55,464 $71,684 $107,279 $145,507 $222,734 $346,253 $524,165 $775,509 $1,125,987 $1,605,530 $2,160,861 $1,636 $2,208 $2,981 $4,024 $5,433 $7,334 $9,901 $13,366 $18,045 $24,360 $32,886 $44,396 $46,269 $57,672 $74,665 $111,304 $150,940 $230,068 $356,154 $537,531 $793,554 $1,150,347 $1,638,416 $2,205,258 Fixed Assets Accumulated Depreciation Net Fixed Assets $6,000 -2000 $4,000 $0 -2000 -$2,000 $3,000 -3000 $0 $0 $20,000 -3000 -5500 -$3,000 $14,500 $6,000 - 7500 -$1,500 $0 -7500 -$7,500 $0 -7500 -$7,500 $0 -7500 -$7,500 $0 -7500 -$7,500 $3,000 -8500 -$5,500 $0 -8500 -$8,500 Total Assets $50,269 $55,672 $74,665 $108,304 $165,440 $228,568 $348,654 $530,031 $786,054 $1,142,847 $1,632,916 $2,196,758 Liabilities Accounts Payable Deferred Revenue Total Current Assets $1,962.72 $2,649.67 $3,577.06 $4,829.03 $6,519.19 $8,800.90 $11,881.22 $16,039.64 $21,653.52 $29,232.25 $39,463.54 $53,275.78 $981.36 $1,324.84 $1,788.53 $2,414.51 $3,259.59 $4,400.45 $5,940.61 $8,019.82 $10,826.76 $14,616.13 $19,731.77 $26,637.89 $2,944 $3,975 $5,366 $7,244 $9,779 $13,201 $17,822 $24,059 $32,480 $43,848 $59,195 $79,914 Long Term Debt $49,320 $48,634 $47,945 $47,251 $46,552 $45,848 $45,140 $44,427 $43,710 $42,987 $42,260 $41,528 Total Liabilities $52,264 $52,609 $53,310 $54,494 $56,331 $59,050 $62,962 $68,487 $76,190 $86,836 $101,455 $121,442 Equity Common Stock Retained Earnings Total Shareholders Equity -$81 -$81 $8,616 $24,420 $56,218 $107,631 $181,342 $294,398 $460,568 $698,440 $1,033,108 $1,495,687 $2,134,674 $8,616 $24,420 $56,218 $107,631 $181,342 $294,398 $460,568 $698,440 $1,033,108 $1,495,687 $2,134,674 Liabilities & Shareholders Equity $52,183 $61,225 $77,731 $110,712 $163,961 $240,392 $357,360 $529,055 $774,630 $1,119,944 $1,597,142 $2,256,115 Balance Check -$1,914 -$5,553 -$3,066 -$2,409 $1,478 -$11,824 -$8,706 $977 $11,424 $22,903 $35,774 -$59,358 Cash Flow Statement Jan 1, Year o 2021 JUN JAN FEB MAR APR MAY JUL AUG SEP OCT NOV DEC Net Income $81 $8,697 $15,804 $31,798 $51,413 $73,711 $113,056 $166,170 $237,872 $334,669 $462,578 $638,987 Operating Activities Depreciation Change in AR Change in AP Change in Deferred Rev Operating CF $2,000 $1,636 $687 $343 $1,314 $2,000 $572 $927 $3,000 $3,000 $773 -$1,043 $1,252 $1,690 $626 $19,910 $36,290 $5,500 -$1,408 $2,282 $1,141 $58,927 $7,500 $7,500 $7,500 $7,500 $7,500 $8,500 $8,500 $1,901 -$2,567 -$3,465 -$4,678 $6,316 -$8,526 $11,510 $3,080 $4,158 $5,614 $7,579 $10,231 $13,812 $53,276 $1,540 $2,079 $2,807 $3,789 $5,116 $6,906 $26,638 $83,930 $124,227 $178,625 $252,062 $351,200 $483,270 $556,063 $464 $845 $11,515 Investing Activities Capex 6000 0 3000 0 20000 6000 0 0 0 0 3000 0 Free Cash Flow -$4,686 $11,515 $16,910 $36,290 $38,927 $77,930 $124,227 $178,625 $252,062 $351,200 $480,270 $556,063 -698.81 -712.88 Financing Activities Debt Repayment Net Borrowings NCF from Financing -680.49 50000 49319.51 -685.02 0 -685.02 -689.59 0 -689.59 -694.19 0 -694.19 0 -698.81 -703.47 0 -703.47 -708.16 0 -708.16 0 -712.88 -717.64 0 -717.64 -722.42 0 -722.42 -727.24 0 -727.24 -732.09 0 -732.09 Net Cash Flow $44,634 $10,830 $16,220 $35,595 $38,228 $77,227 $123,518 $177,912 $251,344 $350,478 $479,543 $555,331 Income Statement 2021 JUN JAN FEB MAR APR MAY JUL AUG SEP OCT NOV DEC Revenue Subscription Software Reven Refunds Discounts Net Revenue $37,600 -$1,880 -$3,008 $32,712 $50,760 -$2,538 -$4,061 $44,161 $68,526 -$3,426 -$5,482 $59,618 $92,510 -$4,626 -$7,401 $80,484 $124,889 -$6,244 -$9,991 $108,653 $168,600 -$8,430 -$13,488 $146,682 $227,610 -$11,380 -$18,209 $198,020 $307,273 -$15,364 -$24,582 $267,327 $414,818 -$20,741 -$33,185 $360,892 $560,005 -$28,000 -$44,800 $487,204 $756,007 -$37,800 -$60,481 $657,726 $1,020,609 -$51,030 -$81,649 $887,930 Cost of Goods Sold Merchant Services Hosting Total COGS $981 $2,000 $2,981 $1,325 $2,000 $3,325 $ $1,789 $2.000 $3,789 $2,415 $2,000 $4,415 $3,260 $2,000 $5,260 $4,400 $2,000 $6,400 $5,941 $2,000 $7,941 $8,020 $2,000 $10,020 $10,827 $2,000 $12,827 $14,616 $2,000 $16,616 $19,732 $2,000 $21,732 $ $26,638 $2,000 $28,638 Gross Margin GM% $29,731 90.89% $40,836 92.47% $55,829 93.65% $76,069 94.52% $103,394 95.16% $140,281 95.64% $190,080 95.99% $257,308 96.2596 $348,065 96.45 $470,588 96.59% $635,994 96.70% $859,292 96.7796 $8,333 $6,666 Operating Expenses CEO Salary coo Salary Developer Salary Jr Developer Salary Sales Associate Salary Assistant Salary ASSISL Rent Dues & Subscriptions Professional Fees Pole Utilities Misc. Depreciation Total OPEX 88 8 8 $5,000 $2,000 $4,000 $500 $1,000 $2,000 $29,499 $8,333 $6,666 0 0 0 0 $5,000 $2,000 $4,000 $500 $1,000 $2,000 $29,499 $8,333 $6,666 $5,000 $0 $0 $0 $5,000 $2,000 $4,000 $500 $1,000 $3,000 $35,499 $8,333 $6,666 $5,000 $0 $0 $0 $5,000 $2,000 $4,000 $500 $1,000 $3,000 $35,499 $8,333 $6,666 $5,000 $0 $0 $0 $5,000 $2,000 $4,000 $500 $1,000 $5,500 $ $37,999 $8,333 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 24,00 $4,000 $500 $1,000 $7,500 $46,665 $8,335 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 $4,000 $500 $1,000 $7,500 $46,665 $8,333 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 $4,000 $500 $1,000 $7,500 $46,665 $8,333 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 $4,000 $500 $1,000 $7,500 $46,665 $8,333 $6,666 $5,000 $3,333 $3,333 $0 $5,000 $2,000 $4,000 $500 $1,000 $7,500 $46,665 $8,333 $6,666 $5,000 $3,333 $3,333 $2,500 $5,000 $2,000 $4,000 $500 $1,000 $8,500 $50,165 $8,333 $6,666 $5,000 $3,333 $3,333 $2,500 $5,000 $2,000 $4,000 $500 $1,000 $8,500 $50,165 Operating Income $231 $11,337 $20,330 $40,570 $65,394 $93,616 $143,414 $210,642 $301,400 $423,923 $585,829 $809,126 Interest 333.33 328.600894 324.23 319.63 315 310.35 305.66 300.94 296.18 291.4 286.58 281.73 NI Before Taxes -$102 $11,008 $20,006 $40,250 $65,079 $93,306 $143,109 $210,341 $301,104 $423,631 $585,542 $808,845 Taxes -$21.42 $2,311.77 $4,201.16 $8,452.57 $13,666.63 $19,594.17 $30,052.83 $44,171.67 $63,231.78 $88,962.58 $122,963.81 $169,857.38 Net Income NI % -$81 -0.25% $8,697 19.69% $15,804 26.51% $31,798 39.51% $51,413 47.32% $73,711 50.25% $113,056 57.09% $166,170 62.16% $ 237,872 65.91% $334,669 68.69% $462,578 70.33% $638,987 71.96% EBITDA $2,231 $13,337 $23,330 $43,570 $70,894 $101,116 $150,914 $218,142 $308,900 $431,423 $594,329 $817,626 Capex & Depreciation Useful Life (Years) 2021 JUN JAN FEB MAR APR MAY JUL AUG SEP OCT NOV DEC 8 $0 SO Capex Equipment Computers Total Capex 3 $0 $6,000 $6,000 So $0 $0 $0 $3,000 $3,000 SO $O SO $20,000 $0 $20,000 $o $6,000 $6,000 SO SO $0 so $0 $o $0 $0 SO SO SO $0 $3,000 $3,000 $0 SO Depreciation Equipment Computers Total D&A $0 $2,000 $2,000 $0 $2,000 $2,000 $0 $3,000 $3,000 $0 $3,000 $3,000 $2,500 $3,000 $5,500 $2,500 $5,000 $7,500 $2,500 $5,000 $7,500 $2,500 $5,000 $7,500 $2,500 $5,000 $7,500 $2,500 $5,000 $7,500 $2,500 $6,000 $8,500 $2,500 $6,000 $8,500 Balance Sheet Jan 1, Year 0 2021 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Assets Cash AR Total Current Assets $44,634 $55,464 $71,684 $107,279 $145,507 $222,734 $346,253 $524,165 $775,509 $1,125,987 $1,605,530 $2,160,861 $1,636 $2,208 $2,981 $4,024 $5,433 $7,334 $9,901 $13,366 $18,045 $24,360 $32,886 $44,396 $46,269 $57,672 $74,665 $111,304 $150,940 $230,068 $356,154 $537,531 $793,554 $1,150,347 $1,638,416 $2,205,258 Fixed Assets Accumulated Depreciation Net Fixed Assets $6,000 -2000 $4,000 $0 -2000 -$2,000 $3,000 -3000 $0 $0 $20,000 -3000 -5500 -$3,000 $14,500 $6,000 - 7500 -$1,500 $0 -7500 -$7,500 $0 -7500 -$7,500 $0 -7500 -$7,500 $0 -7500 -$7,500 $3,000 -8500 -$5,500 $0 -8500 -$8,500 Total Assets $50,269 $55,672 $74,665 $108,304 $165,440 $228,568 $348,654 $530,031 $786,054 $1,142,847 $1,632,916 $2,196,758 Liabilities Accounts Payable Deferred Revenue Total Current Assets $1,962.72 $2,649.67 $3,577.06 $4,829.03 $6,519.19 $8,800.90 $11,881.22 $16,039.64 $21,653.52 $29,232.25 $39,463.54 $53,275.78 $981.36 $1,324.84 $1,788.53 $2,414.51 $3,259.59 $4,400.45 $5,940.61 $8,019.82 $10,826.76 $14,616.13 $19,731.77 $26,637.89 $2,944 $3,975 $5,366 $7,244 $9,779 $13,201 $17,822 $24,059 $32,480 $43,848 $59,195 $79,914 Long Term Debt $49,320 $48,634 $47,945 $47,251 $46,552 $45,848 $45,140 $44,427 $43,710 $42,987 $42,260 $41,528 Total Liabilities $52,264 $52,609 $53,310 $54,494 $56,331 $59,050 $62,962 $68,487 $76,190 $86,836 $101,455 $121,442 Equity Common Stock Retained Earnings Total Shareholders Equity -$81 -$81 $8,616 $24,420 $56,218 $107,631 $181,342 $294,398 $460,568 $698,440 $1,033,108 $1,495,687 $2,134,674 $8,616 $24,420 $56,218 $107,631 $181,342 $294,398 $460,568 $698,440 $1,033,108 $1,495,687 $2,134,674 Liabilities & Shareholders Equity $52,183 $61,225 $77,731 $110,712 $163,961 $240,392 $357,360 $529,055 $774,630 $1,119,944 $1,597,142 $2,256,115 Balance Check -$1,914 -$5,553 -$3,066 -$2,409 $1,478 -$11,824 -$8,706 $977 $11,424 $22,903 $35,774 -$59,358 Cash Flow Statement Jan 1, Year o 2021 JUN JAN FEB MAR APR MAY JUL AUG SEP OCT NOV DEC Net Income $81 $8,697 $15,804 $31,798 $51,413 $73,711 $113,056 $166,170 $237,872 $334,669 $462,578 $638,987 Operating Activities Depreciation Change in AR Change in AP Change in Deferred Rev Operating CF $2,000 $1,636 $687 $343 $1,314 $2,000 $572 $927 $3,000 $3,000 $773 -$1,043 $1,252 $1,690 $626 $19,910 $36,290 $5,500 -$1,408 $2,282 $1,141 $58,927 $7,500 $7,500 $7,500 $7,500 $7,500 $8,500 $8,500 $1,901 -$2,567 -$3,465 -$4,678 $6,316 -$8,526 $11,510 $3,080 $4,158 $5,614 $7,579 $10,231 $13,812 $53,276 $1,540 $2,079 $2,807 $3,789 $5,116 $6,906 $26,638 $83,930 $124,227 $178,625 $252,062 $351,200 $483,270 $556,063 $464 $845 $11,515 Investing Activities Capex 6000 0 3000 0 20000 6000 0 0 0 0 3000 0 Free Cash Flow -$4,686 $11,515 $16,910 $36,290 $38,927 $77,930 $124,227 $178,625 $252,062 $351,200 $480,270 $556,063 -698.81 -712.88 Financing Activities Debt Repayment Net Borrowings NCF from Financing -680.49 50000 49319.51 -685.02 0 -685.02 -689.59 0 -689.59 -694.19 0 -694.19 0 -698.81 -703.47 0 -703.47 -708.16 0 -708.16 0 -712.88 -717.64 0 -717.64 -722.42 0 -722.42 -727.24 0 -727.24 -732.09 0 -732.09 Net Cash Flow $44,634 $10,830 $16,220 $35,595 $38,228 $77,227 $123,518 $177,912 $251,344 $350,478 $479,543 $555,331
