# TAILIEUCHUNG - Financial Analysis With Microsoft Excel-Mayes, Shank - Chapter 5

## CHAPTER 5 Financial Forecasting Explain how the “percent of sales” method is used to develop pro-forma financial statements, and how to construct such statements in Excel. Use the TREND function for forecasting sales or any other trending variables. | 5 Financial Forecasting After studying this chapter you should be able to 1. Explain how the percent of sales method is used to develop pro-forma financial statements and how to construct such statements in Excel. 2. Use the Trend function for forecasting sales or any other trending variables. 3. Perform a regression analysis with Excel s built-in regression tools. Forecasting is an important activity for a wide variety of business people. Nearly all of the decisions made by financial managers are made on the basis of forecasts of one kind or another. For example in Chapter 3 we ve seen how the cash budget can be used to forecast short-term borrowing and investing needs. Every item in the cash budget is itself a forecast. In this chapter we will examine several methods of forecasting. The first the percent of sales method is the simplest. We will also look at more advanced techniques such as regression analysis. 139 140 Financial Forecasting The Percent of Sales Method Forecasting financial statements is important for a number of reasons. Among these reasons are planning for the future and providing information to the company s investors. The simplest method of forecasting income statements and balance sheets is the percent of sales method. This method has the added advantage of requiring relatively little data to make a forecast. The fundamental premise of the percent of sales method is that many but not all income statement and balance sheet items maintain a constant relationship to the level of sales. For example if the cost of goods sold has averaged 65 of sales over the last several years we would assume that this relationship would hold for the next year. If sales were expected to be 10 million next year our cost of goods forecast would be million 10 million x million . Of course this method assumes that the forecasted level of sales is already known. Forecasting the Income Statement As an example of income statement forecasting consider the .

TÀI LIỆU LIÊN QUAN
533    10    0
442    11    0
78    12    0
146    8    0
12    9    2
110    10    0
6    11    0
292    5    0
4    12    0
5    8    0
TÀI LIỆU XEM NHIỀU
24    2457    9
8    2083    6
29    1946    10
165    1773    1
2    1723    3
64    1685    4
35    1683    9
1    1626    4
15    1618    0
14    1573    1
TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
6    7    0    27-09-2020
11    4    0    27-09-2020
77    7    0    27-09-2020
15    8    0    27-09-2020
4    13    0    27-09-2020
23    4    0    27-09-2020
3    8    1    27-09-2020
9    14    0    27-09-2020
17    8    0    27-09-2020
17    6    0    27-09-2020
TÀI LIỆU HOT
580    1311    123
171    686    90
312    135    78
21    229    61
116    84    56
16    292    55
51    267    49
8    123    40
17    141    38
15    10    38