Automated financial ratios visualization modeling with excel
- 0.0
Brief Introduction
Fully automate the most important ratios in your financial statementsDescription
In this course you will learn how to build a full financial ratios analysis sheet for your business of for your investing activities.
Great financial management is the key to success in any business and financial ratios are the key indicator of how well a business is managing their finances.
From a business administration point of view you having this knowledge is essential to your continued success as you will better understand how your business is doing after you take this course.
If you are an investor it will help you visualize what has been happening over the past few periods or years at the company and therefore help you make the correct investing decisions.
Requirements
- Requirements
- Accounting knowledge
- Knowledge of financial ratios
Knowledge
- financial ratios
- data visualization
- accounting automation
- Gross Profit
- Operating Profit
- Pre Tax Profit
- Net Profit
- Profitability to Sales Ratios
- Profitability to Investment Ratios
- Return on Capital Employed
- Return on Equity
- Net asset Turnover
- Economic Value Added
- Liquidity/ Working Capital Ratios
- Current Ratio
- Quick Asset Ratio
- Collection Period
- Inventory Period
- Payments Period
- Working Capital Ratio
- Leverage Ratios
- Overall Leverage
- Bank Leverage
- Long Term Leverage
- Profit Cover for Interest