Sensitivity analysis-determine the after-tax cash flow

Assignment Help Business Economics

Reference no: EM13986869

Barbara's Body Shop is considering investing in a Kaizen training class. Training the entire workforce now incurs $100,000 in expenses. Improvement ideas will generate $50,000 annual income. Implementation expenses will cost $30,000 in year 1, 25,000 in year 2, decreasing by $5,000 per year until year 5. There are NO capital costs. The effective tax rate is 37%. A. Determine the after-tax cash flow for years 0 to 5, assuming annual income is $50,000 per year. B. Determine the after-tax rate-of-return for the cash flow in part A. If the company expects a 15% MARR on all investments, should it invest in the Kaizen program? C. Find the sensitivity of IRR to annual income for the following amounts.

$60,000 - optiistic

$50,000 - most likely

$40,000- pessimistic

D. Based on the sensitivity analysis, should the company invest in the Kaizen program? Why or why not? Solve on excel

Reference no: EM13986869

Questions Cloud

Compare and contrast two established personality assessments : Compare and contrast two established personality assessments discussed in the course.Include in your discussion strengths and limitations of each measure.

A college economics lecture in a classroom is : A college economics lecture in a classroom is

Arguments on the economic principles of barriers to entry : The recent merger of US Air with American Airlines received both national and local attention. The U.S. Department of Justice contested the merger on the basis that it would produce harmful monopoly-like behavior in many airline markets. Develop an a..

How does federal reserve influence the federal funds rate : What is the federal funds rate? Why is it a vital component of macroeconomics? How does the Federal Reserve influence the federal funds rate? Graphically illustrate the impact of an FOMC open market operation that aims to reduce the federal fund

Sensitivity analysis-determine the after-tax cash flow : Barbara's Body Shop is considering investing in a Kaizen training class. Training the entire workforce now incurs $100,000 in expenses. Improvement ideas will generate $50,000 annual income. Determine the after-tax cash flow for years 0 to 5, assumin..

When the production of good involves a positive externality : When the production of a good involves a positive externality, which of the following will be true?

Supply and demand equations for labor : Consider the following supply and demand equations for labor in a given industry: If a minimum wage of $8 is applied to this market, how many people will lose their jobs because of minimum wage? How many will be added to the unemployment rolls?

Example of a market failure : Which of the following is not an example of a market failure?

What should the bonds price : A 15-year municipal bond was issued 5 years ago. its coupon interest rate is 8%, interest payments are made semiannually, and its face value is $1000. if the urrent market interest rate is 12.36% what should the bonds price?

User Account

All Pages