FM12_Ch_03_Tool_Kit

FM12_Ch_03_Tool_Kit - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1/22/2007 Chapter 3. Tool Kit for Financial Statements, Cash Flows, and Taxes FINANCIAL STATEMENTS AND REPORTS (Section 3.1) THE BALANCE SHEET (Section 3.2) The annual report contains a verbal section plus four key statements: the balance sheet, income statement, statement of retained earnings, and statement of cash flows. These statements contain a wealth of information that is used by bankers, stock and bond analysts, and managers. Hence, they are quite important. Spreadsheets are used both to create and to analyze these statements, as we demonstrate in this model. Regarding statement creation, firms' accounting information is maintained in computer files, which are adjusted as sales occur, materials are purchased, and so forth. The firm's accountants periodically--monthly, quarterly, and annually-- extract information from the general files and compile the four statements. These statements-- in both printed and spreadsheet format--are made available to security analysts, and if the firm wants to borrow money, the same information is provided to potential lenders. The firm's financial staff also uses the data to analyze the firm's condition--its strengths and weaknesses--and this information is used in the quest to improve operations and increase the firm's value. In this model, we start with the same balance sheet and income statement that was used in the chapter, but in an Excel format, and then we show how Excel (and other spreadsheet packages) can be used to analyze the data. In addition, note that in cells which summarize data in other cells, such as sums or differences, the spreadsheet uses formulas rather than fixed numbers. For example, the cell for Total assets contains the Sum formula rather than just $2,000. (The cell itself shows $2,000, but if you put the pointer on the cell, then the formula line will show that the cell actually contains a formula.) That way, if the data for any input (cash, for instance) changes, the spreadsheet will automatically recalculate and provide the correct net value for Total assets. As you will see as you go through our models, this automatic recalculation feature is one of the most useful and powerful aspects of Excel and other spreadsheets. Finally, note that we show just below this introduction, before the financial statements, some information that is used to develop aspects of the financial statements, including the tax rate, number of shares outstanding, and price per share. Generally, in financial models, data that are used to construct statements are shown in an Input Data Section toward the top of the model. A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
INPUT DATA SECTION: Historical Data Used in the Analysis 2007 2006 Year-end common stock price $23.00 $26.00 Year-end shares outstanding (in millions) 50 50 Tax rate 40% 40% Weighted average cost of captal (WACC) 11.0% 10.8% Table 3-1 MicroDrive Inc. December 31 Balance Sheets
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

FM12_Ch_03_Tool_Kit - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online