Calculate the change in ebit taxes and depreciation

Assignment Help Finance Basics
Reference no: EM13779808

It's been 2 months since you took a position as an assistant financial analyst at Caledonia Products. Although your boss has been pleased with your work, he is still a bit hesitant about unleashing you without supervision. Your next assignment involves both the calculation of the cash flows associated with a new investment under consideration and the evaluation of several mutually exclusive projects. Given your lack of tenure at Caledonia, you have been asked not only to provide a recommendation but also to respond to a number of questions aimed at judging your understanding of the capital-budgeting process. The memorandum you received outlining your assignment follows:

We are considering the introduction of a new product. Currently we are in the 34 percent marginal tax bracket with a 15 percent required rate of return or cost of capital. This project is expected to last 5 years and then, because this is somewhat of a fad product, be terminated. The following information describes the new project: Cost of new plant and equipment $7,900,000   Shipping and installation costs $ 100,000 Unit sales       YEAR UNITS SOLD            1 70,000          2 120,000          3 140,000          4 80,000          5 60,000    Sales price per unit $300/unit in years 1 through 4, $260/unit in year 5 Variable cost per unit $180/unit Annual fixed costs $200,000 Working-capital requirements There will be an initial working-capital requirement of $100,000 just to get production started. For each year, the total investment in net working capital will be equal to 10 percent of the dollar value of sales for that year. Thus, the investment in working capital will increase during years 1 through 3, then decrease in year 4. Finally, all working capital is liquidated at the termination of the project at the end of year 5. The depreciation method Use the simplified straight-line method over 5 years. Assume that the plant and equipment will have no salvage value after 5 years. a. Should Caledonia focus on cash flows or accounting profits in making its capital-budgeting decisions? Should the company be interested in incremental cash flows, incremental profits, total free cash flows, or total profits? b. How does depreciation affect free cash flows? c. How do sunk costs affect the determination of cash flows? d. What is the project's initial outlay? e. What are the differential cash flows over the project's life? f. What is the terminal cash flow? g. Draw a cash flow diagram for this project. h. What is its net present value? i. What is its internal rate of return? j. Should the project be accepted? Why or why not? k. In capital budgeting, risk can be measured from three perspectives. What are those three measures of a project's risk? l. According to the CAPM, which measurement of a project's risk is relevant? What complications does reality introduce into the CAPM view of risk, and what does that mean for our view of the relevant measure of a project's risk? m. Explain how simulation works. What is the value in using a simulation approach? n. What is sensitivity analysis and what is its purpose? (Keown. Foundations of Finance: The Logic and Practice of Financial Management, 6th Edition. Pearson Learning Solutions 14.15).

a. We focus on free cash flows rather than accounting profits because these are the flows that the firm receives and can reinvest.  Only by examining cash flows are we able to correctly analyze the timing of the benefit or cost.  Also, we are only interested in these cash flows on an after-tax basis as only those flows are available to the shareholder.  In addition, it is only the incremental cash flows that interest us, because, looking at the project from the point of the company as a whole, the incremental cash flows are the marginal benefits from the project and, as such, are the increased value to the firm from accepting the project.

b. Although depreciation is not a cash flow item, it does affect the level of the differential cash flows over the project's life because of its effect on taxes.  Depreciation is an expense item and, the more depreciation incurred, the larger are expenses.  Thus, accounting profits become lower and in turn, so do taxes which are a cash flow item.

c. When evaluating a capital budgeting proposal, sunk costs are ignored.  We are interested in only the incremental after-tax cash flows, or free cash flows, to the company as a whole.  Regardless of the decision made on the investment at hand, the sunk costs will have already occurred, which means these are not incremental cash flows.  Hence, they are irrelevant.

Section I. Calculate the change in EBIT, Taxes, and Depreciation (this become an input in the calculation of Operating Cash Flow in Section II).

Year

0

1

2

3

4

5

 

Units Sold

 

70,000

120,000

140,000

80,000

60,000

Sale Price

 

$300

$300

$300

$300

$260

 

MINI CASE

         

 

 

 

 

 

       

 

 

D)

   

 

     

 

 

DATA

           

 

 

Coxt of plant and equipment

79,00,000

       

 

 

Shipping and installation

1,00,000

       

 

 

Tax rate

 

34%

       

 

 

Required rate of return

15%

       

 

 

Sales Price per unit (yrs 1-4)

300

       

 

 

Sales Price per unit (yr 5)

260

       

 

 

Variable cost per unit

180

       

 

 

Annual fixed cost

2,00,000

       

 

 

Depreciation life

5

       

 

 

             

 

 

Section 1:  Calculate EBIT

         

 

 

Year

   

1

2

3

4

 

 

Units Sold

 

70,000

1,20,000

1,40,000

80,000

 

 

             

 

 

Sales Revenue

         

 

 

Less: Variable Costs

         

 

 

Less: Fixed Costs

         

 

 

Equals: EBDIT

         

 

 

Less: Depreciation

         

 

 

Equals: EBIT

         

 

 

Taxes

           

 

 

             

 

 

Section 2:  Calculate Operating Cash Flow

     

 

 

EBIT

           

 

 

Less:  Taxes

         

 

 

Plus:  Depreciation

         

 

 

Operating Cash Flow

         

 

 

             

 

 

Section 3:  Calculate Net Working Capital

       

 

 

Revenue:

           

 

 

Initial Working Capital Requirement

       

 

 

Net Working Capital Needs:

         

 

 

Liquidation of Working Capital

         

 

 

Change in Working Capital:

         

 

 

             

 

 

Section 4:  Calculate Free Cash Flow

       

 

 

Operating Cash Flow

         

 

 

Minus: Change in Net Working Capital

       

 

 

Minus: Change in Capital Spending

       

 

 

Free Cash Flow:

Reference no: EM13779808

Questions Cloud

Evidence-based psychological interventions : According to the text, the imbalance in the diversity of clinical psychologists
Social welfare policies to contemporary issues of society : Provide solutions that are policy oriented affecting the population your are writing about.
Interpretive paper instructions : Read Numbers 14:26-35 and discuss God's vow against the Israelites (Numbers 14:28-32) explaining why it happened and the significance of a "vow" when sworn by God.
What information would be lost in such a usage : What would be the value of expressing something like the national debt in scientific notation? What information would be lost in such a usage? Is that important? Explain why or why not.
Calculate the change in ebit taxes and depreciation : It's been 2 months since you took a position as an assistant financial analyst at Caledonia Products. Although your boss has been pleased with your work, he is still a bit hesitant about unleashing you without supervision. Calculate the change in ..
Horizontal asymptote andy-intercept of the function : 1.  Use transformations to graph this function. (Do this on paper. Your teacher may ask you to turn in this graph.) Determine the domain, range, horizontal asymptote, andy-intercept of the function. (If you need to enter∞or -∞type INFINITY or -INFINI..
Domain of social work and the social justice issues : Choose two of the systems (education, work, the military, and immigration). Explain how they fit into the domain of social work and the social justice issues social workers should be aware of in these systems.
Data analytics and information governance : Health informatics professionals are responsible for promoting and maintaining data quality standards. As organizations continue to adopt information systems for managing health information, the implementation of standardized clinical vocabularies..
How many moles nh3 are needed to react with 9 mol pbo : How many moles NH3 are needed to react with 9 mol PbO - How many moles N2 are produced by the readtion of 10 mol NH3?

Reviews

Write a Review

Finance Basics Questions & Answers

  Design a needs assessment plan and identify three specific

training assessment is an important task for hr personnel. use the argosy university online library and textbooks to

  Multiple choice questions on dividend policy1nbspnbsp

multiple choice questions on dividend policy.1.nbspnbsp matrix corporation follows the residual dividend policy. in a

  What is the intrinsic value of this stock

Clayton wants to sell stock to raise capital. He plans to issue a dividend of $10.00 next year and growing at a 5% rate forever. What is the intrinsic value of this stock if the discount rate is 6%?

  Compute the bond expected rate of return

Compute the bond's expected rate of return? Determine the value of the bond to you, given your required rate of return.

  Ontario inc manufactures two products standard and enhanced

ontario inc. manufactures two products standard and enhanced and applies overhead on the basis of direct-labor hours.

  What is the cross-rate in terms of yen per pound

Suppose the Japanese yen spot exchange rate is 118 yen = $1.00, and the British pound spot exchange rate is 1 pound = $1.81.

  Maintain a minimum balance

Randy, a student, has $500 to deposit in a new checking account, but Randy knows he will not be able to maintain a minimum balance. He will not use an ATM card, but will write a large number of checks.

  What is the major advantage of fixed exchange rate system

what is the major advantage of fixed exchange rate system? why do you think countries have tried to establish various

  Which of these methods provides the most accurate

What are three methods for estimating the cost of common stock from retained earnings? Which of these methods provides the most accurate and reliable estimate?

  What is the current value of this bond

The firm has a bond issue outstanding with 15 years to maturity and a coupon rate of 8 percent, with interest paid semiannually. The required nominal rate on the debt has now risen to 12 percent. What is the current value of this bond?

  Archer daniels midland company is considering buying a new

1.archer daniels midland company is considering buying a new farm that it plans to operate for 10years. the farm will

  What is the yield to maturity on these bonds

Rockinghouse Corp. plans to issue seven-year zero coupon bonds. It has learned that these bonds will sell today at a price of $402.35. Assuming annual coupon payments, what is the yield to maturity on these bonds?

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