Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Please read directions that says create the financial statements, I started the income statement but didn't finish it. Complete the financial statements with any numbers

Please read directions that says "create the financial statements, I started the income statement but didn't finish it." Complete the financial statements with any numbers you want as long as they balance. Add an additional year to it ( 2016, 2017, 2018) Create a Data Table and Drop down cell box in excel and explain in detail how its down. ( do all this in excel because I have to go and integrate all the financials to make sure they balance.)

image text in transcribedimage text in transcribed

Current Balance Sheet Statement of Cash Flows Net Income Add Back Depreciation Income Statement Revenue Sales Revenue Less: Sales discounts & returns Net Sales Less: Cost of Goods Sold Gross Margin Operating Expenses Advertising expense Office Supplies expense Salaries expense Past Year 2016 2017 Assets $12,212,000.00 3,000.00 12,209,000.00 s 3,000,000.00 $9,209,000.00 Current Assets Cash and Cash Equivalents Accounts Receivable Inventory Change in Inventory aid enses Short term Investments Total Current Assets Fixed Long Term Assets Long term investments Property, Plant, and Equipment Le Accumulated depreciation) Change in Accruals $500,000.00 $10,000.00 $499,600.00 44,000.00 $13,000.00 $3,000.00 $ 3,000.00 $10,000.00 S 50,000.00 $ 200,000.00 $300,000.00 $4,000.00 1,000.00 $8,000.00 $10,000.00 $50,000.00 $800,000.00 $ 2,505,600.00 $ 6,703,400.00 6,730.50 $ 6,696,669.50 Net Cash from Operations Property & Equip. Purchases, net Net Cash Investing Activities en Insurance Utilities Fees Maintenance and repairs Research and Development Short Term Financing, Net Long Term Financing, Net Owner's Contribution, Net Net Cash from Financing Act. Total other assets Total Assets Liabilities and Owner's Equity Current Liabilities Accounts Payable Notes Payable accrued salaries and wages unearned revenue Total Current Liabilities Long term debt Deferred income tax Total Long term Liabilities Owner's Equity Owner's Investment Retained earnings Total Equity Total Liabilities and Equity Distributions to Owners Funds Needed Net Change in Cash Cash, Beginning of Year Cash, End of Year web hosting and domains Miscellaneous Depreciation Travel commission Total Operationg Costs Interest Income before taxes Income Tax Expense Income from continuing operations Income from discontinued operations Effect of accounting changes Extraordinary items 0 ncome

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