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.

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.

• Course Overview 1min
• Differentiating Accounting and Finance Concepts 13mins
• Calculating Depreciation on Fixed Assets 25mins
• Evaluating Financial Success from Cash Flows 28mins
• Comparing Projects with Constant Cash Flows 26mins
• Comparing Projects with Irregular Cash Flows 21mins
• Preparing Payment Schedules 22mins