Purchase Solution

Balance Sheet and Forecasting Calculation

Not what you're looking for?

Ask Custom Question

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)

The CFO of IPOD Accessories, Inc. has asked for your help in estimating the firm's additional financing needed for next year. The CFO has provided the following information to help you with your task:
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.

Attachments
Purchase this Solution

Solution Summary

This solution shows step-by-step calculations to determine the additional financing required, cash budgets and external financing for the financial scenarios. All workings are shown with proper balance sheet format.

Solution provided by:
Education
  • BA, Ain Shams University, Cairo Egypt
  • MBA, California State University, Sacramento
Recent Feedback
  • "ty i have more need help with"
  • "ty i have jmore i need help with"
  • "great help"
  • "excellent help"
  • "Very helpful and easy to understand."
Purchase this Solution


Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

IPOs

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

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.