100,000+ Books, Games & Puzzles in-stock πŸ‡³πŸ‡Ώ

Overnight NZ-wide delivery on in-stock orders πŸš€

The Essentials of Financial Modeling in Excel

A Concise Guide to Concepts and Methods
Book Hero Magic crafted this summary to help describe this book. While it's new and still learning, it may not be perfect - your feedback is welcome! Summary
The Essentials of Financial Modeling in Excel by Michael Rees is a practical guide to creating financial models using Excel. It covers key techniques and tools necessary for effective financial analysis, offering readers insights into both basic and advanced modelling techniques. The book aims to equip readers with the skills to construct robust financial models for a variety of applications, enhancing decision-making in a business context.
Read More
Format: Paperback / softback
$9099
AVAILABLE WITH SUPPLIER Ships from our Auckland warehouse within 3-4 weeks

Found a better price? Request a price match

Book Hero Magic created this recommendation. While it's new and still learning, it may not be perfect - your feedback is welcome! IS THIS YOUR NEXT READ?

You might find this book appealing if you have an interest in enhancing your financial analysis skills through practical Excel modelling. It's tailored for those keen on learning detailed techniques, ensuring you can build robust financial models with confidence. Whether you're a finance professional or an enthusiastic beginner, the book offers clear explanations and practical examples to equip you with essential tools.

Book Hero thinking about your next read

Book Hero Magic formatted this description to make it easier to read. While it's new and still learning, it may not be perfect - your feedback is welcome! Description

A concise and practical guide to financial modeling in Excel

In The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods, veteran quantitative modeling and business analysis expert Dr. Michael Rees delivers a practical and hands-on introduction to financial modeling in Excel. The author offers readers a well-structured and strategic toolkit to learn modeling from scratch, focusing on the core economic concepts and the structures commonly required within Excel models.

Divided into six parts, the book discusses the use of models and the factors to consider when designing and building models so that they can be as powerful as possible, yet simple. Readers will also find:

  • The foundational structures and calculations most frequently used in modeling, including growth- and ratio-based methods, corkscrews, and waterfall analysis.
  • Walkthroughs of economic modeling, measurement, and evaluation, and the linking of these to the decision criteria. These include breakeven and payback analysis, compounding, discounting, calculation of returns, loan calculations, and others.
  • Structured approaches for modeling in corporate finance, including financial statement modeling, cash flow valuation, cost of capital, and ratio analysis.
  • Techniques to implement sensitivity and scenario analysis.
  • Core aspects of statistical analysis, including data preparation, manipulation, and integration.
  • The use of approximately 100 Excel functions within example modeling contexts.
  • Further Topics Sections, which introduce advanced aspects of many areas, in order to provide further benefit to more advanced readers, whilst presenting the truly essential topics separately. Examples of these include introductions to PowerQuery and PowerPivot, as well as advanced waterfall structures.

An invaluable, all-in-one blueprint for learning financial modeling in Excel, this book is ideal for beginning and intermediate financial professionals and students seeking to build and reinforce essential topics in financial modeling.

Book Details

INFORMATION

ISBN: 9781394157785

Publisher: John Wiley & Sons Inc

Format: Paperback / softback

Date Published: 09 February 2023

Country: United States

Imprint: John Wiley & Sons Inc

Audience: Professional and scholarly

DIMENSIONS

Spine width: 23.0mm

Width: 168.0mm

Height: 241.0mm

Weight: 408g

Pages: 336

About the Author

Michael Rees is Professor of Finance at Audencia Business School in Nantes, France. He has over 30 years’ experience in senior roles at leading firms in finance and strategy consulting, including JP Morgan, Mercer Management Consulting, and Braxton Associates. He has also worked as an independent consultant and trainer, advising clients in private equity, auditing and consulting, finance, banking, insurΒ­ance, pharmaceuticals, and other industries.

More from Science & Nature

View all
  • Murder Under the Mistletoe
    BOOK 4 IN THE BESTSELLING CANON CLEMENT MYSTERY SERIES 'The best of the new cosy crime writers' Daily Telegraph 'You'll want to take a front row pew in Champton while this delicious series unfolds' Janice Hallett It is Christmas Day and at Champton Rectory, Canon Daniel Clement and his mother Audrey are joined by the residents and guests of the...
    Paperback
    $2799
    In Stock
    Ships tomorrow
  • John and Paul
    THE SUNDAY TIMES AND NEW YORK TIMES BESTSELLER LONGLISTED FOR THE BAILLIE GIFFORD PRIZE FOR NON-FICTION 'A triumph.' Deborah Levy, New Statesman 'Tremendous.' Alwyn Turner, The Times 'Revelatory.' Simon Schama, Financial Times 'The gold standard of Beatles books.' Anthony Quinn, Observer 'As enthralling and astonishing as their music.' Jon Dennis, Sunday Telegraph 'A masterpiece.' Dylan Jones, Evening Standard '[Ian Leslie]...
    Paperback
    $2800
    Elsewhere:
    $3299
    In Stock
    Ships tomorrow
  • Raising Hare
    THE INSTANT SUNDAY TIMES AND NEW YORK TIMES BESTSELLER SHORTLISTED FOR THE WOMEN'S PRIZE FOR NON-FICTION 2025 SHORTLISTED FOR WATERSTONES BOOK OF THE YEAR 2024 SHORTLISTED FOR THE HATCHARDS AND BIOGRAPHERS' CLUB FIRST BIOGRAPHY PRIZE A BOOK OF THE YEAR FOR THE HAY FESTIVAL, SUNDAY TIMES, THE TIMES, FINANCIAL TIMES, SPECTATOR AND iNEWS 'A beautiful book' - ANGELINA JOLIE 'I...
    Paperback
    $2400
    Elsewhere:
    $2799
    In Stock
    Ships tomorrow
  • What If? 10th Anniversary Edition
    CELEBRATING TEN YEARS OF THE MILLION-SELLING POP SCIENCE CLASSIC WITH A SPECIAL EDITION. THIS IS WHAT IF? . . . x10. THE SUNDAY TIMES BESTSELLER 'Nerd royalty' β€” BEN GOLDACRE 'Totally brilliant' β€” TIM HARFORD 'Required reading across the world' β€” NEW YORK TIMES From the creator of the wildly popular xkcd.com, experience hilarious and informative answers to important questions...
    Hardback
    $4200
    Elsewhere:
    $5000
    In Stock
    Ships tomorrow
  • Nuclear War
    The Sunday Times bestselling non-fiction thriller that has to be read to be believed. Baillie Gifford shortlisted, a favourite of Steven Bartlett, with an average reader rating of 4.6, sure to be a mass-market hit. Up to now, no one outside of official circles has known exactly what would happen if a rogue state launched a nuclear missile at the...
    Paperback
    $2500
    Elsewhere:
    $2800
    In Stock
    Ships tomorrow
  • The Anxious Generation
    A powerful argument for reclaiming childhoodβ€”and all human relationshipsβ€”from the online world, from the influential social psychologist and international bestselling author. Jonathan Haidt has spent his career speaking truth and wisdom in some of the most difficult spacesβ€”communities polarised by politics and religion, campuses battling culture wars, and now the mental health emergency hitting teenagers today in many countries around...
    Paperback
    $2299
    Elsewhere:
    $3000
    In Stock
    Ships tomorrow
  • Prisoners of Geography
    Prisoners of Geography looks at the past, present, and future to offer crucial insights into one of the major factors that determine world history – because if you don’t know geography, you’ll never have the full picture. Originally published in 2015, this completely revised and updated edition brings it up to date with the events and trends of the past...
    Paperback
    $2899
    In Stock
    Ships tomorrow
  • Booker Prize
    Orbital
    Winner of the Booker Prize 2024. Chair of the judges, Edmund de Waal, describes the winner as 'a book about a wounded world' adding that the panel's 'unanimity about Orbital recognises its beauty and ambition'. Life on our planet as you've never seen it before. A team of astronauts in the International Space Station collect meteorological data, conduct scientific experiments...
    Paperback
    $2200
    Elsewhere:
    $2600
    (2)
    In Stock
    Ships tomorrow
  • Diddly Squat: Home to Roost
    It's been another memorable year on Diddly Squat Farm - will the chickens finally come home to roost? Welcome back to Clarkson's Farm. The spring crop failed. Farming sheep, pigs, and cows was hardly more lucrative (better off breeding ostriches...) But in the face of uncooperative weather, bureaucracy, and the world's persistent refusal to recognise his genius, our hero's not...
    Paperback
    $2600
    Elsewhere:
    $3000
    In Stock
    Ships tomorrow
  • The Place of Tides
    To save the world, we have to start somewhere. One afternoon many years ago, James Rebanks met an old woman on a remote Norwegian island. She lived and worked alone on a tiny rocky outcrop, caring for wild ducks and gathering their down. Hers was a centuries-old trade that had once made men and women rich, but had long been...
    Paperback
    $3000
    In Stock
    Ships tomorrow
  • Ultra-Processed People
    Launching the runaway bestseller with ambitions to be the biggest non-fiction paperback of the year IT'S NOT YOU. IT'S THE FOOD. "If you only read one diet or nutrition book in your life, make it this one" - Bee Wilson "You've got to get this book in your life . . . Completely compelling . . . Read a page...
    Paperback
    $2500
    Elsewhere:
    $2800
    In Stock
    Ships tomorrow
  • The Island of Missing Trees
    The Island of Missing Trees by Elif Shafak is a captivating and poignant novel that delves into the intertwined lives of two star-crossed lovers in war-torn Cyprus and their enduring legacy decades later. This Sunday Times bestselling novel intricately weaves themes of love, loss, and identity amidst a backdrop of cultural and historical turmoil. Set in 1974 on the island...
    Paperback
    $2300
    Elsewhere:
    $2600
    In Stock
    Ships tomorrow

Why buy from us?

Book Hero is not a chain store or big box retailer. We're an independent 100% NZ-owned business on a mission to help more Kiwis rediscover a love of books and reading!

Service & Delivery

Service & Delivery

Our warehouse in Auckland holds over 100,000 books, toys, board games and puzzles in-stock so you're not waiting for your order to arrive from overseas.

Auckland Bookstore

Auckland Bookstore

We're primarily an online store, but for your convenience you can pick up your order for free from our bookstore, which is right next door to our warehouse in Hobsonville.

Our Gifting Service

Our Gifting Service

Books make wonderful thoughtful gifts and we're here to help with gift-wrapping and cards. We can even send your gift directly to your loved one.