Part 1: Assume ABC Company has asked you to prepare their 20X1 year-end Balance Sheet based upon the below information. End of the year information: 12/31/X1 Account Ending Balance Cash Accounts Receivable Inventory Equipment Accumulated Depreciation Accounts Payable Short-term Notes Payable Long-term Notes Payable Common Stock Retained Earnings 50,000 175,000 126,000 480,000 90,000 156,000 12,000 200,000 235,000 solve Part 1: Prepare the year-end balance sheet for 20X1. Be sure to use proper headings and labels. This should be done in Excel, using the first tab in the worksheet. Part 2