Homework: Finance Report
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.
I. The total revenue numbers over the past 4 years for Tag-It Corporation were as follows (values in millions):
i. 73,785
ii. 69,495
iii. 71,879
iv. 75,356
II. 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.
Format your homework according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- Income-Statement.rar