Description
Hi all, I need help on my IT Project Management assignment. A Case Study will be provided, the contents are in the following
1. Business case financial analysis
2. Project cost control
3. Project schedule development
4. Project selection
Thank you.
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

Attached.
Page 1 of 9
Discount Rate
PROJECT 1
7%
Year 0
Year 1
Year 2
Revenue
0
0
0
Discount Factor
1
0.93
0.87
Discount Revenue
0
0
0
Costs
Discount Factor
$ 2,000,000 $
1
Year 3
Year 5
Total
$ 12,250,000 $ 12,250,000 $ 12,250,000
0.82
$ 10,045,000 $
456,000 $ 462,360 $
0.93
Year 4
0.87
469,102 $
0.82
0.76
0.71
9,310,000 $
8,697,500 $ 28,052,500
476,248 $
0.76
Discount Cost
$ 2,000,000 $
424,080 $ 402,253 $
384,663 $
361,948 $
Discount Benefit
$ -2,000,000 $ -424,080 $ -402,253 $
9,660,337 $
8,948,052 $
Cumulative Benefit $ -2,000,000 $ -2,424,080 $-2,826,333 $
483,823
0.71
343,514 $
3,916,459
8,353,986 $ 24,136,041
6,834,003 $ 15,782,055 $ 24,136,041
Answer:
ROI of the project =
(Total Discounted Revenue – Total Discounted Costs)
∗ 100
Total Discounted Costs
=
(28,052,500 – 3,916,459)
3,916,459
∗ 100
= 616%
Answer:
It would take three years to recover all the money sent on the project. Since, the payback
period of the project is 3 years.
Page 2 of 9
Answer:
The project has an ROI of 616%. This means that the company would make a decent gain on
its investment in the next five years. The company would recover all the expenses made on
the project in 3 years (payback period). Moreover, the net present value (NPV) of the project
$24,136,041 indicates that the project has the potential to generate considerable amount of
profit. Hence, considering t...
