Question

In: Finance

XYZ Company Income Statement Sales $140,000 Cost of Goods Sold 117,000 Gross Profit 23,000 Operating Expenses...

XYZ Company

Income Statement

Sales $140,000
Cost of Goods Sold 117,000
Gross Profit 23,000
Operating Expenses 12,830
EBIT 10,170
Taxes @39% 2168
Net income 3,392
Dividend 1,018
Addition to Retained Earnings $2,374
XYZ Company
Balance Sheet
Current Assets
Cash $7,500
Accounts Receivable 12,100
Inventory 10,400
Prepaid Items 5,900
Other CA 4,300
Total Current Assets $40,200
Net Plant $ Equipment 82,300
Total Assets $122,500

XYZ Company

Balance Sheet

Current Liabilities
Accounts Payable $7,200
Wages Payable 3,600
Notes payable 5,400
Taxes Payable 4,200
Total Current Liabilities $20,400
Long Term Debt 35,700
Total Liabilities $56,100

Common Stock

Retained Earnings

28,700

37,700

Total Liabilities & Equity

$122,500

Questions

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 and pro forma Income Statement. The EFR will be a plug number that makes the balance sheet balance like in the class example.

B.  Using the existing financial statements as your basis, estimate firm XYZ’s EFR for the forecast period again, but this time using the cookbook model. Assume that the profit margin remains the same in the forecast period. Also based on the cookbook equation, how much funding is expected to come from each of the internal sources of funds (change in SL and retained earnings). If firm XYZ must maintain a minimum current ratio of 1.8 and a maximum debt ratio of 0.50, how would you propose the EFR be financed (how much short term debt, long term debt, and equity)?

C.  Based on your results in part B, prepare a Pro Forma Sources and Uses of Funds Statement to reflect the financing allocations that you decided on in part B. The only format change required is to break the total EFR down into the amounts of short term debt, long term debt, and new equity. You will have to use the numbers for △CA, △SL, addition to R.E., and EFR that you calculated in part B to make it balance, since they may be slightly different than those from part A. Explain the basis for your financing allocations.

Answers

-Pro forma EFR = $18,589

-Cookbook EFR = $18,941

-Financing Plan with constraints at their limits

Additional Notes Payable: $2,820

Additional LTD: $11,861

Additional Equity: $4,260

Solutions

Expert Solution

Pro forma Financial Statement:

A pro forma financial statement is prepared for the income statement and a balance sheet. A projected income statement and balance sheet are called pro format financial statements. These contain the projected future values.

A)

Income   Statement
Current Ratio (Vertical Analysis) (see Note 1) Projected (See Note   2)
Sales $140,000 100.00% $ 165,000
Cost of Goods Sold 117,000 83.57% $ 137,893
Gross Profit $23,000 16.43% $ 27,107
Operating Expenses 12,830 9.16% $ 15,121
EBIT 10,170 7.26% $ 11,986
Interest Expense 4,610 3.29% $ 5,433
EBT 5,560 Taxes @ 39% 2,168 1.55% $ 2,555
Net Income $3,392 2.42% $ 3,998
Dividend 1,018 0.73% $ 1,200
Addition to Retained Earnings $2,374 1.70% $ 2,798
Balance Sheet
Current Ratio (Vertical Analysis) (see Note 3) Projected (See Note   4)
Assets
Current   Assets:
Cash $7,500 6.12% $ 8,840
Accounts Receivable 12,100 9.88% $ 14,261
Inventory 10,400 8.49% $ 12,257
Prepaid Items 5,900 4.82% $ 6,954
Other CA 4,300 3.51% $ 4,300
Total Current Assets $40,200 32.82% $ 46,612
Net Plant & Equipment 82,300 67.18% $ 100,300
Total Assets $122,500 100.00% $ 146,912
Liabilities & Equity
Current   Liabilities:
Accounts Payable $7,200 5.88% $ 7,200
Wages Payable 3,600 2.94% $ 4,243
Notes Payable 5,400 4.41% $ 5,400
Taxes Payable 4,200 3.43% $ 4,950
Total Current Liabilities $20,400 16.65% $ 21,793
Long Term Debt 35,700 29.14% $ 53,700
Total Liabilities $56,100 45.80% $ 75,493
Common Stock 28,700 23.43% $ 30,961
Retained Earnings 37,700 30.78% $ 40,498
Total Liabilities & Equity $122,500 100.00% $ 146,912

Note 1: The elements in the current year has been computed as percentage of revenue (sales).

Note 2: The amount and percentage in the projected year have been computed based on new projected revenue.

Note 3 & Note 4: The percentage in the balance sheet items for asset components and equity & liability components have been computed as the percentage of the total assets and total shareholders' equity and liability, respectively, which has been computed based on the given constraints. All amount has been found based on percentage.

B) & C)

