There is a Part-1 and Part-2 in word document….
Should be done in an Excel.. Present all your calculations and formulas used along with your final results.
This should be well-organized. Please attach any necessary Excel Workbooks as necessary along with your written analysis….
The word document is attached bellow….(Finance-part1and2)