business plan

profilealex009
ForReference-CraftBeerShopProjectionsYears1-3completed.xls
Home>Business & Finance homework help>Marketing homework help>business plan

Simple Calculations (Example)

THIS IS SIMPLY AN EXAMPLE OF THE TAX BACKET USED THAT SHOULD BE TAKEN INTO ACCOUNT FOR YOUR FINANCIAL PLAN (NUMBERS WILL OBVIOUSLY CHANGE FOR YOUR BUSINESS SINCE SALES, PURCHASES, COGS, ETC WILL NOT BE THE SAME FOR EVERY COMPANY)
THE RATES APPLY TO BELGIUM WHICH IS THE COUNTRY IN WHICH THE BUSINESS IS DEVELOPED
Simple Calculation
Example A
Sales 10000
Purchases (COGS) 2500
Gross Profit 7500
Gross Profit Margin (%) 75%
COGS Margin 25%
Profit Before Tax 500,000 1,000,000 1,500,000
Using Belgian Tax rates given:
0-25000 24.98% 6245 6245 6245
250001-90000 31.93% 20754.18 20754.18 20754.18
90001-322500 35.54% 82630.14 82630.14 82630.14
322501 and over 33.99% 60331.91 230281.91 400231.9101
Calculate Net Amount of tax to pay 169961.2 339911.2354 509861.2354
Calculate Earnings after tax 330,039 660,089 990,139
effective Tax Rate % 34% 34% 34%

Balance Sheet Year 1- 3

Balance Sheet
Sebastian's Craft Beer Shop sprl
as at end of December 2017, 2018 & 2019
2017 2018 2019
Assets
Current assets:
Cash 74,703 114,626 78,214
Inventories 20,000 30,000 50,000
Accounts Receivable 17,599
Total current assets 94,703 144,626 145,813
Fixed assets:
Property & Equip 19,000 19,000 19,000
Less Depreciation -3,800 -7,600 -11,400
Rental Guarantee 7,500 7,688 7,764
Net fixed assets 22,700 19,088 15,364
Intangible assets:
Start Up Costs 50,000 50,000 50,000
Less Amortisation -10,000 -20,000 -30,000
Total other assets 40,000 30,000 20,000
Total assets 157,403 193,714 181,177
Liabilities and owner's equity
Current liabilities:
Social Costs 4,620 9,500 11,550
Payroll Company 1,000 1,000 1,100
Utilities 1,029 1,833 2,200
Accounts Payable 14,615 32,555 31,973
Directors Salary 23,000 59,000 0
Income Tax 9,232
Total current liabilities 44,264 103,888 56,055
Long-term liabilities:
Investment Loan 100,000 100,000 100,000
Owners Loan 25,000 0 0
Total long-term liabilities 125,000 100,000 100,000
Owner's equity:
Retained Earnings -11,861 -10,174 25,123
Total owner's equity -11,861 -10,174 25,123
Total liabilities and owner's equity 157,403 193,714 181,177
Balanced Balanced Balanced
Difference: 0 0 0
&C&"Times New Roman,Regular"&12&A
&C&"Times New Roman,Regular"&12Page &P

Income Statement Year 1-2-3

