Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
402
result(s) for
"Corporations -- Finance -- Computer programs"
Sort by:
Using Excel for business and financial modelling : a practical guide
\"A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling\"-- Provided by publisher.
Book
Using Excel for Business Analysis
Utilise Excel 2013 capabilities to build effective financial models Using Excel for Business Analysis, Revised Edition provides practical guidance for anyone looking to build financial models. Whether for business proposals, opportunity evaluation, financial reports, or any other business finance application, this book shows you how to design, create, and test your model, then present your results effectively using Excel 2013. The book opens with a general guide to financial modelling, with each subsequent chapter building skill upon skill until you have a real, working model of your own. Financial tools, features, and functions are covered in detail from a practical perspective, and put in context with application to real-world examples. Each chapter focuses on a different aspect of Excel modelling, including step-by-step instructions that walk you through each feature, and the companion website provides live model worksheets that give you the real hands-on practice you need to start doing your job faster, more efficiently, and with fewer errors. Financial modelling is an invaluable business tool, and Excel 2013 is capable of supporting the most common and useful models most businesses need. This book shows you how to dig deeper into Excel's functionality to craft effective financial models and provide important information that informs good decision-making. Learn financial modelling techniques and best practice Master the formulas and functions that bring your model to life Apply stress testing and sensitivity analysis with advanced conditionals Present your results effectively, whether graphically, orally, or written A deceptively powerful application, Excel supports many hundreds of tools, features, and functions; Using Excel for Business Analysis eliminates the irrelevant to focus on those that are most useful to business finance users, with detailed guidance toward utilisation and best practice.
eBook
Using Excel for business and financial modelling : a practical guide
A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the author's online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling.
eBook
Building financial models with microsoft excel
A comprehensive guide to building financial models Building Financial Models with Microsoft Excel + CD-ROM provides beginning or intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow readers to build their own financial models. This comprehensive resource also covers important topics such as the concept of valuation, the concept of sensitivity analysis, the concepts of contribution margin and financial ratios and the basics of building and using a Capitalization Table. K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider.
eBook
Using Excel for business and financial modelling
Cover -- Title Page -- Copyright -- Contents -- Preface -- Book Overview -- Acknowledgements -- Chapter 1 What is Financial Modelling? -- What's the Difference Between a Spreadsheet and a Financial Model? -- Types and Purposes of Financial Models -- Tool Selection -- Is Excel Really the Best Option? -- Evaluating Modelling Tools -- 32-Bit versus 64-Bit Microsoft Excel -- What Skills do You Need to be a Good Financial Modeller? -- Spreadsheet and Technical Excel Skills -- Industry Knowledge -- Accounting Knowledge -- Business Knowledge -- Aesthetic Design Skills -- Communication and Language Skills -- Numeracy Skills -- Ability to Think Logically -- The \"Ideal\" Financial Modeller -- What's the Typical Background for a Financial Modeller? -- Training Courses -- Summary -- Chapter 2 Building a Model -- Model Design -- Practical Example 1: Assumptions Layout -- Practical Example 2: Summary Categorisation -- The Golden Rules for Model Design -- Separate Inputs, Calculations, and Results, where Possible -- Use Each Column for the Same Purpose -- Use One Formula per Row or Column -- Refer to the Left and Above -- Use Multiple Worksheets -- Include Documentation Sheets -- Design Issues -- The Workbook Anatomy of a Model -- Workbook Anatomy Issues -- Project Planning Your Model -- How Long Does it Take to Build a Financial Model? -- Building a Model Under Pressure -- Model Layout Flowcharting -- Practical Exercise: Model Design Customer Support Pricing Model -- Steps to Building a Model -- The Streamlined Version -- The Team Version -- Information Requests -- Version-Control Documentation -- File Structure -- Summary -- Chapter 3 Best-Practice Principles of Modelling -- Document Your Assumptions -- Linking, Not Hardcoding -- Enter Data Only Once -- Avoid Bad Habits -- Use Consistent Formulas -- Format and Label Clearly.
Publication
Building Financial Models with Microsoft Excel
A comprehensive guide to building financial models Building Financial Models with Microsoft Excel + CD-ROM provides beginning or intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow readers to build their own financial models. This comprehensive resource also covers important topics such as the concept of valuation, the concept of sensitivity analysis, the concepts of contribution margin and financial ratios and the basics of building and using a Capitalization Table. K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider.
Publication