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.

Investment strategies in retirees' decumulation phase

This thesis consists of three studies on investment strategies for Australian retirees. Specifically, it investigates retirees' preference between alternative drawdown strategies in the presence of government pensions, appropriate management of longevity risk through the use of deferred annuities and asset allocation in retirement. It finds drawdown strategies linked to life expectancy to be the best performers. Deferred annuities are found to improve retirement incomes for risk averse retirees. For retirees who want to meet certain wealth thresholds in retirement, equity dominated portfolios provide superior outcomes for higher threshold levels.