Building Financial Models with Microsoft Excel
"While many business professionals are familiar with the "output" of financial models, namely consolidated financial statements, few are truly adept at building an accurate and effective financial model from the ground up. Building Financial Models with Microsoft Excel addresses this real, immediate, and significant issue. Written in a straightforward and accessible manner, it is a resource for business professionals with a beginner or intermediate level of experience in both Microsoft Excel and finance or accounting." "Part One of Building Financial Models with Microsoft Excel introduces the concepts of budgets and financial models, and covers the steps involved in building the master budget - as well as its two key elements, the operating budget and financial budget. You'll learn the fundamentals of the budgeting process and how various components of a master budget relate to one another. The master budget template provided in this part of the book serves as a road map for building each individual component of the financial model." "Part Two of this book deals with a company's consolidated financial statements and free cash flows. It provides you with a guide to building these statements from scratch, based upon the operating and financial budgets of a company. The final part of Building Financial Models with Microsoft Excel - Part Three - deals with several topics, including: various ways to analyze a financial model; the concept of valuation; and capitalization, or ownership, charts."--BOOK JACKET.