Utilizing the PAYBACK METHOD how long shall it take 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 anexcel spreadsheet.

-Use Excel formulas which are on the ribbon in Excel marked "fx" to make your calculations whenever possible.

All information must be inExcel.

YEAR PROJECT A PROJECT B PROJECT C

2018 ($3,000,000) ($3,000,000) ($3,000,000)

2019 $0 $975,000 $985,000

2020 $600,000 $975,000 $925,000

2021 $900,000 $975,000 $995,000

2022 $2,700,000 $975,000 $975,000