The items in the budget should appear in the following order: 1. The balance sheet for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The items in the budget should appear in the following order: 1. The balance sheet for December 31, 2022 (as given above). 2. A cash receipts schedule for January, February and March. Hint: use the given percentages, with the Round function (explained below), to avoid a rounding error. Check figure: Cash receipts for January should be $40,584. 3. A purchases schedule in units for January, February and March. Check figure: January purchases should be 110 units. 4. A cash payments schedule for January, February and March. Check figure: January's total cash payments should be $44,034. 5. A cash budget for January, February and March, including the balance of the short-term loan balance at the end of each month (presented below the cash budget). Check figure: At the end of January the cash balance should be $8,000 and the short-term loan balance should be $971 at the end of March. 6. The pro-forma income statements for January, February and March with a fourth column for totals. Subtotals for EBIT and EBT should be included. List all expenses separately (do not combine) and show long-term and short-term interest separately. Hint: Cost of goods sold is not the same thing as purchases. Cost of goods sold is based on sales. Check figure: January's earnings after taxes should be $1,781. 7. A pro-forma retained earnings schedule for the quarter ended March 31 (not for each month). Check figure: Ending retained earnings should be $4,943. A pro-forma balance sheet at March 31. You do not have to complete balance sheets for January or February. Hints: Consider what will cause balances to change from the December 31, 2022 balance sheet. Prepaid insurance will be the opening amount less the amount expensed on the income statement. Tax payable will be the opening balance plus total tax expense less total tax instalments. Check figure: Total assets should be $59,432. Cash Accounts receivable Inventory Prepaid insurance Total current assets Equipment Accumulated depreciation Net equipment Total assets Balance Sheet December 31, 2022 $ 8.000 11,780 15,960 8.400 44,140 16,000 6,000 10,000 $ 54,140 Accounts payable Taxes payable ST loan payable Total current liabilities LT loan payable Total liabilities $ 22,470 1,800 2.400 26,670 10,000 36,670 16,000 1,470 $ 54,140 Common shares Retained earnings Total liabilities and equity *1,000 common shares outstanding A. The company sells each system for $380. Actual sales for November 2022 were 100 units and actual sales for December 2022 were 104. It is expected that sales will increase by 4% per month until May 2023. B. 75% of the cash for sales is collected in the month of sale, 20% is collected in the following month, and the remaining 5% is collected in the month after that. For simplicity, all sales taxes will be ignored. C. The company purchases enough units each month to cover the current month's sales and maintain an ending inventory equal to 70% of the following month's projected sales. Each unit costs the company $210. Inventory purchases are paid for in the month following the purchase. D. The company is expected to incur fixed operating expenses of $2,400 per month and variable operating expenses equal to 10% of sales for the month. Operating expenses are paid for in the month incurred. E. Monthly interest is paid on the long-term loan at a rate of 6% per annum. At the end of March, a payment of $1,000 will be made on the principal of the loan. F. On August 1, 2022, the company paid $14,400 for one year's insurance coverage. G. Equipment costing $6,000 will be purchased and paid for at the beginning of January. All equipment (existing and new) is depreciated on a straight-line basis over 15 years with no residual value. H. The company will issue 100 additional common shares and sell them to your uncle for $20.00 per share at the end of March 2023. I. The company pays salaries totalling $8,000 each month. For simplicity, ignore all payroll tax implications. The company will declare and pay a dividend of $3,000 at the beginning of March 2023. J. K. Income tax expense for this small business is calculated at 28% of the earnings before taxes. The company pays income tax instalments of $1,000 per month. L. The company must maintain a minimum cash balance of $8,000. A short-term loan is available to cover any shortfall. Interest is paid monthly on the previous month's loan balance at a rate of 5% per annum. Any cash above $8,000 av able at month end is used to reduce any existing short-term loan. The items in the budget should appear in the following order: 1. The balance sheet for December 31, 2022 (as given above). 2. A cash receipts schedule for January, February and March. Hint: use the given percentages, with the Round function (explained below), to avoid a rounding error. Check figure: Cash receipts for January should be $40,584. 3. A purchases schedule in units for January, February and March. Check figure: January purchases should be 110 units. 4. A cash payments schedule for January, February and March. Check figure: January's total cash payments should be $44,034. 5. A cash budget for January, February and March, including the balance of the short-term loan balance at the end of each month (presented below the cash budget). Check figure: At the end of January the cash balance should be $8,000 and the short-term loan balance should be $971 at the end of March. 6. The pro-forma income statements for January, February and March with a fourth column for totals. Subtotals for EBIT and EBT should be included. List all expenses separately (do not combine) and show long-term and short-term interest separately. Hint: Cost of goods sold is not the same thing as purchases. Cost of goods sold is based on sales. Check figure: January's earnings after taxes should be $1,781. 7. A pro-forma retained earnings schedule for the quarter ended March 31 (not for each month). Check figure: Ending retained earnings should be $4,943. A pro-forma balance sheet at March 31. You do not have to complete balance sheets for January or February. Hints: Consider what will cause balances to change from the December 31, 2022 balance sheet. Prepaid insurance will be the opening amount less the amount expensed on the income statement. Tax payable will be the opening balance plus total tax expense less total tax instalments. Check figure: Total assets should be $59,432. Cash Accounts receivable Inventory Prepaid insurance Total current assets Equipment Accumulated depreciation Net equipment Total assets Balance Sheet December 31, 2022 $ 8.000 11,780 15,960 8.400 44,140 16,000 6,000 10,000 $ 54,140 Accounts payable Taxes payable ST loan payable Total current liabilities LT loan payable Total liabilities $ 22,470 1,800 2.400 26,670 10,000 36,670 16,000 1,470 $ 54,140 Common shares Retained earnings Total liabilities and equity *1,000 common shares outstanding A. The company sells each system for $380. Actual sales for November 2022 were 100 units and actual sales for December 2022 were 104. It is expected that sales will increase by 4% per month until May 2023. B. 75% of the cash for sales is collected in the month of sale, 20% is collected in the following month, and the remaining 5% is collected in the month after that. For simplicity, all sales taxes will be ignored. C. The company purchases enough units each month to cover the current month's sales and maintain an ending inventory equal to 70% of the following month's projected sales. Each unit costs the company $210. Inventory purchases are paid for in the month following the purchase. D. The company is expected to incur fixed operating expenses of $2,400 per month and variable operating expenses equal to 10% of sales for the month. Operating expenses are paid for in the month incurred. E. Monthly interest is paid on the long-term loan at a rate of 6% per annum. At the end of March, a payment of $1,000 will be made on the principal of the loan. F. On August 1, 2022, the company paid $14,400 for one year's insurance coverage. G. Equipment costing $6,000 will be purchased and paid for at the beginning of January. All equipment (existing and new) is depreciated on a straight-line basis over 15 years with no residual value. H. The company will issue 100 additional common shares and sell them to your uncle for $20.00 per share at the end of March 2023. I. The company pays salaries totalling $8,000 each month. For simplicity, ignore all payroll tax implications. The company will declare and pay a dividend of $3,000 at the beginning of March 2023. J. K. Income tax expense for this small business is calculated at 28% of the earnings before taxes. The company pays income tax instalments of $1,000 per month. L. The company must maintain a minimum cash balance of $8,000. A short-term loan is available to cover any shortfall. Interest is paid monthly on the previous month's loan balance at a rate of 5% per annum. Any cash above $8,000 av able at month end is used to reduce any existing short-term loan.
Expert Answer:
Answer rating: 100% (QA)
Step 18 The Sales Budget for the period is prepared as below Your Company Name Sales Budget Req 1 Sa... View the full answer
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Posted Date:
Students also viewed these accounting questions
-
A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty five percent of those interested are found not...
-
A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty five percent of those interested are found not...
-
In a hospital ward, the patients can be grouped into two general categories depending on their condition and the amount of solid foods they require in their diet. A combination of two diets is used...
-
As an HR director for IMF Plastics Manufacturing, you receive a phone call about communicating changes made by the company to provide additional shifts.As soon as the call ends, you begin the process...
-
Why do objects illuminated by moonlight lack color?
-
Design a lowpass filter using the prefilter and interpolation methods satisfying the following specifications: \[\begin{aligned}A_{\mathrm{p}} & =0.8 \mathrm{~dB} \\A_{\mathrm{r}} & =40 \mathrm{~dB}...
-
Define a sequence of correlated random numbers \[ s_{k}=\alpha s_{k-1}+(1-\alpha) r_{k} \] where \(r_{k}\) is a unit-variance, uncorrelated, Gaussian pseudorandom number while \(0
-
The following balances were taken from the books of Parnevik Corp. on December 31, 2012. Assume the total effective tax rate on all items is 34%.InstructionsPrepare a multiple-step income statement;...
-
In Milestone Two, you will review the Final Project Client Information document to identify all beneficiaries and discuss potential tax ramifications of receiving inherited property. In addition, you...
-
Company Selection and Financial Retrieval: Pick a public company that piques your interest. Obtain its latest financial statements. 2. Cash Flow Interpretation: Using the acquired financial data,...
-
Amalgamated General Corporation is a consulting firm that also offers financial services through its credit division. From time to time the company buys and sells securities. The following selected...
-
1) What are 2 reasons why stakeholder management is important to project success? 2) What are some possible consequences of stakeholder mismanagement? 3) What if stakeholders have different, or even...
-
How much money does Jessica have in her Education Savings plan if, starting today, she can withdraw $350 per month for four years and her plan earns 7.2% compounded monthly?
-
A 2012 Gallup survey of a random sample of 1014 American adults indicates that American families spend, on average, $151 per week on food. The report further states that, with 95% confidence, this...
-
how to calculate income before tax and interest on PROFORMA sheet
-
What the Marketlands are and what the city plans to do there, using a reference from the cite you got the information from.
-
Boxcars, Inc. has a capital structure consisting of $100MM in equity and $150MM in debt. With this capital structure, the expected return to its equity is 18 percent, the expected return to its debt...
-
Rewrite the code of Figure 7.3 in Ada, Java, or C#. Figure 7.3: template class queue { item items [max_items]; int next_free, next_full, num_items; public: queue () : next_free (0), next_full(0),...
-
Develop a spreadsheet model for gasoline Suggest some metrics that a manager of a fast food restaurant, such as McDonalds or Chipotle, might want to collect. Describe how the manager might use the...
-
PLE produces its most popular model of lawn tractor in its Kansas City and Santiago plants and ships these units to major distribution centers in Atlanta, Caracas, Melbourne, Mexico City, London,...
-
Row 26 of the Excel file Census Education Data gives the number of employed persons having a specific educational level. a. Find the probability that an employed person has attained each of the...
-
Powerhouse Ltd purchased machinery on 2 January 2019, at a cost of $800 000. The machinery is depreciated using the straightline method over a useful life of 8 years with a residual value of $80 000....
-
The purchases and sales of Big Flower Pty Ltd of one brand of lawn fertiliser for the year ended 31 December 2019 are contained in the schedule below. The selling price up to 30 June was $12 per unit...
-
In groups of four or five, consider the following information. On 1 July 2019, Stevenson Pty Ltd, a proprietary company with three shareholders, acquired some property by issuing 100 000 shares to...
Study smarter with the SolutionInn App