Transcribed Image Text
[Refer to the first venture (Intertactical-See reference below).Use Excel built-in functions, include in the Excel file.] (a) UsePV function to calculate the present worth (i.e., at time zero) ofeach year’s CF. Find the total present worth. (b) Use NPV functionto calculate the present worth (i.e., at time zero) of the venture.(c) Use FV function to calculate the future worth (i.e., at year 5)of each year’s CF. Find the total future worth. (d) Use PMTfunction to calculate the value of equivalent uniform cash flowsover the given study period of 5 years. The discount rate is 8%Reference: You have been tasked with fielding an interactive videocommunications systems. Your job is to provide the U.S. Army withthe least expensive system (for the next 5 years) Intertactical: Aninteractive communications system designed to rely on currentsatellite systems. The Army must spend $10,590,843.42 now. (t = 0)and $1.7 million this year. (t= 1), increasing that investment by13% in subsequent years for 4 additional years. (t = 2 through5).