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
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
Financial Analyst Date: 10/5/13 Re: Corporate Financial Position/Statement of Cash Flows I have been charged to examine the Financial Statements of Carpino Company for the purpose of providing an objective opinion regarding organizational capacity to generate sufficient cash to continue as a going concern. Toward that end‚ I have examined financial statements and have prepared the attached Statement of Cash Flows for the Year Ended January 31‚ 2007. I am pleased to inform Carpino Company stockholders
Premium Investment Generally Accepted Accounting Principles Chief executive officer
Pinkerton‚ should he finance the purchase with Financing Alternative #1 (debt and equity financing from an investment firm) or Alternative #2 (all debt financing from a bank). The financing alternatives are discussed on page 4 of the case. You should do the discounted cash flow valuation of the deal using Adjusted Present Value. The question is “What is Pinkerton worth to CPP (Wathen’s sole proprietorship)?” The value of Pinkerton to CPP is made up of three parts: 1. the value of Pinkerton as a
Premium Free cash flow Discounted cash flow Cash flow
the syllabus for examples.The points for each question are listed in parentheses at the start of the question‚ and the total points for the entire assignment adds up to 100. You are strongly encouraged to use spreadsheets. Refer to Note on Sample Cash Flow Template. Question 1 (5 points) The project with the highest IRR is always the project with the highest NPV. Your Answer | | Score | Explanation | True | | | | False | ✔ | 5.00 | Correct. Try now to sort this out in different contexts
Premium Free cash flow Inventory Generally Accepted Accounting Principles
present value of the asset’s expected future cash flows. SECURITY VALUATION In general‚ the intrinsic value of an asset = the present value of the stream of expected cash flows discounted at an appropriate required rate of return. Can the intrinsic value of an asset differ from its market value? Ct = cash flow to be received at time t. k = the investor’s required rate of return. V = the intrinsic value of the asset. BOND VALUATION Discount the bond’s cash flows at the investor’s required rate of return
Premium Bond Investment Bonds
paying cash‚ manufacturing the product‚ selling the product and collecting cash. During the payment‚ the cash need occurs. Cash need should be covered by going into a debt. Cash budget is a primary tool in short-term financial planning. It is prepared after the operating budgets (sales‚ manufacturing expenses or merchandise purchases‚ selling expenses‚ and general and administrative expenses) and the capital expenditures budget are prepared. The cash budget starts with the beginning cash balance
Premium Time Money Budget
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
Explain. Our basic principle of stock valuation is that the value of a share of stock is simply equal to the present value of all of the expected dividends on the stock. According to the dividend growth model‚ an asset that has no expected cash flows has a value of zero‚ so if investors are willing to purchase shares of stock in firms that pay no dividends‚ they evidently expect that the firms will begin paying dividends at some point in the future. 2. Explain why some bond investors are
Premium Discounted cash flow Net present value Time value of money
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