Hello,

I need help calculating the projected performance for the next three years 2022, 2023 and 2024

Assumptions:

Assuming an increase of 4% in revenue from year to year, in regards to previous years of revenue fluctuations, and COVID still a threat to the companys success and growth

Operating Expenses increase at a percentage of 5%

Note: I made up the assumptions myself, if there are easier numbers to use as percentages for revenue increases and operating expanses then go ahead and use that.

The rows should include revenue, expenses, calculated profit, and calculated profit margin. The columns should represent years: two years of history, plus three years of your reasonable future projections.

Thank you

Period Ending:	1/30/2021	2/1/2020	2/2/2019	2/3/2018
Total Revenue	$10,715,000	$15,524,000	$15,860,000	$15,478,000
Cost of Revenue	$7,600,000	$9,932,000	$10,155,000	$9,890,000
Gross Profit	$3,115,000	$5,592,000	$5,705,000	$5,588,000
Operating Expenses
Research and Development	--	--	--	--
Sales, General and Admin.	$4,162,000	$4,808,000	$4,868,000	$4,662,000
Non-Recurring Items	--	--	--	--
Other Operating Items	--	--	--	--
Operating Income	-$1,047,000	$784,000	$837,000	$926,000
Add'l income/expense items	--	--	--	--
Earnings Before Interest and Tax	-$1,047,000	$784,000	$837,000	$926,000
Interest Expense	$181,000	$102,000	$104,000	$136,000
Earnings Before Tax	-$1,228,000	$682,000	$733,000	$790,000
Income Tax	-$538,000	$186,000	$169,000	$353,000
Minority Interest	--	--	--	--
Equity Earnings/Loss Unconsolidated Subsidiary	--	--	--	--
Net Income-Cont. Operations	-$690,000	$496,000	$564,000	$437,000
Net Income	-$690,000	$496,000	$564,000	$437,000
Net Income Applicable to Common Shareholders	-$690,000	$496,000	$564,000	$437,000