{"product_id":"9781430262060","title":"The Handbook of Financial Modeling: A Practical Approach to Creating and Implementing Valuation Projection Models","description":"\u003cp\u003e    The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings\/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in \u003cem\u003eThe Financial Modeling Handbook\u003c\/em\u003e, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance.      Based on the author's extensive experience building models in business and financeand teaching others to do the same\u003cem\u003eThe Handbook of Financial Modeling\u003c\/em\u003e takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel.   \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, \u003cem\u003eThe Handbook of Financial Modeling\u003c\/em\u003e also covers:  \u003c\/p\u003e\u003cul\u003e  \u003cli\u003eThe accounting and finance concepts that underpin working financial models; \u003c\/li\u003e  \u003cli\u003eHow to approach financial issues and solutions from a modeler's perspective; \u003c\/li\u003e  \u003cli\u003eThe importance of thinking about end users when developing a financial model; \u003c\/li\u003e  \u003cli\u003eHow to plan, design, and build a fully functional financial model; \u003c\/li\u003e  \u003cli\u003eAnd more. \u003c\/li\u003e  \u003c\/ul\u003e  \u003cp\u003eA nuts-to-bolts guide to solving common financial problems with spreadsheets, \u003cem\u003eThe Handbook of Financial Modeling \u003c\/em\u003eis a one-stop resource for anyone who needs to build or analyze financial models.\u003c\/p\u003e             What youll learn  \u003cul\u003e  \u003cli\u003eKey financial modeling principles, including best practices, principles around calculations, and the importance of producing clean, clear financial models \u003c\/li\u003e  \u003cli\u003eHow to design and implement a projection model that allows the user to change inputs quickly for sensitivity testing \u003c\/li\u003e  \u003cli\u003eThe proper way to approach a financial modeling assignment, from project planning all the way through to the documentation of the model's findings and effectiveness \u003c\/li\u003e  \u003cli\u003eHow to model in Microsoft Excel, including how to set up an Excel environment, how to format worksheets, and the correct application of various modeling formulae \u003c\/li\u003e  \u003cli\u003eThe skills and knowledge they need to become more proficient financial modelers and differentiate themselves from their professional competitors.  \u003c\/li\u003e  \u003c\/ul\u003e    Who this book is for      \u003cp\u003e     Written in a clear, concise manner and filled with screen grabs that will facilitate readers' comprehension of the financial modeling process, \u003cem\u003eThe Handbook of Financial Modeling\u003c\/em\u003e is appropriate for intermediate to advanced financial modelers who are looking to learn how to enhance their modeling proficiency.         \u003c\/p\u003e     Table of Contents\u003col\u003e  \u003cli\u003e  Financial Modeling: An Overview   \u003c\/li\u003e  \u003cli\u003eFinancial Modeling Best Practices \u003c\/li\u003e  \u003cli\u003eModeling Functions and Tools \u003c\/li\u003e  \u003cli\u003ePlanning Your Model \u003c\/li\u003e  \u003cli\u003eTesting and Documenting Your Model \u003c\/li\u003e  \u003cli\u003eDesigning and Building Your Model \u003c\/li\u003e  \u003cli\u003eThe Model User: Inputs \u003c\/li\u003e  \u003cli\u003eAn Introduction to Finance and Accounting for Modelers \u003c\/li\u003e  \u003cli\u003eManaging and Evaluating a Business for Modelers \u003c\/li\u003e  \u003cli\u003eThe Implications and Rules of Accounting for Modelers \u003c\/li\u003e  \u003cli\u003eFinancial Based Calculations \u003c\/li\u003e  \u003cli\u003eLogical and Structural Based Calculations \u003c\/li\u003e  \u003cli\u003eHow to Capture Document and Track Assumptions in Your Model \u003c\/li\u003e  \u003cli\u003eModeling to Give the User Transparency \u003c\/li\u003e  \u003cli\u003eModel Testing and Auditing \u003c\/li\u003e  \u003cli\u003eModeling Handover Dos and Don'ts.  \u003c\/li\u003e  \u003cli\u003eCase Study: Building a Full Life Cycle Model \u003c\/li\u003e  \u003cli\u003eAdditional Tools and VBA for Financial Models \u003c\/li\u003e  \u003cli\u003eWhat is the Future of Financial Modeling?  \u003c\/li\u003e  \u003cli\u003eKeyboard Shortcuts \u003c\/li\u003e  \u003cli\u003eFinance and Accounting Glossary \u003c\/li\u003e  \u003cli\u003eReadymade Functions \u003c\/li\u003e  \u003cli\u003eSample Outputs \u003c\/li\u003e  \u003cli\u003eHousekeeping\u003c\/li\u003e  \u003cli\u003eReferences \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47127973003504,"sku":"9781430262060","price":63.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430262060_p0.jpg?v=1763751064","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430262060","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}