EVA/ROE analysis sheet

EVA/ROE analysis sheet

Based on the specified B/S template, B/S budget, P/L template, P/L budget, and so on, the EVA/ROE analysis sheet is generated and outputted.
The outputs by "Company Unit" without specifying items, or the individual output for each "Department" as well as "Project code 1, 2" or "Accounting analysis code 1, 2" are also available.
"Effective tariff" to be used in calculations must be registered in [Register analysis index for cashflow] in advance.
→ To Operation Procedure

Screen Transition

[Cashflow management module]
  ↓
[Cashflow management]
  ↓
[EVA/ROE analysis sheet]
  ↓
[EVA/ROE analysis sheet] screen

Item Setup

[Required item]

Accounting year
Specify a range of accounting year. It initially indicates "current fiscal year - current fiscal year."
If there are no data for the specified year in [Register analysis index for cashflow], an error message will appear and the output will not be generated.
Output FCF achievements
Mark here to output the actual values in the rows of "Operating profit," "Operating profit after tax," "Interest-bearing debts," "Capital," "Invested capital," "ROE" and "EVA."

Output
Select any one of "Company unit," "Indiv item compare," and "Comparison by item/budget." By default, "Company unit" is selected.
If you select "Indiv item compare," a text box will appear on the lower potion of the screen, then you can enter a range of output items.

Output	Output results
Company unit	Without setting a range of items, the EVA/ROE analysis sheet summarized for the entire company is created.
Indiv item compare	By setting a range of items, the EVA/ROE analysis sheet summarized in the range is created. A group of project codes or departments can be specified as an item.
Comparison by item/budget	Items and budgets are arranged side by side in the output EVA/ROE analysis sheet.

Item
Select from "Department," "Project code 1," "Project code 2," "Accounting analysis code 1," and "Accounting analysis code 2" and specify the range for them.
When "Indiv item compare" has been set in "Output", if you select "Department" or "Project code 1, 2," "Summary Dept" and "Project group" are also available.
B/S template code, P/L template code, Budget code
Select a B/S template and a P/L template from the registered templates in [Financial statements module], and based on the selected templates, select the same budget codes of B/S budget (annual budget) and P/L budget (annual budget) as the ones registered in [Planning control module]. Only the budgets registered with standard currency can be selected.
When "Indiv item compare" or "Comparison by item/budget" has been set in "Output," only the annual budgets registered in the specified item can be selected.
The budget codes of "Term," "Quarter," and "Half-year" are not available.
Macro file, Macro
If you want to apply Microsoft Excel Macros to the output, specify the names of Macrofile and Macro.

[Buttons]

Refer
Start
Clear
Exit

Calculation methods of EVA/ROE Analysis objects

In the discounted cashflow, for each one of the specified year, budget code, and actual of the specified year, budgets and actuals of operating profit, operating profit after tax, interest-bearing debts, capital, invested capital, ROE, EVA, WACC, and effective tariff are outputted. For the rows except EVA, WACC and effective tariff, total values are calculated.
Operating profit, operating profit after tax, interest-bearing debts, capital, invested capital, ROE, EVA, WACC and effective tariff are calculated using the following formulas.

Output item	Formula	Comment
Operating profit	Sales - Cost of sales - Sales and general	Budget: Among the A/Cs registered under the P/L year budget of the specified year, the row of the A/Cs with A/C types of "Sales," "Cost of sales," and "Sales and general" are summarized. In B/S year budget, if A/Cs with A/C types of "Sales," "Cost of sales," or "Sales and general" are specified, these A/Cs will be excluded from the summary objects. Actual: Based on the balance data and journal data of the corresponding year, the Amts entered in A/Cs of "Sales," "Cost of sales" and "Sales and general" types are summarized.
Operating profit after tax	Operating profit × (1-Effective tariff)	This is calculated using the effective tariff value specified in "Operating profit" and [Register analysis index for cashflow] described above. Rounded off at the third decimal place.
Interest-bearing debts	Summary of A/Cs with "Interest-bearing debts" marked	Budget: Among the A/Cs registered under the B/S year budget of the specified year, the rows of the A/Cs with "Interest-bearing debts" marked are summarized. In P/L year budget, if A/Cs with "Interest-bearing debts" marked are specified, these A/Cs will be excluded from the summary objects. Actual: Based on the balance data and journal data of the corresponding year, the Amts entered in A/Cs with "Interest-bearing debts" marked are summarized.
Capital	Summary of A/Cs with A/C type "Capital"	Budget: Among the A/Cs registered under the B/S year budget of the specified year, the rows of the A/Cs with A/C type "Capital" are summarized. In P/L year budget, if A/Cs with A/C type "Capital" are specified, these A/Cs will be excluded from the summary objects. Actual: Based on the balance data and journal data of the corresponding year, the Amts entered in A/Cs with A/C type "Capital" are summarized.
Invested capital	Interest-bearing debts + Capital	"Interest-bearing debts" and "Capital" described above are added.
ROE	Operating profit after tax/Capital	ROE has 1 digit + 6 digits for the fractional portion. It is rounded off at the seventh decimal place. EVA has 13 digits + 2 digits for the fractional portion. It is rounded off at the third decimal place. The formula shown in left column is embedded in the Excel sheet. Modifying the operating profit after tax value will cause interlocking to change this value.
EVA	Operating profit after tax – WACC × Invested capital
WACC	Refer to [Discounted cashflow].
Effective tariff	The value of the corresponding year in [Register analysis index for cashflow] is referred.

Back Top