Question

les Pevenax 477, 750 7. WillieC o will use a percent of sales basis to forecast its Income Statement for next year. They assume expenses for G&A and Common Dividends will be the same as this year, and that both CoGS and Interest Expense v create a forecasted statement for next year assuming a 29 percent increase in sales ary with sales. Using the following current Income Statement, 2018 2019 Sales COGS Gross Profit G&A Expense EBIT Interest Expense EBT Taxes (25%) Net Income C Stock Div Change in RE $220,000 130,000 90,000 12,000 78,000 2,600 75,400 18,850 56,550 30,000 + 26,550

0 0
Add a comment Improve this question Transcribed image text
Answer #1
INCOME STATEMENT Year - 2018 Year - 2019 Remarks
PARTOCUALRS AMOUNT Based on % of Sales Amount (Forcasted)  
Service Revenue (A) $                     2,20,000 100% $                     2,83,800 (129% of $ 220,000)
Less: COGS $                     1,30,000 59% $                     1,67,700 59% of Sales
Gross Profit $                         90,000 $                     1,16,100
G&A Expenses $                         12,000 $                         12,000 No Change
EBIT $                         78,000 $                     1,04,100
Interest Expenses $                           2,600 1% $                           2,838 1 % of Sales
EBT $                         75,400 $                     1,01,262
Taxes @ 25% $                         18,850 $                   25,315.50
Net income $                         56,550 $                         75,947
C Stock Dividend $                         30,000 $                         30,000
Chnagein Retained Earning $                         26,550 $                         45,947
Add a comment
Know the answer?
Add Answer to:
les Pevenax 477, 750 7. WillieC o will use a percent of sales basis to forecast...
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
  • VanRee Recycling Inc. is expecting sales to rise 12 percent next year. Their most recent income...

    VanRee Recycling Inc. is expecting sales to rise 12 percent next year. Their most recent income statement and next year's projected income statement are below Income Statement This Year ecte 1,120,000 (481,600) (180,000) 458,400 (130,000) 328,400 Sales 1,000,000 (430,000) (180,000) 390,000 (130,000) 260,000 (78,000) 182,000 Costs Depreciation EBIT Interest expense EBT Taxes (.3) (98,520 Net Income 229,880 Dividends 109,200 137,928 Additions to Retained Earnings 72,800 91,952 This year's Balance Sheet is: Balance Sheet Cash 70,000 30,000 80,000 Accounts pay 60,000...

  • Consider the following projected income statement: INCOME STATEMENT Prepared by Kert Sanders Current Forecast Sales $1,000.00...

    Consider the following projected income statement: INCOME STATEMENT Prepared by Kert Sanders Current Forecast Sales $1,000.00 $500.00 $500 00 $100.00 $400.00 Sales Growth 25,00% less Cost of Goods Sold & Depreciation COGS&Deprecistion as a % of Sales 50.00% EBIT less Irterest Expense Irterest Growth 0.00% EBT $160.00 $240.00 $48.00 $192.00 less Taxes 40.00% Tax Rate NI less CommonDividends Addinon to Retaired Earings Payour Rato Diridend Growth Rate 20.00% 31.25% What is forecasted cost of goods sold? O $315 O $625...

  • Given data: 2020 Sales $4 million COGS 50%. Operating expenses 25% of sales, interest expense 2%...

    Given data: 2020 Sales $4 million COGS 50%. Operating expenses 25% of sales, interest expense 2% sales, Tax rate 40% Divided payout 40% 100,000 shares stock outstanding. Complete an income statement and Proforma income statement for 2021. Sales projections indicate 10% growth with no change in depreciation expense. Year 2020 Proforma Growth -10% 50.0% Income Statement Sales COGS Gross Profit Operating expense Depreciation Exp EBIT Oper. Profit 25.0% No change Interest exp. 2.00% 40 EBT Tax 40% EAT Dividend RE...

  • VanRee Recycling Inc. is expecting sales to rise 18 percent next year. Their most recent income...

    VanRee Recycling Inc. is expecting sales to rise 18 percent next year. Their most recent income statement and next year's projected income statement are below Income Statement This Year 1,000,000 (400,000) (180,000) 420,000 (130,000) 290,000 (87,000) 203,000 Projected 1,180,000 (472,000) (180,000) 528,000 (130,000) 398,000 (119,400), 278,600 Sales Costs Depreciation EBIT Interest expense EBT Taxes (.3) Net Income Dividends 121,800 167,160 Additions to Retained Earnings 81,200 111,440 This year's Balance Sheet is Balance Sheet 60,000 25,000 85,000 Cash 70,000 30,000 80,000...

  • 1.  Lasso Corp. wants to forecast for 2020.  The end of year statements for 2019 are as follows:...

    1.  Lasso Corp. wants to forecast for 2020.  The end of year statements for 2019 are as follows: Income Statement Revenues                     $245,622 COGS                            - 142,461 Gross Profits                 103,161 Expenses                       - 49,124 EBIT                                 54,037 - Interest                        -  9,642 EBT                                  44,395 -Taxes                              -7,991 EAT                                  26,637 Balance Sheet Current Assets           $179,304       Current liabilities          $85,700 Fixed Assets                 $140,930       Long-term debt            78,180 Total Assets                 $320,234       Total liabilities             $163,880                        Equity                          $156,354                     Total Liabilities & Equity                      $320,234 Management expects the following for 2020: An 8% increase in revenues; COGS will increase by 2% from its current percent of sales. Expenses will stay at the same percent of...

  • Create a model from an empty spreadsheet. Use the information below You must project Cleo's Nail...

    Create a model from an empty spreadsheet. Use the information below You must project Cleo's Nail Salon's income statement for 5 years. Here is the historical information you have received from Cleo's. Previous year's income statement for Cleo's Sales COGS SG&A EBIT Interest Expense EBT Taxes Net Income 500,000 300,000 100,000 100,000 10,000 90,000 28,800 61,200 Cleo's assumptions for the next five years at Sales growth COGS % of Sales SG&A % of Sales Interest Expense S Tax Rate Year...

  • Income Statement Sales 750,000 (218,000) (180,000) 352,000 (150,000) 202,000 (50,500) 151,500 Costs Depreciation EBIT Interest expense...

    Income Statement Sales 750,000 (218,000) (180,000) 352,000 (150,000) 202,000 (50,500) 151,500 Costs Depreciation EBIT Interest expense EBT Taxes Net Income Dividends 113,625 Additions to Retained Earnings 37,875 VanRee expects sales to rise by 10 percent next year. Costs are expected to increase spontaneously with sales. Depreciation and interest expense will remain constant. The tax rate will also remain constant. VanRee will continue to pay out 75 percent of their net income as dividends. Prepare next year's income statement What will...

  • We have Cromwell's financial statements from this year. Income Statement Sales 1,000,000 (250,000) (180,000) 570,000 (130,000)...

    We have Cromwell's financial statements from this year. Income Statement Sales 1,000,000 (250,000) (180,000) 570,000 (130,000) 440,000 (132,000) 308,000 Costs Depreciation EBIT Interest expense EBT Taxes (.3) Net Income Dividends 231,000 Additions to Retained Earnings 77,000 We were unable to transcribe this image

  • PROJECTED INCOME STATEMENT: Sales: $3,000.00 less Cost of Goods Sold: $2450.00 EBITDA: $550.00 less Depreciation this...

    PROJECTED INCOME STATEMENT: Sales: $3,000.00 less Cost of Goods Sold: $2450.00 EBITDA: $550.00 less Depreciation this year: $250.00 EBIT: $300.00 less Interest Expense: $125.00 EBT: $175.00 less Taxes: $70.00 NI: $105.00 Sales Growth: 20.00% COGS as a % of Sales: 70.00% Depreciation Growth: 20.00% Interest Expense Growth: 0.0% Tax Rate: 40.00% 1. What is projected sales? A. $655 B. $2,520 C. $393 D. $3,600 2. What is projected EBT? A. $393 B. $2,520 C. $3,600 D. $655 3. What is...

  • Use the following information to calculate this firm's days' sales in inventory as of the end...

    Use the following information to calculate this firm's days' sales in inventory as of the end of 2016: Income Statement For the Year 2016 Net Sales 631,000 COGS 442,220 Depreciation Expense 28,100 EBIT 160,700 Interest Expense 14,900 EBT 145,800 Tax Expense 49,600 Net Income 96,200 Cash Accounts Receivable Inventory Net Fixed Assets Total Assets Balance Sheet Beginning of 2016 38,200 91,400 203,900 516,100 849,600 End of 2016 $ 43,700 $ 86,150 $ 214,600 $ 537,950 $ 882,400 Accounts Payable Long-term...

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