View previous attempt Check my work Lou Barlow, a divisional manager for Sage Company, has an...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
View previous attempt Check my work 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: Initial investment: Annual revenues and costs: Product A Product B Cost of equipment (zero salvage value) $ 210,000 $ 420,000 $ 290,000 $ 390,000 $ 138,000 $ 186,000 $ 42,000 $ 84,000 $ 74,000 $ 54,000 Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs The company's discount rate is 19%. 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 Req 2 Req 3 Req 4 Req 6A Calculate the payback period for each product. (Round your answers to 2 decimal places.) Product A Product B Payback period 2.69 years 2.80 years Complete this question by entering your answers in the tabs below. Req 1 Req 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.) Net present value $ Product A 243,697 Product B Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Reg 4 Req 6A Using Excel, calculate the internal rate of return for each product. (Round your percentage answers to 1 decimal place i.e. 0.123 should be considered as 12.3%.) Product A Product B Internal rate of return 24.8% 23.1% Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Reg 4 Req 6A Calculate the profitability index for each product. (Round your answers to 2 decimal places.) Product A Product B Profitability index Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 6A For each measure, identify whether Product A or Product B is preferred. Net Present Value Profitability Index Payback Period Internal Rate of Return Product B Product A Product A Product A View previous attempt Check my work 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: Initial investment: Annual revenues and costs: Product A Product B Cost of equipment (zero salvage value) $ 210,000 $ 420,000 $ 290,000 $ 390,000 $ 138,000 $ 186,000 $ 42,000 $ 84,000 $ 74,000 $ 54,000 Sales revenues Variable expenses Depreciation expense Fixed out-of-pocket operating costs The company's discount rate is 19%. 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 Req 2 Req 3 Req 4 Req 6A Calculate the payback period for each product. (Round your answers to 2 decimal places.) Product A Product B Payback period 2.69 years 2.80 years Complete this question by entering your answers in the tabs below. Req 1 Req 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.) Net present value $ Product A 243,697 Product B Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Reg 4 Req 6A Using Excel, calculate the internal rate of return for each product. (Round your percentage answers to 1 decimal place i.e. 0.123 should be considered as 12.3%.) Product A Product B Internal rate of return 24.8% 23.1% Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Reg 4 Req 6A Calculate the profitability index for each product. (Round your answers to 2 decimal places.) Product A Product B Profitability index Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 6A For each measure, identify whether Product A or Product B is preferred. Net Present Value Profitability Index Payback Period Internal Rate of Return Product B Product A Product A Product A
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
1. Consider a household that has $300 to spend on back-to- school shoes. They visit one of the discount shoe stores where shoes are buy one pair for $50, get the second half off. a. Draw the budget...
-
Assume that Tulsa, Inc., needs $3 million for a one-year period. Within one year, it will generate enough U.S. dollars to pay off the loan. It is considering three options: (1) Borrowing U.S. dollars...
-
Four friends plan to form a corporation for purposes of constructing a shopping center. Charlie will be contributing the land for the project and wants more security than shareholder status provides....
-
Abbott Laboratories is a diversified health care company devoted to the discovery, development, manufacture, and marketing of innovative products that improve diagnostic, therapeutic, and nutritional...
-
1. From a utilitarian point of view, who do you think should be in the priority group? From a justice as fairness perspective, who should be in the priority group? 2. Should people who make society...
-
Use theinformation below to answer the next four questions. You are currentlypursuingyour childhood dream of runninga cupcake shop in downtown NYC. Currently, you only sellcupcakes; however, you are...
-
You, CPA, as the Senior Auditor for the MMC financial statement audit engagement for the year ended March 31, 2020 met with the Audit Partner prior to beginning audit fieldwork. The Audit Partner has...
-
Johnston & Chu started the year with $ 6 5 0 , 0 0 0 in the common stock account and $ 1 , 3 1 8 , 4 0 7 in the additional paid - in surplus account. The end - of - year balance sheet showed $ 7 2 0...
-
You, CPA, work for Artful Accounting Inc. (AAI), a CPA professional corporation. It is February 29, 2024 and you have just finished meeting with Maxine Maximus a senior manager at your company. Ms....
-
Dimsdale Sports, a merchandising company, reports the following balance sheet at December 31. DIMSDALE SPORTS COMPANY Balance Sheet Cash Assets Accounts receivable Inventory Equipment December 31...
-
At the beginning of the year SKYNT, Inc has a balance accumulated E&P of $30,000. During the current year the corporation generates current E&P of $200,000. The E&P is allocated as a current deficit...
-
2. Complete the sentence: "cGMP is that part of the Quality Assurance System which ensures that products are manufactured consistently to a quality"... b) "that suits the needs of the manufacturer"...
-
The following data are given for the Superior Gas Field: Area = 230 acres Net productive thickness = 55 ft Porosity = 22% Connate water = 23% Gas Formation Volume Factor = 0.00533 ft3/SCF Calculate...
-
Draw and label the E and Z isomers for each of the following compounds: 1. CH3CH2CH==CHCH3 2. 3. 4. CH,CH2C CHCH2CH Cl CH3CH2CH2CH2 CH CH2CCCH2CI CHCH3 CH3 HOCH CH CCC CH O-CH C(CH
-
Capstone Consolidated, Inc. is a leading manufacturer of steel products. The following inventory data relates to the firms production during the first quarter of 2015: At the end of the first quarter...
-
Consider the following inventory data for the first two months of the year for CompX International: Required 1. Calculate the cost of goods sold and ending inventory for January and February under...
-
The following inventory data is taken from the financial records of Fernandez, Inc., a personal computer software manufacturer. Required 1. Complete the following table. 2. Which inventory method...
Study smarter with the SolutionInn App