TwitterFacebookLinkedInEmailRSS
logo

An editorial blog of CFA Society Minnesota

  • Home
  • About Us
  • Contact Us
    • Compensation Survey Contact Form
  • Subscribe to Blog via Email

Tag Archives: valuation

Easy as (Lotus) 123

6th October, 2014 · John Boylan, CFA · Leave a comment
John Boylan, CFA

Not long ago I wrote about how many securities analysts including myself have a strong, almost obsessive, preference towards calculator brands. Every so often I also get asked which software I prefer to analyze securities as well. Over time my answer has changed—to a simple spreadsheet.

Before you write me off as some technology Luddite (which my children did long ago), I believe there is a great deal of value within analytical software. I personally use these tools constantly. It saves a lot of time screening securities, determining potential valuations, and figuring out statistical nuances between competing investments. Most importantly is helps investment teams speak the same valuation language—at least in the initial investment discussion.

In other words, we all have “go to” tools in our valuation toolbox, which may differ dramatically from our co-workers favorite methodologies. Therefore having analytical software can help teams start with a base scenario for a particular security in which everyone can understand and discuss. However, it is the main tool I use to determine valuation and investment value? At least for me—no.

So why do I prefer the simple spreadsheet? It goes toward the qualitative side of investing—what I consider its art. So what is art (if you ever lived in Madison, WI in the 1980’s, you know Art was a window washer)? For me personally, the art of investing means determining the right questions to ask. Spending the half day to a day or so it takes me to generate models of the various financial statements of a company helps me think deeply about what happened in the company’s past as I enter those numbers into the spreadsheet. Can I see those same numbers much more quickly with analytical software? Yes, but in a strange way I find myself glossing over them more if they are merely provided to me as opposed to trying to build a model and trying to understand why a certain number or ratio is what it is. I have more intellectual ownership of the analysis if I build a model from scratch. Additionally it is a lot easier to make notes on your model changes in the spreadsheet than in analytical software. I wish I knew how many times I created a scenario in a software program and came back to it several weeks later wondering why I used the numbers that I did.

Again, I do find those products very useful and I use them quite a bit. However, if I want to really dig down deep into a company, I find the good old fashioned spreadsheet works best for me. Plus I may not not as a big of a technology Luddite as I think, as I once knew a person who did their models using just a calculator and MSWord.

 

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to email this to a friend (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
Posted in Freezing Assets Shout Out, Local Charterholders | Tags: freezing assets shout out, Lotus, number crunching, technology, valuation |

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Recent Posts

  • Important Minnesota Financial Literacy Legislation Update 03/20/2023
  • New Financial Literacy Effort Launched for Minnesota Communities and Schools 09/30/2022
  • End of an Era 07/26/2022
  • Starting my Midwestern Goodbye 04/05/2022
  • Face-Off 10/18/2021

Submit your inquiry here

Categories

  • Compliance (3)
  • Department of Labor Fiduciary Rule (1)
  • Ethics (7)
    • Ask the Ethicist (2)
  • Freezing Assets Shout Out (34)
  • Hot Topic Commentary (177)
  • Intellisight (1)
  • Local Charterholders (88)
  • Member Spotlight (4)
  • Society President Letters (15)
  • Spotlight on MN Companies (1)
  • Valuation (2)
  • Weekly Credit Wrap (35)

Archives

  • March 2023 (1)
  • September 2022 (1)
  • July 2022 (1)
  • April 2022 (1)
  • October 2021 (1)
  • August 2021 (1)
  • May 2021 (1)
  • February 2021 (1)
  • January 2021 (2)
  • October 2020 (2)
  • September 2020 (2)
  • August 2020 (1)
  • June 2020 (1)
  • February 2020 (1)
  • December 2019 (1)
  • November 2019 (2)
  • October 2019 (1)
  • September 2019 (1)
  • August 2019 (1)
  • July 2019 (2)
  • June 2019 (1)
  • April 2019 (3)
  • March 2019 (2)
  • February 2019 (1)
  • January 2019 (2)
  • December 2018 (1)
  • November 2018 (2)
  • October 2018 (3)
  • September 2018 (1)
  • April 2018 (3)
  • March 2018 (8)
  • February 2018 (3)
  • January 2018 (1)
  • November 2017 (5)
  • September 2017 (1)
  • August 2017 (3)
  • July 2017 (1)
  • June 2017 (1)
  • May 2017 (1)
  • April 2017 (2)
  • March 2017 (1)
  • December 2016 (2)
  • November 2016 (2)
  • October 2016 (1)
  • September 2016 (1)
  • August 2016 (1)
  • July 2016 (2)
  • June 2016 (5)
  • May 2016 (2)
  • April 2016 (2)
  • February 2016 (5)
  • January 2016 (3)
  • December 2015 (1)
  • November 2015 (4)
  • October 2015 (6)
  • September 2015 (1)
  • July 2015 (1)
  • June 2015 (6)
  • April 2015 (2)
  • March 2015 (4)
  • February 2015 (2)
  • December 2014 (2)
  • November 2014 (7)
  • October 2014 (10)
  • September 2014 (3)
  • August 2014 (5)
  • July 2014 (2)
  • June 2014 (5)
  • May 2014 (9)
  • April 2014 (9)
  • March 2014 (8)
  • February 2014 (7)
  • January 2014 (8)
  • December 2013 (6)
  • November 2013 (7)
  • October 2013 (13)
  • September 2013 (4)
  • August 2013 (2)

Popular Tags

#memberspotlight 2015 Compensation Survey A Day in the Life BlackRock Board of Directors Carlson School of Management CFA CFA Charter CFA Charterholder CFA Charterholders CFA Institute CFA Institute Research Challenge CFA Minnesota CFAMN CFA Program CFA Society Minnesota CFA Society MN Changing Perceptions Chartered Financial Analyst charterholders Compensation Survey Diversity ESG ethics freezing assets shout out interest rates investment management Josh Howard Joshua M. Howard Member Engagement Minnesota non-GAAP earnings North Dakota Nuveen Asset Management President's Letter SEC Society President South Dakota Susanna Gibbons University of Minnesota Volunteer Volunteering Volunteers Weekly Credit Wrap women in finance
© 2021 CFAMN Freezing Assets - Please note that the content of this site should not be construed as investment advice, nor do the opinions expressed necessarily reflect the views of CFAMN, FreezingAssets.org or CFA Institute.
  • Home
  • Log In
  • RSS Feed