Introduction to Discounted Cash Flow Analysis and Financial Functions in Excel

The financial and economic analysis of investment projects is typically carried out using the technique of discounted cash flow (DCF) analysis. This module introduces concepts of discounting and DCF analysis for the derivation of project performance criteria such as net present value (NPV), internal rate of return (IRR) and benefit to cost (B/C) ratios. These concepts and criteria are introduced with respect to a simple example, for which calculations using MicroSoft Excel are demonstrated.

Reconciling value estimates from the discounted cash flow model and the residual income model

This paper examines why practitioners and researchers get different estimates of equity value when they use a discounted cash flow (CF) model versus a residual income (RI) model. Both models are derived from the same underlying assumption -- that price is the present value of expected future net dividends discounted at the cost of equity capital -- but in practice and in research they frequently yield different estimates. We argue that the research literature devoted to comparing the accuracy of these two models is misguided; properly implemented, both models yield identical valuations for all firms in all years. We identify how prior research has applied inconsistent assumptions to the two models and show how these seemingly small errors cause surprisingly large differences in the value estimates. [ABSTRACT FROM AUTHOR]

As variáveis condicionantes da previsão do cash flow operacional aplicado às Empresas Portuguesas de vestuário e calçado

O presente artigo tem por finalidade analisar os factores condicionantes da previsão do cash flow proveniente da actividade operacional, através do desenvolvimento de um modelo econométrico que foi estimado com base numa amostra seccional relativa ao ano de 2000 e constituída por 395 empresas portuguesas dos sectores do vestuário e calçado. O modelo foi estimado através do método de mínimos quadrados ordinário (MQO) com a correcção de White e, os resultados obtidos mostraram que o cash flow futuro é explicado pelas variáveis explicativas; recursos gerados na actividade operacional, dívidas de e a terceiros provenientes da actividade operacional e uma variável dummy que diferencia as empresas pelos dois sectores de actividade, todas desfasadas de um período (ano).

Does direct cash flow presentation help in predicting future operating cash flow?

A Work Project, presented as part of the requirements for the Award of a Masters Degree in Finance from the NOVA – School of Business and Economics

Almirante: Evaluating the board game: Board game, startup, discounted cash flow, venture capital method, real options

This thesis evaluates a start-up company (Jogos Almirante Lda) whose single asset is a board game named Almirante. It aims to conclude whether it makes sense to create a company or just earn copyrights. The thesis analyzes the board game’s market, as part of the general toy’s market, from which some data exists: European countries as well as the USA. In this work it is analyzed the several ways to finance a start-up company and then present an overview of the valuation of the Jogos Almirante based on three different methods: Discounted Cash Flow, Venture Capital Method and Real Options.

Does direct cash flow presentation help in predicting future operating cash flow?

Research literature and regulators are unconditional in pointing the disclosure of operating cash flow through direct method a section of unique information. Besides the intuitive facet, it is also consistent in forecasting future operating cash flows and a cohesive piece to financial statement puzzle. Bearing this in mind, I produce an analysis on the usefulness and predictive ability on the disclosure of gross cash receipts and payments over the disclosure of reconciliation between net income and accruals for two markets with special features, Portugal and Spain. Results validate the usefulness of direct method format in predicting future operating cash flow. Key

Reporting cash flow evidence from campanies listed in the Euronext Lisbon

Based on the 2013 and 2014 consolidated statements of cash flows of companies listed in Euronext Lisbon, this Work Project analyses the cash flow disclosures, namely if they are in accordance with International Accounting Standards 7, specifically the format, the choice of classification interests, dividends paid and received and the composition of cash and cash equivalents. Additionally, quality of income ratio is analyzed due to its importance for users of financial statements. The results show evidence of uniformity and consistency in the use of the direct method for reporting operational activities in both years, but there are some differences regarding the disclosure of interests and dividends, paid and received, respectively.

Market rewards to patterns on increasing earnings: do cash flow patterns, accruals manipulation and real activities manipulation matter?

This study explores whether firms have differential price-earnings multiples associated with their means of achieving a sequential pattern of increasing positive earnings. Our main findings show that market participants assign higher price-earnings multiples to firms when their pattern of increasing earnings is supported by the same pattern of increasing cash flows. Market participants assign lower price-earnings multiples to firms suspect of having engaged in accrual-based earnings management, sales manipulation, and overproduction to achieve the earnings pattern. We find, however, that market participants do not penalize firms suspect of having achieved the earnings pattern through the opportunistic reduction of discretionary expenses.

