Tuesday, July 6, 2010

My Cost Benefit Analysis on the NBN


The Senate report ( process here, final report here, pdf (327k) here) on the viability of the NBN asked for a cost benefit analysis. Several have been done already, including:

* Ergas and Robson (2009) here, found $13 - 20 billion loss, based on all revenue generated from usage fees (reported here, pdf here)

* Gans (2009), found overall social benefits, using a month consumer payments and surplus analysis here, and pdf here.

* My previous attempt on this blog (Apr 2009), which suggested an operating shortfall of $40 million per month: available here.

I have updated my Cost benefit analysis of the NBN and attach it for your information (here ; updated for broken link, Apr.2013). Given the recent Senate Report calling for a cost benefit analysis, and media talk, I thought I would have a go at putting one together. About three hours work.

I found that to achieve a positive NPV, the NBN needs to add between 0.5 and 1.0% to GDP per annum. Approx $7 billion per annum, proportional to % build complete from network 50% complete. I add NPV for NBN Co, including projected revenue, depreciation, operating costs, but no interest.

This model assumes, funding/interest at 5%, consumer takeup maximum 70%, corporate takeup maximum 90% at year 8, pro rata over the course of the build, with accelerating takeup as the build passes 50% complete.

In the model I assume that the Federal Government pays interest on $43 billion invested at 5%. That Telstra loses 50% of its value over the network build (about $20 billion). That NBN Co earns profits, which pay down the $43 billion NBN investment, and NBN Operating expenses of 20% of depreciation (about $430 milllion after build). Depreciation straight line at 5% per annum.

Future adjustments to model could include: grossing Telstra loss up to future value (adds about $10 billion, and reduces NPV by $7 billion), adding other telco losses, eg Optus, AAPT, shaping GDP gains from high in mid term, and dropping over the longer term.

The spreadsheet allows all these variables to be manipulated and show the impact on NBN and National NPV. I look at cashflows for years 1-15, and discount at 5%, including debt outstanding at that point. If you have any questions about the model or would like to discuss it, please let me know.

10 comments:

  1. With the removal of the Telstra Copper, the shift of all Telstra customers from Telstra CAN (including paytv and foxtel Cable internet customers) - does that change the customer percentage takeup figures?
    Additionally all current ISPs shift all of their customers onto it due to the removal of the Telstra Copper (with the exception of Wireless ISPs, and in the worst case scenario for the NBN the Optus Cable and smaller complete infrastructure operators customers sticking with the existing infrastructure).
    What do those numbers do to your customer takeup percentages?
    (I only ask because even if Telstra didn't decommission the CAN surely the remaining 30% of customers that DONT shift to the NBN would not be enough to warrant Telstra maintaining it in any usable state...)

    ReplyDelete
  2. Thanks for all of the labor on this web site. My mum takes pleasure in engaging in research and it's really obvious why.[url=http://www.cheaptomsshoescity.com]Cheap Toms Shoes[/url]

    cheap toms , My partner and i learn all concerning the lively form you create advantageous guidance by means of your website and

    therefore invigorate participation from

    people about this

    matter while our own simple princess cheap toms outlet is always cheap toms outlet studying so much. Enjoy the remaining portion of the year.

    You are performing a fantastic job.

    ReplyDelete
  3. I wanted to draft

    you one very little

    word to help thank you so much yet again

    over the great solutions you've documented above. cheap oakley sunglasses ,It is quite

    remarkably generous of

    people like you to supply easily all that numerous people could

    possibly have

    marketed for an e-book to

    get some cash on their own,

    mostly given that you might have done it [url=http://www.sunglassesokcheap.com]oakley sunglasses[/url] discount oakley sunglasses if you

    ever [url=http://www.sunglassesokcheap.com]oakley sunglasses[/url]

    oakley sunglasses outlet desired. The good

    tips

    also acted to be the great way to be sure

    that some people have a similar zeal much like

    mine to learn whole lot more pertaining to this problem.

    I know

    there are thousands of more pleasurable sessions up front for

    individuals that

    scan your blog.

    ReplyDelete
  4. Thanks for all your valuable hard work on this website.

    Gloria really loves carrying

    out research and it's really easy to

    understand why.[url=http://www.longchampsacspliagefr.com]sac longchamp pliage[/url]

    sac longchamp ,

    We hear all relating to the dynamic tactic you convey great information on your

    web site and as well

    recommend participation from

    other people on this

    article while our simple princess sac longchamp pliage pas cher is undoubtedly sac longchamp pliage becoming educated a

    lot. Have fun with the rest of the new year.

    Your performing a first

    class job.

    ReplyDelete
  5. My spouse and i

    were [url=http://www.saclongchamppliagefr.org]sac longchamp pliage pas cher[/url] absolutely

    fortunate that Jordan could finish

    off his web

    research because of the ideas he

    made in

    your web pages. sac longchamp pliage pas cher ,It is now and again perplexing just to possibly be

    giving away ideas which often people may

    have been trying to sell. We fully understand

    we now have the website

    owner to appreciate

    because of that. The type of

    illustrations you made, the

    straightforward [url=http://www.saclongchamppliagefr.org]sac longchamp[/url] blog navigation, the

    relationships [url=http://www.saclongchamppliagefr.org]sac longchamp pliage pas cher[/url] you will give

    support to create - it's all

    sensational, and it's really making our son and our family recognize that

    the issue is satisfying, which is certainly tremendously fundamental. Thank you

    for all!

    ReplyDelete
  6. I wanted to draft

    you this very little

    remark just to thank you very much again

    for all the exceptional secrets you've shown on this page. sac longchamp ,This is really

    wonderfully open-handed of

    you to supply unreservedly all a few people might have sold for an ebook to earn some profit for themselves, and in

    particular now that you might well have tried it [url=http://www.longchampsacspliagefr.com]sac longchamp pliage pas cher[/url] sac longchamp pliage pas cher if you [url=http://www.longchampsacspliagefr.com]sac longchamp[/url]

    sac longchamp decided. These tactics

    likewise acted to become great way to

    understand that most people have similar dream much like

    mine to realize somewhat

    more on the subject of this condition.

    I think

    there are millions of more pleasurable

    periods in the future for folks who

    see your site.

    ReplyDelete
  7. Having read this I thought it was very informative.
    I appreciate you finding the time and energy to put this content together.

    I once again find myself personally spending a significant amount of time both reading and posting comments.
    But so what, it was still worth it!

    Here is my web-site :: uhaul

    ReplyDelete
  8. See Excel file here:

    http://www.mediafire.com/file/se3h5enxx2fa5ao/NBN_NPVyr1-15sensitivity.xls

    (previous link now broken)

    ReplyDelete
  9. I am regular visitor, how are you everybody? This post posted at this web page
    is truly good.

    My web-site: panic at the disco (en.wikipedia.org)

    ReplyDelete
  10. Hello, this weekend is good designed for me, because this point in time i am reading this great educational article here at my residence.


    Visit my web blog: CharlineEMigdal

    ReplyDelete