financial calculations for decision making
There are 6 questions on the last page. Please guide me through answering each questions using Excel.
Thank you.
Spring 2015 Due : Sunday January 31, 2015 by 11:59 P.M. Eastern Points Possible : 25 Purpose : Learn to work with financial calculations for decision making and create a weighted scoring model. Be sure to make your output look professional. Deliverable Media : Electronic PDF submitted through Blackboard and the corresponding spreadsheet source. Assignment : review the following case study and answer the questions at the end. You work for a large successful Fortune 500 organization, Brewer Enterprises (BE) but lately many of the IT projects have experienced disappointing results. You have been put on the steering committee to improve the project selection process. BE has decided that any new projects selected for implementation must first meet strict financial measures as well as several other criteria. They have set minimum values for ROI, NPV, IRR, and the payback period. The following information was generated by the project manager for the current set of proposed new projects. Project One Costs Year 0 - Year 4: $120,000; $15,000; $12,000; $7500; $7500 Project One Revenue Year 0 – Year 4: $0; $5,000; $70,000; $100,000; $110,000 Project One Risk determined to be high The project directly supports several line items on the Strategic Plan Current Competitors have not yet completed a similar project Resource Availability is good Project Two Costs Year 0 - Year 4: $51,000; $50,000; $25,000; $6,000; $6,000 Project Two Revenue year 0 – Year 4: $0; $4,000; $77,000; $80,000; $100,000 Project Two Risk determined to be Medium The project is something entirely new, not on the strategic plan, but being mandated by the U.S. government. One current competitor has completed a similar project
Answers
Status NEW
Posted 13 Dec 2017 01:12 PM
My Price 10.00
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------
Not Rated(0)