Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.
