Ans.
Pro Forma Income Statement | ||
Red Queens Restaurants | ||
For the Year Ended December 31, 2020 | ||
(percent-of-sales method) | ||
Sales revenue | $ 900,100.00 | |
Less: Cost of goods sold | $ 673,726.20 | 74.8501% |
Gross profit | $ 226,373.80 | |
Less: Operating expenses | $ 112,737.30 | 12.5250% |
Net Profits before taxes | $ 113,636.50 | |
Less: taxes (rate= 40%) | $ 45,454.60 | |
Net profits after taxes | $ 68,181.90 | |
Less: Cash dividends | $ 34,000.00 | |
To retained earnings | $ 34,181.90 |
Pro Forma Balance Sheet | |||
Red Queen Restaurants | |||
December 31,2020 | |||
(Judgmental Method) | |||
Assets | Liabilities and Stockholders' equity | ||
Cash | $ 31,700.00 | Accounts payable | $ 112,849.60 |
Marketable securities | $ 17,200.00 | Taxes payable | $ 11,363.65 |
Accounts receivable | $ 216,024.00 | Other current liabilities | $ 5,800.00 |
Inventories | $ 112,062.80 | Total current liabilities | $ 130,013.25 |
Total current assets | $ 376,986.80 | Long-term debt | $ 198,900.00 |
Net fixed assets | $ 377,300.00 | Total liabilities | $ 328,913.25 |
Common stocks | $ 149,200.00 | ||
Retained earnings | $ 209,181.90 | ||
External Funds Required | $ 66,991.65 | ||
Total assets | $ 754,286.80 | Total Liabilities and equity | $ 754,286.80 |
i need all the blanks in both pictures please. thank you! Integrative-Pro forma statements Red Queen...
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 2020 will be $900,400. (2) The firm expects to pay $35,300 in cash dividends in 2020. (3) The firm wishes to maintain a minimum cash balance of $31,800. (4) Accounts receivable represent approximately 19% of annual sales. Data...
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 $900,300 (2) The firm expects to pay $35,900 in cash dividends in 2016 (3) The firm wishes to maintain a minimum cash balance of $30,500 (4) Accounts receivable represent approximately 24% of annual sales (5)...
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 2020 will be $900,600. (2) The firm expects to pay $35,600 in cash dividends in 2020. (3) The firm wishes to maintain a minimum cash balance of $30,000. (4) Accounts receivable represent approximately 21% of annual sales. (5) The firm's ending...
b. Discuss the financing changes suggested by the statement pre Integrative: Pro form cial plans. Use the financial statements and prepare the financial plans. P4-20 a statements Red Queen Restaurants wishes to prepare finan the other information provided below to The following financial data are also available: (1) The firm has estimated that its sales for 2020 will be $900,000. (2) The firm expects to pay $35,000 in cash dividends in 2020. (3) The firm wishes to maintain a minimum...
Pro forma balance sheet-Basic Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2020. The firm expects 2020 sales to total $3,000,000. The following information has been gathered (1) A minimum cash balance of $49,500 is desired (2) Marketable securities are expected to remain unchanged. (3) Accounts receivable represent 10.1% of sales. (4) Inventories represent 12.1% of sales. (5) A new machine costing $90,200 will be acquired during 2020. Total depreciation for the year will be...
Can you provide step by step answers and there are two more parts to the questions b and c but I can't take picture of it until this one is done to prepare the financial plans. The Integrative Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided here following financial data are also available: (1) The firm has estimated that its sales for 2020 will be $900,900. (2) The...
Provincial Imports, Inc., has assembled past (2019) financial statements (income statement and balance sheet LOADING...) and financial projections for use in preparing financial plans for the coming year (2020). Information related to financial projections for the year 2020 is as follows: (1) Projected sales are $ 5,992,000. (2) Cost of goods sold in 2019 includes $ 1,000,000 in fixed costs. (3) Operating expense in 2019 includes $ 245,000 in fixed costs. (4) Interest expense will remain unchanged....
Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.2 million. It wishes to analyze expected performance and financing needs for 2021—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 receivable; 12.4%, Inventory; 18.4%; Accounts payable, 13.8%; Net profit margin, 3.3%. (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance...
Create two years (2020 and 2021) of pro forma income statements and balance sheets and the statement of cash flows, including operating, investing, and financing sections for 2020 only. Additional Information: The relationship between cost of goods sold and sales revenue Is expected to continue in the near term and no inflation is expected. Operating expenses include $200,000 in depreciation (fixed expense), the remainder is variable costs tied to sales revenue. Fixed assets are adequate to support sales growth for...
Pro forma balance sheet: Basic Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2020. The firm expects 2020 sales to total $3,000,000. The following information has been gathered: (1) A minimum cash balance of $50,000 is desired. (2) Marketable securities are expected to remain unchanged. (3) Accounts receivable represent 10% of sales. (4) Inventories represent 12% of sales. (5) A new machine costing $90,000 will be acquired during 2020. Total deprecia- tion for the year...