• Business & Economics

Corporate Financial Analysis with Microsoft Excel


Author: Francis Clauss
Publisher: McGraw Hill Professional
ISBN: 0071628843
Category: Business & Economics
Page: 512
View: 9756
Corporate Financial Analysis with Microsoft® Excel® visualizes spreadsheets as an effective management tool both for financial analysis and for coordinating its results and actions with marketing, sales, production and service operations, quality control, and other business functions. Taking an integrative view that promotes teamwork across corporate functions and responsibilities, the book contains dozens of charts, diagrams, and actual Excel® screenshots to reinforce the practical applications of every topic it covers. The first two sections— Financial Statements and Cash Budgeting— explain how to use spreadsheets for: Preparing income statements, balance sheets, and cash flow statements Performing vertical and horizontal analyses of financial statements Determining financial ratios and analyzing their trends and significance Combining quantitative and judgmental techniques to improve forecasts of sales revenues and customer demands Calculating and applying the time value of money Managing inventories, safety stocks, and the allocation of resources The third and final section—Capital Budgeting— covers capital structure, the cost of capital, and leverage; the basics of capital budgeting, including taxes and depreciation; applications, such as new facilities, equipment replacement, process improvement, leasing versus buying, and nonresidential real estate; and risk analysis of capital budgets and the potential impacts of unforeseen events. Corporate Financial Analysis with Microsoft® Excel® takes a broad view of financial functions and responsibilities in relation to those of other functional parts of modern corporations, and it demonstrates how to use spreadsheets to integrate and coordinate them. It provides many insightful examples and case studies of real corporations, including Wal- Mart, Sun Microsystems, Nike, H. J. Heinz, Dell, Microsoft, Apple Computer, and IBM. Corporate Financial Analysis with Microsoft® Excel® is the ideal tool for managing your firm’s short-term operations and long-term capital investments.

    • Business & Economics

Financial Analysis with Microsoft Excel 2016, 8E


Author: Timothy R. Mayes,Todd M. Shank
Publisher: Cengage Learning
ISBN: 1337298042
Category: Business & Economics
Page: 50
View: 6140
Taking your spreadsheet skills to the next level, Mayes/Shank's FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2016, 8E, equips you with a solid foundation in corporate finance while helping you master the tools professionals use every day. It delivers thorough coverage of financial statements, cash budgets, time series forecasting, the Security Market Security Line, pro forma financial statements, cost of capital, VBA programming, Pivot Tables, and Get & Transform tools (formerly known as Power Query). With its unique self-directed learning approach, this reader-friendly book is an ideal resource for independent learning and a valuable reference tool. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

    • Business & Economics

Building Financial Models with Microsoft Excel

A Guide for Business Professionals
Author: K. Scott Proctor
Publisher: John Wiley and Sons
ISBN: 9780470561454
Category: Business & Economics
Page: 352
View: 3788

    • Business & Economics

Financial Analysis and Modeling Using Excel and VBA


Author: Chandan Sengupta
Publisher: John Wiley & Sons
ISBN: 047027560X
Category: Business & Economics
Page: 793
View: 5376
Provides a comprehensive guide for anyone who has to undertake financial analysis, or understand and implement financial models. Discusses a wide range of real-world financial problems and models using Excel 2007 and Visual Basic for Applications (VBA). Provides reference to earlier versions of Excel and VBA, and includes a CD-Rom with modelling tools and working versions of models discussed.

    • Business & Economics

Mastering Financial Modelling in Microsoft Excel 3rd edn

A Practitioner's Guide to Applied Corporate Finance
Author: Alastair Day
Publisher: Pearson UK
ISBN: 0273772341
Category: Business & Economics
Page: 520
View: 2839
Comprehensive tools and methods to help you build, develop and apply financial models using Microsoft Excel, enabling you to get better, more accurate results, faster. The new edition of this bestselling title begins by explaining basic modelling techniques before moving through to more complex models. The book is divided into two parts: the first part outlines model designs and gives templates, key features and techniques. The second part of the book shows how to build corporate financial models in Excel. This new edition includes a reworking of the book in Excel 2010 (but with older material still included), inclusion of Apple Mac, addition of specific 2010 features and end of chapter exercises. If you are buying the ebook, companion files can be downloaded from the digital downloads section of http://www.financial-models.com/.

    • Business & Economics

