
|
Financial Model, General Excel Financial Models |
Excel, Free Financial Model Templates, NPV (Net Present Value), Tax Assets, Valuation |
This valuation model provides a framework for the valuation of tax loss carryforwards and tax carrybacks via Net Present Value (NPV) calculation.
The financial model determines how long your historic tax losses can be carried forward to be offset against the taxable income. Optionally it also allows.
The assumptions used are:
- Discount rate
- Tax rate
- Time period tax loss carryforwards are allowed
- If you wish to consider also tax carrybacks (yes/no)
- Time period tax carrybacks can be offset
The model provides a detailed calculation which tax loss carryforward and carrybacks can be used at which point in time and what the value of the tax assets are.
Screenshots
Schedule for the use of tax loss carryforwards
Schedule for the use of tax carrybacks
Taxable income and deductions of tax loss carryforwards and tax carrybacks
Calculation of tax savings and NPV valuation
Executive Summary with Financial Overview