OCP Group E-Cademy Dominique Jacquet

  • E-learning
  • Podcasts & Vidcasts
  • Educational films
  • Courses and Certifications
  • OCP Issues Analysis
  • Fr
  • E-learning
  • Podcasts & Vidcasts
  • Educational films
  • Courses and Certifications
  • OCP Issues Analysis
  • Fr
  • Fr

Accounting for entrepreneurs, module 3 // Purchase of a machine, June

  1. Accounting for entrepreneurs
  2. Accounting for entrepreneurs, module 3 // Purchase of a machine, June
Previous Étape
Back to Course
Next Étape
WEBVTT 1 00:00:00.500 --> 00:00:03.500 Will have the months of May with a kind 2 00:00:03.500 --> 00:00:06.300 of mixed feeling of course a unique 3 00:00:06.300 --> 00:00:10.400 production cost was down which is by the way, they purpose 4 00:00:09.400 --> 00:00:12.900 the justification of our investment but 5 00:00:12.900 --> 00:00:16.100 is positive trend was not yet observed on 6 00:00:15.100 --> 00:00:18.600 the gross margin rate and the fans 7 00:00:18.600 --> 00:00:21.200 from operations where hardly positive. 8 00:00:22.200 --> 00:00:25.800 The months of June is going to be completely different. We 9 00:00:25.800 --> 00:00:28.400 are going to observe an increase in volume, 10 00:00:28.400 --> 00:00:31.500 which is going to generate economies of scale not 11 00:00:31.500 --> 00:00:34.200 only on the production cost and all the 12 00:00:34.200 --> 00:00:37.500 cost of goods all but also on the indirect cost. 13 00:00:38.300 --> 00:00:41.300 In addition to that there will be a stabilization in a 14 00:00:41.300 --> 00:00:44.700 calculation of the operating working capital requirement, which 15 00:00:44.700 --> 00:00:47.700 is going to significantly reduce its cash 16 00:00:47.700 --> 00:00:50.400 consumption as a conclusion. We are 17 00:00:50.400 --> 00:00:54.000 going to observe in June the full economic 18 00:00:53.800 --> 00:00:55.900 justification of the investment. 19 00:00:56.900 --> 00:01:00.100 What are the events in June sales are 20 00:00:59.100 --> 00:01:03.400 planned 2,900 units 21 00:01:02.400 --> 00:01:05.600 1,400 for 22 00:01:05.600 --> 00:01:08.600 b2c. 1,500 for B2B. 23 00:01:09.300 --> 00:01:14.200 We anticipate sales for July 3,000 24 00:01:12.200 --> 00:01:15.300 and 300 units. 25 00:01:16.200 --> 00:01:20.000 As we are cautious people we want to increase and 26 00:01:19.300 --> 00:01:22.800 inventory Target certified percent 27 00:01:22.800 --> 00:01:25.400 of July planned sales 28 00:01:25.400 --> 00:01:30.300 3,300. It's 1,155 units. 29 00:01:29.300 --> 00:01:32.100 We want to see in the warehouse at the 30 00:01:32.100 --> 00:01:32.600 end of the month. 31 00:01:33.400 --> 00:01:38.700 how many units should we produce in June 3,185 units 32 00:01:38.700 --> 00:01:41.400 which is a same calculation as in 33 00:01:41.400 --> 00:01:44.300 May 2900 units 34 00:01:44.300 --> 00:01:48.900 for sale 1155 units 35 00:01:48.900 --> 00:01:52.300 for inventory and of the month minus the 36 00:01:51.300 --> 00:01:54.500 inventory the number of units we 37 00:01:54.500 --> 00:01:57.500 already have in the warehouse 870 38 00:01:58.100 --> 00:02:01.500 Of course 3,000 and something is much more than the threshold 39 00:02:01.500 --> 00:02:04.800 of 2,500. We need six workers. 40 00:02:04.800 --> 00:02:07.800 Then we are going to observe no change 41 00:02:07.800 --> 00:02:10.500 in the organizational chart and the 42 00:02:10.500 --> 00:02:13.700 good news is we have no new accounting concept. 43 00:02:13.700 --> 00:02:17.700 It's going to be absolutely straightforward organizational 44 00:02:16.700 --> 00:02:20.600 chart management Administration sales 45 00:02:19.600 --> 00:02:22.400 and generate not yet 46 00:02:22.400 --> 00:02:25.800 R&D production one fals supervision six 47 00:02:25.800 --> 00:02:27.600 operators for the machine. 48 00:02:28.600 --> 00:02:32.300 Production costs business as usual we anticipate 49 00:02:31.300 --> 00:02:35.200 July sales 3,300 and 50 00:02:34.200 --> 00:02:38.000 you remember we planned some production of 3000 51 00:02:37.800 --> 00:02:40.400 100 and 85 you multiply 52 00:02:40.400 --> 00:02:43.500 that by 16 dollars you get the purchase 53 00:02:43.500 --> 00:02:45.300 of consume raw materials. 54 00:02:45.900 --> 00:02:49.000 One person for supervision six workers 55 00:02:48.300 --> 00:02:51.900 and a depreciation of the machine which is definitely a 56 00:02:51.900 --> 00:02:54.300 fixed cost. So Total Protection cost is 57 00:02:54.300 --> 00:02:58.200 59,460 you 58 00:02:57.200 --> 00:03:00.100 divide these total cost by the 59 00:03:00.100 --> 00:03:04.000 production plan 3,185 and 60 00:03:03.200 --> 00:03:06.400 then you get quite good news. The production 61 00:03:06.400 --> 00:03:10.200 cost per unit is now 18.67 dollars, 62 00:03:09.200 --> 00:03:12.700 which is significantly less than the 63 00:03:12.700 --> 00:03:15.400 price we paid for puzzles when 64 00:03:15.400 --> 00:03:18.300 we use to buy them from the supplier you remember it 65 00:03:18.300 --> 00:03:21.800 was 20 now. We generate a significant gross 66 00:03:21.800 --> 00:03:22.100 margin. 67 00:03:23.300 --> 00:03:26.200 To calculate the actual gross. Margin we have to go through the 68 00:03:26.200 --> 00:03:27.500 inventory calculation. 69 00:03:28.400 --> 00:03:31.300 Beginning of the month 870 units 70 00:03:31.300 --> 00:03:35.500 will produce 3,185 available 71 00:03:34.500 --> 00:03:38.200 for sale 4,055. We 72 00:03:37.200 --> 00:03:40.800 set 2,900 units how 73 00:03:40.800 --> 00:03:45.000 many units are left in the warehouse 1,100 and 74 00:03:44.700 --> 00:03:48.000 55 units which are evaluated 75 00:03:47.300 --> 00:03:52.700 at the unit production cost 18.67 dollars. 76 00:03:53.500 --> 00:03:56.600 Though in terms of value we still 77 00:03:56.600 --> 00:04:00.400 use the first in first out method obviously beginning 78 00:03:59.400 --> 00:04:02.400 inventory. It was in the balance 79 00:04:02.400 --> 00:04:05.400 sheet at the end of May production costs. We just 80 00:04:05.400 --> 00:04:11.400 calculated it and inventory. Well, 1,155 81 00:04:08.400 --> 00:04:11.900 units 82 00:04:11.900 --> 00:04:15.800 multiplied by the unit production cost 18.67 83 00:04:14.800 --> 00:04:17.200 and we deduct from 84 00:04:17.200 --> 00:04:20.500 that the cost of sales. The average cost of sales 85 00:04:20.500 --> 00:04:24.300 is 54 700 and 86 00:04:23.300 --> 00:04:26.100 52 divided by the number of 87 00:04:26.100 --> 00:04:29.500 units sold, which is 2,000 900 and 88 00:04:29.500 --> 00:04:32.600 we get 18.88 and although 89 00:04:32.600 --> 00:04:36.100 the way to calculate the same figure is you need 90 00:04:35.100 --> 00:04:38.900 cost of goods sold beginning inventory 91 00:04:38.900 --> 00:04:41.400 19.37 as 92 00:04:41.400 --> 00:04:44.500 you need calls good produced in June 93 00:04:44.500 --> 00:04:48.100 and sold in June 2013 units 94 00:04:47.100 --> 00:04:51.100 so some of 870 and 95 00:04:50.100 --> 00:04:53.000 30 being 96 00:04:53.500 --> 00:04:56.200 Channel 900 the number of units we 97 00:04:56.200 --> 00:04:59.600 sold in June we calculated the total cost of goods 98 00:04:59.600 --> 00:05:02.100 sold. We have the unique cost. We have exactly the same 99 00:05:02.100 --> 00:05:05.100 calculation, which is absolutely no surprise. 100 00:05:05.900 --> 00:05:08.500 Now we can build the p&l. It starts 101 00:05:08.500 --> 00:05:12.100 with sales and revenues 2,900 units 102 00:05:11.100 --> 00:05:14.700 parties. B2c part is B2B 103 00:05:14.700 --> 00:05:17.500 cost of sales. We just calculated two 104 00:05:17.500 --> 00:05:20.800 ways to calculate the gross margin is provided 105 00:05:20.800 --> 00:05:23.900 by the difference same administrative expense 106 00:05:23.900 --> 00:05:26.800 same selling expense same engineering 107 00:05:26.800 --> 00:05:29.700 expense the operating profit before interest 108 00:05:29.700 --> 00:05:32.400 and taxes is now 16,000 and 109 00:05:32.400 --> 00:05:35.600 something we deduct interest expense. We deduct 110 00:05:35.600 --> 00:05:38.700 the tax same rate 20% the net 111 00:05:38.700 --> 00:05:41.700 earnings earnings after tax. The bottom line of the period is 112 00:05:41.700 --> 00:05:44.500 12,886. 113 00:05:45.400 --> 00:05:48.500 Business as usual that decision we now have to take 114 00:05:48.500 --> 00:05:51.900 is Which percentage is distributed Which percentage 115 00:05:51.900 --> 00:05:54.300 is reinvested and as our 116 00:05:54.300 --> 00:05:57.800 cash situation is quite lower the moment we decide 117 00:05:57.800 --> 00:06:00.300 to retain 100% of the earnings of 118 00:06:00.300 --> 00:06:03.100 the period dividend declared zero. 119 00:06:03.900 --> 00:06:06.100 That was for the p&l Now we move to 120 00:06:06.100 --> 00:06:09.300 cash no increase in finance all that in 121 00:06:09.300 --> 00:06:12.800 June same as in May because there is no purchase of 122 00:06:12.800 --> 00:06:15.900 any kind of exceptional Capital expenditures. So 123 00:06:15.900 --> 00:06:18.300 the cash we collect from sales is going 124 00:06:18.300 --> 00:06:21.300 to be the one and unique source of cash in flow. 125 00:06:22.100 --> 00:06:25.500 Building the accounts receivable accounts gives us 126 00:06:25.500 --> 00:06:27.400 the cash collection from sales. 127 00:06:28.400 --> 00:06:32.900 What was you by the customer was 27,500 we 128 00:06:32.900 --> 00:06:35.500 generate sales, but you remember that the 129 00:06:35.500 --> 00:06:38.500 B2B sales 1,500 units at 130 00:06:38.500 --> 00:06:41.400 25 dollars per unit are not going 131 00:06:41.400 --> 00:06:44.800 to be paid in June. But in July they show 132 00:06:44.800 --> 00:06:47.900 in the balance it as and accounts receivable 133 00:06:47.900 --> 00:06:50.700 and of June the cash 134 00:06:50.700 --> 00:06:53.600 collection from sales walls. Obviously the 135 00:06:53.600 --> 00:06:56.900 B2B sales in May plus 136 00:06:56.900 --> 00:06:59.200 the b2c sales in June 137 00:06:59.200 --> 00:07:02.800 69,500. This is 138 00:07:02.800 --> 00:07:05.400 a total cash inflows. Now, we can move to the cash 139 00:07:05.400 --> 00:07:08.000 outflows, which start with what we are going to 140 00:07:08.400 --> 00:07:09.300 pay to the suppliers. 141 00:07:10.300 --> 00:07:13.600 The purchases in June are 50,000 on 142 00:07:13.600 --> 00:07:16.700 something 50% is paid immediately 50% 143 00:07:16.700 --> 00:07:19.900 will be paid in July. So what 144 00:07:19.900 --> 00:07:22.300 we pay is what is due at the beginning of the month 145 00:07:22.300 --> 00:07:26.400 plus 50% of the purchases. It is 45,000 146 00:07:25.400 --> 00:07:27.800 640 147 00:07:28.700 --> 00:07:32.400 in addition to that we cash out for administration. We 148 00:07:31.400 --> 00:07:34.400 cash outfall sales experience and 149 00:07:34.400 --> 00:07:37.700 generating production supervision production workers. 150 00:07:37.700 --> 00:07:41.400 No taxes later. No dividends declared 151 00:07:40.400 --> 00:07:43.100 purchase price of the machine. 152 00:07:43.100 --> 00:07:46.600 It was April. It's neither me nor Jude and 153 00:07:46.600 --> 00:07:49.300 we pay the interest. So the cash Outlet is 154 00:07:49.300 --> 00:07:53.000 61,000 700 and 80 which 155 00:07:52.200 --> 00:07:55.900 is significantly less than the 156 00:07:55.900 --> 00:07:58.700 total cash in flowers. So this 157 00:07:58.700 --> 00:08:03.800 month we generate cash of 7,720 and 158 00:08:03.800 --> 00:08:06.300 as at the beginning of the period of the cash account 159 00:08:06.300 --> 00:08:10.300 of the company was 2007 ad now 160 00:08:09.300 --> 00:08:12.200 we have some cash at the end of the period 161 00:08:12.200 --> 00:08:15.700 which is 10,500 and we feel much 162 00:08:15.700 --> 00:08:16.100 better. 163 00:08:16.900 --> 00:08:20.000 No surprise in the balance seed in factories 164 00:08:19.800 --> 00:08:22.400 calculated accounts receivable 165 00:08:22.400 --> 00:08:25.700 B2B sales cash. We just calculated 166 00:08:25.700 --> 00:08:28.500 and net property plant and 167 00:08:28.500 --> 00:08:32.500 Equipment same story as in May grows 168 00:08:31.500 --> 00:08:34.500 property plant and Equipment the historical 169 00:08:34.500 --> 00:08:37.900 purchasing prices of machine is 60,000. But 170 00:08:37.900 --> 00:08:40.700 now we have consumed the machine during three 171 00:08:40.700 --> 00:08:44.200 consecutive months. The consumption per 172 00:08:43.200 --> 00:08:46.500 month is 1000. We have consumed three 173 00:08:46.500 --> 00:08:49.200 thousand the net property plant and 174 00:08:49.200 --> 00:08:53.000 equipment is 57,000 total 175 00:08:52.400 --> 00:08:56.900 asset 1 26,562, which 176 00:08:56.900 --> 00:08:59.800 is obviously the same as a total equity 177 00:08:59.800 --> 00:09:03.400 and liabilities same Capital retain earnings 178 00:09:02.400 --> 00:09:05.700 incremented by the earnings 179 00:09:05.700 --> 00:09:08.900 of June fully reinvested 180 00:09:08.900 --> 00:09:11.600 in shareholders Equity. Same level 181 00:09:11.600 --> 00:09:15.100 of financial debt. No dividends payable accounts payable 182 00:09:14.100 --> 00:09:16.100 calculator. 183 00:09:16.900 --> 00:09:20.000 On tax payable the accumulated income 184 00:09:19.200 --> 00:09:22.500 tax payable at the end of May plus 185 00:09:22.500 --> 00:09:25.300 the tax liability. We generate in 186 00:09:25.300 --> 00:09:28.400 June as a consequence of our taxable income. 187 00:09:29.400 --> 00:09:32.500 Once the accounting job is done. We move 188 00:09:32.500 --> 00:09:35.600 to financial analysis. Same steps 189 00:09:35.600 --> 00:09:38.000 sales profit cash. 190 00:09:40.400 --> 00:09:43.500 Sales, they are growing and they are nicely growing in 191 00:09:43.500 --> 00:09:46.400 June so that we are sure now 192 00:09:46.400 --> 00:09:49.800 that the commercial success of our business is guaranteed. 193 00:09:50.600 --> 00:09:53.800 We are happy because we see the revenues growing 194 00:09:53.800 --> 00:09:56.600 which means that we have the right commercial model. 195 00:09:56.600 --> 00:09:59.300 We have the right products and we create value for 196 00:09:59.300 --> 00:10:02.500 our customers. But we also have to create value for 197 00:10:02.500 --> 00:10:06.000 our investors. We have to create value for our shareholders. 198 00:10:05.500 --> 00:10:08.900 We have to generate profits and 199 00:10:08.900 --> 00:10:12.000 transforms this customer value creation into 200 00:10:11.700 --> 00:10:15.000 investors value creation as well. The economics 201 00:10:14.700 --> 00:10:17.800 justification of the investment is shared 202 00:10:17.800 --> 00:10:20.500 in June when the growth margin 203 00:10:20.500 --> 00:10:23.800 and when the operating margin are both significantly 204 00:10:23.800 --> 00:10:26.800 up why both because we generate economies 205 00:10:26.800 --> 00:10:28.400 of scale at two levels. 206 00:10:29.400 --> 00:10:32.800 This amortization of fixed costs generates an 207 00:10:32.800 --> 00:10:35.300 increase in the gross margin of 7% 208 00:10:36.100 --> 00:10:39.200 but the operating margin is a by 11% 209 00:10:40.100 --> 00:10:43.100 So 7% come from the increase in 210 00:10:43.100 --> 00:10:46.700 the gross margin and an additional 4% comes 211 00:10:46.700 --> 00:10:49.700 from the amortization of indirect cost 212 00:10:49.700 --> 00:10:52.700 which here in this case are completely 213 00:10:52.700 --> 00:10:55.300 fixed. So we see the economic 214 00:10:55.300 --> 00:10:58.900 justification of the investment the ebit 215 00:10:58.900 --> 00:11:01.400 the operating margin is skyrocketing. 216 00:11:02.400 --> 00:11:05.600 But you remember that Prophet is one thing and cash 217 00:11:05.600 --> 00:11:08.500 is another thing because in May the 218 00:11:08.500 --> 00:11:11.500 operating working capital requirement increase was 219 00:11:11.500 --> 00:11:14.700 completely consuming the cash. We were generating from a 220 00:11:14.700 --> 00:11:15.100 bit. 221 00:11:15.800 --> 00:11:18.700 Now when we look at the operating working capital 222 00:11:18.700 --> 00:11:21.800 requirement, of course, it's up inventories are 223 00:11:21.800 --> 00:11:24.500 for exactly the same reasons as in 224 00:11:24.500 --> 00:11:28.400 May production is up first second. 225 00:11:27.400 --> 00:11:30.400 We increase the rate 226 00:11:30.400 --> 00:11:33.300 of inventories. We want to show at the end of June because we 227 00:11:33.300 --> 00:11:34.700 are cautious persons. 228 00:11:35.200 --> 00:11:38.800 Accounts receivable is because of sales grows 229 00:11:38.800 --> 00:11:41.700 that's normal and now accounts payable 230 00:11:41.700 --> 00:11:43.300 is significantly up. 231 00:11:43.800 --> 00:11:47.100 For a very good reason which is it's based 232 00:11:46.100 --> 00:11:50.300 on the same calculation. It's based 233 00:11:49.300 --> 00:11:52.900 on 50% of purchases which 234 00:11:52.900 --> 00:11:56.000 are made at 16 dollars per 235 00:11:55.900 --> 00:11:58.500 unit. Now. We see an 236 00:11:58.500 --> 00:12:02.000 increase in the accounts payable which is quite significant in 237 00:12:01.100 --> 00:12:04.500 June when it was stable in May as 238 00:12:04.500 --> 00:12:07.600 opposed to April as a consequence. There 239 00:12:07.600 --> 00:12:10.000 will be a reduction in the increase in 240 00:12:10.600 --> 00:12:13.500 the operating working capital requirement, which is 241 00:12:13.500 --> 00:12:16.900 going to be still 9,388. 242 00:12:17.900 --> 00:12:20.500 Now funds from operation. Of course, we 243 00:12:20.500 --> 00:12:23.500 observe this cash consumption, but the operating income 244 00:12:23.500 --> 00:12:26.200 is 16,000 and something depreciation, which 245 00:12:26.200 --> 00:12:30.000 is added up to calculate. The ebida is 1000. So 246 00:12:29.200 --> 00:12:34.900 on the one hand they're a bit that is 17,348 247 00:12:32.900 --> 00:12:35.500 on the 248 00:12:35.500 --> 00:12:40.200 other hand. We consume 9,388 of 249 00:12:39.200 --> 00:12:45.600 that but how much is left is 7,960 250 00:12:42.600 --> 00:12:46.300 which 251 00:12:45.300 --> 00:12:48.700 is going to be a great consequence on 252 00:12:48.700 --> 00:12:51.300 the cash position. Why because we have 253 00:12:51.300 --> 00:12:54.200 no capex. We have no Capital increase. We have 254 00:12:54.200 --> 00:12:57.200 no increase in debt. We have no debt Redemption and 255 00:12:57.200 --> 00:13:00.300 we just have to pay for the interest expense of 256 00:13:00.300 --> 00:13:02.500 two hundred and forty. 257 00:13:03.300 --> 00:13:06.400 This is a reason why then they're changing cash position is going 258 00:13:06.400 --> 00:13:10.400 to be 7,720. Now 259 00:13:09.400 --> 00:13:12.400 the manufacturing process with the 260 00:13:12.400 --> 00:13:15.200 machine is stabilized. We now have 261 00:13:15.200 --> 00:13:18.600 to go back to the final short metrics. The reason 262 00:13:18.600 --> 00:13:21.800 why we decided to buy the machine you remember 263 00:13:21.800 --> 00:13:24.400 that we were purchasing the puzzles 264 00:13:24.400 --> 00:13:27.800 at 20. Now the unit cost price 265 00:13:27.800 --> 00:13:31.800 of goods. All is 18.88 which 266 00:13:31.800 --> 00:13:34.400 basically means that we generate savings per 267 00:13:34.400 --> 00:13:37.500 unit of 1.12 doors per unit. 268 00:13:37.500 --> 00:13:40.400 We multiply that by the volume of 269 00:13:40.400 --> 00:13:43.700 sales in June 2,900 and 270 00:13:43.700 --> 00:13:46.700 we anticipate that it's going to grow again. So 271 00:13:46.700 --> 00:13:50.400 the total savings are 2,900 times 272 00:13:50.400 --> 00:13:55.000 1.12, which is 3,000 248 273 00:13:53.000 --> 00:13:55.400 dollars. 274 00:13:56.300 --> 00:13:59.600 You remember that the cost of the machine was 60,000? 275 00:14:00.200 --> 00:14:03.700 So how many months of savings do 276 00:14:03.700 --> 00:14:06.500 we need to generate to have the possibility to 277 00:14:06.500 --> 00:14:09.400 repay to redeem the purchasing of 278 00:14:09.400 --> 00:14:12.700 the machine 18 months, which is a simple result 279 00:14:12.700 --> 00:14:15.600 of a calculation 60,000 how 280 00:14:15.600 --> 00:14:19.200 much we paid 3,248 how 281 00:14:18.200 --> 00:14:21.400 much we generate each and every month? 282 00:14:22.300 --> 00:14:25.300 The expected life of the machine is five years 283 00:14:25.300 --> 00:14:28.700 the payback. The number of months is 284 00:14:28.700 --> 00:14:31.700 18 months 1.5 years. So 285 00:14:31.700 --> 00:14:35.000 you understand that we are going to repair the 286 00:14:34.300 --> 00:14:37.100 machine without discounting the 287 00:14:37.100 --> 00:14:40.700 cash flows. Okay, but as a simple calculation, we 288 00:14:40.700 --> 00:14:43.500 are going to pay the machine in 1.5 years 289 00:14:43.500 --> 00:14:47.100 and we are going to generate plenty of profits Beyond 290 00:14:46.100 --> 00:14:49.700 this kind of Time Break Even, which 291 00:14:49.700 --> 00:14:52.000 is 1.5 years. We are going to 292 00:14:52.400 --> 00:14:56.200 generate 3.5 years of profit in 293 00:14:55.200 --> 00:14:58.600 addition to the cost of the machine as a 294 00:14:58.600 --> 00:15:01.700 conclusion in June. We observe the 295 00:15:01.700 --> 00:15:03.800 economic justification of the investment. 296 00:15:04.900 --> 00:15:07.200 What it will learn during this month. 297 00:15:08.400 --> 00:15:11.500 Not many New Concept we are rainfalls this 298 00:15:11.500 --> 00:15:14.100 concept of production cost as opposed to 299 00:15:14.100 --> 00:15:17.700 cost price of goods sold, but 300 00:15:17.700 --> 00:15:20.900 no New Concept in addition. We've 301 00:15:20.900 --> 00:15:23.300 been able to Deep dive a little bit in a different 302 00:15:23.300 --> 00:15:26.600 items elements of the operating working capital 303 00:15:26.600 --> 00:15:29.300 requirement to understand what happened to the 304 00:15:29.300 --> 00:15:32.300 casparable in June as opposed to 305 00:15:32.300 --> 00:15:35.300 May again. We observe the 306 00:15:35.300 --> 00:15:38.700 sequence of building the accounts starting with p&l 307 00:15:38.700 --> 00:15:41.300 and cash to end with the balance sheet 308 00:15:41.300 --> 00:15:42.600 the picture at the end of the month. 309 00:15:43.400 --> 00:15:47.000 Last but not least for both cost categories 310 00:15:46.100 --> 00:15:49.800 fixed costs where fixed so 311 00:15:49.800 --> 00:15:52.700 we were able to observe actual economies 312 00:15:52.700 --> 00:15:53.400 of scale. 313 00:15:54.100 --> 00:15:57.300 Let's make a quick wrap-up for this module 3. 314 00:15:58.200 --> 00:16:02.100 The objective was to observe the economic justification 315 00:16:01.100 --> 00:16:03.900 of an investment project. 316 00:16:04.800 --> 00:16:07.700 We want to grow we want capacity. We want 317 00:16:07.700 --> 00:16:10.600 to control manufacturing. We invest we're 318 00:16:10.600 --> 00:16:13.800 buying machine. We buy today we generate profits 319 00:16:13.800 --> 00:16:16.600 tomorrow. This is a definition of an investment. What 320 00:16:16.600 --> 00:16:18.700 is the economic justification? 321 00:16:19.500 --> 00:16:22.300 We also introduced during the module the concept 322 00:16:22.300 --> 00:16:24.100 of financing with debt. 323 00:16:24.700 --> 00:16:27.800 We had to observe where that is introduced 324 00:16:27.800 --> 00:16:28.700 in the accounts. 325 00:16:29.400 --> 00:16:32.400 In the cash budget in a cash flow statement, but also 326 00:16:32.400 --> 00:16:34.600 in the balance sheet as a financial liability. 327 00:16:35.500 --> 00:16:38.400 We had to observe how to account for interest 328 00:16:38.400 --> 00:16:41.600 expense. It's a use it. It's a rant you 329 00:16:41.600 --> 00:16:43.600 pay on debt and it is in a p&l. 330 00:16:44.500 --> 00:16:48.000 We have an extensive discussion on costs 331 00:16:47.600 --> 00:16:50.400 and invent arrays the cost 332 00:16:50.400 --> 00:16:53.600 of goods all was quite simple in module 2. 333 00:16:53.600 --> 00:16:56.600 It was a purchasing price of the puzzle. Now, we 334 00:16:56.600 --> 00:16:59.700 had to get into production cost calculations and 335 00:16:59.700 --> 00:17:03.300 inventory calculation inventory valuation 336 00:17:03.300 --> 00:17:05.200 is a little bit more complex. 337 00:17:06.300 --> 00:17:09.300 And of course, it's about Grouse and grows and 338 00:17:09.300 --> 00:17:10.000 grows. 339 00:17:10.500 --> 00:17:13.200 Gross is about creating value for the 340 00:17:13.200 --> 00:17:17.100 customers. It's a purpose of the firm gross is 341 00:17:17.100 --> 00:17:20.600 also great because you can generate economies of scale 342 00:17:20.600 --> 00:17:24.100 you remember in June. It was absolutely fantastic seven 343 00:17:23.100 --> 00:17:26.800 percent on the gross margin 4% on 344 00:17:26.800 --> 00:17:29.600 the indirect cost and it is the economic performance 345 00:17:29.600 --> 00:17:30.200 of the company. 346 00:17:31.500 --> 00:17:34.900 Of course, but gross is also consuming cash. We 347 00:17:34.900 --> 00:17:37.300 had to buy a machine. This is an 348 00:17:37.300 --> 00:17:41.300 investment. This is cash out and we have observed each 349 00:17:40.300 --> 00:17:43.400 and every month the conception of 350 00:17:43.400 --> 00:17:46.400 cash, which is a consequence of an increase in 351 00:17:46.400 --> 00:17:48.400 the operating working capital requirement. 352 00:17:49.100 --> 00:17:52.700 So you understand that grows is absolutely great because 353 00:17:52.700 --> 00:17:56.200 it demonstrates that you have the right product under right 354 00:17:55.200 --> 00:17:58.500 price. It's great because it 355 00:17:58.500 --> 00:18:01.500 boosts economic performance when you can amortize your 356 00:18:01.500 --> 00:18:04.400 fixed cost but it is consuming cash on 357 00:18:04.400 --> 00:18:07.700 the asset side of the balance sheet property plant and 358 00:18:07.700 --> 00:18:10.200 equipment and working capital requirement. 359 00:18:11.100 --> 00:18:15.100 So gross is always a kind of ambiguous process. 360 00:18:16.400 --> 00:18:19.700 That was a rapid for module 3 but there 361 00:18:19.700 --> 00:18:22.800 is a common wrapper for module 1 and 2 362 00:18:22.800 --> 00:18:25.400 and 3. What is a purpose of 363 00:18:25.400 --> 00:18:27.200 financial accounting? 364 00:18:27.800 --> 00:18:29.200 Not to build the accounts. 365 00:18:29.900 --> 00:18:33.200 But to support operating decisions 366 00:18:32.200 --> 00:18:35.300 we take a decision which is 367 00:18:35.300 --> 00:18:38.900 to buy machine. We have to support that with financial 368 00:18:38.900 --> 00:18:41.700 accounting measuring the performance 369 00:18:41.700 --> 00:18:44.100 and evaluating the performance which is 370 00:18:44.100 --> 00:18:47.300 a consequence of these decisions. This is why 371 00:18:47.300 --> 00:18:51.400 financial accounting is so important incorporate life 372 00:18:51.400 --> 00:18:54.400 and should be absolutely Mastered by 373 00:18:54.400 --> 00:18:57.100 each and every operating manager. 374 00:18:57.900 --> 00:19:00.800 This three module trip was quite 375 00:19:00.800 --> 00:19:03.900 substantial quite significant. We learned 376 00:19:03.900 --> 00:19:06.800 plenty of things during these three modules 377 00:19:06.800 --> 00:19:09.800 and I think that it's important now we 378 00:19:09.800 --> 00:19:12.400 reach a step a level in 379 00:19:12.400 --> 00:19:15.700 accounting knowledge to make a kind of progress report 380 00:19:15.700 --> 00:19:18.800 and to review all these Concepts 381 00:19:18.800 --> 00:19:21.900 and to put them into perspective after 382 00:19:21.900 --> 00:19:24.400 this first part of the course. 383 00:19:24.400 --> 00:19:27.400 It will be also for me an opportunity 384 00:19:27.400 --> 00:19:30.600 to introduce module 4 and module 5
Will have the months of May with a kind of mixed feeling of course a unique production cost was down which is by the way, they purpose the justification of our investment but is positive trend was not yet observed on the gross margin rate and the fans from operations where hardly positive.
The months of June is going to be completely different.
We are going to observe an increase in volume, which is going to generate economies of scale not only on the production cost and all the cost of goods all but also on the indirect cost.
In addition to that there will be a stabilization in a calculation of the operating working capital requirement, which is going to significantly reduce its cash consumption as a conclusion.
We are going to observe in June the full economic justification of the investment.
What are the events in June sales are planned 2,900 units 1,400 for b2c.
1,500 for B2B.
We anticipate sales for July 3,000 and 300 units.
As we are cautious people we want to increase and inventory Target certified percent of July planned sales 3,300.
It's 1,155 units.
We want to see in the warehouse at the end of the month.
how many units should we produce in June 3,185 units which is a same calculation as in May 2900 units for sale 1155 units for inventory and of the month minus the inventory the number of units we already have in the warehouse 870 Of course 3,000 and something is much more than the threshold of 2,500.
We need six workers.
Then we are going to observe no change in the organizational chart and the good news is we have no new accounting concept.
It's going to be absolutely straightforward organizational chart management Administration sales and generate not yet R&D production one fals supervision six operators for the machine.
Production costs business as usual we anticipate July sales 3,300 and you remember we planned some production of 3000 100 and 85 you multiply that by 16 dollars you get the purchase of consume raw materials.
One person for supervision six workers and a depreciation of the machine which is definitely a fixed cost.
So Total Protection cost is 59,460 you divide these total cost by the production plan 3,185 and then you get quite good news.
The production cost per unit is now 18.67 dollars, which is significantly less than the price we paid for puzzles when we use to buy them from the supplier you remember it was 20 now.
We generate a significant gross margin.
To calculate the actual gross.
Margin we have to go through the inventory calculation.
Beginning of the month 870 units will produce 3,185 available for sale 4,055.
We set 2,900 units how many units are left in the warehouse 1,100 and 55 units which are evaluated at the unit production cost 18.67 dollars.
Though in terms of value we still use the first in first out method obviously beginning inventory.
It was in the balance sheet at the end of May production costs.
We just calculated it and inventory.
Well, 1,155 units multiplied by the unit production cost 18.67 and we deduct from that the cost of sales.
The average cost of sales is 54 700 and 52 divided by the number of units sold, which is 2,000 900 and we get 18.88 and although the way to calculate the same figure is you need cost of goods sold beginning inventory 19.37 as you need calls good produced in June and sold in June 2013 units so some of 870 and 30 being Channel 900 the number of units we sold in June we calculated the total cost of goods sold.
We have the unique cost.
We have exactly the same calculation, which is absolutely no surprise.
Now we can build the p&l.
It starts with sales and revenues 2,900 units parties.
B2c part is B2B cost of sales.
We just calculated two ways to calculate the gross margin is provided by the difference same administrative expense same selling expense same engineering expense the operating profit before interest and taxes is now 16,000 and something we deduct interest expense.
We deduct the tax same rate 20% the net earnings earnings after tax.
The bottom line of the period is 12,886.
Business as usual that decision we now have to take is Which percentage is distributed Which percentage is reinvested and as our cash situation is quite lower the moment we decide to retain 100% of the earnings of the period dividend declared zero.
That was for the p&l Now we move to cash no increase in finance all that in June same as in May because there is no purchase of any kind of exceptional Capital expenditures.
So the cash we collect from sales is going to be the one and unique source of cash in flow.
Building the accounts receivable accounts gives us the cash collection from sales.
What was you by the customer was 27,500 we generate sales, but you remember that the B2B sales 1,500 units at 25 dollars per unit are not going to be paid in June.
But in July they show in the balance it as and accounts receivable and of June the cash collection from sales walls.
Obviously the B2B sales in May plus the b2c sales in June 69,500.
This is a total cash inflows.
Now, we can move to the cash outflows, which start with what we are going to pay to the suppliers.
The purchases in June are 50,000 on something 50% is paid immediately 50% will be paid in July.
So what we pay is what is due at the beginning of the month plus 50% of the purchases.
It is 45,000 640 in addition to that we cash out for administration.
We cash outfall sales experience and generating production supervision production workers.
No taxes later.
No dividends declared purchase price of the machine.
It was April.
It's neither me nor Jude and we pay the interest.
So the cash Outlet is 61,000 700 and 80 which is significantly less than the total cash in flowers.
So this month we generate cash of 7,720 and as at the beginning of the period of the cash account of the company was 2007 ad now we have some cash at the end of the period which is 10,500 and we feel much better.
No surprise in the balance seed in factories calculated accounts receivable B2B sales cash.
We just calculated and net property plant and Equipment same story as in May grows property plant and Equipment the historical purchasing prices of machine is 60,000.
But now we have consumed the machine during three consecutive months.
The consumption per month is 1000.
We have consumed three thousand the net property plant and equipment is 57,000 total asset 1 26,562, which is obviously the same as a total equity and liabilities same Capital retain earnings incremented by the earnings of June fully reinvested in shareholders Equity.
Same level of financial debt.
No dividends payable accounts payable calculator.
On tax payable the accumulated income tax payable at the end of May plus the tax liability.
We generate in June as a consequence of our taxable income.
Once the accounting job is done.
We move to financial analysis.
Same steps sales profit cash.
Sales, they are growing and they are nicely growing in June so that we are sure now that the commercial success of our business is guaranteed.
We are happy because we see the revenues growing which means that we have the right commercial model.
We have the right products and we create value for our customers.
But we also have to create value for our investors.
We have to create value for our shareholders.
We have to generate profits and transforms this customer value creation into investors value creation as well.
The economics justification of the investment is shared in June when the growth margin and when the operating margin are both significantly up why both because we generate economies of scale at two levels.
This amortization of fixed costs generates an increase in the gross margin of 7% but the operating margin is a by 11% So 7% come from the increase in the gross margin and an additional 4% comes from the amortization of indirect cost which here in this case are completely fixed.
So we see the economic justification of the investment the ebit the operating margin is skyrocketing.
But you remember that Prophet is one thing and cash is another thing because in May the operating working capital requirement increase was completely consuming the cash.
We were generating from a bit.
Now when we look at the operating working capital requirement, of course, it's up inventories are for exactly the same reasons as in May production is up first second.
We increase the rate of inventories.
We want to show at the end of June because we are cautious persons.
Accounts receivable is because of sales grows that's normal and now accounts payable is significantly up.
For a very good reason which is it's based on the same calculation.
It's based on 50% of purchases which are made at 16 dollars per unit.
Now.
We see an increase in the accounts payable which is quite significant in June when it was stable in May as opposed to April as a consequence.
There will be a reduction in the increase in the operating working capital requirement, which is going to be still 9,388.
Now funds from operation.
Of course, we observe this cash consumption, but the operating income is 16,000 and something depreciation, which is added up to calculate.
The ebida is 1000.
So on the one hand they're a bit that is 17,348 on the other hand.
We consume 9,388 of that but how much is left is 7,960 which is going to be a great consequence on the cash position.
Why because we have no capex.
We have no Capital increase.
We have no increase in debt.
We have no debt Redemption and we just have to pay for the interest expense of two hundred and forty.
This is a reason why then they're changing cash position is going to be 7,720.
Now the manufacturing process with the machine is stabilized.
We now have to go back to the final short metrics.
The reason why we decided to buy the machine you remember that we were purchasing the puzzles at 20.
Now the unit cost price of goods.
All is 18.88 which basically means that we generate savings per unit of 1.12 doors per unit.
We multiply that by the volume of sales in June 2,900 and we anticipate that it's going to grow again.
So the total savings are 2,900 times 1.12, which is 3,000 248 dollars.
You remember that the cost of the machine was 60,000? So how many months of savings do we need to generate to have the possibility to repay to redeem the purchasing of the machine 18 months, which is a simple result of a calculation 60,000 how much we paid 3,248 how much we generate each and every month? The expected life of the machine is five years the payback.
The number of months is 18 months 1.5 years.
So you understand that we are going to repair the machine without discounting the cash flows.
Okay, but as a simple calculation, we are going to pay the machine in 1.5 years and we are going to generate plenty of profits Beyond this kind of Time Break Even, which is 1.5 years.
We are going to generate 3.5 years of profit in addition to the cost of the machine as a conclusion in June.
We observe the economic justification of the investment.
What it will learn during this month.
Not many New Concept we are rainfalls this concept of production cost as opposed to cost price of goods sold, but no New Concept in addition.
We've been able to Deep dive a little bit in a different items elements of the operating working capital requirement to understand what happened to the casparable in June as opposed to May again.
We observe the sequence of building the accounts starting with p&l and cash to end with the balance sheet the picture at the end of the month.
Last but not least for both cost categories fixed costs where fixed so we were able to observe actual economies of scale.
Let's make a quick wrap-up for this module 3.
The objective was to observe the economic justification of an investment project.
We want to grow we want capacity.
We want to control manufacturing.
We invest we're buying machine.
We buy today we generate profits tomorrow.
This is a definition of an investment.
What is the economic justification? We also introduced during the module the concept of financing with debt.
We had to observe where that is introduced in the accounts.
In the cash budget in a cash flow statement, but also in the balance sheet as a financial liability.
We had to observe how to account for interest expense.
It's a use it.
It's a rant you pay on debt and it is in a p&l.
We have an extensive discussion on costs and invent arrays the cost of goods all was quite simple in module 2.
It was a purchasing price of the puzzle.
Now, we had to get into production cost calculations and inventory calculation inventory valuation is a little bit more complex.
And of course, it's about Grouse and grows and grows.
Gross is about creating value for the customers.
It's a purpose of the firm gross is also great because you can generate economies of scale you remember in June.
It was absolutely fantastic seven percent on the gross margin 4% on the indirect cost and it is the economic performance of the company.
Of course, but gross is also consuming cash.
We had to buy a machine.
This is an investment.
This is cash out and we have observed each and every month the conception of cash, which is a consequence of an increase in the operating working capital requirement.
So you understand that grows is absolutely great because it demonstrates that you have the right product under right price.
It's great because it boosts economic performance when you can amortize your fixed cost but it is consuming cash on the asset side of the balance sheet property plant and equipment and working capital requirement.
So gross is always a kind of ambiguous process.
That was a rapid for module 3 but there is a common wrapper for module 1 and 2 and 3.
What is a purpose of financial accounting? Not to build the accounts.
But to support operating decisions we take a decision which is to buy machine.
We have to support that with financial accounting measuring the performance and evaluating the performance which is a consequence of these decisions.
This is why financial accounting is so important incorporate life and should be absolutely Mastered by each and every operating manager.
This three module trip was quite substantial quite significant.
We learned plenty of things during these three modules and I think that it's important now we reach a step a level in accounting knowledge to make a kind of progress report and to review all these Concepts and to put them into perspective after this first part of the course.
It will be also for me an opportunity to introduce module 4 and module 5