Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer Enter the numbers from your Excel spreadsheet: format the numbers with a comma separating the thousands position and no decimal places. In the
please answer
Enter the numbers from your Excel spreadsheet: format the numbers with a comma separating the thousands position and no decimal places. In the Income Statement for 2017: gross profit $ 1,850,000 depreciation $ 550,000 tax rate 35 % In the Balance sheet for 2017: total shareholder's equity $4.026.720 total assets $ 1,389,970 In the Statement of Cash flows for 2017 (use a positive sign for cash inflows and a negative sign for cash outflows): total cash flows from operations $ total cash flows from investing $ cash dividend paid to shareholders $ Square Corp. Income Statement For the Year Ended Dec. 31, 2017 (S) 2017 2016 7,250,000 6,750,000 5,400,000 5,330,000 1,850,000 1,420,000 965,000 632,000 550,000 550,000 335,000 238,000 130,000 110,000 205,000 128,000 71,750 48,900 133,250 79,100 35.00% 38.20% 75,000 65,000 $1.78 $1.22 $1.07 $0.73 $0.71 $0.49 60% Sales Cost of Goods Sold Gross Profit Selling and G&A Expenses Depreciation EBIT Interest Expense Earnings Before Taxes Taxes Net Income Notes: Tax Rate Shares Outstanding Earnings per Share Dividends per Share Addition to RE per Share Dividend Payout Ratio 3 26 27 2 3 6 7 10 11 12 Assets Square Corp. Balance Sheet As of Dec. 31, 2017 (S) Cash Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Net Fixed Assets Total Assets 13 Liabilities and Owners' Equity Accounts Payable 14 15 Notes Payable 16 Total Current Liabilities 17 Long-term Debt 18 Total Liabilities 19 Common Stock 20 Additional Paid-in-Capital Retained Earnings 22 Total Shareholder's Equity 21 23 24 25 Total Liabilities and Owners' Equity 2017 2016 149,970 100,000 370,000 347,000 870,000 515,000 138,970 962,000 6,570,000 5,010,000 1,930,000 1,380,000 4,640,000 3,630,000 6,029,970 4,592,000 420,000 321,440 166,625 22,960 586,625 344,400 1,350,000 918,400 1,936,625 1,262,800 2,520,000 2,043,440 772,000 551,040 801,345 734,720 4,026,720 332,900 6,029,970 4,592,000 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