[All parts must be prepared and submitted in the Excel file using Excel built-in functions. Note that you should NOT manually enter any numeric value inside the built-in functions but rather refer to cells containing input values.] You have been tasked with fielding an interactive video communications systems. Your job is to provide the Army with the least expensive system (for the next 5 years) from the following alternatives: 1. Intertactical. An interactive communications system designed to rely on current satellite systems. The Army must spend $10,590,843.42 now. (t = 0) and $1.7 million this year. (t = 1), increasing that investment by 13% in subsequent years for 4 additional years. (t = 2 through 5). 2. TacLine. Provides interactive communications that operate through existing phone lines. The Army must spend $4 million now (t = 0) and $3 million dollars this year (t = 1), increasing its investment by by $500,000 each year thereafter for 4 additional years (t = 2 through 5). The Army uses an annual interest rate of 8%. (a) (7 points] Prepare a cash flow (CF) table in Excel for each of these ventures and make sure you label everything. (b) [6 points] Use pv function to calculate the present worth (i.e., at time zero) of each year's CF. Then, use the sum function to find the total present worth. (c) [3 points] Use NPV function to calculate the present worth (i.e., at time zero) of the venture. (d) [6 points] Use FV function to calculate the future worth (i.e., at year 5) of each year's CF. Then, use the sum function to calculate the total future worth. (e) [6 points] Use PMT function to calculate equivalent uniform cash value of each year's CF considering the given study period of 5 years. Then, use the sum function to calculate the total annual value. (1) [2 points] Using the answers you have given to previous parts, which alternative should be chosen? Explain