Cost-Benefit Calculation. The whole assignment needs to be done in an Excel sheet. Net present value(NPV), Return on investment(ROI), and Internal Rate of Return need to be calculated based on the data provided in the word doc, along with the answers to other questions.
Cost-Benefit Calculation. The whole assignment needs to be done in an Excel sheet. Net present value(NPV), Return on investment(ROI), and Internal Rate of Return need to be calculated based on the dat
Using the table of costs and benefits below, answer the questions that follow. Year Costs Benefits Year 0 1,000,000 20,000 Year 1 125,000 50,000 Year 2 25,000 100,000 Year 3 25,000 120,000 Year 4 25,000 140,000 Year 5 25,000 160,000 Year 6 25,000 180,000 Year 7 25,000 200,000 Year 8 25,000 220,000 Year 9 25,000 240,000 Year 10 25,000 260,000 Year 11 25,000 280,000 Year 12 25,000 300,000 Year 13 25,000 320,000 Year 14 25,000 340,000 Year 15 25,000 360,000 Year 16 25,000 380,000 Year 17 25,000 400,000 Year 18 25,000 420,000 Year 19 25,000 440,000 Year 20 25,000 460,000 Year 21 25,000 480,000 Year 22 25,000 500,000 Year 23 25,000 520,000 Year 24 25,000 540,000 Year 25 25,000 560,000 1. What is the NPV(Net Present Value) of the project? Assume a 15% discount rate and round your answer to the nearest whole dollar (e.g. $125,321). 2. What is the IRR(Internal Rate of Return) of the project? Round your answer to two decimal places (e.g. 15.80%). 3. What is the Simple ROI(Return on Investment) of the project? 4. Based on your calculations, should the project move forward? Why or why not? Please submit a single Excel file with your answers. Please answer the questions directly in the Excel file.




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.