{"id":18074,"date":"2021-07-20T06:37:31","date_gmt":"2021-07-20T06:37:31","guid":{"rendered":"https:\/\/analystprep.com\/study-notes\/?p=18074"},"modified":"2024-04-05T06:01:39","modified_gmt":"2024-04-05T06:01:39","slug":"spreadsheet-general-modeling","status":"publish","type":"post","link":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/","title":{"rendered":"Spreadsheet (General) Modeling"},"content":{"rendered":"<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/fiJA5WhgigU\" width=\"611\" height=\"343\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\r\n\r\n<p>Dividend discount models assume a stylized pattern of dividend growth. However, the dividend growth may follow a variety of patterns. Therefore, spreadsheet modeling is used to forecast any dividend pattern.<\/p>\r\n<p>In addition, spreadsheets allow analysts to build complicated models, perform scenario analysis, and exchange information by sharing their spreadsheet models. Compared to the stylized models presented in this reading, spreadsheets allow pro forma statements to be forecast over a much longer horizon.<\/p>\r\n<blockquote>\r\n<h2>Question<\/h2>\r\n<p>Which of the following is <em>least likely<\/em> an advantage of using spreadsheet modeling?<\/p>\r\n<ol style=\"list-style-type: upper-alpha;\">\r\n\t<li>Building complicated models.<\/li>\r\n\t<li>Forecasting any dividend growth pattern.<\/li>\r\n\t<li>Valuing a stock with a stylized pattern of dividend growth.<\/li>\r\n<\/ol>\r\n<h4>Solution<\/h4>\r\n<p><strong>The correct answer is C.\u00a0<\/strong><\/p>\r\n<p>Valuing a stock with a stylized pattern of dividend growth does not require spreadsheet modeling. Instead, dividend discount models are more appropriately used to value this type of stock.<strong>\u00a0<\/strong><\/p>\r\n<p><strong>A is incorrect. <\/strong>Spreadsheet modeling is practical when one is required to build complicated models.<strong>\u00a0<\/strong><\/p>\r\n<p><strong>B is incorrect. <\/strong>By using spreadsheet modeling, different growth patterns can be used for each period.<\/p>\r\n<\/blockquote>\r\n<p>Reading 23: Discounted Dividend Valuation<\/p>\r\n<p><em>LOS 23 (m) Explain the use of spreadsheet modeling to forecast dividends and to value common shares.<\/em><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Dividend discount models assume a stylized pattern of dividend growth. However, the dividend growth may follow a variety of patterns. Therefore, spreadsheet modeling is used to forecast any dividend pattern. In addition, spreadsheets allow analysts to build complicated models, perform&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[102,401],"tags":[216,402,440,455],"class_list":["post-18074","post","type-post","status-publish","format-standard","hentry","category-cfa-level-2","category-equity-valuation","tag-cfa-level-2","tag-equity-valuation","tag-reading-27-discounted-dividend-valuation","tag-spreadsheet-general-modeling","blog-post","no-post-thumbnail","animate"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Spreadsheet (General) Modeling - CFA, FRM, and Actuarial Exams Study Notes<\/title>\n<meta name=\"description\" content=\"Understand how spreadsheet tools enhance financial analysis and equity valuation strategies for effective decision-making.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Spreadsheet (General) Modeling - CFA, FRM, and Actuarial Exams Study Notes\" \/>\n<meta property=\"og:description\" content=\"Understand how spreadsheet tools enhance financial analysis and equity valuation strategies for effective decision-making.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/\" \/>\n<meta property=\"og:site_name\" content=\"CFA, FRM, and Actuarial Exams Study Notes\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-20T06:37:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-05T06:01:39+00:00\" \/>\n<meta name=\"author\" content=\"Irene R\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Irene R\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/\"},\"author\":{\"name\":\"Irene R\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5\"},\"headline\":\"Spreadsheet (General) Modeling\",\"datePublished\":\"2021-07-20T06:37:31+00:00\",\"dateModified\":\"2024-04-05T06:01:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/\"},\"wordCount\":193,\"keywords\":[\"CFA-level-2\",\"Equity Valuation\",\"Reading 27: Discounted Dividend Valuation\",\"Spreadsheet (General) Modeling\"],\"articleSection\":[\"CFA Level II Study Notes\",\"Equity Valuation\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/\",\"url\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/\",\"name\":\"Spreadsheet (General) Modeling - CFA, FRM, and Actuarial Exams Study Notes\",\"isPartOf\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/#website\"},\"datePublished\":\"2021-07-20T06:37:31+00:00\",\"dateModified\":\"2024-04-05T06:01:39+00:00\",\"author\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5\"},\"description\":\"Understand how spreadsheet tools enhance financial analysis and equity valuation strategies for effective decision-making.\",\"breadcrumb\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/analystprep.com\/study-notes\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Spreadsheet (General) Modeling\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/#website\",\"url\":\"https:\/\/analystprep.com\/study-notes\/\",\"name\":\"CFA, FRM, and Actuarial Exams Study Notes\",\"description\":\"Question Bank and Study Notes for the CFA, FRM, and Actuarial exams\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/analystprep.com\/study-notes\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5\",\"name\":\"Irene R\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/33caf1e1bcb63ee970b36351f165c7bc714b19614993ab9c2c8bf36273b7df48?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/33caf1e1bcb63ee970b36351f165c7bc714b19614993ab9c2c8bf36273b7df48?s=96&d=mm&r=g\",\"caption\":\"Irene R\"},\"url\":\"https:\/\/analystprep.com\/study-notes\/author\/irene\/\"}]}<\/script>\n<meta property=\"og:video\" content=\"https:\/\/www.youtube.com\/embed\/fiJA5WhgigU\" \/>\n<meta property=\"og:video:type\" content=\"text\/html\" \/>\n<meta property=\"og:video:duration\" content=\"4156\" \/>\n<meta property=\"og:video:width\" content=\"480\" \/>\n<meta property=\"og:video:height\" content=\"270\" \/>\n<meta property=\"ya:ovs:adult\" content=\"false\" \/>\n<meta property=\"ya:ovs:upload_date\" content=\"2021-07-20T06:37:31+00:00\" \/>\n<meta property=\"ya:ovs:allow_embed\" content=\"true\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Spreadsheet (General) Modeling - CFA, FRM, and Actuarial Exams Study Notes","description":"Understand how spreadsheet tools enhance financial analysis and equity valuation strategies for effective decision-making.","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:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/","og_locale":"en_US","og_type":"article","og_title":"Spreadsheet (General) Modeling - CFA, FRM, and Actuarial Exams Study Notes","og_description":"Understand how spreadsheet tools enhance financial analysis and equity valuation strategies for effective decision-making.","og_url":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/","og_site_name":"CFA, FRM, and Actuarial Exams Study Notes","article_published_time":"2021-07-20T06:37:31+00:00","article_modified_time":"2024-04-05T06:01:39+00:00","author":"Irene R","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Irene R","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/#article","isPartOf":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/"},"author":{"name":"Irene R","@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5"},"headline":"Spreadsheet (General) Modeling","datePublished":"2021-07-20T06:37:31+00:00","dateModified":"2024-04-05T06:01:39+00:00","mainEntityOfPage":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/"},"wordCount":193,"keywords":["CFA-level-2","Equity Valuation","Reading 27: Discounted Dividend Valuation","Spreadsheet (General) Modeling"],"articleSection":["CFA Level II Study Notes","Equity Valuation"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/","url":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/","name":"Spreadsheet (General) Modeling - CFA, FRM, and Actuarial Exams Study Notes","isPartOf":{"@id":"https:\/\/analystprep.com\/study-notes\/#website"},"datePublished":"2021-07-20T06:37:31+00:00","dateModified":"2024-04-05T06:01:39+00:00","author":{"@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5"},"description":"Understand how spreadsheet tools enhance financial analysis and equity valuation strategies for effective decision-making.","breadcrumb":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/analystprep.com\/study-notes\/"},{"@type":"ListItem","position":2,"name":"Spreadsheet (General) Modeling"}]},{"@type":"WebSite","@id":"https:\/\/analystprep.com\/study-notes\/#website","url":"https:\/\/analystprep.com\/study-notes\/","name":"CFA, FRM, and Actuarial Exams Study Notes","description":"Question Bank and Study Notes for the CFA, FRM, and Actuarial exams","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/analystprep.com\/study-notes\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5","name":"Irene R","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/33caf1e1bcb63ee970b36351f165c7bc714b19614993ab9c2c8bf36273b7df48?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/33caf1e1bcb63ee970b36351f165c7bc714b19614993ab9c2c8bf36273b7df48?s=96&d=mm&r=g","caption":"Irene R"},"url":"https:\/\/analystprep.com\/study-notes\/author\/irene\/"}]},"og_video":"https:\/\/www.youtube.com\/embed\/fiJA5WhgigU","og_video_type":"text\/html","og_video_duration":"4156","og_video_width":"480","og_video_height":"270","ya_ovs_adult":"false","ya_ovs_upload_date":"2021-07-20T06:37:31+00:00","ya_ovs_allow_embed":"true"},"_links":{"self":[{"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/18074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/comments?post=18074"}],"version-history":[{"count":9,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/18074\/revisions"}],"predecessor-version":[{"id":30077,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/18074\/revisions\/30077"}],"wp:attachment":[{"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/media?parent=18074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/categories?post=18074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/tags?post=18074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}