Fin 405 Final Exam prep
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
Fin 405
Final Exam prep
Last two topic outline
I. Bonds
A. Functions used
1. COUPxxx
2. PRICE
3. YIELD
4. EDATE
5. EOMONTH
B. Calculations
1. Accrued Interest2. Invoice Price3. Payment4. Cash flow table with correct periods6. Duration7. Modified Duration8. Convexity9. Predicted invoice price change
a. With actual priceb. With durationc. With duration and convexity
10. Realized Compound Yield
C. VBA
1. Duration
2. Convexity
3. For loops
4. RCY
Portfolio
D. Functions
1. SUMPRODUCT
2. MMULT
3. SQRT
4. MAX
E. Calculations
1. Portfolio Expected Return
2. Portfolio Standard Deviation
3. Covariance between two portfolios with a common VCOV matrix
4. 2-Asset portfolio
a. Return
b. Risk
5. Data Tables
6. Advanced Graphing
7. SOLVER
8. Utility
9. Finding the Tangent Portfolio
10. Graphing the Tangent CAL
11. Finding the individual Security weights and # shares
F. VBA
1. Spinner/Scroll Bar button
2. Command Button
3. Macro to run solver
4. Input boxes
5. Msg Boxes
6. Cleaning up code after recording
2021-12-10