show answers with formulas in excel

A D E G H B Paige Monroe Company Budgeted balance sheet 31-Dec-22 Assumptions for inputs No dividends will be paid in 2022 Budgeted 2022 Actual 2021 (prior year) 5 7 8 9 10 11 12 13 14 15 Assets: Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets $ $ $ 5,4065 $ 5,406 S 16,000 79,000 14,600 383 Ending inventoryDesired ending Inventory/tob1b)X COGS per unit (ob in 109,983 $ Property plant & equipment: Equipment Warehouses Less: Accumulated depreciation Total PPSE $ $ 225,000 $ $ 225,000 $ 150,000 100,000 (68,800) Dont forget to accumulate both the manufacturing AND SG&A portion of depreciation 181,200 $ Totalets $ 230,406 $ 291,183 Liabilities & Equity Liabilities Accounts payable Line of credit Notes payable Total abilities 45,000 $ $ 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 32 38 39 40 S 5 125,000 $ 125,000 125,000 170,000 $ Equity Common stock Retained earnings Total equity 74,500 5 S 74,500 5 74,500 46,683 121,183 $ Total liabilities and equity $ 199,500 5 291,183 A D E G H B Paige Monroe Company Budgeted balance sheet 31-Dec-22 Assumptions for inputs No dividends will be paid in 2022 Budgeted 2022 Actual 2021 (prior year) 5 7 8 9 10 11 12 13 14 15 Assets: Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets $ $ $ 5,4065 $ 5,406 S 16,000 79,000 14,600 383 Ending inventoryDesired ending Inventory/tob1b)X COGS per unit (ob in 109,983 $ Property plant & equipment: Equipment Warehouses Less: Accumulated depreciation Total PPSE $ $ 225,000 $ $ 225,000 $ 150,000 100,000 (68,800) Dont forget to accumulate both the manufacturing AND SG&A portion of depreciation 181,200 $ Totalets $ 230,406 $ 291,183 Liabilities & Equity Liabilities Accounts payable Line of credit Notes payable Total abilities 45,000 $ $ 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 32 38 39 40 S 5 125,000 $ 125,000 125,000 170,000 $ Equity Common stock Retained earnings Total equity 74,500 5 S 74,500 5 74,500 46,683 121,183 $ Total liabilities and equity $ 199,500 5 291,183