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.

The impact of size and age of the company on assessing financial risk

Textiles and tourism sectors are two important sectors in Portuguese economy. Its high exposure to both internal and international economy volatility transform the companies operating in these economic sectors especially vulnerable to recent economic crises in Portugal and European Union. The objective of this paper is to evaluate and understand the impact of size and age on the financial health of textile and tourism companies, measured by economic indices. An empirical based model is proposed. Its implications are derived and tested on a sample of 4061 Portuguese companies from textile and tourism sector, during the period 2005-2009. The results conclude that age has a stronger impact on the risk of failure than size. Whereas the effect of age is generally positive regarding the financial health of the company, the effect of size is less clear and depends on the age of the company.

Financial Risk Analysis of Portuguese Textile and Tourism Companies

Textile and tourism sectors are two important industries in the Portuguese economy. However, its high exposure to both internal and international economic volatility make the companies operating in these economic sectors particularly vulnerable to economic crises, such as the ones which have been impacting Portugal and the European Union. The objective of this paper is to evaluate and understand the impact of size and age on the financial health of textile and tourism companies, measured by economic indices. An empirical based model is proposed. Its implications are derived and tested on a sample of 4061 Portuguese companies from textile and tourism sectors, during the period 2005-2009. The findings suggest that age has a major impact on the risk of failure, rather than size. Whereas the effect of age is generally positive regarding the financial health of the company, the effect of size is less clear and ultimately depends on the age of the company.

Financial Risk Analysis of Portuguese Textile and Tourism Companies

Textile and tourism sectors are two important industries in the Portuguese economy. However, its high exposure to both internal and international economic volatility make the companies operating in these economic sectors particularly vulnerable to economic crises, such as the ones which have been impacting Portugal and the European Union. The objective of this paper is to evaluate and understand the impact of size and age on the financial health of textile and tourism companies, measured by economic indices. An empirical based model is proposed. Its implications are derived and tested on a sample of 4061 Portuguese companies from textile and tourism sectors, during the period 2005-2009. The findings suggest that age has a major impact on the risk of failure, rather than size. Whereas the effect of age is generally positive regarding the financial health of the company, the effect of size is less clear and ultimately depends on the age of the company.

The impact of size and age of the company on assessing financial risk.

Textiles and tourism sectors are two important sectors in Portuguese economy. Its high exposure to both internal and international economy volatility transform the companies operating in these economic sectors especially vulnerable to recent economic crises in Portugal and European Union. The objective of this paper is to evaluate and understand the impact of size and age on the financial health of textile and tourism companies, measured by economic indices. An empirical based model is proposed. Its implications are derived and tested on a sample of 4061 Portuguese companies from textile and tourism sector, during the period 2005-2009. The results conclude that age has a stronger impact on the risk of failure than size. Whereas the effect of age is generally positive regarding the financial health of the company, the effect of size is less clear and depends on the age of the company.

Governance mechanisms in Spanish financial intermediaries

This paper examines the governance of Spanish Banks around two main issues. First, does a poor economic performance activate those governance interventions that favor the removal of executive directors and the merger of non-performing banks? And second, does the relationship between governance intervention and economic performance vary with the ownership form of the bank? Our results show that a bad performance does activate governance mechanisms in banks, although for the case of Savings Banks intervention is confined to a merger or acquisition. Nevertheless, the distinct ownership structure of Savings Banks does not fully protect non-performing banks from disappearing. Product-market competition compensates for those weak internal governance mechanisms that result from an ownership form which gives voice to several stakeholder groups.

The response of the external finance premium in Asian corporate bond markets to financial characteristics, financial constraints and two financial crises

Empirical investigation of the external finance premium has been conducted on the margin between internal finance and bank borrowing or equities but little attention has been given to corporate bonds, especially for the emerging Asian market. In this paper, we hypothesize that balance sheet indicators of creditworthiness could affect the external finance premium for bonds as they do for premia in other markets. Using bond-specific and firm-specific data for China, Hong Kong, Indonesia, Korea, Philippines, Singapore and Thailand during 1995-2009 we find that firms with better financial health face lower external finance premia in all countries. When we introduce firm-level heterogeneity, we show that financial variables appear to be both statistically and quantitatively more important for financially constrained firms. Finally, when we examine the effects of the 1997-98 Asian crisis and the 2007-09 global financial crisis, we find that the sensitivity of the premium is greater for constrained firms during the Asian crisis compared to other times.

