Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following two tables with financial and subjective scores on three projects, create MS Excel models to compute each of the following selection criteria

Given the following two tables with financial and subjective scores on three projects, create MS Excel models to compute each of the following selection criteria for each project: 1) NPV (discounting factor is 8%) 2) IRR 3) ROI (at least 10% required) 4) Payback period (maximum 2 years) 5) Weighted score (using weighted scoring model)

Can i know the right steps of each please?

Table 1:
Projects: Cost/Benefits Year 1 Year 2 Year 3 Year 4 Total
Project 1 Costs 5,000 6,000 4,000 2,000 17,000
Benefits 0 2,000 7,000 8,000 17,000
Project 2 Costs 1,000 4,000 7,000 6,000 18,000
Benefits 1,000 6,000 8,000 2,000 17,000
Project 3 Costs 3,000 6,000 4,000 1,000 14,000
Benefits 1,000 4,000 3,000 8,000 16,000
Table 2:
Criteria: Weight Project 1 Project 2 Project 3
Support key business objectives 50% 80 60 90
Has strong internal sponsor 30% 60 80 70
Has low risk in meeting triple constraint 20% 70 80 50

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

Step: 3

blur-text-image

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

Applications In Energy Finance

Authors: Christos Floros, Ioannis Chatziantoniou

1st Edition

3030929566, 978-3030929565

More Books

Students also viewed these Finance questions