Income Tax Schedule - Excel Model Template

Description
This model enables you to generate an income tax schedule tailored to your company's tax stream.

The Wall Street Oasis dictionary states that a tax schedule is a form necessary to any company in order to prepare for their tax return, which declares their types of income or deductions.

The model works as a 'plug-and-play' template. You only need to insert your own numbers and formulas in order to create output numbers.

More specifically, you will be able to calculate:
- the total Income before tax,
- the total provision for Income tax,
- the effective tax provision rate,
- the foreign tax weighted total.

Moreover, this template helps you compare your income throughout the years by showing your historical data and its growth stage.

The model consists of several tabs including many different financial models such as:

- Forecast Drivers;
- A Balance Sheet;
- An Income Statement;
- A Statement of Cash Flows;
- A Free Cash Flow (FCF) Statement;
- An Adjusted Present Value Valuation;
- A Sensitivity Analysis template;
- A Reasonability Check;
- A Retained Earnings Schedule;
- A Revenue Schedule;
- A Revenue Sensitivity Table.

If you have any comments and/or questions, please do not hesitate to start a discussion below or reach out to the Author via private message on their Eloquens channel.

For more tools, feel free to visit our page on Eloquens!