Small firms, growth and financial constraints

This paper analyses the impact of different sources of finance on the growth of firms. Using panel data from Spanish manufacturing firms for the period 2000-2006, we investigate the effects of internal and external finances on firm growth. In particular, we examine three dimensions of these financial sources: a) the performance of the firms’ capital structure in accordance with firm size; b) the effects of internal and external financial sources on growth performance; c) the combined effect of equity, external debt and cash flow on firm growth. We find that low-growth firms are sensitive to cash flow and short-term bank debt, while high-growth firms are more sensitive to long-term debt. Furthermore, equity capital seems to reduce barriers to external finance. Our main conclusion is that during the start-up phase, firms are unable to increase their financial leverage and so their capital structure fails to promote correct investment strategies. However, as their equity capital increases, alternative financial mechanisms, in particular long-term debt, become available, which have a positive impact on firm growth.

Are small firms more sensitive to financial variables?

This paper analyses the impact of different sources of finance on the growth of firms. sing panel data from Spanish manufacturing firms for the period 2000-2006, we investigate the effects of internal and external finances on firm growth. In particular, we examine wo dimensions of these financial sources: a) the performance of the firms' capital structure n accordance with firm size; b) the combined effect of equity, external debt and cash low n firm growth. We find that low-growth firms are sensitive to cash low and short-term ank debt, while high-growth firms are more sensitive to long-term debt. Furthermore, ur results show that low-growth firms are more sensitive to short-term financial variables, hile fast growth firms are more sensitive to long-term financial variables. EL codes: L25, R12. eywords: Finance, Firm growth, Quantile regressions, Small firms

Framework for Corporate and Financial Governance for Regulatory Bodies under the aegis of the Department of Health and Children

The document should be read as supplementary to existing requirements as set out both in statute â?" particularly legislation specific to your organisation, the Health Acts 1947-2004, Ombudsman Act, 1980, Data Protection Acts 1988 & 2003, Freedom of Information Acts 1997-2003, Ethics in Public Office Acts 1995 & 2001, Ombudsman for Children Act, 2002 and the Comptroller and Auditor General (Amendment) Act, 1993 – and in Government approved guidelines, including the Code of Practice for the Governance of State Bodies (2001), Public Financial Procedures, The Role and Responsibilities of Accounting Officers (2003) and Risk Management Guidance for Government Departments and Offices (2004). Read the report (PDF, 1.4mb)  

Financial constraints and the failure of innovation projects

Theoretical and empirical approaches have stressed the existence of financial constraints in innovative activities of firms. This paper analyses the role of financial obstacles on the likelihood of abandoning an innovation project. Although a large number of innovation projects are abandoned before their completion, the empirical evidence has focused on the determinants of innovation while failed projects have received little attention. Our analysis differentiates between internal and external barriers on the probability of abandoning a project and we examine whether the effects are different depending on the stage of the innovation process. In the empirical analysis carried out for a panel data of potential innovative Spanish firms for the period 2004-2010, we use a bivariate probit model to take into account the simultaneity of financial constraints and the decision to abandon an innovation project. Our results show that financial constraints most affect the probability of abandoning an innovation project during the concept stage and that low-technological manufacturing and non-KIS service sectors are more sensitive to financial constraints.

Financial constraints and the failure of innovation projects

Theoretical and empirical approaches have stressed the existence of financial constraints in innovative activities of firms. This paper analyses the role of financial obstacles on the likelihood of abandoning an innovation project. Although a large number of innovation projects are abandoned before their completion, the empirical evidence has focused on the determinants of innovation while failed projects have received little attention. Our analysis differentiates between internal and external barriers on the probability of abandoning a project and we examine whether the effects are different depending on the stage of the innovation process. In the empirical analysis carried out for a panel data of potential innovative Spanish firms for the period 2004-2010, we use a bivariate probit model to take into account the simultaneity of financial constraints and the decision to abandon an innovation project. Our results show that financial constraints most affect the probability of abandoning an innovation project during the concept stage and that low-technological manufacturing and non-KIS service sectors are more sensitive to financial constraints. Keywords: barriers to innovation, failure of innovation projects, financial constraints JEL Classifications: O31, D21

