
ISBN
| 9781118904015 |
DDC
| 332 |
Tác giả CN
| Rees, Michael |
Nhan đề
| Principles of financial modelling : model design and best practices using Excel and VBA / Michael Rees |
Thông tin xuất bản
| Chichester, West Sussex : John Wiley & Sons, Ltd, 2018 |
Mô tả vật lý
| xxix, 512 pages. ; 25 cm. |
Tùng thư
| Wiley finance series. |
Phụ chú
| Includes index. |
Tóm tắt
| The comprehensive, broadly-applicable, real-world guide to financial modelling Principles of Financial Modelling - Model Design and Best Practices Using Excel and VBAcovers the full spectrum of financial modelling tools and techniques in order to provide practical skills that are grounded in real-world applications. Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts. This book integrates theory and practice to provide a high-value resource for anyone wanting to gain a practical understanding of this complex and nuanced topic. Highlights of its content include extensive coverage of: -Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking -Sensitivity and scenario analysis, simulation, and optimisation -Data manipulation and analysis -The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling The companion website provides approximately 235 Excel files (screen-clips of most of which are shown in the text), which demonstrate key principles in modelling, as well as providing many examples of the use of Excel functions and VBA macros. These facilitate learning and have a strong emphasis on practical solutions and direct real-world application. For practical instruction, robust technique and clear presentation, Principles of Financial Modelling is the premier guide to real-world financial modelling from the ground up. It provides clear instruction applicable across sectors, settings and countries, and is presented in a well-structured and highly-developed format that is accessible to people with different backgrounds. |
Từ khóa tự do
| Microsoft Office. |
Từ khóa tự do
| Microsoft Excel (Computer file) |
Từ khóa tự do
| Finance -- Mathematical models. |
Khoa
| Khoa Tài chính - Kế toán |
Địa chỉ
| 300Q12_Kho Mượn_02(2): 078449, 084268 |
|
000
| 00000nam#a2200000u##4500 |
---|
001 | 30105 |
---|
002 | 2 |
---|
004 | 9A54FF4D-B603-4887-9FE3-702498351C4A |
---|
005 | 202205031529 |
---|
008 | 211007s2018 enk eng |
---|
009 | 1 0 |
---|
020 | |a9781118904015|c2216000 |
---|
039 | |a20220503152906|btainguyendientu|c20211029162824|dnghiepvu|y20210802101443|znghiepvu |
---|
040 | |aNTT |
---|
041 | |aeng |
---|
044 | |aenk |
---|
082 | |a332|bR3281|223 |
---|
100 | |aRees, Michael |
---|
245 | |aPrinciples of financial modelling : |bmodel design and best practices using Excel and VBA / |cMichael Rees |
---|
260 | |aChichester, West Sussex : |bJohn Wiley & Sons, Ltd, |c2018 |
---|
300 | |axxix, 512 pages. ; |c25 cm. |
---|
490 | |aWiley finance series. |
---|
500 | |aIncludes index. |
---|
520 | |aThe comprehensive, broadly-applicable, real-world guide to financial modelling Principles of Financial Modelling - Model Design and Best Practices Using Excel and VBAcovers the full spectrum of financial modelling tools and techniques in order to provide practical skills that are grounded in real-world applications. Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts. This book integrates theory and practice to provide a high-value resource for anyone wanting to gain a practical understanding of this complex and nuanced topic. Highlights of its content include extensive coverage of: -Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking -Sensitivity and scenario analysis, simulation, and optimisation -Data manipulation and analysis -The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling The companion website provides approximately 235 Excel files (screen-clips of most of which are shown in the text), which demonstrate key principles in modelling, as well as providing many examples of the use of Excel functions and VBA macros. These facilitate learning and have a strong emphasis on practical solutions and direct real-world application. For practical instruction, robust technique and clear presentation, Principles of Financial Modelling is the premier guide to real-world financial modelling from the ground up. It provides clear instruction applicable across sectors, settings and countries, and is presented in a well-structured and highly-developed format that is accessible to people with different backgrounds. |
---|
541 | |aMua |
---|
653 | |aMicrosoft Office. |
---|
653 | |aMicrosoft Excel (Computer file) |
---|
653 | |aFinance -- Mathematical models. |
---|
690 | |aKhoa Tài chính - Kế toán |
---|
691 | |aTài chính ngân hàng |
---|
691 | |aTài Chính Ngân Hàng - ThS |
---|
692 | |aLập mô hình TC |
---|
852 | |a300|bQ12_Kho Mượn_02|j(2): 078449, 084268 |
---|
856 | 1|uhttp://elib.ntt.edu.vn/documentdata01/2 tailieuthamkhao/300 khoahocxahoi/anhbiasach/30105_principlesoffinancialmodellingthumbimage.jpg |
---|
890 | |a2|b2|c0|d0 |
---|
| |
Dòng |
Mã vạch |
Nơi lưu |
S.gọi Cục bộ |
Phân loại |
Bản sao |
Tình trạng |
Thành phần |
Đặt chỗ |
1
|
078449
|
Q12_Kho Mượn_02
|
332 R3281
|
Sách mượn tại chỗ
|
1
|
|
|
|
2
|
084268
|
Q12_Kho Mượn_02
|
332 R3281
|
Sách mượn tại chỗ
|
2
|
|
|
|
Không có liên kết tài liệu số nào
|
|
|
|