You have been tasked with fielding an interactive video communications systems. Your job is to provide the U.S. 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 $500,000 each year thereafter for 4 additional years (t = 2 through 5).
(a) Draw and label a cash flow diagram for each of these ventures.
(b) Prepare a cash flow (CF) table in Excel for each of these ventures.
(c) Using an annual interest rate of 8%, conduct a present worth analysis for the first venture (Intertactical).
(d) Using an annual interest rate of 8%, conduct a present worth analysis for the second venture (TacLine).
(e) Are these two ventures equivalent? Why or why not?
Part (a)
Cash flow diagram for each of the two ventures:
For Intertactical, cash flow in year 2 = C2 = C1x (1 + 13%) = 1,700,000 x (1 + 13%); C3 = C2 x (1 + 13%) and so on
For Tacline, C2 = C1+ 500,000 = 3,000,000 + 500,000 = 3,500,000 and C3 = C2 + 500,000 and so on
Part (b), (c), (d)
Please see the table below. All financials are in $. The cells highlighted in yellow contain the PW values. Adjacent cells in blue contain the formula in excel I have used to get the final output.
Part (e)
No, the two ventures are not equivalent because
You have been tasked with fielding an interactive video communications systems. Your job is to provide...
[Refer to the first venture (Intertactical-See reference below). Use Excel built-in functions, include in the Excel file.] (a) Use PV function to calculate the present worth (i.e., at time zero) of each year’s CF. Find the total present worth. (b) Use NPV function to 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 PMT...
QUESTION#1 ate equity firm. You have been tasked with analyzing a leveraged buyout You are an analyst at a private equity firm. You have been ta opportunity of a retail company. Does this look like a good mpany. Does this look like a good investment for the fund? Key Assumptions: The fund expects to hold the company for five years. Comparable 1d the company for five years. Comparable analysis puts the company value at 5* EBITDA. en able to negotiate...
PROBLEM1 You have been placed in charge of campground development for your agency. You have been asked to assess the value of two potential options using a discount rate is 3% (annual). 1a) Upgraded facilities (hookups and restrooms) will require an initial investment of $65,000 now and require maintenance costs of $1500 per year starting at the end of the first year and $23,000 every five years starting at the end of the fifth year. You expect 750 overnight visitors...
An electrical utility is experiencing a sharp power demand that continues to grow at a high rate in a certain local area.Two alternatives are under consideration. Each is designed to provide enough capacity during the next 25 years, and both will consume the same amount of fuel, so fuel cost is not considered in the analysis. •Alternative A. Increase the generating capacity now so that the ultimate demand can be met without additional expenditures later. An investment of $20 million...
An electrical utility is experiencing a sharp power demand that continues to grow at a high rate in a certain local area.Two alternatives are under consideration. Each is designed to provide enough capacity during the next 25 years, and both will consume the same amount of fuel, so fuel cost is not considered in the analysis. •Alternative A. Increase the generating capacity now so that the ultimate demand can be met without additional expenditures later. An investment of $20 million...
An electrical utility is experiencing a sharp power demand that continues to grow at a high rate in a certain local area. Two alternatives are under consideration. Each is designed to provide enough capacity during the next 25 years, and both will consume the same amount of fuel, so fuel cost is not considered in the analysis. bullet Alternative A. Increase the generating capacity now so that the ultimate demand can be met without additional expenditures later. An investment of...
An electrical utility is experiencing a sharp power demand that continues to grow at a high rate in a certain local area. Two alternatives are under consideration. Each is designed to provide enough capacity during the next 25 years, and both will consume the same amount of fuel, so fuel cost is not considered in the analysis. • Alternative A. Increase the generating capacity now so that the ultimate demand can be met without additional expenditures later. An investment of...
Assume that you are nearing graduation and that you have applied for a job with a local bank. As part of the bank’s evaluation process, you have been asked to take an examination that covers several financial analysis techniques. The first section of the test addresses time value of money analysis. See how you would do by answering the following questions: a. Draw cash flow time lines for (1) a $100 lump-sum cash flow at the end of Year 2,...
I just need help solving for alternative B, I think maybe I am just doing the formula wrong to solve it, so any and all assistance would be appreciated. An electrical utility is experiencing a sharp power demand that continues to grow at a high rate in a certain local area Two alternatives are under consideration. Each is designed to provide enough capacity during the next 25 years, and both will consume the same amount of fuel, so fuel cost...
You have just started a new job and your employer has enrolled you in KiwiSaver. This is the first time you have been enrolled in KiwiSaver and you decide not to “opt out”. You are interested in estimating how much your KiwiSaver fund could be worth when you retire. You make the following assumptions: • You have just turned 30 and will retire in exactly 35 years when you are 65. • Your salary is $50,000 this year and you...