Question

In: Finance

You have been tasked with fielding an interactive video communications systems. Your job is to provide...

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?

Solutions

Expert Solution

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

  • Their PWs are different
  • Cash flows are different
  • Cash flow patterns are different, Tactical has higher cost upfront at t = 0

Related Solutions

After 3 months on the job, you have now been tasked to provide an investment recommendation...
After 3 months on the job, you have now been tasked to provide an investment recommendation to the Board of Directors of UCW. Currently, UCW is looking to lease an additional 2,000 square feet in Vancouver House. Assume that it currently has 10,000 square feet under lease and that the additional potential space is located on the 1st floor. Zoning for this space provides for multiple potential uses, including retail, restaurants and education. You are to propose a recommendation to...
A new warehouse is to be constructed and you have been tasked to provide the initial...
A new warehouse is to be constructed and you have been tasked to provide the initial design. The warehouse is primarily used for pick/pack of grocery items with a small amount of frozen goods and some pharmaceuticals. Incoming goods are palletized and outgoing orders are as per the customers’ orders. The warehouse will contain some 8000 SKU’s with the majority considered, 80%, to be C class items. The building is only framed right now and is waiting on your design...
5. You are an air-conditioning systems designer, and you have been tasked with developing an air-conditioning...
5. You are an air-conditioning systems designer, and you have been tasked with developing an air-conditioning system (cooling only) for lecture theatre building 32 on ECU’s Joondalup Campus. As a first step you will need to develop a model of the system, explain how you would go about this by providing answers to the following: a. The steps that you would take when developing a mathematical model of the system and what information you would need b. List all of...
Strategic Management - As an international manager for your company, you have been tasked by your...
Strategic Management - As an international manager for your company, you have been tasked by your boss with determining whether or not to expand your company’s products abroad and the possibility of manufacturing and/or outsourcing your products as well. Please apply what you have learned in this course and discuss the following: a. What factors do you think you should consider about your organization and its ability to expand abroad? b. What are the various modes of entry that you...
Consider that you/your group works for the University and you have been tasked with improving the...
Consider that you/your group works for the University and you have been tasked with improving the 5-year graduation rate. In the Analyze phase of your Lean Six Sigma project, you decide to investigate potential causes for “why students do not graduate on-time.” To do this, you plan to use 5 whys/why-why analysis in conjunction with a cause-and-effect diagram. Then, you will collect data about the most significant potential causes of your problem and create a Pareto chart to determine the...
As the Financial Controller of your company, you have been tasked to present a proposal to...
As the Financial Controller of your company, you have been tasked to present a proposal to the Board of Directors of your company for consideration.   Your proposal must address the following; a.      The negative impact of the COVID 19 pandemic on the operations of hospitality firms, justifying why your firm needs a stimulus package from the government?   Your arguments should be situated within the hospitality industry in Ghana. And again with your understanding of lessons on capital structure, which other...
You have been tasked by your upper management team to give a presentation to your peers...
You have been tasked by your upper management team to give a presentation to your peers on heath disparities and inequalities. In this assignment, you will create a PowerPoint presentation to evaluate the impact of commonly accepted business principles used to create an equitable healthcare system. Your presentation should include discussion on the following topics: definitions and examples, ethical differences between an inequality and an inequity, populations involved, ways to reduce or eliminate health inequalities, and business principles and ethical...
Strategic Management - As a top manager for your firm you have been tasked with developing...
Strategic Management - As a top manager for your firm you have been tasked with developing criteria for your strategic management team to evaluate strategies for your organization. Based on what you have studied in class, what criteria would you use to conduct your analysis (i.e. in evaluating the external and internal environment and other factors). Please ground your reasoning/argument in the textbook and show me you can apply concepts from class. You may want to give an example to...
As a Human Resources manager for a mid-sized company in your area, you have been tasked...
As a Human Resources manager for a mid-sized company in your area, you have been tasked with purchasing the best group health insurance for your organization. Analyze at least two (2) lifestyle choices relative to the effect(s) that these choices could have on the organization’s premiums. Support your rationale with two (2) health economic examples. Debate It: Take a position that the full implementation of the Affordable Care Act in 2014 will or will not create a market failure for...
Assume you have been tasked to explain the need for Group Policy in your organization. Describe...
Assume you have been tasked to explain the need for Group Policy in your organization. Describe how your organization (or any organization about which you have knowledge) can benefit from implementing Group Policy. Provide examples and elaboration in your answer. What are some best practices to consider when implementing Group Policy?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT