IMPORTANT: Please include formulas. Thank you!

Argo Airlines, a privately held firm, is looking to buy additional gates at its home airport for $350,000. Argo has money in the bank but that money may not be spent as it is used to pay salaries, suppliers, and equipment. Argo asked its bank for a loan but the bank refused saying that Argo's interest-bearing debt to equity was too high. The bank said that Argo needed to lower that ratio below 0.5 in order to get the loan. Separately, SkyBlue Airlines has approached Argo to see if Argo will buy it. 2. Aside from the purchase price, the gates will require a working capital infusion of $95,000 at purchase. Argo estimates the gates will generate cash flows of $44,000/year for the next 10 years. After that, the gates will revert back to the airport operator. The working capital is recovered at the end. Calculate the NPV and IRR of the gates. A I K L M B C D E F G H Start Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 1 2 Investment 3 Working Capital 4 Operating Cash Flow 5 Total Cash Flow 6 7 NPV 8 IRR 9 10 Note: Show all numbers in thousand dollars. 11