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
5 & 6 Cash flow reporting and analysis REVISED BY DR SIMONA SCARPARO (FEBRUARY 2013). EARLIER R E V I S E D B Y D R G U S H O S S A R I ( J A N U A R Y 2 0 1 0 ) ‚ B A S E D O N O R I G I N A L M AT E R I A L P R E PA R E D BY GARRY CARNEGIE‚ GRAEME W INE‚ CHRISTINE JUBB AND JUDY NAGY Contents Lectures 5 & 6: Introduction 1 Objectives 1 Learning resources 1 Prescribed text Online readings Glossary CloudDeakin 1 2 2 2 Importance of cash flow information
Premium Cash flow Balance sheet Generally Accepted Accounting Principles
for new equipment 35‚000 Cash dividends paid 8‚000 Cash paid to suppliers 18‚000 Cash balance 1/1/10 12‚000 Hint: Prepare a statement of cash flows. (SO 5) Instructions • Prepare the 2010 statement of cash flows for Damon Corporation. • Suppose you are one of Damon’s creditors. Referring to the statement of cash flows‚ evaluate Damon’s ability to repay its creditors. E1-13 The following data are derived from the 2006 financial statements of Southwest Airlines. All
Premium Income statement Revenue Income
how to format and account for cash flows when a company has subsidiaries operating in foreign countries. It gives an example of a consolidated cash flow statement from a US based company and its two subsidiary companies. The reference explains how excess cash should be disclosed. A majority of the reference deals with the local currency and how it should be shown with the parent company‚ in this case a US company based on the dollar. So for both foreign companies it needs to be formatted with both
Premium Corporation Subsidiary Cash flow statement
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 the IRR‚ the NPV‚ and the MIRR for each project‚ and indicate the correct accept-reject
Premium Depreciation Net present value Operating cash flow
Indirect Cash Flows Marlene A Broaddus-Waddell XACC-291 June 27‚ 2013 The difference between direct and indirect method of cash flows are the operating activities‚ which is the first section of the statement of cash flows. The investing and financing activities sections has no reported differences in the presentation of the cash flows. The direct presentation of cash flows displays cash receipts and payments from operations‚ more or less like the actual statement of cash flow. On the other
Premium Cash flow statement Generally Accepted Accounting Principles Cash flow
I. Introduction The purpose of this paper is to present and explain the statement of cash flows by incorporating the statements No. 95‚ 102 and 104 that establish standards for cash flows reporting issued by FASB[i]. FASB Statement No. 95 (FAS 95) “Statement of Cash Flows” supersedes APB Opinion No. 19‚ Reporting Changes in Financial Position‚ and requires a statement of cash flows as part of a full set of financial statements for all business enterprises[ii] in place of a statement of changes
Premium Cash flow statement Asset Money
Direct and Indirect Cash Flows Christine Grae XACC/291 Principles of Accounting II March 29‚ 2015 Susan Schulz When companies utilize the accrual method of accounting‚ they will prepare a cash flow statement in order to understand the flow of cash. We call this method the cash flow statement and it can be prepared in two different methods which would be indirect and direct. The methods are different but they both will be conducted with the same results for the accounting period. The direct
Premium Cash flow statement Cash flow Income statement
period between buying materials and collecting cash. And the third period is the period between selling the product and collecting cash. Cash flow management should be done carefully. The mistakes which are made during calculation of NPV and IRR can be compensated‚ but cash flow must be designed well. While the company makes cash flow endeavoring‚ the collection time and collection amount are assumed pessimistic in order to be well-prepared towards collecting problems. The payment should
Premium Time Money Budget
CHAPTER 4 DISCOUNTED CASH FLOW VALUATION Solutions to Questions and Problems 10. To find the future value with continuous compounding‚ we use the equation: FV = PVeRt a. b. c. d. FV = $1‚000e.12(5) FV = $1‚000e.10(3) FV = $1‚000e.05(10) FV = $1‚000e.07(8) = $1‚822.12 = $1‚349.86 = $1‚648.72 = $1‚750.67 23. We need to find the annuity payment in retirement. Our retirement savings ends at the same time the retirement withdrawals begin‚ so the PV of the retirement withdrawals will be the FV of
Premium Cash flow Net present value Rate of return