MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Financial Function in Excel

### Course Summary

The course explains various finance related function in excel which are essential for a financial analyst.

• +

### Course Syllabus

• Introduction
• Introduction and Contents of the Course
• Time Value Function - Basics
• Time Value of Money Explained
• Interest Rate of Equal Cash Flows Occuring at Yearly Intervals
• Interest Rate of Equal Cash Flows Occuring at Monthly and Quarterly Intervals
• Present Value of Equal Cash Flows Occurring at Regular Intervals
• Future Value of Equal Cash Flows Occuring at regular Intervals
• Calculating EMI - Car Loan Case Study
• EMI - Effect of change in Floating Rates - Home Loan Case Study
• Exercises for basic Time Value of Money functions
• Solutions for Basic Time Value of Money functions exercises
• Time Value Functions for Unequal Cash Flows and Unequal Intervals
• Present value of Cash Flows When Cash Flows Occuring at Regular Intervals
• Interest rate for Unequal Cash Flows Occurring in Regular Intervals
• Interest rate for Unequal Cash Flows Occurring at Ir-regular Intervals
• Exercises for time value of money with irregular cash flows
• Solution for Time value of Money functions with irregular cash flows Exercises
• Nominal and Effective Interest Rates
• Exercises for Effective & Nominal rate conversion
• Solution for exercise on effective and nominal interest rate conversion
• Fixed Income Functions
• Bonds - An Intrduction
• Converting Quoted Price to Dollar Price and Vice Versa
• Bond Yield
• Bond Yield with Day Count Convention
• Bond Duration (Macaulay Duration)
• Bond Modified Duration
• Bond Accrued Coupon
• Bond Clean and Dirty price
• Zero Coupon Bond - Price and Yield
• Exercises for Fixed Income Functions
• Exercises for Fixed Income Functions - Solutions
• Discounted Cash Flow
• DCF- a) With exactly 1 year left for 1st Cash Flow; b) Elapsed Time
• Depreciation of Assets
• Straight Line Depreciation
• Double Declining Balance Depreciation
• Exercise Questions - Miscallneous
• Exercise Solution - Miscallneous
• Summary
• Summary

Course Fee:
USD 24

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts: