We will learn how to read financial statements and how to use them for decision making.
A primary tool we will use is ratio analysis. Ratio analysis is a very useful skill in a wide area of topics, and financial analysis is a great place to learn the skill.
Ratios are necessary when measuring performance, including most any job performance. For example, we must apply ratio analysis when measuring the job performance of sports athletes. Similar ratio analysis will apply to most any job performance, and also apply to the performance of corporations.
Once we analyze the past performance of a corporation, we can use this knowledge to predict future performance, helping us make decisions about the company, whether those decisions be investment-related, creditor related, or managerial.
This course will include many example problems using both a presentation format and a spreadsheet format.
Corporate finance is a wonderful tool to learn, improve, and practice Excel or Google Sheets spreadsheet skills. Every spreadsheet practice problem will include a downloadable Excel file, that can be opened with Google Sheets, containing at least two tabs, one with the answer, the other with a preformatted worksheet to be filled in along with a step by step instructional video.
Financial Statements
Practice Probs - Financial Statements
Excel Probs - Financial Statement
-
13211 Earnings Per Share & Gross Profit
-
14214 Operating Income
-
15215 Income Statement Accounts
-
16216 Make an Income Statement
-
17218 Make an Income Statement Including Earning Per Share
-
18223 Balance Sheet Current Noncurrent Classification
-
19224 Balance Sheet & Income Statement Classification
-
20225 Balance Sheet Alternative Formats
-
21227 Retained Earnings & Earnings Per Share
-
22230 Cash Flow Based on Account Activity
-
23231 Depreciation and Cash Flow Statement
-
24232 Free Cash Flow
-
25233 Book Value Per Share
-
26234 Book Value Per Share Earnings Per Share PE Ratio
-
27237 Financial Statements Creation
-
28238 Statement of Cash Flows
Financial Ratios
-
29211 Earnings Per Share & Gross Profit
-
30214 Operating Income
-
31215 Income Statement Account Order
-
32216 Make an Income Statement
-
33218 Make an Income Statement Including Earning Per Share
-
34220 Income Statement with Expense Unknown & Tax & Interest Expense Calculations
-
35223 Balance Sheet Current Noncurrent Classification
-
36224 Balance Sheet & Income Statement Classification
-
37225 Balance Sheet Alternative Formats
-
38226 Increase in Retained Earnings & Earnings Per Share
-
39227 Retained Earnings & Earnings Per Share
-
40228 Earning Per Share & Price to Earnings Ratio
-
41230 Cash Flow Based on Account Activity
-
42231 Depreciation and Cash Flow Statement
-
43232 Free Cash Flow
-
44233 Book Value Per Share
-
45234 Book Value Per Share Earnings Per Share PE Ratio
-
46235 Book Value Per Share Earnings Per Share PE Ratio # 2
-
47237 Financial Statements Creation
-
48238 Statement of Cash Flows
Practice Probs - Financial Ratios
Excel Probs - Financial Ratios
-
51311 Profit Margin Percent
-
52312 Return on Investment (ROI)
-
53313 Return on Assets, Total Asset Turnover, & Profit Margin
-
54314 Return on Investment, Total Asset Turnover, & Profit Margin
-
55315 Profit Margin Two Years Comparison & Income Statement
-
56317 Expense to Sales Ratios
-
57318 Return on Assets, Return on Equity, & Asset Turnover
-
58325 Total Asset Turnover & Return on Equity-More Complex Relationships
-
59326 Total Asset Turnover, Return on Equity, & Profit Margin
-
60327 Return on Equity & Other Ratios Two Company Comparison
-
61328 Average AR Collection Period
-
62331 Turnover Ratios Two Year Comparison
-
63332 Multiple Ratio Calculations
-
64333 Times Interest Earned & Fixed Charge Coverage
-
65337 Asset Turnover & Return on Equity Trend Analysis
-
66338 Asset Turnover & Debt to Asset Compared to Industry
-
67339 Net Profit Margin & ROA Division Comparison
-
68342 Ratios to Create Current Assets Portion of Balance Sheet
-
69343 Use Ratios to Create a Balance Sheet
-
70344 Use Ratios to Create Account Balances
-
71346 Comprehensive Ratio Analysis
-
72347 P1 Comprehensive Ratio – Two Companies Part 1
-
73347 P2 Comprehensive Ratio – Two Companies Part 2