Question

Question 1 Company XYZ has shown you their Balance Sheet and asked you to build a ProForma Balance Sheet. You will find key variables needed for this estimation just below the Balance Sheet. Your answers should be given to two decimal places Balance Sheet for Company XYZ, Inc. Common Size ProForma Current Assets: Cash Accounts Receivable $155,000.00 $805,000.00 $500,000.00 $1,460,000.00 $6,250,000.00 $7,710,000.00 2.01% 10.44% 6.49% 18.94% 81.06% 100.00% Inventoy Total Current Assets Total Fixed Assets Total Assets Current Liabilities: Notes Payable $108,000.00 1.40%

Next Years Estimated Sales $8,950,000.00 Next Years COGS Estimate $7,250,000.00 Current Receivables Period Current Inventory Period Current Payables Period New Capital Expenditures $150,000.00 $34.00 $26.20 $28.90

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Question 1 Company XYZ has shown you their Balance Sheet and asked you to build a...
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
  • Company XYZ has shown you their Income Statement and asked you to build a ProForma Income...

    Company XYZ has shown you their Income Statement and asked you to build a ProForma Income Statement for next year for them. Their estimated sales growth is 1 1 .70% and their estimated tax rate is 23.70%. Your answers should be given to two decimal places. Common Size Income Statement Income Statement for Company XYZ, Inc. ProForma Column Total Revenue $425,000.00 Cost of Goods Sold $250,000.00 Gross Profit $175,000.00 Operating Expenses Salaries $82,000.00 30,000.00 Utilities $6,550.00 Depreciation $25,500.00 Utilities $6,550.00...

  • You are given the below figures from the Income statement and Balance sheet of ABC Ltd...

    You are given the below figures from the Income statement and Balance sheet of ABC Ltd at the end of year 2018. Calculate the following for ABC Ltd: (a) Quick (acid-test) Ratio (b) Return on equity (C) Net profit margin [6M] Inventory Total assets Total long term liabilities Total current assets Total shareholder's equity Number of shares outstanding Data on ABC End 1,800,000.00 P/E ratio 5.450,000.00 Current market price 2,000,000.00 Cost of Inventory sold during the period 2,450,000.00 Income tax...

  • The balance sheet of XYZ Company is shown below. What is the Net Working Capital for...

    The balance sheet of XYZ Company is shown below. What is the Net Working Capital for the company? ASSETS LIABILITIES & OWNERS’ EQUITY Current assets $ 300 Current liabilities $ 240 Net fixed assets 1,500 Long-term debt 700 Owners’ equity 860 Total assets $ 1,800 Total liabilities and equity $ 1,800 Multiple Choice $180 $1,800 $1,560 $860 $60

  • XYZ Company Balance Sheet 12/31/XXXX Assets A Current Assets Cash Accounts Receivable Inventory Prepaid Items Other...

    XYZ Company Balance Sheet 12/31/XXXX Assets A Current Assets Cash Accounts Receivable Inventory Prepaid Items Other CA Total Current Assets Net Plant & Equipment Total Assets $7,500 12,100 10,400 5,900 4,300 $40,200 82,300 $122,500 XYZ Company Balance Sheet 12/31/xxxx Liabilities & Equity Current Liabilities Accounts Payable Wages Payable Notes Payable Taxes Payable Total Current Liabilities Long Term Debt Total Liabilities $7,200 3,600 5,400 4.200 $20,400 35,700 $56,100 Common Stock Retained Earnings 28,700 37,700 Total Liabilities & Equity $122,500 Homework Problem,...

  • CASE 1 (35 points) The 2019 financial statements for Assol Corporation follow. Assets, costs, and current...

    CASE 1 (35 points) The 2019 financial statements for Assol Corporation follow. Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not The company maintains a constant 40 percent dividend payout ratio. As with every other firm in its industry, next year's sales are projected to increase by exactly 15 percent . The firm is operating at full capacity and no new debt or equity is issued. Income Statement Balance Sheet Sales 57.900 Current assets...

  • CASE 1 (35 points) The 2019 financial statements for Assol Corporation follow. Assets, costs, and current...

    CASE 1 (35 points) The 2019 financial statements for Assol Corporation follow. Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 40 percent dividend payout ratio. As with every other firm in its industry, next year's sales are projected to increase by exactly 15 percent. The firm is operating at full capacity and no new debt or equity is issued. Income Statement Balance Sheet Sales $7.900 Current assets $3,900...

  • 11. You have the following balance sheet and income statement information for Epic Corp.: Balance sheet...

    11. You have the following balance sheet and income statement information for Epic Corp.: Balance sheet $ Accounts receivable (A/R) 1,800 Inventory 3,600 Accounts payable (A/P) 760 Income statement $ Sales 7,200 Cost of goods sold (COGS) 5,760 All sales and purchases were on credit. a. How long is the days inventory outstanding (in days)? b. How long is the collection period (in days)? c. How long is the payables period (in days)? d. How long is the cash conversion...

  • Use the following information to answer the following 5 questions. XYZ Company Balance Sheet as of...

    Use the following information to answer the following 5 questions. XYZ Company Balance Sheet as of December 31, 20X7 & 20X8 ASSETS: 20X7 20X8 Current assets: Cash $10,000 $12,000 Accounts receivable 20,000 25,000 Inventory 16,000 24,000 Prepaid insurance 4,000 3,000 50,000 64,000 Property & equipment 76,000 84,000 Total assets $126,000 $148,000 LIABILITIES AND STOCKHOLDERS EQUITY: Current liabilities: Accounts payable $15,000 $17,000 Other payables 3,000 7,000 18,000 24,000 Long term notes payable 35,000 40,000 Total liabilities 53,000 64,000 Stockholder's equity Capital...

  • Mel King has asked you to prepare a classified balance sheet for Pad Co. as of...

    Mel King has asked you to prepare a classified balance sheet for Pad Co. as of December 31, 2017. Ending merchandise inventory was $1,800: 10 Mel King has asked you to prepare a classified balance sheet for Pad Co, as of December 31, 2017 Ending merchandise inventory was $1,800 10 Cash Prepaid Rent Prepaid Insurance Office Equipment Accum. Depreciation Accounts Payable Salaries Payable Notes Payable (long-term) 3. Pad, Capital $1,500 4,500 3,000 4,500 3,089 1,800 2,250 1,569 9,750 eBook References...

  • Question: The financial statements of XYZ Company appear below: XYZ COMPANY Comparative Balance Sheet December 31,...

    Question: The financial statements of XYZ Company appear below: XYZ COMPANY Comparative Balance Sheet December 31, Assets Cash .........+4000... Short-term investments. Accounts receivable (net)...-9000 Inventory Property, plant and equipment (net) ........ Total assets ...... 2018 $ 35,000 15,000 50,000 50,000 250.000 $400.000 2017 $ 40,000 60,000 30,000 70,000 300.000 $500.000 Liabilities and stockholders' equity Accounts payable......... $ 10,000 Short-term notes payable ................. 40,000 Bonds payable ...... 88,000 Common stock ............ .....2.1.X 160,000 Retained earnings.- 960.0. 102.000 Total liabilities and stockholders'...

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