The Basics of Financial Modeling

توانایی ایجاد و درک مدل‌های مالی که ارزیابی یک شرکت، پروژه‌هایی را که انجام می‌دهد و پیش‌بینی‌های درآمد/سود آتی آن را ارزیابی می‌کند، یکی از ارزشمندترین مهارت‌ها در امور مالی شرکت است. با این حال، در حالی که بسیاری از متخصصان کسب و کار با صورت های مالی و گزارش های حسابداری آشنا هستند، تعداد کمی از آنها واقعاً در ساختن یک مدل مالی دقیق و مؤثر از ابتدا مهارت دارند. در کتاب کوتاه خود، مبانی مدلسازی مالی—خلاصه ای از کتابچه راهنمای مدلسازی مالیش—جک آون تجهیز می کند. متخصصان مالی با مروری اجمالی از ابزارهایی که برای نظارت بر دارایی‌های یک شرکت و پیش‌بینی عملکرد آینده و چشم‌انداز آن برای ابتکارات خاص نیاز دارند.

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. In his short book, The Basics of Financial Modeling—an abridgement of his Handbook of Financial Modeling—Jack Avon equips financial professionals with a quick overview of the tools they need to monitor a company's assets and project its future performance and prospects for specific initiatives.

What you’ll learn

• Key financial modeling principles, including best practices, principles around calculations, and the importance of producing clean, clear financial models
• How to design and implement a projection model that allows the user to change inputs quickly for sensitivity testing
• The 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
• How 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
• The skills and knowledge they need to become more proficient financial modelers and differentiate themselves from their professional competitors.

Who this book is for

Written in a clear, concise manner and filled with screen shots that will facilitate readers' comprehension of the financial modeling process, The Basics of Financial Modeling is appropriate for those new to financial modeling as well as those who would like to enhance their modeling proficiency.

Table of Contents