Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. The table below summarizes the costs and benefits for a new online procurement system . Based on these estimates: a. Create a spreadsheet showing

1. The table below summarizes the costs and benefits for a new online procurement system. Based on these estimates:

a. Create a spreadsheet showing the Net Present Value for the costs and benefits listed. Use NPV values for the calculations below.

b. Calculate the return on investment for this project.

c. Calculate the payback period for this project.

d. Calculate the internal rate of return for this project.

2. Based on these calculations would you recommend undertaking this project? Why? What factors other than financial metrics would you consider?

3. Identify 5 risks you think might impact this project and evaluate the importance of each of these risks?

Costs

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9

Year 10

Hardware

$ 200,000.00

$ 100,000.00

$ 50,000.00

$ 10,000.00

$ 10,000.00

$ 75,000.00

$ 75,000.00

$ 10,000.00

$ 10,000.00

$ 10,000.00

Software

Development

$ 400,000.00

$ 400,000.00

$ 75,000.00

$ -

$ -

$ -

$ -

$ -

$ -

$ -

Licenses

$ 200,000.00

$ 20,000.00

$ 20,000.00

$ 20,000.00

$ 20,000.00

$ 20,000.00

$ 20,000.00

$ 20,000.00

$ 20,000.00

$ 20,000.00

Maintenance

$ -

$ -

$ 25,000.00

$ 50,000.00

$ 50,000.00

$ 200,000.00

$ 50,000.00

$ 50,000.00

$ 50,000.00

$ 50,000.00

Benefits

Reduce Operating Budget of $12,000,000 by 10% per year after year 3

If you can explain the formulas and calculations or provide any explanations, that would be awesome. Thank you very much.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Recent Advances In Computational Finance

Authors: Nikolaos S. Thomaidis, Jr. Dash, Gordon H.

1st Edition

1626181233, 978-1626181236

More Books

Students also viewed these Finance questions

Question

=+ (b) Show that the reverse implication holds if 22 is countable.

Answered: 1 week ago