Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664870944a341_44366487093dcafd.jpg)
Transcribed Image Text:
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: Product A Product B Cost of equipment (zero salvage value) $ 310,000 $ 510,000 Annual revenues and costs: Sales revenues Variable expenses Depreciation expense $ 360,000 $ 460,000 $ 164,000 $ 214,000 $ 62,000 $ 102,000 81,000 $ 65,000 Fixed out-of-pocket operating costs $ The company's discount rate is 18%. Required (Use Excel for 2-4): 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. 6a. For each measure, identify whether Product A or Product B is preferred. Complete this question by entering your answers in the tabs below. Req 1 Reg 2 Req 3 Req 4 Req 6A Using Excel, calculate the net present value for each product. (Round your final answers to the nearest whole dollar amount.) Product A Product B Net present value < Req 1 Req 3 > 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: Product A Product B Cost of equipment (zero salvage value) $ 310,000 $ 510,000 Annual revenues and costs: Sales revenues Variable expenses Depreciation expense $ 360,000 $ 460,000 $ 164,000 $ 214,000 $ 62,000 $ 102,000 81,000 $ 65,000 Fixed out-of-pocket operating costs $ The company's discount rate is 18%. Required (Use Excel for 2-4): 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. 6a. For each measure, identify whether Product A or Product B is preferred. Complete this question by entering your answers in the tabs below. Req 1 Reg 2 Req 3 Req 4 Req 6A Using Excel, calculate the net present value for each product. (Round your final answers to the nearest whole dollar amount.) Product A Product B Net present value < Req 1 Req 3 >
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Using quarterly data for 10 years, the regression results are given in the following table where CAR = number of new car sales per thousand population, PRICE = new car price index, INC= per-capita...
-
Why are software objects more reusable than other types of computer code?
-
Barry has recently been assigned to a project team that will be developing a new retail store management system for a chain of submarine sandwich shops. Barry has several years of experience in...
-
Derive the equation that is equivalent to Eqs. (15-32b) and (15-32c) in terms of a partial pressure driving force and a \(\log\) mean partial pressure difference: \[ \begin{equation*}...
-
After retiring as a physician, Bob Guthrie became an avid downhill skier on the steep slopes of the Utah Rocky Mountains. As an amateur inventor, Bob was always looking for something new. With the...
-
What is the purpose of the Low-Income Retirement Plan Contribution Credit? a. To encourage taxpayers to participate in retirement plans b. To increase the amount of taxpayers' Social Security...
-
1. What are the 2 elements in developing a professional brand? Provide personal examples for each that could be beneficial in building your own professional brand. 2. Pick one of the elements of...
-
How can incumbent companies protect themselves against new, international technology disruptors?
-
2. This experiment used a computer to integrate the area under each peak in order to determine the relative amounts of each component in the mixture. If a computer is not available, we can estimate...
-
The BLA must be satisfied that granting permission will not be contrary to the public interest. Set out in detail why granting permission to you or the company would not be contrary to the public...
-
NYI Corporation manufactures decorative window glass in two sequential departments. These data pertain to the month of August: Department 1 Direct Materials used for production Department 2 $ 5 5 , 0...
-
Thinking about the theory of Dynamic Systems (different domains of development interact with each other), can you explain how multiple domains would interact while a toddler learns to walk? Explain...
-
A company has the following Capital Structure: Ordinary $10 shares authorized: 1,000,000, of which 800,000 are issued. 100,000 $20 Preference shares issued and $5,000,000 Bonds at 5% interest The...
-
Continuation of Exercise 4-83. (a) What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? (b) What is the probability that there are no major...
-
The following data (and annotations) are for Nelson Company's processing department work-in-process account for the month of September 2019: Nelson uses the weighted average method. Materials are...
-
Terrace Corporation makes an industrial cleaner in two sequential departments, Compounding and Drying. All materials are added at the beginning of the process in the Compounding Department....
-
Cost Flows Through Journal Entries The Mixing Department performs a series of processes in which a fluid chemical is concentrated. Records indicate that the Mixing Department has been charged with...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App