Analyses and reports in Excel with the description of their formatting

Constructing of financial analyses for evaluation of business activity and investment projects. Forming reports and documents forms in Excel for accounts department, marketing department, warehouse facilities, and other structures of the company.

Forming of reports analyses with examples

calculation-effective-interest-rateCalculation of the effective interest rate on loan in Excel.
Calculation of the effective interest rate on the loan, leasing and government bonds is performed using the functions EFFECT, IRR, XIRR, FV, etc. Let's look at examples of how real interest is considered.
calculation-kpi-in-excelThere is calculation of KPI in the Excel: examples and formulas.
KPI key performance indicators assess the result of the work performed. On the basis of the indices are often constructed compensation system. Formulas example of a table and KPI matrix.
time-series-analysisTime series analysis and forecasting in Excel with examples.
Time series: analysis and forecasting of values. Tool Analysis package offers the user methods of statistical processing of time series elements. Examples of analysis and forecasting of time series.
management-accountingManagement accounting in Excel with examples.
Tables of management accounting on the example of a restaurant-cafe. Examples of filling out reports on income, expenses, profits and losses. Analysis of the property of the enterprise. How to automate the work?
financial-analysis-exampleFinancial analysis in Excel with an example.
The financial and statistical analysis in Excel: automation of calculations. How to analyze the time series and forecast sales, taking into account the trend component and seasonality?
abc-xyz-analysis-in-excelABC and XYZ analysis in Excel with example of calculation.
ABC analysis and possible technique, the conditions for use. Example analysis of the product portfolio of the table processor means. XYZ-analysis method.
calculating-irr-functionsHow to calculate IRR by formula in Excel for Chart.
The analysis of the investment project requires the calculation of the internal rate of return IRR. Formula and example on the graph, built-in functions. Graphical method of calculating the indicator.
calculation-credit-in-excelCalculation of credit in Excel and the formula of monthly payments.
How to calculate loan payments: the formula for the annuity and differentiated method, interest and balance, overpayment and the full value of the loan. EIR new formula.
bcg-matrix-exampleBCG Matrix: construction and analysis in Excel with example.
The BCG matrix is an excellent tool for portfolio analysis. Consider the example in Excel, the construction of the matrix, the identification with its help of promising and unpromising goods.
regression-correlation-analysisHow to do a Regression and Correlation analysis in Excel.
Meaning methods of correlation and regression analysis for statistics. How to find the coefficients using Excel tools in two clicks. Construction of the correlation field.
1 2 3 4 5 6 7

en ru