Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 EVEimage text in transcribedimage text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Construction Accounting And Financial Management

Authors: Steven J. Peterson

3rd Edition

0132675056, 978-0132675055

More Books

Students also viewed these Accounting questions