Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. create income statement and balance sheet in excel

CREATE INCOME STATEMENT AND BALANCE SHEET IN EXCEL USING THE ABOVE TRIAL BALANCE 2019...

70.2K

Verified Solution

Question

Accounting

image

CREATE INCOME STATEMENT AND BALANCE SHEET IN EXCEL USING THE ABOVE TRIAL BALANCE

2019 2017 $693,470 12,000 $526,945 24,859 Sales revenue Other revenue Cost of goods sold Operating expenses Interest expense Income Tax Expense Cash Accounts receivable, net Inventory Prepaid expenses Property & equipment (net) Accounts payable Accrued expenses Long-term debt Common stock Additional paid-in capital Retained earnings Total $283,877 176,820 12,188 74,479 66,650 89,627 94,071 12,430 755,857 2018 $534,293 16,854 $231,878 112,968 11,484 85,046 49,865 120,313 71,097 18,200 645,120 85,261 12,869 185,000 6,000 99,000 406,694 $1,345,971 $1,345,971 $257,334 103,469 14,280 74,687 22,553 89,515 55,116 5,060 594,330 50,464 10,600 178,000 6,000 99,000 516,465 $1,565,999 67,010 45,870 180,000 5,000 62,000 304,660 $1,216,344 $1,565,999 $1,216,344

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

a toy rocket is fired fired at rest vertically upwards and accelerates at a constant rate....

Physics
Q

Pre-Lab Questions 1.   How are electric potential and electric field similar? How are they different? 2.   Draw the...

Physics
Q

5.State and proof the existence and uniqueness of the Laplace transform. 6.State and proof the linearity properties...

Advance Math
Q

For the Original Post*, identify what you believe is an ethical concern or potential for fraud...

Accounting
Q

example of economic damage that can occur from introduced species

Biology
Q

Consider a uniformly charged solid cylinder of large length and radius R Now consider a...

Physics
Q

Company Squeeze pay profit tax by using the anticipatory profit tax system. Knowing the following...

Accounting
Q

Serial Problem Business Solutions LU P1, P2, P3, P4, P5, PO After the success of...

Accounting
Q

Jean Peck's Furniture manufactures tables for hospitality sector. It takes only bulk orders and each...

Accounting
Q

FIN1013 Financial Analysis and Budgeting Chapter \#10 - Time Value of Money Concept Example Exercise...

Accounting
Q

Sunshine Pty Ltd manufacturers curtains and establishes the following standards: Standard direct materials for each...

Accounting
Q

Question 1 (1 point) Saved Consider the same example as in class: you have $7000,...

Finance