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
autoparts chain‚ is considering purchasing a smaller chain‚ South Georgia Parts (SGP). Brau’s analysts project that the merger will result in the following incremental free cash flows‚ tax shields‚ and horizon values: Years 1 2 3 4 Free cash flow $1 $3 $3 $7 Unlevered horizon value 75 Tax shield 1 1 2 3 Horizon value of tax shield 32 Assume that all cash flows occur at the end of the year. SGP is currently financed with 30% debt at a rate of 10%. The acquisition
Premium Finance Free cash flow Corporate finance
FINANCIAL STATEMENTS AND CASH FLOW 1. Liquidity measures how quickly and easily an asset can be converted to cash without significant loss in value. It’s desirable for firms to have high liquidity so that they have a large factor of safety in meeting short-term creditor demands. However‚ since liquidity also has an opportunity cost associated with it - namely that higher returns can generally be found by investing the cash into productive assets - low liquidity levels are also desirable to the
Premium Generally Accepted Accounting Principles Cash flow Balance sheet
Difference Between Cash Flow and Funds Flow Statement Many people think that both cash and fund are same‚ however they both are different and so is the case with cash flow statement and funds flow statement. Let’s look at some of the differences between cash flow and funds flow statement – 1. While funds flow statement reveals the change in the working capital of a company between two balance sheet dates while cash flow statement reveals the change in the cash position of the company between two
Premium Cash flow Balance sheet Cash flow statement
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)
Premium Generally Accepted Accounting Principles Balance sheet Accounts receivable
Chapter 12 Statement of Cash Flows True / False Questions 1. Interest and dividends from investments held by a company are reported as cash inflows from investing activities on the statement of cash flows. True False 2. Under the indirect method‚ changes in current assets are used in determining cash flows from operating activities and changes in current liabilities are used in determining cash flows from financing activities. True False 3. Using the indirect method‚ the increase
Premium Balance sheet Cash flow statement Cash flow
Writing Assignment Week 1 Question 2.2 – Accounting and Cash Flows: Why is it that the revenue and cost figures shown on a standard income statement may not be representative of the actual cash inflows and outflows that occurred during a period? Financial Statements are prepared according to accrual rule of ‚ according to which cost and revenue are recorded as they occur and not when they are actually received or paid. This is why cash flows during the year may be different from revenue and costs
Premium Generally Accepted Accounting Principles Balance sheet Income statement
Cash is the life blood of a business and it can’t operate without it. Survival of a business depends upon its ability to meet liabilities when they fall and thus requires cash. When considering the overall cash flow of the yacht business we can see that it is suffering from cash flow problems ever since the business started. Although the monthly deficit has been decreasing every month due to the increased sales‚ the overall balance carried forward is gradually going up. It would be advisable
Premium Costs Marketing Cost
Initial cash flow at t=0: Purchase: -$700‚000 Shipping and installation: -$100‚000 Depreciable basis = $800‚000 Old machine after taxes = $120‚000 - ($120‚000-$80‚000)(.40) = $104‚000 Initial Cash flow = -$800‚000 + $104‚000 = -$696‚000 Depreciation: Year 1: $800‚000 * .3333 = $266‚640 Year 2: $800‚000 * .4445 = $355‚600 Year 3: $800‚000 * .1481 = $118‚480 Year 4: $800‚000 * .0741 = $59‚280 Yearly revenue change: Decrease operating expenses of $90‚000 Incremental net cash flow at t=1:
Premium Income statement Cash Generally Accepted Accounting Principles
year ended December 31‚ 2010. Cash received from lenders $20‚000 Cash received from customers 60‚000 Cash paid 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
Premium Income statement Revenue Income