Exercise one and seven.xlsx

Exercise one and seven.xlsx - 1 Two new internet site...

This preview shows page 1 - 2 out of 4 pages.

Using the payback period Project B is better as it has a shorter payback period 7. Develop a spreadsheet for Exercise 6 Project Score # Grade Score 1 Criterion Weight A B C A B C 2 Cost 20 1 2 3 20 40 60 3 Risk 20 2 3 1 40 60 20 Opportunity 10 2 1 3 20 10 30 Profitability 10 3 3 2 30 30 20 Sustainability 10 2 1 1 20 10 10 Safety 25 1 2 3 25 50 75 Competitiveness 10 2 2 2 20 20 20 175 220 235 Project Grade Score Criterion Weight A B C A B C Cost 20 1 2 3 20 40 60 Risk 20 2 3 1 40 60 20 Opportunity 10 2 1 3 20 10 30 Profitability 25 3 3 2 75 75 50 Sustainability 10 2 1 1 20 10 10 Safety 10 1 2 3 10 20 30 Competitiveness 10 2 2 2 20 20 20 205 235 220 Project Grade Score Criterion Weight A B C A B C Cost 20 1 2 3 20 40 60 Risk 20 2 3 1 40 60 20 Opportunity 10 2 1 3 20 10 30 Profitability 25 3 3 2 75 75 50 Sustainability 10 2 1 1 20 10 10 Safety 10 3 2 3 30 20 30 1. Two new internet site projects are proposed to a young start-up company. Project A will cost $250,000 to implement and is expected to have annual net cash flows of $75,000. Project B will cost $150,000 to implement and should generate annual net cash flows of $52,000.
Image of page 1

Subscribe to view the full document.

Image of page 2
You've reached the end of this preview.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern