UNDERSTANDING AND ANALYZING BALANCE SHEETS USING EXCEL WORKSHEET

UNDERSTANDING AND ANALYZING BALANCE SHEETS USING EXCEL WORKSHEET

Author: J. RUZBEH BODHANWALA

Publisher: PHI Learning Pvt. Ltd.

Published: 2015-05-01

Total Pages: 249

ISBN-13: 812035107X

DOWNLOAD EBOOK

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


Business Analysis with Microsoft Excel

Business Analysis with Microsoft Excel

Author: Conrad George Carlberg

Publisher: Que Publishing

Published: 2002

Total Pages: 510

ISBN-13: 9780789725523

DOWNLOAD EBOOK

Take control of the bottom line using expert techniques and Excel's powerful financial capabilities! Whether you own a small business or work for a large corporation; whether you are looking for help making financial and business decisions -- this book is for you. Business Analysis with Microsoft Excel, Second Editionprovides in-depth information that will maximize your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions.


Corporate Financial Analysis with Microsoft Excel

Corporate Financial Analysis with Microsoft Excel

Author: Francis J. Clauss

Publisher: McGraw Hill Professional

Published: 2009-08-23

Total Pages: 529

ISBN-13: 0071628843

DOWNLOAD EBOOK

Corporate Financial Analysis with Microsoft® Excel® visualizes spreadsheets as an effective management tool both for financial analysis and for coordinating its results and actions with marketing, sales, production and service operations, quality control, and other business functions. Taking an integrative view that promotes teamwork across corporate functions and responsibilities, the book contains dozens of charts, diagrams, and actual Excel® screenshots to reinforce the practical applications of every topic it covers. The first two sections—Financial Statements and Cash Budgeting—explain how to use spreadsheets for: Preparing income statements, balance sheets, and cash flow statements Performing vertical and horizontal analyses of financial statements Determining financial ratios and analyzing their trends and significance Combining quantitative and judgmental techniques to improve forecasts of sales revenues and customer demands Calculating and applying the time value of money Managing inventories, safety stocks, and the allocation of resources The third and final section—Capital Budgeting—covers capital structure, the cost of capital, and leverage; the basics of capital budgeting, including taxes and depreciation; applications, such as new facilities, equipment replacement, process improvement, leasing versus buying, and nonresidential real estate; and risk analysis of capital budgets and the potential impacts of unforeseen events. Corporate Financial Analysis with Microsoft® Excel® takes a broad view of financial functions and responsibilities in relation to those of other functional parts of modern corporations, and it demonstrates how to use spreadsheets to integrate and coordinate them. It provides many insightful examples and case studies of real corporations, including Wal- Mart, Sun Microsystems, Nike, H. J. Heinz, Dell, Microsoft, Apple Computer, and IBM. Corporate Financial Analysis with Microsoft® Excel® is the ideal tool for managing your firm’s short-term operations and long-term capital investments.


Principles of Accounting Volume 1 - Financial Accounting

Principles of Accounting Volume 1 - Financial Accounting

Author: Mitchell Franklin

Publisher:

Published: 2019-04-11

Total Pages: 1056

ISBN-13: 9781680922912

DOWNLOAD EBOOK

The text and images in this book are in grayscale. A hardback color version is available. Search for ISBN 9781680922929. Principles of Accounting is designed to meet the scope and sequence requirements of a two-semester accounting course that covers the fundamentals of financial and managerial accounting. This book is specifically designed to appeal to both accounting and non-accounting majors, exposing students to the core concepts of accounting in familiar ways to build a strong foundation that can be applied across business fields. Each chapter opens with a relatable real-life scenario for today's college student. Thoughtfully designed examples are presented throughout each chapter, allowing students to build on emerging accounting knowledge. Concepts are further reinforced through applicable connections to more detailed business processes. Students are immersed in the "why" as well as the "how" aspects of accounting in order to reinforce concepts and promote comprehension over rote memorization.


MANAGERIAL ECONOMICS, Third Edition

MANAGERIAL ECONOMICS, Third Edition

Author: NADAR, E. NARAYANAN

Publisher: PHI Learning Pvt. Ltd.

Published: 2020-06-01

Total Pages: 367

ISBN-13: 9387472809

DOWNLOAD EBOOK

Managerial Economics has assumed a predominant role in today's globalized and liberalized economy because of the financial implications of many decisions that a manager has to take in his day-to-day professional life. This comprehensive and student-friendly book strives to equip the young, practising and budding managers to find solutions to the real-world problems through the efficient and effective use of economic tools and techniques. The authors who admirably combine academic and professional experience give a clear and straightforward analysis of the various topics in managerial economics. The text begins with an overview of managerial economics and describes the modern business firm and its objectives along with the concepts of market mechanism, demand theory and production analysis. The text then moves further to explain managerial techniques, macroeconomic theory and international trade and finance along with the risks and uncertainties involved in business. Besides, it also explains the cost and revenue, supply, pricing, profit and investment analyses. Finally, this book discusses some important Case Studies to reinforce the concepts presented in the text. The third edition of the book comprises multiple choice questions (with answers) at the end of each chapter to test the understanding of the concepts discussed in the chapter. Besides, the objectives, strategies and initiatives of the twelfth five year plan (2012–2017) of Planning Commission as well as a new section on Replacement of Indian Planning Commission with NITI Aayog have been incorporated in the chapter on Macroeconomic Analysis. Intended as a text for postgraduate students of Management, Commerce and Economics, the book would also be useful for undergraduate engineering courses where Managerial Economics is offered. Finally, the book can be profitably used by marketing and management consultants, business executives and other related professionals. KEY FEATURES • Includes several simple, numerical examples with solutions for easy understanding of theory. • Contains a large number of tables and figures to illustrate the concepts. • Provides chapter-end exercises to check students' comprehension of the subject. TARGET AUDIENCE • MBA • M.Com • M.A. Economics


MANAGEMENT ACCOUNTING, THIRD EDITION

MANAGEMENT ACCOUNTING, THIRD EDITION

Author: SINGHVI, N. M.

Publisher: PHI Learning Pvt. Ltd.

Published: 2018-08-01

Total Pages: 440

ISBN-13: 9387472949

DOWNLOAD EBOOK

The third edition of the book, on the lines of the previous editions, provides a thorough and updated study of the text and cases extracted from the real-life shop floors. This comprehensive text gives an in-depth analysis of the fundamental concepts, principles and conventions of accounting. It further dwells onto the topics like reading of annual report, notes to the accounts, shareholding patterns and analysis using ratios, common size statements, trend analysis, in detail. The theory is flawlessly combined with the practical elements taken from the top-notch multinational companies of the country to provide the students an analytical insight into the current market scenario. NEW TO THE THIRD EDITION  Incorporates a new chapter on 'Introduction to IFRS and Ind AS'.  Presents two caselets at the end of chapter on 'Depreciation, Reserves and Provisions'.  Completely revamped chapter on 'Tools of Balance Sheet Analysis'.  Comprises updated sections, and recent cash flow statements, balance sheets as well as fund flow statements, wherever required.  Contains updated Appendix 1 on 'Balance Sheet Abstract of Ingersoll Rand India Ltd. for the Year Ending 2017'. TARGET AUDIENCE • B.Com • BBA • M.Com • MBA/PGDM


Understanding Financial Accounts

Understanding Financial Accounts

Author: OECD

Publisher: OECD Publishing

Published: 2017-11-06

Total Pages: 424

ISBN-13: 9264281282

DOWNLOAD EBOOK

Understanding Financial Accounts seeks to show how a range of questions on financial developments can be answered with the framework of financial accounts and balance sheets, by providing non-technical explanations illustrated with practical examples.


How to Read a Balance Sheet: The Bottom Line on What You Need to Know about Cash Flow, Assets, Debt, Equity, Profit...and How It all Comes Together

How to Read a Balance Sheet: The Bottom Line on What You Need to Know about Cash Flow, Assets, Debt, Equity, Profit...and How It all Comes Together

Author: Rick Makoujy

Publisher: McGraw Hill Professional

Published: 2010-04-29

Total Pages: 209

ISBN-13: 0071703446

DOWNLOAD EBOOK

Put the most valuable business tool to work for you! The balance sheet is the key to everything--from efficient business operation to accurate assessment of a company’s worth. It’s a critical business resource--but do you know how to read it? How to Read a Balance Sheet breaks down the subject into easy-to-understand components. If you're a business owner or manager, this book helps you . . . Manage working capital Generate higher returns on assets Maximize your inventory dollars Evaluate investment opportunities If you're an investor, this book helps you . . . Determine the market value of a company's assets and operations Predict future earnings and trends Assess the impact of capital expenditures Identify potential "red flags" before the crowd How to Read a Balance Sheet gives you the bottom line of what you need to know about: Cash Flow * Assets * Debt * Equity * Profit and how it all comes together.


ACCOUNTING FOR MANAGERS

ACCOUNTING FOR MANAGERS

Author: JELSY JOSEPH KUPPAPALLY

Publisher: PHI Learning Pvt. Ltd.

Published: 2008-08-08

Total Pages: 632

ISBN-13: 9788120333185

DOWNLOAD EBOOK

Decision-making is a pivotal function of any manager. A knowledge of Accounting, insofar as it affects decision-making, is very important for a manager. And very often, students find Accounting as one of the ‘tough’ subjects to handle. This book strives to make Accounting intelligible and easily comprehensible to students. The text gives a comprehensive coverage of the three branches of Accounting – Financial Accounting, Management Accounting, and Cost Accounting. It focuses on the various methods and techniques followed in the Management Reporting System. The text deals, in detail, with various accounting transaction procedures, methods of costing, ratio analysis, budgeting, forecasting, accounting errors, funds flow and cash flow statements, trial balance and balance sheet, and so on. It equips the students with the knowledge in the preparation, analysis, evaluation, and interpretation of financial statements, which will enrich their managerial competence and decision-making skills. KEY FEATURES  Emphasises the various accounting and decision-making techniques.  Provides a number of problems and their solutions, besides giving notes, working notes, and exercises, to help the students understand the concepts better. This book is intended as a text for the postgraduate students of Management (MBA/MIB), financial courses (MFC), and undergraduate and postgraduate students of Commerce and those pursuing MCA. In addition, the book will be very useful to practising managers who wish to develop effective and result-oriented decision-making skills.