Analyzing Financial Results in Excel

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

This course provides an overview of some major financial schedules that are completed in Excel for cash flow management and project evaluation, as well as key Excel financial functions.

1-Course Overview

1 -Course Overview

2-Differentiating Accounting and Finance Concepts

2 -Accounting vs. Finance for IT

3 -Excel Functions Overview

4 -Finance Schedules Overview

5 -Summary

3-Calculating Depreciation on Fixed Assets

6 -What Is Depreciation

7 -Calculating Straight Line Depreciation

8 -Declining Balance Depreciation Methods

9 -Hybrid Depreciation

10 -Demo Using Straight Line in Excel

11 -Demo Using Variable Declining in Excel

12 -Demo Comparing Depreciation Methods in Excel

13 -Summary

4-Evaluating Financial Success from Cash Flows

14 -What Is Compound Interest

15 -Compound Interest Rate Formulas in Excel

16 -Calculating Future Value

17 -Calculating Present Value

18 -Uneven Cash Flows Net Present Value

19 -Demo Evaluation of Software Purchase Using NPV

20 -Summary

5-Comparing Projects with Constant Cash Flows

21 -Strengths and Weaknesses of NPV

22 -Payback Period

23 -Profitability Index

24 -Internal Rate of Return

25 -Demo Evaluating Multiple Projects

26 -Summary

6-Comparing Projects with Irregular Cash Flows

27 -Working with Irregular Cash Flows

28 -Irregular Cash Flow NPV in Excel

29 -Project Evaluation with Irregular Cash Flows

30 -Demo Comparing 2 Investments with Irregular Cash Flows

31 -Summary

7-Preparing Payment Schedules

32 -What Is a Payment Schedule

33 -Schedule Requirements

34 -Manual Calculation of a Loan Schedule

35 -Excel Loan Functions

36 -Demo Building a Payment Schedule

37 -Summary

139,000 تومان

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

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

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

تولید کننده: PluralSight