# ERP Migration Payback Period and NPV Calculator

> Source: https://netray.co/tools/erp-migration-payback-and-npv-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Calculates payback period, net present value and ROI for a GP or AX replacement from investment, run-cost savings and productivity gains.

## Category

cost-finance

## Audience

- CFO
- Controller
- IT director

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### One-time migration investment

**Key:** investment

**Type:** number

**Default:** 450000

**Min:** 0

**Step:** 10000

**Unit:** total

**Help:** Implementation, data migration, training and internal backfill.

#### Current annual run cost

**Key:** current_run

**Type:** number

**Default:** 200000

**Min:** 0

**Step:** 5000

**Unit:** per year

#### New annual run cost

**Key:** new_run

**Type:** number

**Default:** 120000

**Min:** 0

**Step:** 5000

**Unit:** per year

#### Annual productivity and process gains

**Key:** productivity

**Type:** number

**Default:** 30000

**Min:** 0

**Step:** 5000

**Unit:** per year

**Help:** Only count gains you will actually bank or redeploy.

#### Ramp delay before savings start

**Key:** ramp

**Type:** slider

**Default:** 6

**Min:** 0

**Max:** 24

**Step:** 1

**Unit:** months

#### Evaluation horizon

**Key:** horizon

**Type:** slider

**Default:** 5

**Min:** 1

**Max:** 10

**Step:** 1

**Unit:** years

#### Discount rate

**Key:** rate

**Type:** slider

**Default:** 10

**Min:** 0

**Max:** 25

**Step:** 1

**Unit:** %

**Outputs:**

#### Annual net benefit

**Key:** annual_saving

**Expr:** current_run - new_run + productivity

**Format:** currency

#### Payback period

**Key:** payback

**Expr:** ramp + investment / (annual_saving / 12)

**Format:** months

**Primary:** true

**Description:** Ramp months plus months to recover the investment.

#### Annuity factor

**Key:** pv_factor

**Expr:** if(gt(rate, 0), (1 - pow(1 + rate / 100, 0 - horizon)) / (rate / 100), horizon)

**Format:** decimal

#### Benefit lost during ramp

**Key:** lost

**Expr:** annual_saving * ramp / 12

**Format:** currency

#### Net present value

**Key:** npv

**Expr:** annual_saving * pv_factor - lost - investment

**Format:** currency

**Primary:** true

#### Simple ROI over horizon

**Key:** roi

**Expr:** (annual_saving * horizon - lost - investment) / investment * 100

**Format:** percent

**Chart:**

#### NPV vs discount rate

**Type:** line

**X:** rate

**From:** 0

**To:** 25

**Steps:** 26

**Series:**

- npv

**Disclaimer:** Simplified model. The ramp loss is subtracted undiscounted, and benefits are assumed level and annual.

## Content

**Intro:** A migration business case needs a payback period and a value that accounts for time. This calculator gives both from a handful of inputs a finance lead can defend.

**Sections:**

#### How to use it

**Body:** Put every one-time cost in the investment line, including internal time and consultants. For savings, subtract new run cost from current run cost, using the full cost of the old system as seen in the on-prem run-cost tool. Count productivity only when someone owns the benefit. Test the result at conservative and optimistic values.

#### The method

**Body:** Annual net benefit is the run-cost saving plus productivity gain. Payback is the ramp delay plus investment divided by monthly benefit. NPV uses the annuity factor, one minus the discount factor raised to the horizon, divided by the rate, multiplied by annual benefit, less benefit lost during ramp and the investment. With a zero rate the factor equals the years.

#### Reading the result

**Body:** A positive NPV at your cost of capital means the project clears the hurdle. If payback exceeds the horizon, the case rests on strategic reasons such as supportability or security. A common mistake is counting avoided risk as a saving without probability weighting, which the cost-of-waiting calculator handles separately.

**Cta:** Netray can help validate the run-cost and benefit baseline with data from your ERP. The calculator needs no such input.

**Faq:**

#### What discount rate should I use?

**Answer:** Use your company's cost of capital or hurdle rate. If you do not have one, ask finance. Eight to twelve percent is common for mid-size manufacturers, but it is a company decision.

#### Why subtract the ramp loss?

**Answer:** Because savings do not start on day one. Dual running, training and stabilisation delay the benefits, and ignoring that overstates the case.

#### Can NPV be negative and still justify a move?

**Answer:** Yes, if staying carries unquantified risk or blocks growth. State that explicitly in the business case rather than hiding it in the numbers.

#### Does it handle varying yearly benefits?

**Answer:** No. It assumes level benefits. For uneven profiles, use a spreadsheet with a row per year and the same logic.

## Search terms

erp migration payback period, erp npv calculator, erp roi calculator, dynamics gp replacement business case, ax to d365 business case, erp migration discount rate npv

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json