Question: Please only answer Question 2 Part C. The data is provided on first page, there is no missing info. Thanks! (: Problems Sales 1. Using

Problems Sales 1. Using the data presented below: Big Rock Candy Mountain Mining Co. Income Statements For the Years 2015 and 2016 2016 2015 5369,300 5354,000 Cost of Goods 285 400 281 800 Gross Profit 83.900 72,200 Depreciation 26.820 26,360 Selling & Admin Expense 23,340 21.820 Other Operating Expense 1 ORO 1.080 Net Operating Income 32,660 22,940 Interest Expense 7685 7.505 Earnings Before Taxes 24.975 15,435 Taxes 9.990 6,174 Net Income $14.985 $9,261 Notes: Tax Rate 40 00 40.00% Shares 52.100 52,100 Earnings per Share $0.29 50.18 Big Rock Candy Mountain Mining Co. Balance Sheet For the Year Ended December 31, 2016 2016 2015 Assets Cash $14,714 SIO 100 Marketable Securities SI 841 $550 Accounts Receivable $41,090 $42.100 Inventory $46,910 $48.490 Total Current Assets $104.555 S101.440 Gross Fixed Assets 5388.000 $352,600 Accumulated Depreciation $78,020 $51,200 Ner Plant & Equipment $309.980 S301.400 Total Assets $414,535 S-402.840 Liabilities & Omar's Equity Accounts Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock (51.00 par) Additional Paid-in-Capital Retained Earings Total Owner's Equity Total Liab. & Owner's Equity $750 $2,850 $38,050 SI52.700 S190,750 $52,100 5121,500 $50, 185 512700 $2,740 $35.440 $158.600 $194,040 $52.100 $121,500 S15 200 S205 800 5402.840 $223.75 $414.535 2. Using the data from the previous problem: a. Create a common-size income statement for 2015 and 2016. This statement should be created on a separate worksheet with all formulas linked directly to the income statement. b. Create a common-size balance sheet for 2015 and 2016. This statement should be created on a separate worksheet with all formulas linked directly to the balance sheet. Create a common-size statement of cash flows for 2016 that can be switched between using sales and the 2015 cash balance in the denominator
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
