Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PENACY SETTINES APFIED. Yoie eccounf pinacy settings ace being opolied to thik device. To odjuat your artings go to pimacy settings. Hesaly Thaturnibilite Cood to

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
PENACY SETTINES APFIED. Yoie eccounf pinacy settings ace being opolied to thik device. To odjuat your artings go to pimacy settings. Hesaly Thaturnibilite Cood to go Clear determine the following account classifications: Asset, Liability, Equity, Revenue, and Expense. 3. Calculate the following items using formulas in Excel: a. Total assets as of January 31, 2020 (put formula in Cell C84) b. Total liabilities as of January 31,2020 (put formula in Cell C85) c. Revenues for the month ending January 31, 2020 (put formula in Cell C89) d. Expenses for the month ending January 31, 2020 (put formula in Cell C90) e. Net income for the month ending January 31, 2020 (put formula in Cell C91) f. Equity as of January 31, 2020 (put formula in Cell C86) Hint: Equity will be Common Shock + Retained Eamings + Net income Dividends g. Total fiabilities and equity as of January 31, 2020 (put formula in Cell C87) 4. Using your Excel worksheet and your answers to Requirement 2, answer the following questions: a. What would the accounting equation for Gettin' Grub Food Delivery be as of January 31, 2020? b. What accounts would be found on Gettin' Grub Food Delivery's balance sheet as of January 31, 2020? c. What accounts would be found on Gettin' Grub Food Delivery's c. Revenues for the month ending January 31, 2020 (put formula in Cell C89) d. Expenses for the month ending January 31, 2020 (put formula in Cell C90) e. Net income for the month ending January 31, 2020 (put formula in Cell C91) f. Equity as of January 31, 2020 (put formula in Cell C86) Hint: Equity will be Common Stock + Retained Earnings + Net income Dividends 9. Total liabilities and equity as of January 31, 2020 (put formula in Cell C87) 4. Using your Excel worksheet and your answers to Requirement 2, answer the following questions: a. What would the accounting huration for Gettin' Grub Food Delivery be as of January 31,2020 ? b. What accounts would be found on Gettin' Grub Food Delivery's balance sheet as of January 31, 2020? c. What accounts would be found on Gettin' Grub Food Delivery's income statement for the month ended January 31, 2020? d. Did Gettin' Grub Food Delivery have a profitable month? How do you know? e. What is the total amount that Gettin' Grub Food Deivery owes as of January 31, 2020? f. What was Gettin' Grub Food Delivery's largest total expense for January? Requirements c. Revenues for the month ending January 31, 2020 (put formula in Cell C89) d. Expenses for the month ending January 31, 2020 (put formula in Cell C90) e. Net income for the month ending January 31, 2020 (put formula in Cell C91) f. Equity as of January 31, 2020 (put formula in Cell C86) Hint: Equity will be Common Stock + Retained Earnings + Net income Dividends g. Total liabilities and equity as of January 31,2020 (put formula in Cell C87) 4. Using your Excel worksheet and your answers to Requirement 2, answer the following questions: a. What would the accounting vquation for Gettin' Grub Food Delivery be as of January 31, 2020? b. What accounts would be found on Gettin' Grub Food Delivery's balance sheet as of January 31,2020 ? c. What accounts would be found on Gettin' Grub Food Delivery's income statement for the month ended January 31, 2020? d. Did Gettin' Grub Food Delivery have a profitable month? How do you know? e. What is the total amount that Gettin' Grub Food Delivery owes as of January 31, 2020? f. What was Gettin' Grub Food Delivery's largest total expense for January? PENACY SETTINES APFIED. Yoie eccounf pinacy settings ace being opolied to thik device. To odjuat your artings go to pimacy settings. Hesaly Thaturnibilite Cood to go Clear determine the following account classifications: Asset, Liability, Equity, Revenue, and Expense. 3. Calculate the following items using formulas in Excel: a. Total assets as of January 31, 2020 (put formula in Cell C84) b. Total liabilities as of January 31,2020 (put formula in Cell C85) c. Revenues for the month ending January 31, 2020 (put formula in Cell C89) d. Expenses for the month ending January 31, 2020 (put formula in Cell C90) e. Net income for the month ending January 31, 2020 (put formula in Cell C91) f. Equity as of January 31, 2020 (put formula in Cell C86) Hint: Equity will be Common Shock + Retained Eamings + Net income Dividends g. Total fiabilities and equity as of January 31, 2020 (put formula in Cell C87) 4. Using your Excel worksheet and your answers to Requirement 2, answer the following questions: a. What would the accounting equation for Gettin' Grub Food Delivery be as of January 31, 2020? b. What accounts would be found on Gettin' Grub Food Delivery's balance sheet as of January 31, 2020? c. What accounts would be found on Gettin' Grub Food Delivery's c. Revenues for the month ending January 31, 2020 (put formula in Cell C89) d. Expenses for the month ending January 31, 2020 (put formula in Cell C90) e. Net income for the month ending January 31, 2020 (put formula in Cell C91) f. Equity as of January 31, 2020 (put formula in Cell C86) Hint: Equity will be Common Stock + Retained Earnings + Net income Dividends 9. Total liabilities and equity as of January 31, 2020 (put formula in Cell C87) 4. Using your Excel worksheet and your answers to Requirement 2, answer the following questions: a. What would the accounting huration for Gettin' Grub Food Delivery be as of January 31,2020 ? b. What accounts would be found on Gettin' Grub Food Delivery's balance sheet as of January 31, 2020? c. What accounts would be found on Gettin' Grub Food Delivery's income statement for the month ended January 31, 2020? d. Did Gettin' Grub Food Delivery have a profitable month? How do you know? e. What is the total amount that Gettin' Grub Food Deivery owes as of January 31, 2020? f. What was Gettin' Grub Food Delivery's largest total expense for January? Requirements c. Revenues for the month ending January 31, 2020 (put formula in Cell C89) d. Expenses for the month ending January 31, 2020 (put formula in Cell C90) e. Net income for the month ending January 31, 2020 (put formula in Cell C91) f. Equity as of January 31, 2020 (put formula in Cell C86) Hint: Equity will be Common Stock + Retained Earnings + Net income Dividends g. Total liabilities and equity as of January 31,2020 (put formula in Cell C87) 4. Using your Excel worksheet and your answers to Requirement 2, answer the following questions: a. What would the accounting vquation for Gettin' Grub Food Delivery be as of January 31, 2020? b. What accounts would be found on Gettin' Grub Food Delivery's balance sheet as of January 31,2020 ? c. What accounts would be found on Gettin' Grub Food Delivery's income statement for the month ended January 31, 2020? d. Did Gettin' Grub Food Delivery have a profitable month? How do you know? e. What is the total amount that Gettin' Grub Food Delivery owes as of January 31, 2020? f. What was Gettin' Grub Food Delivery's largest total expense for January

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions