000 02272nam a22002537a 4500
999 _c1847
_d1847
005 20220311103922.0
008 220301b ||||| |||| 00| 0 eng d
020 _a9781138948143
082 _a332.0285554
_bHEL
100 _aHelbaek, Morten
_95889
245 _aFinancial modelling and asset valuation with Excel
260 _bRoutledge
_aOxon
_c2022
300 _axiv, 430 p.
365 _aINR
_b2195.00
504 _aTable of Contents Part I: Excel 1. Getting Started 2. Formulas and Functions 3. Charts and Tables 4. What-If Analysis 5. Data Analysis Part II: Basic Finance 6. Time Value of Money 7. Investments 8. Risk and Portfolio Models Part III: Valuation 9. Valuation of investments and projects 10. Real Estate 11. Bonds 12. Stocks 13. Options Part IV: Simulations 14. Monte Carlo Simulations Part V: VBA 15. Visual Basic for Applications 16. Programming in VBA 17. Control Structures 18. Working with VBA 19. Procedures 20. Arrays 21. UserForms
520 _aBook Description Finance is Excel! This book takes you straight into the fascinating world of Excel, the powerful tool for number crunching. In a clear cut language it amalgamates financial theory with Excel providing you with the skills you need to build financial models for private or professional use. A comprehensive knowledge of modeling in Excel is becoming increasingly important in a competitive labour market. The chapters in part one start with the most basic Excel topics such as cell addresses, workbooks, basic formulas, etc. These chapters get more advanced through part one, and takes you in the end to topics such as array formulas, data tables, pivot tables, etc. The other parts of the book discusses a variety of subjects such as net present value, internal rate of return, risk, portfolio theory, CAPM, VaR, project valuation, asset valuation, firm valuation, loan, leasing, stocks, bonds, options, simulation, sensitivity analysis, etc.
650 _aFinance--Mathematical models--Computer programs
_95890
650 _aMicrosoft Excel (Computer file)
_9850
650 _aCapital assets pricing model
_95476
650 _aHedging (Finance)
_95269
700 _aLovaas, Ragnar
_95891
700 _aMjolhus, Jon Olav
_95710
942 _2ddc
_cBK