IES Management College And Research Centre

Image from Google Jackets

Understanding and analyzing balance sheets using excel worksheet

By: Analytics: Show analyticsPublication details: PHI Learning Private Limited 2015 New DelhiDescription: 256 p. PaperISBN:
  • 978-81-203-5107-3
Subject(s): DDC classification:
  • 657.3
Contents:
Contents: Preface • Acknowledgements 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 Test Banks Appendices I: Compounded Value of Rupee 1 II: 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 1 V: Present Value of Annuity of Rupee 1 VI: Continuous Compounding of Rupee 1 and Continuous Discounting of Rupee 1 Glossary • Index
Summary: Description: 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 www.aicte-india.org/modelsyllabus.php
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number Status Notes Date due Barcode Item holds
Book Book Main Library ON SHELF FINANCIAL 657.3/ Bod/ 31528 (Browse shelf(Opens below)) Available 11131528
Book's CD Book's CD Main Library Audio Visual REFERENCE N/B -3331526/ 31528 (Browse shelf(Opens below)) Not For Loan With Book 31528--CD Accession No. 2053 3331526
Total holds: 0

Contents:

Preface • Acknowledgements

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



Test Banks



Appendices



I: Compounded Value of Rupee 1

II: 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 1

V: Present Value of Annuity of Rupee 1

VI: Continuous Compounding of Rupee 1 and Continuous
Discounting of Rupee 1



Glossary • Index

Description:

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 www.aicte-india.org/modelsyllabus.php

There are no comments on this title.

to post a comment.

Circulation Timings: Monday to Saturday: 8:30 AM to 9:30 PM | Sundays/Bank Holiday during Examination Period: 10:00 AM to 6:00 PM