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, entered new markets, and has consistently expanded their customer base. 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 ledgers. More recently, however, Belle has become concerned about her finances. Whether it is due to the growth of the company or changing economic conditions she has begun to feel that she does not have a good understanding of how well her business is doing. 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 BelleCos financial state. Her first undertaking is to compile information from her ledgers. Information Belle realized the need to take stock of everything that her company 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: YR 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 utilizing MACRS. Her building and land ($400,000) is depreciated on a 39-year MACRS nonresidential real property schedule. Her manufacturing equipment ($260,000) has a recovery period 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 each year are: YR 1 2 3 4 5 Other Items $2,000.00 $3,500.00 $4,700.00 $5,200.00 $5,000.00 These miscellaneous items will depreciate on a 3 year MACRS. Surprised at the values that she was finding, she decided to dig deeper through her ledger and other notes. She found that her transactions had increased greatly, and all told, 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. 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 (first year). 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 (COGS) 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. YR 1 2 3 4 5 COGS $93,000.00 $115,000.00 $146,300.00 $174,579.00 $195,340.00 Sales Expenses $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/Rubric Belle hopes that she will gain insight into her company by organizing and structuring all this information. 1) She would like to start by putting together a standard set of financial statements [50 pts] a. Develop the Amortization Table b. Develop all Depreciation Tables and summarize data into a single table that covers all five years c. Develop (that covers all five years): i. Balance Sheet ii. Income Statement iii. Cash Flow Statement 2) Analyze the financial statements: [50 pts] a. Identify at least three trends and describe the financial impacts of each trend in 50 words or less? [recommend common size] b. Describe how the company is doing? Does the future look bright for BellCo? Why or why not? (must use 200+ words) c. Based on your findings above, provide at least two recommendations for Belle that you believe will improve profitability. For each recommendation, explain how they would improve profitability in 50 words or less.