Determine the annual net cash flows from the project

Reference no: EM131970199

Question: Southeastern Freight Lines (SFL), as the name suggests, is a less-than-truckload freight-hauling firm that works in the Southeastern United States as well as Puerto Rico and the U.S. Virgin Islands. This family owned company is considering the installation of a two-way mobile satellite messaging service on its 1,500 trucks. A pilot test conducted on 150 trucks by the company last year found that satellite messaging could cut 60% of its $5 million bill for long-distance communications with truck drivers. Moreover, because of this system the drivers reduced the number of "deadhead" miles-those driven without paying loads-by 0.5%. Applying that improvement to all 230 million miles covered by the SFL fleet each year would produce an extra $1.25 million in savings.

Equipping all 1,500 trucks with the satellite hookup will require an investment of $8 million and the construction of a message-relaying system costing $2 million. The equipment and on-board devices will have a service life of eight years and negligible salvage value; they will be depreciated under the five-year MACRS class. SFL's marginal tax rate is about 38%, and its required minimum attractive rate of return is 18%.

a) Determine the annual net cash flows from the project and make a decision regarding the attractiveness of the project based on the project's NPV.

b) Perform a sensitivity analysis by varying savings in the telephone bill to determine the resultant impact on the project's NPV. Assume that the telephone bill savings can deviate from its base-case expected value by +/-10 %, +/-20%, and +/-30%. Interpret the results of your sensitivity analysis.

c) Perform a scenario analysis on the project's NPV by comparing the base case to the following two scenarios then interpret the results:

	Worst Case Scenario	Best Case Scenario
Savings in the Telephone Bill	-30%	+30%
Savings in Deadhead Miles	-20%	+30%
Tax Rate	45%	25%

d) Assume that there is a 25% chance that the worst case scenario will occur, a 15% chance that the best case scenario will occur, and a 60% chance that the original (or base case) scenario will occur. What is the expected NPV and the associated measure of risk?

e) Use the Certainty Equivalent Method (CEM) to take into account the risk associated with the project assuming the same three scenarios used in part c). Assume that the risk free rate is 5% and the following certainty equivalent coefficients:

	COV	1	2	3	4	5	6	7	8
1	<= 0.1	0.95	0.92	0.89	0.85	0.80	0.75	0.70	0.64
2	0.1 < COV <= 0.2	0.90	0.85	0.82	0.75	0.70	0.65	0.60	0.54
3	>0.2	0.80	0.85	0.75	0.70	0.65	0.60	0.55	0.49

Use the project financials model that you developed in part a) to fill out the cash flows for each scenario in order to conduct your analysis using the CEM.

Outcome	Probability	CF0	CF1	CF2	CF3	CF4	CF5	CF6	CF7	CF8
Base	60%
Worst	25%
Best	15%

Reference no: EM131970199

Questions Cloud

How to produce and for whom to produce : Why do people strive to maximise income and wealth rather than happiness. Can we maximise happiness?

Analyze the american public health association : Under the AHPA Communities tab, review the sections and related disciplines under the "Member sections" and "State Affiliates".

What is the size of the physical memory : What type of memory, virtual or physical, is exhausted when there is a memory leak problem with a process - How much memory has the program used when reaching

Decline with the rest of us employment : Using theory discussed in this course, explain WHY the health care industry did not decline with the rest of U.S. employment.

Determine the annual net cash flows from the project : Determine the annual net cash flows from the project and make a decision regarding the attractiveness of the project based on the project's NPV.

What is difference between present value : What is difference between Present Value and the future value of an asset?

Determining the amount of radioactive isotopes : Determining the amount of radioactive isotopes in a geological or archeological specimen can help decipher its relative age.

Confidence interval for the population mean weight : A sample of 25 items yields X ¯ = 50.0 grams and s = 2.5 grams. Assuming a normal distribution, construct a 99 percent confidence interval for the population me

How should you make the necessary tradeoffs : If there are lots of workers like you, where will the apartments be relatively more expensive? How will you choose where to live?

User Account

All Pages