Using Excel for Business Analysis

A Guide to Financial Modelling Fundamentals
Author: Danielle Stein Fairhurst
Publisher: John Wiley & Sons
ISBN: 1119062462
Category: Business & Economics
Page: 464
View: 7401
While there are many hundreds of tools, features and functions in Excel, this book focusses only on the ones it is critical for the Finance Business user to know. 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. It is invaluable for anyone using Excel for Finance, as it helps them to do their jobs faster, more efficiently and with fewer errors. The book is organized into twelve chapters, arranged in order based on different aspects of Excel modelling. This book includes: -step-by-step instructions for how to use each feature that are detailed in a practical example -live models for readers to build it on their own accompanying excel worksheets downloadable via the website

    • Business & Economics

Financial Modeling in Excel For Dummies


Author: Danielle Stein Fairhurst
Publisher: John Wiley & Sons
ISBN: 111935756X
Category: Business & Economics
Page: 336
View: 8475
Make informed business decisions with the beginner's guide to financial modeling using Microsoft Excel Financial Modeling in Excel For Dummies is your comprehensive guide to learning how to create informative, enlightening financial models today. Not a math whiz or an Excel power-user? No problem! All you need is a basic understanding of Excel to start building simple models with practical hands-on exercises and before you know it, you'll be modeling your way to optimized profits for your business in no time. Excel is powerful, user-friendly, and is most likely already installed on your computer—which is why it has so readily become the most popular financial modeling software. This book shows you how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more. You'll learn the fundamental best practices and know-how of financial modeling, and how to put them to work for your business and your clients. You'll learn the tools and techniques that bring insight out of the numbers, and make better business decisions based on quantitative evidence. You'll discover that financial modeling is an invaluable resource for your business, and you'll wonder why you've waited this long to learn how! Companies around the world use financial modeling for decision making, to steer strategy, and to develop solutions. This book walks you through the process with clear, expert guidance that assumes little prior knowledge. Learn the six crucial rules to follow when building a successful financial model Discover how to review and edit an inherited financial model and align it with your business and financial strategy Solve client problems, identify market projections, and develop business strategies based on scenario analysis Create valuable customized templates models that can become a source of competitive advantage From multinational corporations to the mom-and-pop corner store, there isn't a business around that wouldn't benefit from financial modeling. No need to buy expensive specialized software—the tools you need are right there in Excel. Financial Modeling in Excel For Dummies gets you up to speed quickly so you can start reaping the benefits today!

    • Business & Economics

Principles of Finance with Excel


Author: Simon Benninga,Tal Mofkadi
Publisher: Oxford University Press, USA
ISBN: 9780190296384
Category: Business & Economics
Page: 792
View: 6484
Offering exceptional resources for students and instructors, Principles of Finance with Excel, Third Edition, combines classroom-tested pedagogy with the powerful functions of Excel software. Authors Simon Benninga and Tal Mofkadi show students how spreadsheets provide new and deeper insightsinto financial decision making.The third edition of Principles of Finance with Excel covers the same topics as standard financial textbooks - including portfolios, capital asset pricing models, stock and bond valuation, capital structure and dividend policy, and option pricing - and can therefore be used in any introductorycourse. In addition, it introduces Excel software as it applies to finance students and practitioners. Throughout the book, the implementation of finance concepts with Excel software is demonstrated and explained. A separate section of PFE provides thorough coverage of all Excel software topics usedin the book: graphs, function data tables, dates, Goal Seek, and Solver.Visit www.oup.com/us/benninga for student and instructor resources, including all the spreadsheets used as examples in the text and in the end-of-chapter problems.

    • Business & Economics

Financial Modelling and Asset Valuation with Excel


