Question
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
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 than go ahead and use that.
Please show how to do the calculations
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started