Utilizing the fictitious company Tag-It Corporation, prepare next year's forecast with a pro forma income statement....

  

Transcribed Image Text:

Utilizing the fictitious company Tag-It Corporation, prepare next year's forecast with a pro forma income statement. Here is the current income statement for Tag-It: Download the income statement. Additionally, 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 on the Excel spreadsheet. 1. The total revenue numbers over the past 4 years for Tag-It Corporation were as follows (values in millions): • 73,785 • 69,495 • 71,879 • 75,356 2. Determine whether you think Tag-It can hit the target of a 15% increase in sales next year. Prepare a 5 page report that includes a pro forma forecast using the template provided and an analysis of Tag-It's ability to hit the 15% increase in sales in a separate word document. The use of 1 scholarly source (e.g., textbook, article from the CEC Library) is required. Be 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 breakeven analysis can be one page of the analysis. Submitting your assignment in APA format means, at a minimum, you will need the following: • Title page: Remember the running head. The title should be in all capitals. • Length: 5 pages • Abstract: This is a summary of your paper, not an introduction. Begin writing in third person. • Body: This begins on the page following the title page and abstract page and must be double-spaced (be careful not to triple- or quadruple-space between paragraphs). The typeface should be 12-pt. Times Roman or 12-pt. Courier in regular black type. Do not use color, bold type, or italics, except as required for APA-level headings and references. The deliverable length of the body of your paper for this assignment is 5 pages. In-body academic citations to support your decisions and analysis are required. A variety of academic sources is encouraged. • Reference page: References that align with your in-body academic sources are listed on the final page of your paper. The references must be in APA format using appropriate spacing, hanging indent, italics, and uppercase and lowercase usage as appropriate for the type of resource used. Remember, the Reference page is not a bibliography but a further listing of the abbreviated in-body citations used in the paper. Every referenced item must have a corresponding in-body citation. 2018 2019 Total Revenue S 71,879 S 82,661 Cost of Revenue S (51,125) S (58,794) Gross Profit S 20,754 $ 23,867 Operating Expenses: Selling, General, and Administrative S (14,248) S (16,385) Research and Development Special Income/Other Charges S (2,194) S (2,523) Total Operating Expenses S (16,442) $ (18,908) Operating Income 4,312 4,959 Net Interest Income (666) (766) edite Pre-Tax Income 3,646 4,193 Provision for Income Tax (19.5%) (711) (818) Net Income 2,935 3,375 %24 %24 Utilizing the fictitious company Tag-It Corporation, prepare next year's forecast with a pro forma income statement. Here is the current income statement for Tag-It: Download the income statement. Additionally, 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 on the Excel spreadsheet. 1. The total revenue numbers over the past 4 years for Tag-It Corporation were as follows (values in millions): • 73,785 • 69,495 • 71,879 • 75,356 2. Determine whether you think Tag-It can hit the target of a 15% increase in sales next year. Prepare a 5 page report that includes a pro forma forecast using the template provided and an analysis of Tag-It's ability to hit the 15% increase in sales in a separate word document. The use of 1 scholarly source (e.g., textbook, article from the CEC Library) is required. Be 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 breakeven analysis can be one page of the analysis. Submitting your assignment in APA format means, at a minimum, you will need the following: • Title page: Remember the running head. The title should be in all capitals. • Length: 5 pages • Abstract: This is a summary of your paper, not an introduction. Begin writing in third person. • Body: This begins on the page following the title page and abstract page and must be double-spaced (be careful not to triple- or quadruple-space between paragraphs). The typeface should be 12-pt. Times Roman or 12-pt. Courier in regular black type. Do not use color, bold type, or italics, except as required for APA-level headings and references. The deliverable length of the body of your paper for this assignment is 5 pages. In-body academic citations to support your decisions and analysis are required. A variety of academic sources is encouraged. • Reference page: References that align with your in-body academic sources are listed on the final page of your paper. The references must be in APA format using appropriate spacing, hanging indent, italics, and uppercase and lowercase usage as appropriate for the type of resource used. Remember, the Reference page is not a bibliography but a further listing of the abbreviated in-body citations used in the paper. Every referenced item must have a corresponding in-body citation. 2018 2019 Total Revenue S 71,879 S 82,661 Cost of Revenue S (51,125) S (58,794) Gross Profit S 20,754 $ 23,867 Operating Expenses: Selling, General, and Administrative S (14,248) S (16,385) Research and Development Special Income/Other Charges S (2,194) S (2,523) Total Operating Expenses S (16,442) $ (18,908) Operating Income 4,312 4,959 Net Interest Income (666) (766) edite Pre-Tax Income 3,646 4,193 Provision for Income Tax (19.5%) (711) (818) Net Income 2,935 3,375 %24 %24 Utilizing the fictitious company Tag-It Corporation, prepare next year's forecast with a pro forma income statement. Here is the current income statement for Tag-It: Download the income statement. Additionally, 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 on the Excel spreadsheet. 1. The total revenue numbers over the past 4 years for Tag-It Corporation were as follows (values in millions): • 73,785 • 69,495 • 71,879 • 75,356 2. Determine whether you think Tag-It can hit the target of a 15% increase in sales next year. Prepare a 5 page report that includes a pro forma forecast using the template provided and an analysis of Tag-It's ability to hit the 15% increase in sales in a separate word document. The use of 1 scholarly source (e.g., textbook, article from the CEC Library) is required. Be 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 breakeven analysis can be one page of the analysis. Submitting your assignment in APA format means, at a minimum, you will need the following: • Title page: Remember the running head. The title should be in all capitals. • Length: 5 pages • Abstract: This is a summary of your paper, not an introduction. Begin writing in third person. • Body: This begins on the page following the title page and abstract page and must be double-spaced (be careful not to triple- or quadruple-space between paragraphs). The typeface should be 12-pt. Times Roman or 12-pt. Courier in regular black type. Do not use color, bold type, or italics, except as required for APA-level headings and references. The deliverable length of the body of your paper for this assignment is 5 pages. In-body academic citations to support your decisions and analysis are required. A variety of academic sources is encouraged. • Reference page: References that align with your in-body academic sources are listed on the final page of your paper. The references must be in APA format using appropriate spacing, hanging indent, italics, and uppercase and lowercase usage as appropriate for the type of resource used. Remember, the Reference page is not a bibliography but a further listing of the abbreviated in-body citations used in the paper. Every referenced item must have a corresponding in-body citation. 2018 2019 Total Revenue S 71,879 S 82,661 Cost of Revenue S (51,125) S (58,794) Gross Profit S 20,754 $ 23,867 Operating Expenses: Selling, General, and Administrative S (14,248) S (16,385) Research and Development Special Income/Other Charges S (2,194) S (2,523) Total Operating Expenses S (16,442) $ (18,908) Operating Income 4,312 4,959 Net Interest Income (666) (766) edite Pre-Tax Income 3,646 4,193 Provision for Income Tax (19.5%) (711) (818) Net Income 2,935 3,375 %24 %24 Utilizing the fictitious company Tag-It Corporation, prepare next year's forecast with a pro forma income statement. Here is the current income statement for Tag-It: Download the income statement. Additionally, 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 on the Excel spreadsheet. 1. The total revenue numbers over the past 4 years for Tag-It Corporation were as follows (values in millions): • 73,785 • 69,495 • 71,879 • 75,356 2. Determine whether you think Tag-It can hit the target of a 15% increase in sales next year. Prepare a 5 page report that includes a pro forma forecast using the template provided and an analysis of Tag-It's ability to hit the 15% increase in sales in a separate word document. The use of 1 scholarly source (e.g., textbook, article from the CEC Library) is required. Be 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 breakeven analysis can be one page of the analysis. Submitting your assignment in APA format means, at a minimum, you will need the following: • Title page: Remember the running head. The title should be in all capitals. • Length: 5 pages • Abstract: This is a summary of your paper, not an introduction. Begin writing in third person. • Body: This begins on the page following the title page and abstract page and must be double-spaced (be careful not to triple- or quadruple-space between paragraphs). The typeface should be 12-pt. Times Roman or 12-pt. Courier in regular black type. Do not use color, bold type, or italics, except as required for APA-level headings and references. The deliverable length of the body of your paper for this assignment is 5 pages. In-body academic citations to support your decisions and analysis are required. A variety of academic sources is encouraged. • Reference page: References that align with your in-body academic sources are listed on the final page of your paper. The references must be in APA format using appropriate spacing, hanging indent, italics, and uppercase and lowercase usage as appropriate for the type of resource used. Remember, the Reference page is not a bibliography but a further listing of the abbreviated in-body citations used in the paper. Every referenced item must have a corresponding in-body citation. 2018 2019 Total Revenue S 71,879 S 82,661 Cost of Revenue S (51,125) S (58,794) Gross Profit S 20,754 $ 23,867 Operating Expenses: Selling, General, and Administrative S (14,248) S (16,385) Research and Development Special Income/Other Charges S (2,194) S (2,523) Total Operating Expenses S (16,442) $ (18,908) Operating Income 4,312 4,959 Net Interest Income (666) (766) edite Pre-Tax Income 3,646 4,193 Provision for Income Tax (19.5%) (711) (818) Net Income 2,935 3,375 %24 %24