cashflow template
DESCRIPTION
A basic template for cashflow. *ignore the contents*TRANSCRIPT
Projected Income Statement for Ethno Sound Records (2015)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC TOTAL
SALES 20,000 24,500 21,000 75,080 58,500 32,110 20,000 65,000 316,190
C.O.G.S. 10,000 12,250 10,500 37,540 29,250 16,055 10,000 32,500 158,095
GROSS PROFIT 0 0 0 0 10,000 12,250 10,500 37,540 29,250 16,055 10,000 32,500 158,095
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 250 250 5,500
Internet 150 150 150 150 150 150 150 150 150 150 99 99 1,698
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 18,000
Accountant/Bookeeper 300 300 300 300 300 300 300 300 300 300 3,000
Street Team 750 750 750 750 750 750 750 750 750 750 7,500
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 20,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 42,500
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 42,000
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 12,750
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 2,200
Auto Insurance 640 640 640 640 640 640 640 640 640 640 6,400
INTEREST 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
RENT
Studio 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 3,050 34,950
Home Office 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,750 6,000 66,750
TOTAL OP. EXPENSE 10,050 10,050 24,210 24,210 24,210 24,210 26,335 26,335 26,335 26,335 26,284 26,684 275,248
NET PROFIT -10,050 -10,050 -24,210 -24,210 -14,210 -11,960 -15,835 11,205 2,915 -10,280 -16,284 5,816 -117,153
Projected Income Statement for Ethno Sound Records (2016)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC TOTAL
SALES 65,000 34,200 25,350 10,042 32,000 10,450 23,000 64,000 54,600 20,000 24,000 25,100 387,742
C.O.G.S. 32,500 17,100 12,675 5,021 16,000 5,225 11,500 32,000 27,300 10,000 12,000 12,550 193,871
GROSS PROFIT 32,500 17,100 12,675 5,021 16,000 5,225 11,500 32,000 27,300 10,000 12,000 12,550 193,871
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 250 250 5,500
Internet 150 150 150 150 150 150 150 150 150 150 99 99 1,698
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 26,985 26,985 26,985 26,985 26,985 26,985 26,985 26,985 26,985 26,985 26,684 26,684 323,218
NET PROFIT 5,515 -9,885 -14,310 -21,964 -10,985 -21,760 -15,485 5,015 315 -16,985 -14,684 -14,134 -129,347
Projected Income Statement for Ethno Sound Records (2017)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC TOTAL
SALES 25,100 20,050 45,000 50,500 75,500 45,000 43,600 83,000 45,000 42,500 44,500 48,500 568,250
C.O.G.S. 12,550 1,155 1,450 25,250 37,750 22,500 21,800 41,500 22,500 21,250 22,250 24,250 254,205
GROSS PROFIT 12,550 18,895 43,550 25,250 37,750 22,500 21,800 41,500 22,500 21,250 22,250 24,250 314,045
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 250 250 5,500
Internet 150 150 150 150 150 150 150 150 150 150 99 99 1,698
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Virtual Assistant #2 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,484 28,484 344,818
NET PROFIT -16,235 -9,890 14,765 -3,535 8,965 -6,285 -6,985 12,715 -6,285 -7,535 -6,234 -4,234 -30,773
Projected Income Statement for Ethno Sound Records (2018)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC TOTAL
SALES 48,500 43,600 65,000 75,000 54,000 78,000 85,000 50,700 75,000 54,000 86,400 60,050 775,250
C.O.G.S. 24,250 1,155 1,450 37,500 27,000 39,000 42,500 25,350 37,500 27,000 43,200 30,025 335,930
GROSS PROFIT 24,250 42,445 63,550 37,500 27,000 39,000 42,500 25,350 37,500 27,000 43,200 30,025 439,320
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 250 250 5,500
Internet 150 150 150 150 150 150 150 150 150 150 99 99 1,698
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Virtual Assistant #2 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,484 28,484 344,818
NET PROFIT -4,535 13,660 34,765 8,715 -1,785 10,215 13,715 -3,435 8,715 -1,785 14,716 1,541 94,502
Projected Income Statement for Ethno Sound Records (2019)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC TOTAL
SALES 60,050 56,500 67,000 82,500 94,000 91,000 100,500 60,300 50,070 87,050 100,200 98,500 947,670
C.O.G.S. 30,025 1,155 1,450 41,250 47,000 45,500 50,250 30,150 25,035 43,525 50,100 49,250 414,690
GROSS PROFIT 30,025 55,345 65,550 41,250 47,000 45,500 50,250 30,150 25,035 43,525 50,100 49,250 532,980
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 250 250 5,500
Internet 150 150 150 150 150 150 150 150 150 150 99 99 1,698
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Virtual Assistant #2 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,484 28,484 344,818
NET PROFIT 1,240 26,560 36,765 12,465 18,215 16,715 21,465 1,365 -3,750 14,740 21,616 20,766 188,162
Projected Income Statement for Ethno Sound Records (2020)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC TOTAL
SALES 98,500 75,000 65,700 42,500 70,500 78,050 98,500 67,000 10,140 56,700 70,400 90,400 823,390
C.O.G.S. 49,250 1,155 1,450 21,250 35,250 39,025 49,250 33,500 5,070 28,350 35,200 45,200 343,950
GROSS PROFIT 49,250 73,845 64,250 21,250 35,250 39,025 49,250 33,500 5,070 28,350 35,200 45,200 479,440
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 250 250 5,500
Internet 150 150 150 150 150 150 150 150 150 150 99 99 1,698
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Virtual Assistant #2 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,785 28,484 28,484 344,818
NET PROFIT 20,465 45,060 35,465 -7,535 6,465 10,240 20,465 4,715 -23,715 -435 6,716 16,716 134,622
Projected Cash Flow Statement for Ethno Sound Records (2015)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC Totals
OPENING BALANCE 400,000 390,600 381,200 356,990 332,780 318,570 306,610 290,775 301,980 304,895 294,615 278,030 3,957,045
SALES 20,000 24,500 21,000 75,080 58,500 32,110 20,000 65,000 316,190
C.O.G.S. 10,000 12,250 10,500 37,540 29,250 16,055 10,000 32,500 158,095
GROSS PROFIT 10,000 12,250 10,500 37,540 29,250 16,055 10,000 32,500 158,095
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 5,000
Internet 150 150 150 150 150 150 150 150 150 150 1,500
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 18,000
Accountant/Bookkeeper 300 300 300 300 300 300 300 300 300 300 3,000
Street Team 750 750 750 750 750 750 750 750 750 750 7,500
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 20,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 42,500
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 42,000
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 12,750
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 2,200
Auto Insurance 640 640 640 640 640 640 640 640 640 640 6,400
INTEREST 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
RENT
Studio 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 2,900 3,050 34,950
Home Office 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,500 5,750 6,000 66,750
TOTAL OP. EXPENSE 9,400 9,400 24,210 24,210 24,210 24,210 26,335 26,335 26,335 26,335 26,585 26,985 274,550
NET PROFIT -9,400 -9,400 -24,210 -24,210 -14,210 -11,960 -15,835 11,205 2,915 -10,280 -16,585 5,515 -116,455
CLOSING BALANCE 390,600 381,200 356,990 332,780 318,570 306,610 290,775 301,980 304,895 294,615 278,030 283,545 3,840,590
Projected Cash Flow Statement for Ethno Sound Records (2016)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC Totals
OPENING BALANCE 278,030 282,865 272,300 257,310 234,666 223,001 200,561 184,396 188,731 188,366 170,701 155,036 2,635,963
SALES 65,000 34,200 25,350 10,042 32,000 10,450 23,000 64,000 54,600 20,000 24,000 25,100 387,742
C.O.G.S. 32,500 17,100 12,675 5,021 16,000 5,225 11,500 32,000 27,300 10,000 12,000 12,550 193,871
GROSS PROFIT 32,500 17,100 12,675 5,021 16,000 5,225 11,500 32,000 27,300 10,000 12,000 12,550 193,871
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Internet 150 150 150 150 150 150 150 150 150 150 150 150 1,800
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookkeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 20,160
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 27,665 27,665 27,665 27,665 27,665 27,665 27,665 27,665 27,665 27,665 27,665 27,665 331,980
NET PROFIT 4,835 -10,565 -14,990 -22,644 -11,665 -22,440 -16,165 4,335 -365 -17,665 -15,665 -15,115 -138,109
CLOSING BALANCE 282,865 272,300 257,310 234,666 223,001 200,561 184,396 188,731 188,366 170,701 155,036 139,921 2,497,854
Projected Cash Flow Statement for Ethno Sound Records (2017)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC Totals
OPENING BALANCE 155,036 138,121 127,551 141,636 137,421 145,706 138,741 131,076 143,111 136,146 127,931 120,716 1,643,192
SALES 25,100 20,050 45,000 50,500 75,500 45,000 43,600 83,000 45,000 42,500 44,500 48,500 568,250
C.O.G.S. 12,550 1,155 1,450 25,250 37,750 22,500 21,800 41,500 22,500 21,250 22,250 24,250 254,205
GROSS PROFIT 12,550 18,895 43,550 25,250 37,750 22,500 21,800 41,500 22,500 21,250 22,250 24,250 314,045
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Internet 150 150 150 150 150 150 150 150 150 150 150 150 1,800
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Virtual Assistant #2 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookkeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 20,160
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 353,580
NET PROFIT -16,915 -10,570 14,085 -4,215 8,285 -6,965 -7,665 12,035 -6,965 -8,215 -7,215 -5,215 -39,535
CLOSING BALANCE 138,121 127,551 141,636 137,421 145,706 138,741 131,076 143,111 136,146 127,931 120,716 115,501 1,603,657
Projected Cash Flow Statement for Ethno Sound Records (2018)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC Totals
OPENING BALANCE 120,716 115,501 128,481 162,566 170,601 168,136 177,671 190,706 186,591 194,626 192,161 205,896 2,013,652
SALES 48,500 43,600 65,000 75,000 54,000 78,000 85,000 50,700 75,000 54,000 86,400 60,050 775,250
C.O.G.S. 24,250 1,155 1,450 37,500 27,000 39,000 42,500 25,350 37,500 27,000 43,200 30,025 335,930
GROSS PROFIT 24,250 42,445 63,550 37,500 27,000 39,000 42,500 25,350 37,500 27,000 43,200 30,025 439,320
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Internet 150 150 150 150 150 150 150 150 150 150 150 150 1,800
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Virtual Assistant #2 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookkeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 20,160
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 353,580
NET PROFIT -5,215 12,980 34,085 8,035 -2,465 9,535 13,035 -4,115 8,035 -2,465 13,735 560 85,740
CLOSING BALANCE 115,501 128,481 162,566 170,601 168,136 177,671 190,706 186,591 194,626 192,161 205,896 206,456 2,099,392
Projected Cash Flow Statement for Ethno Sound Records (2019)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC Totals
OPENING BALANCE 205,896 206,456 232,336 268,421 280,206 297,741 313,776 334,561 335,246 330,816 344,876 365,511 3,515,842
SALES 60,050 56,500 67,000 82,500 94,000 91,000 100,500 60,300 50,070 87,050 100,200 98,500 947,670
C.O.G.S. 30,025 1,155 1,450 41,250 47,000 45,500 50,250 30,150 25,035 43,525 50,100 49,250 414,690
GROSS PROFIT 30,025 55,345 65,550 41,250 47,000 45,500 50,250 30,150 25,035 43,525 50,100 49,250 532,980
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Internet 150 150 150 150 150 150 150 150 150 150 150 150 1,800
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Virtual Assistant #2 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookkeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 20,160
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 353,580
NET PROFIT 560 25,880 36,085 11,785 17,535 16,035 20,785 685 -4,430 14,060 20,635 19,785 179,400
CLOSING BALANCE 206,456 232,336 268,421 280,206 297,741 313,776 334,561 335,246 330,816 344,876 365,511 385,296 3,695,242
Projected Cash Flow Statement for Ethno Sound Records (2020)
MONTH JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC Totals
OPENING BALANCE 365,511 385,296 429,676 464,461 456,246 462,031 471,591 491,376 495,411 471,016 469,901 475,636 5,438,152
SALES 98,500 75,000 65,700 42,500 70,500 78,050 98,500 67,000 10,140 56,700 70,400 90,400 823,390
C.O.G.S. 49,250 1,155 1,450 21,250 35,250 39,025 49,250 33,500 5,070 28,350 35,200 45,200 343,950
GROSS PROFIT 49,250 73,845 64,250 21,250 35,250 39,025 49,250 33,500 5,070 28,350 35,200 45,200 479,440
UTILITIES
Phone 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Internet 150 150 150 150 150 150 150 150 150 150 150 150 1,800
SALARY
Virtual Assistant #1 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Virtual Assistant #2 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 21,600
Accountant/Bookkeeper 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Street Team 750 750 750 750 750 750 750 750 750 750 750 750 9,000
Publicist 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Radio Promoter 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 4,250 51,000
ADVERTISING
Ad Buys 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400
Tour Support 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 2,125 25,500
INSURANCE
Business Insurance 220 220 220 220 220 220 220 220 220 220 220 220 2,640
Auto Insurance 640 640 640 640 640 640 640 640 640 640 640 640 7,680
INTEREST 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 1,680 20,160
RENT
Studio 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 3,050 36,600
Home Office 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
TOTAL OP. EXPENSE 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 29,465 353,580
NET PROFIT 19,785 44,380 34,785 -8,215 5,785 9,560 19,785 4,035 -24,395 -1,115 5,735 15,735 125,860
CLOSING BALANCE 385,296 429,676 464,461 456,246 462,031 471,591 491,376 495,411 471,016 469,901 475,636 491,371 5,564,012
Balance Sheet for Ethno Sound Records
Assets Liabilities and Owners' Equity
Cash 4,300 Liabilities
Accounts Receivable 2,150
Bank Loans/ Credit Card Payables 34,320
Total liabilities 34,320
Computers and studio/band equipment 51,500
Owners' equity
Capital Stock 0
Retained Earnings 23,630
Total owners' equity 23,630
Total 57,950 Total 57,950