A proven guide to building financial models from scratch
The Second Edition of Building Financial Models with Microsoft Excel + CD-ROM provides beginning and intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel 2007-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow you to build your own financial models. This comprehensive resource also covers important topics such as the concepts of valuation, sensitivity analysis, and contribution margin.
Incorporating financial models into business decisions has become an essential element of good business practice, and this book will show you how to excel at this endeavor.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Microsoft Excel has become a critical element for decision-making in the modern business environment. It is particularly effective in the logical, step-by-step process of building a financial model—the quantitative representation of a company's past, present, and future business operations—where each component builds upon or feeds into another component. These financial models serve as the foundation and basis of today's standard financial accounting reports. But while many business professionals are familiar with consolidated financial statements, few are truly proficient at building an accurate and effective financial model from the ground up.
Building Financial Models with Microsoft Excel, Second Edition offers a detailed and easy-to-understand guide for anyone who needs to build or analyze financial models using Microsoft Excel 2007. Written in a straightforward and accessible manner, it is a comprehensive resource for business professionals with a beginner or intermediate level of experience in both Microsoft Excel, and finance or accounting. K. Scott Proctor provides a thoughtful and coherent link between financial/accounting theory and common Wall Street practice by addressing key questions in financial modeling like what to build, how to build, and how to analyze.
Part One covers the steps involved in building the master budget—detailing 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—from sales, inventory, and operating expenses to capital budgets, cash budgets, and balance sheets. Part Two explains consolidated financial statements and free cash flows, providing a guide to building these statements from scratch. Part Three tackles the various ways to analyze a financial model, including sensitivity analysis, contribution margin analysis, and financial ratios analysis. The book also includes a companion CD-ROM, which contains sample Excel worksheets that allow you to follow the examples illustrated within the book or build your own financial models according to your specific situation.
Filled with in-depth insights and easy-to-understand instructions, this fully revised Second Edition of Building Financial Models with Microsoft Excel is a readable, practical guide to understanding and creating fully functioning financial models.From the Back Cover:
Praise for the First Edition of
Building Financial Models with Microsoft Excel
"Scott Proctor offers a comprehensive and easy-to-understand guide to constructing and using financial models; I recommend this book as a tutorial and a reference for business professionals, entrepreneurs, venture capitalists, and angel investors."
—Jack M. Gill, PhD, Vanguard Ventures
"This book is about making good decisions. . . . The modeling tools described in this book establish an analytical framework which adds much needed clarity to effective decision-making. This in-depth guide should well serve experienced professionals as a reference and business students and entrepreneurs as a tutorial."
—Eugene V. Fife, Retired Chairman, Goldman Sachs International
"Excel has become a critical element for decision-making in the modern business environment. Mr. Proctor's book is a solid introduction to utilizing this complex tool."
—William Polk Carey, Chairman and founder, W.P. Carey & Co. LLC
Readable, comprehensive, and engaging—buy this book; study it; and thereby build your capacity to harness the computer in the solution of real-world business problems."
—Robert F. Bruner, Dean and Charles C. Abbott Professor of Business Administration at the Darden Graduate School of Business, University of Virginia
"This book offers an excellent guide to building financial models. Proctor guides readers through the many interrelated steps involved in constructing and using financial models, a vital skill in today's business world."
—Jeffrey Nuechterlein, Managing Partner, Isis Capital
"Building Financial Models with Microsoft Excel takes a complex but critical subject and presents it in a concise, easy-to-follow fashion. This book is an indispensable reference guide for anyone who needs to build or analyze financial models using Microsoft Excel."
—Michael R. Lincoln, Partner, Cooley Godward LL
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Descrizione libro Wiley, 2010. Soft cover. Condizione libro: New. International Edition. 380pp. Book cover and ISBN different from US edition. Territorial Restrictions maybe printed on the book. This is an international edition. Codice libro della libreria 327355
Descrizione libro Paperback. Condizione libro: New. This is an International Edition Brand New Paperback Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. Standard Delivery within 6-14 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. Codice libro della libreria RU_9780470481745
Descrizione libro Soft cover. Condizione libro: New. Opt EXPEDITED shipping for 2 to 4 day delivery - Brand NEW - International Edition - 2ed - CD-ROM included, SAME Contents as in US edition - SHRINKwrapped BOXpacked - There is no CD or Access Code, unless specified above - Ships from various locations. Codice libro della libreria Y25
Descrizione libro Condizione libro: Brand New. PAPERBACK,Book Condition New, Brand New, Softcover, International Edition. We Do not Ship APO FPO AND PO BOX. Cover Image & ISBN may be different from US edition but contents as US Edition. Printing in English language. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Codice libro della libreria ABESTTND1724
Descrizione libro Softcover. Condizione libro: New. 2nd edition. Brand NEW, Paperback International Edition. Black & White or color, Cover and ISBN may be different but similar contents as US editions. Standard delivery takes 3-6 business days by USPS/UPS/Fedex with tracking number. Choose expedited shipping for superfast delivery 2-4 business days. We do not ship to PO Box addresses. International Edition Textbooks may bear a label Not for sale in the U.S. or Canada etc. printed only to discourage U.S. students from obtaining an affordable copy. Legal to use despite any disclaimer on cover as per US court. No access code or CD included unless specified. In some instances, the international textbooks may have different exercises at the end of the chapters. Printed in English. 100% Customer satisfaction guaranteed! Please feel free to contact us for any queries. Codice libro della libreria LBDUS61435749
Descrizione libro Paperback. Condizione libro: New. Softcover Book, New Condition, Fast Shipping. Ready in Stock. 2nd Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. 384 pages, Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Codice libro della libreria 299911
Descrizione libro Paperback. Condizione libro: New. New, Softcover International Edition, Printed in Black and White, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Codice libro della libreria 4952
Descrizione libro Wiley. Paperback. Condizione libro: New. International Edition. Very fast shipping. Receive your book in 2-7 business days if you checkout with expedited shipping. We take pride in our customer service, please contact us if you have any questions regarding the listing. Codice libro della libreria in-us-9780470481745
Descrizione libro Softcover. Condizione libro: Brand New. .. Black & White or color International Edition. ISBN and front cover may be different, but contents are same as the US edition. Book printed in English. Territorial restrictions may be printed on the book. GET IT FAST within 3-5 business days by DHL/FedEx/Aramex and tracking number will be uploaded into your order page within 24-48 hours. Kindly provide day time phone number in order to ensure smooth delivery. No shipping to PO BOX, APO, FPO addresses. 100% Customer satisfaction guaranteed!. . Codice libro della libreria UBS02596
Descrizione libro Condizione libro: Brand New. Brand New Paperback International Edition, Perfect Condition. Printed in English. Excellent Quality, Service and customer satisfaction guaranteed!. Codice libro della libreria AIND-9128