Financial Markets and Real Ecinomy: Four Essays in International Trade

Financial markets play an important role in an economy performing various functions like mobilizing and pooling savings, producing information about investment opportunities, screening and monitoring investments, implementation of corporate governance, diversification and management of risk. These functions influence saving rates, investment decisions, technological innovation and, therefore, have important implications for welfare. In my PhD dissertation I examine the interplay of financial and product markets by looking at different channels through which financial markets may influence an economy.My dissertation consists of four chapters. The first chapter is a co-authored work with Martin Strieborny, a PhD student from the University of Lausanne. The second chapter is a co-authored work with Melise Jaud, a PhD student from the Paris School of Economics. The third chapter is co-authored with both Melise Jaud and Martin Strieborny. The last chapter of my PhD dissertation is a single author paper.Chapter 1 of my PhD thesis analyzes the effect of financial development on growth of contract intensive industries. These industries intensively use intermediate inputs that neither can be sold on organized exchange, nor are reference-priced (Levchenko, 2007; Nunn, 2007). A typical example of a contract intensive industry would be an industry where an upstream supplier has to make investments in order to customize a product for needs of a downstream buyer. After the investment is made and the product is adjusted, the buyer may refuse to meet a commitment and trigger ex post renegotiation. Since the product is customized to the buyer's needs, the supplier cannot sell the product to a different buyer at the original price. This is referred in the literature as the holdup problem. As a consequence, the individually rational suppliers will underinvest into relationship-specific assets, hurting the downstream firms with negative consequences for aggregate growth. The standard way to mitigate the hold up problem is to write a binding contract and to rely on the legal enforcement by the state. However, even the most effective contract enforcement might fail to protect the supplier in tough times when the buyer lacks a reliable source of external financing. This suggests the potential role of financial intermediaries, banks in particular, in mitigating the incomplete contract problem. First, financial products like letters of credit and letters of guarantee can substantially decrease a risk and transaction costs of parties. Second, a bank loan can serve as a signal about a buyer's true financial situation, an upstream firm will be more willing undertake relationship-specific investment knowing that the business partner is creditworthy and will abstain from myopic behavior (Fama, 1985; von Thadden, 1995). Therefore, a well-developed financial (especially banking) system should disproportionately benefit contract intensive industries.The empirical test confirms this hypothesis. Indeed, contract intensive industries seem to grow faster in countries with a well developed financial system. Furthermore, this effect comes from a more developed banking sector rather than from a deeper stock market. These results are reaffirmed examining the effect of US bank deregulation on the growth of contract intensive industries in different states. Beyond an overall pro-growth effect, the bank deregulation seems to disproportionately benefit the industries requiring relationship-specific investments from their suppliers.Chapter 2 of my PhD focuses on the role of the financial sector in promoting exports of developing countries. In particular, it investigates how credit constraints affect the ability of firms operating in agri-food sectors of developing countries to keep exporting to foreign markets.Trade in high-value agri-food products from developing countries has expanded enormously over the last two decades offering opportunities for development. However, trade in agri-food is governed by a growing array of standards. Sanitary and Phytosanitary standards (SPS) and technical regulations impose additional sunk, fixed and operating costs along the firms' export life. Such costs may be detrimental to firms' survival, "pricing out" producers that cannot comply. The existence of these costs suggests a potential role of credit constraints in shaping the duration of trade relationships on foreign markets. A well-developed financial system provides the funds to exporters necessary to adjust production processes in order to meet quality and quantity requirements in foreign markets and to maintain long-standing trade relationships. The products with higher needs for financing should benefit the most from a well functioning financial system. This differential effect calls for a difference-in-difference approach initially proposed by Rajan and Zingales (1998). As a proxy for demand for financing of agri-food products, the sanitary risk index developed by Jaud et al. (2009) is used. The empirical literature on standards and norms show high costs of compliance, both variable and fixed, for high-value food products (Garcia-Martinez and Poole, 2004; Maskus et al., 2005). The sanitary risk index reflects the propensity of products to fail health and safety controls on the European Union (EU) market. Given the high costs of compliance, the sanitary risk index captures the demand for external financing to comply with such regulations.The prediction is empirically tested examining the export survival of different agri-food products from firms operating in Ghana, Mali, Malawi, Senegal and Tanzania. The results suggest that agri-food products that require more financing to keep up with food safety regulation of the destination market, indeed sustain longer in foreign market, when they are exported from countries with better developed financial markets.Chapter 3 analyzes the link between financial markets and efficiency of resource allocation in an economy. Producing and exporting products inconsistent with a country's factor endowments constitutes a serious misallocation of funds, which undermines competitiveness of the economy and inhibits its long term growth. In this chapter, inefficient exporting patterns are analyzed through the lens of the agency theories from the corporate finance literature. Managers may pursue projects with negative net present values because their perquisites or even their job might depend on them. Exporting activities are particularly prone to this problem. Business related to foreign markets involves both high levels of additional spending and strong incentives for managers to overinvest. Rational managers might have incentives to push for exports that use country's scarce factors which is suboptimal from a social point of view. Export subsidies might further skew the incentives towards inefficient exporting. Management can divert the export subsidies into investments promoting inefficient exporting.Corporate finance literature stresses the disciplining role of outside debt in counteracting the internal pressures to divert such "free cash flow" into unprofitable investments. Managers can lose both their reputation and the control of "their" firm if the unpaid external debt triggers a bankruptcy procedure. The threat of possible failure to satisfy debt service payments pushes the managers toward an efficient use of available resources (Jensen, 1986; Stulz, 1990; Hart and Moore, 1995). The main sources of debt financing in the most countries are banks. The disciplining role of banks might be especially important in the countries suffering from insufficient judicial quality. Banks, in pursuing their rights, rely on comparatively simple legal interventions that can be implemented even by mediocre courts. In addition to their disciplining role, banks can promote efficient exporting patterns in a more direct way by relaxing credit constraints of producers, through screening, identifying and investing in the most profitable investment projects. Therefore, a well-developed domestic financial system, and particular banking system, would help to push a country's exports towards products congruent with its comparative advantage.This prediction is tested looking at the survival of different product categories exported to US market. Products are identified according to the Euclidian distance between their revealed factor intensity and the country's factor endowments. The results suggest that products suffering from a comparative disadvantage (labour-intensive products from capital-abundant countries) survive less on the competitive US market. This pattern is stronger if the exporting country has a well-developed banking system. Thus, a strong banking sector promotes exports consistent with a country comparative advantage.Chapter 4 of my PhD thesis further examines the role of financial markets in fostering efficient resource allocation in an economy. In particular, the allocative efficiency hypothesis is investigated in the context of equity market liberalization.Many empirical studies document a positive and significant effect of financial liberalization on growth (Levchenko et al. 2009; Quinn and Toyoda 2009; Bekaert et al., 2005). However, the decrease in the cost of capital and the associated growth in investment appears rather modest in comparison to the large GDP growth effect (Bekaert and Harvey, 2005; Henry, 2000, 2003). Therefore, financial liberalization may have a positive impact on growth through its effect on the allocation of funds across firms and sectors.Free access to international capital markets allows the largest and most profitable domestic firms to borrow funds in foreign markets (Rajan and Zingales, 2003). As domestic banks loose some of their best clients, they reoptimize their lending practices seeking new clients among small and younger industrial firms. These firms are likely to be more risky than large and established companies. Screening of customers becomes prevalent as the return to screening rises. Banks, ceteris paribus, tend to focus on firms operating in comparative-advantage sectors because they are better risks. Firms in comparative-disadvantage sectors finding it harder to finance their entry into or survival in export markets either exit or refrain from entering export markets. On aggregate, one should therefore expect to see less entry, more exit, and shorter survival on export markets in those sectors after financial liberalization.The paper investigates the effect of financial liberalization on a country's export pattern by comparing the dynamics of entry and exit of different products in a country export portfolio before and after financial liberalization.The results suggest that products that lie far from the country's comparative advantage set tend to disappear relatively faster from the country's export portfolio following the liberalization of financial markets. In other words, financial liberalization tends to rebalance the composition of a country's export portfolio towards the products that intensively use the economy's abundant factors.

