Analyzing Financial Results in Excel

Focused View

Brent Allen

2:19:18

0 View

1-Course Overview

1 -Course Overview.mp4

01:23

2-Differentiating Accounting and Finance Concepts

2 -Accounting vs. Finance for IT.mp4

04:26

3 -Excel Functions Overview.mp4

03:50

4 -Finance Schedules Overview.mp4

03:59

5 -Summary.mp4

00:46

3-Calculating Depreciation on Fixed Assets

6 -What Is Depreciation.mp4

04:42

7 -Calculating Straight Line Depreciation.mp4

03:10

8 -Declining Balance Depreciation Methods.mp4

06:39

9 -Hybrid Depreciation.mp4

02:11

10 -Demo Using Straight Line in Excel.mp4

04:05

11 -Demo Using Variable Declining in Excel.mp4

01:36

12 -Demo Comparing Depreciation Methods in Excel.mp4

02:39

13 -Summary.mp4

00:55

4-Evaluating Financial Success from Cash Flows

14 -What Is Compound Interest.mp4

02:33

15 -Compound Interest Rate Formulas in Excel.mp4

01:50

16 -Calculating Future Value.mp4

06:23

17 -Calculating Present Value.mp4

06:29

18 -Uneven Cash Flows Net Present Value.mp4

06:44

19 -Demo Evaluation of Software Purchase Using NPV.mp4

03:33

20 -Summary.mp4

00:52

5-Comparing Projects with Constant Cash Flows

21 -Strengths and Weaknesses of NPV.mp4

04:34

22 -Payback Period.mp4

04:15

23 -Profitability Index.mp4

04:10

24 -Internal Rate of Return.mp4

05:04

25 -Demo Evaluating Multiple Projects.mp4

07:11

26 -Summary.mp4

00:53

6-Comparing Projects with Irregular Cash Flows

27 -Working with Irregular Cash Flows.mp4

04:00

28 -Irregular Cash Flow NPV in Excel.mp4

04:08

29 -Project Evaluation with Irregular Cash Flows.mp4

03:59

30 -Demo Comparing 2 Investments with Irregular Cash Flows.mp4

08:39

31 -Summary.mp4

00:48

7-Preparing Payment Schedules

32 -What Is a Payment Schedule.mp4

02:58

33 -Schedule Requirements.mp4

03:18

34 -Manual Calculation of a Loan Schedule.mp4

04:56

35 -Excel Loan Functions.mp4

04:46

36 -Demo Building a Payment Schedule.mp4

05:52

37 -Summary.mp4

01:02

Description

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.

What You'll Learn?

When working with business partners, you need to know how projects generate money for the business! In this course, Analyzing Financial Results in Excel, you will learn foundational knowledge in Excel financial formulas, in the context of evaluating IT projects. First, you will learn asset depreciation formulas. Next, you will discover evaluating projects using discounted cash flows. Finally, you will explore how to generate a loan schedule using Excel. When you are finished with this course, you will have the skills and knowledge of Excel formulas needed for monitoring cash flow and evaluating projects on a financial basis.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Brent Allen

Instructor's Courses

Brent Allen is a finance and technology professional with an MBA from Queen's University and is a Certified Professional Accountant in Canada. He has worked as a finance and technology professional for large businesses across multiple sectors, including TD Securities, McDonald's and BentallGreenOak. In his roles as a financial and business analyst, he has been responsible for automating key financial processes using Excel, Access and VBA. He has acted as a system owner for key financial systems, training both finance and technology teams on processes and systems. He believes in the constant improvement of financial processes using the Microsoft Power Platform, as well as other modern methods for ingestion, analysis and presentation of data. When not deep in a spreadsheet or database, he enjoys following the local Toronto sports teams, and is an avid NFL fantasy football team manager.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.