MBA Team Project Report Template (Analysis, Rubric)

Team Project Report: [Project title]

A report structure for an MBA team project: executive summary, problem and scope, workplan, analysis, options and recommendation, implementation and risks, a contribution statement and an appendix, with a grading rubric and a quality checklist. It is for learning teams writing a graded course project, a consulting-style project for a company or a term-long analysis in strategy, marketing, operations or finance. A worked example for a fictional retailer shows the level of detail expected. Source basis: answer-first business writing (the pyramid structure described by Minto), hypothesis-driven problem solving, standard capital budgeting (NPV, IRR, payback) and multi-criteria option scoring, and research on team effectiveness and peer assessment (Hackman 2002; Ohland et al. 2012), written in our own words. Replace every [bracketed] value and every row marked Example.

Document control

Approvals

How a strong team report is built

A team report is graded on its answer, its evidence and its clarity, and readers decide within the first page whether the team has an answer. Three habits separate strong reports from long ones.

Answer first. The executive summary states the recommendation and the two to four reasons for it, before any background. Minto's pyramid principle describes this structure: a governing idea at the top, supported by a small number of grouped arguments, each supported by evidence. A reader who stops after the first page should still know what to do and why.

Hypothesis-driven work. Write a provisional answer in week one, break it into the questions that would have to be true (an issue tree), and plan the analysis that tests each question. The hypothesis will change; the point is that every hour of analysis is aimed at a question that affects the decision. Teams without a hypothesis tend to collect data first and look for a story later, which produces long background sections and thin recommendations.

One integrated voice. A report written in pieces reads like four reports. The deliverable lead owns the storyline, the terminology, the exhibit numbering and the consistency of numbers. Every member reviews a section they did not write. Hackman (2002) notes that an enabling structure, clear task design and norms of conduct, is one of the conditions that let teams perform; for a report, that structure is the outline, the owners and the integration schedule set out in Section 2.

0. Executive summary

Example. Northfield Outdoor Co. (fictional), a mid-size outdoor-gear retailer with stores and an online shop, should launch a rental and certified-resale programme in its 12 largest stores, starting with tents and technical jackets. The programme fits Northfield's repair capability and its customers' stated interest in renting expensive gear, it scores highest of three options on the team's criteria (4.0 out of 5 against 3.25 and 2.3), and the four-year case has an NPV of USD 0.268m at a 10% discount rate, an IRR of 18.8% and a payback of 2.82 years. The main risk is volume: if inflows are 20% below plan the NPV turns slightly negative (USD -0.026m), so the team recommends a two-store pilot with explicit volume gates before the full roll-out.

1. Problem and scope

Example. Decision: whether and how Northfield should enter rental and resale. Decision maker: the chief executive and the head of stores. Success criteria: positive NPV at Northfield's 10% hurdle rate, payback within three years, and a measurable increase in repeat visits. Out of scope: rental of bicycles and watercraft, international stores.

2. Workplan

3. Analysis

3.1 Issue tree

The example tree splits the decision into four questions; each leaf is an analysis owned by one workstream in Section 2. Replace it with your own tree and keep it in the report so the reader sees why each analysis exists.

3.2 Findings by question

3.3 Financial analysis

Example. Exhibit 3: Northfield rental and resale, incremental cash flows (USD m, fictional).

Excel's NPV function discounts its first value by one period, so the year-0 outlay is added outside the function.

4. Options and recommendation

Example.

Excel: with weights in B2:B5 and Option A's scores in C2:C5, =SUMPRODUCT($B$2:$B$5,C2:C5).

Recommendation: [state it in one sentence, then the conditions under which the team would change its mind].

Example. Launch Option A as a two-store pilot for six months, scale to 12 stores if the pilot reaches at least 85% of planned rental volume, because the full-scale NPV turns negative if volume runs 20% below plan. The team would change its recommendation if the pilot showed that rentals mainly replace sales of new gear rather than attract new customers.

5. Implementation, risks and next steps

6. Contribution statement

