Oo.32.Subject:- Account 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 thelast 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 revenuesVariable expensesDepreciation expenseFixed out-of-pocket operating costsThe company's discount rate is 18%.Required (Use Excel for 2-4):1. Calculate the payback period for each product2. Calculate the net present value for each product3. Calculate the internal rate of return for each productReq 1Req 2Payback period4. Calculate the profitability Index for each product6a. For each measure, Identify whether Product A or Product B is preferred.Complete this question by entering your answers in the tabs below.Req 3Product AProduct AReq 4years$ 260,000$ 310,000$ 144,000$ 52,000$ 76,000Product ByearsCalculate the payback period for each product. (Round your answers to 2 decimal places.)Product B$ 470,000$ 410,000$ 194,000$ 94,000$ 58,000Req 6AReg 2 >

Capital budgeting is to find investment possibilities that can yield a profit, add value to the…

Answered: Lou Barlow, a divisional manager for…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

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 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…
QLou 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%. 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. Product A $170,000 Product B $380,000 $250,000 $350,000 $120,000 $170,000 $34,000 $76,000 $70,000 $50,000
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…
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…
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 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…
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…
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 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…
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 22% 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 Product A Required: 1. Calculate the payback period for each product. 2. Calculate the net present value for each product. Product B $ 350,000 $ 390,000 178,000 $ $ 70,000 $ $ 550,000 $ 470,000 $ 210,000 $ 110,000 87,000 $ 67,000 The company's discount rate is 20%. Click here to view Exhibit 7B-1 and Exhibit 7B-2, to determine the appropriate discount factor using tables. 3. Calculate the internal rate of return for each product. 4. Calculate the project…
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: Product A Product B Initial Investment Cost of equipment (salvage value) 170000 380000 Annual revenues and costs Sales revenue 250000 350000 Variable expenses 120000 170000 Depreciation expense 34000 76000 Fixed out-of-pocket operating costs 70000 50000 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. 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…
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: 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…
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 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 years
Calculate the internal rate of return for each product. (Round your answers to 1 decimal place i.e as 12.3%.) Product Product A

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS