Q12
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period He has computed the cost and revenue estimates for each product as follows: Product Products $370,000 $ 530,000 Initial investments Cost of equipment (zero salvage value) Annual revenues and costs Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs $ 400,000 $ 510,000 $ 100,000 $ 250,000 $ 74,000 $ 106,000 585,000 72,000 The company's discount rate is 19% Click here to view Exhibit 148:1 and Exhibit 148-2. to determine the appropriate discount factor using tables. This is a great review problem that reinforces the Individual concepts covered using a comprehensive example, To answer the questions, you must first calculate the annual net cash inflows as follows: Sales revenue minus variable expenses minus fixed out-of-pocket operating costs Then you will calculate the following: payback period (even flows), net present value (NPV), Internal rate of return (IRR) and profitability Index Required: Then you will calculate the following: payback period (even flows), net present value (NPV), Internal rate of return (IRR) and profitability index. Required: 1. Calculate the payback period for each product 2. Calculate the net present value for each product. 3. Calculate the internal rate of return for each product. 4. Calculate the profitability index for each product Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Req3 Reg 4 Calculate the payback period for each product. (Round your answers to 2 decimal places.) Product Products Payback period years yoans Regt Req2 nt Complete this question by entering your answers in the tabs int Req 1 Reqr2 Req3 Req 4 Calculate the net present value for each product. (Round your final answers to the Product A Product B Net present value hits Required: 1. Calculate the payback period for each product. 2. Calculate the net present value for each product. 3. Calculate the internal rate of return for each product. 4. Calculate the profitability index for each product. Complete this question by entering your answers in the tabs below. eBook Hint Print Req 1 Reg 2 Red 3 Req 4 Calculate the internal rate of return for each product. (Round your percentage answers to 1 considered as 12.3%.) Product A % Product B % Internal rate of return 4. Calculate the profitability index for each product. Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Rbq4 Calculate the profitability index for each product. (Round your answers to 2 decimal places.) Product A Product B Profitability index