All blogs & thangs

Ratio commentary

When I began the task of calculating the ratios for Steel & Tube, I thought it was going to be quite a daunting process. Even though, I still considered myself a numbers person; towards the beginning of Assignment 2, I felt as though I had struggled throughout the term being able to relate to my firm or have an in-depth understanding of their financials. However, after receiving the marks that I had done for the assignment 1, I knew I was doubting myself for no reason and I had the ability and knowledge to calculate the ratios successfully. Also after watching Maria’s lecture, the task of calculating the ratios almost felt as though they were going to be easy with the most difficult task actually commentating on the findings and conclusions of the ratios.

Weighted average cost of capital

Martin suggesting using a Weighted Average Cost of Capital of 10% for step 8 unless we had reasons not to. Steel & Tube had a WACC of 9.19% for 2016, 10.5% for 2015, 8.8% for 2014 and 7.1% for 2013 which resulted in an average of 9.04%. I used the actual WAAC for each year for the Ratio Calculation instead of the 10% as I wanted to see the true figures not have that 1% variance.

 Profitability ratios

 My understanding of the Net Profit Margin is that the higher this percentage is, the better; as it indicates the business’s efficiency and how much of each dollar collected as revenue by Steel & Tube and is turned into profit. This margin has been reasonably consistent over the last four years at Steel & Tube with it progressively and constantly increasing each year whilst still not dropping below 4%. Seeing these good numbers, it made me wonder where Steel & Tube were sitting in comparison to other firms so I compared my ratios to Maria’s firm Wesfarmers. Even though the scale of these firms is non-comparable; at the end of the day every company wants to have a reasonable Net Profit Margin. Even though Wesfarmers Net Profit Margin fluctuates significantly in the past four years, they have maintained a positive figure. As mentioned, Steel & Tube and Wesfarmers are entirely different industries however Steel & Tube are generating more profit than Wesfarmers for every dollar spent with the exception of 2014.

Return on Assets (ROA) is also used to tell us how efficient the company is but in the sense of how much profit is generated from assets. Again, with this value, I believe that the higher this percentage is; the better. This means that the business is more profitable and it is earning more money on less investments. Comparing this to Wesfarmers, again shows different figures with their ROA not being consistent over the four-year period. Unlike Steel & Tube, Wesfarmers have increased every year except for the most recent whereas Steel & Tube had a small drop of 0.5% in 2014 but then consistently increased years after. ROA was actually a concept I had a good understanding on and believe that the positive and reasonably consistent figures for Steel & Tube tell us that they have continued to generate earning from their assets every year with the exception of 2014. The 2014 ROA made me wonder what happened in that year to have a lower return on assets than any of the other year. Looking back at my financial statements I determined that it wasn’t that they had less assets as they have increased assets significantly every year but it was possibly because their Net Profit after tax was only approximately 5.9% greater than 2013 but they had a sales Revenue that was approximately over 12.2%.

Efficiency ratios

Looking at the efficiency ratios for Steel & tube, it did exactly what I thought it was going to do; which was to indicate how effective the firm was operating. My understanding of efficiency / asset management ratios, is the firm’s ability to use their assets whilst managing their liabilities in a resourceful manner. Even though Steel & Tube operate in both the service and production industry; their inventory listed on the balance sheet is based off their production aspect. Once I had calculated the ratio, I found that there is a significant amount of time that Steel & Tube actually held onto their inventory for before they saw any profit from it. These figures are quite inconsistent and vary each of the years out of the four that were analysed. It does make me wonder how long is too long to have stock sitting in inventory not making or producing revenue? The shortest time that the inventory was on hand was approximately 80 days. When I reflect and compare this to Wesfarmers, it is almost double. My first thoughts were that this is a bit crazy to think that the figures are almost double but then I realised that a big contributing factor to Wesfarmers and their inventory is partly made up of food products from Coles which would mean a lot of the food has expiration dates as well as consumers coming into purchase the goods on a daily basis. Whereas the steel industry would only have commercial or big companies purchasing the good most of the time infrequently. My understanding of the asset turnover ratio for Steel & Tube is that they have produced a brilliant rate. This is because this ratio is what actually determines how well the firm generates sales from their assets. Currently Steel & Tube are turning $1.56 into sales for ever $1 of assets. This result seems like a great one when I compare it with Wesfarmers as it is a higher figure than their already good asset turnover ratio. The asset turnover ratio for Steel & Tube has fluctuated every year however it has consistently not dropped below 1.5 in the four-year period that is analysed. This did however have me questioning what is was that is happening with the firms asset which causes them to drop every second year