Cash flow and discount rate risk decomposition and ICAPM for the US and brazilian stock markets

Esse trabalho é uma aplicação do modelo intertemporal de apreçamento de ativos desenvolvido por Campbell (1993) e Campbell e Vuolteenaho (2004) para as carteiras de Fama-French 2x3 brasileiras no period de janeiro de 2003 a abril de 2012 e para as carteiras de Fama-French 5x5 americanas em diferentes períodos. As varíaveis sugeridas por Campbell e Vuolteenaho (2004) para prever os excessos de retorno do mercado acionário americano no period de 1929 a 2001 mostraram-se também bons preditores de excesso de retorno para o mercado brasileiro no período recente, com exceção da inclinação da estrutura a termo das taxas de juros. Entretanto, mostramos que um aumento no small stock value spread indica maior excesso de retorno no futuro, comportamento que não é coerente com a explicação para o prêmio de valor sugerida pelo modelo intertemporal. Ainda, utilizando os resíduos do VAR preditivo para definir o risco de choques de fluxo de caixa e de choques nas taxas de desconto das carteiras de teste, verificamos que o modelo intertemporal resultante não explica adequadamente os retornos observados. Para o mercado norte-americano, concluímos que a abilidade das variáveis propostas para explicar os excessos de retorno do mercado varia no tempo. O sucesso de Campbell e Vuolteenaho (2004) em explicar o prêmio de valor para o mercado norte-americano na amostra de 1963 a 2001 é resultado da especificação do VAR na amostra completa, pois mostramos que nenhuma das varíaveis é um preditor de retorno estatisticamente significante nessa sub-amostra.

EC94-852 Cash Flow Planning Form

This extension circular covers the following areas of a cash flow planning form: Beginning Cash Balance, Operating Sales (crop and hay, market livestock, livestock product, custom work); Capital Sales (breeding livestock, machinery and equipment); Personal Income (wages, interest); Operating Expenses (car/truck, chemicals, conservation, custom hire, feed purchased, fertilizers and lime, freight and trucking, gasoline, fuel and oil, insurance, labor hired, rents and leases, repairs and maintenance, seeds and plants, storage, warehousing, supplies, taxes, utilities, veterinary, breeding fees and medicine, feeder livestock); Capital Purchases (breeding livestock, machinery and equipment, family living withdrawals, personal investments, income and social security, term loan payments); Net Cash Available (operating loan borrowings, operating loan payments); and Ending Operating Loan Balance. Along with the Cash Flow Planning Form is a Projected Income Statement Form which covers Projected Business Income (operating sales, breeding livestock, estimated cash income adjustments, estimated gross revenues, estimated value of production); Project Business Expenses (cash operating, esimated operating, prepaid and supplies, cash investment in growing crops, accounts payable); Projected Net Income Summary (estimated net income from operations, estimated net business income, estimated net income after taxes, estimated earned net worth change); and a Physical Inventory Flows Worksheet.

Separation of Control and Cash-Flow Rights of State Owned Listed Enterprises: Channels of Expropriation after the Discriminated Share Reform in China

Literature on agency problems arising between controlling and minority owners claim that separation of cash flow and control rights allows controllers to expropriate listed firms, and further that separation emerges when dual class shares or pyramiding corporate structures exist. Dual class share and pyramiding coexisted in listed companies of China until discriminated share reform was implemented in 2005. This paper presents a model of controller to expropriate behavior as well as empirical tests of expropriation via particular accounting items and pyramiding generated expropriation. Results show that expropriation is apparent for state controlled listed companies. While reforms have weakened the power to expropriate, separation remains and still generates expropriation. Size of expropriation is estimated to be 7 to 8 per cent of total asset at mean. If the "one share, one vote" principle were to be realized, asset inflation could be reduced by 13 percent.

JEFFI [microform] : a simplified, Lotus-based cash flow analysis program /

"July 1993"--P. [2] of cover.

Protecting the small business cash flow lifeline /

Bibliography: p. 20-23.