Basic finance made accessible in Excel 2007 : "the big 5, plus 2"

The basic principles and equations are developed for elementary finance, based on the concept of compound interest. The five quantities of interest in such problems are present value, future value, amount of periodic payment, number of periods and the rate of interest per period. We consider three distinct means of computing each of these five quantities in Excel 2007: (i) use of algebraic equations, (ii) by recursive schedule and the Goal Seek facility, and (iii) use of Excel's intrinsic financial functions. The paper is intended to be used as the basis for a lesson plan and contains many examples and solved problems. Comment is made regarding the relative difficulty of each approach, and a prominent theme is the systematic use of more than one method to increase student understanding and build confidence in the answer obtained. Full instructions to build each type of model are given and a complete set of examples and solutions may be downloaded (Examples.xlsx and Solutions.xlsx).

Teaching basic finance with Excel, and without pain

The five quantities of interest in elementary finance problems are present value, future value, amount of periodic payment, number of periods and the rate of compound interest per period. A recursive approach to computing each of these five quantities in a modern version of Excel, for the case of ordinary annuities, is described. The aim is to increase student understanding and build confidence in the answer obtained, and this may be achieved with only linear relationships and in cases where student knowledge of algebra is essentially zero. Annuity problems may be solved without use of logarithms and black-box intrinsic functions; these being used only as check mechanisms. The author has had success with the method at Bond University and surrounding high schools in Queensland, Australia.

Public Finance for REDD+ in Kenya

Kenya aims to prepare for both public and private Reduced Emission from Deforestation and Degradation (REDD+) investment flows. This chapter examines how current Kenyan law can be used as a starting point for building a regulatory regime to support public sector finance. For present purposes, ‘public sector finance’ is defined as money flowing from multilateral international institutions and bi-lateral donor funds. Key issues addressed by this chapter • The nature and form of public sector finance for REDD+ in Kenya. • The management and laws relating to public funds in Kenya; • Mechanisms that can be utilised to manage risk associated with REDD+ investments with a focus on Kenyan anti-corruption laws and policies; • The regulatory regime for distributing the benefits from REDD+ investment to relevant forest stakeholders.

How does access to development finance shape our cities?

In market economies the built environment is largely the product of private sector property development. Property development is a high-risk entrepreneurial activity executing expensive projects with long gestation periods in an uncertain environment and into an uncertain future. Risk lies at the core of development: the developer manages the multiple risks of development and it is the capital injection and financing that is placed at risk. From the developer's perspective the search for development capital is a quest: to access more finance, over a longer term, with fewer conditions and at lower rates. From the supply angle, capital of various sources - banks, insurance companies, superannuation funds, accumulated firm profits, retail investors and private equity - is always seeking above market returns for limited risk. Property development presents one potentially lucrative, but risky, investment opportunity. Competition for returns on capital produces a continual dynamic evolution of methods for funding property developments. And thus the relationship between capital and development and the outcomes for the built environment are in a restless continual evolution. Little is documented about the ways development is financed in Australia and even less of the consequences for cities. Using publicly available data sources and examples of different development financing from Australian practice, this paper argues that different methods of financing development have different outcomes and consequences for the built environment. This paper also presents an agenda for further research into these themes.

The case for unitary taxation with formulary apportionment in the finance sector and the effect on developing nations

In 2013 the OECD released its 15 point Action plan to deal with base erosion and profit shifting (BEPS). In that plan it was recognised that BEPS has a significant effect on developing countries. This is because the lack of tax revenue can lead to a critical underfunding of public investment that would help promote economic growth. To this end, the BEPS project is aimed at ensuring an inclusive approach to take into account not only views of the G20 and OECD countries but also the perspective of developing nations. With this focus in mind and in the context of developing nations, the purpose of this article is to consider a possible solution to profit shifting which occurs under the current transfer pricing regime, with that solution being unitary taxation with formulary apportionment. It does so using the finance sector as a specific case for application. Multinational financial institutions (MNFIs) play a significant role in financing activities of their clients in developing nations. Consistent with the ‘follow-the-client’ phenomenon which explains financial institution expansion, these entities are increasingly profiting from activities associated with this growing market. Further, not only are MNFIs persistent users of tax havens but also, more than other industries, have opportunities to reduce tax through transfer pricing measures. This article establishes a case for an industry specific adoption of unitary taxation with formulary apportionment as a viable alternative to the current regime. It argues that such a model would benefit not only developed nations but also developing nations which are currently suffering the effects of BEPS. In doing so, it considers the practicalities of such an implementation by examining both definitional issues and a possible formula for MNFIs. This article argues that, while there would be implementation difficulties to overcome, the current domestic models of formulary apportionment provide important guidance as to how the unitary business and business activities of MNFIs should be defined as well as factors that should be included in an allocation formula, along with the appropriate weighting. While it would be difficult for developing nations to adopt such a regime, it is argued that it would be no more difficult than addressing issues they face with the current transfer pricing regime. As such, this article concludes that unitary taxation with formulary apportionment is a viable industry specific alternative for MNFIs which would assist developing nations and aid independent fiscal soundness.

Unitary Taxation of the Finance Sector

Multinational financial institutions (MNFIs) play a significant role in financing the activities of their clients in developing nations. Consistent with the ‘follow-the-customer’ phenomenon which explains financial institution expansion, these entities are increasingly profiting from activities associated with this growing market. However, not only are MNFIs persistent users of tax havens, but also, more than other industries, have the opportunity to reduce tax through transfer pricing measures. This paper establishes a case for an industry-specific adoption of unitary taxation with formulary apportionment as a viable alternative to the current regime. In doing so, it considers the practicalities of implementing this by examining both definitional issues and possible formulas for MNFIs. This paper argues that, while there would be implementation difficulties to overcome, the current domestic models of formulary apportionment provide important guidance as to how the unitary business and business activities of MNFIs should be defined, as well as the factors that should be included in an allocation formula, and the appropriate weighting. This paper concludes that unitary taxation with formulary apportionment is a viable industry-specific alternative for MNFIs.

Social organization of household finance: Understanding artful financial systems in the home

In this paper we discuss results of a field study focused on understanding the ways money and financial issues are handled within family settings. Families develop ‘systems’ or methods through which they coordinate and manage their everyday financial activities. Through an analysis of our fieldwork data collected from fifteen families, we provide several examples of such systems, highlighting their qualities and illustrating how such systems come to support the handling of financial activities in the home. Our results show that these systems are developed with a careful consideration of familial values, relationships and routines; and incorporate the use of physical and digital tools. Consequently, we suggest that design should consider the use and non-use of technology when supporting household financial management, taking into account the richness of families’ existing organically formed practices surrounding financial systems. Finally, our findings point to the fact that financial management in the domestic setting is socially organized and is closely connected to supporting everyday household activities.

Studies on Binary Time Series Models with Applications to Empirical Macroeconomics and Finance

This thesis studies binary time series models and their applications in empirical macroeconomics and finance. In addition to previously suggested models, new dynamic extensions are proposed to the static probit model commonly used in the previous literature. In particular, we are interested in probit models with an autoregressive model structure. In Chapter 2, the main objective is to compare the predictive performance of the static and dynamic probit models in forecasting the U.S. and German business cycle recession periods. Financial variables, such as interest rates and stock market returns, are used as predictive variables. The empirical results suggest that the recession periods are predictable and dynamic probit models, especially models with the autoregressive structure, outperform the static model. Chapter 3 proposes a Lagrange Multiplier (LM) test for the usefulness of the autoregressive structure of the probit model. The finite sample properties of the LM test are considered with simulation experiments. Results indicate that the two alternative LM test statistics have reasonable size and power in large samples. In small samples, a parametric bootstrap method is suggested to obtain approximately correct size. In Chapter 4, the predictive power of dynamic probit models in predicting the direction of stock market returns are examined. The novel idea is to use recession forecast (see Chapter 2) as a predictor of the stock return sign. The evidence suggests that the signs of the U.S. excess stock returns over the risk-free return are predictable both in and out of sample. The new "error correction" probit model yields the best forecasts and it also outperforms other predictive models, such as ARMAX models, in terms of statistical and economic goodness-of-fit measures. Chapter 5 generalizes the analysis of univariate models considered in Chapters 2 4 to the case of a bivariate model. A new bivariate autoregressive probit model is applied to predict the current state of the U.S. business cycle and growth rate cycle periods. Evidence of predictability of both cycle indicators is obtained and the bivariate model is found to outperform the univariate models in terms of predictive power.

International Climate Finance and its Influence on Fairness and Policy

27 p.