Use of AI tools and outside help: [state what was used, for which task, and confirm it complies with the course's rule as of YYYY-MM-DD; see mba/mba-ai-use-policy-check]. External sources are cited in the appendix. If peer evaluation is part of the grade, see mba/mba-peer-feedback.

7. Appendix

8. Quality checklist

• The recommendation is in the first two sentences of the executive summary.
• Every section heading is a finding or a question, not a topic label.
• Every number in the text matches the exhibits and the model; totals add up.
• Units and currency are stated on every exhibit; years and periods are consistent.
• At least three options were considered, including the status quo.
• The main risk and the condition that would change the recommendation are stated.
• Assumptions have sources and dates.
• Exhibits are numbered, titled with their message and referred to in the text.
• One voice: terminology, tense and formatting are consistent.
• Length, format and citation style meet the course's current instructions.
• The contribution statement is agreed by all members.
• AI use and outside help comply with the course rule and are disclosed as required.

9. Grading rubric

Example. A draft scored 3, 3, 4, 3, 2 and 4 on the six criteria. Weighted percent: $10 \times \tfrac{3}{4} + 30 \times \tfrac{3}{4} + 20 \times \tfrac{4}{4} + 10 \times \tfrac{3}{4} + 15 \times \tfrac{2}{4} + 15 \times \tfrac{4}{4} = 80.0$. Excel: =SUMPRODUCT(B2:B7,C2:C7)/4 with weights as whole numbers in B2:B7 and scores in C2:C7. The weakest criterion, writing and exhibits, is where the final 48 hours should go.

Common mistakes

1. Background first, recommendation on page eight.
2. Topic headings ("Market overview") instead of message headings ("Demand is concentrated in tents and jackets").
3. Analysis that is interesting but does not change the decision.
4. Only one real option compared against a straw man.
5. Weights in the scoring matrix chosen after scoring, so the preferred option wins.
6. Numbers in the text that do not match the exhibits after late model changes.
7. NPV computed with Excel's NPV over the year-0 cash flow, which discounts the outlay by one period.
8. No sensitivity analysis on the driver that matters most.
9. Four writing styles and inconsistent terminology because nobody integrated the sections.
10. A contribution statement written by one person and not agreed by the team.
11. Undisclosed AI use or outside help where the course requires disclosure.

Self-test

1. What belongs in the first two sentences of the executive summary?
2. Why write a hypothesis in week one if it may change?
3. In the example, why is the NPV computed as =NPV(10%,C2:F2)+B2 and not =NPV(10%,B2:F2)?
4. Verify the payback of 2.82 years from the cumulative cash flows.
5. Recompute Option B's weighted score.
6. What does the 20% sensitivity tell the decision maker, and how did the team respond in its recommendation?
7. Name two reasons a contribution statement helps the team.
8. A draft scores 4 on every criterion except analysis quality (2). What is its weighted percent?

Sources and further reading

• Hackman, J. R. (2002). Leading Teams: Setting the Stage for Great Performances. Harvard Business School Press.
• Ohland, M. W., Loughry, M. L., Woehr, D. J., Bullard, L. G., Felder, R. M., Finelli, C. J., Layton, R. A., Pomeranz, H. R., and Schmucker, D. G. (2012). The comprehensive assessment of team member effectiveness: development of a behaviorally anchored rating scale for self and peer evaluation. Academy of Management Learning and Education, 11(4), 609-630.
• Further reading (by name only): Minto, The Pyramid Principle; Brealey, Myers and Allen, Principles of Corporate Finance (capital budgeting chapters); Berk and DeMarzo, Corporate Finance; OpenStax, Principles of Management (CC BY-NC-SA 4.0), chapters on teamwork and communication.

Answer key

1. The recommendation and the main reasons for it (with the key number), so a reader who stops there knows what to do and why.
2. It focuses the analysis on questions that affect the decision; it is tested and revised, not defended.
3. Excel's NPV treats its first value as arriving one period from now, so including the year-0 outlay would discount it; the outlay is added separately. Correct result: USD 0.268m.
4. Cumulative after year 2 is -0.45; year 3 inflow is 0.55; 0.45 / 0.55 = 0.82 of year 3, so 2 + 0.82 = 2.82 years.
5. 0.30 × 3 + 0.25 × 3 + 0.25 × 4 + 0.20 × 3 = 0.90 + 0.75 + 1.00 + 0.60 = 3.25.
6. Value depends heavily on volume: a 20% shortfall in inflows makes NPV slightly negative (USD -0.026m). The team recommended a two-store pilot with a volume gate at 85% of plan before full roll-out.
7. It makes contributions visible and fair (protecting members who did more) and it shows the instructor or client how the team worked; it can also be compared with peer evaluations.
8. 10 + 30 × 2/4 + 20 + 10 + 15 + 15 = 10 + 15 + 20 + 10 + 15 + 15 = 85.0%.

Revision history

Standard and licence note

Structure aligned with common practice for business-school team projects and consulting-style reports: answer-first writing in the manner of Minto's pyramid principle, hypothesis-driven problem solving with issue trees, standard capital budgeting (NPV, IRR, payback) and weighted multi-criteria scoring, all general methods explained here in original wording. The rubric is original and is not any school's official rubric; this template is not affiliated with or endorsed by any business school or publisher. Check your course's current instructions on format, length, citation, collaboration and AI use before submitting. Northfield Outdoor Co. and all figures in the example are fictional. Template licence: MIT.