Income Statement Sebastien Craft Beer Shop Sprl Year 1-3, 2016-2019
Year 1 Year 2 Year 3
Revenues
Sales 205,750 100.00% 313,152 101.01% 375,782 101.01%
Less Sales Returns 0 0.00% 3,132 1.01% 3,758 1.01%
Net Revenues 205,750 100.00% 310,020 100.00% 372,024 100.00%
Less COGS
Opening Stock 0 0.00% 0 0.00% 0 0.00%
Purchases 73,082 35.52% 110,108 35.52% 108,140 29.07%
Closing Stock 0 0.00% 0 0.00% 0 0.00%
COGS 73,075 35.52% 110,108 35.52% 108,140 29.07%
Gross Profit 132,675 64.48% 199,912 64.48% 263,884 70.93%
GPM 64.48% 0.00% 64.48% 0.00% 70.93% 0.00%
Less Operating Expenses
Rent 30,000 14.58% 30,750 9.92% 31,058 8.35%
Director's salary 23,000 11.18% 36,000 11.61% 36,000 9.68%
FT Salaries 18,480 8.98% 28,500 9.19% 42,000 11.29%
FT Social Costs 18,480 8.98% 28,500 9.19% 42,000 11.29%
Students Salaries 0 0.00% 7,600 2.45% 12,600 3.39%
Student Social Costs 0 0.00% 1,900 0.61% 3,150 0.85%
Utilities 5,144 2.50% 7,750 2.50% 9,301 2.50%
Payroll Company 4,000 1.94% 4,000 1.29% 4,400 1.18%
Telecoms 1,800 0.87% 2,070 0.67% 2,277 0.61%
Advertising 15,000 7.29% 19,500 6.29% 6,000 1.61%
Maintenance 6,000 2.92% 7,000 2.26% 7,000 1.88%
Credit Card Costs 2,332 1.13% 2,805 0.90% 3,270 0.88%
Cash Payment Expenses 0 0.00% 1,550 0.50% 0 0.00%
Depreciation 3,800 1.85% 3,800 1.23% 3,800 1.02%
Amorisation 10,000 4.86% 10,000 3.23% 10,000 2.69%
Total Operating Expenses 138,036 67.09% 191,726 61.84% 212,855 57.22%
Non Operating Expenses:
Interest 6,500 3.16% 6,500 2.10% 6,500 1.75%
Net Profit Before Tax -11,861 -5.76% 1,686 0.54% 44,529 11.97%
Loss carried over 0 0.00% -11,861 -3.83% -10,174 -2.73%
Taxable Profit 0 0.00% 0 0.00% 34,354 9.23%
1st bracket 24.98% (0-25000) 0 0.00% 0 0.00% 6,245 1.68%
2nd Bracket 31.93% (25001-90,000) 0 0.00% 0 0.00% 2,987 0.80%
3rd Bracket 35.54% (90001-322500) 0 0.00% 0 0.00% 0 0.00%
Net Income after Tax -11,861 -5.76% 1,686 0.54% 35,297 9.49%
Accumulated profits (losses) -11,861 -5.76% -10,174 -3.28% 25,123 6.75%

Year 1 Inc Stat & Cash Flow

