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

## CHAPTER 3 The Cash Budget Explain the purpose of the cash budget and how it differs from an income statement. Calculate a firm’s expected total cash collections and disbursements for a particular month. Calculate a firm’s expected ending cash balance and short-term borrowing needs. | 3 The Cash Budget After studying this chapter you should be able to 1. Explain the purpose of the cash budget and how it differs from an income statement. 2. Calculate a firm s expected total cash collections and disbursements for a particular month. 3. Calculate a firm s expected ending cash balance and short-term borrowing needs. 4. Demonstrate how Excel can be used to determine the optimal timing of major cash expenditures. 5. Use the Scenario Manager to evaluate different assumptions in a model. 6. Use the various tools that Excel provides to find and fix errors in formulas. Of all the topics covered in this book perhaps no other task benefits so much from the use of spreadsheets as the cash budget. As we ll see the cash budget can be a complex document with many interrelated entries. Manually updating a cash budget especially for a large firm is not a chore for which one volunteers. However once the initial cash budget is set up in a spreadsheet updating and playing what if becomes very easy. A cash budget is simply a listing of the firm s anticipated cash inflows and outflows over a specified period. Unlike a pro forma income statement discussed in Chapter 67 68 The Cash Budget 5 the cash budget includes only actual cash flows. For example depreciation expense does not appear on the cash budget but principal payments on debt obligations which are not on the income statement do. Because of its emphasis on cash income and expenditures the cash budget is particularly useful for planning short-term borrowing and the timing of expenditures. As with all budgets another important benefit of the cash budget comes from reconciling actual cash flows with those from the forecast. We ll see that a cash budget is composed of three parts 1. The worksheet area 2. A listing of each of the cash inflows collections and outflows disbursements 3. Calculation of the ending cash balance and borrowing needs. Throughout the chapter we will create a complete cash budget with these .

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    2455    9
8    2083    6
29    1945    10
165    1773    1
2    1723    3
64    1685    4
35    1682    8
1    1625    4
15    1617    0
14    1573    1
TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
2    7    0    27-09-2020
9    5    0    27-09-2020
8    2    0    27-09-2020
78    8    0    27-09-2020
8    5    0    27-09-2020
7    9    0    27-09-2020
5    3    0    27-09-2020
7    5    0    27-09-2020
25    6    0    27-09-2020
36    8    0    27-09-2020
TÀI LIỆU HOT
580    1311    123
171    686    90
312    135    77
21    228    61
116    84    56
16    290    55
51    267    49
8    123    40
17    141    38
15    9    38