| Your company is considering three potential projects, and as the financial analyst, you have been asked to evaluate the projects using Net Present Value (NPV). Each project requires an initial investment and is expected to generate cash flows over the next five years. The company’s required rate of return (discount rate) is 10% for project A, 15% for project B, and 20% for project C. | ||||||
| Your task is to use Excel to do the following: | ||||||
| 1. Calculate the NPV for each project. | ||||||
| 2. Recommend which project the company should invest in based on your findings. | ||||||
| 3. Justify your selection using the calculated NPV | ||||||
| Data: | ||||||
| Project | Initial Investment | Year 1 Cash Flow | Year 2 Cash Flow | Year 3 Cash Flow | Year 4 Cash Flow | Year 5 Cash Flow |
| Project A | ($200,000) | $50,000 | $60,000 | $70,000 | $80,000 | $90,000 |
| Project B | ($250,000) | $80,000 | $90,000 | $100,000 | $110,000 | $120,000 |
| Project C | ($300,000) | $100,000 | $110,000 | $120,000 | $130,000 | $140,000 |
Struggling with where to start this assignment? Follow this guide to tackle your assignment easily!
Step-by-Step Guide to Completing the NPV Analysis in Excel
Step 1: Organize Your Excel Worksheet
-
Open Excel and create a new worksheet.
-
Label columns clearly:
-
Project Name
-
Initial Investment
-
Year 1 through Year 5 Cash Flows
-
-
Enter the data exactly as provided, including negative values for initial investments.
Tutor tip: Keeping a clean layout helps avoid formula errors and improves grading clarity.
Step 2: Understand What NPV Measures
Net Present Value tells you whether a project:
-
Adds value (positive NPV)
-
Breaks even (NPV ≈ 0)
-
Destroys value (negative NPV)
A company should generally invest in the project with the highest positive NPV.
Step 3: Use the Excel NPV Function Correctly
For each project:
-
Enter the discount rate in a separate cell
-
Project A: 10%
-
Project B: 15%
-
Project C: 20%
-
-
Use Excel’s
NPV()function to discount only the future cash flows (Years 1–5). -
Add the initial investment separately to the NPV result.
Common mistake: Do not include the initial investment inside the NPV function.
Step 4: Calculate NPV for All Projects
-
Repeat the NPV calculation process for Projects A, B, and C.
-
Clearly label each NPV result.
Tutor expectation: All calculations must be formula-based, not manually calculated numbers.
Step 5: Analyze and Compare the Results
-
Compare the NPVs across all three projects.
-
Identify:
-
Which project has the highest NPV
-
Whether any project has a negative NPV
-
Business insight: Higher discount rates increase risk, which directly impacts NPV.
Step 6: Write Your Recommendation
In a clearly labeled cell or text box, answer:
-
Which project should the company invest in?
-
Why? (Reference the NPV values directly.)
Strong answers explain:
-
Why the selected project adds the most value
-
Why other projects are less attractive
Step 7: Final Review Before Submission
Before submitting:
-
Ensure all formulas are visible and correct
-
Format dollar amounts as Currency
-
Double-check discount rates
-
Keep explanations concise and professional
Helpful Learning Resources
You may use the following links for support:
-
Excel NPV Function (Microsoft):
https://support.microsoft.com/excel -
Excel Financial Functions Explained:
https://www.excel-easy.com/functions/financial-functions.html -
Net Present Value Explained Simply:
https://www.investopedia.com/terms/n/npv.asp -
Excel Tutorials for Beginners:
https://www.gcfglobal.org/excel/
The post NPV Analysis Homework: Evaluating Investment Projects Using Excel appeared first on Skilled Papers.