BUS202: Using Excel to Solve Time Value of Money Problems | Saylor Academy

Home Specialization Programs Help

These videos will help you learn to use Excel to solve the Practice and Assessment, rather than purchasing a financial calculator or using the formulas. You may also use calculating apps on your phone. Try practicing doing the homework problems with Excel.

Video 1: TVM: Future Value in Excel
Video 2: Time Value of Money using Excel

Source: Dave Alldredge, https://www.youtube.com/watch?v=pbsnv0Q6KjM
This work is licensed under a Creative Commons Attribution 3.0 License.

Source: Business Career College, https://www.youtube.com/watch?v=s4Nwc9diIsc
This work is licensed under a Creative Commons Attribution 3.0 License.

Last modified: Friday, 13 December 2024, 11:41 AM

Course Introduction

Course Syllabus

Unit 1: Introduction To Finance

1.1: Introduction to Concepts in Finance

Introducing Finance

1.2: Goal of Financial Management

Goals of Financial Management

1.3: Ethics

An Overview of Ethics

Ethics and Finance

1.4: Business Organization and Governance

Types of Business Organizations

Forms of Business Ownership

Corporate Governance

Agency and Conflicts of Interest

1.5: Asset Classes

Asset Classes

1.6: Institutions, Markets, and Intermediaries

Institutions, Markets, and Intermediaries

Financial Markets

Unit 1 Practice and Assessment

Introduction to Financial Management Exercises and Problems

Unit 2: Financial Statements and Financial Analysis

2.1: Balance Sheets and Income Statements

Introducing Financial Statements

The Income Statement

More on the Income Statement

The Balance Sheet

More on Balance Sheets

Balance Sheets and Equity

Balance Sheet and Income Statement Relationship

Tax Considerations

2.2: Cash Flow and Other Statements

Cash Accounting

Accrual Basis of Accounting

Comparing Accrual and Cash Accounting

The Statement of Cash Flows

Basic Cash Flow Statement

Other Statements

2.3: Analyzing Financial Statements

Standardizing Financial Statements

Overview of Ratios

Financial Ratio

Profitability Ratios

Asset Management Ratios

Liquidity Ratios

Market Value Ratios

Earnings and EPS

The DuPont Equation, ROE, ROA, and Growth

Using Financial Ratios for Analysis

Selected Financial Ratios and Analyses

Considering Inflation's Distortionary Effects

Other Distortions

2.4: Forecasting Financial Statements

Forecasting the Income Statement

Forecasting the Balance Sheet

Building a Cash Budget

Analyzing Forecasts

Pro Forma Statements

Financial Modeling and Pro Forma Analysis

Unit 2 Practice and Assessment

Unit 2 Financial Statement Analysis Exercises

Unit 3: Working Capital Management

3.1: Overview of Working Capital

Financial Analysis: Working Capital Example

Working Capital

3.2: Cash Management

The Importance of Cash and Cash Management

3.3: Managing Accounts Receivable

Accounts Receivable

3.4: Inventory Management

Inventory Management

3.5: Sources of Short-Term Financing

Overview of Short-Term Financing

Unit 3 Practice and Assessment

Cash and Cash Conversion Cycle Exercises

Unit 4: Time Value Of Money

4.1: The Time Value of Money

Time Value of Money

Introduction to Interest