Please create a balance sheet and income statement in an excel sheet from the following information: As of December 31, 2019, Armani Company's financial records show the following items and amounts     Cash  $       10,000 Acount receivable  $         9,000 Supplies  $         6,000 Equipment  $         5,000 Account payable  $       11,000 A.Armani, Capital, Dec 31, 2018  $       16,000 A.Armani, Capital, Dec 31, 2019  $       19,000 A.Armani, Withdrawals  $       13,000 Consulting revenue  $       33,000 Rental revenue  $       22,000 Salaries Expense  $       20,000 Rent Expense  $       12,000 Selling and administrative expenses  $         8,000

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter4: The Balance Sheet And The Statement Of Shareholders' Equity
Section: Chapter Questions
Problem 6E: Balance Sheet Baggett Companys balance sheet accounts and amounts as of December 31, 2019, are shown...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Please create a balance sheet and income statement in an excel sheet from the following information:

As of December 31, 2019, Armani Company's financial records show the following items and amounts
   
Cash  $       10,000
Acount receivable  $         9,000
Supplies  $         6,000
Equipment  $         5,000
Account payable  $       11,000
A.Armani, Capital, Dec 31, 2018  $       16,000
A.Armani, Capital, Dec 31, 2019  $       19,000
A.Armani, Withdrawals  $       13,000
Consulting revenue  $       33,000
Rental revenue  $       22,000
Salaries Expense  $       20,000
Rent Expense  $       12,000
Selling and administrative expenses  $         8,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning