My Goals: 1.To bring my deep understanding of innovation, technology and industry transitions to improve local innovation practices and drive consumer value.
viewof pic5 = {
const pl = DOM.element('div');
var layout = {
showlegend: true,
title: "NBN Revenue vs EBITDA 2016-2024, update 2021-24 Corp Plan",
barmode: 'stack',
xaxis: {
title: 'Year',
dtick: 1
}, // x-axis
yaxis: {
range: [-4, 8],
title: '$B / M',
dtick: 1
} // y-axis
}
var trace1 = {
x: years,
y: revenue,
name: 'Revenue est. 18 $B',
type: 'line'
};
// variables with 19 suffix indicate update info from Strat Plan 2019-22
var trace19 = {
x: years,
y: revenue19,
name: 'Revenue est. 19 $B',
type: 'line'
};
var trace199 = {
x: years,
y: revenue20,
name: 'Revenue est. 20 $B',
type: 'line'
};
var trace1999 = {
x: years,
y: revenue21,
name: 'Revenue est. 21 $B',
type: 'line'
};
var trace7 = {
x: years,
y: usersMeoy,
name: 'Activated USERS est. 18 (M)',
type: 'line',
color: 'yellow'
};
var trace79 = {
x: years,
y: usersMeoy19,
name: 'Activated USERS est. 19 (M)',
type: 'line',
color: 'yellow'
};
var trace799 = {
x: years,
y: usersMeoy20,
name: 'Activated USERS est. 20 (M)',
type: 'line',
color: 'black'
};
var trace7999 = {
x: years,
y: usersMeoy21,
name: 'Activated USERS est. 21 (M)',
type: 'line',
color: 'black'
};
var trace9 = {
x: years,
y: ebitda21,
name: 'EBITDA post subs. est 21 ($B)',
type: 'line',
color: 'black'
};
var trace99 = {
x: years,
y: ebitda20,
name: 'EBITDA post subs. est 20 ($B)',
type: 'line',
color: 'light green'
};
var trace999 = {
x: years,
y: ebitda19,
name: 'EBITDA post subs. est 19 ($B)',
type: 'line',
color: 'black'
};
var trace9999 = {
x: years,
y: ebitda18,
name: 'EBITDA post subs. est 18 ($B)',
type: 'line',
color: 'black'
};
plotly.newPlot(pl, [ trace1, trace19, trace199, trace1999, trace9, trace99, trace999, trace9999], layout)
return pl
}
usersMeoy20= { return [1.1, 2.4, 4.0, 5.5, 7.0, 8.1, 8.4, 8.6]; }
usersMeoy21= { return [1.1, 2.4, 4.0, 5.5, 7.3, 8.2, 8.6, 8.8, 9.0]; }
subPays20 = { return [0.6, 1.6, 2.7, 1.9, 2.3, 1.3, 0.4]; }
subPays21 = { return [0.6, 1.6, 2.7, 1.9, 2.4, 1.1, 0.3, 0.1]; }
accSubPays20 = { return [0.6, 2.2, 4.9, 6.8, 9.1, 10.4, 10.8]; }
accSubPays21 = { return [0.6, 2.2, 4.9, 6.8, 9.2, 10.3, 10.6, 10.7]; }
md `EBITDA ($B): ^5, p.55, ^4, p.48, ^3, p.38, ^1, p.32`
ebitda21 = { return [,-2.7,-2.3,-1.7, -0.6,1.3, 3.3, 4.0, 4.5]; }
ebitda20 = { return [,-2.7,-2.3,-1.7, -1.4, 0.8, 2.4, 3.2]; }
ebitda19 = { return [,-2.7,-2.3,-1.7, -1.4, 1.3, 2.5]; }
ebitda18 = { return [,-2.7,-3.4,-2.4, 0.7, 2.2]; }
md`Cashflows Out ($B): ^1 p.34; ^2 p.101; ^4 p.48.`
cashOUT20 = { return [6.8, 6.9, 7.6, 7.5, 6.1, 2.1, 0.2]; }
cashOUT21 = { return [6.8, 6.9, 7.6, 7.5, 6.1, 2.1, 0.2]; } // cash not reported in Corp Plan 2021
debt20 = { return [0, 0, 5.5, 13.1, 19.2, 21.3, 21.5]; }
debt21 = { return [0, 0, 5.5, 13.1, 19.2, , , , 27.5]; }
totExp20 = { return [1.4, 1.8, 2.4, 2.6, 2.9, 2.9];
// fixed + var
}
accExp20 = { return [1.4, 3.2, 5.6, 8.2, 11.1, 14.0];
// excluding Subs
// annual - 1.4, 1.8, 2.4, 2.6, 2.6, 2.8
}
capex20 = { return [4.7, 5.8, 5.7, 5.9, 4.3, 1.7, 1.4, 1.4]; }
capex21 = { return [4.7, 5.8, 5.7, 5.9, 5.0, 3.4, 3.8, 2.4, 2.2]; }
revenue20 = { return [0.4, 1.01, 2.02, 2.8, 3.7, 4.9, 5.6, 5.9]; }
revenue21 = { return [0.4, 1.01, 2.02, 2.8, 3.8, 4.5, 5.4, 5.8, 6.2]; }
One platform to build and deploy the best data apps
Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.