Financial Modelling Final Exam Prep PDF
Document Details
Uploaded by Deleted User
Handelshøyskolen BI
Tags
Related
Summary
This document is a study guide for the final exam in financial modelling. It covers financial calculation methods in Excel, portfolio modeling, and corporate valuation. It provides a list of Excel functions, formulas, and key concepts related to each topic.
Full Transcript
lOMoARcPSD|29308817 Financial modelling - Final exam preperation Financial Decision making with Excel (Handelshøyskolen BI) Skann for å åpne på Studocu Studocu er ikke sponset eller støttet av noen universitet eller høyskole Lastet ned av...
lOMoARcPSD|29308817 Financial modelling - Final exam preperation Financial Decision making with Excel (Handelshøyskolen BI) Skann for å åpne på Studocu Studocu er ikke sponset eller støttet av noen universitet eller høyskole Lastet ned av henrik dale ([email protected]) lOMoARcPSD|29308817 Financial modelling – Final exam preperation This course has six topics presented in the lectures, including the lab work. The purpose of this document is to prepare for the final exam on the 27 of April. Each topic should include all covered material and the formulas used. Contents List of excel functions:............................................................................................................................... 1 Other excel functionalities:....................................................................................................................... 1 1. Topic 1 – Basic financial calculations................................................................................................. 2 2. Topic 2 – Portfolio models I & II........................................................................................................ 4 3. Topic 3 – Excel visual basic application........................................................................................... 15 4. Topic 4 – Corporate valuation I + II.................................................................................................. 20 List of excel functions: make a quiz of this** 1. =NPV(rate; value1; [value2];…) 2. =PV(rate; nper; pmt; [fv]; [type]) 3. =XNPV(rate; values; dates) 4. =IRR(values; [guess]) 5. =XIRR(values; dates; [guess]) 6. =NXIRR(values; dates; [guess]) 7. =FV(rate; nper; pmt; [pv]; [type]) 8. =PMT(rate; nper; pv; [fv]; [type]) 9. =RATE(nper; pmt; pv; [fv]; [type]; [guess]) 10. =MMULT(array1; array2) 11. =TRANSPOSE(array) 12. =MINVERSE(array) 13. {=bltracking(array)} 14. {=VarCovar(returns)} 15. {=SIM(returns; market returns)} 16. {=CorrMatrixTriangular(return; =averageIF(corrmatrixtriangular;"
