1 answer

Pro Forma Balance Sheet: Just need Common Stock & Retained Earnings, External Funds required, and Total...

Question:

Pro Forma Balance Sheet:

Pro forma balance sheet Peabody & Peabody has 2015 sales of $10.4 million. It wishes to analyze expected performance and financing needs for 2017-2 years ahead. Given the following information, respond to parts a. and b 1) The percents of sales for items that vary directly with sales are as follows Accounts rece able: 11.6%, Inventory: 17.6% Accounts payable 13.7% Net profit margin, a (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $475,000 is desired. (4) A new machine costing $653,000 will be acquired in 2016, and equipment costing $855,000 will be purchased in 2017. Total depreciation in 2016 is forecast as $291,000, and in 2017 $385,000 of depreciation will be taken. (5) Accruals are expected to rise to $495,000 by the end of 2017. (6) No sale or retirement of long-term debt is expected. (7) No sale or repurchase of common stock is expected. (8) The dividend payout of 50% of net profits is expected to continue. (9) Sales are expected to be S11.5 million in 2016 and $11.5 million in 2017 1% (10) The December 31, 2015, balance sheet is here EEBData Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Leonard Industries Balance Sheet December 31, 2015 $398,000 Accounts payable Assets Cash Marketable securities Accounts receivable Inventories Liabilities and Stockholders Equity $1,402,000 399,000 79,500 $1,880,500 1,995,500 3,717,000 198,000 Accruals 1,201,000 Other current liabilities 1,801,000 Total current liabilities Total current assets $3,598,000 Long-term debt Net fixed assets 3,995,000 Common stock Total liabilities and Total assets $7,593,000 stockholders equity $7,593,000 Print DoneCurrent assets Cash Marketable securities Accounts receivable Inventories 398000 198000 1201000 1801000 3598000 3995000 7593000 Total current assets Net fixed assets Total assetsAccounts payable Accruals Other current liabilities 399000 79500 1880500 1995500 3876000 Total current liabilities Long-term debt Total liabilities Common stock and Retained Earnings External funds required $ Total liabilities and stockholders eauitv Sb. Discuss the financing changes suggested by the statement prepared in part (a). (Select all the answers that apply.) A. Peabody & Peabody must arrange for additional financing of at least $644,000 over the next two years based on the given constraints and projections. □ B. Peabody & Peabody must arrange for additional financing of at least $639,000 over the next two years based on the given constraints and projections. C. If financing cannot be obtained, one or more of the constraints must be changed. □ D. Peabody & Peabodys retained earnings are enough to cover all of the companys desired level of certain accounts.

Just need Common Stock & Retained Earnings, External Funds required, and Total liabilities and stockholders equity, and the multiple choice question

Pro forma balance sheet Peabody & Peabody has 2015 sales of $10.4 million. It wishes to analyze expected performance and financing needs for 2017-2 years ahead. Given the following information, respond to parts a. and b 1) The percents of sales for items that vary directly with sales are as follows Accounts rece able: 11.6%, Inventory: 17.6% Accounts payable 13.7% Net profit margin, a (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $475,000 is desired. (4) A new machine costing $653,000 will be acquired in 2016, and equipment costing $855,000 will be purchased in 2017. Total depreciation in 2016 is forecast as $291,000, and in 2017 $385,000 of depreciation will be taken. (5) Accruals are expected to rise to $495,000 by the end of 2017. (6) No sale or retirement of long-term debt is expected. (7) No sale or repurchase of common stock is expected. (8) The dividend payout of 50% of net profits is expected to continue. (9) Sales are expected to be S11.5 million in 2016 and $11.5 million in 2017 1% (10) The December 31, 2015, balance sheet is here EEB
Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Leonard Industries Balance Sheet December 31, 2015 $398,000 Accounts payable Assets Cash Marketable securities Accounts receivable Inventories Liabilities and Stockholders' Equity $1,402,000 399,000 79,500 $1,880,500 1,995,500 3,717,000 198,000 Accruals 1,201,000 Other current liabilities 1,801,000 Total current liabilities Total current assets $3,598,000 Long-term debt Net fixed assets 3,995,000 Common stock Total liabilities and Total assets $7,593,000 stockholders' equity $7,593,000 Print Done
Current assets Cash Marketable securities Accounts receivable Inventories 398000 198000 1201000 1801000 3598000 3995000 7593000 Total current assets Net fixed assets Total assets
Accounts payable Accruals Other current liabilities 399000 79500 1880500 1995500 3876000 Total current liabilities Long-term debt Total liabilities Common stock and Retained Earnings External funds required $ Total liabilities and stockholders' eauitv S
b. Discuss the financing changes suggested by the statement prepared in part (a). (Select all the answers that apply.) A. Peabody & Peabody must arrange for additional financing of at least $644,000 over the next two years based on the given constraints and projections. □ B. Peabody & Peabody must arrange for additional financing of at least $639,000 over the next two years based on the given constraints and projections. C. If financing cannot be obtained, one or more of the constraints must be changed. □ D. Peabody & Peabody's retained earnings are enough to cover all of the company's desired level of certain accounts.

Answers

Solution: The workings of Income Statement and Project Balance Sheet is as under:-

Income Statement 2015 2016 2017
Sales 10400000 11500000 11500000
Profit Margin 322400 356500 356500
DPO 178250 178250
Retained Earning 178250 178250
Assets 2015 2016 2017 Liabilities and Stockholders Equity 2015 2016 2017
Cash $3,98,000.00 $4,75,000.00 $4,75,000.00 Accounts Payable $14,02,000.00 $15,75,500.00 $15,75,500.00
Marketable Sec $1,98,000.00 $1,98,000.00 $1,98,000.00 Accruals $3,99,000.00 $3,99,000.00 $4,95,000.00
Account Receivables $12,01,000.00 $13,34,000.00 $13,34,000.00 OCL $79,500.00 $79,500.00 $79,500.00
Inventories $18,01,000.00 $20,24,000.00 $20,24,000.00 TCL $18,80,500.00 $20,54,000.00 $21,50,000.00
TCA $35,98,000.00 $40,31,000.00 $40,31,000.00 Long Term Debt $19,95,500.00 $19,95,500.00 $19,95,500.00
Net Fixed Assets $39,95,000.00 $43,57,000.00 $48,27,000.00 Common Stock $37,17,000.00 $37,17,000.00 $37,17,000.00
Total Assets $75,93,000.00 $83,88,000.00 $88,58,000.00 Net Profit $0.00 $1,78,250.00 $3,56,500.00
External Fund Required $0.00 $4,43,250.00 $6,39,000.00
Total Liabilities and Stock holders Equity $75,93,000.00 $83,88,000.00 $88,58,000.00

Thus Common Stock will be $37,17,000.00; Retained Earning: for 2017: $3,56,500.00, External Funds required for 2017: $ 6,39,000.00 and Total Liabilities and Stock Holders Equity: $88,58,000.00

Ans for Multiple choice question is option (b).

.

Similar Solved Questions

1 answer
Cost of Production and Journal Entries Lighthouse Paper Company manufactures newsprint. The product is manufactured in...
Cost of Production and Journal Entries Lighthouse Paper Company manufactures newsprint. The product is manufactured in two departments, Papermaking and Converting. Pulp is first placed into a vessel at the beginning of papermaking production. The following information concerns production in the Pape...
1 answer
A large tract of South-Australian Mallee has been donated to long-term conservation. It has been heavily cleared and grazed for >100-years, and is negatively affected by alien invasive pests and we...
A large tract of South-Australian Mallee has been donated to long-term conservation. It has been heavily cleared and grazed for >100-years, and is negatively affected by alien invasive pests and weeds, 15-years of drought, and poor management of fire and irrigation practices.You have been tasked ...
1 answer
12) Answer the question on the basis of the following marginal utility data for products X...
12) Answer the question on the basis of the following marginal utility data for products X & Y. Assume the prices of X and Y are $4 and $2, respectively, and that the consumers income is $18. Units of x Marginal Utility, Y 16 14 12 Marginal Utility, x Units of Y 20 162 12 4 6 5 4 | 6 | 12 10...
1 answer
Aloudspeaker of mass 19.0 kg is suspended a distance of h= 1.80 m below the ceiling...
Aloudspeaker of mass 19.0 kg is suspended a distance of h= 1.80 m below the ceiling by two cables that make equal angles with the ceiling. Each cable has a length of l = 3.30 m. (Figure 1) Part A What is the tension Tin each of the cables? Use 9.80 m/s2 for the magnitude of the acceleration due to g...
1 answer
Suppose that when household income in a city rises by 30%, and the price of good...
Suppose that when household income in a city rises by 30%, and the price of good X remains unchanged, the quantity demanded of good X increases by 15%. Then, in this city, the income elasticity of demand for good X is , and you know that good X is...
1 answer
#NOTE THETA=2.5 degrees Part B - Normal Component of the Reaction at A The slender rod...
#NOTE THETA=2.5 degrees Part B - Normal Component of the Reaction at A The slender rod AB shown has a mass of m - 63.0 ky and is being supported by a rope and pulley system stationed at C Starting from rest in the position shown the rope and pulley system tug on the rod causing it to rotate about A....
1 answer
Sluent's response? (2 points) 2. The following are two hypothetical statements by American politicians Politician A:...
sluent's response? (2 points) 2. The following are two hypothetical statements by American politicians Politician A: "Our economy is in the crapper! Thirty states had falling incomes last year Politician B. "Our economy is showing appreciable gains Seventy percent of Americans had rising...
1 answer
The equilibrium constant, Kc, for the following reaction is 77.5 at 600 K. Calculate the equilibrium...
The equilibrium constant, Kc, for the following reaction is 77.5 at 600 K. Calculate the equilibrium concentrations of reactant and products when 0.304 moles of CO and 0.304 moles of Cl2 are introduced into a 1.00 L vessel at 600 K Co Clh COC2l...
1 answer
Which species is larger in each pair? ) o^ 2 or s^ 2 ii) re^ 2+ or Fe^ 3+ iii) k K^ + Which of the following spe...
Which species is larger in each pair? ) o^ 2 or s^ 2 ii) re^ 2+ or Fe^ 3+ iii) k K^ + Which of the following species would be expected to have the lowest ionization energy? Which of the following has the largest first ionization energy? Select...
1 answer
Solve the inequality. Express your answer using set notation or interval notation. Graph the solution set....
Solve the inequality. Express your answer using set notation or interval notation. Graph the solution set. - 2(4x-5)<2 Choose the correct and per below that is the solution set to the inequality O A. {x[x> 1} or (1,00) OB. {x\x < 1) or (-0,1) O C. {x}x< - 1} or [-00,- 1] OD. {x[x> 1} ...
1 answer
On Jan. 2 this year, Earth was 1.471x10^13 cm from the Sun, its closest point to...
On Jan. 2 this year, Earth was 1.471x10^13 cm from the Sun, its closest point to the Sun. The semi-major axis of Earth's orbit around the Sun is 1AU (1.496x10^13 cm. Use this information to determine: A. The eccentricity of Earth's orbit around the Sun. B. The difference between the maximum ...
1 answer
Why is co2 dispersion forces? example please and typed answer.
why is co2 dispersion forces? example please and typed answer....
1 answer
YOU FOCUS YOUR ATTENTION ON THE STARS that are contained within or very close to THE CONSTELLATIO...
YOU FOCUS YOUR ATTENTION ON THE STARS that are contained within or very close to THE CONSTELLATIONS OF THE ZODIAC groups such as Taurus the Bulland Gemini the Twins (etc). Page 20 of 34 and stars very close to the zodiac constellations such as Sirius (the Dog Star) & Betelgeuse (the Hunter's...