Question
THE FOLLOWING QUESTION BY SUBMITTING AN EXCEL DOCUMENT. Feel free to submit both excel-related questions in the same file, but on separate, clearly labeled tabs.
THE FOLLOWING QUESTION BY SUBMITTING AN EXCEL DOCUMENT. Feel free to submit both excel-related questions in the same file, but on separate, clearly labeled tabs. BE SURE TO LABEL YOUR FILENAME WITH FIRST NAME, LAST NAME, STUDENT #, BUSI1013 EXAM. Ex. MikeKennedy100052782BUSI1013Exam.xlsx A group of Acadia students has decided to start a Prof K. bad joke-inspired clothing store in Wolfville called PUNdemic Clothing Inc. The company has the following adjusted trial balance as at Year End December 31st, 2019: PUNDemic Clothing Inc.. ADJUSTED TRIAL BALANCE DECEMBER 31ST, 2019 ACCOUNT DEBIT CREDIT Cash 13,600 Accounts Receivable 32,600 Inventory 19,600 Supplies 2,600 Equipment 69,000 Accumulated Depreciation, Equipment 13,700 Accounts Payable 5,100 Deferred Revenue Note Payable, Long-Term Contributed Capital 2,800 40,000 25,000 Retained Earnings 68,200 Dividends. 48,000 Sales Revenue 197,500 Sales Returns & Allowances 4,800 Sales Discount 3,100 553IT Cash 13,600 Accounts Receivable 32,600 Inventory 19,600 Supplies 2,600 Equipment 69,000 Accumulated Depreciation, Equipment 13,700 Accounts Payable 5,100 Deferred Revenue Note Payable, Long-Term Contributed Capital 2,800 40,000 25,000 Retained Earnings 68,200 Dividends 48,000 Sales Revenue 197,500 Sales Returns & Allowances 4,800 Sales Discount 3,100 Cost of Goods Sold 101,400 Selling Expense 37,000 General Expense 20,600 Total 352,300 352,300 REQUIRED: 1. Prepare a Multi-Step Income Statement for the Year Ended December 31st, 2019. 2. Prepare a Classified Balance Sheet as at December 31st, 2019. 3. Calculate the Current Ratio and Gross Profit Margin Percentage for the company. FOR AN EVE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started