Hello I need assistance with the completion of this assignment!
Required:
Part 1: Prepare the cash flows from operations section of Preston Company's 2016 statement of cash flows.
Part 2: Prepare the following:
A horizontal analysis on the income statements for 2015 and 2016
A horizontal analysis on the balance sheet for 2015 and 2016
Part 3: Prepare the following:
A vertical analysis on the income statements for 2015 and 2016
A vertical analysis on the balance sheet for 2015 and 2016
Part 4: Prepare the following calculations for 2016 (2016 only)
Working capital
Current ratio
Cash ratio
Inventory turnover
Days' sales in inventory
Gross profit ratio
Accounts receivable turnover
Days' sales in receivables
Debt ratio
Debt to equity ratio
Profit margin
Rate of return on total assets
Asset turnover ratio
Rate of return on common stockholders' equity
Earnings per share
Price to earnings ratio
Dividend yield
Dividend payout ratio
Please show work in the area given at the bottom of the spreadsheet.