Present Value Analysis for Pricing: Ad-Hoc Pricing Models Default to Using Excel, but What Happens When the Model Is Neither Robust nor Scalable to Cope with New Customers? This Case Study Offers Some Answers

By Smith, David | Financial Management (UK), November 2011 | Go to article overview

Present Value Analysis for Pricing: Ad-Hoc Pricing Models Default to Using Excel, but What Happens When the Model Is Neither Robust nor Scalable to Cope with New Customers? This Case Study Offers Some Answers


Smith, David, Financial Management (UK)


This decision is clearly based on assumptions, owing to the incomplete nature of the information available: i) that the investment is a single cash flow, ii) tax is too difficult, so keep it simple and avoid capital allowances, iii) inflation in the discount factor will be constant over the project life, and iv) when the project ends, there will be no terminal cash flows.

When it comes to investment appraisals we are happy to make broad assumptions. But when it comes to pricing, will our customers be equally happy to assume? If not, what are the implications for the pricing experts in the finance function?

The following example is based on a subsidiary of a large utilities company. The subsidiary invested [pounds sterling]1bn to provide new facilities and expand capacity. Commercial contracts deemed that part of the investment was to be recovered from customers at a post-tax real rate of return of, say, six per cent over the life of the contract. Excel was initially used as a price calculation tool. A process improvement project team then reviewed this and established how it would be improved.

The recoverable investment comprised 13 different assets, each with unique project start dates and cash outflows to suppliers. Because the investment takes place in multiple phases, and new customers are joining for different contract durations in each phase, the need to share asset usage over that duration posed a particular problem. This meant that each period of asset use could have three to five customers sharing the asset, with each customer having a share of the asset capacity.

The largest of the recoverable assets cost [pounds sterling]18m and took three years to construct. For the purpose of a present value calculation the accuracy required in a pricing context dictated that the monthly cash flows be captured.

[FIGURE 1 OMITTED]

Calculating monthly discount rates

The nominal discount rate is the sum of 1/ [(RPI(n) / RPI [degrees]) * (PTROR A M)], where:

* RPI(n) is the retail price index actual or forecast for the month of calculation.

* RPI [degrees] is the retail price index in the month of the first project cash flow.

* (M) is the month number from the month of the first project cash flow.

* PTROR is the post-tax real rate of return per month or l+6%A(l/2).

Taxation

The taxation treatment of the investment arises from the capital allowance rules, which replace depreciation in the calculation of taxable profits. The sum of the annual amount invested by asset is a capital allowances asset that is written off on a reducing balance basis (main pool WDA 20 per cent 2010- 11). Each year's capital allowance, multiplied by the prevailing rate of corporation tax, is the value of tax saved (the company was chargeable). *

Customers had been paying for use of the assets on a monthly basis in arrears. To account for payments made before the pricing revision, each payment was discounted from the asset start date to give the PV of payments received. The tax outflow resulting from the payments received was calculated at the prevailing rate of corporation tax.

[FIGURE 2 OMITTED]

In a similar way to a mortgage, any delays in making due payments resulted in the accumulation of interest. This meant that the outstanding principle, at a point in time, was repayable in equal, real-terms monthly payments over the remaining contract term. However, while this met the contractual need to achieve the real terms rate of return, inflation was then added to future payments so as to achieve the rule. Bear in mind that mortgage payments have a flat profile in nominal terms, while these payments were flat in real terms and increasing in nominal terms and the nominal payments changed subject to the customer's future asset usage profile. …

The rest of this article is only available to active members of Questia

Sign up now for a free, 1-day trial and receive full access to:

  • Questia's entire collection
  • Automatic bibliography creation
  • More helpful research tools like notes, citations, and highlights
  • Ad-free environment

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited article

Present Value Analysis for Pricing: Ad-Hoc Pricing Models Default to Using Excel, but What Happens When the Model Is Neither Robust nor Scalable to Cope with New Customers? This Case Study Offers Some Answers
Settings

Settings

Typeface
Text size Smaller Larger Reset View mode
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Full screen

matching results for page

Cited passage

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited passage

Welcome to the new Questia Reader

The Questia Reader has been updated to provide you with an even better online reading experience.  It is now 100% Responsive, which means you can read our books and articles on any sized device you wish.  All of your favorite tools like notes, highlights, and citations are still here, but the way you select text has been updated to be easier to use, especially on touchscreen devices.  Here's how:

1. Click or tap the first word you want to select.
2. Click or tap the last word you want to select.

OK, got it!

Thanks for trying Questia!

Please continue trying out our research tools, but please note, full functionality is available only to our active members.

Your work will be lost once you leave this Web page.

For full access in an ad-free environment, sign up now for a FREE, 1-day trial.

Already a member? Log in now.