{"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":"2026-06-16T16:47:42","modified_gmt":"2026-06-16T16:47:42","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><script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"QAPage\",\r\n  \"mainEntity\": {\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Spreadsheet Modeling Advantages\",\r\n    \"text\": \"Which of the following is least likely an advantage of using spreadsheet modeling?\\n\\nA. Building complicated models.\\nB. Forecasting any dividend growth pattern.\\nC. Valuing a stock with a stylized pattern of dividend growth.\",\r\n    \"answerCount\": 3,\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"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.\",\r\n      \"upvoteCount\": 0,\r\n      \"commentCount\": 0\r\n    },\r\n    \"suggestedAnswer\": [\r\n      {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"Building complicated models is practical and a key advantage of spreadsheet modeling.\",\r\n        \"upvoteCount\": 0,\r\n        \"commentCount\": 0\r\n      },\r\n      {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"Forecasting any dividend growth pattern is possible by using different growth assumptions in each period within spreadsheet models.\",\r\n        \"upvoteCount\": 0,\r\n        \"commentCount\": 0\r\n      }\r\n    ]\r\n  }\r\n}\r\n<\/script><\/p>\r\n<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\r\n<div style=\"text-align: center; margin: 30px 0;\"><a style=\"display: inline-flex; align-items: center; justify-content: center; padding: 12px 26px; border-radius: 9999px; background: #1e5bd8; color: #ffffff; font-weight: bold; text-decoration: none;\" href=\"https:\/\/analystprep.com\/free-trial\/\" target=\"_blank\" rel=\"noopener noreferrer\"> Start Free Trial \u2192 <\/a> <p style=\"margin-top: 12px; font-size: 16px; line-height: 1.5;\">Access CFA Level 2 study notes, practice questions, mock exams, and video lessons to strengthen your spreadsheet modeling skills and boost your exam readiness.<\/p>\r\n <\/div>\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 v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Spreadsheet Modeling for Finance | CFA Level 2<\/title>\n<meta name=\"description\" content=\"Learn spreadsheet modeling techniques for financial analysis, equity valuation, and decision-making with practical examples and applications.\" \/>\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 Modeling for Finance | CFA Level 2\" \/>\n<meta property=\"og:description\" content=\"Learn spreadsheet modeling techniques for financial analysis, equity valuation, and decision-making with practical examples and applications.\" \/>\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=\"2026-06-16T16:47:42+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\":\"2026-06-16T16:47:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/analystprep.com\\\/study-notes\\\/cfa-level-2\\\/spreadsheet-general-modeling\\\/\"},\"wordCount\":219,\"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 Modeling for Finance | CFA Level 2\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/analystprep.com\\\/study-notes\\\/#website\"},\"datePublished\":\"2021-07-20T06:37:31+00:00\",\"dateModified\":\"2026-06-16T16:47:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/analystprep.com\\\/study-notes\\\/#\\\/schema\\\/person\\\/7002f30d8f174958802c1c30b167eaf5\"},\"description\":\"Learn spreadsheet modeling techniques for financial analysis, equity valuation, and decision-making with practical examples and applications.\",\"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:\\\/\\\/secure.gravatar.com\\\/avatar\\\/33caf1e1bcb63ee970b36351f165c7bc714b19614993ab9c2c8bf36273b7df48?s=96&d=mm&r=g\",\"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 Modeling for Finance | CFA Level 2","description":"Learn spreadsheet modeling techniques for financial analysis, equity valuation, and decision-making with practical examples and applications.","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 Modeling for Finance | CFA Level 2","og_description":"Learn spreadsheet modeling techniques for financial analysis, equity valuation, and decision-making with practical examples and applications.","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":"2026-06-16T16:47:42+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":"2026-06-16T16:47:42+00:00","mainEntityOfPage":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/spreadsheet-general-modeling\/"},"wordCount":219,"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 Modeling for Finance | CFA Level 2","isPartOf":{"@id":"https:\/\/analystprep.com\/study-notes\/#website"},"datePublished":"2021-07-20T06:37:31+00:00","dateModified":"2026-06-16T16:47:42+00:00","author":{"@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5"},"description":"Learn spreadsheet modeling techniques for financial analysis, equity valuation, and decision-making with practical examples and applications.","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:\/\/secure.gravatar.com\/avatar\/33caf1e1bcb63ee970b36351f165c7bc714b19614993ab9c2c8bf36273b7df48?s=96&d=mm&r=g","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":11,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/18074\/revisions"}],"predecessor-version":[{"id":44110,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/18074\/revisions\/44110"}],"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}]}}