Overview

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.

 

  • 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).
  • 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.
  • 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.
  • 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

Browse our top rated business templates. See All
3 Statement Model for Bank
1,399
1
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
1,693
2
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
1,879
164
Corporate finance ratios are quantitative measures that are used to assess businesses. These ratios are used by financial analysts, equity…
Installment Calculator (Annuity)
1,205
56
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…
Amortization Schedule (Automatic)
1,341
111
An amortization calculator is used to determine the periodic payment amount due on a loan (typically a mortgage), based on the amortization process. The amortization repayment…
NPV and IRR Calculator (Automatic)
1,400
125
After the cash flow for each period is calculated, the present value (PV) of each one is achieved by discounting its future value (see Formula)…
See All