My Accounting Journey



ACCT11081 Introductory Financial AccountingAssignmentBy Angela Engelbrecht -12048737Blog: My Accounting JourneyMoodle: Angela Engelbrecht STEP 3My company 401002528765500The company I have been given is Aluminium Bahrain B.S.C.Aluminium Bahrain WebsiteAnnual Report 2014Annual Report 2015Annual Report 2016I was initially overwhelmed when I saw my company was an aluminium smelter because I know nothing about the industry. I was even more overwhelmed that it is in Bahrain and it trades in Bahrain dinar. Where and what the heck is that? I then remembered my anxiety when I received a UK construction company, Bellway, in ACCT11059, and I remembered how much I enjoyed researching that company through the assignment. I know from discussions with other students that I am not the only one that had this reaction and that we all calm down and get on with it in the end.Aluminium Bahrain is in The Kingdom of Bahrain in the Middle East. The Kingdom of Bahrain is an island in the Persian Gulf just North of Qatar and 25km off the North East coast of Saudi Arabia. It is connected to Saudi Arabia by a 25 kilometre long bridge. Bahrain has a high human development index and was recognised by the World Bank as a high income economy. Bahrain’s currency is the Bahrain dinar (BHD) and 1BHD is equal to 3.14AUD so the currency is quite strong. Their shares are currently trading on the London Stock Exchange at US$6.61.Aluminium Bahrain, or Alba as they call themselves, is an aluminium smelter company. This means they extract aluminium from its oxide, alumina, and then they make products out of the aluminium which they sell to downstream industries. Downstream industries, for those of us that are not aware, are industrial firms that process the output of other firms into a finished product. Alba produces billets, slabs, foundry, ingots and liquid aluminium from the aluminium they extract. Below are examples of the end products from Alba’s output;Billets are sold to aluminium extrusion suppliers who use the versatile properties of aluminium alloys to create profiles in all shapes and sizes. They are used mainly in building applications like structural components and window frames.Slabs are cast in rolling mills to produce foil stock which is then re-rolled into household foil or packaging materials used mainly by pharmaceutical industries. Other types of slabs are rolled into plates or sheets for use in general engineering and building industries.Foundry alloys are used by automotive components manufacturers to cast wheels and engine blocks.Standard Ingots are re-melted and then cast into various products used in the construction industry, transportation, electrical goods and household appliances to name a few.Liquid molten metal is sold primarily to Midal Cables, one of the world’s leading cable and rod manufacturers. The liquid takes around 5 hours to solidify and can be transported to customers near Alba who can then cast their products directly without having to re-melt the aluminium. 48672753340100048577501548765004857750615315004857750250126500I found Alba’s annual report to be very informative and easy to read. I feel like they are quite transparent and aim to show honesty and integrity to their stakeholders. The company started in 1968 with the first production in 1971 with a maximum capacity of 120,000 metric tonnes per annum. In 2016 they achieved a record setting year with a production of 971,420 metric tonnes. They appear to be very successful and are expanding to add a 6th pot line. This expansion is due to roll out its first production on 1st January 2019. This additional pot line will bring their capacity to 1.5 million metric tonnes per annum, which will make them the largest single-site aluminium smelter in the world. They have also secured US$1.5 billion in financing to complete the line 6 expansion, which is the largest corporate loan in the history of Bahrain. This shows the trust the financers have in the company. I found a great corporate video on their website Corporate Video from 2014, which I put on my blog Step 3 - My Company - Aluminium Bahrain. This video shows their professionalisms and their commitment to their people. They are very proud of their country and their company.Alba’s sales in 2016 were BD669 million (US$1,704 million), down from US$ 1.993 million in 2015, and with a net profit of BD48 million (US$129 million), down from US$159 million in 2015. The downturn in sales from 2015 to 2016 is due to lower LME (London Metal Exchange) prices and premium prices, and the price of aluminium fell in 2016 due to global uncertainty. Key challenges Alba faces;Volatile LME pricesHigh US interest ratesChinese over productionCompetitionRising costsOther risks and uncertainties Alba faces;Price of AluminiumHealth, safety, security and environmental risksLoss of either of their two largest customersDisruption to supply chainNatural gas supply at competitive ratesAlba is very proactive in regards to employee happiness and safety. ‘I remain grateful to my fellow Board of Directors for their able and dynamic leadership in supporting Alba in our long-term success. I, also, express my appreciation to Alba’s Management Team for their commitment towards developing Alba from within and steering the Company to a better and stronger position. Most importantly, I thank our employees who have transformed challenges into opportunities and made Alba what it is today.’ Daij bin Salman bin Daij Al Khalifa Chairman of the Board in the 2016 annual report. Safety, health and environment are very important to them and they believe that continual improvement in safety is a key advantage over their competitors. This is because safety is the key to a good working culture and a profitable business. More safety equals less accidents and less down time. They also believe that their focus on managing costs through their ongoing initiatives is keeping them one step ahead of the competition. They invest in their people and they train and upskill their employees to further their financial success. Showing their commitment to health and safety, here (health & safety achievement) is a media release of an announcement that Alba reached 5 million hours at their Casthouse without any LTI (Lost Time Injury). They consider this a significant accomplishment as they have been working on Tomorrowland, a safety initiative, and they invest a lot of effort into their safety policies. They are continually improving and developing to ensure they come out on top in a volatile industry. In 2016 global demand for aluminium consumption was at a record high at 59.6 million metric tonnes and the world production was at 58.9 million metric tonnes which is looking good for Alba and its future. They also believe that the global demand for aluminium is expected to grow.In 2017 there have been articles in the media about China’s illegal output and Beijing’s noxious smog. China has a limit on capacity because of environmental protection and air pollution control, and has allegedly been overstepping that capacity. There has also been talk of a third of China’s capacity being cut during the winter heating season, which starts in November, to ease the air pollution problem. This talk has forced the price of aluminium to go up. I have included some media links below and the effects this has had on aluminium price. It will be interesting to see Alba’s annual report for 2017 to see what impact this has on the company.Article - Chinese Aluminium Smelters - February 2017Article - Chinese Aluminium Smelters - July 2017Article - Chinese Aluminium Smelters - August 2017In November this year in the media there was an article about Cracks Open in Aluminium Raw Materials Supply Chain. They are still trying to assess what impact the Chinese shutdowns will have on the aluminium market and production. On the LME aluminium was trading as high as US$2,215/tonne, which is considerably higher than the ~US$1,700 of November 2016. Alumina and carbon anode have both jumped in price and that is a concern. Alumina has increased 50% in price in the past year and aluminium has only increased 25% in price. There has also been a change in the pricing structure. Previously the volatility in the alumina price was not a concern for smelters because most of them had a supply contract linking the price to that of primary aluminium. It was like a natural hedge. Now that hedge is gone because the link between alumina and primary aluminium is no longer there and a price index is being used instead, although no pricing structure has been agreed on yet. I do find it difficult to understand hedging and price indexes and I would love to gain more understanding in this area. Carbon anode, produced from petroleum coke, is necessary in the extracting process and there is no alternative at the moment. The supply of carbon anode is also being disrupted by China’s winter shutdown because China is the main supplier of petroleum coke, and it is believed that supply will run out. It is all very much up in the air. It’s all very exciting!There is also talk in the media about America imposing import duties on aluminium. The US is conducting an investigation into aluminium imports, mainly from China. This could impact the aluminium suppliers as well as downstream industries in the US. The outcome on whether or not the duty will be imposed is yet to be decided. US Import Duties on Aluminium - November 2017. So much is happening in the aluminium industry at the moment.In October of this year Alba released their third quarter reports, Q3 Results - October 2017 and reported an increase in sales for 2017 which they attribute to a comeback in the global aluminium market. They have reported a 35% increase in sales in the third quarter from last year and net income is up 80% from the third quarter last year. As they predicted the global demand for aluminium is growing and as far as I can see all the uncertainty is not impacting them right now. I also had a look at their share prices over the past five years and it is very interesting to see the impact the uncertainty in the aluminium industry had on the company through 2016, bottoming out in January 2017. I have included a graph below and you can see that 2017 has been a much more stable year for the company with share prices quickly returning to their pre 2016 figures and even higher.Alba’s financial statements look similar to Bellway’s, the company I had in ACCT11059. Some of the statements are called different names and there are only the consolidated financial statements, no company statements, but the layout looks very similar. The Statement of Comprehensive Income, or Income Statement, is quite short. They show sales and cost of sales and then a few other income and expense items being other income, foreign exchange translation, administrative expenses, selling and distribution expenses, finance costs, directors’ fees and then tax expense. That is it. In the notes their other income is made up of sales of water, settlement of a legal case, interest and miscellaneous. It is interesting to note that because they have their own seawater desalination plant, they use their own water and sell it too. They also have their own petroleum coke Calciner plant where they make their own coke needed in the production of aluminium. Alba is one of only two aluminium smelters with their own Caliner.I did notice their sales increased from 2013 to 2014 and then slightly decreased through 2015 and 2016, the same with their profit, as we can see in the graph below. They attribute this to the price of aluminium. The volatility of the cost of alumina and the price of aluminium must make it difficult for this company to keep the operating profits constant.We can also see from the profitability ratios below that their return on assets has decreased since 2014 and their net profit margin has decreased too.?2016201520142013Net Profit MarginNet profit after tax/sales7.2%7.8%11.7%10.6%Return on AssetsNet profit after tax/total assets4.1%5.1%8.3%6.8%I thought it would be beneficial to work out their financial structure ratios as the company has many assets and I was interested to see how it looked. I was happy to find out that they look to be in a very good financial position. The debt/equity ratio compares the debt to the equity and Alba does not have much in the way of liabilities compared to their assets. Their equity ratio shows how much of the company is being funded by its investors and according to the figures below that is a considerable amount, which is good too. Alba’s debt ratio, debt to assets, is very low showing the company does not have a lot of debt in comparison to its assets. Although their net profit margin has decreased slightly, their financial position is better. A lot will change this year with the expansion of pot line 6 and their US$1.5 billion finance loan.??2016201520142013Debt/Equity RatioDebt/equity18.8%24.8%26.5%35.7%Equity RatioEquity/total assets84.2%80.2%79.0%73.7%Debt Ratio?15.8%19.8%21.0%26.3%Looking at the Consolidated Statement of Financial Position, or the Balance Sheet, Alba’s assets are made up of property, plant and equipment. This comprises of land and buildings, a power generator plant, other equipment and assets in the process of completion. There are other assets, which is the lease rights to land and deferred tax. I did not know what deferred taxes was but the notes tell me it is differences between carrying amounts of taxes and liabilities for financial reporting purposes and amounts used for income tax purposes. I still do not fully understand the difference between the two. There is also inventory, trade and other receivables and bank balances and cash. Their inventory is made up of raw materials, work in progress, goods in transit, finished goods and spare stock. Their liabilities are made up of borrowings, employee’s end of service benefits and trade and other payables. I am happy to note they have depreciation and inventories in their financial statements. One thing that has really baffled me is the Statement of Cash Flow. They show the profit for the year before tax and then add in depreciation, amortisation and other items. I am confused why these items are in the statement of cash flow. They are not actual physical amounts are they? I know we are not touching on this financial report just yet but I would really like to understand it better.I am happy we received a different company to the one we had in ACCT11059 because it means I have the opportunity to research a new company instead of working with the same one. I enjoy the process of digging up information about my company. I am also happy I got Aluminium Bahrain and I was quite excited while I was researching this company. I even thought I wouldn’t mind working there and I had to stop myself from looking further so that I could concentrate on the other steps of this assignment, because I could have researched this company and its industry forever. I am enjoying this company a lot more than the one I had in ACCT11059 because I have been in the building industry for 14 years now and although every company is different, I felt Bellway was a lot of the same thing I do every day. Aluminium Bahrain is so far from what I know and what I am used to and I believe the challenge is why I feel so much more excited about this company. They seem to be very successful and proactive. The CEO, Tim Murry, quoted “Together if we Believe it, We Can Achieve it” in the 2016 Annual Report, which sums up what they are about and their strategy.Discussions with others in our unitMelissa De Rossi and I had a great discussion about our companies. One thing I realised from my discussion with Melissa is how dependant a lot of companies are on the currency of countries. A big drop in the currency of their country or the countries they trade in can make such a big difference in their expenses and profits. I had not though a lot about this before. I also wondered about some of the policies companies adopt and if they are genuinely interested in those policies or if they only implement them because it allows them to receive a reduction in their taxes, like in Melissa’s company A.G. Barr, or reducing emissions gives them a better rating, like in my company Aluminium Bahrain, or if they are genuinely worried about the health and environmental implications.Angela – BlueMelissa-GreyA G Barrs annual report looks like a very long advertisement. There are not many similarities I can see between them and Aluminium Bahrain. I feel like the annual reports for Aluminium Bahrain are much more straight forward and the format is superior. Our companies are so different - soft drinks and aluminium. The company I had for ACCT11059 was Monadelphous and it is somewhat similar. They are an Australian company providing engineering and maintenance services on a large scale. E.g. Infrastructure and mining. One thing I noticed that was similar to Monadelphous was the commitment to safety. Something you mentioned was the strong currency (BHD). A.G. Barr is located in the United Kingdom, and I found an article explaining that due to a drop in the value of the GBP, they would have to increase prices. They had already restructured and this was their next option. They are also tackling a new tax on sugar that will be implemented in 2018. They have been reducing the amount of sugar in their drinks, which brings the drinks into a lower tax bracket, meaning there will be a smaller increase in price. Is your company facing any challenges at the moment? I did see the reduced sugar in the annual report. I wonder if they are reducing the sugar because of taxes alone or if they are concerned about the health risks of consuming so much sugar. My company in ACCT11059 was a UK company, Bellway. They were a building company and I did enjoy researching them but I am very happy to have a different company this time round. I found Aluminium Bahrian so much more interesting (maybe because I work for a building company here in Bundaberg and something different is more challenging for me). I also found Alba's reports very straightforward and professional. I think AG Barr's reports look professional too but they are very much geared for the investor. I love the way Alba are so focused on their people and the community. They are facing a few challenges at the moment. The alumina and aluminium prices are very volatile and there is a big problem with the Chinese over producing. I think I preferred Monadelphous simply because it is an Australian company and is a little more familiar to me. In fact, they recently completed a water treatment plant at Bargara. (I'm from Bundy too.) Monadelphous was also impacted by China in regards to steel prices and demand for their products. It is interesting to see how two different companies from relatively different industries (yet somewhat connected) can be impacted by just one country. I am enjoying the fact that I have an overseas company this time simply because I want to expand my understanding into a more global perspective. Different currencies and regions, different regulations, etc. I think it will be easier to understand exactly what A.G. Barr does simply because they make and sell soft drink. It seems a little more basic than the multiple services that Monadelphous provides. Also, I like your outside the box thinking in regards to the reasons for reducing sugar in the soft drinks. Is it really just about profits or do they care about the health of those who consume the product. I also enjoy the difference an overseas company presents. I have lived in many countries and travelled a lot before I came to Australia so the country the company is in does not bother me. As long as the reports are in English! A G Barr's financial statements are nicely presented and easy to read. I think both our companies are very similar in that respect. The financial reports are to the point. They seem to be making a decent profit.I also had a great conversation with Makamas Silarat (Minty), on my blog, about the differences between our companies, which I have inserted below. Discussion with Minty on my blog. Hi Angela,wow what an effort. I love reading through your blog, very details which shows me how much effort you put into understanding your firm. I am very jealous because your firm looks so much more interesting than mine. The annual report is a lot more engaging and and fun to look at. My company is Cathay International Holding Ltd, which is a Hong Kong based investment company that has many subsidiary in the pharmaceutical industry. Another interesting point I have notice from reading your financial report is that it has emphasise on training and development of its staffs. However, my financial report doesn’t have many information regarding training and development of its staffs like most other firm’s statement. My financial report is mainly focusing on its performance review and its subsidiary. Please have a read through my blog and leave some feedback of what you know and don’t understand about my company. As well as if you would be able to answer some of the questions that I have for my Regards, Minty.Thank you Minty. I really did enjoy researching Aluminium Alba. I also noticed how much they focus on their staff and they believe that is why they are so successful. I am going to head over to your blog now and have a look at your company and we can compare them after I have had a look.AngelaHi Mintyfor some reason I can’t put a comment on your blog as it won’t let me publish my comment. We can discuss our companies here though.Pharmaceuticals, healthcare and hotels. A strange combination. Your company is interesting, I must say. The annual report is very long and not very exciting and they have a lot of information about the products and reasons why they are not performing well. If I was a stakeholder in this company, I guess that is information that I would want to know because the group of companies is showing a loss. They seem to think that they have spent what they have to and now things are going to start looking up for them. I hope they are right because I wonder how long they can keep losing money and still stay in business. I was shocked to see in the Income Statement that they spend 26% of their revenue on selling and distribution costs and another 24% on administrative expenses. Those two use up half their income! They do seem to have enough assets to cover their liabilities at this stage though. Another thing I noticed is that their retained earnings balance is -62 million. I am sure the shareholders would love this company to turn around soon and start making a profit.The main difference I noticed between your company annual report and mine is that my company is making a profit and things look a lot more positive. They are concentrating on how to improve something that is already working where your company seems like they are trying to explain themselves. What do you think?Hi Angela, I totally agree with you, Angela. What a wonderful analysis. There are many things that you have noticed but I have clearly missed. Thank you for pointing out some of their massive spending for my company. I have yet to understand why they have spend so much when they clearly are not making enough profits. Yet, the company are taking some actions in the hope to turn this trouble around. Such action is to dispose of some of shares the company holds, and other measures such as diversification strategy by expanding into other areas of pharmaceutical includes healthcare and cosmeceutical products, in the hope to mitigate the business risks and improve profitability. I am not too sure how effective is their strategy, because more products means more costs. But we just got to hope and see what this company can do. Pharmaceutical, healthcare and hotels is an odd combination, I wonder if that is part of their strategic plans or is it because they’ll just invest in whatever in the hope to make profits? What do you think?I have mentioned earlier that your annual report is so much more comprehensive and interesting. The company have reported about their training and development programs, safety health and environment, and corporate social responsibility. Which is very common in most company’s annual report, however in my company annual report there seem to be missing. Even for my last company, LogiCamms, I remember they also these specific information in their annual report. I wonder why that is? I feel as though Cathay is more focused on profits, investment and shares rather than management. Or perhaps, because is the head of the Group, so the management structure does not fall under the same principal. May be they all have a separate annual report?Your company seems to be making so much profit when comparing to mine. Your Gross profit is 82,379,000 BHD which equals to 218,333,182.65 USD. That’s a massive difference in comparison to my company when the gross profit is only just 57,282,000 USD. It is so interesting to learn more about different company, as well as hearing other people point of view. p.s I think I have fixed my blog so it should be find to comments.Love to hear more from you. Kind regards, Minty.Hi MintyI think Cathay need to do something to turn the company around. I would hope they are concentrating on the products they know they can make money out of in order to start making a profit. Then they can continue concentrating on other products that they may think will be profitable in the future. Maybe because they are running at a loss overall they think they need to concentrate more on profitability and products than on their employees and the community. You brought up some very interesting points above. Alba does seem to be doing very well. Their gross profit is down in 2016. In 2015 it was US$273 million and in 2016 it was US$218 million, the price of aluminium fell quite a bit in 2016. Cathay’s financial statements are fairly easy to read and they have been presented well for investors to understand what is going on in the company. They haven’t tried to put so much in to confuse interested parties. Are you happy with your firm or would you have preferred another firm?I am definitely happy with my firm because I get to see more on how international company actually operates. It is also very valuable to actually compare it with your company just to see where they have went wrong and what strategic plans they are looking at in order to reverse the situation back around.What about you? Are you happy with your firm?From what you said that the profit has gone down since 2015, so do you reckon that the reason for this is the drop in aluminium price alone or is there another factor that comes into play?Minty.Hi MintyI am very happy with my firm too. I think it is a very exciting industry and I love how they value their people so much and believe their success is largely due to their people. I do think the downturn in profit since 2015 has been mainly due to aluminium price. I think they know that because the price of aluminium is so volatile and their profit margins are quite small they have to produce volume to keep the profits up, and that is why they are expanding. It will be interesting to see their financial reports in the next few years because they are taking out huge loans to cover the expansion and their liabilities are going to be more than their assets for a while. I am thinking I may have a look at their annual report for a few years to see how it goes.AngelaWe are continually learning by discussing aspects of our company with others. Discussing with others brings to light the differences and similarities between companies. I had discussions with others who had companies in completely different industries but we could all compare our companies and they all had some similarities. It is amazing to realise that the majority of companies have very similar financial statements and as an accountant we will be able to make deductions about a variety of different companies from looking at their financial statements. I found my discussions with others very beneficial to my assignment and I did add things in and researched other areas in response to some of the discussions I had.STEP 4Practicing the recording processThis step was so much fun and disheartening at the same time. I have always kept a budget because finances have always been tight for us. My mother lives with us and she is completely financially dependent on us and we have two children who were in private schools but are now in university. I don’t have their university fees to pay as they have loans for that but I do have to support one at home with us and one in a different city because his degree is not available where we live. And of course I have my university fees to throw in the mix. In order for me to know how we are tracking and how we are going to afford all the bills, I have always maintained a budget spreadsheet for six months to a year in advance. This has been a great help to us, however I have never completed a month to month chart of accounts and income statement. I was shocked to see how much we are spending on certain areas and other areas were no surprise at all. I have fudged some of the figures for confidentiality, but I will definitely continue this practice on monthly bases to analyse our spending. I did find it difficult to get all the different accounts to add up to the total as I have quite a few transactions in my bank account every month. It was suggested by Rachelle Eastaway to colour code the accounts to make it easier to balance and I noticed Makamas Silrat also colour coded hers. I found, when I completed my own one after I did this exercise that if I have my Income Statement on the same page of the spreadsheet as the transactions I can see which ones I have included by clicking on the total amount for each account in the Income Statement because then all the items included are boxed in a different colour in the transactions.What is the chart of accounts so far as illustrated in this example? What is your own chart of accounts?The chart of accounts in the example is quite simple and straightforward. It is made up of the Revenue and Expenses. I am a little confused why the Revenue and Expenses are on top and the Assets, Liabilities and Equity are below but I assume it has been done this way because most of us will only utilise the Revenue and Expenses in our exercise. I guess it does not matter how your chart of accounts is set out as they do not have to abide by any regulations, and as long as you have all the accounting elements in there it should be done however it is easiest for the user. I have done mine the same way because I thought it would be a great exercise to do monthly, and I feel I am more likely to complete mine every month if I only have to tackle Revenue and Expenses in the beginning. I can then maybe add Assets, Liabilities and Equity at a later stage. My own chart of accounts is a little more detailed as I have broken my expenses down into more categories and I have also used sub-categories for my vehicle expenses and home loan expenses to show the different types of expenses in those categories. I will find it useful to know how much extra I am paying on my home loan and I will also find it useful to know how my vehicle expenses are split.What level of detail could you change in the chart of accounts shown in this activity? Why might you want to do this?I could, and I probably will, change a lot of detail in my chart of accounts as I go from month to month and see what I want to get out of it and what information I feel I need to be able to see. The chart of accounts shown in this activity could be expanded to show a greater level of detail. The account 1-2 Income - salary and wages could be split up to show individual family members income so that they could see how much revenue each person is bringing in and the account 2-6 General Living Expenses (food, fuel) could be split up into individual accounts for fuel, groceries, takeout and any other items lumped together with food. The two mobile telephones could have their own accounts so see the totals over a period of time and the different credit cards could be split up into individual accounts. It all depends on what information the user wants to know. I personally would like to leave the 1-2 Income – salary and wages lumped together because that individual information is not relevant to me. I would however like to have a more detailed breakdown on 2-6 General Living Expenses to know where the money is being spent and what areas need to be cut back on in order to reduce the expenses.How might you analyse your Income Statement? Has this exercise of recording your transactions through to the financial statements been useful for you? If so, why; if not, why not?The process of classifying my bank transactions and merging them into an Income Statement has enabled me to have a good look at the totals for the month for each account. I can see the percentages of expenses compared to income and analyse how this impacts my family and what we can do to change that impact. I can see from my Income Statement above that my home loan expenses are the biggest monthly expense, this is when adding my required payments and my extra payments. I thought my child expenses would be higher than my home loan expenses but that is not the case, although my child expenses are very high comprising 13.4% of our family income.The big shock for me was my insurance expenses. I pay my insurances monthly but I do have one car which I pay yearly and that one was paid in September, which made our insurance very high for this month. I may, in future, accrue the expenses I pay yearly so that we can get a clearer picture of our monthly expenditure. In saying that, as long as I am aware that we had a yearly bill in a certain account in that month, I can assess that and get an idea of how that impacts us. I was happy to see entertainment was only 0.8% of our monthly income. I will use this account to record anything we do that I class as unnecessary or indulgent, like eating out or buying unnecessary items, so that I can monitor these.I must admit I did enjoy completing this step and I will definitely be continuing it into the future. I can see the benefit of completing this monthly, and then yearly, to see where our income is being spent and to determine if and where we can make cutbacks to maximise our cash at bank balance and ultimately our equity. Completing this step was a bit of a shock to me and I think I will be making some changes in the future because of it. I am tempted to go back and do a monthly Income Statement for last year to see how we did so that I can have something to compare at the end of this year.STEP 5Creating a Trial Balance in a spreadsheet, using your company’s financial statementsCompleting the Trial Balance for Aluminium Bahrain was a relatively straightforward process for me. I am fortunate that Alba’s financial reports are easy to read and very clearly set out. There is a clear distinction between Assets, Equity and Liabilities in the Balance Sheet and the Revenue and Expenses are clearly defined in the Income Statement. There are no group statements and company statements shown, making it easier when trying to decipher the financial statements.I am proud to say that I completed the spreadsheet before watching the lecture. At first the Trial Balance would not balance and then I thought about the retained earnings and I thought about how the balance sheet has the retained earnings figure including the profit/loss for the year, therefore doubling up the Revenue and Expenses, and I realised I needed to take the Revenue and Expenses off the retained earnings figure in the Balance Sheet in order to reflect the profit/loss allocated at the end of year. This reinforced to me the fact that I understood the retained earnings process. I had questions in ACCT11059 about retained earnings and how it all linked together and I did some research back then which I think helped me in my understanding of this process. I understand that the Revenue and Expense accounts are temporary accounts which we use during the period to reflect the day to day operating activities in regards to sales, cost of sales and other income and expenses. At the end of the period we journal the Revenue and Expenses into a profit/loss account and then the balance remaining is journaled to retained earnings and the Revenue and Expense accounts start with a nil balance for the next period.When completing the trial balance I realised the full impact of the link between the statements and how the Income Statement is linked to the Statement of Changes in Equity by the retained earnings and how the Balance Sheet is linked to the Statement of Changes in Equity by the retained earnings and any other accounts that are closed off at the end of a period. The Statement of Changes in Equity seems to be the middle man here. I am eager to learn more about the Statement of Cash Flow and how it relates because that is one statement we have not touched on yet and I do not understand how it ties into the other statements.I did not have to look too closely at the Statement of Changes in Equity when completing my trial balance as I did not have any other comprehensive income in my Income Statement. I did note that the retained earnings carried forward from 2015 was BD731,698,000 and my figure for the retained earnings in the trial balance was BD731,423,000. The difference was BD275,000, which was loss on resale of treasure shares (BD287,000) and excess of final dividend for 2015 reversed BD12,000. These were both closed off to retained earnings. I did not record these in my spreadsheet as they were not listed in the Income Statement. I do, however, understand why my retained earnings on my trial balance does not match my retained earnings brought forward from 2015 and this was because of the (BD287,000) and BD12,000 relating to capital contributions and dividends. When I took the total for retained earnings as shown on my Balance Sheet and added my revenue minus my expenses as per my Income Statement the difference was exactly my profit amount and I was happy with this.Discussions with others in our unitAfter discussions with others in the unit and after reading other students assignments, I have come to the realisation that financial statements can be quite different. While they all relay the same type of information they have a variety of different ways to do this. You can have two completely different types of companies and their financial statements can look quite similar and then you can have two companies that do the same thing and their financial statements can be quite different. One thing they all have in common is that the Revenue and Expenses are always closed off to the Retained Earnings in the Equity of the Balance Sheet via the profit/loss account.My discussion with Melissa De Rossi about completing the trial balance is below.Angela – BlueMelissa-Grey. How did you go with step 5? I enjoyed step 5 and found the excel part pretty straightforward. I did learn a lot about how the different financial statements link together. What about you? I have never done a trial balance before so that was new to me. I complete the accounts up to trial balance at work but have never taken too much notice of the trial balance and what it represents. I will be taking more notice from now on. I found the excel part mostly straight forward. The only bit that I had to think a bit about was where the other comprehensive income items closed off into. Afterwards one of the equity items ended up in a negative debit, so I ended up converting it into the credit column. I found it fascinating how the statements linked. Income and CI into equity, and then into the balance sheet. It really made me understand that you need all of them to understand the big picture. It was definitely a new experience for me and I quite enjoyed the number crunching. Alba doesn’t have any other comprehensive income, lucky me. I also found it enjoyable. It has confirmed for me that I am going to enjoy accounting. Me too! Thanks for the chat Melissa, it's been great. I have to get up at 4am so I should finish off now. I will look out for your draft and complete a feedback form for you as I have already read some of your assignment and looked at your annual report. Good luck with the rest and will chat again soon. Thank you, you too. I will do the same for yours. Melissa and I did not have too many complications when completing the trial balance spreadsheet. We did confirm our love of number crunching and spreadsheets and the fact that we both think we will enjoy our accounting careers! I did not gain much from my discussion about this step but I did however gain a lot of insight when I helped others with this step. When looking at other students financial statements and trying to see how they fitted into the trial balance I learned a lot more about the other comprehensive income and how it links in with the statement of changes in equity. Shayla Sheen’s company, The Card Factory, had other comprehensive income that was closed off to hedging reserve in the statement of changes in equity so she had to reverse the closing off of the hedging reserve as well as the retained earnings. There was also a large amount of dividend payments closed off to retained earnings which made her reversed closing off to retained earnings a minus amount. I have discussed this in my feedback below.STEP 6FeedbackFeedback I gave to others in the unitThis is one area I really struggled with in ACCT11059. I discussed in my assignments in that unit about how I felt in the beginning and that I thought I didn’t have anything of value to add for other people. I believe this was mainly because I did not have very much confidence in myself. I have thoroughly enjoyed providing feedback this time. I have gained so much information and knowledge from reading other student’s assignments and I feel I have made a difference for others in the unit by helping them in the areas I am comfortable with. Reading an assignment with the sole intention of giving feedback makes you read the content more thoroughly and critically which helps in your own learning process. I have come to value this process and I know it will be very beneficial to me throughout my degree. Rachelle Eastaway was having some trouble with her step 5 spreadsheet. She posted it in the forum and on facebook and I had a look and helped her out with a few little mistakes she had made. Her response was priceless;Thank you Thank you Thank you! I owe you one! it makes so much more sense now, i made so many little mistakes and it overall just created one big error. Thank you again, if you need me to have a look over your draft or anything please do not hesitate to send it through.?Kind regards,?Rachelle :)?I also helped out Makamas Silarat with some problems she was having and her response is below.Hi Angela,?thank you so much for your help!! I cannot thank you enough. I've been struggling with step 5 for so long and I thought I should ask an expert like you and you've really pulled me out of a black hole. Thank you for getting back to me so fast, I really didn't expect that. I have posted my draft on the forum if you could provide me some feedback and I will do the same for you as well. Thank you a million time!!!You legend!Minty.?Helping others is so rewarding and I find I learn better that way. In helping Rachelle and Minty I gained a better understanding of how the statements link together and the different ways the statements are presented because their financial statements were a little different to mine, and therefore it was not a repeat exercise but rather a new exercise for me.Giving feedback to Rachelle I learned about underlying and non-underlying items. My understanding is that non-underlying are those items that are one-offs and underlying are items in the normal trading activities. I also learned, from helping Shayla Sheen in her step 5 that I had no idea what to do with the retained earnings in the trial balance when it became a negative after you took the profit away from the retained earnings. I assume it needed to go into the debit column, to show it is a negative, but that one stumped me. I helped Shayla as much as I could but she did not respond so I hope she got it confirmed in the end. My feedback to Shayla is below.PEER FEEDBACK SHEET: Assignment Steps 3-5Feedback From: Angela EngelbrechtFeedback To: Shayla SheenMy CommentsStep 5Trial balanceDiscussionIncome Statement ColumnsYou need to type the figures in here, not link them to the trial balance column. We don’t use negatives in a trial balance. Simply entering the amounts in the opposite column (credits for assets and expenses and debits for equity, revenue an liabilities) automatically gives it a negative amount so you can take out the negatives. We also do not need currency in the spreadsheet as the currency is already noted at the top of the column. You need to use the 2017 total, not the 2017 underlying amount. You also need to add your other comprehensive income at the bottom of your income statement columns; these are on the financial statement page titled Consolidated Statement of Comprehensive Income. There are three figures in there. Your profit for your income statement (credits – debits) should = ?64.6m which is your total comprehensive income for the period.Balance Sheet ColumnsYou need to type the figures in here too, not link them. All you need to do here is move your Reverse Acquisition Reserve from the credit column to the debit column and get rid of the negative (moving it to the debit column shows it is a negative because a decrease in equity is a debit). It should balance now if you sum your totals in these columns.Trial Balance ColumnsYou need to link all the amounts in these columns with the amounts in the Income Statement and Balance Sheet columns. Your trial balance should then be out by the amount of your profit of ?64.6m. You then need to sum the difference between your revenue and expenses and take this away from your retained earnings to counteract for the revenue and expenses also being in these columns and your other comprehensive income needs to be taken away from your hedging reserve as is shown in the statement of equity. Maria has a great step by step video tutorial in week 4 on how to do this. Once you have completed this your trial balance should balance. One thing I don’t know about is once this is completed your retained earnings will be a negative because there is a large amount paid out to dividends. I am not sure if you need to transfer this amount over to the debit column or not. Maybe you can ask Maria or others in the unit about this.Let me know if you need further explanation. Hope this helps. Good luck!PEER FEEDBACK SHEET: Assignment Steps 3-5Feedback From: Angela EngelbrechtFeedback To: Makamas Silarat (Minty)My CommentsStep 3Background information of companyComments/KCQsDiscussion with othersFantastic background information on your company. You have explained in great detail who your company is, what they do and your thoughts on your company. I think your background information is very well done.Just a few suggestions below:I would include a link to your blog as the marker will want to have a look at your blog.You have included a link to the company annual report but it doesn’t want to open for me. Check your document and make sure it opens for you or provide a link your blog post where the annual report is. All the other links in your document are working correctly.On page 5 in the middle paragraph you have quoted from the annual report and I suggest you put the quote in inverted commas to show that it is a quote. However, the Group have also reported that “the company is beginning to see the benefits of our diversification strategy from pharmaceutical to include healthcare and cosmeceutical products, which mitigate our business risks and improve profitability.”I believe the discussion you had with others about your companies should go at the end of step 3 as it is a requirement of this step, not of step 4. You have a great section about discussing with others and how those discussions have impacted you. You have given me some ideas here for my assignment, thank you!Step 4The recording processYour discussion in this area is very good and your spreadsheet looks correctly linked and well presented.Great idea with the colour coding. When you have more transactions it is a nice idea so ensure you balance.You have answered all the questions and have given a good description of your processes in this step.On the bottom of page 6 you have written car legislation instead of car registration Step 5Trial balanceDiscussionErrors pre-draft stageIncome StatementRevenue - Your revenue figure is incorrect and you are missing “Share of post-tax profit of associate”.Expenses – You are missing the “Income tax expense” and you have two other lines that should not be there. One is a header line (totals of the figures above) and the other is showing totals of the profit/loss attributable to the owner of parent which is a total only and should not be there.Other Comprehensive Income – You have the last two lines debits and credits in the wrong columns.Balance SheetAssets – You are missing “Prepaid land lease payment” (there are two of these in the assets).Liabilities – These are correct.Equity – You have a “Retained Earnings” but your company has “Profit and loss account”. You can delete the retained earnings line and insert profit and loss account. Your “Foreign exchange reserve” you have as a credit but it should be a debit as it is a negative amount. Your “Profit and loss account” sum, because it is a loss, should add all the debits and minus all the credits to take away the profits from the profit and loss account as the revenue and expenses are already accounted for in the list.I have included a spreadsheet with this, if you have any questions about these please let me know. You also may want to get a second opinion as I am no expert Post draft stageYou have fixed all the errors in your trial balance and everything looks like it has been linked correctly and it all balances. Yay! Just one thig, I would go through the spreadsheet and make sure the lines are all the same as it is not all matching up at the moment, especially at the bottom. It helps with presentation if it is neat.Your honesty in your discussion was so nice to read and you made me laugh. Helping each other in this unit is part of our learning process and I learned from helping you too, so you are correct in saying never be too afraid to ask for help.Maybe provide a link to the discussion where you asked me for help on my blog at the end of this step.OverallOverall I think you have a fantastic assignment here. I suggest you read through your assignment and have a look for small errors in the wording, but I do realise that English is not your first language and I think your effort is excellent.Well done!PEER FEEDBACK SHEET: Assignment Steps 3-5Feedback From: Angela EngelbrechtFeedback To: Rachelle EastawayMy CommentsStep 3Background information of companyComments/KCQsDiscussion with othersRachelle the background information you have written for your company is great. You have given us a really nice summary of how the company started and how they got to where they are today. Well done! I didn’t see anything on any challenges your company may be facing. Do they have any?On page 2 in the second paragraph you say “However, with research I found that non-underlying and underlying were never seen before items that the director considers not related to the trading activities of the company.” Should underlying be deleted here? My understanding is that non-underlying are those items that are one-offs and underlying are items in the normal trading activities. I notice a few people have these but I have not had them in any of my companies.I would also add a link to your company’s annual reports in your word document to make it easier for the reader to locate them.You mention some figures from the balance sheet on page 7 in the last paragraph “in 2015 their total equity and liabilities was ?282619 and in 2016 it was ?320737.” You should mention that is in thousands of pounds as the financial statements are in ?000sYou have some great media links. I love the video. Maybe you could expand a little on the acquisition of the other company and how it has affected Alliance Pharma. This seems to have had a huge impact on the company.You have a link to the facebook group but not to any specific discussions you have had. Maybe you can link to your specific discussions to make it easier for the marker to see your specific discussion.Step 4The recording processI love your description of your recording process. Your honesty is refreshing. I am able to download the transactions from my bank onto a spreadsheet; you should try and find out if your bank does that. Unfortunately, I don’t think there is any other way to classify them except manually. If you find a way please let me know . Your idea to colour code is brilliant and I did that in my own separate spreadsheet, which I am going to continue with, because I also found it quite hard to balance the different accounts when you have a large amount of transactions in each month.You have answered all the required questions in this step and you have clearly shown your thought process and understanding of the material.It looks like you have linked everything correctly and your spreadsheet looks nice. I noticed you worked out your percentages of expenses on your total expenses and not your income. I found this interesting as I like to see how much I have spent in comparison to my income. This just reinforces the fact that everyone likes to know different information from their financial statements and the reason we tailer them to suit ourselves. Step 5Trial balanceDiscussionYour trial balance looks great and it all balances. It looks like you have done this correctly.The only thing I can comment on here is that there are some areas in the spreadsheet where the formatting is not the same. The lines are different and do not match up with the rest of the spreadsheet. I would have a look over the formatting and neaten it up.I would read over this step and take note of your grammar as some sentences are just a little unclear but I can still understand what you are trying to say.You outlined your process and your difficulties well. I think you could expand a little on your understanding of how the statements are linked; otherwise this step is really good.I clicked on the link and it didn’t work for me. Maybe have a look and see if it does the same for you.OverallRachelle, I think you have done a very good job overall in this part of the assignment. Your presentation is very good and you have relayed your thoughts very clearly. With a little tweaking I think you have an excellent assignment. Thank you so much for the excellent feedback you gave me and I wish you well with your marks PEER FEEDBACK SHEET: Assignment Steps 3-5Feedback From: Angela EngelbrechtFeedback To: Melissa De RossiMy CommentsStep 3Background information of companyComments/KCQsDiscussion with othersI thought your background information was great. I like the history you provided about your company because it helps to understand where the company comes from and how they came to be where they are today.I love the way you have inserted the logo. It looks really good.If I were to add anything I might think of listing some of the products A.G. Barr manufacture and sell to give us a better sense of identification with the company.A.G. Barr has a very exciting website and the links you added are excellent. I love the Scottish accent. There is one link to an article in The Telegraph which would not open for me, maybe you could check and make sure it is working your end.I would also include a link to your blog and A.G. Barr website and annual reports to make it easier for the marker.You have packed in a lot of information about your company, their financial reports and comparisons with other companies. You have also included discussions with other students which is great. Maybe a little more information about their financial reports and some figures would be good, like a comparison between the last 4 years of income and profit, something like that.I believe you have covered all the assignment criteria and I thoroughly enjoyed reading what you have written about your company.Step 4The recording processYou seem to have had no trouble with the recording process. You have linked your figures and it all looks correct to me.I loved reading your thoughts on your process of looking at your personal finances and producing your financial statements, especially the last chapter where you related it to being a smaller version of how businesses work. I think your explanation of this was very informative and showed your understanding of the process a business goes through to produce their financial statements.The only think I can think of that may improve this step is to clearly define your answers to the three questions, a, b and c. I can see that you have answered all of them and it works this way but you may consider defining them.Step 5Trial balanceDiscussionHere again you don’t seem to have had any trouble with the process of entering your trial balance. It looks to me like you have linked the trial balance figures with the income statement and balance sheet figures. It looks to me like you have calculated your retained earnings in the trial balance correctly and it all balances, yay!I can see by your write up of step 5 that you have a good understanding of the trial balance process.Well done for attempting a balance sheet. I think I may have a crack at this myself after seeing yours!OverallMelissa, I think overall you have a great assignment here. It is well written and it clearly shows your understanding of the material. Well done!Feedback I received from others in the unitAs you can see, I received very valuable feedback from other students. I reviewed my assignment with this feedback in mind and change quite a few things before submitting my final draft. I am very grateful for the feedback and conversations I had with others in the unit.Feedback From: Rachelle Eastaway Feedback To: Angela EngelbrechtMy CommentsStep 3Background information on company Comments/KCQsDiscussion with othersOutstanding! Your background information was very informative and the pictures just make it more engaging for the reader. I feel as if I really know Aluminium Bahrain and how they operate internally. I also am inspired by how much detail you have given about the media articles you found on your company and it has made me re-think how much detail I put into my own assignment for this section. The only suggestion I have is to see if you could find a video on your company’s operations and add that in as well if you like. The only other feedback I have is to perhaps add more of your feelings and thoughts in on the company. It is in your assignment but I just thought more is always better Another point, and you have already noted yourself, is just not to forget to put in your discussion with others on your step 3. Step 4The recording processAwesome work! Loved the layout of this section in excel and the word document. Couple of suggestions would be, to perhaps colour code your chart of accounts to make it easier for you to read when recording the data into the profit and loss statement. Also perhaps add in to your discussion about any parts of this step you had trouble with and if not then explain why? Was it due to your thorough understanding of accounting or was it that you had completed this process before?Step 5 Trial balance DiscussionNice work! Great discussion, really gave the reader an insight into how you handled this step and what you learned. Overall your Trial balance looks awesome and with it balancing overall means it is correct. Only point I could suggest is you have a large space between revenue and expenses if you want, you could delete a couple of rows for layout purposes. OverallOverall, awesome job! The layout of your assignment so far is beautiful and is very reader friendly. Just ensure that paragraph and line spacing are all correct for final submission. Good luck Peer Feedback SheetFeedback to: Angela EngelbrechtFeedback From: Teena Hedgecock S0038974My CommentsStep 3Background information of companyComments/KCQsDiscussion with othersYou have provided vital information and knowledge of your company. It is very informative and easy to read. Your picture and links assist in further understanding your company Aluminum Bahrain. Your layout and structure were clear and professional. I love your honesty at being overwhelmed with your company and location. I too was overwhelmed at the start but once I looked further into the company I really enjoyed mine. Your key KCQ’s were clearly discussed and you thoroughly described your company’s annual reports. The only thing I could suggest, like myself, you may like to have discussions with other students and compare companies. I completely understand how this may be hard.Step 4The recording processThis step has been well written. Really like your layout. It is clear, easy to read, professional and have drawn good conclusions to where your money is being spent.Excellent and easy to read.One thing, you could discuss and concerns or parts you did or did not have trouble with. Really enjoyable to read.Step 5Trial balanceDiscussionIt is good to see you had little concerns in this step. We are so different. Where you have total understanding and knowledge, I struggled and found it extremely difficult.I love your honesty and discussion regarding the links between different reports. You have again discussed in detail your knowledge and understanding of the trail balance and how you have arrived at your results. An absolute pleasure to read. I have struggled with this step and it has assisted me in where I have gone wrong.OverallYou have shown vast knowledge and discussion through out your assignment. It has been set out perfectly. Magnificent work.Best of luck with the remainder of your assignment.PEER FEEDBACK SHEET: Assignment Steps 3-5Feedback From: Makamas Silarat Feedback To: Angela EngelbrechtMy CommentsStep 3Background information of companyComments/KCQsDiscussion with othersWow! What a fantastic effort. I love reading your work, it is so detailed and very informative. This tells me is tat accounting is probably something that you enjoy. You have put a lot of effort into writing this part, and a very thorough analysis of your company’s annual report. Very well done! The only thing that I’d like to see more of is perhaps some of the questions that you may have while learning more about the company’s annual report.Step 4The recording processStep 4 is very well written. I can relate to you because I also have to manage my expenses, however because my mum pays for most of things in the house and I just contribute my part in to help them. It is very interesting to see how other people manage their own finance. It can become quite personal when reading through this task, however I can also a lot about accounting and most importantly the practical side of managing our financial situations. Besides, you can also tell a lot about the person from looking at their income statement. For example, I can tell that you are very organise, pays attention to details and careful with your spending. Step 5Trial balanceDiscussionReading this part makes me feel sad, mainly because I didn’t find it as straightforward as you did. Haha but well done for that. Nice analysis and very detailed!OverallAwesome job, nothing to fault. Overall, perfect assignment. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download