Author: Morten Helbæk,Ragnar Løvaas,Jon Olav Mjølhus
Publisher: Routledge
ISBN: 1134620276
Category: Business & Economics
Page: 448
View: 4615
Finance is Excel! This book takes you straight into the fascinating world of Excel, the powerful tool for number crunching. In a clear cut language it amalgamates financial theory with Excel providing you with the skills you need to build financial models for private or professional use. A comprehensive knowledge of modeling in Excel is becoming increasingly important in a competitive labour market. The chapters in part one start with the most basic Excel topics such as cell addresses, workbooks, basic formulas, etc. These chapters get more advanced through part one, and takes you in the end to topics such as array formulas, data tables, pivot tables, etc. The other parts of the book discusses a variety of subjects such as net present value, internal rate of return, risk, portfolio theory, CAPM, VaR, project valuation, asset valuation, firm valuation, loan, leasing, stocks, bonds, options, simulation, sensitivity analysis, etc.

    • Business & Economics

Business Analysis with Microsoft Excel


Author: Conrad George Carlberg
Publisher: Que Publishing
ISBN: 9780789736642
Category: Business & Economics
Page: 481
View: 4142
Extensive coverage of Excel's financial capabilities - for small businesses or major corporations!

    • Business & Economics

Financial Modeling Using Excel and VBA


Author: Chandan Sengupta
Publisher: John Wiley & Sons
ISBN: 9780471267683
Category: Business & Economics
Page: 857
View: 5816
"Reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial models" - cover.

    • Business & Economics

Mastering Financial Mathematics in Microsoft Excel

A practical guide to business calculations
Author: Alastair Day
Publisher: Pearson UK
ISBN: 1292067535
Category: Business & Economics
Page: 392
View: 4611
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. The examples used are relevant to both managers and students in the UK and overseas. New to this edition Updated glossary of key terms Functions list in English and Euro languages Continuity check on all formats, layouts and charts More worked examples Additional exercises at the end of each chapter to help build models Templates and models available online.

    • Business & Economics

Excel Modeling in Corporate Finance, Global Edition


Author: Craig W. Holden
Publisher: Pearson Higher Ed
ISBN: 1292071494
Category: Business & Economics
Page: 232
View: 3023
For courses in corporate finance or financial management at the undergraduate and graduate level. Excel Modeling in Corporate Finance approaches building and estimating models with Microsoft® Excel®. Students are shown the steps involved in building models, rather than already-completed spreadsheets.

    • Business & Economics

Business and Financial Statistics Using Minitab 12 and Microsoft Excel 97


Author: John C. Lee
Publisher: World Scientific
ISBN: 9789810238797
Category: Business & Economics
Page: 353
View: 3592
The personal computer has made statistical analysis easier and cheaper. Previously, statistical analysis was difficult for many reasons. Two of the reasons were: (1) statistical analysis was slow and tedious because calculations were done by hand; (2) it was costly because it was done on mainframes and mainframe time was expensive. This book discusses statistical analysis using two personal computer software packages, Minitab 12 and Microsoft Excel 97, Minitab was chosen because it is powerful and is one of the more user-friendly statistical software packages. Microsoft Excel 97 was selected because it is one of the most important software packages to learn and most companies use Microsoft Excel. Excel is a software package that is not dedicated to statistical analysis like Minitab, but it has many statistical features and a very powerful development environment for writing customized statistical analysis. The book is organized in a textbook format. Each chapter discusses statistical conceptsand illustrates the use of Minitab and/or Excel. Often it becomes necessary to write macros (programs) in order to do specific statistical analysis. This books prints the codes of the macros for the reader to use and study. This is valuable because usually the difficult part is how to write the code. What the reader will find after studying this book is that statistical analysis will become more fun because he will have more time doing statistical analysis and make less statistical calculations.

    • Business & Economics

Financial Modeling


Author: Simon Benninga,Benjamin Czaczkes
Publisher: MIT Press
ISBN: 0262027283
Category: Business & Economics
Page: 1144
View: 304
A substantially revised edition of a bestselling text combining explanation and implementation using Excel; for classroom use or as a reference for finance practitioners.

    • Corporations

