Question

In: Finance

Case Study: Assume that the company, where you are working as a team in Financial Department,...

Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 650 000 unit per year at this price for a period of 4 years. Launching this project will require purchase of a $3 500 000 equipment that has residual value in four years of $500 000 and adding $ 850 000 in working capital which is expected to be fully retrieved at the end of the project. Other information is available below: Depreciation method: straight line Variable cost per unit: $17 Cash fixed costs per year: $450 000 Discount rate: 10% Tax Rate: 30% Do a scenario analysis with cash flows of the assumed project to determine the sensitivity of the project’s NPV to different scenarios that are defined in terms of the estimated values for each of the project’s value drivers. Please work on two scenarios corresponding to the worst- and best-case outcomes for the project. You need to provide your results in (a) relevant tables: Worst case: Unit sales decrease by 20%; price per unit decreases by 20%; variable cost per unit increases by 20 %; cash fixed cost per year increases by $100 000 Best case: Unit sales increase by 20%; price per unit increases by 20%; variable cost per unit decreases by 20%; cash fixed cost per year decreases by $100 000 Based on the scenario analysis outcome, draw relevant conclusion about project NPV’s sensitivity.

Solutions

Expert Solution

ProjecInitial investment = Equipment Cost + working capital = 3,500,000 + 850,000 =  4,350,000

Terminal cash flow = Post tax salvage value + release of working capital = 500,000 x (1 - 30%) + 850,000 = 1,200,000

Please see the table below. All financials are in $. Please see the second column to understand the mathematics. The last row colored in yellow contains your answer.

Linkage Base Case Worst Case Best Case
Initial investment A        4,350,000         4,350,000            4,350,000
Life B                  4.00                   4.00                     4.00
Sale Price per unit C                22.00 22 x (1 - 20%) = 17.60 22 x (1 + 20%) = 26.40
Sale volume D           650,000 650,000 x (1 - 20%) = 520,000 650,000 x (1 + 20%) = 780,000
Variable cost per unit E                17.00 17.00 x (1 + 20%) = 20.40 17.00 x (1 - 20%) = 16.32
Cash fixed cost F           450,000 450,000 + 100,000 = 550,000 450,000 - 100,000 = 350,000
Annual depreciation G = 3,500,000/B           875,000            875,000               875,000
EBIT H = (C - E) x D - F - G        1,925,000        -2,881,000            6,637,400
Taxes I = H x 30%           577,500           -864,300            1,991,220
NOPAT J = H - I        1,347,500        -2,016,700            4,646,180
OCF K = J + G        2,222,500        -1,141,700            5,521,180
Terminal Cash flows L        1,200,000         1,200,000            1,200,000
Discount rate M 10% 10% 10%
NPV '=-PV(M,B,K,L)-A 3,514,642.10 -7,149,419.23    13,971,013.85

Project's NPV is highly sensitive to the operating parameters such as sales price, sales volume, variable cost per unit and fixed cost. In the worst cse scenario, the project has a negative NPV.


Related Solutions

Case Study: Assume that the company, where you are working as a team in Financial Department,...
Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 650 000 unit per year at this price for a period of 4 years. Launching this project will require purchase of a $3 500 000 equipment that has residual value in four years of $500...
Case Study: Assume that the company, where you are working as ateam in Financial Department,...
Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 650 000 unit per year at this price for a period of 4 years. Launching this project will require purchase of a $3 500 000 equipment that has residual value in four years of $500...
Assume you are a new manager in the Financial Analysis department and are orienting a team...
Assume you are a new manager in the Financial Analysis department and are orienting a team of new college graduates to the world of capital budgeting. In your initial post, explain the uses of the common capital budgeting tools to them. Explain what they are, and how you use them in your daily tasks. Make sure to explain any financial terminology
. Assume you are working for the US government. The president wants your department to study...
. Assume you are working for the US government. The president wants your department to study the clothing market. The US governments need to raise revenues from the Clothing market, and you are assigned to study the cotton shirt market. You have access to the previous data: - If P = 20 then ???? = 80. If P = 30 then ???? = 70. - If P = 20 then ???? = 25. If P= 30 then ???? = 40....
Assume you are working for the US government. The president wants your department to study the...
Assume you are working for the US government. The president wants your department to study the clothing market. The US governments need to raise revenues from the Clothing market, and you are assigned to study the cotton shirt market. You have access to the previous data: - If P = 20 then ???? = 80. If P = 30 then ???? = 70. - If P = 20 then ???? = 25. If P= 30 then ???? = 40. The...
Case study background Assume that you are a graduate accountant working for Tucker and associates a...
Case study background Assume that you are a graduate accountant working for Tucker and associates a public accounting firm situated at 55 York Street, Sydney, NSW 2000. The manager of your firm, Mr Adam Tucker has asked you to draft a letter in response to an email received from a client – Joe Black, the managing director of Sotoma Pty Ltd, raising a few accounting issues regarding his company – see the copy of the email on the next page....
Assume that you are working for the Ministry of Health in the geriatric department. The department...
Assume that you are working for the Ministry of Health in the geriatric department. The department is planning to create a specific geriatric care model for older adults to meet their needs and enable them to be healthy while they are aging. Your supervisor asks you to address one of the common geriatric syndromes to be used in that model. 1. What is the geriatric syndrome that you are going to address? 2. Explain your approach/policy that you will use...
(35 marks) Q5. Case Study: Assume that are the financial manager of a company, which is...
Q5. Case Study: Assume that are the financial manager of a company, which is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 350 000 unit per year at this price for a period of 4 years. Launching this project will require purchase of a $2 000 000 equipment that has residual value in four years of $200 000 and adding...
Assume that you are part of a development team that is working on a new warehouse...
Assume that you are part of a development team that is working on a new warehouse management system. You have the task of investigating software packages that are available through ASPs. Using the World Wide Web, identify at least two potential sources of such software. What are the pros and cons of this approach to obtaining a software package? Write in complete sentences. The answer may not exceed 100 words.
Case Study Baseball Team Manager For this case study, you’ll use the programming skills that you...
Case Study Baseball Team Manager For this case study, you’ll use the programming skills that you learn in Murach’s Python Programming to develop a program that helps a person manage a baseball team. This program stores the data for each player on the team, and it also lets the manager set a starting lineup for each game. After you read chapter 2, you can develop a simple program that calculates the batting average for a player. Then, after you complete...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT