HSSIQIIIIICIII. ucsunpuun Jtiiizing the ctitious company Tag-ti Corporation, prepare next year's forecast with a proforma income statement. Here is the current income statement for Tag-it: Download the income statement. \dditionaliy, Tag-it's CEO has predicted a 15% increase in total revenue next year. Utilizing the percentage of sales method, prepare a forecast for next year in the correct section in the Excel spreadsheet. 1. The total revenue numbers over the past 4 years for Tag-It Corporation were as follows (values in millions): a 73,785 a 69,495 a 71,879 a 75,356 2. Determine whether you think Tag-it can hit the target of a 15% increase in sales next year. jrepare a 5 page report that includes a pro forma forecast using the template provided and an analysis of Tagit's ability to hit the 15% increase in sales in a separate word tocument. Fhe use of 1 scholarly source (e.g., textbook, article from the CEC Library) is required. 3e sure to show your breakeven analysis in a table in a word document. Answer the questions above as part of your analysis. The assignment is 5 pages minimum. The )reakeven analysis can be one page of the analysis. Submitting your assignment in APA format means, at a minimum, you will need the following