347 647 9001+1 714 797 8196Request a Call
Call Me

GoDaddy IPO Valuation Model

September 18, 2014
, ,
GoDaddy IPO valuation model

Download: GoDaddy IPO Valuation Model

It started with me not getting selected in Deloitte which had come for summer internship. I had an exciting opportunity in risk consulting waiting for me, not to mention the remuneration associated with it. For any young guy looking to make it big in the field of Finance, it is a good step forward to say at the least. But, it wasn’t to be and I was one of those rejected in the final interview. Now, this is where life teaches us a lesson and it is important to understand the subtle difference between ‘Rejection’ and ‘Non-Selection’. The beauty of the matter is that the choice is all ours. I chose to believe in the latter and concluded that I need to keep going in search of the light at the end of tunnel and light there was and that too a shining bright ray of hope.

I didn’t sit in interview process of the companies which followed Delloite for multiple reasons, profile being one of them. Finally, Edupristine gave me opportunity to valuate GO DADDY which seemed exciting so I accepted.

Frankly speaking, no internship could have offered me better work and I was supposed to work from home. So, I was happy since my friends, most of them were working in marketing and operations, had to roam around Delhi in sultry afternoon.

I had no clue where to start. Honestly I didn’t even know where to get the data from which I came to know eventually though. I was assigned a mentor who helped me a lot.

One more good this project did was compel me to revise basic accounting concepts which had wiped out completely from my memory following the completion of the 1st term.

I started by doing basic formatting in Excel which is supposed to be similar for all sheets. Over the time I learnt lot more new things in excel which includes plethora of shortcuts.

Actually I developed knack for short cuts. Every time I had to do small thing like increasing the font, I would press ‘Alt+’ and look for the next key.

Eventually I managed to memorize lot of shortcuts which are frequently used in excel while doing modelling.

I faced lot of problems, most of them about making assumptions, but the major among all of them was matching cash in cash flow statement with the balance sheet.

I took me few days to figure out the mistake I committed while adjusting balance sheet items in the cash flow sheet.

The overall experience and a weird sense of achievement which I felt post completing the valuation was really fulfilling.

Below, I have mentioned step by step method which I followed to value GO DADDY. I hope it helps and inspires you to learn financial modelling.

Case 1- Data Collection

Since the company has registered for an IPO, its information can be retrieved from S1 form.

The figures are given in ‘000, so you may keep it like that or divide entire figures by 10^3.

All the figures which are directly taken from some source are blue coded while those which are derived are black coded.

Case 2- Understanding Business profile

Technology provider to small businesses, web design professionals and individuals, delivering simple, easy to use cloud-based products and outcome-driven, personalized Customer Care.

Operate the world’s largest domain marketplace, customers can find that unique piece of digital real estate that perfectly matches their idea.

Provide website building, hosting and security tools to help customers easily construct and protect their online presence and tackle the rapidly changing technology landscape.

Case 3- Modelling revenue and expense drivers

Identifying revenue drivers:

  • Domains
  • Hosting & Presence
  • Business Applications

Average Revenue Per Use [x]Total Customers [x]% of domain users Revenue

Operating Expenses except depreciation & amortization can modelled as %age of total revenues.

Since no information is provided regarding addition or deletion of assets. Depreciation & Amortization can be modelled as %age of PPE.

Case 4- Modelling Net Income

Interest Expense can be modelled as %age of long term debt. Net Income can be easily calculated after adjusting income tax. Benefit from income tax is modelled as %age of PBT.

Case 5- Completing Balance Sheet

A/c receivables can be modelled as days of revenue. Similarly, A/c payable is modelled as days of operating expenses. Registry deposits and pre domain name registry fee are modelled as %age of total customers.

Total customers can be easily forecasted, once y-o-y increase in total customers is calculated.

Case 6- Modelling Cash Flow

Cash Flow can be easily calculated by adjusting values from operating, investing and financing activities.

Cash Flow from operating activity:

  • Increase in liability – Out Flow of cash
  • Decrease in liability – In Flow of cash
Cash Flow from investing activity:
  • Increase in assets - In Flow of cash
  • Decrease in assets - Out Flow of cash
Cash Flow from financing activity:
  • Increase in Equity – In Flow of cash
  • Decrease in Equity - Out Flow of cash

Case 7- Calculating Ratios

Revenue Mix can be calculated by taking ratio of individual revenue drivers and total revenue.

Gross Margin can be calculated by taking gross ratio with total revenue. Liquidity and Leverage ratios can be calculated easily.

Case 8- DCF Valuation

We have used discounted cash flow method for valuation. FCFE is calculated using:

PAT (Consolidated)

[+] Depreciation, Amortization & Impairment [-] Change in Working Capital [-] Capital Expenditure [-] Debt Repayment, Net FCFE FCFE is discounted with cost of equity.

Assumptions in calculating cost of equity:

  • Risk free rate is taken as the average of maximum and minimum return offered on US treasury bonds with maturity of 10 years.
  • Beta is taken as the average of different values provided by different sources.
  • Expected return is again taken as average of values found in magazines, newspapers, articles etc.
  • Terminal growth rate is taken between the GDP growth rate of developing and developed nations. Since, their businesses come from countries like US, India.

Case 9- Sensitivity Analysis

Since we have taken assumptions in calculating cost of equity and terminal growth rate, we need to do sensitivity analysis to check the effect of variation in these two parameters on the stock price.


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 63377