Please calculate the common size percentages for the Balance Sheet and Income Statement (both years), and calculate the Ratios for the year 2016. Excel is the preferred platform for completing the assignment.

FALLCO 09-2017 Balance Sheet ASSETS Cash Accounts Receivable as of 12/31/2015 as of 12/31/2016 19,000 130,000 426,000 575,000 1,210,000 475,000 735,000 1,310,000 14,000 112,000 Current Assets Gross Fixed Assets (Accumulated Depreciation) 450,000 1.188,000 438,000 750,000 1.200,000 Net Fixed Assets Total Assets LIABILITES&OWNERS EQUITY Accounts Payable Notes Payable 75,000 110,000 185,000 195,000 380,000 95,000 125,000 220,000 160,000 380,000 Current Liabilities Long-Term Debt Total Liabilities Owners' Equity Common Stock Retained Earnings 575,000 245,000 820,000 1.200,000 625,000 305,000 930,000 1,310,000 Total Equity Total Liabilities & Owners' Equity Working Capital 265,000 355,000