وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Excel for Corporate Finance Professionals

سرفصل های دوره

Learn how to use Excel for the bread-and-butter tasks required by corporate finance and financial planning and analysis (FP&A) professionals. In this hands-on course, Professor Michael McDonald steps through how to leverage this powerful tool for capital budgeting and corporate investment selection at your firm, determine your firm's cost of capital, and perform operational budgeting. Michael explains how to estimate weighted average cost of capital (WACC), build a budget, perform stress testing and scenario analysis, and more. Throughout the course, Michael includes exercises and downloadable exercise files that can give you a practical understanding of these key topics.


01 - Introduction
  • 01 - Excels tools for corporate finance

  • 02 - 1. Critical Tasks in Corporate Finance
  • 01 - Describe corporate finance and its purpose
  • 02 - Explore project selection in finance
  • 03 - Explain the weighted average cost of capital and capital structure
  • 04 - Estimate cash flows in budgeting
  • 05 - Financial ratios and Excel
  • 06 - Valuation tools and Excel
  • 07 - Build scenarios and stress tests in Excel

  • 03 - 2. Project Selection in Excel
  • 01 - Define a capital budgeting scenario in Excel
  • 02 - Build out a series of capital budgeting scenarios
  • 03 - Perform NPV tests
  • 04 - Perform IRR tests
  • 05 - Perform PBP and MIRR tests
  • 06 - Scenario analysis in Excel
  • 07 - NPV and scenario analysis
  • 08 - Evaluate Excel models for accuracy

  • 04 - 3. WACC and Capital Structure in Excel
  • 01 - Capital structure in Excel
  • 02 - Describe the concept of WACC
  • 03 - Build out a set of capital structure options in Excel
  • 04 - Demonstrate changes in capital structure
  • 05 - Estimate WACC in Excel for a capital structure
  • 06 - Show sensitivity of WACC to changes in capital structure
  • 07 - Determine optimal WACC
  • 08 - Adjusting WACC for risk

  • 05 - 4. Operational Budgeting in Excel
  • 01 - Introduce operational budgeting in Excel
  • 02 - Demonstrate building a budget in Excel
  • 03 - Add CAGRs to Excel for long-term assumptions
  • 04 - Build percent of sales assumptions for expense
  • 05 - Link budget to pricing and sales assumptions
  • 06 - Provide stress test tools for budgets in Excel

  • 06 - 5. Valuation in Excel
  • 01 - Valuation of assets in Excel
  • 02 - Estimation of cash flows
  • 03 - Determine a discount rate
  • 04 - Identify the valuation
  • 05 - Stress testing the valuation model

  • 07 - Conclusion
  • 01 - Continue your corporate finance journey with Excel
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 24094
    حجم: 500 مگابایت
    مدت زمان: 197 دقیقه
    تاریخ انتشار: 12 آذر 1402
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید