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.

Add to wish list

Free – Purchase Checkout Added to cart

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