Overview

3 Statement Financial Model Analysis with an Interactive Dashboard:

This excel model allows you to calculate Return on Common Equity (ROCE), Return on Net Operation Assets (RNOA), Financial Leverage (FLEV), Net Borrowing Costs (NBC), etc easily using different methods based on the information that you have. You need just to enter the values and everything will be shown clearly and using graphs.

1. Return on Common Equity (ROCE) is a measure of the profitability of shareholders’ equity. It depends on a number of drivers including (1) Return on net operating assets (RNOA), (2) Extent of financial leverage (FLEV) and (3) Spread between RNOA and net borrowing costs
(NBC).
2. RNOA is a ratio of net operating income (OI) at (t) relative to net operating assets at (t-1) and represents the profitability of net operating assets. Note that either an increase (OI) or a decreasing NOA or both will increase RNOA. The definition that NOA=(OA-OL) implies that management’s capacity to depend on low-cost operating liabilities (OL) may increase RNOA by decreasing the level of NOA.
3. FLEV is called the financial leverage measuring net financial obligations relative to common equity. Provided that net borrowing cost (NBC) is expected to be less than RNOA, a higher FLEV will imply a greater ROCE. There may be times when spread turns negative and thus the impact of leverage will be adverse.
4. The term FLEV×(RNOA-NBC) is multiplicative and implies that if (RNOA-NBC)>0, greater leverage will mean greater ROCE.

Reviews Add a review
No reviews yet

More From MD. FAZLA RABBE SARDER, FMVA®, MAT (DU)

Browse our top rated business templates. See All
Financial Statement Model Analysis with an Interactive Dashboard
3,749
1
 3 Statement Financial Model Analysis with an Interactive Dashboard: This excel model allows you to calculate Return on Common Equity…
Income Tax Return Filling with Excel IT-11GA (Bangladesh)
4,432
166
Income Tax Return Filling with Excel IT-11GA  (Bangladesh)The income taxpayer is required to present the details of income, expenditure, and…
3 Statement Model for Bank
5,347
4
A 3 statement model template connects the income statement, balance sheet, and cash flow statement into one dynamically linked financial model.
3 Statement for Bank and Financial Institution with Analysis
5,497
6
A 3 statement model template connects the Income statement, Balance sheet (Financial Position), and Cash flow statement into one dynamically…
Key Ratio Analysis with Financial Statement
5,974
165
Corporate finance ratios are quantitative measures that are used to assess businesses. These ratios are used by financial analysts, equity…
Installment Calculator (Annuity)
4,749
178
An annuity is a series of payments made at equal intervals. Examples of annuities are regular deposits to a savings account, monthly home mortgage payments, monthly insurance payments, and…
See All