Explore BrainMass

# Balance Sheet and Forecasting Calculation

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Please see attached. Thank you :)

(1)
a. Using the percentage of sales method, calculate the additional financing Baldwin Products will need over the next year at the \$6 million sales level. Show the pro forma balance sheet for the company as of December 31, 2006, assuming a sales level of \$6 million is reached. Assume that all assets vary proportionally with sales. Accounts payable is the only liability that varies proportionally with sales. Assume that the additional financing needed is obtained in the form of additional notes payable (in other words, assume that notes payable is the "plug" figure).

b. Suppose that the Baldwin Products' management feels that the average collection period on its additional sales?that is, sales over \$4 million?will be 60 days, instead of the current level. By what amount will this increase in the average collection period increase the financing needed by the company over the next year?

c. If the Baldwin Products' banker requires the company to maintain a current ratio equal to 1.6 or greater, what is the maximum amount of additional financing that can be in the form of bank borrowings (notes payable)? What other potential sources of financing are available to the company?

(4)

Prepare a cash budget for Rotor Products, Inc. for the second quarter of 2006, based on the following information. The marketing department has provided you with the following sales estimates, all of which are for cash:

Total Sales
March 2006 (actual) \$425,000
April 2006 330,000
May 2006 420,000
June 2006 450,000

The company estimates its purchases at 60 percent of next month's sales, and payments for those purchases are budgeted to lag the purchases by 1 month.
Various disbursements have been estimated as follows:

April May June
Wages and salaries \$220,000 \$190,000 \$190,000
Rent 14,000 14,000 14,000
Other expenses \$ 5,000 6,000 7,000

In addition, a tax payment of \$55,000 is due on April 15. The company's projected cash balance at the beginning of April is \$60,000, and the company desires to maintain a balance of \$50,000 at the end of each month.

(8)

Appalachian Registers, Inc. (ARI) has current sales of \$50 million. Sales are expected to grow to \$75 million next year. ARI currently has accounts receivable of \$10 million, inventories of \$15 million, and net fixed assets of \$20 million. These assets are expected to grow at the same rate as sales over the next year. Accounts payable are expected to increase from their current level of \$10 million to a new level of \$13 million next year. ARI wants to increase its cash balance at the end of next year by \$2 million over its current cash balances, which average \$4 million. Net income next year is forecasted to be \$10 million. Next year, ARI plans to pay dividends of \$1 million, up from \$500,000 this year. ARI's marginal tax rate is 34 percent. How much external financing does ARI require next year?

(10)

Sales are forecasted to increase by \$450,000.
Total assets will increase by 80 percent of increase in sales.
Current liabilities will increase by 30 percent of increase in sales.
Net income is projected to equal \$125,000.
Projected dividend payments will equal \$35,000.