# Forecasting with the Percentage of Sales Method calculation

Part A: Forecasting with the Percentage of Sales Method calculation:

Utilizing the fictitious company Tag-It Corporation, prepare next year’s forecast in a pro forma income statement. Tag-It’s CEO requested a report of a forecast with an increase in total revenue of 20% for next year. Prepare a forecast for next year utilizing the percentage of sales method, and complete the column in the forecast section on the Excel spreadsheet below. Here is the current income statement for Tag-It:

Part B: Analyze the growth rate in sales and the CEO’s prediction

1. The total revenue numbers over the past 5 years for Tag-It      Corporation were as follows (values in millions):
• 2018     72,710
• 2019     75,360
• 2020     78,112
• 2021     93,561
2. Determine whether you think Tag-It can hit the target of a 20%      increase in sales next year.

Part C: Develop the CEO’s report with your findings.

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 20% increase in sales in a separate word document.

Use the following template to complete the Unit 2 Individual Project (IP): Unit 2 Template

The use of 1 scholarly source (e.g., textbook, article from the CEC Library) is required.

Be sure to show your analysis in a table in a word document. Answer the questions above as part of your analysis. The assignment is 5 pages minimum. The analysis can be one page of the analysis.

## Forecast

 FINA310 IP TEMPLATE FOR STUDENTS (revised 2023) Student name: Date: ACTUAL FORECAST 2022 Next Year Total Revenue \$ 106,005 Cost of Revenue \$ (74,963) Gross Profit \$ 31,042 Operating Expenses \$ (22,096) Operating Income \$ 8,946 Net Interest Income \$ (39) Pre-Tax Income \$ 8,907 Provision for Income Tax (22%) \$ (1,961) Net Income \$ 6,946

## Year over Year

 ANALYSIS OF GROWTH RATES YEAR Total Revenue Growth Year over Year 2018 72,710 3.64% 2019 75,360 3.65% 2020 78,112 19.78% 2021 93,561 13.30% 2022 106,005