Liquidity ratios

Liquidity ratios are those that measure a company or firm’s ability to pay their debt and are another ratio where the higher the ratio is, the better it is. By dividing the current assets by their current liabilities, it proved that Steel & Tube are very capable of paying their debts. In 2016 Steel & Tube had the lowest of their liquidity ratio which translated into them having 1.56 times more current assets than liabilities. This was the lowest ratio that was calculated over the four-year period. Whereas Wesfarmers produced figures less than 0 which means that they had more liabilities than assets for two out of the four years analysed.

Financial structures ratio

 Continuing on from the liquidity ratios I was expecting the debt / equity ratio would put Steel & Tube in a very good place but this was not the case. The Debt / equity ratio was reasonably simple to calculate as it is exactly what it sounds like; which is the ratio of debt to equity within the firm. Steel & Tube have slowly but consistently increased their debt to equity ratio since 2013 with it more than doubling in the four years. The question I keep asking myself, is why? Steel & Tube appear to have had a consistently high debt ratio since 2014 which is around 40-45%. This is one of the only ratios that Steel & Tube and Wesfarmers appear to have quite similar figures with high debt/equity ratio as well as reasonably high individual debt and equity ratios. The conclusion that I have come to with Steel & Tube’s financial structure ratios is that they are a moderately risky firm. I believe this is subject to change because of how much their debt ratio has changed from 2013 to 2016 which was over 15% in such a short period of time

Market ratios

 Completing the market ratios was actually the first section of the ratios where I ran into issues. This occurred when I was attempting to find my number of ordinary shares issued. I had located the number of issued ordinary shares but I hadn’t divided them by 1000. A peer had realised what I had done wrong once I had posted to the forums and social media looking for assistance. If the Earnings Per Share (EPS) where not already listed in my financial statements, I am not sure if I would have noticed my mistake. Steel & Tube have consistently increased their EPS for their investors by increasing a minimum of 4c every year in the four years that are analysed.

When analyzing the EPS to the dividends per share (DPS) I found that there was not much of a difference between the two at all.  The DPS for Steel & Tube were quite consistent over the four-year period and highlights that they are focused at returning value to their investors as they have increased every year. In comparison to Wesfarmers, Steel & Tube are not performing anywhere near as well but considering they have been a listed company for a reasonably length of time, in my opinion, I wouldn’t consider the earnings per share to be good value.

The Price per earnings ratio is to reflect the potential earnings of a company for their investors. From the price earnings ratios of Steel & Tube they are all positive and have only differed slightly over the four years that were analysed. I struggled to understand the Price earnings ratio for steel & tube and how it is an accurate representation of the success or performance of their firm considering the EPS is made up of the WACC for the firm and the WACC can be set and structured and unable to change each year.

Ratios based on reformulated financial statements

 Calculating the ratios from the reformulated financial statements was a lot easier than I was expecting it to be. Determining and understanding what they meant was the real task.  Based on the figures below for every dollar of shareholder equity Steel & Tube were generating between 10 and just over 13%. This is a very good result for the firm as it proves how profitable a business is by displaying how well the firm uses their investments to generate return/ profit. Moving onto Return on Net Operating Assets (RNOA) which we all know is the Tax operating income (OI) divided by the Net Operating Assets (OA). Steel & Tube have had a relatively stable RNOA which have seen their figures increasing slightly from 2013 to 2015 where they then dropped in 2016. My understanding of the RNOA increasing would mean that the assets are generating revenue for the firm and the assets are not costing the firm.  The Net Borrowing Cost (NBC) of a firm is the cost of debt for the firm and can be interpreted or looked as the average interest rate that the firm pays on finance. Steel & Tube have a significantly low NBC which is a great thing because it costs them less tax for their financial obligations. Compared to Wesfarmers, Steel & Tube have a better NBC ratio and have consistently kept this figure low whereas Wesfarmers has fluctuated each year analysed. If the financial statements were restated incorrectly, I can now see how much of an affect this would have on the ratios. If the Financial and Operational costs were not categorised correctly, it would alter the ratio completely providing an entirely different financial story potentially causing a firm to be paying more tax then necessary on their obligations. Profit Margin (PM) and Asset Turnover would have to be the simplest of all ratios and in my opinion; the easiest to understand with the most to relate to. The PM shows how much earnings are kept for every dollar of sales whereas the ATO shows the sales generated relative to the firm’s assets. The PM has increased consistently each year which indicates that the profitability ratio displayed as a dollar value is that there is a 5c net income for each dollar of total income earnt in 2016. It’s interesting to compare these figures between Wesfarmers and Steel & Tube because of the completely different industries and the sheer volume of income that is different between the two. One thing I really need to just say quickly about ATO (Asset Turn Over) is that I am not a fan of the acronym purely because it is the same acronym as Australian Taxation Office. The ATO is another ratio where the higher the figure, the better it is. When comparing the ATO to the TATO, the ATO is consistently at a higher rate which means that Steel & Tube are not generating as much revenue from their operating assets.

