UNDERSTANDING AND ANALYZING BALANCE SHEETS USING EXCEL WORKSHEET

by J. RUZBEH BODHANWALA

Overview

This compact text presents the fundamental principles of accounting and finance using Excel® as a tool for preparing and analyzing Balance Sheets and Profit & Loss Statements. The book also helps in learning the basics of Excel® and different functions it provides to format financial statements.The Third Edition of this book emphasises on accounting ratios that have been explained in detail by using the Balance Sheet of Ingersoll Rand India Ltd. for the year ending March 2014.The author uses the Balance Sheet of Ingersoll Rand India Ltd. to help students relate accounting principles to real-life situations. The topics analyzed include day-to-day problems that managers encounter such as forecasting balance sheets, investments in stock markets, management of receivables and inventory, EMIs, cost of discounting schemes, and designing finance schemes to promote a new product.The book is accompanied by a CD-ROM which includes 92nd Annual Report of Ingersoll Rand India Ltd. and the exhibits given in Chapters 4 to 6.This updated edition will be useful primarily to postgraduate students pursuing courses in management and commerce disciplines. It will also be of immense help to the professionals indulged in model-building and developing a decision support system on Excel® worksheets.The book is recommended by AICTE for PGDM course. The link is aicte-india.org/modelsyllabus.php

Product Details

ISBN-13:	9788120351073
Publisher:	PHI Learning
Publication date:	05/01/2015
Sold by:	Barnes & Noble
Format:	eBook
File size:	9 MB

About the Author

Ruzbeh J. Bodhanwala [Ph.D., MBA (Finance), M.Com (ABST)] has long experience in academics, research and industry. He regularly contributes articles to reputed journals in India and has successfully conducted management development programmes for executives.Dr. Bodhanwala is at present engaged as a trainer on accounting and business valuation with a multinational conglomerate (Bangalore). He has also served on the faculty of FORE School of Management (New Delhi) and Banasthali (Rajasthan). He has worked with GENPACT as finance and valuation trainer. His areas of interest and specialization include financial management, management accounting, financial modeling and equity valuations.

Table of Contents

Preface • Acknowledgements1. Basic Facts2. Basics of Accounting3. Basic Tools of Balance Sheet Analysis4. Use of Excel in Analyzing the Balance Sheet5. Basics of Finance6. Analyzing Balance Sheet of Ingersoll Rand India Ltd. with Excel Spreadsheet7. Managers’ Biggest ConcernsTest BanksAppendicesI: Compounded Value of Rupee 1II: Compounded Value of Annuity of Rupee 1 (Assuming Rupee to be Invested at the End of the Year)III: Compounded Value of Annuity of Rupee 1 (Assuming Rupee to be Invested at the Beginning of the Year)IV: Present Value of Rupee 1V: Present Value of Annuity of Rupee 1VI: Continuous Compounding of Rupee 1 and ContinuousDiscounting of Rupee 1Glossary • Index