Financial Analysis in Excel: Asset Management Ratios
4.1 (137 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,659 students enrolled

Financial Analysis in Excel: Asset Management Ratios

Learn Excel modelling to analyze financial statements for the assessment of a firm's asset management performance
4.1 (137 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,659 students enrolled
Created by Md Mohan Uddin
Last updated 4/2020
English
English [Auto]
Current price: $23.99 Original price: $39.99 Discount: 40% off
1 hour left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Explain different asset management ratios
  • Mathematical definitions of the asset management ratios
  • Calculate the asset management ratios in Excel using publicly available financial statements
  • Interpret the asset management ratios of a firm
  • Assess a firm's asset management performance over time and in comparison to cross-sectional standards
Requirements
  • Ability to use internet and computer
Description

Financial Analysis in Excel: Asset Management Ratios

Learn Excel modelling to analyze financial statements for the assessment of a firm's asset management performance


Last Update: October 07, 2019.


> Do you use or plan to use spreadsheet software like Excel for financial analysis, modelling, and valuation? 

> Do you have issues in understanding the concept of asset management and firm performance? 

> Are you a (personal/business) financial decision maker who needs to learn financial statement analysis? 

> Do you calculate financial ratios but do not know how to create a model of those calculations in Excel? 

        > Do you calculate financial ratios but do not know how to interpret those? 

> Are you planning for being a professional financial analyst like CFA in the area of Finance? 

> Are you a manager, investor, creditor, supplier, regulator, or any other stakeholder of a business organization? 


If your answer is 'YES' to any one of the above questions, THIS COURSE IS THE PERFECT ONE FOR YOU TO START WITH... 


What you'll learn:

  1. Explain different asset management ratios

  2. Mathematical definition of the asset management ratios

  3. Calculate the asset management ratios in Excel using publicly available financial statements

  4. Interpret the asset management ratios of a firm

  5. Assess a firm's asset management performance over time and in comparison to cross-sectional standards

This course consists of several video lectures that will be updated over time and based on students' requests, quizzes at the end of every section for testing your level of understanding, and additional resources. The lectures contain explanations of necessary concepts along with examples and illustrations.

The instructor welcomes his students for continuous discussion with him. Any sort of input for improving the course is also appreciated. He also expects your positive and genuine review and rating of the course.

Who this course is for:
  • Beginners interested to learn financial and performance analysis in Excel or other spreadsheet software
Course content
Expand all 14 lectures 47:07
+ Getting the Excel workbook ready
2 lectures 07:49

The financial statements are freely available in the US Securities and Exchange Commission EDGAR database. After completing this lecture students will be able to download the annual report of the firm to be analyzed. The annual report contains the financial statements and other financial information that would be needed for the analysis.

Preview 05:01

The downloaded Excel file contains much information about the company in many worksheets. After completing this lecture, students will be able to extract only the needed financial statements in a working Excel workbook. This is useful to save the analyst from information overload.

Preview 02:48
+ Inventory Turnover Ratio
3 lectures 14:03

Inventory Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to define and explain Inventory Turnover Ratio and interpret the calculated Inventory Turnover Ratio using real world financial data in the Excel spreadsheet as demonstrated in another lecture of this course.

Inventory Turnover Ratio - What it is and what it indicates
07:56

Inventory Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to calculate the Inventory Turnover Ratio of a real world business firm in Excel spreadsheet as demonstrated in this lecture.

Calculating the Inventory Turnover Ratio in Excel
01:55

Inventory Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to interpret the calculated Inventory Turnover Ratio of a real world business firm.

Interpretation of Inventory Turnover Ratio using Excel Chart
04:12
+ Days Sales Outstanding
3 lectures 08:52

Days Sales Outstanding is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to define and explain Days Sales Outstanding and interpret the calculated Days Sales Outstanding using real world financial data in the Excel spreadsheet as demonstrated in another lecture of this course.

Days Sales Outstanding - What it is and what it indicates
02:54

Days Sales Outstanding is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to calculate the Days Sales Outstanding of a real world business firm in Excel spreadsheet as demonstrated in this lecture.

Preview 01:57

Days Sales Outstanding is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to interpret the calculated Days Sales Outstanding of a real world business firm.

Interpretation of Days Sales Outstanding using Excel Chart
04:01
+ Fixed Assets Turnover Ratio
3 lectures 08:29

Fixed Assets Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to define and explain Fixed Assets Turnover Ratio and interpret the calculated Fixed Assets Turnover Ratio using real world financial data in the Excel spreadsheet as demonstrated in another lecture of this course.

Preview 03:26

Fixed Assets Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to calculate the Fixed Assets Turnover Ratio of a real world business firm in Excel spreadsheet as demonstrated in this lecture.

Calculating the Fixed Assets Turnover Ratio in Excel
01:26

Fixed Assets Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to interpret the calculated Fixed Assets Turnover Ratio of a real world business firm.

Interpretation of Fixed Assets Turnover Ratio using Excel Chart
03:37
+ Total Assets Turnover Ratio
3 lectures 07:54

Total Assets Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to define and explain Total Assets Turnover Ratio and interpret the calculated Total Assets Turnover Ratio using real world financial data in the Excel spreadsheet as demonstrated in another lecture of this course.

Total Assets Turnover Ratio - What it is and what it indicates
03:30

Total Assets Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to calculate the Total Assets Turnover Ratio of a real world business firm in Excel spreadsheet as demonstrated in this lecture.

Calculating the Total Assets Turnover Ratio in Excel
01:18

Total Assets Turnover Ratio is an asset management ratio for the assessment of the asset management performance of a firm. After completing this lecture students should be able to interpret the calculated Total Assets Turnover Ratio of a real world business firm.

Interpretation of Total Assets Turnover Ratio using Excel Chart
03:06