Economic profit

Moving onto the final ratio calculation of Economic profit. Economic profit is to tell us if a company of a firm has an economic profit or loss and if they are returning at a rate below or above their cost of capital. As mentioned above, I have used the actual weighted cost of capital which Steel & Tube have provided for this ratio calculation. In 2014, they recorded a negative figure with the other three years being positive but not consistently increasing. Steel & Tube have had a combination of both experiencing an economic profit and loss over the last four years. The year the loss was experienced, it was a loss of -1085.35. If you look at the contributing factors that make up this formula it is easy to see why it is in fact a negative economic loss. Steel & Tube produced the lowest RNOA in that same year which in turn has significantly contributed to the negative economic profit figure. The NOA has actually began to increase consistently since the year with the low RNOA which I think will contribute to the continued success of a positive economic profit for the firm’s future.

Advertisements

Ratios

So when I was reading about Step 8 I thought it was going to be quite difficult but it definitely wasn’t the case at all! I absolutely loved step 8’s calculation of ratios! But unfortunately, not so much with the commentary aspect.

I have included my ratio calculations below.

Screen Shot 2017-10-08 at 3.47.36 pm

Let’s hope they are correct and I can work on the hard part now of working out what they all mean and put some commentary together.

Please drop me a line if you have any feedback at all.

Calc-you-later

The struggle continued….. but then it got better!

So the struggle continued with another aspect of my restated statements not balancing. I had come to the end of the online lecture for about the third time and it was time to do calculate the Comprehensive Net Profit after tax (CI). I had crossed my fingers and hoped for the best but it just didn’t happen. It was about 300K too much. My heart sunk and I just thought how on earth could I have made a mistake so big. I had been doing the little checks throughout each section as suggest by Maria so I was racking my brain on how it was so very wrong.

And as it turns out, I had done the same thing as I had done with Total + Equity not equalling NOA for the year of 2013. I had not included the Cost of Sales as an operating or financial expense.  Thankfully, I had marked my financial statements with O and F and could see that I had not marked that so it stood out enough to notice it reasonably quickly.

Martin asks us to comment on whether we found the process of restating our statements, frustrating, confusing or enlightening. And I feel as though I have felt each of these emotions through this process. They were definitely  a lot easier than I had imagined but I really credit this to the online Echo 360 Lectures because without those I think my thoughts about this would be a completely different story. I was confused a couple of times throughout the restating process but I think I really was only genuinely confused when I experienced the CI not balancing as well as my Total + Equity not = NOA for 2013. I think one of the biggest feelings I experienced throughout this process was enlightenment. I thought I knew my way around excel pretty well considering it is a tool that I use regularly but now I think I am on my way to becoming a little bit of a wiz. The little tricks and tips that Maria speaks about in the Echo 360 lectures really change the whole experiencing. Specifically one thing I would like to point out is linking of cells, this is just simply amazing! I can’t believe I have gone so long typing things out twice when I could have simply linked them. This is something so little but so big in my eyes! I know we talked about the classification of Operating Vs Financial in Chapter 4 but I hadn’t really applied it to my firm until I began to restate. It really has given me a deeper understanding into the costs associated not only with my Firm but also the costs of companies in general. At work now, i continue to think a little bit more about the costs associated with everything and wonder where our accounts team would be classifying them. Prior to the restating process I never really thought too much into it but have a new way of looking at things now and feel very grateful for what I have taken away so far.

