Question

VanRee Recycling Inc. is expecting sales to rise 18 percent next year. Their most recent income statement and next years 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 years Balance Sheet isBalance Sheet 60,000 25,000 85,000 Cash 70,000 30,000 80,000 Accounts pay Notes payable Current Liab Accounts rec Inventory Current Assets 180,000 Long-term debt 250,000 Fixed Assets 750,000 Owners Equity 90,000 505,000 595,000 Common stock Retained earnings Total OE Total Assets 930,000 Total Liab & OE 930,000 Current assets and current liabilities increase with sales, the firm is operating at full capacity and no new long-term debt or equity is issued. Prepare next years balance sheet What is the external financing needed? Round to the nearest whole number and no commas

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum 11.A. A.--- 9- ー E ゴText ずWrap Text General в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Paste Format Painter B 2 ClearFe Select Edting Clipboard Font Alignment Number Cells IL399 IG IH IK ILI IM IN IO IP RT IR 399 400 TOTAL ASSETS 401 402 CASH 403 404 INVENTORIES 405 TOTAL 406 407 408 409 100 411 12 TOTAL 413 414 EFN FOR CURRENT YEAR-TOTAL ASSETS-TOTAL EQUITY- LONG TERM DEBT - CURRENT LIABILITIES 415 416 417 ANS EFN 45160 FORECASTED BALANCESHEET CURRENT NEXT TOTAL LIABILITIES & EQUITY YEAR YEAR 70000 30000 80000 180000 82600 18% INCREASE 35400 18% INCREASE 94400 18% INCREASE 212400 18% INCREASE ACCOUNTS PAYABLE NOTES PAYABLE 60000 25000 70800 18% INCREASE 25000 RECEIVABLES TOTAL EFN LONG TERM DEBT OWNERS EQUITY COMMON STOCK RETAINED EARNINGS TOTAL TOTAL LIABILITIES & EQUITY 85000 95800 45160 (BALANCING FIGURE) 250000250000 NET FIXED ASSETS 750000 885000 18% INCREASE 90000 90000 505000 616440 505000+111440) 595000 706440 930000 1097400 930000 1097400 18% INCREASE EFN = FOR CURRENT YEAR-1097400-706440-250000-95800- 45160 N BANKING NOTE BIDDING, UNDERWRITING EUAC AW PM LIFE LP, IP, MRP, INFLATION YIELD WARRAN Trefund bondCLEAN INVOICE PRICE SheetlSheet3 S erences: 1198 0-01-2019

Add a comment
Know the answer?
Add Answer to:
VanRee Recycling Inc. is expecting sales to rise 18 percent next year. Their most recent income...
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...

  • Continuing with the previous problem, Cromwell's projected Income Statement is: Income Statement Projected 1,200,000 (300,000) (180,000)...

    Continuing with the previous problem, Cromwell's projected Income Statement is: Income Statement Projected 1,200,000 (300,000) (180,000) 720,000 (130,000) 590,000 (177,000) 413,000 Sales 1,000,000 (250,000) (180,000) 570,000 (130,000) 440,000 (132,000) Costs Depreciation EBIT Interest expense EBT Taxes (.3) Net Income 308,000 Dividends 231,000 309,750 Additions to Retained Earnings 77,000 103,250 This year's Balance Sheet is Balance Sheet Cash 70,000 Accounts pay Notes payable Current Liab 60,000 25,000 85,000 Accounts rec 30,000 Inventory 80,000 Current Assets 180,000 Long-term debt 250,000 Fixed Assets...

  • 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 Balance Sheet Cash 60,000 25,000 85,000 70,000 Accounts pay 30,000 80,000 180,000 Accounts rec Notes payable Inventory Current Liab Current Assets Long-term debt 250,000 Fixed Assets 750.000 Owners' Equity Common stock 90,000 505,000 595,000 Retained earnings Total OE Total Assets 930,000 Total Liab &...

  • Let's change capacity to 90 percent and recalculate external financing needed. We have Cromwell's financial statements...

    Let's change capacity to 90 percent and recalculate external financing needed. 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 Balance Sheet Cash 70,000 Accounts pay 60,000 Accounts rec 30,000 Notes payable 25,000 Inventory 80,000 Current Liab 85,000 Current Assets 180,000 Long-term debt 250,000 Fixed Assets 750,000 Owners' Equity Common stock 90,000 505,000...

  • REFER The most recent financial statements for Reply, Inc., are shown here: oneet Income Statement Sales...

    REFER The most recent financial statements for Reply, Inc., are shown here: oneet Income Statement Sales $ 23,700 Costs 14.400 Assets Balance Sheet $ 55,200 Debt Equity $20,400 34,800 Taxable income $ 9,300 Total $ 55,200 Total $55,200 Taxes (40%) 3,720 Net income $ 5,580 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,800 was paid, and the company wishes to maintain a constant payout ratio. Next year's sales are projected to be...

  • The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales $9,500 $...

    The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales $9,500 $ 2,700 Balance Sheet Current Current $ 4,200 assets liabilities Fixed assets 9,400 Long-term debt Costs 6,700 4,260 Taxable income $2,800 Equity 6,640 672 Total $13,600 Taxes (24%) Total $13,600 Net Income $ 2,128 Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 35 percent dividend payout ratio. As with every other firm in...

  • The most recent financial statements for Assouad, Inc., are shown here: Balance Sheet Income Statement Sales...

    The most recent financial statements for Assouad, Inc., are shown here: Balance Sheet Income Statement Sales Costs Taxable $3.200 Current $5,400 liabilities assets Current $ 3,300 Long-term 4,820 7,900 Fixed assets 10,200 Long-term Equity 7,480 income Taxes (24%) 768 Total $15,600 Total $15,600 Net income $2,432 Assets, costs, and current liabilities are proportional to sales. Long-term deb are not. The company maintains a constant 40 percent dividend payout ra every other firm in its industry, next year's sales are projected...

  • The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales $10,700 Current...

    The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales $10,700 Current $ 5,100 $ 3,150 Balance Sheet Current Current assets liabilities Fixed assets 10,000 Long-term debt Costs 7,600 4,680 Taxable income $ 3,100 Equity 7,270 Taxes (24%) 744 Total $ 15,100 Total $15,100 Net income $ 2,356 Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 44 percent dividend payout ratio. As with every...

  • The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales $11.900 Balance...

    The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales $11.900 Balance Sheet Current Current liabilities Long-term Fixed assets 10,600 debt assets $6,000 $ 3,600 Costs 8,500 5,100 Taxable income $3,400 Equity 7,900 Taxes (24%) 816 Total $16,600 Total $16,600 Net income $2,584 Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 45 percent dividend payout ratio. As with every other firm in its industry,...

  • The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales Costs Balance...

    The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales Costs Balance Sheet $11,500 Current Current liabilities $ 5,700 $3,450 assets 8,200Fixed assets 10,400 Long-term 4,960 debt Taxable $3,300 Equity 7,690 income Taxes (24%) 792 Total $16,100Total $16,100 Net income $2,508 Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 35 percent dividend payout ratio. As with every other firm in its industry, next year's...

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