Join today and have your say! It’s FREE!

Become a member today, It's free!

We will not release or resell your information to third parties without your permission.
Please Try Again
{{ error }}
By providing my email, I consent to receiving investment related electronic messages from Stockhouse.

or

Sign In

Please Try Again
{{ error }}
Password Hint : {{passwordHint}}
Forgot Password?

or

Please Try Again {{ error }}

Send my password

SUCCESS
An email was sent with password retrieval instructions. Please go to the link in the email message to retrieve your password.

Become a member today, It's free!

We will not release or resell your information to third parties without your permission.
Quote  |  Bullboard  |  News  |  Opinion  |  Profile  |  Peers  |  Filings  |  Financials  |  Options  |  Price History  |  Ratios  |  Ownership  |  Insiders  |  Valuation

Yellow Pages Ltd T.Y

Alternate Symbol(s):  YLWDF

Yellow Pages Limited is a Canada-based digital media and marketing company. The Company offers targeted tools to local businesses, national brands and consumers, allowing them to interact and transact within the digital economy. It offers small and medium-sized enterprises (SMEs) across Canada full-serve access to a comprehensive suite of digital and traditional marketing solutions, such as online and mobile priority placement on its digital media properties, content syndication, search engine solutions, Website fulfillment, social media campaign management, digital display advertising, video production, e-commerce solutions as well as print advertising. The Company’s media properties, primarily desktop, mobile and print, continue to serve as effective marketplaces for Canadian local merchants, brands and consumers. It holds online properties including YP.ca, Canada411 and 411.ca. It also holds the YP, Canada411 and 411 mobile applications and Yellow Pages print directories.


TSX:Y - Post by User

Post by nozzpackon Apr 27, 2021 8:44am
113 Views
Post# 33073078

Forecasted Cash flows in 2021

Forecasted Cash flows in 20211..Simple Method

Balance sheet Cash increased by $10.5 million in January 2021.
Annualized, that is 12 X $10.5 m = $126 million.

Conversion rate of cash flows to cash = 86% in 2020.

That is, cash flows in 2021 = $126 m / 0.86 = $146 million


2..Operating gains and losses


Revenue declined by 17 % in 2020 to $334 m

Assume decline is 11 % in 2021 to $300 m.

At 60 % gross margin, cash flows will be reduced by $34 m X 60 % =  $20.5 m .


Cash flows Gains and losses in 2021

reduced gross margin effect                                                   -$20.5 reduced Interest Expense ( 7/12 X $11.1m )                          +6.5 m
Reduced Restruct Expenses ( $8.1 m -$2.1 m)                     +6.0 m
one time cost CEO LTIP                                                         +4.0 m
Reduction in Capex ( $5.6 m -$3.6 m )                                  +2.0 m
Reduction in NCIB ( $5 m - $3.3 m)                                       +1.6 m

Total                                                                                        -$0.4 m 

A couple of issues are more complicated to estimate.

Other operating expenses were $204 million in 2020 but only $196 m in Q4 /20 annualized , which is a gain of $8 million.

I chose Q4/20 , as manpower expenses were lowest due to accrued   reductions in 2020 head counts in Q4.

Including this gain relative to 2020, and operating cash flows in 2021 relative to 2020 will be that of 2020 ( $127.1 m ) plus $7.6 m which is 
$134.7 m .


Q1/21 will have additional data with which to fine tune these calculations.

But, as it stands right now, 2021 cash flows are forecast to be in the $134.7 m to $146 m range.

In 2020, 86 % of cash flows was converted to cash.

That is cash levels in 2021 will increase by  $116 m to  $125 million.
This places cash levels at exit 2021 at or very near $200 m ( $7.15 per share ) and no debt.

Comments will be welcome.
<< Previous
Bullboard Posts
Next >>