Use the information provided in Table 6.1 to complete the pro forma income statement and balance sheet for J. W. Bracken Inc

What will be an ideal response?


Table 6.1 Answers
Assumptions: ($000's)
Current Sales $136.36
Growth Rate in Sales 10.0%
Gross Profit (% of Sales) 36.0%
SGA Expenses (% of Sales) 18.0%
Depreciation (% of Beginning Fixed Assets) 20.0%
Interest Expenses (% of Current Loan) 10.0%
Tax Rate 40.0%
Dividends (% of Net Earnings) 40.0%
Current Loans $27.0
Beginning Fixed Assets $33.0
No New External Equity
Pro forma age of accounts receivable (days) 38.6

J W Bracken Pro Forma Income Statement ($000's) Year 1 Pro Forma
Sales $150.0
CGS $96.0
Gross Profit $54.0
SGA Expenses $27.0
Depreciation $6.6
EBIT $20.4
Interest $2.7
EBT $17.7
Taxes $7.1
Net Earnings (NE) $10.6

Dividends $4.2
Change in Retained Earnings $6.4

J W Bracken Balance Sheets ($000's) Year 0 Year 1 Pro Forma
Assets
Cash $8.0 $8.6 Given
Accounts Receivable $12.0 $15.9
Inventory $22.0 $24.6 Given
Total Current Assets $42.0 $49.1

Fixed Assets $33.0 $34.5 Given
Total Assets $75.0 $83.6

liabilities
Accounts Payable $14.0 $14.8 Given
Long-Term Debt $27.0 $28.4
Total liabilities $41.0 $43.2

Equity $34.0 $40.4
Total liabilities and Equity $75.0 $83.6

Business

You might also like to view...

Which of the following best explains the cause-and-effect relationships portrayed by the Balanced Scorecard?

A. Improvements in areas related to Customer and Process perspectives lead to improvements in the Financial perspective. B. Improvements in the Process perspective leads to improvements in the Learning & Growth perspective. C. Improvements in the Learning & Growth and Customer perspectives lead to improvements in the Process perspective. D. Improvements in the Financial and Process perspectives lead to improvements in the Customer perspective.

Business

Juan owns a house in a poor area of a large city. A salesman visits his home, selling aluminum

siding. Juan buys and signs a contract, which calls for a price of $25,000 to be paid in monthly installments of $500 for 20 years. Juan only earns $700 per month. In addition, Juan's home is only worth about $35,000. The aluminum siding put on is worth no more than $1,500. Juan speaks and reads very little English and Juan thought he was signing a receipt for a free gift. Which of the following best describes this contract? A) The contract is fully enforceable as written. B) The contract is unenforceable because it is illusory. C) The contract is unenforceable because it is unconscionable. D) The contract is unenforceable because it is exculpatory.

Business

Yount, Inc is interested in expanding its business to include exporting its products to several other countries. Discuss two federal statutes that should be considered before making the decision to export

Business

Learning curves are most useful for measuring performance improvements for ______.

a. routine jobs b. simple jobs c. one-time jobs d. complex jobs

Business