ABC Corporation wants to relocate its new warehouse in order to save money. The expected savings (cash flow) in the next five years in each location are shown in the following tables. The investment required and cash flows depend on the location, access to highways, local taxes and other related costs associated with the location. Calculate the Payback Period, Net Present Value (NPV), Internal Rate of Return (IRR) and profitability index of each location. Based on the four capital budgeting tools, create a table, and based on your findings, recommend where ABC build its new warehouse. The locations are mutually exclusive, which means ABC can choose only one location. Please note that each location has a different cost of capital to allow for the different risks associated with each location. All the numbers are in thousands of dollars. Cranbrook, BC Year: Cash flow: Cost of Capital: 6% TO 1 | 2 | 3 | 4 | 5 - $5,000 $2,000 $2,000 $2,000 $2,000 $2,000 T Okotoks, AB Year: Cash flow: Cost of Capital: 7% O 1 $6,000 $2,500 | 2 | 3 | 4 | 5 $2,500 $2,500 $2.500 $2.500 Kindersley, SK Year: Cash flow: Cost of Capital: 8% TO | 1 2 3 - $7,000 $3,000 $3,000 $3,000 4 $3,000 5 $3,000 Ongway, AB Year: Cash flow: Cost of Capital: 9% 0 1 2 3 4 5 - $8,000 $3,200 $3,200 $3,200 $3,200 $3,200 Morden, MB Year: Cash flow: Cost of Capital: 8% TO 1 |- $7,500 $3,100 2 $3,100 3 $3,100 4 $3,000 5 $3,100