Investment software for private investors

Valuation using Ability to Pay

This method is based on an idea that the company’s own cash flow should be able to pay for its acquisition over a reasonable length of time with a healthy margin left for safety. It assumes a buyer purchases the business using mainly money borrowed from lenders. It involves calculating the cash flow available for debt payments after deducting 20% to 50% as safety margin. The value of the business is the maximum loan amount that this cash flow can support.

+Which UK company?

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Valuing "WPP WPP PLC"

Valuation Assumptions

Latest quoted share price £  
Number of ordinary shares  
 
Number of years to project    
Required annual rate of return   %  
 
Latest reporting financial year    
Total cash & cash equivalents £
Total interest-bearing debts £
Market value £
Sales £
Sales annual growth   %  
Operating profit margin   %  
Corporate tax rate   %  
 
Depreciation £
Depreciation annual growth   %  
Amortization £
Amortization annual growth   %  
 
Capital expenditure £
Capital expenditure annual growth   %  
 
Loans
Loan to value   %  
Interest rate on loans   %  
Loan term in years    

Valuation Results

  • Price & Intrinsic Value Chart
  • £5.11
    Highest price you can pay to get 10% annual return
    0%
    Your annual return if you pay at market price £8.91
    10%
    Your annual return if you pay at intrinsic value £1.59
    -82.2%
    Value Vs Price variation

Projection

Year Growth Sales Depreciation Amortization Capex
2024 5.6% £15,676,320,000 £455,466,000 £0 £255,597,333
2025 5.6% £16,554,193,920 £469,129,980 £0 £258,153,307
2026 5.6% £17,481,228,780 £483,203,879 £0 £260,734,840
2027 5.6% £18,460,177,591 £497,699,996 £0 £263,342,188
2028 5.6% £19,493,947,536 £512,630,996 £0 £265,975,610

Calculations

Market price or asking price £5,664,533,327
Loans from lenders at LTV 70% with interest rate at 5% for 10 years £3,965,173,329
30% Cash provided from buyer £1,699,359,998
Average revenue over the period £17,533,173,565
Estimated operating profit margin (%) 3.3
Average operating profit over the period £578,594,728
- Less average acquisition interest expenses over the period £116,990,754
Average profit before tax £461,603,974
- Less corporate income tax at 29% £133,865,152
Average profit after tax £327,738,821
+ Add average depreciation over the period £483,626,170
+ Add average amortization over the period £0
+ Add average acquisition interest expenses over the period £116,990,754
Average net cash flow after tax £928,355,745
- Less average capex over the period £260,760,656
Average net cash flow before debt service £667,595,090
- Less cash flow safety cushion required £169,936,000
Net cash flow available for debt service £497,659,090
Maximum loan that can be supported by cash flow £3,842,791,578
Value of company operations (£3,842,791,578 / 70%) £5,489,702,254
+ Add cash & cash equivalents £2,218,000,000
- Less total interest-bearing debts £5,995,000,000
Business intrinsic value £1,712,702,254
Business intrinsic value per share £1.59

+Tips & Advice

  • Sales are generally more predictable than earnings and can give a useful indication of the company’s positions in its markets. Sales growth from organic operations such as price increases, new products and new markets are much cheaper and more sustainable than growth from acquisitions. Big and too many acquisitions can lead to culture clash and goodwill write-offs when the economy take a turn for the worst. Look for businesses that can generate internally funded future long-term average sustainable growth of 10% to 20%. Very high growth rates rarely last.
  • Operating profit margin or return on sales shows management’s ability to manage costs, overheads and operate efficiently. It also indicates a company’s ability to withstand adverse conditions such as falling prices, rising costs or declining sales. A well-managed company tends to have stable or increasing margins. Beware if they are declining rapidly, especially on profit margins of only 5%, there is little room for error. With the exception of the supermarket business that is often heavily dependent on volume and usually has a low return on sales. Operating margins of 7.5% should be the minimum and 10% to 20% would be the ideal range. Cross-check with return on total assets for a more reliable business performance check.
  • Risk-free rate is a theoretical rate of return that an investor would expect from a totally risk-free investment over a specific period of time. In the real world, every investment has a risk. For business valuation purposes, most investors estimate the long-term risk-free rate using the US government 10-year treasury bill, UK government 10-year gilt or the German government 10-year bund. This is because these three countries are seen to have a stable economy and are highly unlikely to default on their bonds.
  • Depreciation is an allocation of the cost of an asset over a period of time for accounting and tax purposes. It is charged against earnings on the basis that the use of capital assets is a legitimate cost of doing business. Highly competitive capital-intensive business such as car manufacturer often has depreciation expense runs anywhere from 22% to 57% of its gross profits. Companies with strong business franchise such as Coca-Cola and Procter & Gamble depreciation expense runs between 6% to 8%. Depreciation is also a non-cash expense that is added back to net income to determine the company’s cash flow.
  • Many businesses, legally, take advantage of financial engineering to minimise the tax payable on their underlying activities. In a sense, reported profit can be thought of as the sum of “real” earnings and “artificial” tax manoeuvres. Where a tax rate appears low, the underlying profit may be lower than the reported figures suggest. Companies sometimes can enjoy tax-driven benefits because of loss carry forwards but this will eventually become exhausted. A consistent trend of apparently low tax rates than the expected rate is a strong danger signal.