Part 1:

Prepare Problem 7-4B using Excel (30 points):

NOTE: if you do not have access to Excel, please complete in Google Sheets and "save as" an Excel sheet - let me know if you have questions on this process)

Problem 7-4A Manufacturing: Preparation of a complete master budget ( P1 P2 4 P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Liabilities and Equity Cash $ 40,000 Accounts payable $ 200,500 Accounts receivable 342,248 Short-term notes payable 12,000 Raw materials inventory 98,500 Total current liabilities 212,500 Finished goods inventory 325.540 Long-term note payable 500,000 Total current assets 806,288 Total liabilities 712,500 Equipment 600,000 Common stock 335,000 Accumulated depreciation (150,000) Retained earnings 208.788 Equipment, net 450,000 Total stockholders' equity 543.788 Total assets $1,256,288 Total liabilities and equity $1,256,288