based on the datas above how to calculate the revenue for the next 5 years.

TABLE 2 SPREADSHEET Idexo's Income Statement and Balance Sheet 2019 2019 120,000 Year 2 Income Statement (5000s) Sales 4 Cost of Goods Sold 5 Raw Materials 6 Direct Labor Costs 7 Gross Profit 8 Sales and Marketing Administration 10 EBITA 11 Depreciation 12 EBIT 13 Interest Expense (net) 14 Pretax Income 15 Income Tax 16 Net Income Year Balance Sheet (5000s) Assets Cash and Cash Equivalents Accounts Receivable Inventories Total Current Assets Property, Plant, and Equipment Goodwill 10 Total Assets 11 Liabilities and Stockholders' Equity 12 Accounts Payable 13 Debt 14 Total Liabilities 15 Stockholders' Equity 16 Total Liabilities and Equity 15,000 20,000 8,219 43,219 60,000 1000 104,219 -21,333 -24,000 74,667 -15,000 -18,000 41,667 6,667 35,000 -1,021 33,979 4,893 29,086 9 6,205 20,000 26,2051 78,014 104,219 TABLE 2 SPREADSHEET Idexo's Sales and Operating Cost Projections 2022 2023 2024 23,820 17.0% 45.48 25,250 18.0% 46.39 26,765 18.0% 47.32 Year 2019 2020 2021 Sales Data Growth/Yr 3 Market Size (000s units) 6.0% 20.000 21,200 22,472 14 Market Share 1.0% 14.0% 15.0% 16.0% Average Sales Price ($/unit) 2.0% 42.86 43.71 44.59 7 Operating Expense and Tax Data 8 Gross Margin 62.2% 53.0% 53.0% 19 Sales and Marketing (% sales) 12.5% 16.5% 18.0% 10 Administration (% sales) 15.0% 15.0% 15.0% 11 Tax Rate 14.4% 35.0% 35.0% Market Share growth is expected through 2017 only. Growth is shown in absolute terms. 53.0% 19.5% 14.0% 35.0% 53.0% 20.0% 13.0% 35.0% 53.0% 20.0% 13.0% 35.0% TABLE 3 SPREADSHEET Idexo's Capital Expenditure Forecast 2019 2020 2021 2022 2023 20241 3 4 5 Year Fixed Assets and Capital Investment (5000s) Opening Book Value Capital Investment Depreciation Closing Book Value 60,167 6.500 -6,667 60,000 60,000 5,000 -6,500 58,500 58,500 5,000 -6,350 57,150 57,150 25,000 -8.215 73,935 73,935 12,000 -8.594 77,341 77,341 8,000 -8,534 76,807 TABLE4 SPREADSHEET Idexo's Debt and Interest Forecast 2019 2020 2021 2022 2023 2024 2 Year Debt and Interest Table (5000s) Outstanding Debt Interest on Term Loan 7.0% 20,000 20.000 -1,400 20.000 -1,400 35,000 -1,400 40,000 -2,450 40,000 -2,800