Develop the ceos report with your findings

Assignment Help Corporate Finance

Reference no: EM133464043

Assignment: Forecasting With the Percentage of Sales Method Calculation

Length: 5 pages.

Part 1: 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 2: Analyze the growth rate in sales and the CEO's prediction

A. The total revenue numbers over the past 5 years for Tag-It Corporation were as follows (values in millions):

a. 2018 72,710
b. 2019 75,360
c. 2020 78,112
d. 2021 93,561

B. Determine whether you think Tag-It can hit the target of a 20% increase in sales next year.

Part 3: 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.

Reference no: EM133464043

Questions Cloud

What is your process for evaluating if the information : what is your process for evaluating if the information presented is reliable, valid, and factual?

Discuss difference between a terrorist and a freedom fighter : Discuss the difference between a terrorist and a freedom fighter? - What is the most important factor in creating a useful worksheet? Why?

What do you think the news medias responsibility : What role do the following play in contemporary American society and What do you think the news media's responsibility is in providing accurate information

List some alternate strategies you could have used : List some alternate strategies you could have used during project planning and/or during risk mitigation for better results.

Develop the ceos report with your findings : Determine whether you think Tag-It can hit the target of a 20% increase in sales next year. Develop the CEO's report with your findings.

Is mtv truly reflecting the desires of today teenagers : Is MTV truly reflecting the desires of today's teenagers, or are they stoking a cultural infatuation with music and imagery that glorifies violence and sex

Discuss the safety and effectiveness of alternative : Discuss the safety and effectiveness of alternative and complementary medicine for the treatment of specific illnesses such as cancer, diabetes

Explain the risk assessment you would use to inform : Explain the risk assessment you would use to inform your treatment decision making. What are the risks and benefits of the FDA-approved medicine

How to properly add a military discount for home depot : describing how to properly add a military discount for home depot - You want to read the instructions for writing assignment #2 before writing your personas.

User Account

All Pages