FINA 310 AIUNIV Tag Its Corp Revenue Forecast Excel Spreadsheet Tag-It’s CEO has predicted a 10% increase in total revenue next year. Utilizing the percent

FINA 310 AIUNIV Tag Its Corp Revenue Forecast Excel Spreadsheet Tag-It’s CEO has predicted a 10% increase in total revenue next year. Utilizing the percentage of sales method, prepare a forecast for next year in the section provided on the Excel spreadsheet provided. The total revenue numbers over the past 4 years for Tag-It Corporation were as follows: Values in Millions: 72,618 73,785 69,495 71,879 Determine whether you think Tag-It can hit the target of a 10% increase in sales next year. FINA310 UNIT 3 IP TEMPLATE FOR STUDENTS
Student name: Sonia Diaz
Date:
5/28/2020
ACTUAL
2018
Total Revenue
$
71,879
$
(51,125)
$
20,754
Selling, General, and Administrative
$
(14,248)
Research and Development
$
–
Special Income/Other Charges
$
(2,194)
Total Operating Expenses
$
(16,442)
Operating Income
$
4,312
Net Interest Income
$
Cost of Revenue
Gross Profit
Operating Expenses:
(666)
edite
Pre-Tax Income
$
Provision for Income Tax (19.5%)
$
Net Income
$
3,646
(711)
2,935
FORECAST
2019
Assignment Details
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:
Click here to download the income statement.
Tag-It’s CEO has predicted a 10% increase in total revenue next year. Utilizing the percentage of sales method,
prepare a forecast for next year in the section provided on the Excel spreadsheet provided.
1.
2.
The total revenue numbers over the past 4 years for Tag-It Corporation were as follows:
Values in Millions:
o 72,618
o 73,785
o 69,495
o 71,879
Determine whether you think Tag-It can hit the target of a 10% increase in sales next year.
Submit the Excel spreadsheet provided, saved with your name, which must include the answers to the 2
questions: 1. An updated forecast for next year, and 2. the answer to question regarding the target sales.
The use of 1 scholarly sources (e.g., textbook, article from the CEC Library) is required.
If you are planning to repurpose an assignment or submit one you have used before, please let your instructor
know. If an instructor is not made aware of work being repurposed or reused, he or she will treat the assignment
as a plagiarized task and reserves the right to post an F grade and submit a task for review to administration until
proof of originality is provided. Click here for more information.

Purchase answer to see full
attachment