Font A) Complete following missing data (XI-X10) in the table below (Show your Steps) % Market Share PI Revenue (1st year) 90.6 P2 20% 30.000.000 P4 30% X2 50,000 75,000 50.00% 40.00% 9,000,000 45.00% Market Size X1 # Product %Revenue for Product survey Average sales price per unit Number of Unit Sold Annually Revenue per product gross margin per product Total cost of goods year 1 % Annual Maintenance Annual tax rate Long term debit Years Annual R Increase Annual E Increase 225,000 10,500,000 60.00% X3 8% 5% 4 5.00 2.00% 2.00% X4 4.00% 25.00% 6.00% 5.00% LALU leche Copy Share Pustite CcDE CcDE CDdEe Code dte cedite 1 Normal To Spacesting Heading Te e Clipboard font w agen Annual E Increase Gross Revenue 30,000,000 Manufacturing Cost Sales and marketing 4,000,000 Salaries Depreciation 5,000,000 Insurance 400,000 Maintenance 2,000,000 Utilities 300,000 Administrative fees 180,000 Space Rental 2,000,000 Interest expense 897,400 Taxes on income 0 Net income (loss) -377,400 % Profit Margin -1.24% ROI -1.51% 2.00% 30,600,000 15,300,000 4,080,000 612,000 5,000,000 408,000 2,040,000 306,000 183,600 2,040,000 716,425 A 4.00% 36,720,000 18,360,000 4,243,200 636 480 5,000,000 424,320 2,080,000 318,240 190,944 2,121,600 526,401 140,941 2,677,874 7.87% 10.71% 6.00% 45,900,000 22,950,000 4,497,792 674,669 5,000,000 449,779 2,120,000 337,334 202,401 2,248,896 326,877 X5 6,737,640 17.20% 26.95% 5.00% 48,195,000 24,097,500 4,722,682 708,402 5,000,000 472,268 2,100,000 354,201 212,521 2,361,341 X6 402,435 -86,025 -0.28% -0.34% Years 18.86% 30.59% 1.000.000 X7 Cash and short-term investments Machinery and equipment Total assets Total lichilitinn X8 Page 1 of 2 200 word English United States Laren 11-A . * Home Insert Design Times New R Format Painter BTW Clipboard 70 Front margin ROI Reference A A- Marings E A-3 bo - Word Review View Oleme what you want to UAFL Teacher 9 1 CcDde CcDde cDdee CcDdEedte Ccode. 3 S- T al The South Paste & Share -1.24% -1.51% - -U.com 1 17.87% 10.71% -0.34% 402 Years Editing 17.20% 26.95% 10.00% 30.59% 1.000.000 X7 X8 Cash and short-term investments Machinery and equipment Total assets Total liabilities Owner's equity (common stocks) Paid-in capital Years Long-term debt/financing Ending cash balance X9 2 3,800,471 3.619,496 X10 1.000.000 5,000,000 4 5 4.190,019 4.399,520 3 3.990,494 B) Calculate Simple Payback period Home Tones - -KAARE CD. CD Code Code Idte Code Pa For project with period of 10 years, the compounded payback period = 10. Is this project accepted using AW method or not. Why? (Prove without doing any calculation)