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:

PeterA said...

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...)

Anonymous said...

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.

Anonymous said...

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.

Anonymous said...

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.

Anonymous said...

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!

Anonymous said...

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.

Anonymous said...

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

Anonymous said...

See Excel file here:

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

(previous link now broken)

Anonymous said...

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)

Anonymous said...

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