Income Tax Schedule - Excel Model Template
Originally published: 25/06/2019 13:46
Last version published: 04/02/2020 14:58
Publication number: ELQ-28281-2
View all versions & Certificate

Income Tax Schedule - Excel Model Template

This is an Excel template of an Income Tax Schedule.

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!

This Best Practice includes
1 Excel table

Wall Street Oasis offers you this Best Practice for free!

download for free

Add to bookmarks


5.0 / 5 (2 votes)

please wait...