Finance Report Homework
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 homework is 5 pages minimum. The breakeven analysis can be one page of the analysis.
Submitting your homework in APA format means, at a minimum, you will need the following:
1) Title page: Remember the running head. The title should be in all capitals.
2) Length: 5 pages
3) Abstract: This is a summary of your paper, not an introduction. Begin writing in third person.
4) 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 homework is 5 pages. In-body academic citations to support your decisions and analysis are required. A variety of academic sources is encouraged.
Format your homework according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the homework, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.