7 – Discounted Cash Flow Techniques page 247 A brief tutorial on Excel financial functions (problems to follow) You may find the following Excel‚ built-in financial functions helpful when analyzing the problems below. (To access these functions‚ select Insert‚ Functions‚ and choose Financial.) =PV(rate‚ nper‚ pmt‚ fv‚ type) returns the present value of a series of cash flows. =FV(rate‚ nper‚ pmt‚ pv‚ type) returns the future value of a series of cash flows. =PMT(rate
Premium Net present value Rate of return Internal rate of return
CONSTRUCTION OF FREE CASH FLOWS A PEDAGOGICAL NOTE. PART I Ignacio Vélez-Pareja ivelez@javeriana.edu.co Department of Management Universidad Javeriana Bogotá‚ Colombia Working Paper N 5 First version: 5-Nov-99 This version: January 2001 This paper can be downloaded from the Social Science Research Network Electronic Paper Collection: http://papers.ssrn.com/paper.taf?abstract_id=196588 CONSTRUCTION OF FREE CASH FLOWS
Premium Net present value Cash flow
Chapter 12 Problems 1. Cash flow (LO2) Assume a corporation has earnings before depreciation and taxes of $100‚000‚ depreciation of $50‚000‚ and that it has a 30 percent tax bracket. Compute its cash flow using the format below. Earnings before depreciation and taxes _____ Depreciation _____ Earnings before taxes _____ Taxes @ 30% _____ Earnings after taxes _____ Depreciation _____
Premium Standard deviation Income statement Variance
and MIRRs for Independent Projects Edelman Engineering is considering including two pieces of equipment‚ a truck and an overhead pulley system‚ in this year’s capital budget. The projects are independent. The cash outlay for the truck is $17‚100 and that for the pulley system is $22‚430. The firm’s cost of capital is 14%. After-tax cash flows‚ including depreciation‚ are as follows: Year Truck Pulley 1 $5‚100 $7‚500 2 $5‚100 $7‚500 3 $5‚100 $7‚500 4 $5‚100 $7‚500 5 $5‚100 $7‚500 Calculate
Premium Depreciation Net present value Operating cash flow
E1-5 The following information was taken from the 2006 financial statements of pharmaceutical giant Merck and Co. All dollar amounts are in millions. Retained earnings‚ January 1‚ 2006 $37‚980.0 Materials and production expense 6‚001.1 Marketing and administrative expense 8‚165.4 Dividends 3‚318.7 Sales revenue 22‚636.0 Research and development expense 4‚782.9 Tax expense 1‚787.6 Other revenue 2‚677.1 Hint: Prepare income statement and retained earnings statement
Premium Income statement Revenue Income
Statement of Cash Flows Solutions to Questions 14-1 The statement of cash flows highlights the major activities that impact cash flows and hence affect the overall cash balance. 14-2 Cash equivalents are short-term‚ highly liquid investments such as Treasury bills‚ commercial paper‚ and money market funds. They are included with cash because investments of this type are made solely for the purpose of generating a return on temporarily idle funds and they can be easily converted to cash. 14-3 (1) Operating
Premium Generally Accepted Accounting Principles Balance sheet Accounts receivable
Statement of Cash Flows Chapter 8 Measuring & reporting cash flows pages 448-472 448 472 pages 484-489 1 1 Learning objectives 1. 2. 3. 4. Explain why cash is important to the reporting entity Define cash and cash equivalents Distinguish between accrual- and cash-based transaction recognition Compare and contrast the roles of the four external financial reports (statement of financial performance‚ statement of financial position‚ statement of changes in equity and statement of cash flows) Discuss
Premium Cash flow statement Balance sheet Generally Accepted Accounting Principles
Analysis of Cash Flows Statements By Song Hanxiao Pace University – New York Campus MBA 640‚ 72052 Fall 2011 John Paul Required Research Paper Contents Abstract --------------------------------------------------------------------------------------------------------3 | I. Introduction of importance of Cash Flows statements -------------------------------------4 | II. Function of Cash Flow Statements -----------------------------------------------------------5
Premium Cash flow Cash flow statement Balance sheet
CORPORATE LIQUIDITY‚ CASH FLOW SENSITIVITY‚ AND INVESTMENT DECISION Written by: Destria Kurnianti 10/309731/PEK/15164 Ratified on 18 Januari 2012 Supervisor Prof. Marwan Asri‚ MBA‚ Ph.D INTRODUCTION Modigliani and Miller (1958)‚ in a perfect market conditions there is no relationship between investment decisions and financing decisions. Although the assumption of perfect markets is eliminated‚ the separation between investment decisions and financing
Premium Cash flow Corporate finance
Cash Flows for Discounting Calculations When managers are forecasting the cash flows for a project‚ they will consider the expected revenues and costs‚ but they must also include an estimate for working capital requirements. The working capital will be required in period 1 to allow the business to acquire inventories and build up debtors (receivables) to the extent that these are not matched by trade. The working capital will be recovered at the end of the project when the inventories are sold‚
Premium Cash flow Net present value Tax