Using Excel for Business Anaysis: A Guide to Financial Modelling Fundamentals by DANIELLE STEIN FAIRHURST

1 BOOKS FOUND ON YOUR SEARCH.

Using Excel for Business Anaysis: A Guide to Financial Modelling Fundamentals

by DANIELLE STEIN FAIRHURST

Qty :

Price : $ ~~11.41~~
Your Price : $ 10.27
You Save : $ 1.14 (10%)
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. Preface 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 What Skills Do You Need to Be a Good Financial Modeller? The Ideal Financial Modeller Summary Chapter � 2: Building a Model Model Design The Golden Rules for Model Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flow Charting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter � 3: Best Practice Principles of Modelling Document Your Assumptions Linking, Not Hard Coding Enter Data Only Once Avoid Bad Habits Use Consistent Formulas Format and Label Clearly Methods and Tools of Assumptions Documentation Linked Dynamic Text Assumptions Documentation What Makes a Good Model? Summary Chapter � 4: Financial Modelling Techniques The Problem with Excel Error Avoidance Strategies How Long Should a Formula Be? Linking to External Files Building Error Checks Summary Chapter � 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Basic Excel Functions Logical Functions Nesting: Combining Simple Functions to Create Complex Formulas Cell Referencing Best Practices Named Ranges Summary Chapter � 6: Functions for Financial Modelling Aggregation Functions LOOKUP Formulas Nesting INDEX and MATCH OFFSET Function Regression Analysis CHOOSE Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter =- 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter � 8:Tools for Financial Modelling Hiding Sections of a Model Grouping Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter � 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating Cumulative Totals How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter � 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix :QA Log Chapter � 11: Stress-Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What Are the Differences between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Summary Chapter � 12: Presenting Model Output Preparing an Oral Presentation for Model Results Preparing a Graphic or Written Presentation for Model Results Chart Types Working with Charts Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary About the Author About the Website Index ISBN - 9788126555390

Pages : 440

Untitled Document

Some More Books of Similar Interest

Standard Methods for the Examination of Water and Wastewater, 24th Edition by William C. Lipps, Ellen Burton Braun-Howland, Terry E. Baxter	Electronics (Hindi) by Vijay S. K.	Crystallography Applied to Solid State Physics by Verma, A.R.
Quantum Mechanics by Thankappan, V.K.	Laser Systems and Applications (All India) by Srivastava, S.K.	Laser Systems and Applications (AKTU) by Srivastava, S.K.

If you didn't find any required book(s),
Please mail us the details we will find it for you through our resources.
Kindly click here to send your requirement now.

OR

You may try advance search through below given search window.

Untitled Document

   Tips to get best Search results:
   1. Carefully check the spellings of words typed in the search box.
   2. Type one word in Search box to get better results.
   eg. for searching a book "Sikhism in India" just type sikhism in search box.
   3. Do not use Phrases to search a book like "Books on art of Himachal Pradesh".
   Just search for "art of Himachal Pradesh".
   4. To search a book on author, choose author in drop down menu given above
    search window before pressing Submit button.