Spreadsheet modeling in corporate finance
Spreadsheet modeling in corporate finance
Spreadsheet modeling in corporate finance
5 3
Price: $21.01 FREE for Members
Type: eBook
Publisher: Prentice Hall
Page Count: 161
Format: pdf
Language: English
ISBN-10: 0130675237
ISBN-13: 9780130675231
User Rating: 5.0000 out of 5 Stars! (3 Votes)

Spreadsheet modeling in corporate finance ebook


Craig W. Holden. free


Spreadsheet Modeling in Corporate Finance teaches readers how to build financial models in Excel. This book and CD provide step-by-step instructions so that learners can build models themselves (active learning), rather than handing learners canned “templates” (passive learning). The spreadsheet models progress from simple examples to practical, real-world applications, and span nearly all of the quantitative models in the fundamentals of corporate finance. The basic philosophy of this product is “If they build it, they will learn!”. A five-part organization covers the time value of money, valuation, capital budgeting, financial planning, and options and corporate finance.

change finance education from being calculator based to being spreadsheet modeling based. This change will better prepare students for the 21st century business world. This change will increase student satisfaction in the classroom by allowing more practical, real-world applications and by enabling a more hands-on, active learning approach.

Teach By Example. I believe that the best way to learn spreadsheet modeling is by working through examples and completing a lot of problems. This book fully develops this hands-on, active learning approach. Active learning is a well-established way to increase student learning and student satisfaction with the course / instructor. When students build financial models themselves, they really "get it." As I tell my students, "If you build it, you will learn." Supplement For All Popular Corporate Finance Textbooks. This book is a supplement to be combined with a primary textbook. This means that you can keep using whatever textbook you like best. You don't have to switch. It also means that you can take an incremental approach to incorporating spreadsheet modeling. You can start modestly and build up from there. Alternative notation versions are available that match the notation of all popular corporate finance textbooks. Plain Vanilla Excel. Other books on the market emphasize teaching students programming using Visual Basic for Applications (VBA) or using macros. By contrast, this book does everything in plain vanilla Excel. Although programming is liked by a minority of students, it is seriously disliked by the majority. Plain vanilla Excel has the advantage of being a very intuitive, user-friendly environment that is accessible to all. It is fully capable of handling a wide range of applications, including quite sophisticated ones. Further, your students already know the basics of Excel and nothing more is assumed. Students are assumed to be able to enter formulas in a cell and to copy formulas from one cell to another. All other features of Excel (graphing, built-in functions, Solver, etc.) are explained as they are used. Build From Simple Examples To Practical, Real-World Applications. The general approach is to start with a simple example and build up to a practical, real-world application. In many chapters, the previous spreadsheet model is carried forward to the next more complex model. For example, the chapter on binomial option pricing carries forward spreadsheet models as follows: (a.) single-period model with replicating portfolio, (b.) eight-period model with replicating portfolio, (c.) eight-period model with risk-neutral probabilities, (d.) full-scale, fifty-period model with volatilities estimated from real returns data. Whenever possible, this book builds up to full-scale, practical applications using real data. Students are excited to learn practical applications that they can actually use in their future jobs. Employers are excited to hire students with spreadsheet modeling skills, who can be more productive faster. A Change In Content Too. Spreadsheet modeling is not merely a new medium, but an opportunity to cover some unique content items which require computer support to be feasible. For example, the full-scale, real data spreadsheet model in Corporate Financial Planning uses three years of historical l OK data on Nike, Inc. (including every line of their income statement, balance sheet, and cash flow statement), constructs a complete financial system (including linked financial ratios), and projects these financial statements three years into the future. The spreadsheet model in Life-Cycle Financial Planning includes a detailed treatment of federal and state tax schedules, social Security taxes and benefits, etc., which permit the realistic exploration savings, retirement, and investments choices over a lifetime. The spreadsheet model in US Yield Curve Dynamics shows you 30 years of monthly US yield curve history in just a few minutes. The spreadsheet model in Three Valuation Techniques demonstrates the equivalence of the Adjusted Present Value, Flows To Equity, and the Weighte9Average Cost of Capital methods, not just in the perpetuity case covered by most textbooks, but for a fully general two-stage project with an arbitrary set of cash flows over an explicit forecast horizon, followed by a infinite horizon perpetuity. As a practical matter, all of these sophisticated applications require spreadsheet modeling.

