Financial Model – Valuation of Tax Loss Carryforwards

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