stock analysis continued

CAPELLA UNIVERSITY

FPX-5008-ASSESSMENT 2 (STOCK HISTORY ANALYSIS) HENRY WEBER-INSTRUCTOR

RASHAE WILLIAMS MAY 11, 2021

TPG TELCOM COMPANY STOCK HISTORY ANALYSIS

INTRODUCTION

Background

Total Peripherals Group was established in 1986 by Malaysian-born Australian

businessman known as David Teoh. It was started as an IT company that sold OEM computers and later moved to provide Internet and Telephone services. By August 2015, TPG became the second largest internet service provider in Australia and the biggest mobile virtual network operator.

Statistically the company had more than 671,000 ADSL2+ subscribers and 358,000 landline subscribers and 360,000 mobile subscribers, and owns the second largest ADSL2+ network in Australia consisting of 391 ADSL2+ DSLAMs. It also has its functions operating in Singapore and New Zealand.

The company was formed from the merger between Total Peripherals Group, which was established in 1986 by David and Vicky Teoh, and SP Telemedia in 2008. In August 2018, TPG and Vodafone Hutchison Australia announced their intention to merge, with TPG holding a 49.9% stake in the merged company. This proposition was opposed by the Australian competition and consumer commission, although later on February 2020 Federal court of Australia decided against the merger. TPG provided five ranges of products and services including Internet access, networking, OEM services, mobile phone service and accounting software. Vodafone++

Hutchson merged with TPG Telecom via schemes. TPG Telecom was renamed to TPG Corporation Limited and delisted from ASX, with Vodafone Hutchison taking on the TPG Telecom name.

TPG Telecom has posted a strong full year for FY2021 financials for its first post-merger results thanks to an increase in market share for fixed-line NBN and strong enterprise sales.

In the 12 months ended 31 December 2020, TPG reported net profit after tax of $734 million, revenue of $4.35 billion and EBITDA of $1.39 billion.

All metrics represented sizable increases from the previous year as the FY2019 full year results only accounted for Vodafone’s full year financials and just six months of TPG’s financials at the time.

( highest stock price ) ( lowest stock price )Graphical Representation of Data

a) Scatter Plot of highest stock price

To plot this graph, select the column with subhead high and the time column. Click the Insert tab, and then click Insert Scatter (X, Y)

( High 12 10 8 6 4 2 0 3/10/2020 6/18/2020 9/26/2020 1/4/2021 4/14/2021 7/23/2021 time ) ( Low 10 9 8 7 6 5 4 3 2 1 0 3/10/2020 6/18/2020 9/26/2020 time 1/4/2021 4/14/2021 7/23/2021 )

To plot this scatter plot, select the column with subhead low and the time column. Click the Insert tab, and then click Insert Scatter (X, Y) .

b) Histogram adj close

To plot this graph, Select the entire dataset headed close,Click the Insert tab, In the Charts group, click on the ‘Insert Static Chart’ option, and finally In the Histogram group, click on the Histogram chart icon.

c) Histogram of the stock trading volume

To plot this graph, Select the entire dataset headed volume, Click the Insert tab, In the Charts group, click on the ‘Insert Static Chart’ option, and finally In the Histogram group, click on the Histogram chart icon.

Descriptive Representation of Data

a) Adjusted daily closing stock price i) Mean= 7.340094

ii) Median=7.36

iii) Mode=7.3

iv) Standard Deviation=0.654615

To find the mean use the formula “=AVERAGE (E2:E214), to find median use “=MEDIAN (E2:E214)”, to find mode use “=MODE(E2:E214)” and finally to get std use “=STDEV(E2:E214)” formulas

b) Stock Volume

i) Mean =1173870

ii) Median=926995

iii) Mode=NA

iv) Standard=876623.3

To find the mean use the formula “=AVERAGE (F2:F214), to find median use “=MEDIAN (F2:F214)”, to find mode use “=MODE(F2:F214)” and finally to get std use “=STDEV(F2:F214)” formulas

References

Dodge, Y. (2008). The Concise Encyclopedia of Statistics. Springer.

Everitt, B. S.; Skrondal, A. (2010), The Cambridge Dictionary of Statistics, Cambridge University Press.

Data Source: Yahoo Finance

Data Source: TPG Telcom Company