As a project management professional, it is important for you to be able to review numbers and report on what they are saying. This assignment will help prepare you for this responsibility.
As a project management professional, it is important for you to be able to review numbers and report on what they are saying. This assignment will help prepare you for this responsibility.
Respond to the Following Problems
A certain project has a project cost of $387,000 and the annual inflows resulting from the product created is $64,000. What is the Payback Period?
Assume that $654,980 is to be invested in a project whose annual projected cash flows are as follows: Year 1 = $135,678, Year 2 = $156,560, Year 3 = $233,980, and Year 4 = $298,000. Assume that the required rate of return is 6.50%.
Compute the NPV directly (i.e., without using the Microsoft Excel NPV or PV functions). Be sure to show your work.
Should the project be pursued? Why or why not?
Assume that $1,285,673 is to be invested in a project whose annual projected cash flows are as follows: Year 1 = $235,678, Year 2 = $267,854, Year 3 = $298,054, Year 4 = $314,567, and Year 5 = $325,678. Assume that the required rate of return is 5.25%.
Compute the NPV by using Microsoft Excel’s NPV function. Be sure to show your work.
Should the project be pursued? Why or why not?
A company has two projects that are under evaluation. The project investment costs, annual projected cash flows, and required rates of return are shown below:
Project 1
Project 2
Rate of Return:
0.065
0.065
Project Cost:
-$1,397,654
-$1,619,835
Year 1
$245,367
$267,345
Year 2
$302,542
$343,563
Year 3
$316,543
$367,834
Year 4
$367,843
$432,098
Year 5
$450,425
$589,435
Compute the NPV for each project using Microsoft Excel NPV’s function. Be sure to show your work.
Which project should be pursued? Why?
This assignment uses a scoring guide. Please review the scoring guide prior to beginning the assignment to become familiar with the expectations for successful completion.
APA style is not required, but solid academic writing is expected.
Ensure that your last name is in the file name and submit your completed Excel file by the end of this week.
You are not required to submit this assignment to LopesWrite.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
