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....
(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 49: Musculoskeletal Scenario You are working in the emergency department when M.C., an 82-year-old...
Case Study 49: Musculoskeletal Scenario You are working in the emergency department when M.C., an 82-year-old widow, arrives by ambulance. Because M.C. had not answered her phone since noon yesterday, her daughter went to her home to check on her. She found M.C. lying on the kitchen floor, incontinent of urine and stool, and stating she had pain in her right hip. Her daughter reports a medical history of hypertension, angina, and osteoporosis. M.C. takes propranolol (Inderal), denosumab (Prolia), and...
Assume you are working on budgeting for the room department of your hotel. Assume the hotel’s...
Assume you are working on budgeting for the room department of your hotel. Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2016. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year. Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $250,000 during 2016. For 2017, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2016. Assume the ‘Salaries’ expenses...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT