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 | ||
les Pevenax 477, 750 7. WillieC o will use a percent of sales basis to forecast...
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 $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% 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 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: 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 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 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) 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 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 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...