Question

ACTUAL FORECAST 2018 2019 Total Revenue $       71,879 Cost of Revenue $      (51,125) Gross Profit $      ...

ACTUAL FORECAST
2018 2019
Total Revenue $       71,879
Cost of Revenue $      (51,125)
Gross Profit $       20,754
Operating Expenses:
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 $           (666)
Pre-Tax Income $         3,646
Provision for Income Tax (19.5%) $           (711)
Net Income $         2,935

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. 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
  2. Determine whether you think Tag-It can hit the target of a 10% increase in sales next year.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

4 THE INCOME STATEMENT 5 6 7 Actual $ Forecast-$ 2018 2019 71,879 79,067 8 9 9 51,125 20,754 56,238 22,829 10 11 12 14,248 153 4 5 Year Revenue Growth rate % 2015 72618 2016 73785 1.6 73785-72618/72618*100 2017 69495 -5.81 2018 71879 3.43 2019 79067

Add a comment
Know the answer?
Add Answer to:
ACTUAL FORECAST 2018 2019 Total Revenue $       71,879 Cost of Revenue $      (51,125) Gross Profit $      ...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The income statement. ACTUAL FORECAST        2018 2019                             ...

    The income statement. ACTUAL FORECAST        2018 2019                                  $71,879                                           Cost of Revenue $(51,125)                                          gross profit $20,754                                                                      operating expenses    Selling, General, and Administrative    $(14,248)                                 ...

  • Utilizing the fictitious company Tag-It Corporation, prepare next year’s forecast with a pro forma income statement....

    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 2019 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:...

  • Utilizing the fictitious company Tag-It Corporation, prepare next year’s forecast with a pro forma income statement....

    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. The total revenue numbers over the past 4 years for Tag-It Corporation were as follows: Values...

  • Need help with what I got wrong, please. Common-Size Income Statements Following is the income statement...

    Need help with what I got wrong, please. Common-Size Income Statements Following is the income statement for Target Corporation. Prepare Target's common-size income statement for the fiscal year ended February 3, 2018. Fiscal year ended ($ millions) February 3, 2018 Sales revenue $71,879 Cost of sales 51,125 Selling, general and administrative expenses 14,248 Depreciation and amortization 2,194 Earnings from continuing operations before interest and income taxes 4,312 Net interest expense 666 Earnings from continuing operations before income taxes 3,645 Provision...

  • Review the multiple-step income statements that you have completed From the annual report of Target corporation...

    Review the multiple-step income statements that you have completed From the annual report of Target corporation and Amazon .com for the year ended 2017 and evaluate the information. If you had to decide which company was more successful using only the multiple-step income statement you created, which one would you be more likely to invest in and why? Target Income Statement 2017 (a) 2016 2015 2014 2013 FINANCIAL RESULTS: (in millions) Sales (b) $71,879 $69,495 $73,785 $72,618 $71,279 Cost of...

  • Income Statement 12/31/2019 12/31/2018 Total Revenue 22428000 21965000 2.11% Cost of Revenue 16445000 15907000 3.38% Gross...

    Income Statement 12/31/2019 12/31/2018 Total Revenue 22428000 21965000 2.11% Cost of Revenue 16445000 15907000 3.38% Gross Profit 5983000 6058000 -1.24% Operating Expense 3026000 2852000 6.10% Operating Income 2957000 3206000 -7.77% Net Non Operating Interest Income Expense 8000 -24000 -133.33% Other Income Expense -8000 -18000 -55.56% Tax Provision 657000 699000 -6.01% Total Expenses 19471000 18759000 3.80% Interest Income 90000 69000 30.43% Interest Expense 82000 93000 -11.83% EBIT 3039000 3257000 -6.69% Tax Rate for Calcs 0 0 Tax Effect of Ususual Items...

  • Income Statement Revenue Total revenue $470,100 Cost of Revenue $149,700 Gross Profit $320,100 Operating Exp Selling...

    Income Statement Revenue Total revenue $470,100 Cost of Revenue $149,700 Gross Profit $320,100 Operating Exp Selling General & Admin $57,800 other $17,400 Total Operating Exp $269,900 Operating Income or Loss $200,200 Income from Continuing Operations Expenses Net/Total other Income $114,400 Earnings before Int & Tax $200,200 Interest Exp -$32,200 Income before Tax $314,600 Income Tax Exp $100 Minority Interest $23,300 Net Income from Continuing Ops $314,500 Net Income   $295,300 Net Income applicable to common shares $230,700 Balance Sheet Current Assets...

  • Income Statement Sales/Revenue Total revenue 76,480,000,000 Cost of Revenue 25,110,000,000 Gross Profit 51,370,000,000 Operating Exp 31,810,000,000...

    Income Statement Sales/Revenue Total revenue 76,480,000,000 Cost of Revenue 25,110,000,000 Gross Profit 51,370,000,000 Operating Exp 31,810,000,000 Selling General & Admin - Other Operating Expense 3,390,000,000 Unusual Expense 16,180,000,000 EBIT after Unusual Expense 2,130,000,000 Non Operating Income/Expense 385,000,000 Equity in Affiliates (Pretax) 1,020,000,000 Interest Expense 17,670,000,000 Pretax Income 16,370,000,000 Other After Tax Income (Expense) 1,300,000,000 Consolidated Net Income - Minority Interest Expense 1,300,000,000 Net Income - Discontinued Operations 1,300,000,000 Net Income After Extraordinaries - Preferred Dividends 1,300,000,000 Net Income Available to...

  • 2019 2018 Total Revenue $514,405,000 $500,343,000 Cost of Goods Sold $385,301,000 $373,396,000 Gross Profit $129,104,000 $126,947,000...

    2019 2018 Total Revenue $514,405,000 $500,343,000 Cost of Goods Sold $385,301,000 $373,396,000 Gross Profit $129,104,000 $126,947,000 Gross Profit Percentage 25.10% 25.37% Net Income $6,670,000 $9,862,000 Total Revenue $514,405,000 $500,343,000 Net Income Margin 1.30% 1.97% Comment on changes: Are sales increasingly profitable? How are gross profit and net income changing, as dollar values?

  • Determine the missing amounts. Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Net Inc...

    Determine the missing amounts. Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Net Inc Year $ 72,340 $ (b) $32,300 $ (d) Year $111,100 $73,700 $ Year $71,900 $71,900 $116,050 $47,390 $ eTextbook and Media Save for Later Attempts: 0 of 10 used Submit Answer Send to Gradebook < Prev Next > Operating Expenses Net Income 32,300 $ $13,050 (0) $ $30,910 116,050 $47,390 $ Attempts: 0 of 10 used Submit Answer

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT