Purchase Solution

Percentage of Sales Method

Not what you're looking for?

Ask Custom Question

Dear OTA,

Please explain with steps.

Thanks
ALPHA Inc. has provided you with the following financial data for the year ended December 31, 2006. A major creditor has asked for pro forma financial statements for the year ending December 31, 2007.
Accounts payable $45500
Accounts receivable 60000
Accumulated depreciation 590000
Cash 1500
Common stock 71000
Cost of goods sold 195000
Depreciation expense 10000
General administrative exp 11000
Interest expense 12000
Inventory 95000
Long-term debt 55000
Notes payable 55000
Plant and equipment 740000
Retained earnings 75000
Sales 300000
Selling expense 40000
Wages payable 5000

Prepare the pro forma income statement and balance sheet for the year ending December 31, 2007, using the percent-of-sales method and the additional information that follows.
- 2007 sales are expected to be 10% higher than those of 2006
- Accounts receivable represent 20% of sales in both years
- A minimum cash balance of $1650 is maintained
- Inventory represents 32% of sales
- Plant and equipment outlays in 2007 are $20000
- Total depreciation expense for 2007 will be $15000
- Accounts payable represents 15% of sales
- Notes and wages payable will remain he same
- No long-tern debt will be retired in 2007
- No common stock will be issued or repurchased in 2007
- The firm will pay dividends equal to 50% of its earnings after taxes
- The firm uses a tax rate of 40% for all of its pro forma work
What is the firm's quick ratio at December 31, 2007, expected to be?

Attachments
Purchase this Solution
Solution Summary

The solution explains the percentage of sales method to prepare pro forma income statement and balance sheet.

Solution Preview

Please see the attached excel file

ALPHA Inc. has provided you with the following financial data for the year ended December 31, 2006. A major creditor has asked for pro forma financial statements for the year ending December 31, 2007.
Accounts payable $45500
Accounts receivable 60000
Accumulated depreciation 590000
Cash 1500
Common stock 71000
Cost of goods sold ...

Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting: Percentage of sales method.

    503938 Forecasting: Percentage of sales method. What is the percentage of sales method in forecasting? Explain the weaknesses of using this method.

  • Journal entry for bad debt expense

    (A) The percentage of sales approach (B) Percentage of Accounts Receivable method A .

  • Bad debt expense

    A The percentage of Sales Approach of Allowance Method: The percentage of sales approach matches cost and Revenue. In this approach bad debts are estimated as certain percentage of net sales based on past experience.

  • West Company: Charge to bad debt expense under two methods

    There is the percentage of sales method and the percentage of receivable method, as noted. Both involve making a calculation for the amount expected to go bad.

  • Essential Features of the Allowance Method of Accounting

    A The percentage of Sales Approach of Allowance Method: The percentage of sales approach matches cost and Revenue. In this approach bad debts are estimated as certain percentage of net sales based on past experience.

  • Percentage of Sales Model

    Working Capital - This possibly makes sense in the percentage of sales method. The current assets and spontaneous liabilities and dependant on the level of sales and so would change in the same proportion of sales.

  • Johnson Company uses the allowance method to account for unc

    405714 Johnson Company uses the allowance method to account for uncollectible accounts receivable. Bad debit expense is established as a percentage of credit sales.

  • Bad Debt Allowance

    Would you use the percentage of sales method or the percentage of accounts receivable method and why? Hi there, I hope that this helps you.

  • External Financing: Percentage Sales Method

    268981 External Financing: Percentage Sales Method Given the compressed version of balance sheet and income statement, estimate the amount of external financing needed to increase sales by 20% next year (use percentage of sales method).

  • Computing Bad Debts and Preparing Journal Entries

    In percentage of sales method we do not take into consideration the balance in the allowance for doubtful accounts. We pass the entry on the amount calculated based on percentage of sales.

View More Related Solutions