Assignment 2: Finance Capital Budgeting Case (30%) Drill Maker Sdn Bhd has developed a new hand...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assignment 2: Finance Capital Budgeting Case (30%) Drill Maker Sdn Bhd has developed a new hand drill that would be used for woodwork and carpentry activities. It would cost RM1 million to buy the equipment necessary to manufacture the drills, and it would require and initial net operating working capital equal to 10% of year 1 sales. The project would have a life of 5 years. If the project is undertaken, it will be discontinued at the end of the 5 years. The firm believes it could sell 6,500 units per year. The drills would sell for RM250 per unit, and variable costs would amount to RM180 per unit. The company's fixed costs would be RM100,000 at Year 1 and would increase with inflation. After the first year the sales price and variable costs will also increase at the inflation rate of 3%. The annual Net Operating Working Capital (NOWC) will be 15% of next year sales. Accordingly, Year 1 NOWC will be based on Year 2 Sales, respectively. All NOWC will be recovered at end of Year 5. The equipment would be depreciated over a 5-year period, using the straight-line method. The salvage value of the equipment at the end of the project's 5-year life is RM50,000. The company however estimated the machine can be sold for RM60,000. The corporate tax rate is 25%. The project's returns are expected to be highly correlated with returns on the firm's other assets. The cost of capital is 12%. a. Prepare a spreadsheet cash flow analysis of the project. b. Calculate the project's NPV, IRR, and payback from the spreadsheet in part a. c. Conduct a sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, number of units sold, the variable costs per unit, fixed costs and the cost of capital. Set these variables' values at 20% above and 20% below their base-case values. Include a graph in your analysis. d. Conduct a scenario analysis. Assume the following scenarios. • Scenario 1: Best-case condition the sales price increase by 10%, number of units sold 7,000 units, variable costs per unit and fixed cost increase 5% from the original base- case value. • Scenario 2: Worst-case condition, with increase in the variable and fixed cost by 25% and with no change in the unit sales and unit price from the base value. • Calculate the Expected NPV, the Standard Deviation of the NPV and the project's coefficient of variation? The best-case scenario and the base case each have a 40% probability while the worst case has a 30% probability. e. On the basis of your analysis, would you recommend that the project be accepted? What added advise and special attention would you give for the company with regard to the project? 1 Year 2 Initial Cost 3 4 5 Sales 6 Variable cost per unit 7 Variable cost Fixed Cost Depreciation 8 68 Units Sold Price per unit 9 10 Operating Profit Before Tax Tax (25%) 11 12 Operating Profit After Tax Net Working Capital (NWC) 13 14 Change in NWC 15 Terminal Value 16 Tax on Terminal Value 17 Cash Flow 18 Present Value Cost of Capital Present Value Cash Flow 19 20 Net Present Value (NPV) 0 1 2 3 4 5 Assignment 2: Finance Capital Budgeting Case (30%) Drill Maker Sdn Bhd has developed a new hand drill that would be used for woodwork and carpentry activities. It would cost RM1 million to buy the equipment necessary to manufacture the drills, and it would require and initial net operating working capital equal to 10% of year 1 sales. The project would have a life of 5 years. If the project is undertaken, it will be discontinued at the end of the 5 years. The firm believes it could sell 6,500 units per year. The drills would sell for RM250 per unit, and variable costs would amount to RM180 per unit. The company's fixed costs would be RM100,000 at Year 1 and would increase with inflation. After the first year the sales price and variable costs will also increase at the inflation rate of 3%. The annual Net Operating Working Capital (NOWC) will be 15% of next year sales. Accordingly, Year 1 NOWC will be based on Year 2 Sales, respectively. All NOWC will be recovered at end of Year 5. The equipment would be depreciated over a 5-year period, using the straight-line method. The salvage value of the equipment at the end of the project's 5-year life is RM50,000. The company however estimated the machine can be sold for RM60,000. The corporate tax rate is 25%. The project's returns are expected to be highly correlated with returns on the firm's other assets. The cost of capital is 12%. a. Prepare a spreadsheet cash flow analysis of the project. b. Calculate the project's NPV, IRR, and payback from the spreadsheet in part a. c. Conduct a sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, number of units sold, the variable costs per unit, fixed costs and the cost of capital. Set these variables' values at 20% above and 20% below their base-case values. Include a graph in your analysis. d. Conduct a scenario analysis. Assume the following scenarios. • Scenario 1: Best-case condition the sales price increase by 10%, number of units sold 7,000 units, variable costs per unit and fixed cost increase 5% from the original base- case value. • Scenario 2: Worst-case condition, with increase in the variable and fixed cost by 25% and with no change in the unit sales and unit price from the base value. • Calculate the Expected NPV, the Standard Deviation of the NPV and the project's coefficient of variation? The best-case scenario and the base case each have a 40% probability while the worst case has a 30% probability. e. On the basis of your analysis, would you recommend that the project be accepted? What added advise and special attention would you give for the company with regard to the project? 1 Year 2 Initial Cost 3 4 5 Sales 6 Variable cost per unit 7 Variable cost Fixed Cost Depreciation 8 68 Units Sold Price per unit 9 10 Operating Profit Before Tax Tax (25%) 11 12 Operating Profit After Tax Net Working Capital (NWC) 13 14 Change in NWC 15 Terminal Value 16 Tax on Terminal Value 17 Cash Flow 18 Present Value Cost of Capital Present Value Cash Flow 19 20 Net Present Value (NPV) 0 1 2 3 4 5
Expert Answer:
Answer rating: 100% (QA)
a Spreadsheet cash flow analysis of the project Year 0 1 2 3 4 5 Sales 162500000 167375000 172379875 177519766 182799830 VC 117000000 120410000 123842300 127317669 130826900 FC 1m 10200000 10506000 10... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Review the summarized consolidated statement of income for the manufacturing company whose data is shown here. Use graphics software to prepare a set of bar charts that shows the data for this year...
-
The consolidated statement of income for Ford Motor Company appears below. Net income/(loss) attributable to ford motor company Amounts per share attributable to ford motor company common and class B...
-
On its statement of income for a recent year, Air Canada reported a net loss of $249 million. On its statement of cash flows, it reported $586 million of cash inflows from operating activities....
-
Read the case study of Ritz Carlton Company USA and discuss why and how you would transfer some of their methods to the operation of a non-accommodation component in an integrated resort complex.
-
Make a substitution to express the integrand as a rational function and then evaluate the integral. a. (x+1)/x dx b. dx/(x2+xx
-
Product X is sold for $500 per unit. The total cost of production per year, including capital recovery and a return, is given by the expression TC 0:04n3 700n 50,000 where n is the number of units...
-
Using the material properties from Problem 4.3 and assuming that the stiffnesses are the same in tension and compression, determine the allowable off-axis shear stress, \(\tau_{x y}\) at...
-
The following data were extracted from the accounting records of Meniscus Company for the year ended June 30, 2008: Merchandise inventory, July 1, 2007 . . . . . . . . . . . . $ 183,250 Merchandise...
-
A solenoid has N turns of area A distributed uniformly along its length. When the current in this solenoid increases at the rate of 2.0 A/s, an induced emf of 75 mV is observed. Suppose the spacing...
-
11. The cost of manufacturing goods is made up of wages, materials and overheads in the ratio 5:3:2 respectively. If the overheads amount to $4,000 for the week, find the total cost of production...
-
Develop a scenario based on the proposition that hydrogen-fueled cars will continue to improve and take 15 percent of the automotive market in a few years. Analyze it from the point of view of an...
-
This question also relates to extended trial balances. From the following trial balance of John Brown, store owner, prepare an income statement for the year ending 31 December 2013, and a statement...
-
The following trial balance was extracted from the books of R. Giggs at the close of business on 28 February 2010. Notes: (a) Inventory 28 February 2010 2,400. (b) Wages and salaries accrued at 28...
-
Distinguish between cost-benefi t analysis (CBA) and cost-effectiveness analysis (CEA). Can CEA replace CBA in all cases? If not, why not?
-
If it makes sense that one type of labor can substitute for another in production, how can capital, a physical object, substitute for labor, a human being?
-
The School's IT director has requested bids for 200 desktop computers for the computer labs. He has asked for separate bids for price and warranty cost per year for 3 years, which will be paid at the...
-
Dawson Companys balance sheet information at the end of 2019 and 2020 is as follows: Additional information: The company did not issue any common stock during 2020. Required : Next Level Fill in the...
-
On January 1, 2015, Standard Co. bought 40% of the outstanding common stock of Exchange Corp. for $380,000 cash. Standard Co. accounts for this investment by the equity method. At the date of...
-
Comparative income statements for South Drive Company for Year 2 and Year 1 are given below. 1. Prepare a common-size income statement for Year 1 and Year 2. 2. Return on sales for South Drive is...
-
Anakin, Inc., provides the following account balances for 2015 and 2014: Using the format presented in the chapter, prepare the Operating Activities section of the statement of cash flows and present...
-
An amorphous material is: (a) Mica (b) Lead (c) Rubber (d) Glass
-
Discuss the application vernier caliper and its method of measurement.
-
In center lathe, cutting tool is fed in ____ directions with reference to the lathe axis.
Study smarter with the SolutionInn App