Create an inventory system! Calculate loan repayments! Handle a productionas limiting factors successfully! Work out customersa profitability! Yes, most of the above and much more can be achieved in Microsoft Excel if you understand some basic concepts of financial modelling and analysis. This book was written to help any users wanting to have a clear understanding of how Excel can help to perform some aspects of financial modelling and analysis using some of its built-in financial and logical functions. It goes further by elaborating detail exercises on the above. The book introduces the basic concepts of balance sheet, income statement and cash flow and builds the relevant models. Many books have been written on Excel. However, this book explains some advanced techniques for sensitivity analysis and features in a rather simplified manner with plenty of screen captures wherever possible. New users and existing users on Excel will find this book handy.Excela#39;s financialfunctions areof greathelpto userswho frequently use complex financial equations manually. ... An example of this is thecase of creditcard payments where the interest onthe account isnot applied until the perioda#39;s end ( noristheanbsp;...
|Title||:||Financial Modelling and Analysis using Microsoft Excel for non -finance personnel|
|Publisher||:||Blue Micro Solutions - 2014-07-01|