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

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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