首页 >
财务 >
企业财务 >
Using Excel for Business and Financial Modelling: A Practical Guide

Using Excel for Business and Financial Modelling: A Practical Guide

作者： Danielle Stein Fairhurst
出版商： John Wiley & Sons
ISBN: 9781119520382
出版时间 April 2019
规格： Paperback , 416 pages
适应领域： International ? 免责申明：
Countri(es) stated herein are used as reference only

List Price: ￥697.50

￥676.58 Save ￥20.93 (3%)

或

下载订单表

加入收藏
| 加入比较

描述
大纲

详细

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.
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 Product Design

Design Issues

The Workbook Anatomy of a Model

Project Planning Your Model

Model Layout Flowcharting

Steps to Building a Model

Information Requests

Version-Control Documentation

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

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

Circular References

Summary

Chapter 5: Using Excel in Financial Modelling

Formulas and Functions in Excel

Excel Versions

Handy Excel Shortcuts

Cell Referencing Best Practices

Named Ranges

Basic Excel Functions

Logical Functions

Nesting Logical Functions

Summary

Chapter 6: Functions for Financial Modelling

Aggregation Functions

LOOKUP Functions

Nesting Index and Matching

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

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 a Cumulative Sum (Running 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

Adding Probability to a Data Table

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

Index

你可能需要


The Hong Kong Company Secretary's Handbook: Practice and Procedure (11th Edition): List Price: ￥497.55

￥482.62 Save ￥14.93 (3%)


Hong Kong Tax & Accounting Practical Toolkit (Basic Package): ￥3,161.07


Hong Kong Master Tax Guide 2024/25 (32nd Edition): List Price: ￥1,348.50

￥1,308.05 Save ￥40.46 (3%)


China Master Tax Guide 2021 (14th Edition): List Price: ￥1,562.40

￥1,515.53 Save ￥46.87 (3%)


Hong Kong Company Law & Compliance Practical Toolkit (Basic Package): ￥4,214.76


Hong Kong Company Secretary's Practice Manual, 5th Edition: List Price: ￥1,283.40

￥1,244.90 Save ￥38.50 (3%)


Hong Kong Directors' Manual, 5th Edition: List Price: ￥1,283.40

￥1,244.90 Save ￥38.50 (3%)


Hong Kong Financial Reporting Standards for SMEs (2nd Edition): List Price: ￥1,395.00

￥1,353.15 Save ￥41.85 (3%)


Hong Kong Listed Companies: Law and Practice, 2nd Edition: List Price: ￥1,841.40

￥1,786.16 Save ￥55.24 (3%)


China Master GAAP Guide (12th Edition): List Price: ￥1,395.00

￥1,353.15 Save ￥41.85 (3%)


A Concise Guide to Corporate Compliance Management (2nd Edition): List Price: ￥632.40

￥613.43 Save ￥18.97 (3%)


Wiley IFRS 2023: Interpretation and Application of IFRS Standards: List Price: ￥1,162.50

￥1,127.63 Save ￥34.88 (3%)


Hong Kong Company Secretary Checklist, 2nd Edition: List Price: ￥1,283.40

￥1,244.90 Save ￥38.50 (3%)


Hong Kong GAAP: A Master Guide to Financial Reporting Standards 2023 (17th Edition): List Price: ￥1,395.00

￥1,353.15 Save ￥41.85 (3%)


Taxation in Hong Kong: A Practical Guide 2023-2024 (9th Edition): List Price: ￥1,283.40

￥1,244.90 Save ￥38.50 (3%)

“

Ordering from Professional Bookshop is fantastic, quick delivery great products, great customer service Siti L.
This is a great bookstore and have had no problems with them and all my orders have come on time and in good condition. Yang X.
Everything is perfect. Fast delivery. I highly recommend this website to all my friends and colleagues. Thanks Hoi Man L.
So thankful I am receiving all my books, thank you to all for a great service and excellent products Clinton K.
Professional Bookshop is amazing! I've been a loyal customer for over 5 years. Returns are easy to request, book or delivery complaints are taken seriously and the customer service team is friendly and patient. Mick D.
I wanted to informed you that the customer service is excellent. They were so polite and nice. I would continue to buy books from Professional Bookshop. Jingsong C.
Fast and quick service. Easy transaction method, arrived sooner than expected. Excellent packaging and the books received are in perfect condition! Thank you very much! I love the book and its quality. Saori B.
I can order any accounting books from worldwide from Professional Bookshop. Love this website and save my time to search from internet. Lingxiao R.
It is just so easy to find what you are always looking for and sometimes you can even find it up to 80% off what you would in the normal store. Graeme R.
I love shopping on Professional Bookshop! They have a wide range of accounting book with competent prices. Free shipping in Hong Kong is also really handy! Fergus Y.
Professional Bookshop is a great bookstore, I must say. Buying books in Professional Bookshop is so easy, great and reliable. It is highly recommendable. Deborah D.
A great site to shop accounting books and everything and with discountable prices. It’s my first choice whenever i want to shop something. Most trusted site. Zeng Z.
I found the books I needed and at a very low price. I am very happy and will definitely use it in the future Brian W.
I have been using Professional Bookshop for a while now. I am very impressed with customer service and delivery. When I need to have a return it is done very diligently. Olivia L.
Professional Bookshop is my default go to for finding the best prices and reading details of law books before buying. Detailed book description is very helpful. Tracy W.
I've been using Professional Bookshop since 2011 and they actually great, I always received great service and my book arrives on time. Lisa C.

所有书籍

Using Excel for Business and Financial Modelling: A Practical Guide

Free delivery Hong Kong?

详细

你可能需要

What Our Customers Say?

所有书籍

Using Excel for Business and Financial Modelling: A Practical Guide

Free delivery Hong Kong?

详细

你可能需要

What Our Customers Say?

video title