Question

XYZ Company Balance Sheet 12/31/XXXX Assets A Current Assets Cash Accounts Receivable Inventory Prepaid Items Other CA Total
XYZ Company Balance Sheet 12/31/xxxx Liabilities & Equity Current Liabilities Accounts Payable Wages Payable Notes Payable Ta
Homework Problem, contd The projected sales for the forecast period is $165,000. Assume that the payout ratio will be mainta
Homework Problem, contd Hints: Pro Forma TA = Existing TA +ACA + ANFA Max Pro Forma Total Liabilities = (D.R. Constraint)(Pr


Percent of Sales Technique Homework XYZ Company Income Statement For the Year Ended 12/31/xxxx Sales Cost of Goods Sold Gross
0 0
Add a comment Improve this question Transcribed image text
Answer #1

“Since you have asked multiple questions, we will solve the one question for you. If you want any specific question to be solved then please specify the question number or post only that question”.

(A).

XYZ Company

Pro Forma Income Statement

For the year ended 31st Dec. XXXX

Particulars

Amount ($)

Sales

165,000

Less: Cost of Goods Sold

(137,890)

Gross Profit

27,110

Less: Operating Expenses

(12,830)

Earnings Before Interest and Taxes

14,280

Less: Interest Expenses

(4,610)

Earnings Before Taxes

9,670

Less: Tax@39%

(3,771)

Net income

5,899

Less: Dividend

(1,018)

Addition to Retained Earnings

4,881

XYZ Company

Pro Forma Balance Sheet

As on 31st Dec. XXXX

Particulars

Amount ($)

Amount ($)

Assets

Current Assets:

    Cash

7,500

    Accounts Receivables

12,100

    Inventory

10,400

    Prepaid Items

5,900

    Other Current Assets

4,300

    Investments

18,000

Total Current Assets

58,200

Net Plant and Equipment

82,300

Total Assets

140,500

Liabilities and Equity

Current Liabilities:

    Accounts Payable

7,200

    Wages Payable

3,600

    Notes Payable

5,400

    Taxes Payable

8,520

Total Current Liabilities

24,720

Long Term Debt

35,700

Total Liabilities

60,420

Common Stock

28,700

Retained Earnings

51,380

Total Liabilities and Equity

140,500

Add a comment
Know the answer?
Add Answer to:
XYZ Company Balance Sheet 12/31/XXXX Assets A Current Assets Cash Accounts Receivable Inventory Prepaid Items Other...
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
  • Solve thes questions with work. Answers provided The projected sales for the forecast period is $165,000....

    Solve thes questions with work. Answers provided The projected sales for the forecast period is $165,000. Assume that the payout ratio will be maintained in the forecast period. The firm estimates that additional net fixed asset investment of $18,000 will be required during the forecast period. Assume that all current assets are spontaneous except Other Current Assets which is assumed not to change. Assume that all current liabilities except Notes Payable are spontaneous. A. Prepare the pro forma Balance Sheet...

  • Balance Sheet Assets Current Assets Cash Accounts receivable Inventories Total current assets Liabilities Current Liabilities $47...

    Balance Sheet Assets Current Assets Cash Accounts receivable Inventories Total current assets Liabilities Current Liabilities $47 Accounts payable 23 Total current liabilities $40 40 86 Long-Term Liabilities Long-Term Assets Net property, plant, and equipment Total long-term assets 170 164 Long-term debt Total long-term 164 liabilities 170 Total Assets 250 210 Total Liabilities Stockholders' Equity Total Liabilities and Stockholders' Equity 250 The balance sheet for a small firm is shown above. All amounts are in thousands of dollars What is this...

  • Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below):     a)   ...

    Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below):     a)    create the Pro Forma statement for 2018 given the following assumptions: - sales increase by 20% - all items vary directly with sales (except for Notes Payable, LTD, Owners Equity) - the company is currently operating at 100% capacity - the dividend payout ratio stays at 50%     Income Statement 2017 Pro Forma 2018 Sales $3,000,000 Cost of Goods Sold 2,000,000 Depreciation 300,000 EBIT...

  • RETRO MACHINE,INC Balance Sheet as of December 31, 2016 ASSETS Current assets Cash Accounts receivable Inventory...

    RETRO MACHINE,INC Balance Sheet as of December 31, 2016 ASSETS Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment $ 17,070 24,560 58,650 $100,280 LIABILITIES AND OWNERS' EQUITY Current liabilities Accounts payable $ 45,900 Notes payable 11,480 Total $ 57,380 Long-term debt $106,000 Owners' equity Common stock and paid-in surplus $ 95,000 Accumulated retained earnings 120,680 Total $215,680 Total liabilities and owners' equity $379,060 $278,780 Total assets $37300 21. Calculating EFN The most recent financial statements...

  • RAM, Inc. has the following balance sheet: RRM, Incorporated Balance Sheet as of 12/31/XO Assets Liabilities...

    RAM, Inc. has the following balance sheet: RRM, Incorporated Balance Sheet as of 12/31/XO Assets Liabilities and Equity Cash $ 3,000 Accruals $ 3,500 Marketable securities 1,700 Accounts payable 16,400 Accounts receivable 17,340 Notes payable 5,000 Inventory 18,220 Long term debt 23,000 Common stock 22,000 Plant and equipment 38,000 Retained earnings 8,360 $78,260 $ 78,260 Sales are currently $100,000, but management expects sales to rise to $125,000. The net profit margin is expected to be 10 percent, and the firm...

  • Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets Provincial...

    Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets Provincial Imports, Inc., Balance Sheet December 31, 2015 Liabilities and stockholders' equity $ 200,000 Accounts payable 225,000 Taxes payable 625.000 Notes payable 500,000 Other current liabilities $1,550,000 Total current liabilities 1,400,000 Long-term debt $2.950,000 Total liabilities Common stock Retained earnings Total liabilities and equity $ 700,000 95,000 200,000 5,000 $1,000,000 500,000 $1,500,000 75,000 1.375,000 $2.950.000 (1) Projected sales are $6,000,000. (2) Cost of goods sold...

  • ASSETS Current Assets Cash $ $ $ $ Accounts receivable Inventory Other current assets $ S...

    ASSETS Current Assets Cash $ $ $ $ Accounts receivable Inventory Other current assets $ S Balance Sheet as of December 31, 2012, 2013, and 2014 (s in thousands) 2014 2013 2012 LIABILITIES 2014 2013 2012 Current liabilities 6,937 s 9,365 17,515 Accounts payable s $ 74,383 S 66 116 26,766 $ 25,735 Short-term debt $ 155 $ $ 241 $ 16,317$ 12,647 Total current liabilities $ 80,897 $ 74,637 11,462 $ 10,919 $ Long-term debt $ 60.997 s $...

  • Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment...

    Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment by $4,038,000 with a plant expansion. The inventories will grow by 30%, accounts receivable will grow by 25%, and marketable securities will be reduced by 47% to help finance the expansion. Assume all other asset accounts will remain the same and the company will use long-term debt to finance the remaining expansion costs (no change in common stock or retained earnings). Using this information...

  • Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment...

    Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment by $4,034,000 with a plant expansion. The inventories will grow by 34%, accounts receivable will grow by 15%, and marketable securities will be reduced by 53% to help finance the expansion. Assume all other asset accounts will remain the same and the company will use long-term debt to finance the remaining expansion costs (no change in common stock or retained earnings). Using this information...

  • Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment...

    Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment by $4,058,000 with a plant expansion. The inventories will grow by 31%, accounts receivable will grow by 21%, and marketable securities will be reduced by 53% to help finance the expansion. Assume all other asset accounts will remain the same and the company will use long-term debt finance the remaining expansion costs (no change in common stock or retained earnings). Using this information and...

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