X P12-11 (similar to) Question Help Proforma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment by $4.058,000 with a plant expansion. The inventories will grow by 30% accounts receivable wil grow by 21% and marketable securities will be reduced by 58% to help finance the expansion Assume al other asset accounts will remain the same and the company will use long-term debt to finance the remaining expansion costs (no change in common stock retained earingsl Using this information and the balance sheet in the popup window. for National Beverage Company for 2013, prepare a pro forma balance sheet for 2014. How much additional debt wil the company need using this profoma balance sheet? Complete the pro-toma balance sheet for 2014 below (Round to the nearest dotar) National Beverage Company Pro Forma Balance Sheet for the Year Ending December 31, 2014 ASSETS LIABILITIES Current assets Current liabilities Cash $ Accounts payable Marketable securities $ Other current les Accounts receivable $ Total current liabilities $ Inventories 5 Long term bites Total current assets 5 Long-term debe $ Long-term assets Other long-term liabilities $ Plant, property, and equipment $ Total long-term liabilities Goodwill Total liabilities $ Intangiblesse $ OWNERS' EQUITY Total long-term assets Common stock Retained earnings Total owners' equity $ TOTAL LIABILITIES AND TOTAL ASSETS OWNERS' EQUITY $ $ $ $ Data Table $ $ 5,627.000 3.227.000 8,854.000 $ $ National Beverage Company Balance Sheet for the Year Ending December 31, 2013 ASSETS LIABILITIES Current assets Current liabilities Cash 2.430,000 Accounts payable Martable securities $ 1,663.000 Other currentes Accounts receivable $ 2.782.000 Total current liabilities Inventories $ 1.693.000ong term obite Total current asset $ 8.568,000 Long-term debe Long-term as Other long term bliss Plant, property, and equipment $ 13.692.000 Total long-term liabilities Goodwill 1411.000 Total abilities Intangible asset $ 6,473.000 OWNERS' EQUITY Total long-term assets 5 21,576,000 Common stock Retained earnings Total ownersequity TOTAL LIABILITIES AND TOTAL ASSETS $ 30.144.000 OWNERS' EQUITY $ 1,313.000 2.887 000 4,200,000 13,054.000 5 $ $ 6.365.000 10,225.000 17.090.000 5 5 30,144.000 Print Done Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment by 54.058,000 with a plant expansion The Inventories will grow by 34% accounts receivable will grow by 21%, and marketable securities will be reduced by 55% to help finance the expansion Assume al other asset accounts will remain the same and the company will use long term debt to finance the remaining expansion costs (no change in common stock or retained eamings). Using this information and the balance sheet in the popup window for National Beverage Company for 2013, prepare a proforma balance sheet for 2014. How much additional debt will the company need using this pro forma balance sheet? Complete the pro-toma balance sheet for 2014 below. (Round to the nearest dolar) National Beverage Company Pro Forma Balance Sheet for the Year Ending December 31, 2014 ASSETS LIABILITIES Current assets Current liabilities Cash $ Accounts payable Marketable scurties Other current liabilities $ Accounts receivable $ Total current abilities 5 Inventories Long-term labies Total current assets $ Long-term debe Long-term assets Other long-term liabilities $ $ Plant Goodni Data Table Totallon TOTAL A 5 5 $ 5.627 00 3.227.000 8.854.000 s National Beverage Company Balance Sheet for the Year Ending December 31, 2013 ASSETS LIABILITIES Current assets Current liabilities Cash $ 2,430,000 Accounts payable Marketable securities s 1.663.000 Other current labas Accounts receivable $ 2,782.000 Total current liabilities Inventories $ 1.693.000 Long-term bites Total current assets 5 8,568,000 Long-term debit Long-term assets Other long term liabilities Piant, property, and equipment $ 13,692.000 Total long-term liabilities Goodwill $ 1411.000 Total abilities Intangible assets $ 6,473.000 OWNERS' EQUITY Total long-term assets $ 21,876.000 Common stock Retained earnings Total owners' equity TOTAL LIABILITIES AND TOTAL ASSETS 30,144,000 OWNERS' EQUITY $ 1313.000 2.887.000 4.200.000 13.054.000 $ $ $ $ 6.365.000 10.225.000 17.090.000 $ $ 30.144,000 Print Done Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment by $4,086,000 with a plant expansion. The inventories will grow by 31%, accounts receivable will grow by 25%, and marketable securities will be reduced by 45% to help finance the expansion. Assume all other asset accounts will remain the same and the company will use long-term debt to finance the remaining expansion costs (no change in common stock or retained camnings). Using this information and the balance sheet in the popup window. for National Beverage Company for 2013, prepare a pro forma balance sheet for 2014. How much additional debt will the company need using this pro forma balance Complete the pro-forma balance sheet for 2014 below: (Round to the nearest dollar) i Data Table ASSETS Current assets National Beverage Company Balance Sheet for the Year Ending December 31, 2013 LIABILITIES Current liabilities 2,430,000 Accounts payable 1,640,000 Other current liabilities 2.720,000 Total current liabilities 1.700.000 Long-term liabilities Cash Marketable securities Accounts receivable Inventories 5,684,000 3,297,000 8,981,000 $ Print Done D Data Table PA $4 se th S Marketable securities Accounts receivable Inventories 3,297,000 8,981,000 ea $ po $ Total current assets $ 1,640,000 Other current liabilities 2.720,000 Total current liabilities 1.700.000 Long-term liabilities 8,490,000 Long-term debt Other long-term liabilities 13,620,000 Total long-term liabilities 1,469,000 Total liabilities 6,476,000 OWNERS' EQUITY $ Long-term assets Plant, property, and equipment Goodwill 1,345,000 2,804,000 4,149,000 13,130,000 $ S $ Intangible assets En Print Done Data Table . $ $ 4,149,000 13,130,000 $ $ Plant, property, and equipment Goodwill Intangible assets Total long-term assets s 13,620,000 Total long-term liabilities 1,469,000 Total liabilities 6,476,000 OWNERS' EQUITY 21,565,000 Common stock Retained earnings Total owners' equity TOTAL LIABILITIES AND $ 6,889,000 $ 10.036.000 $ 16,925,000 TOTAL ASSETS 30,055,000 OWNERS' EQUITY 30,055,000 $ $ $ $ $ GA National Beverage Company Pro Forma Balance Sheet for the Year Ending December 31, 2014 ASSETS LIABILITIES Current assets Current liabilities Cash Accounts payable Marketable securities Other current liabilities Accounts receivable $ Total current liabilities Inventories Long-term liabilities Total current assets $ Long-term debt Long-term assets Other long-term liabilities Plant, property, and equipment Total long-term liabilities Goodwill $ Total liabilities Intangible assets $ OWNERS' EQUITY Total long-term assets Common stock Retained earnings Total owners' equity TOTAL LIABILITIES AND $ $ $ $ $ $ $ TOTAL ASSETS OWNERS' EQUITY $