I don't understand how to do these entries. Please help

This is a comprehensive problem all contained on this spreadsheet tab. You are to prepare a cash flow statement, a vertical analysis, a horizontal analysis, and some ratio calculations. Scroll down the spreadsheet to complete each part. Philadelphia Widget Corporation is in the process of preparing financial statements for the year ended 12/31/2015. They have completed the balance sheet and income statement as shown. Philadelphia Widget Corporation Income Statement For the year ended 12/31/2015 Revenue Cost of Goods Sold Gross Profit 1,235,000 806,356 428,644 Administrative Expenses: Salaries Rent Depreciation Total Administrative Expense Operating Profit 212,450 82,500 24,800 319,750 108,894 Gain on Sale of Equipment Interest Expense Net Income 4,500 (42,115) 71,279 Philadelphia Widget Corporation Balance Sheet As of 12/31/2015, 12/31/2014, and 12/31/2013 2015 Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets 2014 119,411 85,455 41,600 14,500 260,966 Land Buildings and Equipment Accumulated Depreciation 89,564 83,118 48,560 18,100 239,342 50,000 182,450 78,900 Total Assets 103,550 2013 105,644 78,400 62,600 24,000 270,644 50,000 172,450 62,600 109,850 50,000 166,800 54,580 112,220 414,516 399,192 432,864 62,525 4,500 3,000 51,480 4,500 - 45,200 1,500 - Current Portion of Long-Term Debt Total Current Liabilities 50,000 120,025 50,000 105,980 50,000 96,700 Long-Term Debt 175,000 225,000 275,000 Accounts Payable Wages payable Unearned Revenue Common Stock, 3500 shares outstanding Retained Earnings Total Stockholders' Equity 35,000 84,491 35,000 33,212 35,000 26,164 68,212 61,164 414,516 Total Liabilities and Equity 119,491 399,192 432,864 A. Prepare a Statement of Cash Flow using the indirect method for the 2015, using the above statements and the following additional information: 1. Equipment costing $30,000 was purchased in 2015. 2. Equipment having an original cost of $20,000 and accumulated depreciation of $8,500 was sold for $16,000 during 2015. 3. A dividend of $20,000 was declared and paid in 2015. Philadelphia Widget Corporation Statement of Cash Flow For the year ended 12/31/2015 Cash provided (used) by operating activities: Net income Adjustments to reconcile net income to net cash: Increase in accounts receivable Increase in accounts payable Decrease in inventory Decrease in prepaid expenses Increase in unearned revenue Depreciation expense Gain on sale of operating assets Net cash provided by operating activities Cash provided (used) by investing activities: Purchase of equipment Sale of equipment - Note that the entire proceeds go in this section, and the gain is subtracted from t Net cash (used) in investing activities #VALUE! Cash provided (used) in financing activities: Repayment of long-term debt Dividends paid #VALUE! Total cash provided (used) #VALUE! Cash at the beginning of the year Cash at the end of the year #VALUE! Note that you need to make sure that your ending cash here matches your cash o B. Prepare a vertical analysis (1 year) of the income statement above and a horizontal analysis (2 years) of the balance sheet. Philadelphia Widget Corporation Vertical Analysis of Income Statement Revenue Cost of Goods Sold Gross Profit #VALUE! #VALUE! #VALUE! Administrative Expenses: Salaries Rent Depreciation Total Administrative Expense Operating Profit #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Gain on Sale of Equipment Interest Expense Net Income #VALUE! #VALUE! #VALUE! Philadelphia Widget Corporation Horizontal Analysis of Balance Sheet 2015 Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets - Land Buildings and Equipment, net Total Assets Accounts Payable Wages Payable Unearned Revenue Current Portion of Long-Term Debt Total Current Liabilities 2014 #VALUE! #VALUE! #VALUE! #VALUE! #DIV/0! - #VALUE! #VALUE! - #DIV/0! - #VALUE! #VALUE! n/c #VALUE! #DIV/0! 2013 #VALUE! #VALUE! #VALUE! #VALUE! #DIV/0! - #VALUE! #VALUE! - #DIV/0! - - #VALUE! #VALUE! n/c #VALUE! #DIV/0! - Long-Term Debt #VALUE! #VALUE! Common Stock Retained Earnings #VALUE! #VALUE! #VALUE! #VALUE! Total Liabilities and Equity - * n/c = not calculable C. Calculate the following ratios based on 12/31/2015 numbers: 1. Earnings per share 2. Return on common stockholder's equity 3. Return on assets 4. Current ratio 5. Acid-test ratio 6. Accounts receivable turnover #DIV/0! - #DIV/0! - from the operating section. cash on the balance sheet