This course
gives hands on learning experience in understanding the basics of MS excel
usage in the finance domain. The course delivery starts with the basic excel functions
like working with cells, formatting rows and columns, key finance functions like
sum, average, count, countif, countA, Max, min, rand and many more will be discussed
and solved using simple problems. The course navigates through the application
of time value of money concept like present value, future value and loan amortization.
Long term investment decision techniques like NPV, XNPV, IRR, XIRR, MIRR
functions are explored using case studies. Problems on risk analysis techniques
like simulation, sensitivity and scenario will be solved in different finance domains.
Analysis of the ideal capital structure decision using the WACC approach and
very importantly the forecasting of financial statements (income statement, balance
sheet and cash flow statement) will be constructed using different methods.
| Course Status : | Upcoming |
| Course Type : | Core |
| Language for course content : | English |
| Duration : | 6 weeks |
| Category : |
|
| Credit Points : | 3 |
| Level : | Postgraduate |
| Start Date : | 15 Jul 2025 |
| End Date : | 31 Oct 2025 |
| Enrollment Ends : | 31 Aug 2025 |
| Exam Date : | |
| Translation Languages : | English |
| NCrF Level : | 6.5 |
| Industry Details : | Banking & Financial Services |
Week 1: Overview of Excel Functions
Week 2: Time Value of Money
Week 3: Capital Budgeting Techniques
Week 4: Risk Analysis in Capital Budgeting
Week 5: Capital Structure Analysis
Week 6: Financial Forecasting Models
Dr. Premalatha K P is a professional educator
with a doctoral degree from university of Mysore holds a decade of teaching
experience in both UG and PG educational institutions. A goal driven person who
bagged gold medal for completing her Masters of Business Administration degree
with First Class Distinction in all the 4 semesters. She is an enthusiastic
faculty member worked for both commerce and management departments with her
domain expertise in finance. Premalatha has published many papers in Scopus, Wiley,
IEEE explore, UGC care and other peer reviewed journals and books. Presented
papers in various national and international level conferences and seminars.
She has actively organized and conducted student development activities, case
study cells, working paper series events and coordinated various finance
interest group activities at JAIN University. Currently working as assistant
professor at JAIN (deemed to be University) in the finance area her expertise
lies in financial management, corporate valuation, risk and derivatives
management and financial strategy. She delivers expert talks as a resource
person for faculty enrichment programs, workshops and training programs
organized by corporate and academic clients.
Enrolling and learning from the course is free. However, if you wish to obtain a certificate, you must register and take the proctored exam in person at one of the designated exam centre’s. The registration URL will be announced when the registration form is open. To obtain the certification, you need to fill out the online registration form and pay the exam fee. More details will be provided when the exam registration form is published, including any potential changes. For further information on the exam locations and the conditions associated with filling out the form, please refer to the form.
Grading Policy:
Assessment Type | Weightage |
Weekend Assessment | 25% |
Final Exam | 75% |
Certificate Eligibility:
Score | Type of Certificate |
>=90 | Gold |
76 - 89 | Silver |
61 - 75 | Bronze |
40 - 60 | Successfully Completed |
<39 | No Certificate |
Sample Certificate:
Disclaimer: In order to be eligible for the certificate, you must register for enrolment and exams using the same email ID. If different email IDs are used, you will not be considered eligible for the certificate.
DOWNLOAD APP
FOLLOW US