Scribd
Upload
79 views1 page

Income Statement Projection Guide

The document is an income statement projection template for a company. It includes sections to input projected revenue, cost of sales, expenses categorized by type, interest and depreciation costs, tax rate, and calculations to determine gross profit margin, earnings before interest, taxes, depreciation and amortization (EBITDA), earnings before tax, and earnings after tax.

Uploaded by

Ashim
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
79 views1 page

Income Statement Projection Guide

The document is an income statement projection template for a company. It includes sections to input projected revenue, cost of sales, expenses categorized by type, interest and depreciation costs, tax rate, and calculations to determine gross profit margin, earnings before interest, taxes, depreciation and amortization (EBITDA), earnings before tax, and earnings after tax.

Uploaded by

Ashim
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Income Statement Projection

[Input Company Name]

Year Ending
[input date]

Insert your projected revenue and cost of sales into the shaded cells below, and your gross margin will be
calculated automatically. The table will also calculate expense ratios expressed as a % of revenue.

Revenue
Cost of Sales
Gross Profit Margin

$0.00
$0.00
$0.00

% of Rev

Input the expenses appropriate for your business into the shaded cells below. You may insert or delete rows as
needed.

Advertising
Accounting
Rental
Telephone
Employee Salaries
Owner's Salary
Insurance
Stationery
Repairs & Maintenance
[other expense]
[other expense]
[other expense]
[other expense]
[other expense]
[other expense]
[other expense]
[other expense]
[other expense]
[other expense]
[other expense]
Total Operating Expenses
Earnings Before Interest, Taxes, Depreciation & Amortization (EBITDA)

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Input interest & depreciation costs into the shaded cells below. Your accountant can help you calculate Asset
Depreciation or Capital Cost Allowance (CCA)

Asset Depreciation or Capital Cost Allowance


Interest on Bank Loans
Other Loans
Total Interest & Depreciation
Total Expenses Including Interest, Depreciation & Amortization

$0.00
$0.00
$0.00
$0.00
$0.00

Input your Provincially-adjusted tax rate into the shaded cell below

Earnings Before Tax


Tax
Earnings After Tax

0.0%

$0.00
$0.00
$0.00

You might also like