Tuesday, April 3, 2018

Is there a business case for the National Broadband Network?

I made a model to calculate the value of NBN for the Business Case Inquiry, using an online calculator(JavaScript) called an Observable Notebook.
See introduction to Observable Notebooks at: https://beta.observablehq.com/@mbostock/five-minute-introduction

I had a class in Feb at Melb Uni which showed these HTML sliders controlling the colour of a box; https://beta.observablehq.com/@maegul/basic-html-and-viewof-play and I thought it would be cool if you could make a model of NBN's finances and use a bunch of sliders to check out various scenarios eg

  • people leave NBN for mobile
  • people leave/stay with FTTN because too slow/good enough
  • when to replace FTTN with FTTC/FTTP (I ended up using two sliders. One to put $$$ aside to replace FTTN, as % of cash profit. The other is what to replace FTTN with, FTTC or FTTP or mix.)
So I wondered with a bunch of sliders, say six, could you model 100M possible scenarios.

As I say in my submission:
This submission introduces an online model which describes financial scenarios of NBN’s business over the next 20 years; including replacing FTTN with FTTC/FTTP, repaying debt, upgrading to gigabit services and the potential fallout of not replacing FTTN, to calculate NBN’s financial value under these different possible futures.

Figure 1. NBN Cashflow graph and four sliders.

Here the Observable model is - NBN Financials from 2021 on. The model rates a Base Case value of NBN at $31B. https://beta.observablehq.com/@areff2000/nbn-financials-from-2021-on-v5a-verbose-off

I was so rushed getting it finished, and 5pp summary(see figshare link) for NBN inquiry, didn’t think to share here, at Whirlpool, for comment. I should have.

Here is the link to the version with explanations; https://beta.observablehq.com/@areff2000/nbn-financials-from-2021-v5-on

Key findings of the model

  • NBN cash profit(EBITDA) after 2021 $2.44B per year
  • can afford to replace FTTN In 6-8 yrs depending on FTTC/FTTP, if not repaying debt
  • each loss 1% of customers worth $1B in NBN value
  • gigabit services can add $20B to NBN value
  • FTTN replacement pays for itself if 30% of FTTN users upgrade to gigabit
  • customer satisfaction has big impact on NBN value
  • where gigabit costs 2* avg ARPU...but higher margin...
  • Model suggests NBN will have enough $$$ to replace FTTN, if don’t have to repay debt urgently. Otherwise run into FTTN end of life and possible loss of customers...
Disclaimer; model had no tax, interest, inflation, price rises, but was built in four weeks, so there you go. The next thing I would add would be interest on debt, and a slider for the rate, to add a time dimension/penalty to the replacement of FTTN.

Any comments, as usual, appreciated.
rf


Links:
Twitter mention: https://twitter.com/valuemgmt/status/979110826643660800?s=21

Thursday, February 8, 2018

Why walk on the footpath when you can walk on the grass? ...a value choice...

Walking to the train this morning, I noticed the long grass verge next to the footpath, as if for the first time. They are upgrading the train near my house, so for the last three months I have had to walk for ten minutes to the 2nd closest train station. It is summer here, and so I had my slip on shoes on to keep cool.

On a whim, I took my shoes off, and walked on the grass instead of the footpath. My 900m walking commute suddenly became a walk in the park. #shoesOff The footpath in bare feet seemed alien and unfriendly. The grass, while uneven and coarse, I realised was gently massaging my feet.

I realised how dull my feet felt in shoes on pavement. While barefoot on grass, I felt more alive, more in touch with nature, more normal.

Then a young woman, headphones on, frightened me as she scooted past on the footpath, walking briskly. Left Right Left Right, she was soon gone up the road, as I ambled along enjoying the tickle of the grass on my soles.

Aha. I was having a value moment. In that choice between grass and concrete, between fast and slow, between smooth and bumpy, we were each finding our value. Hers was quick and smooth and efficient, while mine was bumpy, slow and (like an Aussie wit) laconical. Her value was functional while mine was pleasureable. Hers was a means to an end, while mine was an end in itself.

Monday, I will probably be scooting down the footpath, on a cooler day, socks and shoes on.

Value is thus an individual choice, in a perceived context, between value dimensions eg function vs pleasure, each according to their current momentary needs. That choice for me happened in an instant today, but not occurred to me over the previous three months.