{"id":17297,"date":"2023-01-07T11:14:52","date_gmt":"2023-01-07T11:14:52","guid":{"rendered":"https:\/\/analystprep.com\/study-notes\/?p=17297"},"modified":"2025-12-30T13:13:44","modified_gmt":"2025-12-30T13:13:44","slug":"building-a-model","status":"publish","type":"post","link":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/","title":{"rendered":"Building a Model to Value a Firm"},"content":{"rendered":"<iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/M-Yp1rD9Kf0\" width=\"611\" height=\"343\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\r\n<p>&nbsp;<\/p>\r\n<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\": \"Which of the following costs would least likely fall under selling, general, and administrative expenses?\",\r\n    \"text\": \"Which of the following costs would least likely fall under selling, general, and administrative expenses?\\n\\nA. Fixed costs.\\nB. Variable costs.\\nC. Cost of goods sold.\",\r\n    \"answerCount\": 1,\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Cost of goods sold.\\n\\nCost of goods sold (COGS) refers to the direct costs associated with manufacturing or purchasing the goods a company sells and is typically estimated as a percentage of sales. These costs are reported separately from selling, general, and administrative (SG&A) expenses.\\n\\nFixed and variable costs can be components of SG&A expenses. Fixed costs generally remain constant regardless of revenue, while variable costs tend to change with the level of business activity.\",\r\n      \"dateCreated\": \"2025-12-23\"\r\n    }\r\n  }\r\n}\r\n<\/script>\r\n\r\n\r\n\r\n<p>The following are the steps to developing a sales-based pro forma company model:<\/p>\r\n<h2>Overview<\/h2>\r\n<ol type=\"1\">\r\n\t<li>\r\n<p><strong>Industry Overview<\/strong><\/p>\r\n<p>This involves performing an industry analysis of a company\u2019s segments. Conduct Porter\u2019s five forces analysis of the industry to determine the threat of new substitutes, suppliers&#8217; bargaining power, rivalry, new entrants&#8217; threat, and buyers&#8217; bargaining power.<\/p>\r\n<\/li>\r\n\t<li>\r\n<p><strong>Company Overview<\/strong><\/p>\r\n<p>Collect financial information on a company. This includes all the company\u2019s segments.<\/p>\r\n<p><strong>Constructing a Pro Forma Income Statement<\/strong><\/p>\r\n<ol type=\"1\">\r\n\t<li>\r\n<p><strong>Forecast Revenue<\/strong><\/p>\r\n<p>Revenue forecasts use a hybrid approach because trends in individual segments (bottom-up) are combined with economic developments (top-down). Volume, price, and foreign currency estimates drive the change in revenue. Note that change in revenue depends on historical trends as adjusted for expected changes from the trend.<\/p>\r\n<p>Once revenue has been projected for the individual segments, the amounts are aggregated to derive projected revenue for the company.<\/p>\r\n<\/li>\r\n\t<li>\r\n<p><strong>Forecast Cost of Goods Sold (COGS)<\/strong><\/p>\r\n<p>COGS are estimated as a percentage of sales. Adjustments are then made in case projections are not expected to persist in the future.<\/p>\r\n<\/li>\r\n\t<li>\r\n<p><strong>Forecast Selling<\/strong>,<strong> General<\/strong>,<strong> and Administrative Expenses (SG&amp;A)<\/strong><\/p>\r\n<p>SG&amp;A expenses are less directly related to revenue and are made up of fixed and variable expenses. Fixed expenses are expected to persist in the future, and in case of any anticipated changes, they can be included in the projections. Variable costs are more linked to revenue growth.<\/p>\r\n<\/li>\r\n\t<li>\r\n<p><strong>Forecast Operating Profit by Division<\/strong><\/p>\r\n<p>When analysts deduct the cost of goods, selling, general, and administrative costs (and other expenses are subtracted from revenue), the result is Earnings Before Interest Taxes (EBIT), a proxy of operating profit.<\/p>\r\n<\/li>\r\n\t<li>\r\n<p><strong>Non-operating Expenses<\/strong><\/p>\r\n<p>There are two types of non-operating expenses: finance expenses and income taxes. Finance expenses require estimation of debt and interest rates in debt. The interest rate may be fixed or variable.<\/p>\r\n<\/li>\r\n\t<li>\r\n<p><strong>Corporate Income Tax Forecast<\/strong><\/p>\r\n<p>This is based on the average historical effective tax rate with necessary adjustments.<\/p>\r\n<p>Once these 5 steps have been performed, the analyst can construct the pro forma income statement. The next step is to construct the cash flow statement and balance sheet since many balance sheet accounts, like retained earnings, accounts receivable, accounts payable, and inventory, are related to the income statement.<\/p>\r\n<\/li>\r\n<\/ol>\r\n<p><strong>Constructing a Pro Forma Cash Flow Statement and Balance Sheet<\/strong><\/p>\r\n<ol type=\"1\">\r\n\t<li>\r\n<p><strong>Capital Investment and Depreciation Forecasts<\/strong><\/p>\r\n<p>Estimates of depreciation and capital expenditures for maintenance and growth, which are estimated based on sales, are used to calculate net PP&amp;E.<\/p>\r\n<\/li>\r\n\t<li>\r\n<p><strong>Forecast Working Capital Accounts<\/strong><\/p>\r\n<p>Simply put, current assets minus current liabilities are required to keep a company operating and growing.<\/p>\r\n<p>Many of the pro forma cash flow statement inputs, such as operating profit, working capital estimates, capital expenditures, and capital structure changes, may have been estimated while constructing the pro forma income statement. The final step is to create a pro forma balance sheet. Information on the pro forma income statement, cash flow statement, and balance sheet can then be used in valuation metrics, e.g., EBITDA, EBIT, and EPS.<\/p>\r\n<\/li>\r\n<\/ol>\r\n<\/li>\r\n<\/ol>\r\n<blockquote>\r\n<h2>Question<\/h2>\r\n<p>Which of the following costs would <em>least likely<\/em> fall under selling, general, and administrative expenses?<\/p>\r\n<ol style=\"list-style-type: upper-alpha;\">\r\n\t<li>Fixed costs.<\/li>\r\n\t<li>Variable costs.<\/li>\r\n\t<li>Cost of goods sold.<\/li>\r\n<\/ol>\r\n<h4>Solution<\/h4>\r\n<p>The correct answer is <strong>C<\/strong>.<\/p>\r\n<p>The costs of goods sold refer to the costs of manufacturing the goods a company sells and are estimated as a percentage of sales.<\/p>\r\n<p><strong>A is incorrect<\/strong>. Fixed costs are considered part of selling, general, and administrative expenses. They are expected to remain constant in the future regardless of the revenue.<\/p>\r\n<p><strong>B is incorrect<\/strong>. Variable costs are considered part of selling, general, and administrative expenses. These costs are more linked to revenue growth.<\/p>\r\n<\/blockquote>\r\n<p>Reading 17: Financial Statement Modeling<\/p>\r\n<p><em>LOS 17 (g) Demonstrate the development of a sales-based pro forma company model.<\/em><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;<\/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,312],"tags":[439,216,402,429],"class_list":["post-17297","post","type-post","status-publish","format-standard","hentry","category-cfa-level-2","category-financial-reporting-and-analysis-fra","tag-building-a-model","tag-cfa-level-2","tag-equity-valuation","tag-reading-26-industry-and-company-analysis","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>Building a Model to Value a Firm - CFA, FRM, and Actuarial Exams Study Notes<\/title>\n<meta name=\"description\" content=\"COGS are estimated as a percentage of sales. Adjustments are then made in case projections are not expected to persist in the future.\" \/>\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\/financial-reporting-and-analysis-fra\/building-a-model\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Building a Model to Value a Firm - CFA, FRM, and Actuarial Exams Study Notes\" \/>\n<meta property=\"og:description\" content=\"COGS are estimated as a percentage of sales. Adjustments are then made in case projections are not expected to persist in the future.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/\" \/>\n<meta property=\"og:site_name\" content=\"CFA, FRM, and Actuarial Exams Study Notes\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-07T11:14:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-30T13:13:44+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=\"3 minutes\" \/>\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\/financial-reporting-and-analysis-fra\/building-a-model\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/\"},\"author\":{\"name\":\"Irene R\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5\"},\"headline\":\"Building a Model to Value a Firm\",\"datePublished\":\"2023-01-07T11:14:52+00:00\",\"dateModified\":\"2025-12-30T13:13:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/\"},\"wordCount\":622,\"keywords\":[\"Building a Model\",\"CFA-level-2\",\"Equity Valuation\",\"Reading 26: Industry and Company Analysis\"],\"articleSection\":[\"CFA Level II Study Notes\",\"Financial Reporting and Analysis (FRA)\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/\",\"url\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/\",\"name\":\"Building a Model to Value a Firm - CFA, FRM, and Actuarial Exams Study Notes\",\"isPartOf\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/#website\"},\"datePublished\":\"2023-01-07T11:14:52+00:00\",\"dateModified\":\"2025-12-30T13:13:44+00:00\",\"author\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5\"},\"description\":\"COGS are estimated as a percentage of sales. Adjustments are then made in case projections are not expected to persist in the future.\",\"breadcrumb\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/analystprep.com\/study-notes\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Building a Model to Value a Firm\"}]},{\"@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\/M-Yp1rD9Kf0\" \/>\n<meta property=\"og:video:type\" content=\"text\/html\" \/>\n<meta property=\"og:video:duration\" content=\"3444\" \/>\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=\"2023-01-07T11:14:52+00:00\" \/>\n<meta property=\"ya:ovs:allow_embed\" content=\"true\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Building a Model to Value a Firm - CFA, FRM, and Actuarial Exams Study Notes","description":"COGS are estimated as a percentage of sales. Adjustments are then made in case projections are not expected to persist in the future.","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\/financial-reporting-and-analysis-fra\/building-a-model\/","og_locale":"en_US","og_type":"article","og_title":"Building a Model to Value a Firm - CFA, FRM, and Actuarial Exams Study Notes","og_description":"COGS are estimated as a percentage of sales. Adjustments are then made in case projections are not expected to persist in the future.","og_url":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/","og_site_name":"CFA, FRM, and Actuarial Exams Study Notes","article_published_time":"2023-01-07T11:14:52+00:00","article_modified_time":"2025-12-30T13:13:44+00:00","author":"Irene R","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Irene R","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/#article","isPartOf":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/"},"author":{"name":"Irene R","@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5"},"headline":"Building a Model to Value a Firm","datePublished":"2023-01-07T11:14:52+00:00","dateModified":"2025-12-30T13:13:44+00:00","mainEntityOfPage":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/"},"wordCount":622,"keywords":["Building a Model","CFA-level-2","Equity Valuation","Reading 26: Industry and Company Analysis"],"articleSection":["CFA Level II Study Notes","Financial Reporting and Analysis (FRA)"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/","url":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/","name":"Building a Model to Value a Firm - CFA, FRM, and Actuarial Exams Study Notes","isPartOf":{"@id":"https:\/\/analystprep.com\/study-notes\/#website"},"datePublished":"2023-01-07T11:14:52+00:00","dateModified":"2025-12-30T13:13:44+00:00","author":{"@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5"},"description":"COGS are estimated as a percentage of sales. Adjustments are then made in case projections are not expected to persist in the future.","breadcrumb":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/building-a-model\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/analystprep.com\/study-notes\/"},{"@type":"ListItem","position":2,"name":"Building a Model to Value a Firm"}]},{"@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\/M-Yp1rD9Kf0","og_video_type":"text\/html","og_video_duration":"3444","og_video_width":"480","og_video_height":"270","ya_ovs_adult":"false","ya_ovs_upload_date":"2023-01-07T11:14:52+00:00","ya_ovs_allow_embed":"true"},"_links":{"self":[{"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/17297","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=17297"}],"version-history":[{"count":18,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/17297\/revisions"}],"predecessor-version":[{"id":41639,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/17297\/revisions\/41639"}],"wp:attachment":[{"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/media?parent=17297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/categories?post=17297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/tags?post=17297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}