Financial Analysis Spreadsheet

The financial analysis spreadsheet template conducts financial ratio analysis, business KPIs, profitability, economic trends, compare industry benchmark, by examining PESTLE and WACC and financial statements. Overall, a central focus of financial analysis is evaluating the company’s ability to earn a return on its capital and to generate enough cash to meet obligations and pursue opportunities. The fundamental financial analysis used real-time and historical data to prepares for 3 years financial models to predicts if the identify projects or business expansion is profitable. The business operating Ratios -Inventory Turnover, Receivable Turnover & Payable Turnover, Investment Ratios Operating Cash Flow / EBIT, Capital Expenditure / Revenue and Capital Expenditure / DepreciationThe Valuation Ratios -P/E, P/FCFF, P/BV, EV/EBITDA, EV/EBIT, Per Share Data EPS, BPS, DPS, FCFF, FCFE, Margin Ratios Gross, EBITDA, EBIT, PBT & PAT, Return Ratios RoCE, RoE, RoA, DuPont Analysis, Growth Metrics-Revenue Growth, EBITDA Growth, EBIT Growth, Gearing Ratios -Gross Debt/Assets, Gross & Net Gearing, Financial Leverage, Liquidity Ratios Cash, Current & Quick Ratio, Coverage Ratios EBIT / Gross Interest, Cash Interest Cover EBITDA / Interest Paid, Average Gross Debt / EBITDA, EBITDA / Net Interest, .