Anyways, that is enough feedback for today because I am so excited to say that I have completed my restated financial statements and have uploaded my draft here . I would really appreciate some feedback if people had the time 🙂

Calc-you-later

The struggle is real.

Can I just say the struggle is so very real! I was feeling pretty okay about restating our financial statements because of how great Maria’s online lectures are. I definitely couldn’t have done this without those. But can I also ask, how many times does it take to look at the same numbers in excel before you want to tear your hair out? When completing my restated statements of financial position everything went perfect.

Until…. Until my Total + Equity did not equal NOA for the year of 2013. I just couldn’t work it out. Everything looked right. I could have been looking at it for hours and I just couldn’t see it. I decided that I had to look away from the screen and take a break before my eyes turned square. And when I returned, would you believe it. I could see it. It was shining. I had never been so happy to see an error but I was. I realised that I had not included Property, Plant & Equipment in Operating Assets. Once I added this in, everything seemed right in the world again.

I am currently away for work at the moment and staying on camp so not in my usual environment where I am in the zone so this is causing a slight delay. I do find it a little ironic that I am out at Curragh Coal whom I think parent company is actually Wesfarmers. Isn’t it funny how the world work with the little amusing things. I  will be uploading the draft of the statements shortly and would really appreciate some feedback.

Calc-you-later.

 

 

Feedback Delay

Hiya guys,

Just touching base to let everyone know that I have an extension for my assignment #1 and I will be completing the feedback for everyone over the next couple of days. I know the majority of people would have submitted their assignment already and my feedback won’t be able to take the feedback on board for Assignment #1 as such. However, I will still provide the feedback and hope that everyone can take it on board and reflect for Assignment #2.

Calc-you-later

Delays meme

Stronger in Everyway

On Friday evening I was assigned my company, which is a New Zealand company called Steel & Tube. As the name suggests, they the leading manufacturers, suppliers and distributors of metal and related products in the not so distant Kiwi Land. They supply, distribute and manufacturer all the metal products you could dream of; from nuts and bolts, to roofing and farm fencing, to pipe fittings and valves; they have it all.

I was neither excited nor disappointed with my company assignment, as working for the company that I do, I am exposed to and work with a huge variety of industries on a daily basis. So having Steel & Tube as my assigned company feels a little like industrial home in a weird way.

Steel & Tube are going strong, and have over 60 years of trading experience in New Zealand. They engage in almost every market you could think of that has a metal need. From infrastructure, commercial and residential construction, both heavy and light engineering, to energy, manufacturing and rural sectors.

I have found that they have are in fact going so strong that they have opened a new complex in Dunedin which consolidates several previous complex’s into one. Christchurch, Steel & Tube is also consolidating several businesses into two larger facilities, centralising its distribution and processing hubs for Canterbury with the work expected to be completed later this year and early 2018 respectively.

Steel & Tube have a management team that is built of six directors and a lead team of eight. They are committed to publicly showing the Governance with the below charters and policies:

 

Their commitment to delivering exceptional service, quality and value to their customers and shareholders is maintained through their people who always act safe and are reliable, accountable and committed. Quality is a major focus point of the exceptional service and Steel & Tube as even have their own Quality Policy . This policy highlights that they are committed to the principle that all customers and stakeholders should expect consistent, outstanding service, and quality products from their company. There are no exceptions to this and as their slogan suggests; they are Stronger in Everyway.

Everyone loves a slogan, and even if I think “Stronger in Everyway” is simple, I simply love it! I find that keeping things uncomplicated is clever, and over thinking something as simple as a slogan can really change your first impressions. They have stuck with what they know, and what they do best.

 

From my initial findings of Steel & Tube, I have found out some insightful information and can’t wait to share the more I know. But for now,  I am off to dive deep into the world of Steel & Tube, and will see you on the other side of their financial statements!

Calc-you-later

LJ

 

 

 

This is ironic

So WordPress keep saying that this is my very first Blog post and they aren’t wrong. Ironically, I work in Technology Solutions so I cannot help but find it amusing that I have absolutely no idea what I am doing. Anywho, welcome to my blog!

Create a website or blog at WordPress.com

Up ↑