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 Interest
2. Invoice Price
3. Payment
4. Cash flow table with correct periods
6. Duration
7. Modified Duration
8. Convexity
9. Predicted invoice price change
a. With actual price
b. With duration
c. 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