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

A proven guide to building financial models from scratch The Second Edition of Building Financial Models with Microsoft Excel + CD-ROM provides beginning and intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel 2007-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow you to build your own financial models. This comprehensive resource also covers important topics such as the concepts of valuation, sensitivity analysis, and contribution margin. Offers accessible guidance on building financial models using Excel 2007 Illustrates how to integrate financial statements such as the balance sheet, income statement, and statement of cash flows Covers the basics of building and using a Capitalization Table Discusses how to best present a financial model Incorporating financial models into business decisions has become an essential element of good business practice, and this book will show you how to excel at this endeavor.

This guide for financial professionals helps in the full preparation of financial statements and management reports using Microsoft Excel, regardless of the size and complexity of the organization. Tips are provided on creating financial statements in a single workbook and presenting, printing, or mailing them on a monthly, quarterly, or annual basis, based on either a calendar or fiscal-year reporting system. Also discussed is how to analyze financial statements and create comparable five-year balance sheets and income statements as well as how to add graphs and ratio analysis pictures to cells. Advanced Excel features such as using the Pivot Table reports to analyze financial statements, summarize totals using running numbers, add percentages, and add quarterly calculations are also presented. Bonus CD-ROM includes: * Complete searchable eBook - easy to browse and print * Sample Financial Statements in Excel workbook file * Excel workbook files contain all data and formulas covered in the book * Additional bonus: A number of free Add-Ins

The content of the book is designed to be useful for people who have previously used earlier versions of Excel and for people who are discovering Excel for the first time, and the Excel version used in this book is Excel 2016. In other words, this book will boost your proficiency in using Excel and also help you to understand Windows, the operating system in which Excel runs to enable you to manage files correctly and also to control your printers. The book also describes the analysis of financial data and figures, summarizing the raw data into the alternative perspective of the same source information. Taking up a profession as an accountant, you will need to have a detailed understanding of how to interpret figures and also how to communicate these to the non-financial members of the management team where you work. This book further broadens your knowledge about the 'new' information discovered. This book is designed to teach and equip you with the necessary Excel skills that will help you become a professional spreadsheet user.The book is split into five sections so that it can be easily accessible, they are: Section One: Financial Statements CoreIn section five of Part 1 of this book, we introduced financial statements and went on further to elaborate and explain how to create a balance sheet from our Trial Balance data. In this section, we will discuss how to create an income statement from the Trial Balance data and cash flow statement from the Balance Sheet. We will then end this section with how to create a note worksheet.Section Two: Analyzing Financial Statements and PowerPoint IntroductionThis section includes analyzing financial statements and also calculating the ratio analysis based on the financial statement created in Part 1 and 2. It will also teach us how to analyze data from the trial balance adjusted in Part 1 and present it in our profit center. Lastly, it will introduce us to PowerPoint presentations.Section Three: Presenting the InformationThis section reviews and explains the PowerPoint menus in detail for us to get familiar with the functionalities of PowerPoint. It will further enlighten us about the PowerPoint report structure. Finally, we will look at how we can use the PowerPoint report structure to give a wonderful presentation with the ultimate slide show. In Part 3, We will look at how to hyperlink between PowerPoint and Excel.Section Four: Whatsits AnalysisThis section introduces us to Whatsits analysis and also how we can present the whatsit model report to management through appropriate report structures. It will also introduce us to the historical data that we are going to be analyzed in Section Five.Section Five: Presenting the Historical DataThis section analyses and broaden our knowledge about how to present the information in tables and charts so that it can be used for quick decision making and also for future reference. We will also look at the second stage of how we can present the historical data in the form of a unit table and then finalize it in the third stage. The tables and charts in this section would be used to prepare our Excel Reporting Dashboard in Part 3

Balance sheet analysis can reveal lot of important information about the company. A user of balance sheet if interpret the figures correctly can safeguard his interests and protect himself against creative accounting practices. · It is a snapshot of company’s assets, liabilities & equity on a given date. · It is used by management, investors, bankers, & creditors rating agencies to understand the financial health of a company. · It is the minimum requirement for availing credit facilities from banking system. · Users can interpret balance sheet to know the liquidity & leverage position of a company. · It is used by investors to compare with other companies and to find out stocks good for value investing. · It enables the credit providers to ascertain proper utilization of funds by the company. · It is used by regulators to ensure regulatory compliances. · It is used by private equity investors, venture capital funds to ascertain value of a company and to acquire stake at appropriate price. · It is used by top management to ascertain, if the company is moving in right direction or needs some course correction. In this book, author has tried to elaborate basic structure of balance sheet along with classification of assets and liabilities of a company. The book provides commonly used tools for interpretation of balance sheet information for use by bankers and investors.