Determine the annual net cash flows from the project

Assignment Help Accounting Basics
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?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd