answers to parts a-g
-required h
-required I
-required J
(original instructions)
Add CAMRELL COMPANY. BUDGET PREPARTION SALES BLDGET AMOUNTINS A) Percentage October November December Total Tales 10.320000 354000 460800 116480 Caves 394 11.2000 134400 761280407680 Credits 6529000 29000 299520 757120 CASH COLLECTION BUDGETY AMOUNT INS) B) CREDIT Other November December Total 112000 154000 161280407680 Collection from Accounts receivable Imho 2000 20900 457600 Tul 11.2008 343000 4100 650 INVENTORY PURCHASE BUDGET AMOUNTINS Tercentage:October November December Total 33364000 6000 1161304 Costa de consoles 1.92.0002,30,400 2.16.480 6.93.88 Adding met of extra 23.000 27.5 14.000 64685 lyrooded 2.150902.58,046 2.4.40 1933 23:40 27 545 5065 2.15.00 2.35.00% 2.62.832 18.77.6 CASH PAYMENT BUDGET FOR PURCHASES AMOUNT INS) D) Pecctober November Toul payment of controle 204 141004 1574002427728 meme 694032 10019 12924 227020% 251702.4 07147. EXPENSE BUDGET FOR SEMAMOENTEN Particular Pencenter November December Toul Salary 20000 20000 20000 1000 Sales Cocina % 1019200 23040 5240 Supplies egen 25 000 23206 Unes Feed 3400 3000 3400 10200 Deprecate CORO XO TO Rent Final 600 600 20400 Misce 3300 9000 TOTAL SRA EXPENSE INDO 71656 199736 CASH PAYMENT BUDGET FOR SE MAMOUNT IN S Petter November Total Suary F 2000 20000 20000 00 Sales Commission 100 35200 2 6400 9216 2020 Found 3.000 3400 6500 Deprece o 20400 Misc fisod 3300 3200 3300 600 TOTAL PAYMENTS FOR SEA 36000011 G CASH BUDGET AMOUNTERS Patie Percentage Otober November December Total A Cash Recipes tepaarai thaan 3297632000 Add:Carcer 113000 430 44080 86280 Tocal atte 1136003749764380 939856 Fornity puro 12224 2270308 351702.4 607747 36400 500 61810 155246 256000 el expense 6540 5799 296 126193 Talcah 1434 20840 319317.7 10316 Financing Activities 309024 80035.2 123562310182 343000-520032-915633 95402 Ending change 32576 52100 2000 16 0 Required Information Problem 7-23A Preparing a master budget for retall company with no beginning account balances LO 7- 2,7-3, 7-4, 7-5, 7-6 [The following information applies to the questions displayed below) Campbell Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2019. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks: Problem 7-23A Part 2 h. Prepare a pro formo income statement for the quarter I. Prepare a pro forma balance sheet at the end of the quarter J. Prepare a pro forma statement of cash flows for the quarter. Complete this question by entering your answers in the tabs below. Required Required 1 Required) Prepare a pro forma income statement for the quarter. CAMPBELL COMPANY Pro Forma Income Statement For the Quarter Ended December 31, 2019 0 0 5 0 Required > Problem 7-23A Part 2 h. Prepare a pro forma Income statement for the quarter. I. Prepare a pro forma balance sheet at the end of the quarter J. Prepare a pro forma statement of cash flows for the quarter. Complete this question by entering your answers in the tabs below. Required H Required 1 Required) Prepare a pro forma balance sheet at the end of the quarter. (Amounts to be deducted should be indicated by a minus sign.) CAMPBELL COMPANY Pro Forma Balance Sheet December 31, 2019 Assets 0 Total assets Liabilities Equity Total liabilities and equity 0 Problem 7-23A Part 2 h. Prepare a pro forma Income statement for the quarter 1. Prepare a pro forma balance sheet at the end of the quarter. J. Prepare a pro forma statement of cash flows for the quarter, Complete this question by entering your answers in the tabs below. Required H Required 1 Required Prepare a pro forma statement of cash flows for the quarter. (Amounts to be deducted should be indicated by a minus sign.) CAMPBELL COMPANY Pro Forma Statement of Cash Flows For the Quarter Ended December 31, 2019 Cash flows from operating activities $ 0 Net cash flows from operating activities Cash flows from investing activities Cash flow from financing activities 5 0 Problem 7-23A Part 2 h. Prepare a pro forma Income statement for the quarter. I. Prepare a pro forma balance sheet at the end of the quarter J. Prepare a pro forma statement of cash flows for the quarter. Complete this question by entering your answers in the tabs below. Required H Required 1 Required) Prepare a pro forma balance sheet at the end of the quarter. (Amounts to be deducted should be indicated by a minus sign.) CAMPBELL COMPANY Pro Forma Balance Sheet December 31, 2019 Assets 0 Total assets Liabilities Equity Total liabilities and equity 0 Problem 7-23A Part 2 h. Prepare a pro forma Income statement for the quarter 1. Prepare a pro forma balance sheet at the end of the quarter. J. Prepare a pro forma statement of cash flows for the quarter, Complete this question by entering your answers in the tabs below. Required H Required 1 Required Prepare a pro forma statement of cash flows for the quarter. (Amounts to be deducted should be indicated by a minus sign.) CAMPBELL COMPANY Pro Forma Statement of Cash Flows For the Quarter Ended December 31, 2019 Cash flows from operating activities $ 0 Net cash flows from operating activities Cash flows from investing activities Cash flow from financing activities 5 0
