{"id":1241,"date":"2022-09-04T18:28:44","date_gmt":"2022-09-04T23:28:44","guid":{"rendered":"https:\/\/studyingstocks.com\/?p=1241"},"modified":"2022-09-04T18:53:41","modified_gmt":"2022-09-04T23:53:41","slug":"updates-on-the-stock-analysis-template","status":"publish","type":"post","link":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/","title":{"rendered":"Updates on the stock analysis template"},"content":{"rendered":"\n

Hi everyone,<\/p>\n\n\n\n

Just published another version of the google sheets stock analysis template that address a few of the feedbacks we received so far.<\/p>\n\n\n\n

There were a couple of cosmetic change to make it more user friendly and one major change in the DCF calculation itself. Now, instead of calculating the fair value based on only 5 years of FCF, we extended it to 10 years.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

The reason why is because before, since we were only estimating 5 years, most of the times the FCF growth was changing from double digits to the terminal growth. For example, if year-5 the FCF growth was 15%, year 6 and forward would be suddenly 2.5% (terminal growth), which doesn’t make sense.<\/p>\n\n\n\n

Therefore the change made was that now we slowly progress the growth after year 5 towards the terminal growth, which is more realistic.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Another small change was in the weight of the projections. Before, whenever a percentage was changed, it would affect only that specific year but now, as it can be seen in the picture on the right, the change affects the years after that as well.<\/p>\n\n\n\n

.<\/p>\n\n\n\n

\n\n\n\n

How to get this latest template?<\/h2>\n\n\n\n
  1. If you don’t have an API Key yet, get yours FREE by filling the form in this page<\/a><\/li>
  2. Make a copy of this template spreadsheet<\/strong><\/a> to your own google drive.
    1. In the top menu, go to File > Make a Copy<\/em> (remember to be signed in with your google account)<\/li>
    2. Click Make a copy<\/em><\/li><\/ol><\/li>
    3. Open the version you just copied and add your access key in the cell C6<\/li>
    4. Type the stock ticker you want to analyze in the cell C8 (Ex: AAPL, MSFT, TSLA\u2026)<\/li>
    5. Enjoy!<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"

      Hi everyone, Just published another version of the google sheets stock analysis template that address a few of the feedbacks we received so far. There<\/p>\n","protected":false},"author":1,"featured_media":1244,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"pgc_sgb_lightbox_settings":"","footnotes":""},"categories":[21],"tags":[],"yoast_head":"\nUpdates on the stock analysis template - Studying Stocks<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Updates on the stock analysis template - Studying Stocks\" \/>\n<meta property=\"og:description\" content=\"Hi everyone, Just published another version of the google sheets stock analysis template that address a few of the feedbacks we received so far. There\" \/>\n<meta property=\"og:url\" content=\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/\" \/>\n<meta property=\"og:site_name\" content=\"Studying Stocks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/studyingstocks0\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-04T23:28:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-04T23:53:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/studyingstocks.com\/blog\/wp-content\/uploads\/2022\/09\/ocver.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@studyingstocks0\" \/>\n<meta name=\"twitter:site\" content=\"@studyingstocks0\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/#\/schema\/person\/9de3132e1ec39ccbac29dd05f1dfb4ac\"},\"headline\":\"Updates on the stock analysis template\",\"datePublished\":\"2022-09-04T23:28:44+00:00\",\"dateModified\":\"2022-09-04T23:53:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/\"},\"wordCount\":284,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/studyingstocks.com\/blog\/#organization\"},\"articleSection\":[\"Analyses\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/\",\"url\":\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/\",\"name\":\"Updates on the stock analysis template - Studying Stocks\",\"isPartOf\":{\"@id\":\"https:\/\/studyingstocks.com\/blog\/#website\"},\"datePublished\":\"2022-09-04T23:28:44+00:00\",\"dateModified\":\"2022-09-04T23:53:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/studyingstocks.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Updates on the stock analysis template\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/#website\",\"url\":\"https:\/\/studyingstocks.com\/blog\/\",\"name\":\"Studying Stocks\",\"description\":\"Learning the basics of value investing\",\"publisher\":{\"@id\":\"https:\/\/studyingstocks.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/studyingstocks.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/#organization\",\"name\":\"Studying Stocks\",\"url\":\"https:\/\/studyingstocks.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/studyingstocks.com\/wp-content\/uploads\/2022\/02\/cropped-cropped-Logo-and-name.png\",\"contentUrl\":\"https:\/\/studyingstocks.com\/wp-content\/uploads\/2022\/02\/cropped-cropped-Logo-and-name.png\",\"width\":1900,\"height\":674,\"caption\":\"Studying Stocks\"},\"image\":{\"@id\":\"https:\/\/studyingstocks.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/studyingstocks0\",\"https:\/\/twitter.com\/studyingstocks0\",\"https:\/\/www.instagram.com\/studyingstocks\/\",\"https:\/\/www.pinterest.com\/studyingstocks\/\",\"https:\/\/www.youtube.com\/channel\/UC9c88cazCxNRYKdzzCV32Iw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/#\/schema\/person\/9de3132e1ec39ccbac29dd05f1dfb4ac\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/studyingstocks.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/08ae7a6cbd05782ef4f78f3cc5336c68?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/08ae7a6cbd05782ef4f78f3cc5336c68?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/studyingstocks.com\"],\"url\":\"https:\/\/studyingstocks.com\/blog\/author\/studyingstocks_loxq00\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Updates on the stock analysis template - Studying Stocks","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/","og_locale":"en_US","og_type":"article","og_title":"Updates on the stock analysis template - Studying Stocks","og_description":"Hi everyone, Just published another version of the google sheets stock analysis template that address a few of the feedbacks we received so far. There","og_url":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/","og_site_name":"Studying Stocks","article_publisher":"https:\/\/www.facebook.com\/studyingstocks0","article_published_time":"2022-09-04T23:28:44+00:00","article_modified_time":"2022-09-04T23:53:41+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/studyingstocks.com\/blog\/wp-content\/uploads\/2022\/09\/ocver.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@studyingstocks0","twitter_site":"@studyingstocks0","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/#article","isPartOf":{"@id":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/"},"author":{"name":"admin","@id":"https:\/\/studyingstocks.com\/blog\/#\/schema\/person\/9de3132e1ec39ccbac29dd05f1dfb4ac"},"headline":"Updates on the stock analysis template","datePublished":"2022-09-04T23:28:44+00:00","dateModified":"2022-09-04T23:53:41+00:00","mainEntityOfPage":{"@id":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/"},"wordCount":284,"commentCount":0,"publisher":{"@id":"https:\/\/studyingstocks.com\/blog\/#organization"},"articleSection":["Analyses"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/","url":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/","name":"Updates on the stock analysis template - Studying Stocks","isPartOf":{"@id":"https:\/\/studyingstocks.com\/blog\/#website"},"datePublished":"2022-09-04T23:28:44+00:00","dateModified":"2022-09-04T23:53:41+00:00","breadcrumb":{"@id":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/studyingstocks.com\/blog\/updates-on-the-stock-analysis-template\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/studyingstocks.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Updates on the stock analysis template"}]},{"@type":"WebSite","@id":"https:\/\/studyingstocks.com\/blog\/#website","url":"https:\/\/studyingstocks.com\/blog\/","name":"Studying Stocks","description":"Learning the basics of value investing","publisher":{"@id":"https:\/\/studyingstocks.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/studyingstocks.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/studyingstocks.com\/blog\/#organization","name":"Studying Stocks","url":"https:\/\/studyingstocks.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/studyingstocks.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/studyingstocks.com\/wp-content\/uploads\/2022\/02\/cropped-cropped-Logo-and-name.png","contentUrl":"https:\/\/studyingstocks.com\/wp-content\/uploads\/2022\/02\/cropped-cropped-Logo-and-name.png","width":1900,"height":674,"caption":"Studying Stocks"},"image":{"@id":"https:\/\/studyingstocks.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/studyingstocks0","https:\/\/twitter.com\/studyingstocks0","https:\/\/www.instagram.com\/studyingstocks\/","https:\/\/www.pinterest.com\/studyingstocks\/","https:\/\/www.youtube.com\/channel\/UC9c88cazCxNRYKdzzCV32Iw"]},{"@type":"Person","@id":"https:\/\/studyingstocks.com\/blog\/#\/schema\/person\/9de3132e1ec39ccbac29dd05f1dfb4ac","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/studyingstocks.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/08ae7a6cbd05782ef4f78f3cc5336c68?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/08ae7a6cbd05782ef4f78f3cc5336c68?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/studyingstocks.com"],"url":"https:\/\/studyingstocks.com\/blog\/author\/studyingstocks_loxq00\/"}]}},"_links":{"self":[{"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/posts\/1241"}],"collection":[{"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/comments?post=1241"}],"version-history":[{"count":9,"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/posts\/1241\/revisions"}],"predecessor-version":[{"id":1260,"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/posts\/1241\/revisions\/1260"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/media\/1244"}],"wp:attachment":[{"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/media?parent=1241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/categories?post=1241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studyingstocks.com\/blog\/wp-json\/wp\/v2\/tags?post=1241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}