on Excel sheet

Problem 2: CREATING A BALANCE SHEET (40 points) The information that follows relates to TZC & Associates' latest Balance Sheet (dated December 31, 2017). The figures are presented in Thousands of U.S. Dollars unless noted otherwise. Using the information presented below, prepare and present a properly formatted Balance Sheet. Present the Balance Sheet in any format you wish (T-account or report format) so long as it is professional looking and complete. Accounts Payable Accumulated Depreciation/Amortization on PPE Additional Paid-in-Capital Allowance for Doubtful accounts Cash Common Stock (1.5 million shares out @ $1/share par) Copyrights Current portion of Long-term Debt Deferred Tax Liability Goodwill Gross Accounts Receivable Gross Plant, Property and Equipment (PPE) Inventory Investments Land Long-term Debt Marketable Securities Mortgage Payable Preferred Stock Prepaid Expenses Retained Earnings Treasury Stock Warranty Liability $16,670 27,250 46,400 350 110,325 1,500 22,000 8,900 2,000 65,450 8,760 350,000 10,212 7,178 175,000 318,400 5,176 96,900 17,000 1,002 246,195 27,902 $1,440