Financial Modeling for Decision Making : Using MS-Excel in Accounting and Finance /

This book provides accounting students in post-secondary institutions with an advanced level understanding of how to use MS-Excel to make business decisions. It reflects real-life applications of this important analytical tool, which has become the accepted industry standard for spreadsheet software...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Messer, Ron
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Bingley : Emerald Publishing, 2020.
Temas:
Account books.
Electronic spreadsheets.
Business enterprises > Finance.
Tableurs.
Financial accounting.
Business & Economics > Accounting > General.
Account books
Business enterprises > Finance
Electronic spreadsheets
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Intro
  • Half title page
  • Title page
  • Copyright page
  • Dedication
  • Contents
  • About the Author
  • Brief Summary
  • Preface
  • Chapter 1: Better Learning Decisions
  • How to Learn (and Teach) Financial Modeling
  • Learning Financial Modeling
  • Teaching Financial Modeling
  • Steps in Developing a Financial Model
  • Some Common Excel Terminology
  • Good Financial Modeling Practices4
  • Demonstration Exercise
  • Case Facts5
  • Part 1: Decisions Made about the Future
  • Planning
  • Chapter 2: Break Even Decisions
  • Background Theory
  • Cost-Volume-Profit Analysis
  • Determining Cost Functions
  • Break-even Volumes
  • Financial Management Techniques
  • Relevant MS-Excel Functionality
  • Demonstration Exercise
  • Case Facts
  • Chapter 3: Times Series Forecasting Decisions
  • Background Theory
  • Types of Forecasting Models
  • Detecting Patterns in Time
  • Time Series Forecasting Methods
  • Financial Management Techniques
  • Relevant Excel Functionality
  • Demonstration Exercise
  • Case Facts
  • Step 1: Create a Scatterplot to Assess whether a Pattern Exists
  • Step 2: Perform a Moving Average Forecast for at Least Three Time Intervals
  • Step 3: Perform an Exponential Smoothing Forecast Using at Least Two Dampening Factors
  • Step 4: Optimize the Exponential Smoothing Dampening Coefficient
  • Step 5: Calculate and Evaluate the MAPE for all Forecasts
  • Chapter 4: Capital Budgeting Decisions
  • Background Theory
  • The Importance of Cash Flows
  • NPV, IRR, and Payback Period
  • The Discount Rate
  • Financial Management Techniques
  • Relevant Excel Functionality
  • Demonstration Exercise
  • Case Facts
  • Step 1: Determining the Discount Rate Using a Risk-adjusted Cost of Capital
  • Step 2: Determining the Incremental Net Cash Flows for the Project
  • Step 3: Developing a Base Case Scenario for to the Key Decision Variables
  • Step 4: Determining the NPV, IRR and Payback Period for Each Scenario
  • Chapter 5: Regression Analysis Decisions
  • Background Theory
  • Finding Correlations
  • Determining Causation
  • Regression Analysis
  • Financial Management Techniques
  • Relevant Excel Functionality
  • Demonstration Exercise
  • Case Facts
  • Step 1: Exploring Relationships
  • Step 2: Creating Scatterplots
  • Step 3: Measuring Correlations
  • Step 4: Determine Dependent and Independent Variables
  • Step 5: Create a Single-variable Regression
  • Step 6: Create a Multivariable Regression
  • Step 7: Optimize the Model
  • Nonnumeric Variables
  • Interaction Variables
  • Part 2: Decisions Made about the Present
  • Control
  • Chapter 6: Linear Programming Decisions
  • Background Theory
  • Some History
  • Product Mix
  • Production Scheduling
  • Financial Management Techniques
  • Relevant Excel Functionality
  • Demonstration Exercise 1
  • Case Facts
  • Step 1: Create the Excel Worksheet Model
  • Step 2: Complete the Excel Solver Dialog Box

Ejemplares similares