Purchase Solution

Ford Motor Project Viability NPV payback IRR profit index

Not what you're looking for?

Ask Custom Question

Write a proposal which applies the methods for calculating a project's viability advising Ford Motor Co. on obtaining funding and managing a project budget, to purchase equipment to increase worker safety. Review Ford's annual report. The initial investment is $25M and the yearly cash inflows are as follows:

Year 2: $5M
Year 3: $10M
Year 4: $15M
Year 5: $12M

Assume all cash flows are at the beginning of the period and a discount rate of 10%.

Include the following information in the proposal (no more than 1300 words):

1. Define business needs in an overview of the project, including high-level deliverables to solve the problem.

2. Describe the net present value (NPV), internal rate of return (IRR), profitability index, and payback methodologies for calculating the projects viability. Examine the strengths and weaknesses of each methodology.

3. Calculate NPV, IRR, profitability index, and payback method. Explain the rationale for accepting or rejecting the project based on its financial viability.

Purchase this Solution

Solution Summary

The computation of NPV, IRR, profitability index and payback are in Excel for you. Click in cells to see calculation.

Solution Preview

Here is an outline to assist you in writing your proposal. Use it as a guide as experts are not permitted to write essays.

1. The posting did not include details about the projects to be able to discussion deliverables. However, in a write up, you would clearly mention that worker safety projects should review not only the financial returns but also the qualitative aspects, such as reputation, health, morale, and legal issues surrounding safety.

2. NPV is the dollar amount of the future cash flows expected discounted back to present dollars. That is, the amount of profits expected in today's dollars, assuming a 10% cost of ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

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.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.