Order Description

Use the spreadsheet and the word document to answer question 4. Only question 4 – Use spreadsheet for question 4, copying/editing the necessary info from previous spreadsheets on a new one and answer the question with necessary data changes.

clearly explain the steps taken on excel on a word document.

Assume Ocean Carriers uses a 7% discount rate.
The easiest way to solve the case is to use a spreadsheet to calculate free cash flows. After you set the spreadsheet up for question 1, it should be easy to modify the spreadsheet to answer questions 2, 3 and 4.