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

  The present annual dividend is 270 and the required return

wells engineering issued preferred stock about two years ago. the present annual dividend is 2.70 and the required

  List the three ratios that combine to form the dupont

1. list the three ratios that combine to form the dupont framework. also list the formulas used to compute each

  All market imperfections except personal taxes on dividends

10. Payout Policy. Constancash, Inc. is expected to pay dividends of $2.20 per year for the next ten years, with the first cash flow occurring immediately. (That is, there will be a total of eleven cash flows over the next ten years.) The fair rate o..

  How could accurate balance sheet and income statement

how could accurate balance sheet and income statement information be used along with other information to make a

  Estimate the internal rate of return for the machine

If the project's cost of capital is 10 percent, would you recommend buying the machine? d. Estimate the internal rate of return for the machine.

  Bottleneck identification and management

Perma-clear Glass Corporation was founded in 1980 by Rob Samson and enjoyed rapid growth as demand for new create materials exceeded supply.

  Google-initial public offering

Pick an Initial Public Offering (or a Secondary Offering) completed in the last ten years in U.S. capital markets, and discuss and examine this IPO.

  Compute depreciation expense for the fourth year

Assume Kathleen's computed depreciation expense of $140,000 per year. After three years, Kathleen's determined that the machine would last eight more years (for a total of 11 years). Compute depreciation expense for the fourth year.

  Discuss the concept of risk and how it might be measured

question 1 discuss the concept of risk and how it might be measured. explain how the concept of risk can be

  If the appropriate market rate for investments similar to

laserclok corporation paid a dividend for 50 years until it experienced financial difficulty three years ago at which

  Income statement preparation by absorption

Income statement preparation by Absorption, Variable Costing and Updike Inc. has the following information for its product

  1 the purtell animal welfare society paws boards stray

1. the purtell animal welfare society paws boards stray animals.nbsp they also provide veterinary checkups to ensure

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