Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide the excel formula 4 x fx A D E 2019 2018 F G Increase (Decrease) Amount Percent Assets Cash Accounts Receivable, Net Merchandise
Please provide the excel formula
4 x fx A D E 2019 2018 F G Increase (Decrease) Amount Percent Assets Cash Accounts Receivable, Net Merchandise Inventory Supplies Prepaid Rent Total Current Assets $65,000 $150,000 $135,000 $9,700 $30,000 $389.700 $80,000 $100,000 $70,000 $500 $10,000 $260,500 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, Plant, and Equipment Total Assets $500,000 ($80,000) $420,000 $809,700 $240,000 ($90,000) $150,000 $410,500 Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Unearned Revenue Salaries Payable Federal Income Taxes Payable $150,000 $40,000 $40,000 $10,000 $40,000 $50,000 $30,000 $10,000 Total Current Liabilities $240.000 $130.000 Long Term Liabilities Note Payable Total Long-Term Liabilities Total Liabilities 0 $130,000 $130,000 $370,000 0 $130,000 Stockholders' Equity: Common Stock, S1 Par Paid In Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity $170,000 $43,700 $226,000 $439.700 5809.700 $100,000 SO $180,500 $280.500 $410.500 Comparative Statement of income CashFlowStatement Vertical Analysis Horizontal Analysis Ratio Analysis + Ready U AutoSave Excel Project-SUM2 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 v 2 Wrap Text General A K a.Av Paste B 1 Merge & Center $% 9 157 x fx * A B D H Stockholders' Equity: Common Stock, $1 Par Paid-In Capital in excess of Par Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity $170,000 $43,700 $226,000 $439,700 S809,700 $100,000 $0 $180,500 $280,500 $410,500 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Comparative Statement of Income For the Years Ended December 31, 2018 and 2017 Increase (Decrease) Amount Percent 2019 2018 $700,000 $524,300 $175,700 $600,000 $420,000 $180.000 Sales Cost of Goods Sold Gross Margin Operating Expenses Salaries and Wages Expense Rent Expense Depreciation Expense Total Operating Expenses Income from Operations Loss on Sale of Equipment Interest Expense Increase (Decrease) in Operating Income Income before Taxes Federal income Taxes 30% Net Income $47,290 $20,256 $20,000 $87,546 $88,154 ($5,213) $3,656 158,869 $79,285 $23,786 $55.499 $100,000 $20,000 $10,000 $130,000 $50,000 $0 $5,000 195.000 $45,000 $13,500 $31.500 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 total 10 points for this analysis, Excel funtion is needed to conduct calculation CashFlowStatement Vertical Analysis Horizontal Analysis Ratio Analysis + Ready Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started