Building Financial Statements in Excel
4.2 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,210 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Building Financial Statements in Excel to your Wishlist.

Add to Wishlist

Building Financial Statements in Excel

Learn how to build financial models and use financial ratios in Excel
4.2 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,210 students enrolled
Created by ThinkTank Careers
Last updated 9/2017
English
Current price: $10 Original price: $35 Discount: 71% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build their own balance sheet, income statement, and cash flow statement
  • Use financial ratios to analyze financial statements
  • Build debt schedules and PP&E schedules
View Curriculum
Requirements
  • You should be able to download Excel for your computer
  • You should be able to use Excel at a beginner level
Description

Why this course is for you

You want to learn about financial statements.  You want to learn how to build your own financial statements accurately and efficiently.  You want to learn how to analyze the numbers in your financial statements. 

This course will teach you about the three main financial statements (Income statement, balance sheet, and cash flow statement.  You will learn how to build your own models in Excel including debt schedules and PP&E schedules.  You will also learn how to use financial ratios to effectively analyze the numbers in your financial statements.

What you will learn:

  1. What the financial statements are (income statement, balance sheet, and cash flow statement)
  2. How to build integrated financial statements in Excel
  3. How to build supporting financial schedules
  4. The different financial ratios
  5. How to use financial ratios to analyze your company

What you will need:

  1. A computer, laptop, or tablet
  2. Microsoft Excel
  3. Hunger to learn

30-day money back guarantee

In the rare case that you feel the course was not helpful or isn't for you I will refund your money up to 30 days.  You have nothing to lose and everything to gain

Who is the target audience?
  • Anyone who wants to better understand the three accounting statements
  • Anyone who wants to learn how to build and format accounting statements accurately
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
01:14:11
+
Introduction
3 Lectures 02:11


Download Course Worksheets Here
00:13
+
Building Financial Statements
6 Lectures 35:13


Building the Balance Sheet
08:17

Building the Cash Flow Statement
05:08

Building the Debt Schedule
08:56

Building the PPE Schedule
05:00
+
Ratio Analysis
5 Lectures 22:40
Ratio Analysis Overview
02:03

Performance Ratios
10:15

Liquidity Ratios
04:07

Financing Ratios
03:03

Activity Ratios
03:12
+
Conclusion
1 Lecture 00:50
Conclusion
00:50
About the Instructor
ThinkTank Careers
4.3 Average rating
39 Reviews
5,051 Students
5 Courses
ThinkTank Careers

ThinkTank Careers is a team of professional businessmen and women who have come together to educate individuals in our respective professions.  All of our teachers are college graduates with years of work experience in our fields. Our careers range from finance to management to bloggers. We are diverse group of individuals who hope to educate as many students as possible.