70.2K
Verified Solution
Link Copied!
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
