Ruzbeh J. Bodhanwala

Understanding and Analyzing Balance Sheets uisng Excel Worksheets - 1st ed. - New Delhi PHI 2015 - 236 1 CD ROM

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.

1. Basic Facts

2. Basics of Accounting

3. Basic Tools of Balance Sheet Analysis

4. Use of Excel in Analyzing the Balance Sheet

5. Basics of Finance

6. Analyzing Balance Sheet of Ingersoll Rand India Ltd. with Excel Spreadsheet

7. Managers’ Biggest Concerns


9788120351073


Financial statements

657.3 R949 U / 103532