Integrative-Pro forma statements

Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided here to prepare the financial plans. The following financial data are also available:

(1) The firm has estimated that its sales for 2016 will be $899,300.

(2) The firm expects to pay $34,300 in cash dividends in 2016.

(3) The firm wishes to maintain a minimum cash balance of $31,000.

(4) Accounts receivable represent approximately 23% of annual sales.

(5) The firm's ending inventory will change directly with changes in sales in 2016.

(6) A new machine costing $42,200 will be purchased in 2016. Total depreciation for 2016 will be $15,100.

(7) Accounts payable will change directly in response to changes in sales in 2016.

(8) Taxes payable will equal one-fourth of the tax liability on the pro forma income statement.

(9) Marketable securities, other current liabilities, long-term debt, and common stock will remain

a. Prepare a pro forma income statement for the year ended December 31, 2016, using the percent-of-sales method. (Round to the nearest dollar. Round the percentage of sales to four decimal places.)

b. Prepare a pro forma balance sheet dated December 31, 2016, using the judgmental approach.

c. Analyze these statements, and discuss the resulting external financing required.

creen not 2018-09-25 at 3.35.48 PM Search Red Queen Restaurants Income Statement for the Year Ended December 31, 2015 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Cash dividends To retained earnings $799,600 599,400 $200,200 100,700 $99,500 39,800 $59,700 19,000 $40,700 Red Queen Balance Sheet.jpg.png Search Red Queen Restaurants Balance Sheet December 31, 2015 Assets Cash Marketable securities Accounts receivable Inventories Liabilities and Stockholders' Equity $32,500 Accounts payable $99,900 19,100 4,900 $123,900 $200,900 $149,700 $175,000 $649,500 18,000 Taxes payable 149,200 99,800 Other current liabilities Total current liabilities $299,500 Long-term debt 350,000 Common stoclk Total current assets Net fixed assets Retained earnings Total liabilities and equity Total assets $649,500