Financial Modelling in Practice

A Concise Guide for Intermediate and Advanced Level
Author: Michael Rees
Publisher: N.A
ISBN: 9781118374658
Category: Corporations
Page: 270
View: 7883
Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in-depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models. --From publisher's description.

    • Business & Economics

Advanced Excel Reporting for Management Accountants


Author: Neale Blackwood
Publisher: John Wiley & Sons
ISBN: 1118658183
Category: Business & Economics
Page: 448
View: 6857
The advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants. Explore the structures that simplify the report creation process and make the reports more maintainable Learn techniques to "cleanse" data so that it is ready for use in Pivot Tables and formula-based reports Find out the tips and tricks that can make the creation process quicker and easier Discover all you need to know about Excel's summing functions and how versatile they can be Written in a hands-on style that works towards the completion of two reporting case studies, Advanced Excel Reporting for Management Accountants explains and demonstrates techniques so that Management Accountants can learn how to automate many aspects of the reporting process.

    • Mathematics

Data Analysis with Microsoft Excel: Updated for Office 2007


Author: Kenneth N. Berk,Patrick M. Carey
Publisher: Cengage Learning
ISBN: 1111792771
Category: Mathematics
Page: 608
View: 5093
This popular best-selling book shows students and professionals how to do data analysis with Microsoft Excel. DATA ANALYSIS WITH MICROSOFT EXCEL teaches the fundamental concepts of statistics and how to use Microsoft Excel to solve the kind of data-intensive problems that arise in business and elsewhere. Even students with no previous experience using spreadsheets will find that this text's step-by-step approach, extensive tutorials, and real-world examples make it easy to learn how to use Excel for analyzing data. A downloadable StatPlus add-in for Microsoft Excel, data sets for exercises, and interactive concept tutorials are available on the Book Companion Website. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

    • Business & Economics

Financial Modeling with Crystal Ball and Excel


Author: John Charnes
Publisher: John Wiley & Sons
ISBN: 1118161130
Category: Business & Economics
Page: 288
View: 3643
Praise for Financial Modeling with Crystal Ball(r) and Excel(r) "Professor Charnes's book drives clarity into applied Monte Carlo analysis using examples and tools relevant to real-world finance. The book will prove useful for analysts of all levels and as a supplement to academic courses in multiple disciplines." -Mark Odermann, Senior Financial Analyst, Microsoft "Think you really know financial modeling? This is a must-have for power Excel users. Professor Charnes shows how to make more realistic models that result in fewer surprises. Every analyst needs this credibility booster." -James Franklin, CEO, Decisioneering, Inc. "This book packs a first-year MBA's worth of financial and business modeling education into a few dozen easy-to-understand examples. Crystal Ball software does the housekeeping, so readers can concentrate on the business decision. A careful reader who works the examples on a computer will master the best general-purpose technology available for working with uncertainty." -Aaron Brown, Executive Director, Morgan Stanley, author of The Poker Face of Wall Street "Using Crystal Ball and Excel, John Charnes takes you step by step, demonstrating a conceptual framework that turns static Excel data and financial models into true risk models. I am astonished by the clarity of the text and the hands-on, step-by-step examples using Crystal Ball and Excel; Professor Charnes is a masterful teacher, and this is an absolute gem of a book for the new generation of analyst." -Brian Watt, Chief Operating Officer, GECC, Inc. "Financial Modeling with Crystal Ball and Excel is a comprehensive, well-written guide to one of the most useful analysis tools available to professional risk managers and quantitative analysts. This is a must-have book for anyone using Crystal Ball, and anyone wanting an overview of basic risk management concepts." -Paul Dietz, Manager, Quantitative Analysis, Westar Energy "John Charnes presents an insightful exploration of techniques for analysis and understanding of risk and uncertainty in business cases. By application of real options theory and Monte Carlo simulation to planning, doors are opened to analysis of what used to be impossible, such as modeling the value today of future project choices." -Bruce Wallace, Nortel