F-20

Pro forma balance sheet. Next year, National Beverage Company will increase its plant, property, and equipment by $4,023,000 with a plant expansion. The inventores will grow by 25%, accounts receivable will grow by 24%, and marketable secunties will be reduced by 60% 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 earnings). 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 sheet? Complete the pro-torma balance sheet for 2014 below (Round to the nearest dollar) National Beverage Company Pro Forma Balance Sheet for the Year Ending December 31, 2014 LIABILITIES ASSETS Current assets Current liabilities Cash Accounts payable $ Marketable securities $ Other current abilities $ $ Accounts receivable $ Total current liabilities inventories $ $ $ N Long-term liabilities Long-term debt Other long-term liabilities Total long-term liabilities Total liabilities Total current assets Long-term assets Piant, property, and equipment Goodwill $ $ $ $ 5 OWNERS' EQUITY Intangible assets Total long-term assets $ $ Common stock Retained earnings $ Total owners' equity TOTAL LIABILITIES AND OWNERS' EQUITY TOTAL ASSETS How much additional debt will be estimated using this pro forma balance sheet? (Round to the nearest dollar) $ $ $ 5,699,000 3,217,000 8,916,000 $ National Beverage Company Balance Sheet for the Year Ending December 31, 2013 ASSETS LIABILITIES Current assets Current liabilities Cash 2,413,000 Accounts payable Marketable securities $ 1,622,000 Other current liabilities Accounts receivable 2,770,000 Total current liabilities Inventories 1,650,000 Long-term liabilities Total current assets $ 8,455,000 Long-term debt Long-term assets Other long-term liabilities Plant property, and equipment 13,653,000 Total long-term liabilities Goodwill $ 1,471,000 Total liabilities Intangible assets $ 6,462,000 OWNERS' EQUITY Total long-term assets $ 21,586,000 Common stock Retained earnings $ $ 1.325,000 2,808,000 4,133,000 13,049,000 $ $ $ $ $ 6,818,000 10,174,000 16,992,000 Total owners' equity $ TOTAL LIABILITIES AND TOTAL ASSETS $ 30,041,000 OWNERS' EQUITY $ 30,041,000