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
in Tables 4.10 and 4.11 do not show free cash flow and financing requirements. These are calculated in Table 1. Note that free cash flow for 2005 is -$2.3 million. But dividends are $2.0‚ so the company will need 2.3 + 2.0 = $4.3 million in outside equity financing. Table 2 shows that the book value of equity is forecasted to grow from $40.71 million in 2004 to $63.31 million at the end of 2010. Table 3 works out earnings‚ dividends and free cash flow for 2011. By that time Reeby Sports should
Premium Discounted cash flow Generally Accepted Accounting Principles Stock market
> 25 and shares are Public (ie there is no quoted market values); you can use Fair Value though Net Income Income OR Equity Method 2013-24‚ 2010-84‚ 2008-82‚ 2007.76. 2013M2-29 Goodwill (Don’t Use Calculation) "Goodwill= Cash Paid -FV of Net Assets (BV + FV adjustments) + NCI (based on FV of Net Assets) " Note: If the Full Price (Controlling + Non Controlling) is given‚ use the Full Price * (Non Controlling %) instead of the NCI (based on FV of Net Assets) - 2013M2-54
Premium Generally Accepted Accounting Principles Balance sheet Revenue
Exam 2 Part 2 Answer any EIGHT of the ten questions. Each question is worth 5 points. Return your answers to me by 11:59 PM Sunday 11 November 2012 1. A number of publicly traded firms pay no dividends yet investors are willing to buy shares in these firms. How is this possible? Does this violate our basic principle of stock valuation? 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
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
rates in percentage with up to two decimals. Read 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
Premium Free cash flow Inventory Generally Accepted Accounting Principles
NPV is short for Net Present Value and it makes difference between the present value and cost of a project. In addition‚ NPV takes into account all cash flows through out the whole life of the projects‚ as well as the time value of money. And it compares like with like as all inflows and outflows are discounted to today¡¯s date. Also‚ the cost of capital is very unlikely to be changed over a period of time. To judge if the NPV is good‚ we should see the value of it‚ and the rule is the high the better
Premium Net present value Discounted cash flow Time
(10-8) NPVs‚ IRRs‚ 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
Premium Depreciation Net present value Operating cash flow
Annual Report 2012 9-W) 8466 2 y No. mpan 3 (Co LIA S rhad lan K sia Be rminal‚ Ja rt Zone AirA C Te po port LC n Sup al Air ysia uther ternation san‚ Mala So ur In rul Eh 75 1100 Lump or Da Kuala g‚ Selang ax: 603-87 .com F an sia 4333 0 Sep @aira 6400 603-8660 rrelations sto Tel: : inve -mail E AirAsia Berhad (284669-W) www.airasia.com eams m Dr ality fro o Re t al Annu rt Repo 2012 ur ders O n ou F entous another mom
Premium
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
Premium Bond Investment Bonds