MATH OF FINANCE TEXT – Fundamentals of Financial Management 14th edition – Chapter 4 – P.

I need help with the following:

MATH OF FINANCE

TEXT – Fundamentals of Financial Management • 14th edition – Chapter 4 – P. 136-137

1. Create an Excel spreadsheet for the financial statements on page 136-137 (Tables IC 4.1, IC 4.2 and IC 4.3). Note for Table IC 4.3 only input the industry averages. The individual year data will be calculated in Step 2.
2. Using cell references calculate the ratios for 2014, 2015 and 2016E