Question: Organizing Information BelleCo Case Study Backgrou... Organizing Information BelleCo Case Study Background Belle has been managing a small company making signs for the last five years. The company has grown significantly in this time. The company has purchased numerous assets, expanded the number of products, generated new markets, and has consistently found new customer bases. When Belle started the company she maintained a ledger with most of her transactions, and this was sufficient for her to get an impression of how the company was doing, or so she thought. She had several friends that also ran their own businesses, and all of them were basically using similar systems. More recently, however, Belle has become concerned about her finances. Whether it is due to the growth of the company, changing economic conditions, or for some other reason, she has begun to feel that she does not have a grip on what is going on in her business. She took a class to try and help her with her finances and she has come to the realization that she needs to apply some of the principles that she has learned in graduate school to get a better understanding of financial state. Her first undertaking has been to compile information from her ledger and other sources. Information Belles first undertaking was to take stock of everything that her company (she) had at its disposal. She was surprised at how much she had invested in the company given that she basically started out with nothing five years ago. She went through her old bank statements and found that her cash had increased over the years, which she thought was good news. She did the same for her inventories. Collecting the information for her raw materials, packaging, and finished goods that she had in her warehouse, she came up with the following summary table: 1 2 3 4 5 Cash $9,586.10 $23,374.98 $37,963.65 $30,994.39 $51,953.46 Inventory $28,000.00 $56,000.00 $84,000.00 $112,000.00 $96,000.00 From her tax accountant she learned that she depreciated her assets according to the MACRS. Her building and land ($400,000) on a 40-year MACRS real property schedule. This is very similar to a linear depreciation over the same time period years. Her manufacturing equipment ($260,000) has a depreciable life of 7 years and her delivery vehicle ($35,000) is depreciated based on a 3-year schedule. Two years ago she invested in an expansion to her equipment valued at $130,000, which is depreciable on a 7-year schedule. She has also invested in computers, automation equipment and office furniture over the years. According to her accountant the value for these items is: Value 1 2 3 4 5 Other Items $2,000.00 $3,500.00 $4,700.00 $5,200.00 $5,000.00 These items will depreciate on a 3 years MACRS. Surprised at the values that she was finding, she decided to dig through her ledger and other notes. She found that her transactions had increased greatly and all told, just the amount of money that she owed for operational expenses and COGS that she had already ordered or received was a lot more than she had thought. Going through her notes she also started adding up the amounts that customers owed her for goods that she had already delivered. Accounts 1 2 3 4 5 Receivable $2,400.00 $2,600.00 $3,800.00 $5,400.00 $9,800.00 Payable $10,000.00 $12,000.00 $15,000.00 $15,500.00 $17,000.00 She called her bank, and they were able to provide her with a detailed breakdown of her debt and line of credit. Belle had been very nervous to borrow money, but it had become necessary to purchase her present equipment. Five years ago, she had borrowed $500,000, at 4% interest repayable over 10 years. She also invested from her retirement savings. She used this money to purchase land and a building in which to set up her new manufacturing equipment. She also bought a delivery van; her station wagon not being big enough or for that matter reliable enough for the business. According to the bank, she also had a line of credit, which was opened three years ago, that presently stood at $50,000 and had balances in the preceding years of $50,000 and $70,000. The interest on the line of credit is 6.5%. There is no principle included in the required payment. Information on Operations BelleCo has shown strong growth in its sales. In the first year of operation, it sold $200,000. Since then, it has steadily grown by about 21% per year. Belle expected this growth as a start-up company in an untapped market. She hopes that she can maintain this growth for several more years before the market flattens out. Belle compiled some further information based on her operation. She found that the raw materials and other direct costs that go into the production of her product had increased over the last five years. Similarly, her sales expenses and management and administration costs have increased. Belle summarizes these costs. 1 2 3 4 5 Direct $93,000.00 $115,000.00 $146,300.00 $174,579.00 $195,340.00 Sales Exp. $15,987.00 $20,458.00 $23,390.00 $27,489.00 $29,458.00 G&A $23,456.00 $31,345.00 $39,876.00 $48,767.00 $63,254.00 From the accountant, Belle was also told that her tax rate is 29%. Analysis Belle hopes that she will gain insight into her company by organizing and structuring all this information. She would like to start by putting together a standard set of financial statements and then analyze those statements to see trends and help determine how her company is really doing.