2. Numerical data The income statement and balance sheet for 2021 and 2022 (forecast) can be...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 13 142 July 0 0 4 4 August 36 22 18 76 September 85 72 22 179 October 112 78 7 197 November 121 98 19 238 December 135 138 8 281 1106 850 140 2096 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. 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. 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 13 142 July 0 0 4 4 August 36 22 18 76 September 85 72 22 179 October 112 78 7 197 November 121 98 19 238 December 135 138 8 281 1106 850 140 2096 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. 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.
Expert Answer:
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-1259569197
8th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Olds
Posted Date:
Students also viewed these accounting questions
-
The Stair Company sells computer parts through a retail store that it operates. The firms comparative income statement and balance sheet for the years 2019 and 2018 follow: INSTRUCTIONS 1. Prepare...
-
In 2016, after 10 years of public accounting experience, Michelle Tilford, CPA, decided to resign her position with a national accounting firm and started Canada Software Limited (CSL). Michelle had...
-
Prudence Corporation manufactures two products: X and Y. The company has 4,000 hours of machine time available and can sell no more than 800 units of product X. Other pertinent data follow. Which of...
-
What should it use as its discount rate in determining its pension obligation?
-
Compute the energy loss in a 90 bend in a steel tube used for a fluid power system. The tube has a -in OD and a wall thickness of 0.065 in. The mean bend radius is 2.00 in. The flow rate of hydraulic...
-
Explain the Chinese Room argument, and present some of the arguments against it, and the counter-arguments. Which do you find most convincing? How does this affect your view on the overall worth of...
-
The post-closing trial balance of Violet Corporation at December 31, 2012, contains the following stockholders equity accounts. Preferred Stock (15,000 shares issued)........... $ 750,000 Common...
-
Juan, priest of the San Juan Bautista Church in Culebra, is interested in purchasing a bus with a capacity of 12 passengers or more. When visiting your office, Juan has the idea of using the vehicle...
-
Explain the concept of deadlocks in operating systems. Provide an example of a scenario that can cause a deadlock and discuss the methods used to prevent deadlocks.
-
Why might the members of a currency union wish to impose rules on the conduct of national fiscal policies?
-
What is fiscal federalism? How might the problems of macroeconomic adjustment in a currency union be alleviated by fiscal federalism?
-
What is meant by sustainable economic growth?
-
An RLC circuit consists of a \(220-\Omega\) resistor, a \(3.3-\mu \mathrm{F}\) capacitor, and a \(3.9-\mathrm{mH}\) inductor. The circuit is connected to a power outlet that has a peak emf of \(150...
-
Explain the shape of the New Keynesian AS curve.
-
1. Let a perfectly competitive industry have 100 identical firms with a marginal cost curve given by MC-Q/5. a. Construct the short run industry supply curve with 100 firms. b. Let the market demand...
-
Read the Forecasting Supply Chain Demand Starbucks Corporation case in your text Operations and Supply Chain Management on pages 484-485, then address the four questions associated with the...
-
Would a fixed or variable cost structure be more advantageous if volume is decreasing?
-
Kemp Corporation makes a protein supplement called Power Punch. Its principal competitor for Power Punch is the protein supplement Superior Strength, made by Jim Adams Company (JAC). Mr. Adams, a...
-
Intel Corporation is mostly known for manufacturing silicon chips for computers. Answer the following questions using the company's Form 10-K for the period ended December 27, 2014. The Form 10-K can...
-
A plane layer of coal of thickness \(L=1 \mathrm{~m}\) experiences uniform volumetric generation at a rate of \(\dot{q}=10 \mathrm{~W} / \mathrm{m}^{3}\) due to slow oxidation of the coal particles....
-
Consider the steady-state temperature distribution in a radial wall (cylinder or sphere) of inner and outer radii \(r_{i}\) and \(r_{o}\), respectively. The temperature distribution is \[T(r)=C_{1}...
-
Two-dimensional, steady-state conduction occurs in a hollow cylindrical solid of thermal conductivity \(k=22 \mathrm{~W} / \mathrm{m} \cdot \mathrm{K}\), outer radius \(r_{o}=1.5 \mathrm{~m}\), and...
Study smarter with the SolutionInn App