Comprehensive Problem -
Lou Barlow, a divisional manger for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his divisions
The company’s discount rate is 16%.
Required:
1. Calculate the payback period for each product.
2. Calculate the
3. Calculate the
4. Calculate the project profitability index for each product.
5. Calculate the simple rate of return for each product.
6. Which of the two products should Louts division pursue? Why?
Want to see the full answer?
Check out a sample textbook solutionChapter 12 Solutions
Introduction To Managerial Accounting
- 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. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 18% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs The company's discount rate is 16%. Product A Product B $ 170,000 $ 380,000 $ 250,000 $ 350,000 $ 120,000 $ 34,000 $ 70,000 $ 170,000 $ 76,000 $ 50,000 Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor using tables. 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…arrow_forwardLou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 19% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs Req 1 Req 2 Complete this question by entering your answers in the tabs below. The company's discount rate is 16%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor using tables. Req 3 Internal rate of return 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…arrow_forwardLou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs Req 1 The company's discount rate is 15%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor using tables. Complete this question by entering your answers in the tabs below. 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. 5. Calculate the…arrow_forward
- 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. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 20% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product B Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs Req 1 The company's discount rate is 14% Click here to view Exhibit 128-1 and Exhibit 12B-2, to determine the appropriate discount factor using tables. Complete this question by entering your answers in the tabs below. Req 2 Product A 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…arrow_forwardLou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 19% each of the ast three years. He has computed the cost and revenue estimates for each product as follows: Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs The company's discount rate is 17%. Required (Use Excel for 2-4): 1. Calculate the payback period for each product. 2. Calculate the net present value for each product. Product A $ 190,000 $ 270,000 $ 128,000 $ $ Product B $ 400,000 $ 370,000 $ 178,000 38,000 $ 80,000 72,000 $ 52,000 3. Calculate the internal rate of return for each product. 4. Calculate the profitability index for each product. 6a. For each measure, identify whether Product A or Product B is…arrow_forwardLou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 19% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs The company's discount rate is 16%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor using tables. $ 180,000 $ 270,000 $ 130,000 Product B $ 44,000 $ 80,000 $ 390,000 $360,000 $ 180,000 $ 86,000 $ 60,000 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…arrow_forward
- 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. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 17% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs $ 176,600 $ 260,000 $ 124,000 $ 36,000 $ 71,000 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. 5. Calculate the simple rate of return for each product. Product B $ 390,000 $360,000 $ 174,000 $ 78,000 $ 50,000 The company's discount rate is 15%. Click here to view Exhibit 128-1…arrow_forwardLou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 18% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: $ 170,000 $ 380,000 Sales revenues Variable expenses $350,000 $ 250,000 $ 120,000 $ 170,000 Depreciation expense $ 34,000 $ 76,000 Fixed out-of-pocket operating costs $ 70,000 $ 50,000 The company's discount rate is 15% Click here to view Exhibit 148-1 and Exhibit 148-2, to determine the appropriate discount factor using tables 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…arrow_forwardLou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 20% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: $250,000 $. 460,000 $300,000 $400,000 Sales revenues 190,000 $ 140,000 $ 39,000 Variable expenses $ 81,000 Depreciation expense Fixed out-of-pocket operating $ 75,000 $55,000 costs The company's discount rate is 18%. Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor using tables. Required: Calculate the payback period for each product. (Round your answers to 2 decimal 1. places.) Product A Product B Payback period 2.94 years 2.97 yearsarrow_forward
- 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. His annual pay raises are determined by his division's return on investment (ROI). which has exceeded 21% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: $ 210,000 $ 420,000 $ 290,000 $ 138,000 $ 42,000 $ 74,000 $ 390, 080 $ 186,000 $ 84,000 $ 54,000 Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs The company's discount rate is 19%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor using tables. Requlred: 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 project…arrow_forwardLou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 22% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: $ 380,000 $ 575, 00e Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs $ 418,800 $ 186,800 76,000 $ 89,000 $ 498,00e $ 218,080 $ 115,000 $ 78,000 The company's discount rate is 20%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor using tables. 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 project…arrow_forwardCalculate the internal rate of return for each product. (Round your answers to 1 decimal place i.e as 12.3%.) Product Product Aarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education