Time Goes Across The Columns And Variables Go Down The Rows. When something happens over time, I let each column represent a period of time. For example in capital budgeting, year 0 is in column B, year 1 is in column C, year 2 is in column D, etc. Each row represents a different variable, which is usually a labeled in column A. This manner of organizing spreadsheets is so common because it is how financial statements are organized. Color Coding. A standard color scheme is used to clarify the structure of the spreadsheet models. The printed book uses: (1) light gray shading for input values, (2) no shading (i.e. white) for throughput formulas, and (3) dark gray shading for final results ("the bottom line"). The accompanying electronic version of the book (a PDF file) uses: (1) yellow shading for input values, (2) no shading (i.e. white) for throughput formulas, and (3 green shading for final results ("the bottom line"). A few spreadsheets include choice variables. Choice variables use medium gray shading in the printed book and blue shading in the electronic version. The Time Line Technique. The most natural technique for discounting cash flows in a spreadsheet model is the time line technique, where each column corresponds to a period of time. The time line technique handles the general case of the discount rate changing over time just as easily as the special case of a constant discount rate. Typically one does have some information about the time pattern of the riskfree rate from the term structure of interest rates. Even just adding a constant risk premium, yields a time pattern of discount rates. There is no reason to throw this information away, when it is just as easy to incorporate it into a spreadsheet. I use the time line technique and the general case of changing discount rates throughout the capital budgeting spreadsheet models. Explicit Inflation Rate. A standard error in capital budgeting is to treat the cash flow projections and discount rate determination as if they came from separate planets with no relationship to each other. If the implicit inflation rate in the cash flow projection differs from the implicit inflation rate in the discount rate, then the analysis is inconsistent. The simple fix is to explicitly forecast the inflation rate and use this forecast in both the cash flow projection and the discount rate determination. The capital budgeting spreadsheet models teach this good modeling practice. Dynamic Charts. Dynamic charts allow you to see such things as a "movie" of the Term Structure of Interest Rates moves over time or an "animated graph" of how increasing the volatility of an underlying stock increases the value of an option. Dynamic charts are a combination of an up/down arrow (a "spinner") to rapidly change an input and a chart to rapidly display the changing output. I invented dynamic charts back in 1995 and I have included many examples of this useful educational tool throughout this book.

gain a practical understanding of the core concepts of Corporate Finance, develop hands-on, spreadsheet modeling skills, and build an entire suite of finance applications, which you fully understand.

cholden@indiana.edu to share the good news. Please tell me your name, school, (prospective) graduation year, and which spreadsheet modeling book you completed. I will add you to a web-based honor roll at:
http://www.spreadsheetmodeling.com/honor-roll.htm
We can celebrate together!

Spreadsheet Modeling by Craig W. Holden, published by Prentice Hall. The series includes:

Spreadsheet Modeling in Corporate Finance, Spreadsheet Modeling in the Fundamentals of Corporate Finance, Spreadsheet Modeling in Investments, and Spreadsheet Modeling in the Fundamentals of Investments.

User tags


Download ISBN 0130675237
ISBN 0130675237 books
ISBN 0130675237 epub
ISBN 0130675237 price
Craig W. Holden. book
ISBN 0130675237 for sale
ISBN 0130675237 for cheap
ISBN 0130675237 barcode
Spreadsheet modeling in corporate finance torrent
ISBN 0130675237 pdf
ISBN 0130675237 djvu
ISBN 0130675237 to buy
ISBN 0130675237 edition
ISBN 0130675237 Craig W. Holden.
ISBN 0130675237 Spreadsheet modeling in corporate finance
Download ISBN 9780130675231
ISBN 9780130675231 books
ISBN 9780130675231 epub
ISBN 9780130675231 price
ISBN 9780130675231 for sale
ISBN 9780130675231 for cheap
Craig W. Holden. djvu
ISBN 9780130675231 barcode
ISBN 9780130675231 pdf
ISBN 9780130675231 djvu
ISBN 9780130675231 to buy
ISBN 9780130675231 edition
ISBN 9780130675231 Craig W. Holden.
ISBN 9780130675231 Spreadsheet modeling in corporate finance
download Craig W. Holden.
download Spreadsheet modeling in corporate finance
Craig W. Holden. pdf
Spreadsheet modeling in corporate finance pdf
Spreadsheet modeling in corporate finance book
Craig W. Holden. torrent
Craig W. Holden.free download
Spreadsheet modeling in corporate finance free download
Spreadsheet modeling in corporate finance djvu
Craig W. Holden. epub
Spreadsheet modeling in corporate finance epub

download eBook Spreadsheet modeling in corporate finance - Craig W. Holden. online free pdf mp3 torrent
download 0130675237 9780130675231 book online
9780130675231

| 5 out of 5 Stars!


Hi,

I just finished the book. It is worth every dollar spent on it. If you are buying, get the second edition because the first is packed with typos.

This book serves two purposes:

1. It teaches you how to use Excel

2. It is a great practical review of corporate finance

and it does a great job in both aspects

| 5 out of 5 Stars!


Hi, I am Craig W. Holden, author of "Spreadsheet Modeling in Corporate Finance" (the first edition). I just wanted to let you know that the FOURTH edition of this book is now available. It has been retitled as "Excel Modeling in Corporate Finance (4th Edition)" and was released Aug 12, 2011. It includes everything that was in the first edition plus a lot of additional content. All of the examples and data have been updated to the present and all known typos have been corrected. The fourth edition strictly dominates the first edition and I strongly recommend it. Click on my name at the top of the page to locate it. Thanks for your consideration.

| 5 out of 5 Stars!


Although intended as a supplement for textbooks used in college level business courses, this book is also valuable to working professionals who deal with financial modeling. Because I am a consultant and project manager I'm going to slant this review towards how my peers will benefit from the book. It's value outside of my narrow scope should be apparent.

First, unlike other books that teach spreadsheet modeling, the spreadsheets that come on the CD ROM are not finished products. Instead the author has chosen spreadsheets that use dynamic charts to illustrate concepts in an interactive manner (drag a control to change the parameters and the chart changes - this is a powerful teaching tool in or out of the classroom).

Second, the book needs to be read in sequence because spreadsheets you build in one chapter are the basis for refinements and added complexity in later chapters. This leads to highly complex spreadsheets, such as the model in chapter 16 (Life-Cycle Financial Planning), which incorporates tax parameters (federal and state levels), benefits analysis and other factors.

In all there are 53 spreadsheets presented in this book, and you build them. The author calls this "active learning" (as opposed to passive learning where you are provided templates), and it is effective because you are the one who builds the models and tools while following the book. Note that this book does NOT purport to teach Excel programming, but how to build models using Excel's basic features and functions.

As a consultant and project manager the parts of this book that were immediately useful to me were: Parts I (Time Value of Money), III (Capital Budgeting) and IV (Financial Planning). In particular, project management requires a thorough understanding of time value of money and capital budgeting, and the chapters in these sections should be read by anyone who is assigned as a project manager. Financial planning, especially from the perspective of IT asset management, is another knowledge area in which IT consultants should be well versed.

The other parts of the book (II Valuation and V Options and Corporate Finance) will be more useful to finance professionals and general business managers. There is a collection of supporting material on the author's web site that augment this book, including spreadsheets that can be downloaded. Another plus for the working professional is the book is fast-paced and, dare I say, engrossing.

Showing 1 to 3 of 3
Write Review

Your Name:

Your Review: Note: HTML is not translated!

Rating: Bad            Good

Enter the code in the box below: