Excel: Financial Functions in Depth

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

Analyzing financial data can seem intimidating, but Microsoft Excel has a wide range of functions to perform these calculations quickly and easily. In this course, Microsoft MVP Danielle Stein Fairhurst shows you how and when to use each of the financial functions available in Excel. Danielle covers evaluating loans, payments, and interest; calculating depreciation; determining rates of return; calculating prices and yields as well as applying some of the new features of Excel for Microsoft 365 to financial data. Plus, she guides you through combining these functions to perform financial analysis.

01 - Introduction

01 - Perform financial analysis in Excel

02 - What you should know

03 - Disclaimer

02 - 1. Analyzing Loans, Payments, and Interest

01 - PMT Calculate a loan payment

02 - PPMT and IPMT Calculate the principal and interest payments

03 - Splitting interest and principal payments

04 - CUMPRINC and CUMIPMT Cumulative principal and interest

05 - EFFECT and NOMINAL Nominal and effective interest rates

06 - ACCRINT and ACCRINTM Calculate accrued investments interest

07 - RATE Discover the interest rate of an annuity

08 - PDURATION Calculate the periods to reach a goal

09 - NPER Calculate the number of periods in an investment

03 - 2. Calculate Depreciation

01 - SLN Depreciation using the straight line method

02 - DB Depreciation using the declining balance method

03 - DDB Depreciation using the double-declining balance method

04 - SYD Calculate depreciation for a specified period

05 - VDB Declining balance depreciation for a partial period

06 - Comparing depreciation functions

04 - 3. Determining Values and Rates of Return

01 - FV Future value of an investment

02 - FVSCHEDULE Future value with variable returns

03 - Escalating with compounding interest or growth rates

04 - PV Present value of an investment

05 - NPV Net present value of an investment

06 - XNPV Net present value given irregular inputs

07 - IRR Internal rate of return

08 - XIRR Internal rate of return for irregular cash flows

09 - MIRR Internal rate of return for mixed cash flows

10 - RRI The interest rate for the growth of an investment

05 - 4. Functions and Data Types in Excel for Microsoft 365

01 - STOCKHISTORY Get historical stock prices

02 - Live stock prices with Stocks data types

03 - Calculate exchange rates with Currencies data types

04 - FIELDVALUE Get field data

05 - STOCKHISTORY with data types

06 - Charting STOCKHISTORY with data types

06 - 5. Combining Functions Perform Financial Analysis

01 - EOMONTH, EDATE, and timing flags

02 - Calculate pro data rental costs with date functions

03 - IF Building logical comparisons

04 - Calculating the payback period

05 - Using RATE or RRI for compound annual growth rate (CAGR)

06 - Creating a debt schedule

07 - Using SLN and IF to calculate depreciation

08 - Creating a depreciation schedule

09 - Using dynamic arrays to create a depreciation waterfall

10 - Calculating weighted average cost of capital (WACC)

11 - Using NPV to calculate a discounted cash flow (DCF)

07 - Conclusion

01 - Where to learn more about Excel

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

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

تولید کننده: LinkedIn Learning (Lynda)