Number crunch analysis
Not what you're looking for?
See the attached file.
1. Use Excel, or another suitable program, to calculate each of the following; show your work:
- Payback Period for Option A
- Internal Rate of Return for Option A
- Net Present Value for Option A
- Payback Period for Option B
- Internal Rate of Return for Option B
- Net Present Value for Option B
2. Using the calculations in the first criterion, clearly present the results for Option A and for Option B as though for an audience of city council members.
3. The city council says they can adopt only one (1) of the projects this year. Pick one (1) and justify the choice to the city council.
4. You are getting push back from the city engineer that both projects are vital and should be done this year. You really want to find a way to make both projects happen. Create a solution that would allow both projects to be implemented. Note: in this case, the Required Return is 12% and the Critical Acceptance Level is 2.75 years.
Purchase this Solution
Solution Summary
This solution provides steps to calculate payback periods, internal rate of returns and net present values.
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.