Skip to content
The first pages of the Make or Buy Analysis template

Make or Buy Analysis

Document template for Google Docs and Word

Make a copy in Google Docs
Price
Free
Style
Minimal
Difficulty
Beginner
Updated
November 6, 2026

Every page (8)

Overview

Make-or-buy decisions are often argued from unit price alone, which hides the upfront cost, the labour and the risk. This template sets out a cost-benefit analysis on a shared five-year timeline: scope, in-house cost, supplier cost, quality actions, risks, the decision and a recommendation with sensitivity. It shows the do-nothing option, so every choice is judged against the same baseline.

The sample is for Netherby Capital, a fictional manufacturer deciding whether to machine 42,000 brackets a year in-house. Its costs, NPV and payback are sample data, using an 8 percent discount rate over five years. Replace the options, figures and owners with your own, and rerun the sensitivity test before you present the recommendation.

Useful for

  • A plant director deciding whether to build a cell or buy parts
  • A finance reviewer testing the discount rate and benefit figures
  • A procurement lead preparing a supplier exit with a clear case

What's included

  • Scope page with options, criteria and the decision
  • In-house cost page with a yearly chart and value table
  • Options comparison with NPV, payback and a score table
  • Quality actions checklist with owners and due dates
  • Risk register with scores and responses
  • Decision page with sign-off options and next steps

How to use it

  1. 1

    Click Make a copy in Google Docs, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    State the decision, the options and the five-year horizon in the first box.

  3. 3

    Enter costs by year for each option, including the do-nothing baseline.

  4. 4

    Discount costs and benefits at your finance policy rate, then run the sensitivity.

  5. 5

    Delete the guide page and any section you do not need, then share the analysis.

What you need

Requirements

  • A Google account with access to Google Drive

Works with

  • Google Docs
  • Microsoft Word (download the .docx)

Questions

Is this make or buy analysis template free to use?

Yes. Copy the analysis into your Drive for free, and every option, cost and assumption stays open for review.

Are the company, people and figures real?

No. Netherby Capital, its plant, suppliers and every figure are fictional sample data. Replace them with your own cost and benefit evidence before the decision is made.

Why include a do-nothing option?

Doing nothing has a cost too, such as rising repairs or lost orders. Costing it honestly shows whether a change is worth making at all, not just which option looks cheapest.

  • #make-or-buy
  • #cost-benefit-analysis
  • #npv-analysis
  • #capital-decision
  • #outsourcing-decision
  • #google-docs-template

Also in Finance

All finance templates
Get this template

Preparing your template…