Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn corporate financial management fundamentals through this comprehensive 20-hour course that combines finance theory with practical Excel applications. Master essential financial concepts including cash flow analysis, financial statement interpretation, and investment valuation while developing proficiency in Excel's financial functions and formulas. Explore balance sheets, income statements, and cash flow statements to understand how accounting information translates into financial decision-making tools. Analyze financial ratios for liquidity, leverage, efficiency, and profitability assessment, including DuPont analysis and market value ratios. Calculate time value of money concepts including present value, future value, annuities, and perpetuities using Excel's built-in financial functions. Study bond valuation, yield calculations, interest rate risk, and the relationship between bond prices and market rates. Learn stock valuation methods including dividend discount models, preferred stock analysis, and growth model applications. Master capital budgeting techniques such as Net Present Value (NPV), Internal Rate of Return (IRR), payback period, and profitability index calculations. Understand cash flow estimation for investment projects, including tax implications, depreciation effects, and scenario analysis. Explore risk and return concepts including portfolio theory, diversification benefits, beta calculations, and the Capital Asset Pricing Model (CAPM). Practice with real-world examples covering retirement planning, loan amortization, credit card payoff calculations, and investment analysis. Develop skills in creating financial models, performing sensitivity analysis, and building comprehensive spreadsheet solutions for complex financial problems.
