Financial Modeling using Excel

In an R-assisted learning environment

 Home   Teaching  Finance  Programming  Data  Links

All chapters

  • FIN619/FIN455: syllabus
  • Textbook: preface (my book)
  •   Chapter #1: R installation/Excel basics
  •   Chapter #2: Time value of money
  •   Chapter #3: Financial statement analysis
  •   Chapter #4: Risk vs. return
  •   Chapter #5: T-test, F-test
  •   Chapter #6: Bond and stock evaluation
  •   Chapter #7: CAPM
  •   Chapter #8: FF3, FFC4, FF5, etc.
  •   Chapter #9: Various distributions
  •   Chapter #10: Black-Scholes option model
  •   Chapter #11: Monte Carlo Simulation
  •   Chapter #12: VaR (Value at Risk
  •   Chapter #13: Liquidity & high-freq data
  •   Chapter #14: Portfolio Theory
  •   Chapter #15: Credit Risk Analysis
  • -------------------------------------
  •   Chapter #16: R basics
  •   Chapter #17: Excel basics (II)
  •   Chapter #18: Data sources
  •   Chapter #19: Utility functions
  •   Chapter #20: Issues with Excel
  •   Chapter #21: Data input
  •   Chapter #22: Data manipulation
  •   Chapter #23: Data output
  •   Chapter #24: vlookup, solver
  •   Chapter #25: Simple graph
  •   Chapter #26: Excel Matrix
  •   Chapter #27: Simple VBAs
  •   Chapter #28: Simple Macros
  •   Chapter #29: Pivot Table

Download and Install R

Learning Exdel

My videos

Links

Economics & Finance Dept | add later | add later