Estimation   of firm XYZ's EFR for the forecast period
Particulars Amount
Ending Total Asset (a) $ 146,912
Less: Beginning Total Asset $ 122,500
Change in the total asset ($146,912 -   $122,500) $ 24,412
Less: Cash generated from operations $ (2,798)
Required External Finance (b) $ 21,614
EFR (External Finance Ration) (b/a) 14.71%
Source of External Finance
Current (a) Projected (b) Amount (a - b)
Wages Payable $ 3,600 $    4,243 $ 643
Taxes Payable $ 4,200 $    4,950 $ 750
Long Term Debt $ 35,700 $    53,700 $ 18,000
Common Stock $ 28,700 $    30,961 $ 2,261
Total $ 21,614

Related Solutions

Sales are $3.70 million, cost of goods sold is $550,000, depreciation expense is $140,000, other operating expenses is $290,000. addition to retained
Sales are $3.70 million, cost of goods sold is $550,000, depreciation expense is $140,000, other operating expenses is $290,000. addition to retained earnings is $1,766,625, dividends per share are $1, tax rate is 21 percent, and number of shares of common stock outstanding is 80,000. Lafonya's Flop Shops has no preferred stock outstanding.Use the above information to calculate the times interest earned ratio for LaTonya's Flop Shops, Inc. (Round your answer to 2 decimal places.)Interest earned ________  times
BOK has sales of $500,000, Cost of Goods Sold of $140,000, administrative expenses of $20,000 depreciation...
BOK has sales of $500,000, Cost of Goods Sold of $140,000, administrative expenses of $20,000 depreciation expense of $10,000, and interest expense of $30,000. What is the net income for the firm using the following tax schedule? Taxable Income Tax Rate $ 1-50,000 10% $ 50,001-75,000 20% $ 75,001-100,000 30% $100,001-335,000 40% $335,001 + 50%
Kaler Company has sales of $1,410,000, cost of goods sold of $785,000, other operating expenses of...
Kaler Company has sales of $1,410,000, cost of goods sold of $785,000, other operating expenses of $198,000, average invested assets of $4,400,000, and a hurdle rate of 11 percent. Required: 1. Determine Kaler’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin answer to the nearest whole percentage, (i.e., 0.1234 should be entered as 12%). Round your Investment Turnover answers to 4 decimal places.) Please calculate...
Solano Company has sales of $700,000, cost of goods sold of $470,000, other operating expenses of...
Solano Company has sales of $700,000, cost of goods sold of $470,000, other operating expenses of $50,000, average invested assets of $2,100,000, and a hurdle rate of 9 percent. Required: 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. 2. Several possible changes that Solano could face in the upcoming year follow. Determine each scenario’s impact on Solano’s ROI and residual income. (Note: Treat each scenario independently.) a. Company sales and cost of goods sold...
Solano Company has sales of $760,000, cost of goods sold of $500,000, other operating expenses of...
Solano Company has sales of $760,000, cost of goods sold of $500,000, other operating expenses of $40,000, average invested assets of $2,250,000, and a hurdle rate of 11 percent. 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.) 2....
Kaler Company has sales of $1,450,000, cost of goods sold of $795,000, other operating expenses of...
Kaler Company has sales of $1,450,000, cost of goods sold of $795,000, other operating expenses of $208,000, average invested assets of $4,600,000, and a hurdle rate of 12 percent. Required: 1. Determine Kaler’s return on investment (ROI), investment turnover, profit margin, and residual income. 2. Several possible changes that Kaler could face in the upcoming year follow. Determine each scenario’s impact on Kaler’s ROI and residual income. (Note: Treat each scenario independently.) a. Company sales and cost of goods sold...
Solano Company has sales of $720,000, cost of goods sold of $480,000, other operating expenses of...
Solano Company has sales of $720,000, cost of goods sold of $480,000, other operating expenses of $45,000, average invested assets of $2,150,000, and a hurdle rate of 10 percent. 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.) Return...
Solano Company has sales of $720,000, cost of goods sold of $480,000, other operating expenses of...
Solano Company has sales of $720,000, cost of goods sold of $480,000, other operating expenses of $45,000, average invested assets of $2,150,000, and a hurdle rate of 10 percent. Required: 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.)...
Solano Company has sales of $840,000, cost of goods sold of $540,000, other operating expenses of...
Solano Company has sales of $840,000, cost of goods sold of $540,000, other operating expenses of $70,000, average invested assets of $2,450,000, and a hurdle rate of 11 percent. Required: 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.)...
Solano Company has sales of $800,000, cost of goods sold of $520,000, other operating expenses of...
Solano Company has sales of $800,000, cost of goods sold of $520,000, other operating expenses of $35,000, average invested assets of $2,350,000, and a hurdle rate of 11 percent. 2. Several possible changes that Solano could face in the upcoming year follow. Determine each scenario’s impact on Solano’s ROI and residual income. (Note: Treat each scenario independently.) (Enter your ROI percentage answers to 2 decimal places, (i.e., 0.1234 should be entered as 12.34%.))    a. Company sales and cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT