Create a Cash Flow Statement

The Academy - Statement of financial position (as at September 30, in CAD) 2017 2016 Assets Current Assets Cash A/R Income taxes recoverable Deposits Total current assets 97,498 8,692 0 4,500 110,690 51,591 7,948 2,824 4,500 66,863 69,690 35,493 30,414 34,197 827 Non-current assets Furniture and equipment Less: accum. Depreciation furniture and equipmen Computer equipment Less: accum. depreciation computer equipment Leasehold improvements Less: accum. Leasehold improvements Total non-current assets 69,690 39,276 827 749 40,345 36,483 78 155 672 40,345 32,584 3,862 34,354 7,761 42,113 Total assets 145,044 108,976 Liabilities and shareholders' equity Current liabilities Accounts payable Accrued liabilities Income tax payable Due to shareholders Total current liabilities 10,734 10,111 3,412 68,805 8,915 21,572 0 76,805 93,062 107,292 100 Shareholders' equity Share capital Retained earnings Total shareholders' equity 100 51,882 1,584 51,982 1,684 Total liabilities and shareholders'equity 145,044 108,976 The Academy - Income Statement for the year ending September 30 (in CAD) income tax rate 0.14 0.171 2017 300,323 % 100.0% 2016 249,248 % 100.0% Revenue Cost of Sales Trainers Purchases including freight Gross Profit 103,234 7,177 189,912 34.4% 2.4% 63.296 103,785 3,198 142,265 41.696 1.3% 57.1% Operating expenses Rent Advertising and web design Depreciation Office supplies Repairs and cleaning Utilities Business licenses and memberships Professional fees Insurance Telephone Meals and entertainment Office supplies Conventions and courses Total operating expenses 59,183 26,862 12,554 6,796 5,464 4,291 4,087 2,192 2,170 1,293 919 496 0 126,307 19.7% 8.9% 4.2% 2.3% 1.8% 1.4% 1.4% 0.7% 0.7% 0.4% 0.3% 0.2% 0.0% 42.1% 59,875 16,709 15,268 6,439 5,868 4,027 4,056 1,960 2,091 3,382 3,843 1,995 109 125,622 24.0% 6.7% 6.1% 2.6% 2.4% 1.6% 1.6% 0.8% 0.8% 1.4% 1.5% 0.8% 0.0% 50.4% Net income before interest and tax Interest expenses and bank charges Net income before tax Income tax expense Net income 63,605 4,895 58,710 8,412 50,298 21.2% 1.6% 19.5% 2.8% 16.7% 16,643 3,923 12,720 2,176 10,544 6.7% 1.6% 5.1% 0.9% 4.2% * All sales are made on credit. Sales figures do not include personal training revenues. These revenues go directly to the trainer ** All expenses related to cost of sales were paid on credit 112,749 30,414 Non-current assets Furniture and equipment Less: accum. Depreciation furniture and equipment Computer equipment Less: accum. depreciation computer equipment Leasehold improvements Less: accum. Leasehold improvements Total non-current assets 69,690 43,059 827 826 40,345 40,382 69,690 39,276 827 749 40,345 36,483 69,690 35,493 827 672 40,345 32,584 1 78 same $ as in 2017 34,197 same $ as in 2017 155 same $ as in 2017 7,761 42,113 -37 3,862 34,354 Non-current assets (book value) Accumulated depreciation Total non-current assets (net) 110,862 84,267 26,595 110,862 76,508 34,354 110,862 68,749 42,113 Total accumulated depreciation as of 2017 Depreciation 2018 (as per income statement) Total accumulated depreciation as of 2018 76,508 12,554 89,062 depreciation of the year 3,783 77 3,899 7,759 12,554 4,795 3,783 77 3,899 7,759 12,554 4,795 depr from income statement difference *we don't have enough information about replacement of equipment