Calculate the payback period for each product

Assignment Help Financial Accounting

Reference no: EM132146831

Comprehensive Problem - 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) $170,000 $380.000

Annual revenues and costs:

Sales revenues $250.000 $350.000

Variable expenses $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 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.

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 Lou's division pursue? Why?

Problem should be on excel spreadsheet.

Reference no: EM132146831

Questions Cloud

Global warming of a given amount of carbon dioxide : Assume the effect on global warming of a given amount of carbon dioxide is four times that of methane. What should be the relative fine (tax) on emissions

The vulnerabilities and risk about an information system : The impact of the breach on the livelihoods of millions of people is ongoing and may never be fully known.

Write a post in the discussion stream : After reading Chapter Supporting Processes with ERP Systems, consider the following: The athletics director buys sports equipment from a supplier.

Research the history of the attack and those responsible : Research the history of the attack and those responsible. What did this exploit?

Calculate the payback period for each product : Lou Barlow, a divisional manager for Sage Company, His annual pay raises are determined by his division's ROI, Calculate the payback period for each product

What is your practical experience with physical security : In your current job, what are the physical security protocols that you are required to follow and explain the one you find most annoying?

Differentiate between the interaction types and styles : Differentiate between the interaction types and styles that apply to multi-touch screens and applications running on them.

Create a new database : Use the Management Studio to create a new database called the default settings(If the database already exists, use the Management Studio to delete it and than c

Do you think software and hardware products are advertised : Do you think software and hardware products are advertised as much as cell phone companies selling the latest technology gadgets?

User Account

All Pages