90.2K

Verified Solution

Link Copied!

Using the data presented below:

Square Corp.				Square Corp.
Income Statement				Balance Sheet
For the Year Ended Dec. 31, 2017 ($ in 000's)				As of Dec. 31, 2017 ($ in 000's)
	2017	2016		Assets	2017	2016
Sales	7,250,000	6,750,000		Cash	149,970	100,000
Cost of Goods Sold	5,400,000	5,330,000		Accounts Receivable	370,000	347,000
Gross Profit	?	?		Inventory	870,000	515,000
Selling and G&A Expenses	965,000	632,000		Total Current Assets	?	?
Depreciation	?	550,000		Plant & Equipment	6,570,000	5,010,000
EBIT	335,000	?		Accumulated Depreciation	1,930,000	1,380,000
Interest Expense	?	110,000		Net Fixed Assets	?	?
Earnings Before Taxes	205,000	?		Total Assets	?	?
Taxes	?	?		Liabilities and Owners' Equity
Net Income	133,250	79,100		Accounts Payable	420,000	321,440
				Notes Payable	166,625	22,960
Notes:				Total Current Liabilities	?	?
Tax Rate	?	?		Long-term Debt	1,350,000	918,400
Shares Outstanding	75,000	65,000		Total Liabilities	?	?
Earnings per Share	?	?		Common Stock	2,520,000	2,043,440
Dividends per Share	?	?		Additional Paid-in-Capital	772,000	551,040
Addition to RE per Share	?	?		Retained Earnings	734,720	734,720
Dividend Payout Ratio		60%		Total Shareholder's Equity	?	?
				Total Liab. and Owners' Equity	?	?

1. Recreate the income statement and balance sheet by filling in the question marks with formulas. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly. Note that in 2016, 60% of earnings were paid to shareholders as dividends.
2. On another worksheet, create a statement of cash flows for 2017. Use formulas linked directly to the source on previous worksheets instead of numbers.
3. Create a common-size income statement and balance sheet for 2017 and 2016. These statements should be created on a separate worksheet with all formulas linked directly to the income statement and balance sheet. add formulas please

Answer & Explanation Solved by verified expert

See Answer