Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download the attached E3_PizzaWorld Excel file via the download link: Download Here Using the provided Trial Balance, calculate the Income Statement and Balance Sheet items

image text in transcribed
image text in transcribed
Download the attached E3_PizzaWorld Excel file via the download link: Download Here Using the provided Trial Balance, calculate the Income Statement and Balance Sheet items as requested by filling in the YELLOW boxes. Carefully transcribe your results to the appropriate response windows in D2L using the following formatting guidelines. Your responses MUST follow these guidelines in order to be accepted: Dollar signs, commas, and no decimal places. For example: $16,974 After transcribing your calculations into D2L, save your Excel file and upload it to the appropriate DropBox folder for calculation substantiation purposes. Q1: What is the Net Income amount? Q2: What is the total Asset amount? Q3: What is the total Liabilities amount? 4: What is the total Owner's Equity amount? Q5: What is the Liabilities PLUS Owner's Equity amount? Pizza World Adjusted Trial Balance December 31, 2019 Adjusted Trial Balance \begin{tabular}{|l|r|r|} \hline Account & Debit & \multicolumn{1}{|c|}{ Credit } \\ \cline { 2 - 3 } & & \\ \hline Cash & 23,500 & \\ \hline Accounts Receivable & 4,500 & \\ \hline Prepaid Rent & 1,500 & \\ \hline Inventory & 40,100 & \\ \hline Leasehold Improvements & 110,000 & \\ \hline Accumulated Depreciation & & 4,000 \\ \hline Accounts Payable & & 48,000 \\ \hline Accrued Expenses & & 550 \\ \hline Long-Term Liabilities & & 95,000 \\ \hline Common Stock & & 10,000 \\ \hline Revenues & 80,800 \\ \hline SG\&A Expense & 15,350 & \\ \hline Marketing Expense & 2,000 & \\ \hline Rent Expense & 4,500 & \\ \hline Supplies Expense & 1,500 & \\ \hline Utilities Expense & 2,400 & \\ \hline Wages Expense & 32,500 & \\ \hline Interest Expense & 500 & \\ \hline \end{tabular}

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

Financial And Managerial Accounting For Decision Makers

Authors: Michelle Hanlon, Robert Magee, Glenn Pfeiffer, Thomas Dyckman

4th Edition

1618533614, 9781618533616

More Books

Students also viewed these Accounting questions

Question

If you were Akio, what would you do now?

Answered: 1 week ago