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 financial functions are of great help to users who frequently use complex financial equations manually. Many a times, most of these complex equations or formulas can be replaced with the appropriate financial function. For exampleanbsp;...
|Title||:||Financial Modelling and Analysis Using Microsoft Excel - For Non Finance Personnel|
|Publisher||:||Lulu Press, Inc - 2015-07-19|