Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Management, use the following spread and assumptions to create a pro forma balance sheet and dysis Tor Financial income statement for XYZ Corporation. Round your

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Management, use the following spread and assumptions to create a pro forma balance sheet and dysis Tor Financial income statement for XYZ Corporation. Round your answers to the nearest whole dollar amount and place your answers in the numbered pro forma below. (Hint: #12 is a plug, which is equal to External Financing Required.) 50 Days of S, G, & A Expenses 30% 60 45 Assumptions for Pro Forma (2012) Required Cash on Hand Sales Growth Rate Accounts Payable Period (Days) Accounts Receivable Collection Period (Days) Inventory Turnover Gross Profit Margin Selling, General, and Administrative Expenses Retention Ratio Tax Rate 9 times 13% 12% of Sales 50% 45% Pro Forma 2012 Net Sales 100.0% 100.0% 100.0% 2010 $16,10 4 $13,68 8 $2,416 4 $11,69 9 $2,065 2011 $20,61 3 $17,72 7 $2,886 COGS Gross Profit Expenses - 85. 03 15.0% 85.0% 15.0% 36.0% 14.0% S, G, & A Net Interest Expense Earnings before Tax $1,239 $103 $723 $325 $398 9.0% 0.7% 5.3% 2.4% 2.9% $1,610 $110 $696 $313 $383 10.0% 0.7% 4.3% 1.9% 2.4% $2,267 $90 $529 $238 $291 11.0% 0.4% 2.6% 1.2% 1.4% Tax Earnings after Tax Pro Forma 2012 2009 2010 2011 Assets Current Assets Cash and Securities Accounts Receivable Inventories Prepaid Expenses Total Current Assets Net Fixed Assets Total Assets $551 14.3% $1,789 46.4% $1,376 35.7% $120.3% $3,728 96.8% $124 3.2% $3,852 100.0% $644 12.9% $2,094 42.0% $1,932 38.8% $150.3% $4,685 94.1% $295 5.9% $4,980 100.0% $412 $2,886 $2,267 918 $5,583 $287 $5,870 7.0% 49.28 38.6% 0.3% 95.1% 4.9% 100.0% Liabilities and Owner's Equity Current Liabilities Bank Loan Accounts Payable CMLTD Accrued Wages Total Current Liabilities Long Term Debt Total Liabilities Common Stock Retained Earnings Total Owner's Equity Total Liabilities and Owner's Equity $50 $1,443 $50 $ 7 $1,550 $910 $2,460 $150 $1,242 $1,392 1.3% 37.5% 1.32 0 .XX 40.28 23.6% 63.9% 3.9% 32.2% 36.16 $50 1.0K $2,426 43.7% $50 1.03 $100 .2 $2,536 50.98 $860 17.32 $3,396 68.2% $150 3.0% $1,434 28.8% $1,584 31.88 $50 53,212 $100 918 53,380 $760 54,140 $150 51,580 $1,730 0.93 54.7% 1.7% 0.3% 57.4 12.9% 70.5% 2.6% 26.9% 29.5% $3,852 100.0% 54,980 100.0% $5,870 100.0% Place your answers in the blanks below. The blanks above are provided only as a reference/work area. (000's) Pro Forma 2012 Net Sales COGS Gross Profit Expenses S, G, EA Net Interest Expense Earnings before Tax $95 Tax Earnings after Tax Pro Forma 2012 Assets Current Assets Cash and Securities Accounts Receivable Inventories Prepaid Expenses Total Current Assets Net Fixed Assets Total Assets $20 $280 Liabilities and Owner's Equity Current Liabilities Bank Loan Accounts Payable CMLTD $100 $22 Accrued Wages Total Current Liabilities Long Term Debt Total Liabilities $150 Common Stock Retained Earnings Total Owner's Equity Total Liabilities and Owner's Equity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing An International Approach

Authors: Bahram Soltani

1st Edition

9780273657736

More Books

Students also viewed these Accounting questions

Question

Why would unions target health care workers?

Answered: 1 week ago