Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 divisions return on investment (ROI), which has exceeded 25% each of the last three years. He has computed the cost and revenue estimates for each product as follows:
Product A Product B $330,000 $ 525,000 Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs $380,000 $172,000 $ 66,000 $ 83,000 $ 480,000 $ 222,000 $ 105,000 $ 63,000 The company's discount rate is 17%. Use Excel or a financial calculator to solve any time value of money problems. Required: 1. Calculate the payback period for each product. (Round your answers to 2 decimal places.) Product A years Product B years Payback period 2. Calculate the net present value for each product. (Round answers to the nearest dollar.) Product A Product B Net present value 3. Calculate the project profitability index for each product. (Round your answers to 2 decimal places.) Product A Product B Project profitability index 4. Calculate the simple rate of return for each product. (Round percentage answer to 1 decimal place. i.e. 0.1234 should be considered as 12.3%.) Product A % Product B % Simple rate of return 5a. For each measure, identify whether Product A or Product B is preferred. Net Present Profitability Value Index Payback Period 5b. Based on the simple rate of return, Lou Barlow would likely: Accept Product A Accept Product B Reject both products
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started