Residual Income Model is an equity valuation method used to estimate the true or intrinsic value of a stock based on the present value of all future residual income the company generates.
A company has two sources of capital, equity, and debt. The cost of debt, represented by interest expense, is deducted from operating income to calculate net income. However, the cost of equity represented by dividends and other equity distributions are not accounted for (Dividends on common stock are not reported in the Income Statement as these are not considered as expenses). Because of this, a company’s net income does not necessarily reflect its economic profit. A company may be earning profits but after paying dividends, the company is economically unprofitable after all.
To reflect the effect of the cost of equity, it must be considered as a “charge” against the company’s net income. The “equity charge” is the company’s total equity capital multiplied by the cost of equity. The mathematical formula for the equity charge is:
Equity Charge = Equity Capital x Cost of Equity
To calculate for the residual income, simply deduct the equity charge from net income. The term “residual” represents the excess income after accounting for the company’s true cost of capital. The residual income formula is:
Residual Income (RI) = Net Income – Equity Charge
The Residual Income Model Formula has three (3) components:
- Residual Income
- Book Value of the company’s equity. Also known as Shareholder’s equity.
- Cost of equity (%) or required rate of return for equity investors. Capital Asset Pricing Model (CAPM) is often used to determine the rate.
The intrinsic value of the stock is determined by adding the company’s current book value of equity capital and the present value of the company’s future residual income discounted at the cost of equity. The Residual Income Model Formula is:

Where:

If the value calculated is higher than the current trading price, the stock is undervalued and may qualify as a signal to buy. On the other hand, if it is lower the stock is overvalued and may not be a sound investment.
The residual income model is appropriate for companies in the following scenarios:
- A company is not paying dividends or exhibits an unpredictable dividend pattern (no established dividend policy). This model is a good alternative to the Dividend Discount Model (DDM). You can read more about the DDM here: What is a Dividend Discount Model as well as download for free the DDM Excel Calculator here: Multi-Stage Dividend Discount Model and Gordon Growth Model Calculator.
- A company generates negative free cash flow for a certain number of years but is expected to generate positive cash flow at some point in the future.
Here is a list of industry-specific financial model templates that you can use as a base or reference as you create your own financial model that calculates the residual income:
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophisticated financial forecast for a utility-scale solar p... read more
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when launching a new business centered around an app insta... read more
The Private Equity Fund Cashflows Model helps LPs and GPs analyze fund cash flows, returns, and distributions across investor, manager, and portfolio ... read more
The Pharma Biotech Valuation Model Template calculates the risk-adjusted DCF Value of a Pharma or Biotech Startup Company with several products under ... read more
The SaaS Business financial model offers valuable assistance in preparing a budget and multi-year financial plan for a Software as a Service (SaaS) bu... read more
The Coffee Shop Financial Model helps entrepreneurs, founders, business owners, consultants, and analysts turn a cafe concept into a structured financ... read more
This Discounted Cash Flow (DCF) valuation calculator template projects a three-statement model that allows users to value a company based on the net p... read more
The Hotel Investment Financial Model provides a framework to forecast the expected cash flows for a hotel investment and calculates the relevant inves... read more
The Hotel Financial Model helps users build a structured financial forecast for a hotel business using the revenue drivers that matter most in hospita... read more
The Upstream Oil & Gas Project Financial Model Template in Excel empowers you to project and dissect your impending Oil and Gas drilling ventures. Pre... read more
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the most valuable logic in the world. I have been thr... read more
This Project Plan Template in Google Sheet allows you to quickly develop a project plan and plot a Gantt chart. Enjoy all the benefits of Google Docs ... read more
A commercial real estate valuation model template assists in running a professional DCF Valuation for a commercial property such as an office building... read more
We are introducing our 4-Tier Waterfall Profit Distribution Model. The waterfall profit distribution model template aims to support a thorough analysi... read more
The Wind Farm Financial Model provides a powerful 40-year forecast, capturing critical data on energy production, revenues, operating costs, and debt ... read more
This is a financial model template for a new private school startup business. The Excel model allows forecasting the cash flows over the next 10 years... read more
Feeling overwhelmed by the daunting task of financial forecasting? This FREE Download 5-Year Three Statement Financial Model Excel Template offers you... read more
Dynamic 10-Year Financial Model, suitable for any type of business, supporting strategic planning, investment decisions, and business valuation.
This green hydrogen financial model template builds a multi-year financial plan to analyze the financial feasibility and profitability for the product... read more
Investors can assess the viability of setting up and investing in gasoline stations with a charging station by downloading a financial model for their... read more
The Grocery Store Financial Model helps entrepreneurs, founders, consultants, analysts, and retail business owners build a structured financial foreca... read more
The Manufacturing Financial Model provides a framework to accurately forecast the financial statements of a manufacturing company over the next 10 yea... read more
Key logic designed to forecast cash flow up to 10 years for a fitness center that has recurring monthly fees. Fully integrated 3-statement model, cap ... read more
The Model Incorporates data provided by different available sources to Model an Electrolysis financial model. It includes Electrolyzer cost, Dispenser... read more
The Outpatient Clinic Financial Model helps users turn a clinic business concept into a structured, editable financial forecast. Instead of relying on... read more
Air BnB Financial Model Template presents the business case of the purchase of up to 5 properties with the intent of utilizing them as short term rent... read more
The beverage manufacturing industry is a dynamic and rapidly growing sector that caters to a diverse market ranging from soft drinks and juices to alc... read more
Includes all the assumptions you need to project the gross revenues and profits of a LaaS platform (Lending as a Service). 3-statement model and cap t... read more
This is a simple capitalization (cap) table template which allows entrepreneurs to understand the dilution effect of capital raisings and a simple sto... read more
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year advanced financial forecast.
The Gold Mine Investment Model is used to determine the financial feasibility of a proposed Gold Mine Investment. The Financial Model outputs IRR and ... read more
Airport Operator Financial Model presents the business case of an already operating airport (with planned refurbishments) and an investment in a new t... read more
The Bakery Financial Model helps entrepreneurs, bakery owners, consultants, analysts, and business plan writers turn a bakery concept into a structure... read more
Model for in depth understanding of high level profit and loss and revenue analysis. Big-4 like checklist of due diligence analyses. This Financial Du... read more
The Cafe Financial Model is a ready-to-use financial model template designed to help entrepreneurs, cafe owners, founders, consultants, and analysts b... read more
The Clothing Store Financial Model helps turn a retail apparel concept into a structured financial forecast that can be used for planning, funding, bu... read more
The Poultry Farming Financial Model helps users turn a poultry farm concept into a structured, lender-ready financial forecast. It is designed for pla... read more
This detailed, yet easy to use three statement financial model will allow you to calculate your business' profit and loss, build a balance sheet and c... read more
A general real estate model to plan all assumptions for up to 7 'uses' for a given property. Includes development / acquisition, leverage if desired, ... read more
The rental property financial model calculates the homeowner's IRR and long it takes to repay a mortgage when the property is rented. The financia... read more
The IRR Project Finance Analysis forecasts the expected financials for a greenfield project and calculates the levered and unlevered Internal Rate of ... read more
Plan out the financial plan your hair or beauty salon. The beauty & hair salon business plan goes up to 10 years and has plenty of granularity.
The Online Clothing Store Financial Model helps founders, entrepreneurs, business owners, consultants, and analysts turn an apparel e-commerce idea in... read more
Authorities and Responsibilities Matrices are considered important to organizations due to their role in identifying and documenting decisions that ar... read more
The Biogas Financial Model forecasts the expected financials for a Biogas plant project and calculates the IRR and NPV values for the project.
The template allows the user to calculate the net present value (NPV), internal rate of return (IRR) and payback period from simple cash flow stream w... read more
The Dental Clinic Financial Model helps users turn a dental practice concept, launch plan, or expansion strategy into a structured five-year financial... read more
This poultry financial model template in Excel provides a framework to determine the financial feasibility of a new poultry project for producing bro... read more
The purpose of this financial model is to evaluate the financial feasibility of a waste to energy project such as e.g. a landfill gas plant. The model... read more
Start Up Solar Farm Excel Model presents the business case of an investment in the construction of a solar farm and the sale of the energy generated f... read more