4.52 (58 reviews)

$339.99

Regular PriceTopics

What you will learn

☑ How to read & analyze financial statements

☑ How to read & analyze financial statements

☑ How to use Excel or Google Sheets to work many practice problems

Description

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.

Content

Introduction

110 Finance, Accounting, & Economics

115 Finance Topics & Activities

120 Types of Business Organizations

125 Financial Management Goals

130 Financial Markets

Financial Statements

205 Financial Statements Overview

210 Balance Sheet Introduction

215 Balance Sheet Continued

220 Income Statement Overview

225 Income Statement Continued

230 Statement of Retained Earnings

235 Statement of Cash Flows

Practice Probs - Financial Statements

211 Earnings Per Share & Gross Profit

214 Operating Income

215 Income Statement Accounts

216 Make an Income Statement

218 Make an Income Statement Including Earning Per Share

223 Balance Sheet Current Noncurrent Classification

224 Balance Sheet & Income Statement Classification

225 Balance Sheet Alternative Formats

227 Retained Earnings & Earnings Per Share

230 Cash Flow Based on Account Activity

231 Depreciation and Cash Flow Statement

232 Free Cash Flow

233 Book Value Per Share

234 Book Value Per Share Earnings Per Share PE Ratio

237 Financial Statements Creation

238 Statement of Cash Flows

Excel Probs - Financial Statement

211 Earnings Per Share & Gross Profit

214 Operating Income

215 Income Statement Account Order

216 Make an Income Statement

218 Make an Income Statement Including Earning Per Share

220 Income Statement with Expense Unknown & Tax & Interest Expense Calculations

223 Balance Sheet Current Noncurrent Classification

224 Balance Sheet & Income Statement Classification

225 Balance Sheet Alternative Formats

226 Increase in Retained Earnings & Earnings Per Share

227 Retained Earnings & Earnings Per Share

228 Earning Per Share & Price to Earnings Ratio

230 Cash Flow Based on Account Activity

231 Depreciation and Cash Flow Statement

232 Free Cash Flow

233 Book Value Per Share

234 Book Value Per Share Earnings Per Share PE Ratio

235 Book Value Per Share Earnings Per Share PE Ratio # 2

237 Financial Statements Creation

238 Statement of Cash Flows

Financial Ratios

305 Ratio Analysis Introduction

315 DuPont System of Analysis

Practice Probs - Financial Ratios

311 Profit Margin Percent

312 Return on Investment (ROI)

313 Return on Assets, Total Asset Turnover, & Profit Margin

314 Return on Investment, Total Asset Turnover, & Profit Margin

315 Profit Margin Two Years Comparison & Income Statement

317 Expense to Sales Ratios

318 Return on Assets, Return on Equity, & Asset Turnover

325 Total Asset Turnover & Return on Equity-More Complex Relationships

326 Total Asset Turnover, Return on Equity, & Profit Margin

327 Return on Equity & Other Ratios Two Company Comparison

328 Average AR Collection Period

331 Turnover Ratios Two Year Comparison

332 Multiple Ratio Calculations

333 Times Interest Earned & Fixed Charge Coverage

337 Asset Turnover & Return on Equity Trend Analysis

338 Asset Turnover & Debt to Asset Compared to Industry

339 Net Profit Margin & ROA Division Comparison

342 Ratios to Create Current Assets Portion of Balance Sheet

343 Use Ratios to Create a Balance Sheet

344 Use Ratios to Create Account Balances

346 Comprehensive Ratio Analysis

347 P1 Comprehensive Ratio – Two Companies Part 1

347 P2 Comprehensive Ratio – Two Companies Part 2

Excel Probs - Financial Ratios

311 Profit Margin Percent

312 Return on Investment (ROI)

313 Return on Assets, Total Asset Turnover, & Profit Margin

314 Return on Investment, Total Asset Turnover, & Profit Margin

315 Profit Margin Two Years Comparison & Income Statement

317 Expense to Sales Ratios

318 Return on Assets, Return on Equity, & Asset Turnover

325 Total Asset Turnover & Return on Equity-More Complex Relationships

326 Total Asset Turnover, Return on Equity, & Profit Margin

327 Return on Equity & Other Ratios Two Company Comparison

328 Average AR Collection Period

331 Turnover Ratios Two Year Comparison

332 Multiple Ratio Calculations

333 Times Interest Earned & Fixed Charge Coverage

337 Asset Turnover & Return on Equity Trend Analysis

338 Asset Turnover & Debt to Asset Compared to Industry

339 Net Profit Margin & ROA Division Comparison

342 Ratios to Create Current Assets Portion of Balance Sheet

343 Use Ratios to Create a Balance Sheet

344 Use Ratios to Create Account Balances

346 Comprehensive Ratio Analysis # 1

347 P1 Comprehensive Ratio – Two Companies

347 P2 Comprehensive Ratio – Two Companies Part 2

Reviews

M

Mihran20 November 2020

The overall course was quite instructive, but I think that the duration could be by 2-3 times shorter

Coupons

Status | Date | Discount | ||
---|---|---|---|---|

Expired | 8/18/2020 | 95% OFF | ||

Expired | 10/28/2020 | 100% OFF | ||

Expired | 11/20/2020 | 100% OFF | ||

Expired | 12/2/2020 | 100% OFF | ||

Expired | 1/2/2021 | 100% OFF | ||

Expired | 1/28/2021 | 95% OFF | ||

Expired | 2/4/2021 | 100% OFF | ||

Expired | 3/31/2021 | 95% OFF | ||

Expired | 4/7/2021 | 100% OFF | ||

Bot

Course Submitted by