Calculate the payback period for each product

Assignment Help Financial Management
Reference no: EM131894284

PROBLEM 1 Uncertain Cash Flows

The Cambro Foundation, a nonprofit organization, is planning to invest $104,950 in a project that will last for three years. The project will produce net cash inflows as follows:

Year 1       $30,000
Year 2       $40,000
Year 3           ?

Required:

Assuming that the project will yield exactly a 12% rate of return, what is the expected net cash inflow for Year 3?

PROBLEM 2 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 divi¬sion'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?

*Both problems should be on excel spreadsheet.

Verified Expert

This assignment is based on the basics of accounting. In this given task, there are two problems. In the first problem, the case study of Cambro Foundation was provided, in which we have to evaluate the expected net cash inflow of year. In the second problem, there is another case study is given. The case study of Low Barlow is provided, in which we have to evaluate the payback period of each product, net present value, the internal return rate, project profitability index etc.

Reference no: EM131894284

Questions Cloud

Unsystematic risk-what is the benefit of diversification : Unsystematic risk. What is the benefit of diversification?
Moderate sartre and extreme sartre : What is the difference between moderate Sartre and extreme Sartre?
How much cash novak borrow to maintain monthly balance : How much cash, if any, must Novak borrow to maintain the desired minimum monthly balance? Determine your answer by using the basic form of the cash budget
Communistic and semi-socialistic countries : Could America be farther along the road to communism/socialism than communistic and semi-socialistic countries that have tried to "skip" the full development.
Calculate the payback period for each product : Calculate the payback period for each product and Calculate the net present value for each product - Calculate the internal rate of return
Ultimate result of the contradictions inherent : Or do they support his assertion that communism is the ultimate result of the contradictions inherent in capitalistic and semi-socialistic countries?
What amount was reported as expenditures : The City of Tampa has created a Capital Projects Fund to construct a new school. What amount was reported as EXPENDITURES for 2017 by the Capital Projects Fund
Ethics and trust in critical thinking decisions : Imagine you're thinking about buying a new car. Before making this important decision, you'll want to gather as much information as possible
Explain what is your vision of nursing for the future : Explain What is your vision of nursing for the future? What are challenges that you will face as a nurse? d. What are your goals for professional development?

Reviews

len1894284

3/9/2018 4:49:31 AM

Problem statement is included but contains multiple errors and demonstrates lack of basic understanding of concepts. Problem statement is complete and contains minimal errors. Clear understanding of course content is demonstrated.Problem statement is complete and correct, demonstrating superior understanding of concepts and providing explanatory support

len1894284

3/9/2018 4:49:20 AM

Problem P8-23 50.0 % Problem statement Problem statement is not included. is incomplete or incorrect. 3 Satisfactory 75.00% 4 Good 85.00% 5 Excellent 100.00% Problem statement is included but contains multiple errors and demonstrates lack of basic understanding of concepts. Problem statement is complete and contains minimal errors. Clear understanding of course content is demonstrated.Problem statement is complete and correct, demonstrating superior understanding of concepts and providing explanatory support data and figures.

len1894284

3/9/2018 4:47:25 AM

Complete Problems E8-12 and P8-23 in the textbook and present your responses in an Excel spreadsheet. Please note; both problems should be on excel spreadsheet.APPLY BELOW RUBRICS Statement of Cash Flows 1 2 Unsatisfactory Less than Satisfactory 0.00% 65.00% Content 100.0 % Problem E8-12 50.0 % Problem statement is not included. Problem statement is incomplete or incorrect.

Write a Review

Financial Management Questions & Answers

  Additional funds needed for the coming year

The Booth Company's sales are forecasted to double from $1,000 in 2012 to $2,000 in 2013. Booth's after-tax profit margin is forecasted to be 7% and its payout ratio to be 40%. What is Booth's additional funds needed (AFN) for the coming year?

  What is net income for this firm

What is the net income for this firm?

  After-tax cash outflow for a leasing contract

Lester's Lobsters is in the 40-percent tax bracket. Assuming no purchase option exists and lease payments are made at the beginning of each year, what is the yearly after-tax cash outflow for a leasing contract with an annual payment of $50,000 and a..

  Replacement analysis-What is the NPV of the project

Mississippi River Shipyards is considering the replacement of an 8-year-old riveting machine with a new one that will increase earnings before depreciation from $30,000 to $46,000 per year. The new machine will cost $90,000, and it will have an estim..

  Risk is brought into the stock valuation process

The key to the future behavior of a company lies in the sales growth and the net profit margin. A company's estimated future earnings and its P/E ratio can be used to estimate the stock's future price. A temporary decline in earnings per share usuall..

  The principle of diversification

The principle of diversification does not refer to which of the following statement.

  Compare the alpha from the four-factor model and the capm

Compare the alpha from the four-factor model and the CAPM. Are the alphas different? What do the differences suggest?

  When refinancing commercial property because balloon expried

When refinancing a commercial property because the balloon expired, is it required to purchase new title insurance even if refinancing with the same lender?

  What must be beta of stock that investors expect to return

If the expected rate of return on the market portfolio is 17% and T-bills yield 6%, what must be the beta of a stock that investors expect to return 14%?

  Calculate annual after-tax operating cash flow

Calculate the annual after-tax operating cash flow for Years 1 -4. What is the equipment NPV?

  What insight does ROI give into investment performance

What insight does ROI give into investment performance? Is it acceptable to lose product on one product, if that product is vital to the sale of an extremely profitable product? Please explain why?

  What is meant by strategic asset allocation

What is meant by strategic asset allocation? Discuss the role of strategic asset allocation in achieving a client's goal.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd