Payback, IRR and NPV Excel calculations: guide
Three calculations on one textbook scenario — payback, IRR, and NPV at 12 percent for two competing projects — delivered as a three-tab Excel workbook, with the only prose required being the recommendation the NPV tab must justify.
Editorial process
Last reviewed · August 11, 2026
What do the three-tab rules and the 12 percent actually require?
The deliverable format is half the assignment and the easiest place to lose points: an Excel spreadsheet with exactly three tabs, one per calculation, each tab reflecting only its own calculation's result. That structure means no combined dashboard, no calculation spilling across tabs, and — reading the instruction's intent — workings visible within each tab so the grader can trace inputs to result. The inputs all come from the named scenario (the Kaiser Oakland Practice problem on page 329 of the course's financial management text), and the brief maps each calculation to its worked example in Chapter 7: the payback exhibits, and the Excel IRR walkthrough for unequal cash flows. Set the scenario's cash flows up once, identically, on each tab, because the three methods must run on the same numbers — a discrepancy between tabs is the most visible kind of error.
The three methods answer different questions, and knowing that is what the final prompt ('Which project should be chosen? Explain.') actually tests. Payback measures how fast the initial outlay returns — simple, liquidity-focused, but blind to everything after the payback year and to the time value of money. IRR gives each project's implied rate of return — comparable to a hurdle rate, but capable of misranking mutually exclusive projects when their scale or cash-flow timing differs. NPV at the stated 12 percent cost of capital discounts every cash flow and answers the question that matters for value: which project adds more in today's dollars. When the methods disagree about the two projects, finance's standard answer — and the one the textbook chapter teaches — is that NPV decides, because it measures value added at the organization's actual cost of capital. Your explanation should say which project wins on each method, then choose on NPV and say why.
Use Excel's own functions the way the referenced exhibit does — the IRR function on the cash-flow range, and the NPV function with the discipline it famously requires: it discounts from period one, so the time-zero outlay is added outside the function, not included in the range. That off-by-one is the classic error in this exact assignment shape, and a result that ignores it will disagree with the textbook's method visibly.
Likely learning objectives
Inferred from the brief — check these against your own rubric.
- 01Structure a workbook to the brief's letter: three tabs, one calculation each, workings traceable.
- 02Compute payback for unequal cash flows by cumulative recovery, per the textbook's exhibits.
- 03Apply Excel's IRR function to both projects' cash-flow ranges as the referenced exhibit demonstrates.
- 04Compute NPV at the stated 12 percent with the time-zero outlay handled outside Excel's NPV function.
- 05Choose between competing projects on NPV and explain why it outranks payback and IRR when they disagree.
Read the full question
Review every instruction before using the planning guidance that follows.
Course-wide instructions that accompany this question
Important information for writing discussion questions and participation Hi Class, Please read through the following information on writing a Discussion question response and participation posts. Contact me if you have any questions. Important information on Writing a Discussion Question Your response needs to be a minimum of 150 words (not including your list of references) There needs to be at least TWO references with ONE being a peer reviewed professional journal article. Include in-text citations in your response Do not include quotes—instead summarize and paraphrase the information Follow APA-7th edition Points will be deducted if the above is not followed Participation –replies to your classmates or instructor A minimum of 6 responses per week, on at least 3 days of the week. Each response needs at least ONE reference with citations—best if it is a peer reviewed journal article Each response needs to be at least 75 words in length (does not include your list of references) Responses need to be substantive by bringing information to the discussion or further enhance the discussion. Responses of “I agree” or “great post” does not count for the word count. Follow APA 7th edition Points will be deducted if the above is not followed Remember to use and follow APA-7th edition for all weekly assignments, discussion questions, and participation points. Here are some helpful links Student paper example Citing Sources The Writing Center is a great resource Welcome to class Hello class and welcome to the class and I will be your instructor for this course. This is a -week course and requires a lot of time commitment, organization, and a high level of dedication. Please use the class syllabus to guide you through all the assignments required for the course. I have also attached the classroom policies to this announcement to know your expectations for this course. Please review this document carefully and ask me any questions if you do. You could email me at any time or send me a message via the “message” icon in halo if you need to contact me. I check my email regularly, so you should get a response within 24 hours. If you have not heard from me within 24 hours and need to contact me urgently, please send a follow up text to. I strongly encourage that you do not wait until the very last minute to complete your assignments. Your assignments in weeks 4 and 5 require early planning as you would need to present a teaching plan and interview a community health provider. I advise you look at the requirements for these assignments at the beginning of the course and plan accordingly. I have posted the YouTube link that explains all the class assignments in detail. It is required that you watch this 32-minute video as the assignments from week 3 through 5 require that you follow the instructions to the letter to succeed. Failure to complete these assignments according to instructions might lead to a zero. After watching the video, please schedule a one-on-one with me to discuss your topic for your project by the second week of class. Use this link to schedule a 15-minute session. Please, call me at the time of your appointment on my number. Please note that I will NOT call you. Please, be advised I do NOT accept any assignments by email. If you are having technical issues with uploading an assignment, contact the technical department and inform me of the issue. If you have any issues that would prevent you from getting your assignments to me by the deadline, please inform me to request a possible extension. Note that working fulltime or overtime is no excuse for late assignments. There is a 5%-point deduction for every day your assignment is late. This only applies to approved extensions. Late assignments will not be accepted. If you think you would be needing accommodations due to any reasons, please contact the appropriate department to request accommodations. Plagiarism is highly prohibited. Please ensure you are citing your sources correctly using APA 7th edition. All assignments including discussion posts should be formatted in APA with the appropriate spacing, font, margin, and indents. Any papers not well formatted would be returned back to you, hence, I advise you review APA formatting style. I have attached a sample paper in APA format and will also post sample discussion responses in subsequent announcements. Your initial discussion post should be a minimum of 200 words and response posts should be a minimum of 150 words. Be advised that I grade based on quality and not necessarily the number of words you post. A minimum of TWO references should be used for your initial post. For your response post, you do not need references as personal experiences would count as response posts. If you however cite anything from the literature for your response post, it is required that you cite your reference. You should include a minimum of THREE references for papers in this course. Please note that references should be no more than 5 years old except recommended as a resource for the class. Furthermore, for each discussion board question, you need ONE initial substantive response and TWO substantive responses to either your classmates or your instructor for a total of THREE responses. There are TWO discussion questions each week, hence, you need a total minimum of SIX discussion posts for each week. I usually post a discussion question each week. You could also respond to these as it would count towards your required SIX discussion posts for the week. I understand this is a lot of information to cover in 5 weeks, however, the Bible says in Philippians 4:13 that we can do all things through Christ that strengthens us. Even in times like this, we are encouraged by God’s word that we have that ability in us to succeed with His strength. I pray that each and every one of you receives strength for this course and life generally as we navigate through this pandemic that is shaking our world today. Relax and enjoy the course!
Turn the brief into deliverables
- 01An Excel spreadsheet with three tabs — payback, IRR, NPV — each reflecting only its own calculation's result, per the brief.
- 02All calculations performed for both projects in the textbook's scenario #15 (Kaiser Oakland Practice, page 329).
- 03NPV computed at the stated 12 percent cost of capital, with the project choice stated and explained.
How should each calculation tab be built?
Set up the scenario once, correctly
Extract both projects' initial outlays and yearly cash flows from the textbook scenario and lay them out in a clean, labelled block replicated on each tab.
Tab 1: payback
Compute cumulative cash recovery year by year for each project and identify the year (with interpolated fraction if taught) in which the outlay is recovered, following the chapter's payback exhibits.
Tab 2: IRR
Apply Excel's IRR function to each project's complete cash-flow range — time zero through the final year — as the chapter's Excel exhibit demonstrates.
Tab 3: NPV and the decision
Discount each project's operating flows at 12 percent with Excel's NPV function, add the time-zero outlay outside it, compare the two NPVs, and answer the prompt: which project, and why.
Which references keep the Excel mechanics honest?
Recommended databases
- The course textbook's Chapter 7 sections and exhibits (the brief maps each calculation to them)
- Microsoft Excel documentation
- Healthcare finance references
Search sequence
- 1.Read the mapped Chapter 7 sections first — the payback exhibits and the Excel IRR walkthrough are the assignment's own answer key for method.
- 2.Check Excel's NPV function documentation for the period-one convention before building tab 3.
- 3.Skim a healthcare capital-budgeting overview so the explanation can frame the decision in the organization's terms.
- 4.Verify both projects' results against a quick sanity check: the project with the higher NPV at 12 percent should generally show the stronger IRR unless timing differences explain otherwise.
Reference shortlist
These are authoritative starting points, not a ready-made bibliography. A qualified reviewer must confirm that each source fits the assignment and supports the claim beside which it is cited.
Nothing here is cleared for citation until you have read it.
- 01
Capital Budgeting: NPV, IRR & Payback Period Guide
Learnsignal · 2023
A clean statement of what each of the three methods measures and where each misleads — the conceptual backing for the 'which project and why' explanation.
- 02
Capital Budgeting for Healthcare Organizations
Strata Decision Technology · 2024
The healthcare framing — how hospital and practice capital decisions actually use these techniques — for an explanation written in the course's own industry.
- 03
Investment Decision Rules (NPV, IRR, Payback)
Fiveable Finance Study Guides · 2024
The decision-rule comparison — including why NPV governs when rules conflict for mutually exclusive projects — which is precisely the final prompt's expected reasoning.
Review before submission
Common mistakes
- Including the time-zero investment inside Excel's NPV range — the function discounts from period one, and the initial outlay must be added separately; this single error flips project rankings.
- Combining calculations on one tab or duplicating results across tabs when the brief specifies one calculation per tab, each showing only its own result.
- Computing payback by simple division when the scenario's cash flows are unequal — cumulative recovery year by year is the textbook's method for exactly this case.
- Answering 'which project should be chosen' from payback or IRR when they conflict with NPV, without the explanation the prompt demands.
- Typing results as numbers instead of leaving live formulas — a workbook whose cells can be audited is what the Excel format is for.
- Using cash-flow figures that differ between tabs; the three methods must run on one identical setup from the scenario.
Submission checklist
- Three tabs, named for their calculations; each contains only its calculation.
- Scenario cash flows entered identically on each tab and traceable to page 329's data.
- Payback computed cumulatively for both projects, with the payback year visible.
- IRR computed via Excel's function on the full cash-flow range including time zero.
- NPV computed at 12 percent with the outlay outside the NPV function; both projects compared.
- The choice of project stated on the NPV tab with its explanation.
Use this guide to plan and review your own work. Follow your institution's rules and read our academic-integrity policy.
Written by
Aaron Bishop
MA, Education
assignment interpretation and research-methods coaching across disciplines
Aaron leads the EssayCrackers editorial desk. He works on how assignment briefs are read — what a rubric is actually asking for, and where students most often answer a different question than the one set.
Reviewed by
Dr. Nathan Cole
PhD, Rhetoric & Composition
Argumentation and thesis development
Nathan teaches first-year composition and directs a university writing center. He reviews EssayCrackers guides for argumentative soundness and citation accuracy.