Cargando…

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:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000 i 4500
001 on1190855153
003 OCoLC
005 20231005004200.0
006 m o d
007 cr |n|||||||||
008 200828t20202020enk o 000 0 eng d
040 |a YDX  |b eng  |e rda  |e pn  |c YDX  |d N$T  |d EBLCP  |d UKMGB  |d YDXIT  |d OCLCF  |d UKAHL  |d LUN  |d OCLCQ  |d CACAP  |d OCLCO  |d OCLCQ 
015 |a GBC0A9980  |2 bnb 
016 7 |a 019878582  |2 Uk 
019 |a 1195456331 
020 |a 9781789734133  |q (electronic book) 
020 |a 1789734134  |q (electronic book) 
020 |a 9781789734157  |q (electronic book) 
020 |a 1789734150  |q (electronic book) 
020 |z 1789734142 
020 |z 9781789734140 
029 1 |a AU@  |b 000068214044 
029 1 |a UKMGB  |b 019878582 
029 1 |a AU@  |b 000067937275 
029 1 |a AU@  |b 000073962644 
035 |a (OCoLC)1190855153  |z (OCoLC)1195456331 
037 |a 9781789734157  |b Emerald Publishing 
050 4 |a HF5680  |b .M47 2020 
080 |a 657 
082 0 4 |a 657/.2  |2 23 
049 |a UAMI 
100 1 |a Messer, Ron. 
245 1 0 |a Financial Modeling for Decision Making :  |b Using MS-Excel in Accounting and Finance /  |c Ron Messer. 
264 1 |a Bingley :  |b Emerald Publishing,  |c 2020. 
264 4 |c Ã2020 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
505 0 |a 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 
505 8 |a 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 
505 8 |a 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 
505 8 |a 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 
505 8 |a 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 
520 |a 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. 
588 0 |a Online resource; title from digital title page (viewed on September 28, 2020). 
508 |a Produced by the publisher. 
508 |a Held by CAPER-BC, Langara College. 
590 |a Emerald Insight  |b Emerald All Book Titles 
650 0 |a Account books. 
650 0 |a Electronic spreadsheets. 
650 0 |a Business enterprises  |x Finance. 
650 6 |a Tableurs. 
650 7 |a Financial accounting.  |2 bicssc 
650 7 |a Business & Economics  |x Accounting  |x General.  |2 bisacsh 
650 7 |a Account books  |2 fast  |0 (OCoLC)fst00795342 
650 7 |a Business enterprises  |x Finance  |2 fast  |0 (OCoLC)fst00842558 
650 7 |a Electronic spreadsheets  |2 fast  |0 (OCoLC)fst00907463 
776 0 8 |i Print version:  |z 1789734142  |z 9781789734140  |w (OCoLC)1153040423 
856 4 0 |u https://emerald.uam.elogim.com/insight/publication/doi/10.1108/9781789734133  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n AH37386735 
938 |a Askews and Holts Library Services  |b ASKH  |n AH37386733 
938 |a ProQuest Ebook Central  |b EBLB  |n EBL6317388 
938 |a EBSCOhost  |b EBSC  |n 2446816 
938 |a YBP Library Services  |b YANK  |n 16907761 
994 |a 92  |b IZTAP