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
• Converting Nominal Return to Effective Return
• Converting Effective Return to Nominal Return
• 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:

## C Plus Plus (C++)

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software