03307oam 2200637I 450 991078684820332120200520144314.01-134-62027-60-415-63058-41-134-62020-90-203-36288-810.4324/9780203362884 (CKB)2670000000386494(EBL)1221497(OCoLC)852757405(SSID)ssj0000915705(PQKBManifestationID)12393278(PQKBTitleCode)TC0000915705(PQKBWorkID)10869499(PQKB)10442457(OCoLC)849928748(Au-PeEL)EBL1221497(CaPaEBR)ebr10723447(CaONFJC)MIL499826(OCoLC)1136540533(FINmELB)ELB131726(CaSebORM)9780415625968(MiAaPQ)EBC1221497(EXLCZ)99267000000038649420180706d2013 uy 0engur|n|---|||||txtccrFinancial modelling and asset valuation with Excel /Morten Helbæk, Ragnar Løvaas and Jon Mjølhus1st editionLondon ;New York :Routledge,2013.1 online resource (447 p.)Includes index.1-299-68576-5 0-415-62596-3 Excel -- Getting started -- Formulas and functions -- Charts and tables -- What-if analysis -- Data analysis -- Basic finance -- Time value of money -- Investments -- Risk and portfolio models -- Valuation -- Valuation of investments and projects -- Real estate -- Bonds -- Stocks -- Options -- Simulations -- Monte Carlo simulations -- VBA -- Visual basic for applications -- Programming in VBA -- Control structures -- Working with VBA -- Procedures -- Arrays -- Userforms.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.FinanceMathematical modelsComputer programsFinanceMathematical modelsComputer programs.332.0285/554Helbæk Morten.859769Løvaas Ragnar1950-1520639Mjølhus Jon1520640FlBoTFGFlBoTFGBOOK9910786848203321Financial modelling and asset valuation with Excel3759357UNINA