Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Heuren duove du duodu ne UCIW CE SUITS LIST Task # 2 2. List each account in the column headings in Cells C1 through L1

image text in transcribed
"Heuren duove du duodu ne UCIW CE SUITS LIST Task # 2 2. List each account in the column headings in Cells C1 through L1 as one of the following types of accounts (linke): Asset . Liability Equity Revenue Expense Task # 3 3. Calculate the following items using formulas in Excel (link): Total assets as of January 31, 2020 (put formula in Cell C84) Total liabilities as of January 31, 2020 (put formula in Cell C85) Revenues for the month ending January 31, 2020 (put formula in Cell C89) Expenses for the month ending January 31, 2020 (put formula in Cell C90) Net income for the month ending January 31, 2020 (put formula in Cell C91) Equity as of January 31, 2020 (put formula in Cell C86) Hint: Equity will be Common Stock + Retained Earnings + Net income - Dividends Task #4 4. Total liabilities and equity as of January 31, 2020 (put formula in Cell C87)Using your Excel worksheet and your answers to Requirement 2 answer the following questions: a. What would the accounting equation (linke) for Pepper Food Delivery be as of January 31, 2020? "Heuren duove du duodu ne UCIW CE SUITS LIST Task # 2 2. List each account in the column headings in Cells C1 through L1 as one of the following types of accounts (linke): Asset . Liability Equity Revenue Expense Task # 3 3. Calculate the following items using formulas in Excel (link): Total assets as of January 31, 2020 (put formula in Cell C84) Total liabilities as of January 31, 2020 (put formula in Cell C85) Revenues for the month ending January 31, 2020 (put formula in Cell C89) Expenses for the month ending January 31, 2020 (put formula in Cell C90) Net income for the month ending January 31, 2020 (put formula in Cell C91) Equity as of January 31, 2020 (put formula in Cell C86) Hint: Equity will be Common Stock + Retained Earnings + Net income - Dividends Task #4 4. Total liabilities and equity as of January 31, 2020 (put formula in Cell C87)Using your Excel worksheet and your answers to Requirement 2 answer the following questions: a. What would the accounting equation (linke) for Pepper Food Delivery be as of January 31, 2020

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

Accounting Ethics A Practical Approach

Authors: Howard J Levine

1st Edition

0692112898, 9780692112892

More Books

Students also viewed these Accounting questions

Question

2 What are the advantages and disadvantages of job evaluation?

Answered: 1 week ago

Question

1 Name three approaches to job evaluation.

Answered: 1 week ago