{"id":2021,"date":"2023-08-19T01:41:14","date_gmt":"2023-08-19T01:41:14","guid":{"rendered":"https:\/\/pressbooks.ccconline.org\/accfinance\/chapter\/why-it-matters-14\/"},"modified":"2023-08-19T01:59:27","modified_gmt":"2023-08-19T01:59:27","slug":"why-it-matters-14","status":"publish","type":"chapter","link":"https:\/\/pressbooks.ccconline.org\/accfinance\/chapter\/why-it-matters-14\/","title":{"raw":"Lesson 2 a Financial Forecasting Cash Budgets","rendered":"Lesson 2 a Financial Forecasting Cash Budgets"},"content":{"raw":"<div class=\"why-it-matters\">\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Though no one in business has a crystal ball, managers must often do all they can to predict the future as accurately as possible. This is called <em>forecasting<\/em>. Accounting and finance professionals use past performance along with what they know about the business, its competitors, the economy, and the company\u2019s plans for the future to assemble detailed financial forecasts. Forecasts are useful to many individuals for different reasons. <a id=\"_bookmark1321\"><\/a>A budget, a type of static <strong>forecast<\/strong>, helps accountants and managers see how their plans for the coming year can be achieved. It outlines sales targets and how much can be spent on cost of goods sold and expenses to achieve the company\u2019s bottom-line (net income) targets. Investors use financial forecasts to help guide their decisions to buy, sell or hold stocks or to estimate future potential income through dividends. Perhaps most importantly, for our purposes in finance, forecasts are used to help predict and manage cash flows.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.65pt\">A business can have all the profit in the world at the end of the year, but if it doesn\u2019t raise enough cash (liquidity) to pay the bills and pay its employees halfway through the year, it could still go bankrupt despite being profitable. Forecasting sales and expenses helps assemble a cash forecast\u2014when sales will be collected and when expenses will be paid\u2014so that financial managers can look forward far enough to have enough time to react accordingly and secure short- or long-term financing to meet gaps in cash flow.<\/p>\r\n\r\n<h3><img src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.1\r\n<a id=\"_bookmark1322\"><\/a>The Importance of Forecasting<\/h3>\r\n<h4>Learning Outcomes<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\r\n\r\n<ul>\r\n \t<li>Discuss how to use financial statements in forecasting firm financials.<\/li>\r\n \t<li>Explain why balance sheet items are important in forecasting a firm\u2019s financial result.<\/li>\r\n \t<li>Explain why income statement items are important in forecasting a firm\u2019s financial result.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">In this section, we will briefly review some of the basic elements of financial statements and how we can analyze historical statements to help assemble financial forecasts. Financial forecasting is important to short- and long-term firm success. It helps a firm plan for the resources it will need, ensuring it will have enough cash on hand at the right time to cover daily operations and capital expenditures. It helps the firm communicate its future potential and manage its shareholders\u2019 expectations. It also helps management assess future risk and set plans in place to mitigate that risk.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Financial forecasting involves using historical data, analysis tools, and other information we can gather to make an educated guess about the future financial performance of the firm. Historical figures provide a reasonable starting point. We use tools such as ratios, common size, and trend analysis to fine-tune our forecast. And finally, we assess what we know about the firm, its competitors, the economy, and anything else that might impact performance and further fine-tune our forecast from there.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">It\u2019s important to take a moment to consider the role of ethics in forecasting. Ethics is a huge issue in the world of accounting and finance in general, and forecasting is no different. There can be tremendous pressure on management to perform, to deliver certain levels of profit, and to meet shareholder expectations.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Forecasting, as you will learn throughout this chapter, is not an exact science. There is a great deal of subjectivity that can come into play when forecasting sales and expenses. Ethical behavior is crucial in this area. Those who create forecasts must have a firm understanding of where their data comes from, how reliable it is, and whether or not their assumptions and projections are reasonably justified.<\/p>\r\n\r\n<h4>Financial Statement Foundations<\/h4>\r\n<p class=\"import-Normal\" style=\"margin-left: 17pt;margin-right: 52pt\">In <a href=\"#_bookmark361\">Financial Statements<\/a>, you were introduced to a firm called Clear Lake Sporting Goods. You learned about <a id=\"_bookmark1323\"><\/a>the four key financial statements: the <strong>income statement<\/strong>, <strong>balance sheet<\/strong>, <strong>statement of stockholders\u2019 <\/strong><a id=\"_bookmark1324\"><\/a><strong>equity<\/strong>, and <strong>statement of cash flows<\/strong>. Each one provides a different view of the firm\u2019s financial health and performance.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\"><a id=\"_bookmark1325\"><\/a>Clear Lake Sporting Goods is a small merchandising company (a company that buys finished goods and sells them to consumers) that sells hunting and fishing gear. It uses financial statements to understand its profitability and current financial position, to manage cash flow, and to communicate its finances to outside parties such as investors, governing bodies, and lenders. We will use Clear Lake\u2019s company information and historical financial statements in this chapter as we explore its forecasting process. It\u2019s important to note that in this chapter, we are focusing on just one firm and the one method its managers have chosen to forecast financial performance. There are a variety of types of firms in actual application, and they may choose to forecast their financial performance differently. We are demonstrating just one approach here.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.7pt\">The balance sheet shows all the firm\u2019s assets, liabilities, and equity at one point in time. It also supports the accounting equation in a very clear and transparent way. We find one section of the balance sheet contains all current and noncurrent assets that must total the other section of the balance sheet: total liabilities and equity. In <a href=\"#_bookmark1326\">Figure 18.2<\/a>, we see that Clear Lake Sporting Goods has total assets of $250,000 in the current year, which balances with its total liabilities and equity of $250,000.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 106.15pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image3-12.png\" alt=\"image\" width=\"384.96px\" height=\"458.56px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1326\"><\/a><strong>Figure 18.2<\/strong> <strong>Balance <\/strong><strong>Sheet<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 50.8pt\">The income statement reflects the performance of the firm over a period of time. It includes net sales, cost of goods sold, operating expenses, and net income. In <a href=\"#_bookmark1327\">Figure 18.3<\/a>, we see that Clear Lake had $120,000 in net sales, $60,000 in cost of goods sold, and $35,000 in net income in the current year.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image4-25.png\" alt=\"image\" width=\"384.959895013123px\" height=\"282.24px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1327\"><\/a><strong>Figure<\/strong> <strong>18.3<\/strong> <strong>Full<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Finally, the statement of cash flows is used to reconcile net income to cash balances. The statement begins with net income, then reflects adjustments to balance sheet accounts and noncash expenses. The statement of<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">cash flows is broken down into three key categories: operating, investing, and financing. This allows users to clearly see what elements of the business are generating or using cash. In <a href=\"#_bookmark1330\">Figure 18.4<\/a>, we see that Clear Lake <a id=\"_bookmark1329\"><\/a>had cash flow from <strong>operating<\/strong> <strong>activities<\/strong> of $53,600, cash used for <strong>investing<\/strong> <strong>activities<\/strong> of ($18,600), and cash <a id=\"_bookmark1328\"><\/a>used for <strong>financing activities <\/strong>of ($15,000).<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image5-18.png\" alt=\"image\" width=\"576.96px\" height=\"409.279895013123px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.4pt\"><a id=\"_bookmark1330\"><\/a><strong>Figure<\/strong> <strong>18.4<\/strong> <strong>Statement<\/strong> <strong>of<\/strong> <strong>Cash<\/strong><strong> Flows<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Another key concept to remember about the financial statements is that the statement of cash flows is necessary to truly understand how the firm is using and generating cash. A common misconception is that if a firm reports net income on its income statement, then it must have plenty of cash, and if it reports a loss, it must be short on cash. Although this can be true, it\u2019s not necessarily the case. Historically speaking, we need the statement of cash flows to get the full picture of how cash was used or generated in the past. Looking to the future, we need a cash flow forecast to plan for possible gaps in cash flow and, potentially, how to make the best use of any cash surplus. Throughout this chapter, we will see how to use historical financial statements to help develop the future cash forecast.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">It\u2019s also important to remember that the four financial statements are tied together. Net income from the income statement feeds into retained earnings, which live on the balance sheet. Equity balances on the balance sheet feed information to the statement of stockholders\u2019 equity. And information from both the income statement (net income and noncash expenses) and the balance sheet (changes in working capital accounts) all feed into the statement of cash flows. These relationships will be helpful to understand when using historical statements and preparing forecasts.<\/p>\r\n\r\n<h4>Balance Sheet Analysis<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Fully understanding the items that are on the balance sheet and how they relate to one another and to other financial statements will help you create a financial forecast. In <a href=\"#_bookmark361\">Financial Statements<\/a>, you learned that on the classified balance sheet, both assets and liabilities are broken down into current and noncurrent categories. You also know that the balance sheet must live up to its name\u2014it must balance. This means that total assets (what the company owns) must equal total liabilities and equity (what the company owes).<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">You continued your financial statement development in <a href=\"#_bookmark450\">Measures of Financial Health<\/a>, where you saw how to use elements of the balance sheet to assess financial health. Ratios based on balance sheet accounts can be useful for understanding relationships between balance sheet items\u2014how they related in the past and then, in forecasting, how those relationships might change or remain the same in the future. Examples of balance sheet ratios include the current ratio, quick ratio, cash ratio, debt-to-assets ratio, and debt-to-equity ratio.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 45.95pt\"><a id=\"_bookmark1331\"><\/a>In <a href=\"#_bookmark361\">Financial Statements<\/a>, you also explored common-size analysis. To prepare a <strong>common-size<\/strong> analysis of the balance sheet, every item on the statement must be expressed as a percentage of total assets. Seeing each item as a percentage\u2014that is, seeing its relationship to total assets\u2014is also helpful for assessing historical statements and how those percentages or relationships can be used to predict future balances in the forecast. For example, in <a href=\"#_bookmark1332\">Figure 18.5<\/a>, you can see that Clear Lake\u2019s current assets represented 80% of its total assets in both the current and prior years.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image6-11.png\" alt=\"image\" width=\"576.96px\" height=\"458.56px\" \/><\/p>\r\n\r\n<h4><a id=\"_bookmark1332\"><\/a>Income Statement Analysis<\/h4>\r\n<p class=\"import-Normal\" style=\"margin-left: 9.050000000000001pt\"><br style=\"clear: both\" \/><strong>Figure<\/strong> <strong>18.5<\/strong> <strong>Common-Size<\/strong> <strong>Balance<\/strong> <strong>Sheet<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Like balance sheet analysis, income statement analysis is also quite helpful in preparing for the forecasting process. In <a href=\"#_bookmark361\">Financial Statements<\/a>, you learned that the income statement is commonly broken down into a few sections. Cost of goods sold is deducted from net sales to arrive at gross margin. Gross margin refers to the profits earned solely on the sale of the product itself, without consideration for the expenses incurred to run the business. Next, operating expenses are deducted to reflect operating income. Operating income reflects the profits of the core business function. Finally, other items, such as interest expense, tax expense, and other gains and losses, are deducted to arrive at net income, a.k.a. the <em>bottom<\/em> <em>line<\/em>. Each segment of the income statement is helpful for assessing past performance and estimating future expenses for a forecast.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">You continued your financial statement development in <a href=\"#_bookmark450\">Measures of Financial Health<\/a>, where you saw how to<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">use elements of the income statement to assess historical financial performance. Ratios based on the income statement can be useful for understanding relationships between net sales and expenses\u2014how they related in the past and then, in forecasting, how those relationships might change or remain the same. Examples of income statement ratios include gross margin, operating margin, and profit margin. Common ratios that incorporate items from both the balance sheet and the income statement include return on assets (ROA), return on equity (ROE), inventory turnover, accounts receivable turnover, and accounts payable turnover.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"158.4px\" \/>LINK TO LEARNINGPerformance TrendsReview the most recent annual report for Big 5 Sporting Goods (https:\/\/openstax.org\/r\/ annual_report_for_Big_5_Sporting-Goods). Review the company\u2019s sales and gross margins for the current and past two years. How is their performance? Are their sales trending up or down? Why might the contribution margin have increased or decreased?<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">In <a href=\"#_bookmark361\">Financial Statements<\/a>, you also explored common-size analysis. To prepare a common-size analysis of the income statement, every item on the statement must be expressed as a percentage of net assets. Seeing each item as a percentage, in terms of its relationship to total sales, is also helpful for assessing historical statements and how those percentages or relationships can be used to predict future balances in the forecast. For example, in <a href=\"#_bookmark1334\">Figure 18.6<\/a>, you can see that Clear Lake\u2019s cost of goods sold represented 50% of its net sales in both the current and prior years.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image7-23.png\" alt=\"image\" width=\"576.959895013123px\" height=\"308.16px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 167.2pt\"><a id=\"_bookmark1334\"><\/a><strong>Figure<\/strong> <strong>18.6<\/strong> <strong>Common-Size<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong><\/p>\r\n<p class=\"import-BodyText\"><\/p>\r\n<p class=\"import-BodyText\"><\/p>\r\n\r\n<h3><img src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.2\r\n<a id=\"_bookmark1335\"><\/a>Forecasting Sales<\/h3>\r\n<h4>Learning Outcomes<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\r\n\r\n<ul>\r\n \t<li>Explain how sales are the main driver for a financial forecast.<\/li>\r\n \t<li>Determine a past time period to formulate the basis for a financial forecast.<\/li>\r\n \t<li>Explain the advantages and disadvantages of using past data to forecast future financial performance.<\/li>\r\n \t<li>Calculate past sales growth averages.<\/li>\r\n \t<li>Justify adjusting relationships when forecasting future financial performance.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 55.85pt\">In this section of the chapter, you will begin to explore the first step of creating a forecast: forecasting sales. We will discuss common time frames for sales forecasts and why we use historical data in our forecasts (but only with caution), and we will work through the process of forecasting future sales. We will be using the percent-of-sales method to forecast some expenses for Clear Lake Sporting Goods, the example used throughout the chapter. This method relies on sales data, further highlighting why accuracy in forecasting sales is crucial.<\/p>\r\n\r\n<h4>Sales as the Driver<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">A significant portion of a business\u2019s costs are driven by how much it sells. Thus, the sales forecast is the necessary first step in preparing a financial forecast. Common costs driven by sales include direct product costs, direct labor costs, and other key variable costs (i.e., costs that vary proportionately to sales), such as sales commissions.<\/p>\r\n\r\n<h4>Looking to the Past<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.5pt\">Forecasting sales is not always an easy task, as no one knows the future. We can, however, use the information we do have to forecast future sales with the greatest accuracy possible. Most firms start by looking at the past. A firm may look at past sales from a variety of prior periods. It\u2019s common to look at the past 12 months to estimate the coming 12 months. Looking at 12 consecutive months helps identify seasonality of sales trends, what time of year sales tend to drop off and when they increase, possible sales spikes that might reoccur, and any other trends that tend to appear over a 12-month period. In <a href=\"#_bookmark1336\">Figure 18.7<\/a>, we see Clear Lake\u2019s sales by month for the past 12 months.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Past data is often used in conjunction with probabilities and weighted average calculations derived from probabilities. Though used in several areas of forecasting, this approach is particularly common in drafting the sales forecast. Using multiple scenarios and the probability of each scenario occurring is a common approach to estimating future sales.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image8-16.png\" alt=\"image\" width=\"576.960104986877px\" height=\"99.2px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1336\"><\/a><strong>Figure 18.7<\/strong> <strong>Historical Sales <\/strong><strong>Data<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">We can see at first glance that sales remain fairly steady from January to April. Sales then goes up significantly in April and May, seem to peak in June, taper off a bit in July, then decline steeply from August to the end of the year, with the lowest sales being in November and December. Though not exact, it\u2019s easy to quickly see that sales follow a seasonal pattern. We will focus on just one year of data here to keep things simple. However, it\u2019s important to note that when a firm has a seasonal sales pattern, it normally uses more than one year of data to detect and evaluate the pattern. It\u2019s not uncommon for firms to have a seasonal sales pattern that fluctuates based on an external factor such as weather patterns, patterns in business or demand, or other<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">factors such as holidays. Common examples might include farm-based businesses that function on a weather pattern for harvesting and selling crops or a toy company that fluctuates around gift-giving holidays.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">This knowledge is helpful when assembling a first pass at the next year\u2019s sales forecast. Using common-size and horizontal (trend) analyses on sales is also helpful, as shown in <a href=\"#_bookmark1337\">Figure 18.8<\/a>. We can see the exact percentages that sales went up or down each month:<\/p>\r\n\r\n<ul>\r\n \t<li><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image9-5.png\" alt=\"image\" width=\"158.513385826772px\" height=\"30.656062992126px\" \/>In January, the company had sales of $9,000, which wasof the total annual sales.<\/li>\r\n \t<li>In June, the company had $19,000 sales, which wasof the total annual sales and <img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image10-32.png\" alt=\"image\" width=\"130.511286089239px\" height=\"12.6559580052493px\" \/> of January sales.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image11-11.png\" alt=\"image\" width=\"576.959790026247px\" height=\"163.199895013123px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 160.75pt\"><a id=\"_bookmark1337\"><\/a><strong>Figure<\/strong> <strong>18.8<\/strong> <strong>Historical<\/strong> <strong>Sales<\/strong> <strong>Data<\/strong> <strong>as<\/strong> <strong>Percentages<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Once a baseline in the 12-month period is assessed, it can also be helpful to look for trends in other ways. For example, the past several years might be assessed to see if there is a trend in total growth or decline for those years on a summary basis or by period. Clear Lake Sporting Goods had sales in the current year of $126,000, in the prior year of $105,000, and two years ago of $89,000. This reflects a 20% increase and an 18% increase, respectively. It might be reasonable to expect a roughly 18 to 20% increase in total sales in the future with only this information in mind. Keep in mind that we will learn about many other factors to consider in the forecast, so the 18 to 20% increase is a good general guideline to consider along with other factors.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"265.2px\" \/>THINK IT THROUGHSales Forecast for Big 5 Sporting GoodsReview the 2020 annual report for Big 5 Sporting Goods (https:\/\/openstax.org\/r\/ 2020_annual_report_for_Big_5_Sporting_Goods). Locate the consolidated statements of operations on page F-7. Using the company\u2019s net sales figures for the current and prior years, what percentage might you recommend for their sales forecast for the next year?Solution:Big 5\u2019s sales for 2020 and 2019 were $1,041,212,000 and $996,495,000, respectively. This represents a 4.5% growth from the prior year. Forecasted sales, based solely on this information, might be appropriate at 4.5% growth for the next year, keeping in mind that many other factors should also be considered along with this information. Historical sales are only one set of data to use as a starting point.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Looking at <a href=\"#_bookmark1339\">Figure 18.9<\/a>, assume that Clear Lake Sporting Goods decides to take its first pass at a forecast using the more conservative estimate of 18% total sales growth. The company could consider last year\u2019s sales of<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">$126,000 and increase them by 18% to arrive at total forecasted sales for next year of<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt;text-indent: 0.45pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image12-12.png\" alt=\"image\" width=\"162.431916010499px\" height=\"12.6559580052493px\" \/>. Next, to get the monthly sales, the company could use the same percent of the total for each month that it did for the previous year. For example, sales in January of last year were 7.1% of the full year\u2019s sales. To find the forecast for the next year, the company would take the forecasted sales of<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">$148,680 for the year and multiply that by 7.1% to get $10,620 for January. The process is repeated for each<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">month to get the full year.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image13-5.png\" alt=\"image\" width=\"576.959790026247px\" height=\"163.199895013123px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1339\"><\/a><strong>Figure<\/strong> <strong>18.9<\/strong> <strong>Forecasted<\/strong> <strong>Sales<\/strong><strong> Data<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Keep in mind that this is only a starting point. These estimates will be reviewed, assessed, and updated as more information and other factors are taken into consideration.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">It can also be helpful to look at a shorter period, perhaps just the last few months, on a more detailed basis (by department, by customer, etc.) to see if there are any possible new trends beginning to develop that might be an indicator of performance in the coming year. For example, Clear Lake Sporting Goods might look at detailed sales records for October, November, and December and see that it had an old product line that was discontinued in early October, which contributed to a 2% reduction in monthly sales. This reduction in monthly sales will likely continue into the new year until the new line the company has signed on begins arriving in stores. Thus, the management team feels they should reduce their first quarter monthly estimates by 2%, as reflected in <a href=\"#_bookmark1340\">Figure 18.10<\/a>. January is now <img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image14-5.png\" alt=\"image\" width=\"141.533858267717px\" height=\"12.6559580052493px\" \/>, for example.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image15-22.png\" alt=\"image\" width=\"576.960209973753px\" height=\"88px\" \/><\/p>\r\n\r\n<h4><a id=\"_bookmark1340\"><\/a>Changes for the Future<\/h4>\r\n<p class=\"import-Normal\" style=\"margin-left: 17pt\"><br style=\"clear: both\" \/><strong>Figure<\/strong> <strong>18.10<\/strong> <strong>Adjusted<\/strong> <strong>Forecasted<\/strong> <strong>Sales<\/strong> <strong>Data<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">It\u2019s important to note that the past is not always a reliable predictor of the future. Circumstances can often change to make the future quite different from the past. The business itself may change, the economy can change, the customer base may undergo a shift in demographics or a change in buying habits, new competition may emerge, and so on. So while past performance is helpful, it is only one step in the process of forecasting sales.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"158.4px\" \/>LINK TO LEARNINGBig 5 Sporting Goods MD&amp;A ReportReview the most recent annual report for Big 5 Sporting Goods (https:\/\/openstax.org\/r\/ annual_report_for_Big_5_Sporting_Goods). Review the management\u2019s discussion and analysis (MD&amp;A) report (Item 7). What information does the report share about the firm, the economy, and other factors that might be useful for forecasting sales growth for next year?<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Most firms first look to the past to target some form of baseline estimate for the coming year; then, managers begin making adjustments based on what they know about the future. Assume that Clear Lake Sporting Goods will be adding a new brand to its collection of fishing supplies in March. The manufacturer plans to begin running its commercials in late February, which managers anticipate will increase Clear Lake\u2019s monthly sales<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">by about $500 in March, $1,000 in April, $1,400 in May, and $2,000 per month in June, July, and August. We see the monthly adjustments to Clear Lake\u2019s latest sales forecast in <a href=\"#_bookmark1341\">Figure 18.11<\/a>. March, for example, is now<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">$10,908 ($10,408 prior estimate plus $500 increase from new brand).<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image16-7.png\" alt=\"image\" width=\"576.640209973753px\" height=\"88px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 154.35pt\"><a id=\"_bookmark1341\"><\/a><strong>Figure<\/strong> <strong>18.11<\/strong> <strong>Forecasted<\/strong> <strong>Sales<\/strong> <strong>Data<\/strong> <strong>with<\/strong> <strong>New<\/strong> <strong>Brand<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 46.25pt\">What we have discussed here are only some brief examples of the myriad factors that might impact a sales budget for the coming year. It\u2019s critical that all members of the team take the time and effort to research their customers and the factors that impact their business in order to effectively assess the impact of these factors on future sales. Though only two adjustments were made here, it\u2019s likely that a large firm would have to consider many, many factors that would ultimately impact monthly sales figures before arriving at a conclusion.<\/p>\r\n\r\n<h3><img src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.6px\" \/>18.3\r\n<a id=\"_bookmark1342\"><\/a>Pro Forma Financials<\/h3>\r\n<h4>Learning Outcomes<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\r\n\r\n<ul>\r\n \t<li>Define pro forma in the context of a financial forecast.<\/li>\r\n \t<li>Describe the factors that impact the length of a financial forecast.<\/li>\r\n \t<li>Explain the risks associated with a financial forecast.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 46.1pt\">In this section of the chapter, we will move beyond the sales forecast and look at the general nature, length, and timeline of forecasts and the risks associated with using them. We\u2019ll look at why we use them, how long they generally are, what the key variables in a forecast are, and how we pair those variables with common-size analysis to develop the forecast.<\/p>\r\n\r\n<h4>Purpose of a Forecast<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 42.5pt\">As mentioned earlier in the chapter, forecasts serve different purposes depending on who is using them. Our <a id=\"_bookmark1343\"><\/a>focus here, however, is the world of finance. In this realm, the key purpose of <strong>pro<\/strong> <strong>forma<\/strong> (future-looking) financial statements is to manage a firm\u2019s cash flow and assess the overall value that the firm is generating through future sales growth. Growing just for the sake of growing doesn\u2019t always yield favorable income for the firm. A larger top-line sales figure that results in lower net income doesn\u2019t make sense in the grand scheme of things. The same is true of profitable sales that don\u2019t generate enough cash flows at the right time. The firm may make a profit, but if it doesn\u2019t manage the timing of its cash flows, it could be forced to shut down if it can\u2019t cover the costs of payroll or keep the lights on. Forecasting helps assess both cash flow and the profitability of future growth. Managers can forecast cash flow using data from forecasted financial statements; this allows them to identify potential gaps in cash and plan ahead in order to either alter collection and payment policies or obtain funding to cover the gap in the timing of cash flows.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"140.4px\" \/>LINK TO LEARNINGPro Forma Financial StatementsReview the video Business Plan and Pro-Forma Financial Statements (https:\/\/openstax.org\/r\/ Business_Plan_and_Pro-Forma_Financial_Statements) to learn about the basics of pro forma financial statements and why they are helpful.<\/p>\r\n\r\n<h4>Length of a Forecast<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasts can generally be for any length of time. The length generally depends on the user\u2019s needs. A one- year forecast, broken down by month, is quite typical. A firm will often go through a formal budgeting process near the end of its calendar or fiscal year to project financial plans and goals for the coming year. Once that is done, a rolling financial forecast is then done monthly to adjust as time moves on, more information becomes available, and circumstances change.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">To be useful, the future forecast for financial planning purposes is almost always calculated as monthly increments rather than one total figure for the next 12 months. Breaking the data down by month allows finance managers to more clearly see fluctuations in cash flows in and out, identify potential gaps in cash flow, and plan ahead for their cash needs.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasts can also be done for several years into the future. In fact, they commonly are. However, once the firm is looking out beyond 12 months, it gets difficult to forecast items with a great degree of accuracy. Often, forecasts beyond a year will be completed only to quarterly or even annual figures rather than monthly.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasts that far into the future are often strategic in nature, made more to communicate future plans for the firm than for more detailed decision-making and cash flow planning.<\/p>\r\n\r\n<h4>Common-Size Financials<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">As we saw earlier in the chapter, common-size analysis involves using historical financial statements as a basis for future forecasts. Financial statements provide a great starting point for analysis, as we can see the relationships between sales and costs on the income statement and the relationships between total assets and line items on the balance sheet.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">For example, in <a href=\"#_bookmark1334\">Figure 18.6<\/a>, we saw that for the past two years, cost of goods sold has been 50% of sales. Thus, in the first draft of a forecast for Clear Lake, it\u2019s likely that managers would estimate cost of goods sold at 50% of their forecasted sales. We can begin to see why forecasting sales first is crucial and why doing so as accurately as possible is also important.<\/p>\r\n\r\n<h4>Select Variables to Use<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 45.3pt\">A simple way to begin a full financial statement forecast might be to simply use the common-size statements and forecast every item using historical percentages. It\u2019s a logical way to begin a very rough draft of the forecast. However, several variables should be taken into consideration. First, managers must address the cost of an account and determine if it\u2019s a variable or fixed item. Variable costs tend to vary directly and proportionally with production or sales volume. Common examples include direct labor and direct materials. Fixed costs, on the other hand, do not change when production or sales volume increases or decreases within the relevant range. Granted, if production were to increase or decrease by a large amount, fixed costs would indeed change. However, in normal month-to-month changes, fixed costs often remain the same. Common examples of fixed costs include rent and managerial salaries.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">So, if we were to approach our common-size income statement, for example, we would likely use the percentage of sales as a starting point to forecast variable items such as cost of goods sold. However, fixed costs may not be accurately forecast as a percentage of sales because they won\u2019t actually change with sales. Thus, we would likely look at the history of the dollar values of fixed costs in order to forecast them.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"122.4px\" \/>CONCEPTS IN PRACTICECOVID-19 Makes Forecasting Difficult for Big 5 Sporting GoodsBig 5 Sporting Goods announced record earnings in the third quarter of 2020, attributing its huge success that quarter to the impact of people\u2019s reactions to the COVID-19 pandemic. With so many people in<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><img src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"177.599895013123px\" \/>quarantine still wanting to make healthy lifestyle choices, sporting goods stores were making record sales. Record-breaking sales, however, are not certain in the future. The impacts of the pandemic are extremely difficult to predict, making it a challenge for Big 5 Sporting Goods and other companies to assemble pro forma financial statements.(sources: https:\/\/www.globenewswire.com\/news-release\/2020\/10\/27\/2115470\/0\/en\/Big-5-Sporting-Goods- Corporation-Announces-Record-Fiscal-2020-Third-Quarter-Results.html; https:\/\/finance.yahoo.com\/news\/ investors-want-big-5-sporting-054658521.html; https:\/\/www.cpapracticeadvisor.com\/accounting-audit\/ news\/21206691\/four-ways-covid19-will-impact-2021-financial-forecasting-and-planning)<\/p>\r\n\r\n<h4>Determine Potential Changes in Variables<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">So far, we have focused on using historical common-size statements to create a draft (not a final version) of the forecast. This is because the past isn\u2019t always a perfect indicator of the future, and our finances don\u2019t always follow a linear pattern. We use the past as a good starting point; then, we must assess what else we know to fine-tune and make adjustments to the forecast.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 25.25pt\">Many items impact the forecast, and they will vary from one organization to another. The key is to do research, gather data, and look around at the market, the economy, the competition, and any other factors that have the potential to impact the future sales, costs, and financial health of the company. Though certainly not an exhaustive list, here are a few examples of items that may impact Clear Lake Sporting Goods.<\/p>\r\n\r\n<ul>\r\n \t<li>It has an old product line that was discontinued in early October, contributing to a 2% reduction in monthly sales that will likely continue into the new year until a new line begins arriving in stores.<\/li>\r\n \t<li>It will be adding a new brand to its collection of fishing supplies in March. The manufacturer plans to begin running commercials in late February. Managers anticipate that this will increase Clear Lake\u2019s monthly sales by about $500 in March, $1,000 in April, $1,400 in May, and $2,000 per month in June, July, and August.<\/li>\r\n \t<li>The company has just finished updating its employee compensation package. It goes into effect in January of the new year and will result in an overall 4% increase in the cost of labor.<\/li>\r\n \t<li>The landlord indicated that rent will increase by $50 per month starting July 1.<\/li>\r\n \t<li>Some fixed assets will be fully depreciated by the end of March. Thus, depreciation expense will go down by $25 per month beginning in April.<\/li>\r\n \t<li>There are rumors of new regulations that will impact the costs of importing some of the more difficult-to- obtain hunting supplies. Managers aren\u2019t entirely sure of the full impact of the new legislation at this time, but they anticipate that it could increase cost of goods sold for the affected product line when the new legislation goes into effect in the last quarter. Their best estimate is that it could increase the overall cost of goods sold by up to 2%.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">We will use all of this data later in the chapter when we are ready to compile a complete forecast for Clear Lake.<\/p>\r\n\r\n<h3><img src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.4\r\n<a id=\"_bookmark1345\"><\/a>Generating the Complete Forecast<\/h3>\r\n<h4>Learning Outcomes<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\r\n\r\n<ul>\r\n \t<li>Generate a forecasted income statement that incorporates pertinent sales, functional, and policy variables.<\/li>\r\n \t<li>Generate a forecasted balance sheet.<\/li>\r\n \t<li>Connect the balance sheet and income statement forecasts with appropriate feedback linkages.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">In this section of the chapter, we will tie together what we have learned so far about forecasting sales,<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">common-size analysis, and using what we know about the company and its environment to create a full set of pro forma (forward-looking or forecasted) financial statements.<\/p>\r\n\r\n<h4>Forecast the Income Statement<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">To arrive at a fully forecasted income statement, we use historical income statements, common-size income statements, and any additional information we have about future sales and costs, such as the effects of the economy and competition. As we saw earlier in the chapter, we begin with forecasted sales because they are the basis for many of the forecasted costs.<\/p>\r\n<p class=\"import-BodyText\" style=\"text-align: justify;margin-left: 17pt;margin-right: 51.6pt\">Let\u2019s begin with the sales forecast for Clear Lake Sporting Goods that we saw earlier in the chapter, in <a href=\"#_bookmark1339\">Figure<\/a> <a href=\"#_bookmark1339\">18.9<\/a>, and use it along with the prior year income statement by month shown in <a href=\"#_bookmark1346\">Figure 18.12<\/a>. We will consider other data we have about the business to begin creating a full income statement (see <a href=\"#_bookmark1347\">Figure 18.13<\/a>).<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image17-6.png\" alt=\"image\" width=\"576.64px\" height=\"278.08px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 136.45pt\"><a id=\"_bookmark1346\"><\/a><strong>Figure<\/strong> <strong>18.12<\/strong> <strong>Prior<\/strong> <strong>Year<\/strong> <strong>Monthly<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong> <strong>by<\/strong> <strong>Month<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">The first two key points regarding product lines have already been built into the sales forecast. Notice that the cost of goods sold was 50% in the prior year. However, based on possible future legislation, to be conservative, we should increase the cost of goods sold by 2% in the last quarter of the year. Thus, we will forecast cost of goods sold at 50% of sales in the first nine months and increase it to 52% in the last three months of the year.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Rent is a fixed cost that historically amounts to $458 per month. However, we know that the landlord is increasing rent by $50 starting on July 1. Thus, we will forecast rent at the same fixed cost of $458 per month for the first six months and increase it to $508 per month for the second half of the year.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Depreciation, also a fixed cost, was historically $300 per month. However, we know that depreciation expense will go down by $25 beginning in April. Thus, we forecast depreciation at $300 for the first three months and at<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">$275 for the last 9 months.<\/p>\r\n<p class=\"import-BodyText\" style=\"text-align: justify;margin-left: 17pt;margin-right: 43.1pt\">Salaries expense has historically been $450 per month. However, we know that the company is implementing a new compensation program on January 1 that will increase salaries expense by 4% ($18). Thus, we will forecast salaries for the whole year at $468.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Utilities expense seems to vary somewhat by sales from month to month, as shops are open longer hours during their busy season. However, the total utilities expense is not expected to change for the coming year. Thus, the forecast for utilities expense remains at $2,500, broken down by month as a percentage of sales.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Interest expense is a fixed cost and isn\u2019t anticipated to change. Thus, the same $167 interest expense per month is forecast for the coming year.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Finally, income tax expense is forecasted as a percentage of operating income because tax liability is incurred as a direct result of operating income. <a href=\"#_bookmark1347\">Figure 18.13<\/a> shows the next 12 months\u2019 forecast for Clear Lake Sporting Goods using all of this data.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image18-3.png\" alt=\"image\" width=\"576.64px\" height=\"266.879895013123px\" \/><\/p>\r\n\r\n<h4><a id=\"_bookmark1347\"><\/a>Forecast the Balance Sheet<\/h4>\r\n<p class=\"import-Normal\" style=\"margin-left: 5.55pt\"><br style=\"clear: both\" \/><strong>Figure<\/strong> <strong>18.13<\/strong> <strong>Forecasted<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Now that we have a reasonable income statement forecast, we can move on to the balance sheet. The balance sheet, however, is entirely different from the income statement. It requires a bit more research and additional assumptions. Just like the income statement, it\u2019s often a work in progress. A first draft is a good starting point, but adjustments must be made once it is created, and all the interrelationships between the statements, cash flow in particular, are taken into consideration.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">The balance sheet is a bit more difficult to forecast because the statement reflects balances at just a given point in time. Account balances change daily, so forecasting just one snapshot in time for each month can be a challenge. A good starting point is to assess general company financial policies or rules of thumb. For example, assume that Clear Lake pays most of its vendors on net 30-day terms. A good way to forecast accounts payable on the balance sheet might be to add up the cost of goods sold from the forecasted income statement for the prior month. For example, in <a href=\"#_bookmark1348\">Figure 18.14<\/a>, we see that Clear Lake has forecasted its accounts payable for March as the cost of goods sold in March from its forecasted income statement.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 45.7pt\">For accounts receivable, Clear Lake generally receives payment from customers within net 90-day terms. Thus, it uses the sum of the current and prior two months\u2019 forecasted sales to estimate its accounts receivable balance.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Inventory will vary throughout the year. For the first six months, the company tries to build inventory for four months of sales. Once the busy season hits, inventory goes down to three months\u2019 worth of future sales, then finally drops to only two months of sales in December. Thus, managers use their sales forecast by month to estimate their inventory ending balance each month.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">The equipment balance is forecasted by reducing the prior month\u2019s balance by the forecasted depreciation expense on the forecasted income statement.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Unearned revenue is historically around 50% of the current month\u2019s sales. Thus, Clear Lake estimates its unearned revenue balance each month by taking the current month\u2019s net sales from the forecasted income statement and multiplying it by 50%.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Short-term investments, notes payable, and common stock are not anticipated to change, so the current balance is forecasted to remain the same for the next 12 months.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">To forecast the ending balance for retained earnings for each month, managers add the monthly net income from the forecasted balance sheet to the prior balance and subtract a quarterly $10,000 dividend.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 46.1pt\">Once all of these accounts are completed, the balance sheet is out of balance. Given that all of these events are somewhat related but are not tied together dollar for dollar, it\u2019s not surprising when the forecasted balance sheet is finished and does not balance. To complete the first draft (see <a href=\"#_bookmark1348\">Figure 18.14<\/a>), the cash account is used as a variable and plugged in to make the balance sheet balance. Notice that by the end of the year, the company has $59,905 in cash. However, look at what happens midyear\u2014the cash account falls to only $8,782. In the next section, we will generate a cash flow forecast, which will allow Clear Lake to update its balance sheet forecast once it estimates what it will do to cover the cash flow gaps.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image19-9.png\" alt=\"image\" width=\"576.639895013123px\" height=\"344.64px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 167.75pt\"><a id=\"_bookmark1348\"><\/a><strong>Figure<\/strong> <strong>18.14<\/strong> <strong>Forecasted<\/strong> <strong>Balance<\/strong> <strong>Sheet<\/strong> <strong>Draft<\/strong><\/p>\r\n\r\n<h4>Linkages between the Forecasted Balance Sheet and the Income Statement<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Notice that in the discussion in the prior section on the balance sheet forecast, a lot of the information in the forecasted income statement was used to generate the forecasted balance sheet. The balance sheet accounts generally depend on activity reported in the income statement. For example, for many firms, the balance in their accounts receivable account is tied to their sales. Looking at historical balances in the accounts receivable account and how those relate to historical sales will help determine how to use the forecasted future sales to estimate the future balance of accounts receivable.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">The same is true of accounts payable. Looking at past balances, past expenses (normally cost of goods sold), and the firm\u2019s payment terms for its vendors allows managers to use forecasted cost of goods sold or other expenses to estimate the balance in the accounts payable account.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">We learned in <a href=\"#_bookmark361\">Financial Statements<\/a> that net income flows into retained earnings. Thus, the net income from the forecasted income statement can be used to help estimate the ending balance in retained earnings. If the firm intends to issue any dividends in the coming year, managers should also estimate that reduction in their forecast.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">It\u2019s also common to find other general policies or procedures that help drive performance and aid in forecasting balances. For example, if the company has a goal of maintaining a certain level of inventory or a minimum balance in its cash account, that information can be used to guide the estimate for those accounts.<\/p>\r\n\r\n<h3><img src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.5\r\n<a id=\"_bookmark1349\"><\/a>Forecasting Cash Flow and Assessing the Value of Growth<\/h3>\r\n<h4>Learning Outcomes<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\r\n\r\n<ul>\r\n \t<li>Generate a cash flow forecast.<\/li>\r\n \t<li>Assess a cash flow forecast to determine future cash funding needs.<\/li>\r\n \t<li>Use pro forma financial statements and cash flow forecasts to assess the value of growth to the firm.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">In this section of the chapter, we will use the forecasted income statement, forecasted balance sheet, and other information we know about the firm\u2019s policies and goals for the coming year to generate and assess a cash flow forecast.<\/p>\r\n\r\n<h4>Create a Cash Flow Forecast<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">A cash flow forecast isn\u2019t overly complex, yet it is not easy to assemble because it requires making many <a id=\"_bookmark1350\"><\/a>assumptions about the future. A <strong>cash forecast <\/strong>begins with the beginning cash balance, adds anticipated cash inflows, and deducts anticipated cash outflows. This identifies cash surpluses and shortages.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">For Clear Lake Sporting Goods, for example, we see in <a href=\"#_bookmark1351\">Figure 18.15<\/a> that the company begins with cash of<\/p>\r\n<p class=\"import-BodyText\" style=\"text-align: justify;margin-left: 17pt;margin-right: 51.95pt\">$42,581,000 in January of the new year. Next, it lists the cash inflows, or cash received from customers. Given the assumption that customers pay in 90-day terms, the cash flow is filled in by plugging in the sales forecast for the three prior months. For example, the cash flow from customers of $10,508 for June is the same as the net sales forecast for March (see <a href=\"#_bookmark1347\">Figure 18.13<\/a>).<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image20-12.png\" alt=\"image\" width=\"576.639895013123px\" height=\"143.68px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.4pt\"><a id=\"_bookmark1351\"><\/a><strong>Figure<\/strong> <strong>18.15<\/strong> <strong>Forecasted<\/strong> <strong>Cash<\/strong> <strong>Inflows<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Next, Clear Lake identifies cash outflows, which include accounts payable, salaries, rent, utilities, dividends, and interest payments. Accounts payable are normally paid within 30 days, so the forecast for cost of goods sold for the prior month is used as an estimate of amount paid for payables. For example, in <a href=\"#_bookmark1352\">Figure 18.16<\/a>, we see that the accounts payable settled in June of $8,610 is the cost of goods sold for May from the forecasted income statement.<\/p>\r\n<p class=\"import-BodyText\" style=\"text-align: justify;margin-left: 17pt;margin-right: 48.8pt\">Salaries are paid monthly and thus represent the same recurring monthly cash outflow, as does rent. Utilities, like accounts payable, are assumed to be paid within 30 days. Thus, the cash outflow for utilities is the utilities expense for the prior month from the forecasted income statement.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 65.05pt\">Management intends to pay a quarterly dividend of $10,000. Thus, in <a href=\"#_bookmark1352\">Figure 18.16<\/a>, we see $10,000 cash outflows forecasted for March, June, September, and December. Interest on the long-term liability is paid quarterly. Thus, the $500 cash outflows in March, June, September, and December are simply the monthly interest expense of $167 from the income statement, summed for each quarter.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image21-5.png\" alt=\"image\" width=\"576.639790026247px\" height=\"233.28px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.4pt\"><a id=\"_bookmark1352\"><\/a><strong>Figure<\/strong> <strong>18.16<\/strong> <strong>Forecasted<\/strong> <strong>Cash<\/strong> <strong>Inflows<\/strong> <strong>and<\/strong> <strong>Outflows<\/strong><\/p>\r\n\r\n<h4>Using a Cash Forecast to Determine Additional Funds Needed<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Finally, at the end of the cash flow forecast, cash outflows are subtracted from the cash inflows. This identifies <a id=\"_bookmark1353\"><\/a>whether a <strong>cash surplus <\/strong>(extra) or <strong>cash deficit <\/strong>(not enough) exists for each month. For example, in <a href=\"#_bookmark1354\">Figure<\/a> <a href=\"#_bookmark1354\">18.17<\/a>, we see that in March, Clear Lake is forecasting $4,800 of cash inflows and $17,800 of total cash outflows, which results in a cash deficit of $13,000.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Clear Lake has a general policy to not let its cash balance fall below $35,000. Thus, managers need to assess their monthly balances and potential deficits and identify months when financing is necessary. For example, the deficit of $13,000 in March is enough to push the cash balance lower than $35,000. Thus, it\u2019s estimated that the company will need $5,000 in short-term financing in March. It has an estimated surplus in April, so $3,000 of the borrowing is returned.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image22-17.png\" alt=\"image\" width=\"576.64px\" height=\"278.08px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.5pt\"><a id=\"_bookmark1354\"><\/a><strong>Figure<\/strong> <strong>18.17<\/strong> <strong>Forecasted<\/strong> <strong>Cash<\/strong> <strong>Surplus<\/strong> <strong>or<\/strong> <strong>Deficit<\/strong><\/p>\r\n\r\n<h4>Assessing the Value of Growth<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 52.75pt\">It\u2019s a fairly common assumption that most, if not all, businesses want to grow. While it certainly can be good as a firm to grow in size, growth just for the sake of growth isn\u2019t necessarily a good goal. A firm can grow in size based on customers, employees, locations, or simply sales. However, that doesn\u2019t mean that the growth will increase profits. Growth may increase profits, but this is not a safe assumption. Scaling up operations takes careful planning, which includes monitoring the profitability of the sales and, of course, the cash flow it<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 56.05pt\">would require. Growing a business can require more inventory, more locations, more equipment, and more manpower, all of which cost money. Even if the forecasted growth is profitable, it may pose problems from a cash flow perspective. It\u2019s important that the firm review not only its forecasted income statement and balance sheet but also its cash forecast, as this can reveal some serious gaps in funding depending on the extent, timing, and nature of the planned growth.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">For example, assume that Clear Lake Sporting Goods intends to run a large-scale ad campaign to boost sales in its busy season. Historically, the store relied primarily on its prime location for high volumes of retail foot traffic. Managers felt, however, that given the increase in competition, they could boost sales significantly by running the ad campaign in the first quarter. The campaign would cost $30,000. Forecasts already reflect a cash deficit at the end of the first quarter of $13,000, so the additional $30,000 ad campaign, which would require payment up front, would create a much larger need for funding. It\u2019s also important that managers look at the increased cost of doing business along with the increased cost in advertising to ensure that the move would be profitable. Fortunately, Excel or other forecasting software can be used to create a forecast <a id=\"_bookmark1355\"><\/a>with formulas that tie together, making <strong>scenario<\/strong> <strong>analysis<\/strong> such as this a much easier process.<\/p>\r\n\r\n<h4>Scenarios in Forecasting<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasting is almost never a linear process. In other words, we don\u2019t do one forecast and call it good. The first draft is completed using historical data, and then changes are made a bit at a time as all potential variables are assessed for their impact on the forecast. It\u2019s quite common to then use the work-in-progress forecast to complete scenario analysis. This is particularly true when the forecast is completed in Excel or other budgeting or forecasting software. Elements of the forecast can be changed to see what the overall impact would be to the firm. Assuming the forecast is set up using formulas in Excel or other software, a change to one figure or one variable would then \u201cripple\u201d through the forecast to reflect the overall impact.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 61.25pt\">Often, a firm may complete an initial forecast (scenario) under the assumption that the economy is in a \u201cnormal state.\u201d The firm can then alter the initial forecast for different scenarios, such as the economy in a recession or the economy in a state of expansion. This helps the firm understand different possible future states and highlights how changes in the economy such as inflation may cause revenue and expenses to increase.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Assume that Clear Lake\u2019s initial forecast is created under the assumption that the economy will remain average. Management also wants to know the worst-case scenario. What will their financial results look like if the economy were in a recession, for example? If management assumes their sales would drop to only 60% of the prior year sales in a recessionary economy, they could alter the formula in Excel driving their sales and variable costs, resulting in a new pro forma income statement. In <a href=\"#_bookmark1356\">Figure 18.18<\/a>, we can see that net income would drop to $16,391 under this assumption, compared to the net income of $47,653 forecasted under average economy assumptions in <a href=\"#_bookmark1347\">Figure 18.13<\/a>.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image23-6.png\" alt=\"image\" width=\"576.64px\" height=\"266.879895013123px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 162.6pt\"><a id=\"_bookmark1356\"><\/a><strong>Figure<\/strong> <strong>18.18<\/strong> <strong>Forecasted<\/strong> <strong>Cash<\/strong> <strong>Surplus<\/strong> <strong>or<\/strong> <strong>Deficit<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 44.6pt\"><a id=\"_bookmark1357\"><\/a>Though creating a full forecast in Excel can be a bit complex, it is a powerful tool that is useful for analysis. Elements can be used to vary just about anything, from something small such as a 1% increase in the cost of a product to a company-wide increase in salaries, the introduction of an entire new product line, or the purchase of a new production machine, among other possibilities.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.25pt\">For example, assume that Clear Lake has completed a first pass at its forecast and is reviewing the forecasted profit for the next 12 months. Managers feel the profit is currently low, as they always want to target a certain percentage. They might tinker with variables in the forecast file to see the impact on profits of potential changes they are considering. They may reduce the new salaries package by a percentage point to see if it gets them closer to their goal. They may adjust cost of goods sold by a certain percentage if they feel they can negotiate with vendors to work down their costs. They may adjust rent and see if they can find a better retail location to either reduce costs or increase sales due to increased foot traffic in a new location. They may save an entirely new version of the forecast and change it drastically to see what investing in opening a second retail location would do.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">As you can see, the list of possibilities is endless. Though the main goal of financial managers may be cash planning, the power of a well-developed forecast is tremendous. It can help assess potential growth, new opportunities, and even small changes in the business as well.<\/p>\r\n\r\n<h4>Sensitivity Analysis in Forecasting<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 50.35pt\"><a id=\"_bookmark1358\"><\/a><strong>Sensitivity analysis <\/strong>will often look at the change in just one variable rather than the entire scenario. It examines how sensitive a particular output (commonly net income) will be to a change in a particular underlying input (sales or costs, for example). What if sales are 10% more or less than forecasted? What if the prices the firm can charge its customers are 10% more or less? What if the cost of goods sold increases by 10%? The purpose is to see which variables are crucial to \u201cget right.\u201d It isn\u2019t worth spending a lot of research dollars to make sure you are accurately predicting a variable if that variable won\u2019t notably change the outcome. However, a slight change in other variables may have significant impact.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Using pro forma financial statements created in Excel allows management to quickly generate new pro forma financials and see the impact that each possible variable might have on the overall financial results.<\/p>\r\n\r\n<h3><img src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.6\r\n<a id=\"_bookmark1359\"><\/a>Using Excel to Create the Long-Term Forecast<\/h3>\r\n<h4>Learning Outcomes<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\r\n\r\n<ul>\r\n \t<li>Generate a financial statement forecast using spreadsheet tools.<\/li>\r\n \t<li>Connect the balance sheet and income statement using appropriate formula referencing.<\/li>\r\n \t<li>Use spreadsheet functions to generate appropriate iterations that balance financial forecasts.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Throughout this chapter, we have seen forecasted financial statements for Clear Lake Sporting Goods along with its forecasted cash flow. These statements could all have been generated by hand, of course, but that wouldn\u2019t be an effective use of time. As mentioned in prior sections, several different types of software can be quite effective in making the forecasting process faster and more flexible. In this section, we will review just one common option, Microsoft Excel.<\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 44pt;margin-right: 58.95pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image24-6.png\" alt=\"image\" width=\"30.8px\" height=\"37.6px\" \/>\r\n<em>Download<\/em> <em>the<\/em> <a class=\"rId90\" href=\"https:\/\/openstax.org\/r\/spreadsheet_file\"><em>spreadsheet<\/em> <em>file<\/em> <em>(https:\/\/openstax.org\/r\/spreadsheet_file)<\/em><\/a> <em>containing<\/em> <em>key<\/em> <em>Chapter<\/em> <em>18 <\/em><em>Excel<\/em> <em>exhibits.<\/em><\/p>\r\n<p class=\"import-BodyText\"><\/p>\r\n\r\n<h4>Using the \u201cSheet\u201d<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Creating a budget in Excel can be very simple or extremely complex, depending on the size and complexity of the business and the number of formulas and dependencies that are written into the Excel workbook.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Creating the forecast in Excel follows the same steps and flow we just explored in this chapter but with the power of a software program to do the math for you. We begin with the sales forecast, which uses several key formulas in Excel.<\/p>\r\n\r\n<ul>\r\n \t<li>First, sales are projected to be 18% higher than the prior year. Thus, a total projection for the year is calculated using a simple link and multiplication function tied to last year\u2019s total sales. In <a href=\"#_bookmark1360\">Figure 18.19<\/a>, you can see the formula in cell O4 is \u201c='Figure 18.12'!N4*1.18\u201d. This formula simply does the math to increase the prior year\u2019s sales by 18%.<\/li>\r\n \t<li><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image26-4.png\" alt=\"image\" width=\"576px\" height=\"153.599895013123px\" \/>Next, the sales are distributed by month. In <a href=\"#_bookmark1360\">Figure 18.19<\/a>, we see in cell B5 that the forecasted income statement sheet is linked to the percent of annual sales from the Prior Year Income Statement (<a href=\"#_bookmark1346\">Figure<\/a> <a href=\"#_bookmark1346\">18.12<\/a>) sheet. Then, in cell B4, January sales are estimated with a formula that multiplies the total forecasted sales in O4 by the percent of annual sales for January of the prior year. Notice that the formula then multiplies that product by 0.98. This is because Clear Lake discontinued a product line in the last quarter of the prior year, and management feels that this will reduce sales in the first quarter of the new year by roughly 2%.<\/li>\r\n<\/ul>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 27.4pt\"><a id=\"_bookmark1360\"><\/a><strong>Figure<\/strong> <strong>18.19<\/strong> <strong>Forecasted Sales Formulas<\/strong> <strong>in <\/strong><strong>Excel<\/strong><\/p>\r\n\r\n<ul>\r\n \t<li>As Clear Lake continues to fill out its forecasted income statement, the next formula we see is a simple sum formula to calculate net sales in B8 (see <a href=\"#_bookmark1361\">Figure 18.20<\/a>). It\u2019s a simple formula that subtracts sales returns and allowances in B7 from gross sales in B4. Similar formulas are also found in B10 for gross margin and B18 for net income.<\/li>\r\n \t<li>In cell B9, we see a multiplication formula that multiplies sales from B4 by 0.5, or 50%. This is because<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\" style=\"margin-left: 35pt;margin-right: 43.15pt\">management feels that cost of goods sold will remain the same as last year, in most quarters at least, and last year\u2019s percentage was 50%.<\/p>\r\n\r\n<ul>\r\n \t<li>Rent, depreciation, and salaries are all simply typed in, as they are fixed expenses that remain the same as last year.<\/li>\r\n \t<li>The utilities calculation, found in cell B14, is somewhat similar to the sales calculation. The total utilities expense from O14 is multiplied by the current month\u2019s sales in B4 divided by the total annual sales in O4. This spreads out the utility cost by month based on the percentage of annual sales.<\/li>\r\n<\/ul>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image27-7.png\" alt=\"image\" width=\"412px\" height=\"537px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 151.6pt\"><a id=\"_bookmark1361\"><\/a><strong>Figure<\/strong> <strong>18.20<\/strong> <strong>Forecasted<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong> <strong>Formulas<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 46.55pt\">Clear Lake\u2019s forecasted balance sheet ties very closely to both the forecasted income statement and the prior year\u2019s income statement. In <a href=\"#_bookmark1362\">Figure 18.21<\/a>, we see in C7 an addition formula using the sum of the current month and three months of prior sales as an estimate of the ending accounts receivable balance. The formula for inventory is similar but forward looking. In C8, inventory is estimated by adding the cost of goods sold for the current month and next three months from the forecasted income statement.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Total current assets in C10 is calculated with a SUM formula that adds together the values in all the selected cells. Amounts such as short-term investments and common stock that are not anticipated to change are simply typed as a number in the cell. Much like in the income statement, subtotals are found in C13 for total assets, C17 for current liabilities, C24 for total equity, and C25 for total liabilities and equity. Retained earnings in C23 pulls the ending retained earnings balance from the end of last year (hidden in column B) and adds the<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">net income for January in the forecasted income statement to get the current month\u2019s ending balance.<\/p>\r\n<p class=\"import-BodyText\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image28-7.png\" alt=\"image\" width=\"573.8px\" height=\"579.12px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 160.05pt\"><a id=\"_bookmark1362\"><\/a><strong>Figure<\/strong> <strong>18.21<\/strong> <strong>Forecasted<\/strong> <strong>Balance<\/strong> <strong>Sheet<\/strong> <strong>Formulas<\/strong><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 47.65pt\">Much like the balance sheet, the cash forecast also relies heavily on data from the forecasted income statement as well as the forecasted balance sheet. To begin the year, in <a href=\"#_bookmark1363\">Figure 18.22<\/a>, we see that the formula in B4 pulls the cash balance from the forecasted balance sheet. In B6, the formula pulls the sales for the three months prior from the previous year\u2019s income statement. This is because it\u2019s assumed that cash is collected from customers 90 days after the sale. The same approach is used for accounts payable, rent, salaries, and utilities. The formulas pull the expenses from a prior month depending on the assumed timing for payment. Utilities, for example, are assumed to be paid within 30 days, so the cash outflow in February is assumed to be the utilities expense for January from the forecasted income statement. Note that interest payments are assumed to be zero in January and February, but in March, the formula in D14 sums the interest expenses on the forecasted income statement for January, February, and March. This is because interest is paid quarterly.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Finally, note the formula in C4. The beginning cash balance for a given month is the same as the ending cash balance from the prior month; thus, the figure in B18 is linked to C4 to start the new month.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 34.3pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image29-9.png\" alt=\"image\" width=\"579.599895013123px\" height=\"581.4px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1363\"><\/a><strong>Figure<\/strong> <strong>18.22<\/strong> <strong>Cash<\/strong> <strong>Forecast<\/strong> <strong>Formulas<\/strong><\/p>\r\n\r\n<h4>Using Excel Functions to Balance<\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Once we get a draft of the forecasts outlined, then the tinkering starts. Additional information can be used to adjust the formulas, as we saw with the 2% reduction in January sales for the forecasted income statement. Because we have linked most (though not all) of our expenses, subtotals, and statements together using formulas, management can also use the forecast workbook to perform scenario and sensitivity analyses, essentially asking \u201cwhat if?\u201d and looking at the results. When completed, however, before finalizing the forecast, it\u2019s important that the financial statements are in balance (particularly the <em>balance<\/em> <em>sheet<\/em>, just as the name implies).<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Notice that throughout, we used formulas to calculate subtotals to ensure they are correct and change as needed. We also linked figures, such as the ending and beginning cash balances, to ensure they are in balance. Perhaps the easiest but most important thing to do is to ensure that the balance sheet balances. We can do this with a simple formula that compares total assets to total liabilities and equity. We can see in <a href=\"#_bookmark1364\">Figure 18.23<\/a> that subtracting one from the other in cell C27 should result in $0. If there is a difference, the formula will highlight it, forcing us to investigate and correct the sheet so that it balances.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 87.5pt\"><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image30-7.png\" alt=\"image\" width=\"436px\" height=\"611px\" \/><\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 169.7pt\"><a id=\"_bookmark1364\"><\/a><strong>Figure<\/strong> <strong>18.23<\/strong> <strong>Forecasted<\/strong> <strong>Balancing<\/strong> <strong>Formula<\/strong><\/p>\r\n<p class=\"import-BodyText\"><img src=\"#fixme\" alt=\"image\" width=\"48px\" height=\"1056px\" \/><\/p>\r\n<p class=\"import-BodyText\"><\/p>\r\n\r\n<h3><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image31-5.png\" alt=\"image\" width=\"22.2739107611549px\" height=\"25.1998950131234px\" \/> <a id=\"_bookmark1365\"><\/a>Summary<\/h3>\r\n<h4><a href=\"#_bookmark1322\">Th<\/a><a href=\"#_bookmark1322\">e Importance of Forecasting<\/a><\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasting financial statements is important to different users for different reasons. In finance, it\u2019s most important for assessing the value of future growth plans and planning for future cash flow needs.<\/p>\r\n\r\n<h4><a href=\"#_bookmark1335\">For<\/a><a href=\"#_bookmark1335\">ecasting Sales<\/a><\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">The sales forecast is the foundation on which much of the rest of the forecast is built. Thus, the sales forecast is completed first. Historical sales data and any other information on the firm, its products, the economy, its customers, and its competitors are all used to create the most accurate sales forecast possible.<\/p>\r\n\r\n<h4><a href=\"#_bookmark1342\">Pr<\/a><a href=\"#_bookmark1342\">o Forma Financials<\/a><\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Pro forma financial statements are forward looking in nature. They use the sales forecast, historical data, financial statement analyses, relationships between accounts and statements, and any other information known about the firm, the environment, and the future to create the most accurate financial statement forecast possible.<\/p>\r\n\r\n<h4><a href=\"#_bookmark1345\">Gener<\/a><a href=\"#_bookmark1345\">ating the Complete Forecast<\/a><\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Interrelationships among historical data, the forecasted income statement, and the forecasted balance sheet are all used to estimate each line item in the financial statements.<\/p>\r\n\r\n<h4><a href=\"#_bookmark1349\">For<\/a><a href=\"#_bookmark1349\">ecasting Cash Flow and Assessing the Value of Growth<\/a><\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Once the income statement and balance sheet forecasts are complete, data from those statements, information on company policies, and account relationships are used to generate a cash forecast. The cash forecast is important for identifying any gaps in cash flow so that financial managers can plan for cash needs. It\u2019s also important to review not only the cash forecast but all forecasted financial statements to assess the overall impact and value of proposed firm growth.<\/p>\r\n\r\n<h4><a href=\"#_bookmark1359\">Usin<\/a><a href=\"#_bookmark1359\">g Excel to Create the Long-Term Forecast<\/a><\/h4>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Excel can be a powerful tool for creating financial forecasts. Formulas that complete mathematical functions and tie accounts and financial statements together are used to create the statements, ensure that they balance, and facilitate scenario and sensitivity analyses.<\/p>\r\n\r\n<h3><img src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image32-4.png\" alt=\"image\" width=\"22.2739107611549px\" height=\"25.1998950131234px\" \/> <a id=\"_bookmark1366\"><\/a>Key Terms<\/h3>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.15pt;text-indent: 12pt\"><strong>balance<\/strong> <strong>sheet<\/strong> a financial statement that reflects a firm\u2019s asset, liability, and equity account balances at a given point in time<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><strong>cash<\/strong> <strong>deficit<\/strong> an excess of cash outflows over cash inflows for a given period<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><strong>cash<\/strong> <strong>forecast<\/strong> a financial statement that estimates a firm\u2019s future cash inflows and outflows<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><strong>cash<\/strong> <strong>surplus<\/strong> an excess of cash inflows over cash outflows for a given period<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.15pt;text-indent: 12pt\"><strong>common-size<\/strong> describes a financial statement in which each element is expressed as a percentage of a base amount<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 48.8pt;text-indent: 12pt\"><strong>financing<\/strong> <strong>activities<\/strong> cash business transactions reported on the statement of cash flows that reflect the use of financed funds<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 89pt;text-indent: 12pt\"><strong>forecast<\/strong> an estimate of future performance based on historical performance and other contextual information<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.7pt;text-indent: 12pt\"><strong>income<\/strong> <strong>statement<\/strong> a financial statement that measures a firm\u2019s financial performance over a given period of time<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.15pt;text-indent: 12pt\"><strong>investing<\/strong> <strong>activities<\/strong> cash business transactions reported on the statement of cash flows that reflect the acquisition or disposal of long-term assets<\/p>\r\n<p class=\"import-BodyText\"><img src=\"#fixme\" alt=\"image\" width=\"48px\" height=\"1056px\" \/><\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.15pt;text-indent: 12pt\"><strong>operating<\/strong> <strong>activities<\/strong> cash business transactions reported on the statement of cash flows that relate to ongoing day-to-day operations<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><strong>pro<\/strong> <strong>forma<\/strong> in the context of financial statements, forward-looking<\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 17pt;margin-right: 48.8pt\"><strong>scenario<\/strong> <strong>analysis<\/strong> analysis of how various situations and circumstances would impact the financial forecast <strong>sensitivity analysis<\/strong> analysis of the sensitivity of an output variable to a change in an input variable <strong>statement of cash flows<\/strong> a financial statement that lists a firm\u2019s cash inflows and outflows over a given<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt\">period of time<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 46.1pt;text-indent: 12pt\"><strong>statement<\/strong> <strong>of<\/strong> <strong>stockholders\u2019<\/strong> <strong>equity<\/strong> a financial statement that reports the difference between the beginning and ending balances of each of the stockholders\u2019 equity accounts during a given period<\/p>\r\n<p class=\"import-Normal\"><\/p>\r\n\r\n<\/div>","rendered":"<div class=\"why-it-matters\">\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Though no one in business has a crystal ball, managers must often do all they can to predict the future as accurately as possible. This is called <em>forecasting<\/em>. Accounting and finance professionals use past performance along with what they know about the business, its competitors, the economy, and the company\u2019s plans for the future to assemble detailed financial forecasts. Forecasts are useful to many individuals for different reasons. <a id=\"_bookmark1321\"><\/a>A budget, a type of static <strong>forecast<\/strong>, helps accountants and managers see how their plans for the coming year can be achieved. It outlines sales targets and how much can be spent on cost of goods sold and expenses to achieve the company\u2019s bottom-line (net income) targets. Investors use financial forecasts to help guide their decisions to buy, sell or hold stocks or to estimate future potential income through dividends. Perhaps most importantly, for our purposes in finance, forecasts are used to help predict and manage cash flows.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.65pt\">A business can have all the profit in the world at the end of the year, but if it doesn\u2019t raise enough cash (liquidity) to pay the bills and pay its employees halfway through the year, it could still go bankrupt despite being profitable. Forecasting sales and expenses helps assemble a cash forecast\u2014when sales will be collected and when expenses will be paid\u2014so that financial managers can look forward far enough to have enough time to react accordingly and secure short- or long-term financing to meet gaps in cash flow.<\/p>\n<h3><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.1<br \/>\n<a id=\"_bookmark1322\"><\/a>The Importance of Forecasting<\/h3>\n<h4>Learning Outcomes<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\n<ul>\n<li>Discuss how to use financial statements in forecasting firm financials.<\/li>\n<li>Explain why balance sheet items are important in forecasting a firm\u2019s financial result.<\/li>\n<li>Explain why income statement items are important in forecasting a firm\u2019s financial result.<\/li>\n<\/ul>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">In this section, we will briefly review some of the basic elements of financial statements and how we can analyze historical statements to help assemble financial forecasts. Financial forecasting is important to short- and long-term firm success. It helps a firm plan for the resources it will need, ensuring it will have enough cash on hand at the right time to cover daily operations and capital expenditures. It helps the firm communicate its future potential and manage its shareholders\u2019 expectations. It also helps management assess future risk and set plans in place to mitigate that risk.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Financial forecasting involves using historical data, analysis tools, and other information we can gather to make an educated guess about the future financial performance of the firm. Historical figures provide a reasonable starting point. We use tools such as ratios, common size, and trend analysis to fine-tune our forecast. And finally, we assess what we know about the firm, its competitors, the economy, and anything else that might impact performance and further fine-tune our forecast from there.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">It\u2019s important to take a moment to consider the role of ethics in forecasting. Ethics is a huge issue in the world of accounting and finance in general, and forecasting is no different. There can be tremendous pressure on management to perform, to deliver certain levels of profit, and to meet shareholder expectations.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Forecasting, as you will learn throughout this chapter, is not an exact science. There is a great deal of subjectivity that can come into play when forecasting sales and expenses. Ethical behavior is crucial in this area. Those who create forecasts must have a firm understanding of where their data comes from, how reliable it is, and whether or not their assumptions and projections are reasonably justified.<\/p>\n<h4>Financial Statement Foundations<\/h4>\n<p class=\"import-Normal\" style=\"margin-left: 17pt;margin-right: 52pt\">In <a href=\"#_bookmark361\">Financial Statements<\/a>, you were introduced to a firm called Clear Lake Sporting Goods. You learned about <a id=\"_bookmark1323\"><\/a>the four key financial statements: the <strong>income statement<\/strong>, <strong>balance sheet<\/strong>, <strong>statement of stockholders\u2019 <\/strong><a id=\"_bookmark1324\"><\/a><strong>equity<\/strong>, and <strong>statement of cash flows<\/strong>. Each one provides a different view of the firm\u2019s financial health and performance.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\"><a id=\"_bookmark1325\"><\/a>Clear Lake Sporting Goods is a small merchandising company (a company that buys finished goods and sells them to consumers) that sells hunting and fishing gear. It uses financial statements to understand its profitability and current financial position, to manage cash flow, and to communicate its finances to outside parties such as investors, governing bodies, and lenders. We will use Clear Lake\u2019s company information and historical financial statements in this chapter as we explore its forecasting process. It\u2019s important to note that in this chapter, we are focusing on just one firm and the one method its managers have chosen to forecast financial performance. There are a variety of types of firms in actual application, and they may choose to forecast their financial performance differently. We are demonstrating just one approach here.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.7pt\">The balance sheet shows all the firm\u2019s assets, liabilities, and equity at one point in time. It also supports the accounting equation in a very clear and transparent way. We find one section of the balance sheet contains all current and noncurrent assets that must total the other section of the balance sheet: total liabilities and equity. In <a href=\"#_bookmark1326\">Figure 18.2<\/a>, we see that Clear Lake Sporting Goods has total assets of $250,000 in the current year, which balances with its total liabilities and equity of $250,000.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 106.15pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image3-12.png\" alt=\"image\" width=\"384.96px\" height=\"458.56px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1326\"><\/a><strong>Figure 18.2<\/strong> <strong>Balance <\/strong><strong>Sheet<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 50.8pt\">The income statement reflects the performance of the firm over a period of time. It includes net sales, cost of goods sold, operating expenses, and net income. In <a href=\"#_bookmark1327\">Figure 18.3<\/a>, we see that Clear Lake had $120,000 in net sales, $60,000 in cost of goods sold, and $35,000 in net income in the current year.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image4-25.png\" alt=\"image\" width=\"384.959895013123px\" height=\"282.24px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1327\"><\/a><strong>Figure<\/strong> <strong>18.3<\/strong> <strong>Full<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Finally, the statement of cash flows is used to reconcile net income to cash balances. The statement begins with net income, then reflects adjustments to balance sheet accounts and noncash expenses. The statement of<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">cash flows is broken down into three key categories: operating, investing, and financing. This allows users to clearly see what elements of the business are generating or using cash. In <a href=\"#_bookmark1330\">Figure 18.4<\/a>, we see that Clear Lake <a id=\"_bookmark1329\"><\/a>had cash flow from <strong>operating<\/strong> <strong>activities<\/strong> of $53,600, cash used for <strong>investing<\/strong> <strong>activities<\/strong> of ($18,600), and cash <a id=\"_bookmark1328\"><\/a>used for <strong>financing activities <\/strong>of ($15,000).<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image5-18.png\" alt=\"image\" width=\"576.96px\" height=\"409.279895013123px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.4pt\"><a id=\"_bookmark1330\"><\/a><strong>Figure<\/strong> <strong>18.4<\/strong> <strong>Statement<\/strong> <strong>of<\/strong> <strong>Cash<\/strong><strong> Flows<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Another key concept to remember about the financial statements is that the statement of cash flows is necessary to truly understand how the firm is using and generating cash. A common misconception is that if a firm reports net income on its income statement, then it must have plenty of cash, and if it reports a loss, it must be short on cash. Although this can be true, it\u2019s not necessarily the case. Historically speaking, we need the statement of cash flows to get the full picture of how cash was used or generated in the past. Looking to the future, we need a cash flow forecast to plan for possible gaps in cash flow and, potentially, how to make the best use of any cash surplus. Throughout this chapter, we will see how to use historical financial statements to help develop the future cash forecast.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">It\u2019s also important to remember that the four financial statements are tied together. Net income from the income statement feeds into retained earnings, which live on the balance sheet. Equity balances on the balance sheet feed information to the statement of stockholders\u2019 equity. And information from both the income statement (net income and noncash expenses) and the balance sheet (changes in working capital accounts) all feed into the statement of cash flows. These relationships will be helpful to understand when using historical statements and preparing forecasts.<\/p>\n<h4>Balance Sheet Analysis<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Fully understanding the items that are on the balance sheet and how they relate to one another and to other financial statements will help you create a financial forecast. In <a href=\"#_bookmark361\">Financial Statements<\/a>, you learned that on the classified balance sheet, both assets and liabilities are broken down into current and noncurrent categories. You also know that the balance sheet must live up to its name\u2014it must balance. This means that total assets (what the company owns) must equal total liabilities and equity (what the company owes).<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">You continued your financial statement development in <a href=\"#_bookmark450\">Measures of Financial Health<\/a>, where you saw how to use elements of the balance sheet to assess financial health. Ratios based on balance sheet accounts can be useful for understanding relationships between balance sheet items\u2014how they related in the past and then, in forecasting, how those relationships might change or remain the same in the future. Examples of balance sheet ratios include the current ratio, quick ratio, cash ratio, debt-to-assets ratio, and debt-to-equity ratio.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 45.95pt\"><a id=\"_bookmark1331\"><\/a>In <a href=\"#_bookmark361\">Financial Statements<\/a>, you also explored common-size analysis. To prepare a <strong>common-size<\/strong> analysis of the balance sheet, every item on the statement must be expressed as a percentage of total assets. Seeing each item as a percentage\u2014that is, seeing its relationship to total assets\u2014is also helpful for assessing historical statements and how those percentages or relationships can be used to predict future balances in the forecast. For example, in <a href=\"#_bookmark1332\">Figure 18.5<\/a>, you can see that Clear Lake\u2019s current assets represented 80% of its total assets in both the current and prior years.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image6-11.png\" alt=\"image\" width=\"576.96px\" height=\"458.56px\" \/><\/p>\n<h4><a id=\"_bookmark1332\"><\/a>Income Statement Analysis<\/h4>\n<p class=\"import-Normal\" style=\"margin-left: 9.050000000000001pt\"><br style=\"clear: both\" \/><strong>Figure<\/strong> <strong>18.5<\/strong> <strong>Common-Size<\/strong> <strong>Balance<\/strong> <strong>Sheet<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Like balance sheet analysis, income statement analysis is also quite helpful in preparing for the forecasting process. In <a href=\"#_bookmark361\">Financial Statements<\/a>, you learned that the income statement is commonly broken down into a few sections. Cost of goods sold is deducted from net sales to arrive at gross margin. Gross margin refers to the profits earned solely on the sale of the product itself, without consideration for the expenses incurred to run the business. Next, operating expenses are deducted to reflect operating income. Operating income reflects the profits of the core business function. Finally, other items, such as interest expense, tax expense, and other gains and losses, are deducted to arrive at net income, a.k.a. the <em>bottom<\/em> <em>line<\/em>. Each segment of the income statement is helpful for assessing past performance and estimating future expenses for a forecast.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">You continued your financial statement development in <a href=\"#_bookmark450\">Measures of Financial Health<\/a>, where you saw how to<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">use elements of the income statement to assess historical financial performance. Ratios based on the income statement can be useful for understanding relationships between net sales and expenses\u2014how they related in the past and then, in forecasting, how those relationships might change or remain the same. Examples of income statement ratios include gross margin, operating margin, and profit margin. Common ratios that incorporate items from both the balance sheet and the income statement include return on assets (ROA), return on equity (ROE), inventory turnover, accounts receivable turnover, and accounts payable turnover.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"158.4px\" \/>LINK TO LEARNINGPerformance TrendsReview the most recent annual report for Big 5 Sporting Goods (https:\/\/openstax.org\/r\/ annual_report_for_Big_5_Sporting-Goods). Review the company\u2019s sales and gross margins for the current and past two years. How is their performance? Are their sales trending up or down? Why might the contribution margin have increased or decreased?<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">In <a href=\"#_bookmark361\">Financial Statements<\/a>, you also explored common-size analysis. To prepare a common-size analysis of the income statement, every item on the statement must be expressed as a percentage of net assets. Seeing each item as a percentage, in terms of its relationship to total sales, is also helpful for assessing historical statements and how those percentages or relationships can be used to predict future balances in the forecast. For example, in <a href=\"#_bookmark1334\">Figure 18.6<\/a>, you can see that Clear Lake\u2019s cost of goods sold represented 50% of its net sales in both the current and prior years.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image7-23.png\" alt=\"image\" width=\"576.959895013123px\" height=\"308.16px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 167.2pt\"><a id=\"_bookmark1334\"><\/a><strong>Figure<\/strong> <strong>18.6<\/strong> <strong>Common-Size<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong><\/p>\n<p class=\"import-BodyText\">\n<p class=\"import-BodyText\">\n<h3><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.2<br \/>\n<a id=\"_bookmark1335\"><\/a>Forecasting Sales<\/h3>\n<h4>Learning Outcomes<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\n<ul>\n<li>Explain how sales are the main driver for a financial forecast.<\/li>\n<li>Determine a past time period to formulate the basis for a financial forecast.<\/li>\n<li>Explain the advantages and disadvantages of using past data to forecast future financial performance.<\/li>\n<li>Calculate past sales growth averages.<\/li>\n<li>Justify adjusting relationships when forecasting future financial performance.<\/li>\n<\/ul>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 55.85pt\">In this section of the chapter, you will begin to explore the first step of creating a forecast: forecasting sales. We will discuss common time frames for sales forecasts and why we use historical data in our forecasts (but only with caution), and we will work through the process of forecasting future sales. We will be using the percent-of-sales method to forecast some expenses for Clear Lake Sporting Goods, the example used throughout the chapter. This method relies on sales data, further highlighting why accuracy in forecasting sales is crucial.<\/p>\n<h4>Sales as the Driver<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">A significant portion of a business\u2019s costs are driven by how much it sells. Thus, the sales forecast is the necessary first step in preparing a financial forecast. Common costs driven by sales include direct product costs, direct labor costs, and other key variable costs (i.e., costs that vary proportionately to sales), such as sales commissions.<\/p>\n<h4>Looking to the Past<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.5pt\">Forecasting sales is not always an easy task, as no one knows the future. We can, however, use the information we do have to forecast future sales with the greatest accuracy possible. Most firms start by looking at the past. A firm may look at past sales from a variety of prior periods. It\u2019s common to look at the past 12 months to estimate the coming 12 months. Looking at 12 consecutive months helps identify seasonality of sales trends, what time of year sales tend to drop off and when they increase, possible sales spikes that might reoccur, and any other trends that tend to appear over a 12-month period. In <a href=\"#_bookmark1336\">Figure 18.7<\/a>, we see Clear Lake\u2019s sales by month for the past 12 months.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Past data is often used in conjunction with probabilities and weighted average calculations derived from probabilities. Though used in several areas of forecasting, this approach is particularly common in drafting the sales forecast. Using multiple scenarios and the probability of each scenario occurring is a common approach to estimating future sales.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image8-16.png\" alt=\"image\" width=\"576.960104986877px\" height=\"99.2px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1336\"><\/a><strong>Figure 18.7<\/strong> <strong>Historical Sales <\/strong><strong>Data<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">We can see at first glance that sales remain fairly steady from January to April. Sales then goes up significantly in April and May, seem to peak in June, taper off a bit in July, then decline steeply from August to the end of the year, with the lowest sales being in November and December. Though not exact, it\u2019s easy to quickly see that sales follow a seasonal pattern. We will focus on just one year of data here to keep things simple. However, it\u2019s important to note that when a firm has a seasonal sales pattern, it normally uses more than one year of data to detect and evaluate the pattern. It\u2019s not uncommon for firms to have a seasonal sales pattern that fluctuates based on an external factor such as weather patterns, patterns in business or demand, or other<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">factors such as holidays. Common examples might include farm-based businesses that function on a weather pattern for harvesting and selling crops or a toy company that fluctuates around gift-giving holidays.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">This knowledge is helpful when assembling a first pass at the next year\u2019s sales forecast. Using common-size and horizontal (trend) analyses on sales is also helpful, as shown in <a href=\"#_bookmark1337\">Figure 18.8<\/a>. We can see the exact percentages that sales went up or down each month:<\/p>\n<ul>\n<li><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image9-5.png\" alt=\"image\" width=\"158.513385826772px\" height=\"30.656062992126px\" \/>In January, the company had sales of $9,000, which wasof the total annual sales.<\/li>\n<li>In June, the company had $19,000 sales, which wasof the total annual sales and <img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image10-32.png\" alt=\"image\" width=\"130.511286089239px\" height=\"12.6559580052493px\" \/> of January sales.<\/li>\n<\/ul>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image11-11.png\" alt=\"image\" width=\"576.959790026247px\" height=\"163.199895013123px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 160.75pt\"><a id=\"_bookmark1337\"><\/a><strong>Figure<\/strong> <strong>18.8<\/strong> <strong>Historical<\/strong> <strong>Sales<\/strong> <strong>Data<\/strong> <strong>as<\/strong> <strong>Percentages<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Once a baseline in the 12-month period is assessed, it can also be helpful to look for trends in other ways. For example, the past several years might be assessed to see if there is a trend in total growth or decline for those years on a summary basis or by period. Clear Lake Sporting Goods had sales in the current year of $126,000, in the prior year of $105,000, and two years ago of $89,000. This reflects a 20% increase and an 18% increase, respectively. It might be reasonable to expect a roughly 18 to 20% increase in total sales in the future with only this information in mind. Keep in mind that we will learn about many other factors to consider in the forecast, so the 18 to 20% increase is a good general guideline to consider along with other factors.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"265.2px\" \/>THINK IT THROUGHSales Forecast for Big 5 Sporting GoodsReview the 2020 annual report for Big 5 Sporting Goods (https:\/\/openstax.org\/r\/ 2020_annual_report_for_Big_5_Sporting_Goods). Locate the consolidated statements of operations on page F-7. Using the company\u2019s net sales figures for the current and prior years, what percentage might you recommend for their sales forecast for the next year?Solution:Big 5\u2019s sales for 2020 and 2019 were $1,041,212,000 and $996,495,000, respectively. This represents a 4.5% growth from the prior year. Forecasted sales, based solely on this information, might be appropriate at 4.5% growth for the next year, keeping in mind that many other factors should also be considered along with this information. Historical sales are only one set of data to use as a starting point.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Looking at <a href=\"#_bookmark1339\">Figure 18.9<\/a>, assume that Clear Lake Sporting Goods decides to take its first pass at a forecast using the more conservative estimate of 18% total sales growth. The company could consider last year\u2019s sales of<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">$126,000 and increase them by 18% to arrive at total forecasted sales for next year of<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt;text-indent: 0.45pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image12-12.png\" alt=\"image\" width=\"162.431916010499px\" height=\"12.6559580052493px\" \/>. Next, to get the monthly sales, the company could use the same percent of the total for each month that it did for the previous year. For example, sales in January of last year were 7.1% of the full year\u2019s sales. To find the forecast for the next year, the company would take the forecasted sales of<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">$148,680 for the year and multiply that by 7.1% to get $10,620 for January. The process is repeated for each<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">month to get the full year.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image13-5.png\" alt=\"image\" width=\"576.959790026247px\" height=\"163.199895013123px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1339\"><\/a><strong>Figure<\/strong> <strong>18.9<\/strong> <strong>Forecasted<\/strong> <strong>Sales<\/strong><strong> Data<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Keep in mind that this is only a starting point. These estimates will be reviewed, assessed, and updated as more information and other factors are taken into consideration.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">It can also be helpful to look at a shorter period, perhaps just the last few months, on a more detailed basis (by department, by customer, etc.) to see if there are any possible new trends beginning to develop that might be an indicator of performance in the coming year. For example, Clear Lake Sporting Goods might look at detailed sales records for October, November, and December and see that it had an old product line that was discontinued in early October, which contributed to a 2% reduction in monthly sales. This reduction in monthly sales will likely continue into the new year until the new line the company has signed on begins arriving in stores. Thus, the management team feels they should reduce their first quarter monthly estimates by 2%, as reflected in <a href=\"#_bookmark1340\">Figure 18.10<\/a>. January is now <img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image14-5.png\" alt=\"image\" width=\"141.533858267717px\" height=\"12.6559580052493px\" \/>, for example.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image15-22.png\" alt=\"image\" width=\"576.960209973753px\" height=\"88px\" \/><\/p>\n<h4><a id=\"_bookmark1340\"><\/a>Changes for the Future<\/h4>\n<p class=\"import-Normal\" style=\"margin-left: 17pt\"><br style=\"clear: both\" \/><strong>Figure<\/strong> <strong>18.10<\/strong> <strong>Adjusted<\/strong> <strong>Forecasted<\/strong> <strong>Sales<\/strong> <strong>Data<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">It\u2019s important to note that the past is not always a reliable predictor of the future. Circumstances can often change to make the future quite different from the past. The business itself may change, the economy can change, the customer base may undergo a shift in demographics or a change in buying habits, new competition may emerge, and so on. So while past performance is helpful, it is only one step in the process of forecasting sales.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"158.4px\" \/>LINK TO LEARNINGBig 5 Sporting Goods MD&amp;A ReportReview the most recent annual report for Big 5 Sporting Goods (https:\/\/openstax.org\/r\/ annual_report_for_Big_5_Sporting_Goods). Review the management\u2019s discussion and analysis (MD&amp;A) report (Item 7). What information does the report share about the firm, the economy, and other factors that might be useful for forecasting sales growth for next year?<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Most firms first look to the past to target some form of baseline estimate for the coming year; then, managers begin making adjustments based on what they know about the future. Assume that Clear Lake Sporting Goods will be adding a new brand to its collection of fishing supplies in March. The manufacturer plans to begin running its commercials in late February, which managers anticipate will increase Clear Lake\u2019s monthly sales<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">by about $500 in March, $1,000 in April, $1,400 in May, and $2,000 per month in June, July, and August. We see the monthly adjustments to Clear Lake\u2019s latest sales forecast in <a href=\"#_bookmark1341\">Figure 18.11<\/a>. March, for example, is now<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">$10,908 ($10,408 prior estimate plus $500 increase from new brand).<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image16-7.png\" alt=\"image\" width=\"576.640209973753px\" height=\"88px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 154.35pt\"><a id=\"_bookmark1341\"><\/a><strong>Figure<\/strong> <strong>18.11<\/strong> <strong>Forecasted<\/strong> <strong>Sales<\/strong> <strong>Data<\/strong> <strong>with<\/strong> <strong>New<\/strong> <strong>Brand<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 46.25pt\">What we have discussed here are only some brief examples of the myriad factors that might impact a sales budget for the coming year. It\u2019s critical that all members of the team take the time and effort to research their customers and the factors that impact their business in order to effectively assess the impact of these factors on future sales. Though only two adjustments were made here, it\u2019s likely that a large firm would have to consider many, many factors that would ultimately impact monthly sales figures before arriving at a conclusion.<\/p>\n<h3><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.6px\" \/>18.3<br \/>\n<a id=\"_bookmark1342\"><\/a>Pro Forma Financials<\/h3>\n<h4>Learning Outcomes<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\n<ul>\n<li>Define pro forma in the context of a financial forecast.<\/li>\n<li>Describe the factors that impact the length of a financial forecast.<\/li>\n<li>Explain the risks associated with a financial forecast.<\/li>\n<\/ul>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 46.1pt\">In this section of the chapter, we will move beyond the sales forecast and look at the general nature, length, and timeline of forecasts and the risks associated with using them. We\u2019ll look at why we use them, how long they generally are, what the key variables in a forecast are, and how we pair those variables with common-size analysis to develop the forecast.<\/p>\n<h4>Purpose of a Forecast<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 42.5pt\">As mentioned earlier in the chapter, forecasts serve different purposes depending on who is using them. Our <a id=\"_bookmark1343\"><\/a>focus here, however, is the world of finance. In this realm, the key purpose of <strong>pro<\/strong> <strong>forma<\/strong> (future-looking) financial statements is to manage a firm\u2019s cash flow and assess the overall value that the firm is generating through future sales growth. Growing just for the sake of growing doesn\u2019t always yield favorable income for the firm. A larger top-line sales figure that results in lower net income doesn\u2019t make sense in the grand scheme of things. The same is true of profitable sales that don\u2019t generate enough cash flows at the right time. The firm may make a profit, but if it doesn\u2019t manage the timing of its cash flows, it could be forced to shut down if it can\u2019t cover the costs of payroll or keep the lights on. Forecasting helps assess both cash flow and the profitability of future growth. Managers can forecast cash flow using data from forecasted financial statements; this allows them to identify potential gaps in cash and plan ahead in order to either alter collection and payment policies or obtain funding to cover the gap in the timing of cash flows.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"140.4px\" \/>LINK TO LEARNINGPro Forma Financial StatementsReview the video Business Plan and Pro-Forma Financial Statements (https:\/\/openstax.org\/r\/ Business_Plan_and_Pro-Forma_Financial_Statements) to learn about the basics of pro forma financial statements and why they are helpful.<\/p>\n<h4>Length of a Forecast<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasts can generally be for any length of time. The length generally depends on the user\u2019s needs. A one- year forecast, broken down by month, is quite typical. A firm will often go through a formal budgeting process near the end of its calendar or fiscal year to project financial plans and goals for the coming year. Once that is done, a rolling financial forecast is then done monthly to adjust as time moves on, more information becomes available, and circumstances change.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">To be useful, the future forecast for financial planning purposes is almost always calculated as monthly increments rather than one total figure for the next 12 months. Breaking the data down by month allows finance managers to more clearly see fluctuations in cash flows in and out, identify potential gaps in cash flow, and plan ahead for their cash needs.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasts can also be done for several years into the future. In fact, they commonly are. However, once the firm is looking out beyond 12 months, it gets difficult to forecast items with a great degree of accuracy. Often, forecasts beyond a year will be completed only to quarterly or even annual figures rather than monthly.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasts that far into the future are often strategic in nature, made more to communicate future plans for the firm than for more detailed decision-making and cash flow planning.<\/p>\n<h4>Common-Size Financials<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">As we saw earlier in the chapter, common-size analysis involves using historical financial statements as a basis for future forecasts. Financial statements provide a great starting point for analysis, as we can see the relationships between sales and costs on the income statement and the relationships between total assets and line items on the balance sheet.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">For example, in <a href=\"#_bookmark1334\">Figure 18.6<\/a>, we saw that for the past two years, cost of goods sold has been 50% of sales. Thus, in the first draft of a forecast for Clear Lake, it\u2019s likely that managers would estimate cost of goods sold at 50% of their forecasted sales. We can begin to see why forecasting sales first is crucial and why doing so as accurately as possible is also important.<\/p>\n<h4>Select Variables to Use<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 45.3pt\">A simple way to begin a full financial statement forecast might be to simply use the common-size statements and forecast every item using historical percentages. It\u2019s a logical way to begin a very rough draft of the forecast. However, several variables should be taken into consideration. First, managers must address the cost of an account and determine if it\u2019s a variable or fixed item. Variable costs tend to vary directly and proportionally with production or sales volume. Common examples include direct labor and direct materials. Fixed costs, on the other hand, do not change when production or sales volume increases or decreases within the relevant range. Granted, if production were to increase or decrease by a large amount, fixed costs would indeed change. However, in normal month-to-month changes, fixed costs often remain the same. Common examples of fixed costs include rent and managerial salaries.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">So, if we were to approach our common-size income statement, for example, we would likely use the percentage of sales as a starting point to forecast variable items such as cost of goods sold. However, fixed costs may not be accurately forecast as a percentage of sales because they won\u2019t actually change with sales. Thus, we would likely look at the history of the dollar values of fixed costs in order to forecast them.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"122.4px\" \/>CONCEPTS IN PRACTICECOVID-19 Makes Forecasting Difficult for Big 5 Sporting GoodsBig 5 Sporting Goods announced record earnings in the third quarter of 2020, attributing its huge success that quarter to the impact of people\u2019s reactions to the COVID-19 pandemic. With so many people in<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"624px\" height=\"177.599895013123px\" \/>quarantine still wanting to make healthy lifestyle choices, sporting goods stores were making record sales. Record-breaking sales, however, are not certain in the future. The impacts of the pandemic are extremely difficult to predict, making it a challenge for Big 5 Sporting Goods and other companies to assemble pro forma financial statements.(sources: https:\/\/www.globenewswire.com\/news-release\/2020\/10\/27\/2115470\/0\/en\/Big-5-Sporting-Goods- Corporation-Announces-Record-Fiscal-2020-Third-Quarter-Results.html; https:\/\/finance.yahoo.com\/news\/ investors-want-big-5-sporting-054658521.html; https:\/\/www.cpapracticeadvisor.com\/accounting-audit\/ news\/21206691\/four-ways-covid19-will-impact-2021-financial-forecasting-and-planning)<\/p>\n<h4>Determine Potential Changes in Variables<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">So far, we have focused on using historical common-size statements to create a draft (not a final version) of the forecast. This is because the past isn\u2019t always a perfect indicator of the future, and our finances don\u2019t always follow a linear pattern. We use the past as a good starting point; then, we must assess what else we know to fine-tune and make adjustments to the forecast.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 25.25pt\">Many items impact the forecast, and they will vary from one organization to another. The key is to do research, gather data, and look around at the market, the economy, the competition, and any other factors that have the potential to impact the future sales, costs, and financial health of the company. Though certainly not an exhaustive list, here are a few examples of items that may impact Clear Lake Sporting Goods.<\/p>\n<ul>\n<li>It has an old product line that was discontinued in early October, contributing to a 2% reduction in monthly sales that will likely continue into the new year until a new line begins arriving in stores.<\/li>\n<li>It will be adding a new brand to its collection of fishing supplies in March. The manufacturer plans to begin running commercials in late February. Managers anticipate that this will increase Clear Lake\u2019s monthly sales by about $500 in March, $1,000 in April, $1,400 in May, and $2,000 per month in June, July, and August.<\/li>\n<li>The company has just finished updating its employee compensation package. It goes into effect in January of the new year and will result in an overall 4% increase in the cost of labor.<\/li>\n<li>The landlord indicated that rent will increase by $50 per month starting July 1.<\/li>\n<li>Some fixed assets will be fully depreciated by the end of March. Thus, depreciation expense will go down by $25 per month beginning in April.<\/li>\n<li>There are rumors of new regulations that will impact the costs of importing some of the more difficult-to- obtain hunting supplies. Managers aren\u2019t entirely sure of the full impact of the new legislation at this time, but they anticipate that it could increase cost of goods sold for the affected product line when the new legislation goes into effect in the last quarter. Their best estimate is that it could increase the overall cost of goods sold by up to 2%.<\/li>\n<\/ul>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">We will use all of this data later in the chapter when we are ready to compile a complete forecast for Clear Lake.<\/p>\n<h3><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.4<br \/>\n<a id=\"_bookmark1345\"><\/a>Generating the Complete Forecast<\/h3>\n<h4>Learning Outcomes<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\n<ul>\n<li>Generate a forecasted income statement that incorporates pertinent sales, functional, and policy variables.<\/li>\n<li>Generate a forecasted balance sheet.<\/li>\n<li>Connect the balance sheet and income statement forecasts with appropriate feedback linkages.<\/li>\n<\/ul>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">In this section of the chapter, we will tie together what we have learned so far about forecasting sales,<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">common-size analysis, and using what we know about the company and its environment to create a full set of pro forma (forward-looking or forecasted) financial statements.<\/p>\n<h4>Forecast the Income Statement<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">To arrive at a fully forecasted income statement, we use historical income statements, common-size income statements, and any additional information we have about future sales and costs, such as the effects of the economy and competition. As we saw earlier in the chapter, we begin with forecasted sales because they are the basis for many of the forecasted costs.<\/p>\n<p class=\"import-BodyText\" style=\"text-align: justify;margin-left: 17pt;margin-right: 51.6pt\">Let\u2019s begin with the sales forecast for Clear Lake Sporting Goods that we saw earlier in the chapter, in <a href=\"#_bookmark1339\">Figure<\/a> <a href=\"#_bookmark1339\">18.9<\/a>, and use it along with the prior year income statement by month shown in <a href=\"#_bookmark1346\">Figure 18.12<\/a>. We will consider other data we have about the business to begin creating a full income statement (see <a href=\"#_bookmark1347\">Figure 18.13<\/a>).<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image17-6.png\" alt=\"image\" width=\"576.64px\" height=\"278.08px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 136.45pt\"><a id=\"_bookmark1346\"><\/a><strong>Figure<\/strong> <strong>18.12<\/strong> <strong>Prior<\/strong> <strong>Year<\/strong> <strong>Monthly<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong> <strong>by<\/strong> <strong>Month<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">The first two key points regarding product lines have already been built into the sales forecast. Notice that the cost of goods sold was 50% in the prior year. However, based on possible future legislation, to be conservative, we should increase the cost of goods sold by 2% in the last quarter of the year. Thus, we will forecast cost of goods sold at 50% of sales in the first nine months and increase it to 52% in the last three months of the year.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Rent is a fixed cost that historically amounts to $458 per month. However, we know that the landlord is increasing rent by $50 starting on July 1. Thus, we will forecast rent at the same fixed cost of $458 per month for the first six months and increase it to $508 per month for the second half of the year.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Depreciation, also a fixed cost, was historically $300 per month. However, we know that depreciation expense will go down by $25 beginning in April. Thus, we forecast depreciation at $300 for the first three months and at<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">$275 for the last 9 months.<\/p>\n<p class=\"import-BodyText\" style=\"text-align: justify;margin-left: 17pt;margin-right: 43.1pt\">Salaries expense has historically been $450 per month. However, we know that the company is implementing a new compensation program on January 1 that will increase salaries expense by 4% ($18). Thus, we will forecast salaries for the whole year at $468.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Utilities expense seems to vary somewhat by sales from month to month, as shops are open longer hours during their busy season. However, the total utilities expense is not expected to change for the coming year. Thus, the forecast for utilities expense remains at $2,500, broken down by month as a percentage of sales.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Interest expense is a fixed cost and isn\u2019t anticipated to change. Thus, the same $167 interest expense per month is forecast for the coming year.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Finally, income tax expense is forecasted as a percentage of operating income because tax liability is incurred as a direct result of operating income. <a href=\"#_bookmark1347\">Figure 18.13<\/a> shows the next 12 months\u2019 forecast for Clear Lake Sporting Goods using all of this data.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image18-3.png\" alt=\"image\" width=\"576.64px\" height=\"266.879895013123px\" \/><\/p>\n<h4><a id=\"_bookmark1347\"><\/a>Forecast the Balance Sheet<\/h4>\n<p class=\"import-Normal\" style=\"margin-left: 5.55pt\"><br style=\"clear: both\" \/><strong>Figure<\/strong> <strong>18.13<\/strong> <strong>Forecasted<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Now that we have a reasonable income statement forecast, we can move on to the balance sheet. The balance sheet, however, is entirely different from the income statement. It requires a bit more research and additional assumptions. Just like the income statement, it\u2019s often a work in progress. A first draft is a good starting point, but adjustments must be made once it is created, and all the interrelationships between the statements, cash flow in particular, are taken into consideration.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">The balance sheet is a bit more difficult to forecast because the statement reflects balances at just a given point in time. Account balances change daily, so forecasting just one snapshot in time for each month can be a challenge. A good starting point is to assess general company financial policies or rules of thumb. For example, assume that Clear Lake pays most of its vendors on net 30-day terms. A good way to forecast accounts payable on the balance sheet might be to add up the cost of goods sold from the forecasted income statement for the prior month. For example, in <a href=\"#_bookmark1348\">Figure 18.14<\/a>, we see that Clear Lake has forecasted its accounts payable for March as the cost of goods sold in March from its forecasted income statement.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 45.7pt\">For accounts receivable, Clear Lake generally receives payment from customers within net 90-day terms. Thus, it uses the sum of the current and prior two months\u2019 forecasted sales to estimate its accounts receivable balance.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Inventory will vary throughout the year. For the first six months, the company tries to build inventory for four months of sales. Once the busy season hits, inventory goes down to three months\u2019 worth of future sales, then finally drops to only two months of sales in December. Thus, managers use their sales forecast by month to estimate their inventory ending balance each month.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">The equipment balance is forecasted by reducing the prior month\u2019s balance by the forecasted depreciation expense on the forecasted income statement.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Unearned revenue is historically around 50% of the current month\u2019s sales. Thus, Clear Lake estimates its unearned revenue balance each month by taking the current month\u2019s net sales from the forecasted income statement and multiplying it by 50%.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Short-term investments, notes payable, and common stock are not anticipated to change, so the current balance is forecasted to remain the same for the next 12 months.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">To forecast the ending balance for retained earnings for each month, managers add the monthly net income from the forecasted balance sheet to the prior balance and subtract a quarterly $10,000 dividend.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 46.1pt\">Once all of these accounts are completed, the balance sheet is out of balance. Given that all of these events are somewhat related but are not tied together dollar for dollar, it\u2019s not surprising when the forecasted balance sheet is finished and does not balance. To complete the first draft (see <a href=\"#_bookmark1348\">Figure 18.14<\/a>), the cash account is used as a variable and plugged in to make the balance sheet balance. Notice that by the end of the year, the company has $59,905 in cash. However, look at what happens midyear\u2014the cash account falls to only $8,782. In the next section, we will generate a cash flow forecast, which will allow Clear Lake to update its balance sheet forecast once it estimates what it will do to cover the cash flow gaps.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image19-9.png\" alt=\"image\" width=\"576.639895013123px\" height=\"344.64px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 167.75pt\"><a id=\"_bookmark1348\"><\/a><strong>Figure<\/strong> <strong>18.14<\/strong> <strong>Forecasted<\/strong> <strong>Balance<\/strong> <strong>Sheet<\/strong> <strong>Draft<\/strong><\/p>\n<h4>Linkages between the Forecasted Balance Sheet and the Income Statement<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Notice that in the discussion in the prior section on the balance sheet forecast, a lot of the information in the forecasted income statement was used to generate the forecasted balance sheet. The balance sheet accounts generally depend on activity reported in the income statement. For example, for many firms, the balance in their accounts receivable account is tied to their sales. Looking at historical balances in the accounts receivable account and how those relate to historical sales will help determine how to use the forecasted future sales to estimate the future balance of accounts receivable.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">The same is true of accounts payable. Looking at past balances, past expenses (normally cost of goods sold), and the firm\u2019s payment terms for its vendors allows managers to use forecasted cost of goods sold or other expenses to estimate the balance in the accounts payable account.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">We learned in <a href=\"#_bookmark361\">Financial Statements<\/a> that net income flows into retained earnings. Thus, the net income from the forecasted income statement can be used to help estimate the ending balance in retained earnings. If the firm intends to issue any dividends in the coming year, managers should also estimate that reduction in their forecast.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">It\u2019s also common to find other general policies or procedures that help drive performance and aid in forecasting balances. For example, if the company has a goal of maintaining a certain level of inventory or a minimum balance in its cash account, that information can be used to guide the estimate for those accounts.<\/p>\n<h3><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.5<br \/>\n<a id=\"_bookmark1349\"><\/a>Forecasting Cash Flow and Assessing the Value of Growth<\/h3>\n<h4>Learning Outcomes<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\n<ul>\n<li>Generate a cash flow forecast.<\/li>\n<li>Assess a cash flow forecast to determine future cash funding needs.<\/li>\n<li>Use pro forma financial statements and cash flow forecasts to assess the value of growth to the firm.<\/li>\n<\/ul>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">In this section of the chapter, we will use the forecasted income statement, forecasted balance sheet, and other information we know about the firm\u2019s policies and goals for the coming year to generate and assess a cash flow forecast.<\/p>\n<h4>Create a Cash Flow Forecast<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">A cash flow forecast isn\u2019t overly complex, yet it is not easy to assemble because it requires making many <a id=\"_bookmark1350\"><\/a>assumptions about the future. A <strong>cash forecast <\/strong>begins with the beginning cash balance, adds anticipated cash inflows, and deducts anticipated cash outflows. This identifies cash surpluses and shortages.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">For Clear Lake Sporting Goods, for example, we see in <a href=\"#_bookmark1351\">Figure 18.15<\/a> that the company begins with cash of<\/p>\n<p class=\"import-BodyText\" style=\"text-align: justify;margin-left: 17pt;margin-right: 51.95pt\">$42,581,000 in January of the new year. Next, it lists the cash inflows, or cash received from customers. Given the assumption that customers pay in 90-day terms, the cash flow is filled in by plugging in the sales forecast for the three prior months. For example, the cash flow from customers of $10,508 for June is the same as the net sales forecast for March (see <a href=\"#_bookmark1347\">Figure 18.13<\/a>).<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image20-12.png\" alt=\"image\" width=\"576.639895013123px\" height=\"143.68px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.4pt\"><a id=\"_bookmark1351\"><\/a><strong>Figure<\/strong> <strong>18.15<\/strong> <strong>Forecasted<\/strong> <strong>Cash<\/strong> <strong>Inflows<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Next, Clear Lake identifies cash outflows, which include accounts payable, salaries, rent, utilities, dividends, and interest payments. Accounts payable are normally paid within 30 days, so the forecast for cost of goods sold for the prior month is used as an estimate of amount paid for payables. For example, in <a href=\"#_bookmark1352\">Figure 18.16<\/a>, we see that the accounts payable settled in June of $8,610 is the cost of goods sold for May from the forecasted income statement.<\/p>\n<p class=\"import-BodyText\" style=\"text-align: justify;margin-left: 17pt;margin-right: 48.8pt\">Salaries are paid monthly and thus represent the same recurring monthly cash outflow, as does rent. Utilities, like accounts payable, are assumed to be paid within 30 days. Thus, the cash outflow for utilities is the utilities expense for the prior month from the forecasted income statement.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 65.05pt\">Management intends to pay a quarterly dividend of $10,000. Thus, in <a href=\"#_bookmark1352\">Figure 18.16<\/a>, we see $10,000 cash outflows forecasted for March, June, September, and December. Interest on the long-term liability is paid quarterly. Thus, the $500 cash outflows in March, June, September, and December are simply the monthly interest expense of $167 from the income statement, summed for each quarter.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image21-5.png\" alt=\"image\" width=\"576.639790026247px\" height=\"233.28px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.4pt\"><a id=\"_bookmark1352\"><\/a><strong>Figure<\/strong> <strong>18.16<\/strong> <strong>Forecasted<\/strong> <strong>Cash<\/strong> <strong>Inflows<\/strong> <strong>and<\/strong> <strong>Outflows<\/strong><\/p>\n<h4>Using a Cash Forecast to Determine Additional Funds Needed<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Finally, at the end of the cash flow forecast, cash outflows are subtracted from the cash inflows. This identifies <a id=\"_bookmark1353\"><\/a>whether a <strong>cash surplus <\/strong>(extra) or <strong>cash deficit <\/strong>(not enough) exists for each month. For example, in <a href=\"#_bookmark1354\">Figure<\/a> <a href=\"#_bookmark1354\">18.17<\/a>, we see that in March, Clear Lake is forecasting $4,800 of cash inflows and $17,800 of total cash outflows, which results in a cash deficit of $13,000.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Clear Lake has a general policy to not let its cash balance fall below $35,000. Thus, managers need to assess their monthly balances and potential deficits and identify months when financing is necessary. For example, the deficit of $13,000 in March is enough to push the cash balance lower than $35,000. Thus, it\u2019s estimated that the company will need $5,000 in short-term financing in March. It has an estimated surplus in April, so $3,000 of the borrowing is returned.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image22-17.png\" alt=\"image\" width=\"576.64px\" height=\"278.08px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.5pt\"><a id=\"_bookmark1354\"><\/a><strong>Figure<\/strong> <strong>18.17<\/strong> <strong>Forecasted<\/strong> <strong>Cash<\/strong> <strong>Surplus<\/strong> <strong>or<\/strong> <strong>Deficit<\/strong><\/p>\n<h4>Assessing the Value of Growth<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 52.75pt\">It\u2019s a fairly common assumption that most, if not all, businesses want to grow. While it certainly can be good as a firm to grow in size, growth just for the sake of growth isn\u2019t necessarily a good goal. A firm can grow in size based on customers, employees, locations, or simply sales. However, that doesn\u2019t mean that the growth will increase profits. Growth may increase profits, but this is not a safe assumption. Scaling up operations takes careful planning, which includes monitoring the profitability of the sales and, of course, the cash flow it<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 56.05pt\">would require. Growing a business can require more inventory, more locations, more equipment, and more manpower, all of which cost money. Even if the forecasted growth is profitable, it may pose problems from a cash flow perspective. It\u2019s important that the firm review not only its forecasted income statement and balance sheet but also its cash forecast, as this can reveal some serious gaps in funding depending on the extent, timing, and nature of the planned growth.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">For example, assume that Clear Lake Sporting Goods intends to run a large-scale ad campaign to boost sales in its busy season. Historically, the store relied primarily on its prime location for high volumes of retail foot traffic. Managers felt, however, that given the increase in competition, they could boost sales significantly by running the ad campaign in the first quarter. The campaign would cost $30,000. Forecasts already reflect a cash deficit at the end of the first quarter of $13,000, so the additional $30,000 ad campaign, which would require payment up front, would create a much larger need for funding. It\u2019s also important that managers look at the increased cost of doing business along with the increased cost in advertising to ensure that the move would be profitable. Fortunately, Excel or other forecasting software can be used to create a forecast <a id=\"_bookmark1355\"><\/a>with formulas that tie together, making <strong>scenario<\/strong> <strong>analysis<\/strong> such as this a much easier process.<\/p>\n<h4>Scenarios in Forecasting<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasting is almost never a linear process. In other words, we don\u2019t do one forecast and call it good. The first draft is completed using historical data, and then changes are made a bit at a time as all potential variables are assessed for their impact on the forecast. It\u2019s quite common to then use the work-in-progress forecast to complete scenario analysis. This is particularly true when the forecast is completed in Excel or other budgeting or forecasting software. Elements of the forecast can be changed to see what the overall impact would be to the firm. Assuming the forecast is set up using formulas in Excel or other software, a change to one figure or one variable would then \u201cripple\u201d through the forecast to reflect the overall impact.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 61.25pt\">Often, a firm may complete an initial forecast (scenario) under the assumption that the economy is in a \u201cnormal state.\u201d The firm can then alter the initial forecast for different scenarios, such as the economy in a recession or the economy in a state of expansion. This helps the firm understand different possible future states and highlights how changes in the economy such as inflation may cause revenue and expenses to increase.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Assume that Clear Lake\u2019s initial forecast is created under the assumption that the economy will remain average. Management also wants to know the worst-case scenario. What will their financial results look like if the economy were in a recession, for example? If management assumes their sales would drop to only 60% of the prior year sales in a recessionary economy, they could alter the formula in Excel driving their sales and variable costs, resulting in a new pro forma income statement. In <a href=\"#_bookmark1356\">Figure 18.18<\/a>, we can see that net income would drop to $16,391 under this assumption, compared to the net income of $47,653 forecasted under average economy assumptions in <a href=\"#_bookmark1347\">Figure 18.13<\/a>.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 33.9pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image23-6.png\" alt=\"image\" width=\"576.64px\" height=\"266.879895013123px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 162.6pt\"><a id=\"_bookmark1356\"><\/a><strong>Figure<\/strong> <strong>18.18<\/strong> <strong>Forecasted<\/strong> <strong>Cash<\/strong> <strong>Surplus<\/strong> <strong>or<\/strong> <strong>Deficit<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 44.6pt\"><a id=\"_bookmark1357\"><\/a>Though creating a full forecast in Excel can be a bit complex, it is a powerful tool that is useful for analysis. Elements can be used to vary just about anything, from something small such as a 1% increase in the cost of a product to a company-wide increase in salaries, the introduction of an entire new product line, or the purchase of a new production machine, among other possibilities.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.25pt\">For example, assume that Clear Lake has completed a first pass at its forecast and is reviewing the forecasted profit for the next 12 months. Managers feel the profit is currently low, as they always want to target a certain percentage. They might tinker with variables in the forecast file to see the impact on profits of potential changes they are considering. They may reduce the new salaries package by a percentage point to see if it gets them closer to their goal. They may adjust cost of goods sold by a certain percentage if they feel they can negotiate with vendors to work down their costs. They may adjust rent and see if they can find a better retail location to either reduce costs or increase sales due to increased foot traffic in a new location. They may save an entirely new version of the forecast and change it drastically to see what investing in opening a second retail location would do.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">As you can see, the list of possibilities is endless. Though the main goal of financial managers may be cash planning, the power of a well-developed forecast is tremendous. It can help assess potential growth, new opportunities, and even small changes in the business as well.<\/p>\n<h4>Sensitivity Analysis in Forecasting<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 50.35pt\"><a id=\"_bookmark1358\"><\/a><strong>Sensitivity analysis <\/strong>will often look at the change in just one variable rather than the entire scenario. It examines how sensitive a particular output (commonly net income) will be to a change in a particular underlying input (sales or costs, for example). What if sales are 10% more or less than forecasted? What if the prices the firm can charge its customers are 10% more or less? What if the cost of goods sold increases by 10%? The purpose is to see which variables are crucial to \u201cget right.\u201d It isn\u2019t worth spending a lot of research dollars to make sure you are accurately predicting a variable if that variable won\u2019t notably change the outcome. However, a slight change in other variables may have significant impact.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Using pro forma financial statements created in Excel allows management to quickly generate new pro forma financials and see the impact that each possible variable might have on the overall financial results.<\/p>\n<h3><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"44.6px\" height=\"31.7333333333333px\" \/>18.6<br \/>\n<a id=\"_bookmark1359\"><\/a>Using Excel to Create the Long-Term Forecast<\/h3>\n<h4>Learning Outcomes<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">By the end of this section, you will be able to:<\/p>\n<ul>\n<li>Generate a financial statement forecast using spreadsheet tools.<\/li>\n<li>Connect the balance sheet and income statement using appropriate formula referencing.<\/li>\n<li>Use spreadsheet functions to generate appropriate iterations that balance financial forecasts.<\/li>\n<\/ul>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Throughout this chapter, we have seen forecasted financial statements for Clear Lake Sporting Goods along with its forecasted cash flow. These statements could all have been generated by hand, of course, but that wouldn\u2019t be an effective use of time. As mentioned in prior sections, several different types of software can be quite effective in making the forecasting process faster and more flexible. In this section, we will review just one common option, Microsoft Excel.<\/p>\n<p class=\"import-Normal\" style=\"margin-left: 44pt;margin-right: 58.95pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image24-6.png\" alt=\"image\" width=\"30.8px\" height=\"37.6px\" \/><br \/>\n<em>Download<\/em> <em>the<\/em> <a class=\"rId90\" href=\"https:\/\/openstax.org\/r\/spreadsheet_file\"><em>spreadsheet<\/em> <em>file<\/em> <em>(https:\/\/openstax.org\/r\/spreadsheet_file)<\/em><\/a> <em>containing<\/em> <em>key<\/em> <em>Chapter<\/em> <em>18 <\/em><em>Excel<\/em> <em>exhibits.<\/em><\/p>\n<p class=\"import-BodyText\">\n<h4>Using the \u201cSheet\u201d<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Creating a budget in Excel can be very simple or extremely complex, depending on the size and complexity of the business and the number of formulas and dependencies that are written into the Excel workbook.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Creating the forecast in Excel follows the same steps and flow we just explored in this chapter but with the power of a software program to do the math for you. We begin with the sales forecast, which uses several key formulas in Excel.<\/p>\n<ul>\n<li>First, sales are projected to be 18% higher than the prior year. Thus, a total projection for the year is calculated using a simple link and multiplication function tied to last year\u2019s total sales. In <a href=\"#_bookmark1360\">Figure 18.19<\/a>, you can see the formula in cell O4 is \u201c=&#8217;Figure 18.12&#8242;!N4*1.18\u201d. This formula simply does the math to increase the prior year\u2019s sales by 18%.<\/li>\n<li><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image26-4.png\" alt=\"image\" width=\"576px\" height=\"153.599895013123px\" \/>Next, the sales are distributed by month. In <a href=\"#_bookmark1360\">Figure 18.19<\/a>, we see in cell B5 that the forecasted income statement sheet is linked to the percent of annual sales from the Prior Year Income Statement (<a href=\"#_bookmark1346\">Figure<\/a> <a href=\"#_bookmark1346\">18.12<\/a>) sheet. Then, in cell B4, January sales are estimated with a formula that multiplies the total forecasted sales in O4 by the percent of annual sales for January of the prior year. Notice that the formula then multiplies that product by 0.98. This is because Clear Lake discontinued a product line in the last quarter of the prior year, and management feels that this will reduce sales in the first quarter of the new year by roughly 2%.<\/li>\n<\/ul>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 27.4pt\"><a id=\"_bookmark1360\"><\/a><strong>Figure<\/strong> <strong>18.19<\/strong> <strong>Forecasted Sales Formulas<\/strong> <strong>in <\/strong><strong>Excel<\/strong><\/p>\n<ul>\n<li>As Clear Lake continues to fill out its forecasted income statement, the next formula we see is a simple sum formula to calculate net sales in B8 (see <a href=\"#_bookmark1361\">Figure 18.20<\/a>). It\u2019s a simple formula that subtracts sales returns and allowances in B7 from gross sales in B4. Similar formulas are also found in B10 for gross margin and B18 for net income.<\/li>\n<li>In cell B9, we see a multiplication formula that multiplies sales from B4 by 0.5, or 50%. This is because<\/li>\n<\/ul>\n<p class=\"import-BodyText\" style=\"margin-left: 35pt;margin-right: 43.15pt\">management feels that cost of goods sold will remain the same as last year, in most quarters at least, and last year\u2019s percentage was 50%.<\/p>\n<ul>\n<li>Rent, depreciation, and salaries are all simply typed in, as they are fixed expenses that remain the same as last year.<\/li>\n<li>The utilities calculation, found in cell B14, is somewhat similar to the sales calculation. The total utilities expense from O14 is multiplied by the current month\u2019s sales in B4 divided by the total annual sales in O4. This spreads out the utility cost by month based on the percentage of annual sales.<\/li>\n<\/ul>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image27-7.png\" alt=\"image\" width=\"412px\" height=\"537px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 151.6pt\"><a id=\"_bookmark1361\"><\/a><strong>Figure<\/strong> <strong>18.20<\/strong> <strong>Forecasted<\/strong> <strong>Income<\/strong> <strong>Statement<\/strong> <strong>Formulas<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 46.55pt\">Clear Lake\u2019s forecasted balance sheet ties very closely to both the forecasted income statement and the prior year\u2019s income statement. In <a href=\"#_bookmark1362\">Figure 18.21<\/a>, we see in C7 an addition formula using the sum of the current month and three months of prior sales as an estimate of the ending accounts receivable balance. The formula for inventory is similar but forward looking. In C8, inventory is estimated by adding the cost of goods sold for the current month and next three months from the forecasted income statement.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Total current assets in C10 is calculated with a SUM formula that adds together the values in all the selected cells. Amounts such as short-term investments and common stock that are not anticipated to change are simply typed as a number in the cell. Much like in the income statement, subtotals are found in C13 for total assets, C17 for current liabilities, C24 for total equity, and C25 for total liabilities and equity. Retained earnings in C23 pulls the ending retained earnings balance from the end of last year (hidden in column B) and adds the<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\">net income for January in the forecasted income statement to get the current month\u2019s ending balance.<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image28-7.png\" alt=\"image\" width=\"573.8px\" height=\"579.12px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 160.05pt\"><a id=\"_bookmark1362\"><\/a><strong>Figure<\/strong> <strong>18.21<\/strong> <strong>Forecasted<\/strong> <strong>Balance<\/strong> <strong>Sheet<\/strong> <strong>Formulas<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 47.65pt\">Much like the balance sheet, the cash forecast also relies heavily on data from the forecasted income statement as well as the forecasted balance sheet. To begin the year, in <a href=\"#_bookmark1363\">Figure 18.22<\/a>, we see that the formula in B4 pulls the cash balance from the forecasted balance sheet. In B6, the formula pulls the sales for the three months prior from the previous year\u2019s income statement. This is because it\u2019s assumed that cash is collected from customers 90 days after the sale. The same approach is used for accounts payable, rent, salaries, and utilities. The formulas pull the expenses from a prior month depending on the assumed timing for payment. Utilities, for example, are assumed to be paid within 30 days, so the cash outflow in February is assumed to be the utilities expense for January from the forecasted income statement. Note that interest payments are assumed to be zero in January and February, but in March, the formula in D14 sums the interest expenses on the forecasted income statement for January, February, and March. This is because interest is paid quarterly.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Finally, note the formula in C4. The beginning cash balance for a given month is the same as the ending cash balance from the prior month; thus, the figure in B18 is linked to C4 to start the new month.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 34.3pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image29-9.png\" alt=\"image\" width=\"579.599895013123px\" height=\"581.4px\" \/><\/p>\n<p class=\"import-Normal\" style=\"text-align: center;margin-left: 17.2pt;margin-right: 45.45pt\"><a id=\"_bookmark1363\"><\/a><strong>Figure<\/strong> <strong>18.22<\/strong> <strong>Cash<\/strong> <strong>Forecast<\/strong> <strong>Formulas<\/strong><\/p>\n<h4>Using Excel Functions to Balance<\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Once we get a draft of the forecasts outlined, then the tinkering starts. Additional information can be used to adjust the formulas, as we saw with the 2% reduction in January sales for the forecasted income statement. Because we have linked most (though not all) of our expenses, subtotals, and statements together using formulas, management can also use the forecast workbook to perform scenario and sensitivity analyses, essentially asking \u201cwhat if?\u201d and looking at the results. When completed, however, before finalizing the forecast, it\u2019s important that the financial statements are in balance (particularly the <em>balance<\/em> <em>sheet<\/em>, just as the name implies).<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Notice that throughout, we used formulas to calculate subtotals to ensure they are correct and change as needed. We also linked figures, such as the ending and beginning cash balances, to ensure they are in balance. Perhaps the easiest but most important thing to do is to ensure that the balance sheet balances. We can do this with a simple formula that compares total assets to total liabilities and equity. We can see in <a href=\"#_bookmark1364\">Figure 18.23<\/a> that subtracting one from the other in cell C27 should result in $0. If there is a difference, the formula will highlight it, forcing us to investigate and correct the sheet so that it balances.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 87.5pt\"><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image30-7.png\" alt=\"image\" width=\"436px\" height=\"611px\" \/><\/p>\n<p class=\"import-Normal\" style=\"margin-left: 169.7pt\"><a id=\"_bookmark1364\"><\/a><strong>Figure<\/strong> <strong>18.23<\/strong> <strong>Forecasted<\/strong> <strong>Balancing<\/strong> <strong>Formula<\/strong><\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"48px\" height=\"1056px\" \/><\/p>\n<p class=\"import-BodyText\">\n<h3><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image31-5.png\" alt=\"image\" width=\"22.2739107611549px\" height=\"25.1998950131234px\" \/> <a id=\"_bookmark1365\"><\/a>Summary<\/h3>\n<h4><a href=\"#_bookmark1322\">Th<\/a><a href=\"#_bookmark1322\">e Importance of Forecasting<\/a><\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Forecasting financial statements is important to different users for different reasons. In finance, it\u2019s most important for assessing the value of future growth plans and planning for future cash flow needs.<\/p>\n<h4><a href=\"#_bookmark1335\">For<\/a><a href=\"#_bookmark1335\">ecasting Sales<\/a><\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">The sales forecast is the foundation on which much of the rest of the forecast is built. Thus, the sales forecast is completed first. Historical sales data and any other information on the firm, its products, the economy, its customers, and its competitors are all used to create the most accurate sales forecast possible.<\/p>\n<h4><a href=\"#_bookmark1342\">Pr<\/a><a href=\"#_bookmark1342\">o Forma Financials<\/a><\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Pro forma financial statements are forward looking in nature. They use the sales forecast, historical data, financial statement analyses, relationships between accounts and statements, and any other information known about the firm, the environment, and the future to create the most accurate financial statement forecast possible.<\/p>\n<h4><a href=\"#_bookmark1345\">Gener<\/a><a href=\"#_bookmark1345\">ating the Complete Forecast<\/a><\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 48.8pt\">Interrelationships among historical data, the forecasted income statement, and the forecasted balance sheet are all used to estimate each line item in the financial statements.<\/p>\n<h4><a href=\"#_bookmark1349\">For<\/a><a href=\"#_bookmark1349\">ecasting Cash Flow and Assessing the Value of Growth<\/a><\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Once the income statement and balance sheet forecasts are complete, data from those statements, information on company policies, and account relationships are used to generate a cash forecast. The cash forecast is important for identifying any gaps in cash flow so that financial managers can plan for cash needs. It\u2019s also important to review not only the cash forecast but all forecasted financial statements to assess the overall impact and value of proposed firm growth.<\/p>\n<h4><a href=\"#_bookmark1359\">Usin<\/a><a href=\"#_bookmark1359\">g Excel to Create the Long-Term Forecast<\/a><\/h4>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt;margin-right: 43.15pt\">Excel can be a powerful tool for creating financial forecasts. Formulas that complete mathematical functions and tie accounts and financial statements together are used to create the statements, ensure that they balance, and facilitate scenario and sensitivity analyses.<\/p>\n<h3><img decoding=\"async\" src=\"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-content\/uploads\/sites\/149\/2023\/08\/image32-4.png\" alt=\"image\" width=\"22.2739107611549px\" height=\"25.1998950131234px\" \/> <a id=\"_bookmark1366\"><\/a>Key Terms<\/h3>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.15pt;text-indent: 12pt\"><strong>balance<\/strong> <strong>sheet<\/strong> a financial statement that reflects a firm\u2019s asset, liability, and equity account balances at a given point in time<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><strong>cash<\/strong> <strong>deficit<\/strong> an excess of cash outflows over cash inflows for a given period<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><strong>cash<\/strong> <strong>forecast<\/strong> a financial statement that estimates a firm\u2019s future cash inflows and outflows<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><strong>cash<\/strong> <strong>surplus<\/strong> an excess of cash inflows over cash outflows for a given period<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.15pt;text-indent: 12pt\"><strong>common-size<\/strong> describes a financial statement in which each element is expressed as a percentage of a base amount<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 48.8pt;text-indent: 12pt\"><strong>financing<\/strong> <strong>activities<\/strong> cash business transactions reported on the statement of cash flows that reflect the use of financed funds<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 89pt;text-indent: 12pt\"><strong>forecast<\/strong> an estimate of future performance based on historical performance and other contextual information<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.7pt;text-indent: 12pt\"><strong>income<\/strong> <strong>statement<\/strong> a financial statement that measures a firm\u2019s financial performance over a given period of time<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.15pt;text-indent: 12pt\"><strong>investing<\/strong> <strong>activities<\/strong> cash business transactions reported on the statement of cash flows that reflect the acquisition or disposal of long-term assets<\/p>\n<p class=\"import-BodyText\"><img decoding=\"async\" src=\"#fixme\" alt=\"image\" width=\"48px\" height=\"1056px\" \/><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 43.15pt;text-indent: 12pt\"><strong>operating<\/strong> <strong>activities<\/strong> cash business transactions reported on the statement of cash flows that relate to ongoing day-to-day operations<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 17pt\"><strong>pro<\/strong> <strong>forma<\/strong> in the context of financial statements, forward-looking<\/p>\n<p class=\"import-Normal\" style=\"margin-left: 17pt;margin-right: 48.8pt\"><strong>scenario<\/strong> <strong>analysis<\/strong> analysis of how various situations and circumstances would impact the financial forecast <strong>sensitivity analysis<\/strong> analysis of the sensitivity of an output variable to a change in an input variable <strong>statement of cash flows<\/strong> a financial statement that lists a firm\u2019s cash inflows and outflows over a given<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt\">period of time<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 29pt;margin-right: 46.1pt;text-indent: 12pt\"><strong>statement<\/strong> <strong>of<\/strong> <strong>stockholders\u2019<\/strong> <strong>equity<\/strong> a financial statement that reports the difference between the beginning and ending balances of each of the stockholders\u2019 equity accounts during a given period<\/p>\n<p class=\"import-Normal\">\n<\/div>\n","protected":false},"author":107,"menu_order":5,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-2021","chapter","type-chapter","status-publish","hentry"],"part":3,"_links":{"self":[{"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/pressbooks\/v2\/chapters\/2021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/wp\/v2\/users\/107"}],"version-history":[{"count":1,"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/pressbooks\/v2\/chapters\/2021\/revisions"}],"predecessor-version":[{"id":2022,"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/pressbooks\/v2\/chapters\/2021\/revisions\/2022"}],"part":[{"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/pressbooks\/v2\/parts\/3"}],"metadata":[{"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/pressbooks\/v2\/chapters\/2021\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/wp\/v2\/media?parent=2021"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/pressbooks\/v2\/chapter-type?post=2021"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/wp\/v2\/contributor?post=2021"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.ccconline.org\/accfinance\/wp-json\/wp\/v2\/license?post=2021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}