• PGP in New Age Banking
    4.8 out of 5 by 669 learners
    4x Industry Demand
  • POST GRADUATE DIPLOMA IN MANAGEMENT
    Co-created with BIMTECH
    4.8 out of 6071 learners
    2x industry demand
  • MBA in Investment Banking
    Co-created with Jain University
    4.5 out of 5 by467 learners
    2x industry demand
  • MBA in Fintech
    Co-created with Jain University
    4.4 out of 5 by 349 learners
    2x industry demand
  • MBA (Distance) in Banking and Finance with NGASCE
    Co-created with NMIMS
    4.7 out of 5 by 669 learners
    4x Industry Demand
  • Post Graduate Program in Banking and Credit Underwriting
    4.7 out of 5 by 1376 learners
    12 X industry demand
  • Post Graduate Program In Finance And Accounting
    Co-created with Grant Thornton
    4.9 out of 5 by 238 learners
    14 X industry demand
  • Professional Certification in FinTech
    Co-created with SP Jain School of Global Management
    4.6 out of 5 by 1421 learners
    6X industry demand
  • Credit Risk and Underwriting Prodegree
    Co-created with Moody’s Analytics
    4.6 out of 5 by 1139 learners
    4X industry demand
  • PGP in Banking and Wealth Management
    4.6 out of 5 by 1429 learners
    3X industry demand

Excel is considered to be the tool of opportunity, and it is often the go-to software for most finance professionals. In “Excel Modeling in Corporate Finance” by Craig W. Holden, the author presents numerous typical issues from options valuations to DCF calculations.

The various topics within the book maintain the contents of a typical financial analyst course, like cash flow calculations, yield curves, bond valuations, annuities, capital cost evaluations, option valuations, and financial planning. However, this book is not an average classic finance textbook.

Holden only just touches on financial basics and simply talks about them when needed. The main focus is on implementing and applying the theoretical concepts in Excel in brief. If read alongside a classic financial textbook, the one will be able to enhance their understanding greatly. Each chapter comes with a list of questions which can be solved using and applying the financial model covered in the chapters.

What sets this book apart from other financial textbooks:
Teach by Example: Holden is a firm believer that the best and the most effective way to learn spreadsheet modeling is by working through examples and problem solving and as such his book develops this hands-on, active learning approach. Thus when a student builds themselves, they are able to understand it fully.

Supplement for Corporate Finance Textbooks: When combined with a primary textbook, this book can be a great add on and can be a great supplement – this leaves the student to continue using whatever textbook he or she has been reading and doesn’t need to switch. One can follow an incremental approach and incorporate spreadsheet modeling.

Plain Vanilla Excel: Unlike most other books that teach students programming using Visual Basic for Applications, Excel Modeling in Corporate Finance does everything in plain vanilla excel. Plain vanilla Excel has the advantage of being an intuitive and user-friendly environment that everyone can access.

It is entirely capable of handling a varied range of applications, including the most sophisticated ones. Moreover, all the other features of Excel – like graphing, built-in functions, Solver, etc., are explained as they are used.

Simple Examples: The overall approach in this book is to start with a simple example that builds up to a practical, real-world application. In most chapters, the previous spreadsheet model is taken forward to the next, more complicated model, like the chapter on binomial option pricing, looks into spreadsheet models as :

a single-period model with replicating portfolio
an eight-period model with replicating portfolio
an eight-period model with risk-neutral probabilities
a full-scale, fifty-period model with volatilities estimated from real returns data

Overall Review
The book is printed in a large format, and spreadsheet screenshots and complicated formulas are well arranged and easy to understand. A number of text boxes on the spreadsheets gives additional information.

The book comes with a CD-ROM in which are the PDF copy of the book and all examples in Excel format making it easier for the reader to live to follow all the examples while solving problems through the book. In many places, a lot of formulas are missing, and the reader is asked to fill in the blanks. Concepts taught in the book can be understood easily, and the reader can apply them immediately for better insight.

Holden mostly sticks to Excel 2007 and 2010 as older versions have a chance of being slightly incompatible with few of the examples. In conclusion, this is a must-read for all upcoming and financial modelers who are looking forward to obtaining a financial analyst certification in their future careers.

For Online Course Enquiries
About Imarticus
Imarticus Learning is India’s leading professional education institute that offers training in Financial Services, Data Analytics & Technology. We’ve successfully transformed careers of over 35,000+ individuals globally through our Certification, Prodegree, and Post Graduate programs offered in association with leading and renowned global organisations in the Financial Services, Data Analytics & Technology domain.
Related course
  • Placement Program
    PGP in New Age Banking
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.8 out of 5 by 669 learners
    4x Industry Demand
    Upcoming Batches
    Date Location Schedule
    8th Jan 2022 Live Instructor - Led Training Online
    Date Location Schedule
  • Finance
    POST GRADUATE DIPLOMA IN MANAGEMENT
    Co-created with BIMTECH
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.8 out of 6071 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    Live Instructor - Led Training Online
    Date Location Schedule
  • Recent Graduates
    MBA in Investment Banking
    Co-created with Jain University
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.5 out of 5 by467 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    31st July ONLINE Online
    Date Location Schedule
  • Recent Graduates
    MBA in Fintech
    Co-created with Jain University
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.4 out of 5 by 349 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    31st July ONLINE Online
    Date Location Schedule
  • Placement Program
    MBA (Distance) in Banking and Finance with NGASCE
    Co-created with NMIMS
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 669 learners
    4x Industry Demand
    Upcoming Batches
    Date Location Schedule
    8th Jan 2022 Live Instructor - Led Training Online
    Date Location Schedule
  • Post Graduate
    Post Graduate Program in Banking and Credit Underwriting
    Course duration(6)
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 1376 learners
    12 X industry demand
    Upcoming Batches
    Date Location Schedule
    Not Available MUMBAI Online
    Date Location Schedule
  • Post Graduate
    Post Graduate Program In Finance And Accounting
    Co-created with Grant Thornton
    Course duration(months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    4.9 out of 5 by 238 learners
    14 X industry demand
    Upcoming Batches
    Date Location Schedule
    None DELHI Online
    Date Location Schedule
  • Certification
    Professional Certification in FinTech
    Co-created with SP Jain School of Global Management
    Course duration(Months)
    3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.6 out of 5 by 1421 learners
    6X industry demand
    Upcoming Batches
    Date Location Schedule
    27th November Live Instructor - Led Training Online
    Date Location Schedule
  • PRODEGREE
    Credit Risk and Underwriting Prodegree
    Co-created with Moody’s Analytics
    Course duration(Months)
    3
    Upcoming batches
    2
    Organizations enrolled
    20
    4.6 out of 5 by 1139 learners
    4X industry demand
    Upcoming Batches
    Date Location Schedule
    13th February ONLINE Weekend
    Date Location Schedule
    29th May ONLINE Weekend
  • Post Graduation
    PGP in Banking and Wealth Management
    Course duration(Months)
    2-3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.6 out of 5 by 1429 learners
    3X industry demand
    Upcoming Batches
    Date Location Schedule
    21st October CHENNAI Weekday
    Date Location Schedule