Aging and the lateralization of oscillatory activities related to external and internal motor preparation

Selection of action may rely on external guidance or be motivated internally, engaging partially distinct cerebral networks. With age, there is an increased allocation of sensorimotor processing resources, accompanied by a reduced differentiation between the two networks of action selection. The present study examines the age effects on the motor-related oscillatory patterns related to the preparation of externally and internally guided movements. Thirty-two older and 30 younger adults underwent three delayed motor tasks with S1 as preparatory and S2 as imperative cue: Full, laterality instructed by S1 (external guidance); Free, laterality freely selected (internal guidance); None, laterality instructed by S2 (no preparation). Electroencephalogram (EEG) was recorded using 64 surface electrodes. Motor-Related Amplitude Asymmetries (MRAA), indexing the lateralization of oscillatory activities, were analyzed within the S1-S2 interval in the mu (9-12 Hz) and low beta (15-20 Hz) motor-related frequency bands. Reaction times to S2 were slower in older than younger subjects, and slower in the Free than in the Full condition in older subjects only. In the Full condition, there were significant mu MRAA in both age groups, and significant low beta MRAA only in older adults. The Free condition was associated with large mu MRAA in younger adults and limited low beta MRAA in older adults. In younger subjects, the lateralization of mu activity in both Full and Free conditions indicated effective external and internal motor preparation. In older subjects, external motor preparation was associated with lateralization of low beta in addition with mu activity, compatible with an increase of motor-related resources. In contrast, absence of mu and limited low beta lateralization in internal motor preparation was concomitant with reaction time slowing and suggested less efficient cerebral processes subtending free movement selection in older adults, indicating reduced capacity for internally driven action with age.

Iowa Comprehensive Annual Financial Report, 2005

In accordance with Iowa Code Section 8A.502(8) we are pleased to submit the Comprehensive Annual Financial Report (CAFR) for the State of Iowa for the fiscal year ended June 30, 2005. The report is presented in three sections as follows: • The Introductory Section includes this transmittal letter, the Government Finance Officers Association (GFOA) Certificate of Achievement for the fiscal year 2004 CAFR, an organizational chart of State government, and a list of principal State officials. • The Financial Section contains the independent auditor’s report on the Basic Financial Statements, Management’s Discussion and Analysis (MD&A), the Basic Financial Statements, and Notes to the Financial Statements. The Financial Section also contains Required Supplementary Information (RSI), other than the MD&A, and supplementary information in the form of combining financial statements and schedules. This letter is intended to be read in conjunction with the MD&A. • The Statistical Section highlights selected financial and demographic information, generally presented on a multi-year basis. The Department of Administrative Services is responsible for both the accuracy of the presented data, and the completeness and fairness of the presentation. We believe the information presented is accurate in all material respects and the necessary disclosures have been made which enable the reader to obtain an understanding of the State’s financial activity. This report has been prepared in accordance with U.S. generally accepted accounting principles (GAAP) for governments as promulgated by the Governmental Accounting Standards Board (GASB). As a part of the statewide accounting system upgrade during fiscal year 2005, the implementation team performed a comprehensive review of the adequacy of internal controls and budgetary controls of the system. The team determined that internal controls continue to be in place to provide reasonable, but not absolute, assurance that assets are safeguarded against unauthorized use or disposition, and that financial records from all appropriate sources are reliable for preparing financial statements and maintaining accountability. The concept of reasonable assurance recognizes the cost of internal controls should not exceed the benefits likely to be derived from their use. To monitor the adequacy of internal controls, the Auditor of State reviews internal control procedures as an integral part of departmental audits.