Please assist in the filling out the above and below table. I have provided all information that has been provided to me.

Company	Shares Outstanding	Latest Share Price	MVE	Total Debt	Wd	We
a	b	c = a * b	d	d/(c+d)	c/(c+d)
VR Comp 1
VR Comp 2
VR Comp 3
VR Comp 4
VR Comp 5
VR Comp 6
Average
Median

Transcribed Image Text:

XYZ Tech Income Statement Income Statement Item 2017 2018 2019 2020F 2021F 2022F Net revenue 4,319.0 5,253.0 6,475.0 7,446.3 8,190.9 8,764.2 Cost of sales (3,316.0) (3,466.0) (4,028.0) Gross margin 1,003.0 1,787.0 2,447.0 Research and development (1,008.0) (1,196.0) (1,434.0) Marketing, general and administrative (466.0) (516.0) (562.0) Operating income (loss) (471.0) 75.0 451.0 880.0 890.0 1,156.0 Interest expense (156.0) (126.0) (135.0) Other income (expense), net 80.0 9.0 0.0 Income (loss) before income taxes and equity loss (547.0) (42.0) 316.0 Provision for income taxes (20.0) (25.0) (130.0) Net income (loss) (567.0) (67.0) 186.0 XYZ Tech Statement of Cash Flows (select items) Cash Flow Statement Items 2017 2018 2019 2020F 2021F 2022F Depreciation and amortization 99.0 124.0 170.0 Purchases of property and equipment (CAPEX) (97.0) (133.0) (189.0) XYZ Tech Income Statement Income Statement Item 2017 2018 2019 2020F 2021F 2022F Net revenue 4,319.0 5,253.0 6,475.0 7,446.3 8,190.9 8,764.2 Cost of sales (3,316.0) (3,466.0) (4,028.0) Gross margin 1,003.0 1,787.0 2,447.0 Research and development (1,008.0) (1,196.0) (1,434.0) Marketing, general and administrative (466.0) (516.0) (562.0) Operating income (loss) (471.0) 75.0 451.0 880.0 890.0 1,156.0 Interest expense (156.0) (126.0) (135.0) Other income (expense), net 80.0 9.0 0.0 Income (loss) before income taxes and equity loss (547.0) (42.0) 316.0 Provision for income taxes (20.0) (25.0) (130.0) Net income (loss) (567.0) (67.0) 186.0 XYZ Tech Statement of Cash Flows (select items) Cash Flow Statement Items 2017 2018 2019 2020F 2021F 2022F Depreciation and amortization 99.0 124.0 170.0 Purchases of property and equipment (CAPEX) (97.0) (133.0) (189.0)