{"id":17248,"date":"2023-01-07T05:27:40","date_gmt":"2023-01-07T05:27:40","guid":{"rendered":"https:\/\/analystprep.com\/study-notes\/?p=17248"},"modified":"2024-04-04T11:02:08","modified_gmt":"2024-04-04T11:02:08","slug":"balance-sheet-modeling","status":"publish","type":"post","link":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/","title":{"rendered":"Balance Sheet Modeling"},"content":{"rendered":"<iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/M-Yp1rD9Kf0\" width=\"611\" height=\"343\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\r\n\r\n\r\n<p>Some balance sheet items, such as retained earnings, flow directly from the income statement. Others, such as accounts receivable, inventory, and accounts payable, are closely linked to income statement projections.<\/p>\r\n<p>Working capital accounts are forecasted using efficiency ratios. For example, <em><strong>accounts receivable<\/strong><\/em> are forecast by estimating the number of days of sales outstanding and combining this assumption with a sales projection. <strong><em>Days sales outstanding<\/em><\/strong> are the average number of days a company takes to collect revenue from its customers. For example, if credit sales are $25 million and it usually takes a company 50 days to collect this amount from their customers, accounts receivable would be estimated to be $2.05 million ($15 million \u00d7 50\/365). An analyst can forecast inventory by calculating an <em><strong>inventory turnover ratio<\/strong><\/em> and combining that with the cost of goods sold projection. The inventory turnover ratio measures how much inventory a company keeps on hand. Analysts can look at historical efficiency ratios and recent project performance or a historical average to persist in the future.<\/p>\r\n<p>Projections for long-term assets such as property, plant, and equipment (PP&amp;E) are less directly linked to the income statement. <em><strong>Net PP&amp;E changes<\/strong> result from capital expenditures and depreciation, which are essential components of the cash flow statement. <em><strong>Depreciation forecasts<\/strong><\/em> are based on historical depreciation and disclosures about depreciation schedules. In contrast, <em><strong>capital expenditure<\/strong><\/em>\u00a0forecasts depend on analysts\u2019 judgment and future need for new PP&amp;E. An organization\u2019s capital expenditures are divided into <strong><em>maintenance capital expenditures<\/em><\/strong>, expenditures needed to sustain the current business, and <em><strong>growth capital expenditures<\/strong><\/em>, expenditures required to expand the business. Maintenance expenditures should be higher than depreciation because of inflation.<\/em><\/p>\r\n<p>A company\u2019s future debt and equity levels can be forecast using leverage ratios such as debt-to-capital, debt-to-equity, and debt-to-EBITDA. Analysts should consider historical practices, management\u2019s strategy, and capital requirements when projecting the future capital structure.<\/p>\r\n<p>After projecting the balance sheets and income statements, the future cash flow statement can be projected. The analyst will make assumptions about how a company will use its future cash flows, share repurchases, dividends, additional capital expenditures, and acquisitions.<\/p>\r\n<blockquote>\r\n<h2>Question<\/h2>\r\n<p>Which of the following is <em>least likely<\/em> a ratio used to forecast working capital accounts such as accounts receivables and inventory?<\/p>\r\n<ol style=\"list-style-type: upper-alpha;\">\r\n\t<li>Days sales outstanding.<\/li>\r\n\t<li>Inventory turnover ratio.<\/li>\r\n\t<li>Sensitivity analysis.<\/li>\r\n<\/ol>\r\n<h4>Solution<\/h4>\r\n<p>The correct answer is<strong> C<\/strong>.<\/p>\r\n<p>Sensitivity analysis is a tool that involves changing only one assumption at a time to determine its effect on the estimate of the intrinsic value.<\/p>\r\n<p><strong>A is incorrect<\/strong>.\u00a0Days sales outstanding is an efficiency ratio used to measure the average number of days a firm takes to collect revenue from its customers. It is used to forecast accounts receivable.<\/p>\r\n<p><strong>B is incorrect<\/strong>. The inventory turnover ratio is an efficiency ratio used to forecast inventory. It measures how much inventory a company keeps on hand.<\/p>\r\n<\/blockquote>\r\n<p>Reading 17: Financial Statement Modeling<\/p>\r\n<p><em>LOS 17 (f) Describe approaches to balance sheet modeling.<\/em><\/p>\r\n","protected":false},"excerpt":{"rendered":"Some balance sheet items, such as retained earnings, flow directly from the income statement. Others, such as accounts receivable, inventory, and accounts payable, are closely linked to income statement projections. Working capital accounts are forecasted using efficiency ratios. For example,...","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":[432,216,402,429],"class_list":["post-17248","post","type-post","status-publish","format-standard","hentry","category-cfa-level-2","category-financial-reporting-and-analysis-fra","tag-balance-sheet-modeling","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>Balance Sheet Modeling - CFA, FRM, and Actuarial Exams Study Notes<\/title>\n<meta name=\"description\" content=\"Discover how to forecast working capital accounts like accounts receivable and inventory in financial analysis using efficiency ratios.\" \/>\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\/balance-sheet-modeling\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Balance Sheet Modeling - CFA, FRM, and Actuarial Exams Study Notes\" \/>\n<meta property=\"og:description\" content=\"Discover how to forecast working capital accounts like accounts receivable and inventory in financial analysis using efficiency ratios.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/\" \/>\n<meta property=\"og:site_name\" content=\"CFA, FRM, and Actuarial Exams Study Notes\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-07T05:27:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-04T11:02:08+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\/balance-sheet-modeling\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/\"},\"author\":{\"name\":\"Irene R\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5\"},\"headline\":\"Balance Sheet Modeling\",\"datePublished\":\"2023-01-07T05:27:40+00:00\",\"dateModified\":\"2024-04-04T11:02:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/\"},\"wordCount\":482,\"keywords\":[\"Balance Sheet Modeling\",\"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\/balance-sheet-modeling\/\",\"url\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/\",\"name\":\"Balance Sheet Modeling - CFA, FRM, and Actuarial Exams Study Notes\",\"isPartOf\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/#website\"},\"datePublished\":\"2023-01-07T05:27:40+00:00\",\"dateModified\":\"2024-04-04T11:02:08+00:00\",\"author\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5\"},\"description\":\"Discover how to forecast working capital accounts like accounts receivable and inventory in financial analysis using efficiency ratios.\",\"breadcrumb\":{\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/analystprep.com\/study-notes\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Balance Sheet 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\/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-07T05:27:40+00:00\" \/>\n<meta property=\"ya:ovs:allow_embed\" content=\"true\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Balance Sheet Modeling - CFA, FRM, and Actuarial Exams Study Notes","description":"Discover how to forecast working capital accounts like accounts receivable and inventory in financial analysis using efficiency ratios.","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\/balance-sheet-modeling\/","og_locale":"en_US","og_type":"article","og_title":"Balance Sheet Modeling - CFA, FRM, and Actuarial Exams Study Notes","og_description":"Discover how to forecast working capital accounts like accounts receivable and inventory in financial analysis using efficiency ratios.","og_url":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/","og_site_name":"CFA, FRM, and Actuarial Exams Study Notes","article_published_time":"2023-01-07T05:27:40+00:00","article_modified_time":"2024-04-04T11:02:08+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\/balance-sheet-modeling\/#article","isPartOf":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/"},"author":{"name":"Irene R","@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5"},"headline":"Balance Sheet Modeling","datePublished":"2023-01-07T05:27:40+00:00","dateModified":"2024-04-04T11:02:08+00:00","mainEntityOfPage":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/"},"wordCount":482,"keywords":["Balance Sheet Modeling","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\/balance-sheet-modeling\/","url":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/","name":"Balance Sheet Modeling - CFA, FRM, and Actuarial Exams Study Notes","isPartOf":{"@id":"https:\/\/analystprep.com\/study-notes\/#website"},"datePublished":"2023-01-07T05:27:40+00:00","dateModified":"2024-04-04T11:02:08+00:00","author":{"@id":"https:\/\/analystprep.com\/study-notes\/#\/schema\/person\/7002f30d8f174958802c1c30b167eaf5"},"description":"Discover how to forecast working capital accounts like accounts receivable and inventory in financial analysis using efficiency ratios.","breadcrumb":{"@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/analystprep.com\/study-notes\/cfa-level-2\/financial-reporting-and-analysis-fra\/balance-sheet-modeling\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/analystprep.com\/study-notes\/"},{"@type":"ListItem","position":2,"name":"Balance Sheet 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\/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-07T05:27:40+00:00","ya_ovs_allow_embed":"true"},"_links":{"self":[{"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/17248","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=17248"}],"version-history":[{"count":14,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/17248\/revisions"}],"predecessor-version":[{"id":37580,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/posts\/17248\/revisions\/37580"}],"wp:attachment":[{"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/media?parent=17248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/categories?post=17248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/analystprep.com\/study-notes\/wp-json\/wp\/v2\/tags?post=17248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}