EXCEL - FINANCE ECONOMIC ACTUARIAL

How Excel can help to visualise and simulate financial calculations.

Interest rates and discount factors

• ·         Conventions and parameters on interest rates
• ·         Simple interest calculation
• ·         Compounded interest rates
• ·         Periodic rate and continuous rate
• ·         Discount factors and capitalisation factors
• ·         Present and future values
• ·         Internal rate of return (IRR)

Interest rate curve

• ·         Term structure of interest rate
• ·         Zero coupon curve
• ·         Forward Forward rates
• ·         FRA valuation

Loan calculation

• ·         Periodic loans with constant instalment
• ·         Rate and interest
• ·         Amortization methods: linear, in fine, progressive
• ·         Loan with progressive annuity, differed loan
• ·         Calculate the economic cost of a loan

Bond calculus

• ·         Fix rates and variables rates, indexes
• ·         Bond market and bond features
• ·         Clean and dirty price
• ·         Price, yield relationship
• ·         Sensitivity and duration, convexity