The Board liked the analysis you did on valuation and agreed to proceed with the expansion plan. Your CFO, investment bankers, and consultants have all been working on the cost and benefits of various expansion options. They have agreed on an option that will see simultaneous expansion into 5 domestic markets (Chicago, Dallas, Miami, New York, and Charlotte), Germany, and Brazil. The CFO has developed cost and benefits of the scenario in a spreadsheet and has asked you to review it.

Look at the spreadsheet and use present value analysis to discount the cash flows. Include the calculations for net income, operating cash flows, free cash flows and the present value cash flows and NPV in your spreadsheet.

Free Cash Flow = Operating Cash Flows (FV) - Increase in Fixed Assets (You calculate for each year from 2014 to 2019 - I updated this from 2012-2017 to 2014-2019).

PV Cash Flow = Free Cash Flow for each year x PVif (PV interest factor) for each year

(Present) Value of Future Flows = Sum of PV Cash Flow each year (2014-2019).

Initial Expenditure (Initial Capital Investment for a new project is given): $18 million

NPV (net present value) = Present Value of Future Cash Flows - Initial Capital Expenditure

If NPV is positive, the Board of Directors will decide to accept the project of expansion of the markets; If NPV is negative, the Board will decide to reject the project.