ANALYSIS FOR FINANCIAL MANAGEMENT 10TH Edition Robert C. Higgins Additional Problems Chapter 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.
Premium Net present value Rate of return Internal rate of return
income($M) | 673 | 970 | 123 | 116 | 249 | Net profit margin | 4.48% | 6.23% | 0.85% | 0.84% | 1.67% | × Asset turnover | 0.77 | 0.79 | 0.73 | 0.69 | 0.71 | = ROA | 3.45% | 4.92% | 0.61% | 0.58% | 1.19% | × Financial leverage | 3.45 | 3.44 | 3.49 | 3.34 | 3.40 | = ROE | 11.93% | 16.91% | 2.13% | 1.94% | 4.05% | NOPAT margin | 6.48% | 8.72% | 1.40% | 1.84% | 2.93% | Profitability analysis Virgin blue | 2007 | 2008 | 2009 | 2010
Premium Financial ratios
In the article “An Analysis of Patterns from the Statement of Cash Flows”‚ the writers Benton E. Gup‚ William D. Samson‚ Michael T. Dugan‚ Myung J. Kim‚ and Thawatchai Jittrapanun discuss some of the various aspects of the Statement of Cash Flows. Prior to 1987‚ the Statement of Cash Flows was not a mandatory portion of financial statements (73). On a Statement of Cash Flows‚ there can be three types of cash flows: operating activities‚ financial activities‚ and investing activities; these activities
Premium Cash flow statement Cash flow Money
What is a Negative Cash Flow? When a company spends more than it receives during a set period of time‚ typically a quarter‚ the company is said to have a negative cash flow. This is often viewed as an indicator of financial ill health by people who are assessing companies to determine whether or not to invest in the company. Many things can influence cash flow‚ however‚ and one that’s negative should not necessarily be seen as a black mark. Publicly traded companies send out documentation
Premium Finance
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
became one of the largest independent funds in France. With his second fund he would focus on investments in France on a larger scale. On April 29‚ 1999‚ a new investment opportunity arose for Butler: Autodistribution (AD). AD is an entrepreneurial firm and has become the largest independent automotive parts wholesaler in France by the end of the 1990s. This report starts with an analysis of the opportunities and risks for the AD deal and determines whether Butler should make a proposal or not
Premium Free cash flow Discounted cash flow Auto parts
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
6A:001 Introduction to Financial Accounting Cash Flow Exercise Required: Following are the balance sheet and statement of cash flow as reported by Pro-Solutions Inc. for its fiscal year ending March 31‚ 2012. Using the information provided in the statement of cash flow‚ reconcile the March 31‚ 2011 balance sheet to the March 31‚ 2012 balance sheet using the T-accounts on the attached worksheet. PRO-SOLUTIONS INC. CONSOLIDATED BALANCE SHEETS (IN THOUSANDS) | March 31‚ | March 31‚ |
Premium Generally Accepted Accounting Principles Cash flow Cash
Fund Flow Statements Meaning of Fund Fund Flow Statement is widely used tool in the hands of financial executives for analyzing the financial performance of a concern. Funds keep on moving in a business which itself is based on a going concern concept. In broader sense‚ the term “fund” refers to money values in whatever form it may exits. Meaning of Flow of Fund The term ‘Flow’ means change. Thus flow of fund means change in fund or change in working capital. Flow of fund is said to have taken
Premium Balance sheet Inventory Generally Accepted Accounting Principles
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