Table 4.5
A financial manager at General Talc Mines has gathered the financial data essential to prepare a pro forma balance sheet for cash and profit planning purposes for the coming year ended December 31, 2015. Using the percent-of-sales method and the following financial data, prepare the pro forma balance sheet in order to answer the following multiple choice questions.
(a) The firm estimates sales of $1,000,000.
(b) The firm maintains a cash balance of $25,000.
(c) Accounts receivable represents 15 percent of sales.
(d) Inventory represents 35 percent of sales.
(e) A new piece of mining equipment costing $150,000 will be purchased in 2010.
Total depreciation for 2010 will be $75,000.
(f) Accounts payable represents 10 percent of sales.
(g) There will be no change in notes payable, accruals, and common stock.
(h) The firm plans to retire a long term note of $100,000.
(i) Dividends of $45,000 will be paid in 2015.
(j) The firm predicts a 4 percent net profit margin.
Balance Sheet
General Talc Mines
December 31, 2014
-General Talc Mines may prepare to ________. (See Table 4.5)
A) arrange for a loan equal to the external funds requirement
B) eliminate the dividend to cover the needed financing
C) cancel the retirement of the long term note to cover the needed financing
D) repurchase common stock equal to the external funds requirement

Question

Table 4.5
A financial manager at General Talc Mines has gathered the financial data essential to prepare a pro forma balance sheet for cash and profit planning purposes for the coming year ended December 31, 2015. Using the percent-of-sales method and the following financial data, prepare the pro forma balance sheet in order to answer the following multiple choice questions.
(a) The firm estimates sales of $1,000,000.
(b) The firm maintains a cash balance of $25,000.
(c) Accounts receivable represents 15 percent of sales.
(d) Inventory represents 35 percent of sales.
(e) A new piece of mining equipment costing $150,000 will be purchased in 2010.
Total depreciation for 2010 will be $75,000.
(f) Accounts payable represents 10 percent of sales.
(g) There will be no change in notes payable, accruals, and common stock.
(h) The firm plans to retire a long term note of $100,000.
(i) Dividends of $45,000 will be paid in 2015.
(j) The firm predicts a 4 percent net profit margin.
Balance Sheet
General Talc Mines
December 31, 2014 
-General Talc Mines may prepare to ________. (See Table 4.5)
A) arrange for a loan equal to the external funds requirement 
B) eliminate the dividend to cover the needed financing 
C) cancel the retirement of the long term note to cover the needed financing 
D) repurchase common stock equal to the external funds requirement

Quizplus · Accepted Answer

Based on the pro forma balance sheet and the given financial data, the external funds requirement for General Talc Mines is $357,500 ($435,000 assets - $77,500 liabilities). Therefore, the firm may choose to arrange for a loan of this amount to cover the financing needs. Option B is not a viable choice since it would negatively impact the firm's relationship with its shareholders. Option C is not advisable because it would delay the retirement of the long term note and increase interest expense. Option D is not feasible since there is no indication that the firm has excess cash to repurchase common stock.

Table 4.5 a Financial Manager at General Talc Mines Has Gathered the Gathered