Income Statement Sebastien Craft Beer Shop Sprl Year 1 2017
January February March April May June July August September October November December Totals %ages
Revenues
Sales 8,230 9,259 11,316 10,288 20,575 41,150 13,374 20,575 11,316 8,230 10,288 41,150 205,750
Less Sales Returns 0
Net Revenues 8,230 9,259 11,316 10,288 20,575 41,150 13,374 20,575 11,316 8,230 10,288 41,150 205,750 1
Less COGS
Opening Stock
Purchases 2,923 3,288 4,019 3,654 7,308 14,615 4,750 7,308 4,019 2,923 3,654 14,615 73,082 35.52%
Closing Stock
COGS 2,923 3,288 4,019 3,654 7,308 14,615 4,750 7,308 4,019 2,923 3,654 14,615 73,075 35.52%
Gross Profit 5,307 5,970 7,297 6,634 13,268 26,535 8,624 13,268 7,297 5,307 6,634 26,535 132,675 64.48%
GPM 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48%
Less Operating Expenses
Rent 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 30,000 14.58%
Director's salary 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 23,000 11.18%
FT Salaries 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 18,480 8.98%
FT Social Costs 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 18,480 8.98%
Utilities 206 231 283 257 514 1,029 334 514 283 206 257 1,029 5,144 2.50%
Payroll Company 333 333 333 333 333 333 333 333 333 333 333 333 4,000 1.94%
Telecoms 150 150 150 150 150 150 150 150 150 150 150 150 1,800 0.87%
Advertising 2,500 2,500 2,500 833 833 833 833 833 833 833 833 833 15,000 7.29%
Maintenance 500 500 500 500 500 500 500 500 500 500 500 500 6,000 2.92%
Credit Card Costs 114 123 142 133 225 410 160 225 142 114 133 410 2,332 1.13%
Depreciation 317 317 317 317 317 317 317 317 317 317 317 317 3,800 1.85%
Amorisation 833 833 833 833 833 833 833 833 833 833 833 833 10,000 4.86%
Total Operating Expenses 12,450 12,485 12,555 10,853 11,203 11,902 10,958 11,203 10,888 10,783 10,853 11,902 138,036 67.09%
Non Operating Expenses:
Interest 542 542 542 542 542 542 542 542 542 542 542 542 6,500 3.16%
Net Profit Before Tax -7,684 -7,056 -5,799 -4,761 1,523 14,091 -2,876 1,523 -4,133 -6,018 -4,761 14,091 -11,861 -5.76%
Loss carried over
Taxable Profit
1st bracket 24.98% (0-25000)
2nd Bracket 31.93% (25001-90,000)
3rd Bracket 35.54% (90001-322500)
Net Income after Tax -11,861 -6%
Accumulated profits (losses) -11,861
Cashflow statement Sebastians Craft Beer Shop Year 1, 2017 Net
January February March April May June July August September October November December
Earnings from Operations -7,684 -7,056 -5,799 -4,761 1,523 14,091 -2,876 1,523 -4,133 -6,018 -4,761 14,091 -11,861
Plus Depreciation 317 317 317 317 317 317 317 317 317 317 317 317 3,800 Take into consideration the effect of depreciation
Plus Amortization 833 833 833 833 833 833 833 833 833 833 833 833 10,000 Take into consideration the effect of amortisation.
-6,534 -5,906 -4,649 -3,611 2,673 15,241 -1,726 2,673 -2,983 -4,868 -3,611 15,241
Working Capital Changes:
(increase)/Decrease Accounts Receivable 0 20,000€ of opening stock to be maintained throughout the year
(increase)/Decrease Inventories -20,000 -20,000
(increase)/Decrease Other Current Assets 0
Rent prepaid 0 Rent paid every 6 months
Telecoms Prepaid -1,650 150 150 150 150 150 150 150 150 150 150 150 0 Telecoms pre-paid in January for year
Rent Prepaid -12,500 2,500 2,500 2,500 2,500 2,500 -12,500 2,500 2,500 2,500 2,500 2,500 0
Increase/(Decrease) Accounts Payable and Accrued Expenses
Suppliers debts increasing 7,308 14,615 4,750 7,308 4,019 2,923 3,654 14,615 14,615 From May onwards 1 month credit from suppliers
Suppliers debts decreasing -7,308 -14,615 -4,750 -7,308 -4,019 -2,923 -3,654
Unpaid Director's Wages 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 1,917 23,000 Directors/Owner is willing to not take salary for first year
Increase/(Decrease) Other Current Liabilities
Employee Social Costs 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 1,540 4,620 Employee Social Costs Paid month after trimester is over
Employee Social Costs -4,620 -4,620 -4,620
Payroll company debt increasing 333 333 333 333 333 333 333 333 333 333 333 333 1,000 Payroll company Paid month after trimester is over
Payroll company debt decreasing -1,000 -1,000 -1,000
Utilities debt increasing 206 231 283 257 514 1,029 334 514 283 206 257 1,029 1,029 Utilities Paid month afterwards
Utilities debt decreasing -206 -231 -283 -257 -514 -1,029 -334 -514 -283 -206 -257
Net Cash Provided/(Used) by Operating Activities -36,689 560 1,842 -2,817 16,678 29,503 -26,465 11,851 -62 -5,221 3,611 33,414
Investing Activities
Property & Equipment -19,000 -19,000 We know there was a purchase of assets 19000€
Rental Deposit -7,500 -7,500 To give the landlord a warranty there is 3 months rent deposit paid in January
Set Up Costs -50,000 -50,000 Set up costs 50k€
Net Cash Used in Investing Activities -76,500 0 0 0 0 0 0 0 0 0 0 0 -76,500
0
Financing Activities 0
Increase/(Decrease) Family Loan 25,000 25,000 Founder/Owner invests 25,000€
Increase/(Decrease) Current Portion Long-Term Debt 0
Increase/(Decrease) Long Term Debt 100,000 100,000 Business receives a loan of 100,000€, is capital repayment free for 5 years as based on positively exiting the business in 5 years
Increase/(Decrease) Common Stock 0
Increase/(Decrease) Preferred Stock 0
Dividends Declared 0
Net Cash Provided/(used) by Financing 125,000 0 0 0 0 0 0 0 0 0 0 0 -1,797
Increase/(Decrease) in Cash 11,811 560 1,842 -2,817 16,678 29,503 -26,465 11,851 -62 -5,221 3,611 33,414
Cash at Beginning of period 11,811 12,371 14,213 11,396 28,074 57,577 31,111 42,962 42,899 37,678 41,290
Cash at end of the period 11,811 12,371 14,213 11,396 28,074 57,577 31,111 42,962 42,899 37,678 41,290 74,703
Conchur123: changed to equation than figure

Year 2 Inc Stat & Cash Flow

Income Statement Sebastien Craft Beer Shop Sprl Year 2 2018
January February March April May June July August September October November December Totals %ages
Revenues
Sales 8,230 9,259 11,316 14,403 28,805 57,610 18,723 37,035 20,369 14,814 18,518 74,070 313,152
Less Sales Returns 82 93 113 144 288 576 187 370 204 148 185 741 3,132
Net Revenues 8,148 9,166 11,203 14,258 28,517 57,034 18,536 36,665 20,166 14,666 18,332 73,329 310,020 100.00%
Less COGS
Opening Stock
Purchases 2,894 3,255 3,979 5,064 10,128 20,256 6,583 13,022 7,162 5,209 6,511 26,044 110,108 35.52%
Closing Stock
COGS 2,894 3,255 3,979 5,064 10,128 20,256 6,583 13,022 7,162 5,209 6,511 26,044 110,108 35.52%
Gross Profit 5,254 5,911 7,224 9,194 18,389 36,778 11,953 23,643 13,003 9,457 11,821 47,285 199,912 64.48%
GPM 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48% 64.48%
Less Operating Expenses
Rent 2,563 2,563 2,563 2,563 2,563 2,563 2,563 2,563 2,563 2,563 2,563 2,563 30,750 9.92% 7687.5
Director's salary 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000 11.61%
FT Salaries 1,583 1,583 1,583 1,583 1,583 1,583 3,167 3,167 3,167 3,167 3,167 3,167 28,500 9.19%
FT Social Costs 1,583 1,583 1,583 1,583 1,583 1,583 3,167 3,167 3,167 3,167 3,167 3,167 28,500 9.19%
Students Salaries 2,533 2,533 2,533 7,600 2.45%
Student Social Costs 633 633 633 1,900 0.61%
Utilities 204 229 280 356 713 1,426 463 917 504 367 458 1,833 7,750 2.50%
Payroll Company 333 333 333 333 333 333 333 333 333 333 333 333 4,000 1.29%
Telecoms 173 173 173 173 173 173 173 173 173 173 173 173 2,070 0.67%
Advertising 1,000 1,000 1,000 1,500 1,500 1,500 2,000 2,000 2,000 2,000 2,000 2,000 19,500 6.29%
Maintenance 583 583 583 583 583 583 583 583 583 583 583 583 7,000 2.26%
Credit Card Costs 101 109 124 147 254 468 179 315 191 150 177 590 2,805 0.90%
Cash Payment Expenses 41 46 56 71 143 285 93 183 101 73 92 367 1,550 0.50%
Depreciation 317 317 317 317 317 317 317 317 317 317 317 317 3,800 1.23%
Amorisation 833 833 833 833 833 833 833 833 833 833 833 833 10,000 3.23%
Total Operating Expenses 12,314 12,352 12,428 13,043 16,744 17,814 20,037 17,550 16,931 16,725 16,862 18,925 191,726 61.84%
Non Operating Expenses:
Interest 542 542 542 542 542 542 542 542 542 542 542 542 6,500 2.10%
Net Profit Before Tax -7,602 -6,983 -5,746 -4,390 1,103 18,422 -8,626 5,551 -4,469 -7,810 -5,583 27,819 1,686 0.54%
Loss carried over -11,861
Taxable Profit 0
1st bracket 24.98% (0-25000)
2nd Bracket 31.93% (25001-90,000)
3rd Bracket 35.54% (90001-322500)
Net Income after Tax 1,686 1%
Accumulated profits (losses) -10,174
Cashflow statement Sebastians Craft Beer Shop Year 2, 2018 Net
January February March April May June July August September October November December
Earnings from Operations -7,602 -6,983 -5,746 -4,390 1,103 18,422 -8,626 5,551 -4,469 -7,810 -5,583 27,819 1,686 Take into consideration the effect of depreciation
Plus Depreciation 317 317 317 317 317 317 317 317 317 317 317 317 3,800 Take into consideration the effect of amortisation.
Plus Amortization 833 833 833 833 833 833 833 833 833 833 833 833 10,000
-6,452 -5,833 -4,596 -3,240 2,253 19,572 -7,476 6,701 -3,319 -6,660 -4,433 28,969
Working Capital Changes:
(increase)/Decrease Accounts Receivable 0
(increase)/Decrease Inventories -10,000 -10,000 10,000€ of extra stock in January and to be maintained throughout the year at new level.
(increase)/Decrease Other Current Assets 0 Rent paid every 6 months
Rent prepaid -12,813 2,563 2,563 2,563 2,563 2,563 -12,813 2,563 2,563 2,563 2,563 2,563 0
Telecoms Prepaid -345 173 173 -345 173 173 -345 173 173 -345 173 173 0 Telecoms paid in advance for three months
Increase/(Decrease) Accounts Payable and Accrued Expenses
Suppliers debts increasing 2,894 3,255 3,979 5,064 10,128 20,256 6,583 13,022 7,162 5,209 6,511 26,044 17,940 From Jan onwards 2 month’s credit from suppliers.
Suppliers debts decreasing -14,615 -2,894 -3,255 -3,979 -5,064 -10,128 -20,256 -6,583 -13,022 -7,162 -5,209
Unpaid Director's Wages 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000 Directors/Owner is willing to not take salary during 2nd year
Employee Social Costs Paid month after trimester is over
Increase/(Decrease) Other Current Liabilities
Employee Social Costs 1,583 1,583 1,583 1,583 2,217 2,217 3,800 3,167 3,167 3,167 3,167 3,167 4,880
Employee Social Costs -4,620 -4,750 -6,017 -10,133
Payroll company debt increasing 333 333 333 333 333 333 333 333 333 333 333 333 0 Payroll company Paid month after trimester is over
Payroll company debt decreasing -1,000 -1,000 -1,000 -1,000
Utilities debt increasing 204 229 280 356 713 1,426 463 917 504 367 458 1,833 804 Utilities Paid month afterwards
Utilities debt decreasing -1,029 -204 -229 -280 -356 -713 -1,426 -463 -917 -504 -367 -458
Net Cash Provided/(Used) by Operating Activities -42,859 5,100 4,192 29 17,043 43,762 -25,024 9,155 6,082 -17,026 4,243 60,414
Investing Activities
Property & Equipment 0 We know there was a purchase of assets 19,000€
Rental Deposit -188 -188 To give the landlord a warranty there is 3 months rent deposit paid in January would need updating due to increase of rent
Set Up Costs 0
Net Cash Used in Investing Activities -188 0 0 0 0 0 0 0 0 0 0 0 -188
0
Financing Activities 0
Increase/(Decrease) Family Loan -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -25,000 Founder/Owner initially invested 25,000€, is now paid back over 12 months
Increase/(Decrease) Current Portion Long-Term Debt 0
Increase/(Decrease) Long Term Debt 0 Business receives a loan is capital repayment free for 5 years as based on positively exiting the business in 5 years
Increase/(Decrease) Common Stock 0
Increase/(Decrease) Preferred Stock 0
Dividends Declared 0
Net Cash Provided/(used) by Financing -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 -2,083 39,736
Increase/(Decrease) in Cash -45,130 3,016 2,108 -2,054 14,960 41,679 -27,107 7,072 3,999 -19,109 2,159 58,331
Cash at Beginning of period 74,703 29,574 32,590 34,698 32,644 47,604 89,283 62,176 69,247 73,246 54,136 56,296
Cash at end of the period 29,574 32,590 34,698 32,644 47,604 89,283 62,176 69,247 73,246 54,136 56,296 114,626
Conchur123: changed to equation than figure

Year 3 Inc Stat & Cash Flow

Income Statement Sebastien Craft Beer Shop Sprl Year 3 2019
January February March April May June July August September October November December Totals %ages
Revenues
Sales 9,876 11,111 13,580 17,283 34,566 69,132 22,468 44,442 24,443 17,777 22,221 88,884 375,782
Less Sales Returns 99 111 136 173 346 691 225 444 244 178 222 889 3,758
Net Revenues 9,777 10,999 13,444 17,110 34,220 68,441 22,243 43,998 24,199 17,599 21,999 87,995 372,024 100.00%
Less COGS
Opening Stock
Purchases 2,842 3,197 3,908 4,974 9,947 19,894 6,466 12,789 7,034 5,116 6,395 25,578 108,140 29.07%
Closing Stock
COGS 2,842 3,197 3,908 4,974 9,947 19,894 6,466 12,789 7,034 5,116 6,395 25,578 108,140 29.07%
Gross Profit 6,935 7,802 9,536 12,137 24,273 48,546 15,778 31,208 17,165 12,483 15,604 62,417 263,884 70.93%
GPM 70.93% 70.93% 70.93% 70.93% 70.93% 70.93% 70.93% 70.93% 70.93% 70.93% 70.93% 70.93% 70.93%
Less Operating Expenses
Rent 2,588 2,588 2,588 2,588 2,588 2,588 2,588 2,588 2,588 2,588 2,588 2,588 31,058 8.35%
Director's salary 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000 9.68%
FT Salaries 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 42,000 11.29%
FT Social Costs 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 42,000 11.29%
Students Salaries 4,200 4,200 4,200 12,600 3.39%
Student Social Costs 1,050 1,050 1,050 3,150 0.85%
Utilities 244 275 336 428 856 1,711 556 1,100 605 440 550 2,200 9,301 2.50%
Payroll Company 367 367 367 367 367 367 367 367 367 367 367 367 4,400 1.18%
Telecoms 190 190 190 190 190 190 190 190 190 190 190 190 2,277 0.61%
Advertising 500 500 500 500 500 500 500 500 500 500 500 500 6,000 1.61%
Maintenance 583 583 583 583 583 583 583 583 583 583 583 583 7,000 1.88%
Credit Card Costs 113 122 141 168 297 553 207 370 221 172 205 700 3,270 0.88%
Depreciation 317 317 317 317 317 317 317 317 317 317 317 317 3,800 1.02%
Amorisation 833 833 833 833 833 833 833 833 833 833 833 833 10,000 2.69%
Total Operating Expenses 15,736 15,775 15,855 15,974 21,780 22,892 16,141 16,848 16,204 21,240 16,133 18,278 212,855 57.22%
Non Operating Expenses:
Interest 542 542 542 542 542 542 542 542 542 542 542 542 6,500 1.75%
Net Profit Before Tax -9,342 -8,515 -6,861 -4,379 1,951 25,112 -905 13,819 419 -9,298 -1,070 43,597 44,529 11.97%
Loss carried over -10,174
Taxable Profit 34,354
1st bracket 24.98% (0-25000) 6245
2nd Bracket 31.93% (25001-90,000) 2,987
3rd Bracket 35.54% (90001-322500)
Net Income after Tax 35,297 9%
Accumulated profits (losses) 25,123
Cashflow statement Sebastians Craft Beer Shop Year 3, 2019 Net
January February March April May June July August September October November December
Earnings from Operations -9,342 -8,515 -6,861 -4,379 1,951 25,112 -905 13,819 419 -9,298 -1,070 43,597 44,529 Cash-flow statement Info Year 3:
Plus Depreciation 317 317 317 317 317 317 317 317 317 317 317 317 3,800 Take into consideration the effect of depreciation
Plus Amortization 833 833 833 833 833 833 833 833 833 833 833 833 10,000 Take into consideration the effect of amortisation.
-8,192 -7,365 -5,711 -3,229 3,101 26,262 245 14,969 1,569 -8,148 80 44,747
Working Capital Changes:
(increase)/Decrease Accounts Receivable -1,955 -2,200 -2,689 -3,422 -6,844 -13,688 -4,449 -8,800 -4,840 -3,520 -4,400 -17,599 -17,599 20% of sales are expected to be to purchasers who seek 1 month credit. This helps explain our boost in sales by 20%. This to take effect from 1st January.
(increase)/Decrease Accounts Receivable 1,955 2,200 2,689 3,422 6,844 13,688 4,449 8,800 4,840 3,520 4,400
(increase)/Decrease Inventories -20,000 -20,000 20,000€ of extra stock level in December
(increase)/Decrease Other Current Assets 0
Rent prepaid -12,941 2,588 2,588 2,588 2,588 2,588 -12,941 2,588 2,588 2,588 2,588 2,588 0 Rent paid every 6 months
Telecoms Prepaid -380 190 190 -380 190 190 -380 190 190 -380 190 190 0 Telecoms paid in advance for three months
Increase/(Decrease) Accounts Payable and Accrued Expenses
Suppliers debts increasing 2,842 3,197 3,908 4,974 9,947 19,894 6,466 12,789 7,034 5,116 6,395 25,578 -582 Continue to receive 2 month’s credit from suppliers.
Suppliers debts decreasing -6,511 -26,044 -2,842 -3,197 -3,908 -4,974 -9,947 -19,894 -6,466 -12,789 -7,034 -5,116
Unpaid Director's Wages -4,917 -4,917 -4,917 -4,917 -4,917 -4,917 -4,917 -4,917 -4,917 -4,917 -4,917 -4,917 -59,000 Directors/Owner will take current year’s salary and also be paid back over 12 months all he is owed from previous 2 years.
Increase/(Decrease) Other Current Liabilities
Employee Social Costs 3,500 3,500 3,500 3,500 4,550 4,550 3,500 3,500 3,500 4,550 3,500 3,500 2,050 Employee Social Costs Paid month after trimester is over
Employee Social Costs -9,500 -10,500 -12,600 -10,500
Payroll company debt increasing 367 367 367 367 367 367 367 367 367 367 367 367 100 Payroll company Paid month after trimester is over
Payroll company debt decreasing -1,000 -1,100 -1,100 -1,100
Utilities debt increasing 244 275 336 428 856 1,711 556 1,100 605 440 550 2,200 367 Utilities Paid month afterwards
Utilities debt decreasing -1,833 -244 -275 -336 -428 -856 -1,711 -556 -1,100 -605 -440 -550
Net Cash Provided/(Used) by Operating Activities -40,275 -28,698 -3,345 -12,536 8,924 37,973 -23,222 5,785 7,330 -24,058 398 35,389
Investing Activities
Property & Equipment 0 We know there was a purchase of assets 19,000€ in Year 1.
Rental Deposit -77 -77 To give the landlord a warranty there is 3 months’ rent deposit paid in January would need updating due to increase of rent
Set Up Costs 0
Net Cash Used in Investing Activities -77 0 0 0 0 0 0 0 0 0 0 0 -77
0
Financing Activities 0
Increase/(Decrease) Family Loan 0
Increase/(Decrease) Current Portion Long-Term Debt 0
Increase/(Decrease) Long Term Debt 0 Business received a loan is capital repayment free for 5 years as based on positively exiting the business in 5 years
Increase/(Decrease) Common Stock 0
Increase/(Decrease) Preferred Stock 0
Dividends Declared 0
Net Cash Provided/(used) by Financing 0 0 0 0 0 0 0 0 0 0 0 0 -36,489
Increase/(Decrease) in Cash -40,352 -28,698 -3,345 -12,536 8,924 37,973 -23,222 5,785 7,330 -24,058 398 35,389
Cash at Beginning of period 114,626 74,274 45,577 42,232 29,696 38,621 76,593 53,371 59,156 66,485 42,427 42,825
Cash at end of the period 74,274 45,577 42,232 29,696 38,621 76,593 53,371 59,156 66,485 42,427 42,825 78,214
Conchur123: changed to equation than figure

Revenue Breakdowns

Seabastian wants to open a Craft Beer shop, Sebastian Craft Beer sprl
His product mix will consist of Belgian, Other European and non EU crafted beers.
Purchase price per units are researched as:
Belgian €1.00
Other EU Craft Beers €1.50
Non EU Craft Beers €2.40
From market research he makes the following assumptions on sales forecast:
Weekly Revenue Calculator
Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total
sales/units € sales/units € sales/units € sales/units € sales/units € sales/units € sales/units € sales/units €
Belgian 30 120 30 120 35 140 40 160 120 480 160 640 40 160 455 1820
Other EU Craft Beers 10 30 10 30 15 45 20 60 150 450 80 240 10 30 295 885
Non EU Craft Beers 5 30 10 60 20 120 0 0 100 600 90 540 10 60 235 1410
€180.00 €210.00 €305.00 €220.00 €1,530.00 €1,420.00 €250.00 €4,115.00
Sales GPM on each are Sales Price
Belgian 75% 4
Other EU Craft Beers 50% 3
Non EU Craft Beers 60% 6
Average week sales = 4115.00 Annual Sales Projection 205750 50 weeks
Assumption over 12 months
Monthly Revenue Breakdown
January February March April May June July August September October November December
4.00% 4.50% 5.50% 5.00% 10.00% 20.00% 6.50% 10.00% 5.50% 4.00% 5.00% 20.00% 100.00%
8230 9258.75 11316.25 10287.5 20575 41150 13373.75 20575 11316.25 8230 10287.5 41150 205750
COGS weekly calculator
Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total
sales/units € sales/units € sales/units € sales/units € sales/units € sales/units € sales/units € sales/units €
Belgian 30 €30.00 30 €30.00 35 €35.00 40 €40.00 120 €120.00 160 €160.00 40 €40.00 455 455
Other EU Craft Beers 10 €15.00 10 €15.00 15 €22.50 20 €30.00 150 €225.00 80 €120.00 10 €15.00 295 442.5
Non EU Craft Beers 5 €12.00 10 €24.00 20 €48.00 0 €0.00 100 €240.00 90 €216.00 10 €24.00 235 564
€57.00 €69.00 €105.50 €70.00 €585.00 €496.00 €79.00 €1,461.50
Sales €4,115.00 50 weeks
COGS €1,461.50
Gross Profit €2,653.50
GPM 64.48% 70.93%
COGS % 35.52% 29.07%