1. Background You have been employed as financial controller from 1.12.2021 of a small family-owned company....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Background You have been employed as financial controller from 1.12.2021 of a small family-owned company. In the past there has really been no financial management but now that the founder's daughter took over as CEO she wants proper procedures and reports. The company has a board of directors with three external board members plus two representatives of the owning family. The company imports electronic equipment from South Korea and Japan and sells that to distributors. There are no retail sales of the products directly to customers, but there is a service department selling spare parts online to consumers and repair shops. The company is organized into three divisions: Audio (2 salespersons), Video (1 salesperson) and Spares (1 salesperson). The purchasing is done by one person and you are in administration. The CEO is also a full-time employee. Business is going acceptably but there is a slight concern that the brands represented may not be at the spearhead of technology. The CEO is actively looking for new brands to sell, but that is likely to have an effect in 2024, earliest. Liquidity has been poor during the last year. 2. Numerical data The income statement and balance sheet for 2021 and 2022 (forecast) can be found below. The company has prepared no operating budget nor any cash flow budgets in the past. Arcada Imports Ltd Financial Information 000 of euros 2021 2022 INCOME STATEMENT Sales 2087 2096 Cost of goods sold - 1461 - 1467 Gross profit 626 629 Payroll costs Other Operating expenses Depreciation Interest expense - 317 - 297 - 117 - 137 - 125 - 125 - 83 - 79 Profit before tax - 9 Income taxes Net profit BALANCE SHEET - 16 1 17 - 2021 - 9 2022 2. Numerical data The income statement and balance sheet for 2021 and 2022 (forecast) can be found below. The company has prepared no operating budget nor any cash flow budgets in the past. Arcada Imports Ltd Financial Information 000 of euros 2021 2022 INCOME STATEMENT Sales 2087 2096 Cost of goods sold - 1461 - 1467 Gross profit 626 629 Payroll costs Other Operating expenses Depreciation Interest expense - 317 - 297 - 117 - 137 - 125 - 125 - 83 - 79 Profit before tax - 9 Income taxes Net profit BALANCE SHEET - 16 1 17 - 2021 - 9 2022 BALANCE SHEET 2021 2022 ASSETS Office equipment 500 375 Annual depreciation 125 Goods for sale in inventory 876 937 Spare parts in inventory 158 212 Acc. Receivables 442 458 Prepaid expenses 132 77 Cash equivalent 152 41 2260 2100 LIABILITIES Share capital 100 100 Retained earning 69 59 Long-term loans 1500 1300 Annual amortization 200 Acc. Payable 390 440 Accrued expenses 113 89 Other short-term debt 88 112 2260 2100 2022 Sales in 000 of Audio Video Spares Total January 100 79 13 192 February 113 78 9 200 March 107 74 11 192 April 111 92 7 210 May 109 67 9 185 June 77 52 July 0 0 August 36 22 September 85 72 October 112 78 November 121 98 December 135 138 1106 850 24227214 13 142 4 18 76 179 197 19 238 8 281 2096 3. The budget Your first task is to prepare a master budget (operating budget, balance sheet and cash flow budget) for 2022. The budget may of course be partly based on the figures from previous years but all budget numbers and underlying assumptions must be briefly discussed and documented. Where you lack data for the budget, carry out research and try to come up with sensible numbers that you can explain. Be sure to include recommendations and action points in the documentation, if you come up with any. 4. The proposed financial report Secondly, prepare a proposal for a financial report for the company, in particular the Board. Prepare a template (a model) of the January 2022 monthly financial report, using January 2022 budget data, leaving the actual outcomes blank. Remember to include all relevant financial and non-financial information, but without drowning the reader in details. The report must give the Board all necessary information for evaluating the performance of the company. 5. Grading notes The assignment gives a maximum of 40 points as follows: - documented budget assumptions with discussion and explanations 8p - a sensible and realistic operating budget 8p - a balance sheet that balances and ties in with the other parts 8p - a realistic monthly cash flow budget that ties in with the others 8p - reporting structure and template 8p Please note that Excels that are incomprehensible (impossible for me to understand) will get no points! Late submissions will get o points. 1. Background You have been employed as financial controller from 1.12.2021 of a small family-owned company. In the past there has really been no financial management but now that the founder's daughter took over as CEO she wants proper procedures and reports. The company has a board of directors with three external board members plus two representatives of the owning family. The company imports electronic equipment from South Korea and Japan and sells that to distributors. There are no retail sales of the products directly to customers, but there is a service department selling spare parts online to consumers and repair shops. The company is organized into three divisions: Audio (2 salespersons), Video (1 salesperson) and Spares (1 salesperson). The purchasing is done by one person and you are in administration. The CEO is also a full-time employee. Business is going acceptably but there is a slight concern that the brands represented may not be at the spearhead of technology. The CEO is actively looking for new brands to sell, but that is likely to have an effect in 2024, earliest. Liquidity has been poor during the last year. 2. Numerical data The income statement and balance sheet for 2021 and 2022 (forecast) can be found below. The company has prepared no operating budget nor any cash flow budgets in the past. Arcada Imports Ltd Financial Information 000 of euros 2021 2022 INCOME STATEMENT Sales 2087 2096 Cost of goods sold - 1461 - 1467 Gross profit 626 629 Payroll costs Other Operating expenses Depreciation Interest expense - 317 - 297 - 117 - 137 - 125 - 125 - 83 - 79 Profit before tax - 9 Income taxes Net profit BALANCE SHEET - 16 1 17 - 2021 - 9 2022 2. Numerical data The income statement and balance sheet for 2021 and 2022 (forecast) can be found below. The company has prepared no operating budget nor any cash flow budgets in the past. Arcada Imports Ltd Financial Information 000 of euros 2021 2022 INCOME STATEMENT Sales 2087 2096 Cost of goods sold - 1461 - 1467 Gross profit 626 629 Payroll costs Other Operating expenses Depreciation Interest expense - 317 - 297 - 117 - 137 - 125 - 125 - 83 - 79 Profit before tax - 9 Income taxes Net profit BALANCE SHEET - 16 1 17 - 2021 - 9 2022 BALANCE SHEET 2021 2022 ASSETS Office equipment 500 375 Annual depreciation 125 Goods for sale in inventory 876 937 Spare parts in inventory 158 212 Acc. Receivables 442 458 Prepaid expenses 132 77 Cash equivalent 152 41 2260 2100 LIABILITIES Share capital 100 100 Retained earning 69 59 Long-term loans 1500 1300 Annual amortization 200 Acc. Payable 390 440 Accrued expenses 113 89 Other short-term debt 88 112 2260 2100 2022 Sales in 000 of Audio Video Spares Total January 100 79 13 192 February 113 78 9 200 March 107 74 11 192 April 111 92 7 210 May 109 67 9 185 June 77 52 July 0 0 August 36 22 September 85 72 October 112 78 November 121 98 December 135 138 1106 850 24227214 13 142 4 18 76 179 197 19 238 8 281 2096 3. The budget Your first task is to prepare a master budget (operating budget, balance sheet and cash flow budget) for 2022. The budget may of course be partly based on the figures from previous years but all budget numbers and underlying assumptions must be briefly discussed and documented. Where you lack data for the budget, carry out research and try to come up with sensible numbers that you can explain. Be sure to include recommendations and action points in the documentation, if you come up with any. 4. The proposed financial report Secondly, prepare a proposal for a financial report for the company, in particular the Board. Prepare a template (a model) of the January 2022 monthly financial report, using January 2022 budget data, leaving the actual outcomes blank. Remember to include all relevant financial and non-financial information, but without drowning the reader in details. The report must give the Board all necessary information for evaluating the performance of the company. 5. Grading notes The assignment gives a maximum of 40 points as follows: - documented budget assumptions with discussion and explanations 8p - a sensible and realistic operating budget 8p - a balance sheet that balances and ties in with the other parts 8p - a realistic monthly cash flow budget that ties in with the others 8p - reporting structure and template 8p Please note that Excels that are incomprehensible (impossible for me to understand) will get no points! Late submissions will get o points.
Expert Answer:
Related Book For
Auditing Cases An Interactive Learning Approach
ISBN: 978-0132423502
4th Edition
Authors: Steven M Glover, Douglas F Prawitt
Posted Date:
Students also viewed these accounting questions
-
Never mind computers and tech services. IBM's radical new focus is on revamping customers' operations -- and even running them It was over a lunch in Cincinnati two years ago that IBM Chief Executive...
-
Angela Monterey has a five-year car loan for a Jeep Wrangler at an annual interest rate of 6.7% and a monthly payment of $609.50. After 3 years, Angela decides to buy a new car. What is Angela's loan...
-
Consider the curve a. Show that the curve lies on a sphere centered at the origin. b. Where does the tangent line at t = 1/4 intersect the xz-plane? r(t) = 2r i+ V7j+ V9- 7- 4 k, 0 s=.
-
Dennis Wallace was a deputy sheriff for Stanislaus County, California, when he injured his left knee. After surgery, he was subject to limits on prolonged standing, walking, and running. The county...
-
Why is monitoring and information disclosure critical for the success of emissions banking and trading?
-
The following units of a particular item were available for sale during the calendar year: The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of...
-
N 5 6 Adjustments 1. The equipment was used for the third year. 2. Prepaid insurance was adjusted for Oct-Dec usage. 3. Unearned revenue was updated to show 3 months of work completed. 4. A final...
-
To: [Your name] From: Supervising Attorney Re: Eldridge v. Eldridge; modification of child support We represent Gwen Eldridge in the case of Eldridge v. Eldridge. The Eldridgeswere divorced in 2010....
-
Find the values of all labeled voltages, state and verify the transistors mode of operation, the MOS transistors are identical, and their parameters are: K=2mA/V, V-1V, =0. (Note: the two circuits...
-
Does the approach taken to production scheduling differ by industry or by production process type in use? If so , explain how and why this is the case.
-
If a pixel is the basic building A Shock-mount is used with a microphone to aid is isolating the mic from: Question 3 options: Unwanted reflections Wind noise Environmental noise Mechanical/handling...
-
1. Suppose a mass weighing 10 lb stretches a spring 2 inches. If the mass is displaced an additional 2 in and is then set in motion with an initial upward velocity of 1 ft/s, determine the position...
-
Direct materials Fixed manufacturing overhead costs Sales price Variable manufacturing overhead Direct labor Fixed marketing and administrative costs Units produced and sold during the quarter...
-
Today is June 1. Sustainable Corporation has an obligation of $25 million coming due on August 1. The company is planning to borrow this amount on August 1 to fulfill its obligation, and plans to pay...
-
G Ltd owns a specific machine with a carrying amount of $106 667 at 31 December 2014, for which there is an active market. This machine initially cost $200 000 and is depreciated straight line over...
-
The following information is available for Partin Company: Sales $598,000 Sales Returns and Allowances 20,000 Cost of Goods Sold 398,000 Selling Expense 69,000 Administrative Expense 25,000 Interest...
-
St. James Clothiers is a high-end clothing store located in a small Tennessee town. St. James has only one store, which is located in the shopping district by the town square. St. James enjoys the...
-
Southeast Shoe Distributor (SSD) is a closely-owned business that was founded 10 years ago by Stewart Green and Paul Williams. SSD is a distributor that purchases and resells mens, womens, and...
-
Southeast Shoe Distributor (SSD) is a closely owned business that was founded 10 years ago by Stewart Green and Paul Williams. SSD is a distributor that purchases and sells mens, womens, and...
-
You can purchase an item you need for a project for $10,000 and it has daily operating costs of $500, or you can lease the item for $700 per day. On which day will the purchase cost be the same as...
-
Describe practices that should be followed in directing and managing project execution. Why are deliverables such an important output of project execution? What are some of the typical problems that...
-
Why is it important to manage project knowledge during execution? Provide one example of how this can be done.
Study smarter with the SolutionInn App