Please include the formulas.
1 Sales Budget Decembe 280.000 r 400.000 Musch 100.000 Older 1.300.000 600.000 200.000 2 Schedule of expected cash collections 80.000 120.000 60000 280.000 Total cash collections WA DALAWAWALA 3 Schedule of purchases January Fomda February Formula March Foma Our WALUE! Budgeted cost of goods sold Add desired ending vary Total noods Les beginning invertory Required purchases Foma Forma TINALUE! VALUE! Formula 60.000 Formula ELEVALUMA b. Disbursements for purchases February March January Amount Formula Quarter Formula WALUE! WALUE! Formula Formula December purchases Jany purchases February purchases Vrch purchases To Cash disbursements for purchases Formula E FINALUEIT VALUEILCIWALUEIT VALLEI 4 ts for owners Quarter January 27 000 70 000 February 27000 70,000 30.000 18.000 13310 March 27.000 70,000 15.000 Sales and wages Advertising Shipping Other expenses Total cash disbursements for operating expenses 210.000 65.000 20.000 12.00 200 - 00 Quarter Formula Formula Formula 395.000 5 Cash budget January February March Cash banon, beginning Amount Formula Forma Addons collections FMVALUELT VALUELE Totalcash available WALUEINVALUE! Formula Less disbursements: Purchases of inventory WALUE! WALUE! Formula Operating expenses 120.000 145.000 121000 Purchases of equipment Cash dividends Total disbursements WALU WVALUEL 121.00 Excess deficiency of WALUE!" #VALUE! Formula Fricing Borrowing Repayments Interest Total effect of financing Canhance, anding Input appropriate formulas orgiven amounts 2 6 Income statement HILLYARD COMPANY Income Statement For the Quarter Ended March 31 Formula Formula E WALUE! NALUL Sao Less cost of goods sold: Beginning inventory given) Add purchases Part 3) Goods available for sale Ending inventory Part 3) Co margin Loss operating experises Salaries and wages Part 4) Advertising Part 4) Shoping Part 4) Depreciation Other expenses (Part 4) Net operating income Less interest expense Part 5 Net income 81000 210.000 65000 Fomula 22.00 7 Balance sheet HILLYARD COMPANY Balance Sheet 31 Mar Asos Formula Formula Cash Accounts receivable Invertory Total curasses Buildings and equipment WALUE! Total assets P MALLEL Formula Utilities and Equity Cum ibilities: Accounts payable Stock desaguty Capital stock Retinad eamings Total liabilities and equity 500 000 Residentin bacimina 109.000 1 Sales Budget Decembe 280.000 r 400.000 Musch 100.000 Older 1.300.000 600.000 200.000 2 Schedule of expected cash collections 80.000 120.000 60000 280.000 Total cash collections WA DALAWAWALA 3 Schedule of purchases January Fomda February Formula March Foma Our WALUE! Budgeted cost of goods sold Add desired ending vary Total noods Les beginning invertory Required purchases Foma Forma TINALUE! VALUE! Formula 60.000 Formula ELEVALUMA b. Disbursements for purchases February March January Amount Formula Quarter Formula WALUE! WALUE! Formula Formula December purchases Jany purchases February purchases Vrch purchases To Cash disbursements for purchases Formula E FINALUEIT VALUEILCIWALUEIT VALLEI 4 ts for owners Quarter January 27 000 70 000 February 27000 70,000 30.000 18.000 13310 March 27.000 70,000 15.000 Sales and wages Advertising Shipping Other expenses Total cash disbursements for operating expenses 210.000 65.000 20.000 12.00 200 - 00 Quarter Formula Formula Formula 395.000 5 Cash budget January February March Cash banon, beginning Amount Formula Forma Addons collections FMVALUELT VALUELE Totalcash available WALUEINVALUE! Formula Less disbursements: Purchases of inventory WALUE! WALUE! Formula Operating expenses 120.000 145.000 121000 Purchases of equipment Cash dividends Total disbursements WALU WVALUEL 121.00 Excess deficiency of WALUE!" #VALUE! Formula Fricing Borrowing Repayments Interest Total effect of financing Canhance, anding Input appropriate formulas orgiven amounts 2 6 Income statement HILLYARD COMPANY Income Statement For the Quarter Ended March 31 Formula Formula E WALUE! NALUL Sao Less cost of goods sold: Beginning inventory given) Add purchases Part 3) Goods available for sale Ending inventory Part 3) Co margin Loss operating experises Salaries and wages Part 4) Advertising Part 4) Shoping Part 4) Depreciation Other expenses (Part 4) Net operating income Less interest expense Part 5 Net income 81000 210.000 65000 Fomula 22.00 7 Balance sheet HILLYARD COMPANY Balance Sheet 31 Mar Asos Formula Formula Cash Accounts receivable Invertory Total curasses Buildings and equipment WALUE! Total assets P MALLEL Formula Utilities and Equity Cum ibilities: Accounts payable Stock desaguty Capital stock Retinad eamings Total liabilities and equity 500 000 Residentin bacimina 109.000
