I have included a simple capital investment problem. This I have to look at the pay back method. This method looks at how long it takes to get the money back from an initial investment or cash outflow. Please do the following:

Define the technique.

Analyze the numbers in the problem using an excel spreadsheet.

It must be in Excel formulas which are on the ribbon in Excel marked Fx to make your calculations whenever possible.

All information must be in Excel

Year 2014 2015 2016 2017 2018 Project A ($3,000,000) $0 $600,000 $900,000 $2,700,000 Project B ($3,000,000) $975,000 $975,000 $975,000 $975,000