Question

In: Accounting

Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements...

Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below 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,000.

  2. The firm expects to pay $35,000 in cash dividends in 2020.

  3. The firm wishes to maintain a minimum cash balance of $30,000.

  4. Accounts receivable represent approximately 18% of annual sales.

  5. The firm’s ending inventory will change directly with changes in sales in 2020.

  6. A new machine costing $42,000 will be purchased in 2020. Total depreciation for 2020 will be $17,000.

  7. Accounts payable will change directly in response to changes in sales in 2020.

  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 unchanged.

  1. Prepare a pro forma income statement for the year ended December 31, 2020, using the percent-of-sales method.

  2. Prepare a pro forma balance sheet dated December 31, 2020, using the judgmental approach.

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

    Red Queen Restaurants Income Statement for the Year Ended December 31, 2019

    Sales revenue $800,000 Less: Cost of goods sold    600,000       Gross profits $200,000 Less: Operating expenses    100,000       Net profits before taxes $100,000 Less: Taxes (rate = 21%)    21,000       Net profits after taxes $ 79,000 Less: Cash dividends    20,000       To retained earnings $ 59,000

    Red Queen Restaurants Balance Sheet December 31, 2019

    Assets Liabilities and stockholders’ equity Cash $ 32,000 Accounts payable $100,000 Marketable securities 18,000 Taxes payable 20,000 Accounts receivable 150,000 Other current liabilities   5,000 Inventories    100,000      Total current liabilities $125,000      Total current assets $300,000 Long-term debt    200,000 Net fixed assets    350,000      Total liabilities $325,000      Total assets $650,000 Common stock 150,000 Retained earnings    175,000 Total liabilities and stockholders’ equity $650,000

Solutions

Expert Solution

Pro forma income statement for the year ended December 31, 2020

Particulars    Amount ($) Year ended 31stDecember,2020

Sales Revenue 900000

LESS:Cost of Goods Sold 675000

Gross Profit 225000

LESS: Operating Expenses    112500

Net Profit before Taxes 112500

LESS: Taxes paid(21%) 23625

Net Profit after Taxes    88875  

LESS: Cash Dividend 35000

Retained Earnings 53875

Pro forma Balance Sheet dated December 31, 2020

ASSETS AMOUNT ($)    LIABILITIES & EQUITY   AMOUNT($)

Cash    30000   Accounts Payable 112500

Marketable Securities   18000   Taxes Payable 5906

Accounts Receivable 162000 Other Current Liabilities 5000

Inventories 112500       Total Current Liabilities 123406

Total Current Assets 322500    Long Term Debt 200000

Net Fixed Assets 375000 Common Stock 150000

Total Fixed Assets 697500 Retained Earnings    228875

Temporary Investment Required 4781    

TOTAL 702281 TOTAL 702281

  


Related Solutions

Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements...
Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below to prepare the financial plans. The following financial data are also available: The firm has estimated that its sales for 2020 will be $900,000. The firm expects to pay $35,000 in cash dividends in 2020. The firm wishes to maintain a minimum cash balance of $30,000. Accounts receivable represent approximately 18% of annual sales. The firm’s ending inventory...
P4-20: Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial...
P4-20: Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below to prepare the financial plans. The following financial data are also available: The firm has estimated that its sales for 2020 will be $900,000. The firm expects to pay $35,000 in cash dividends in 2020. The firm wishes to maintain a minimum cash balance of $30,000. Accounts receivable represent approximately 18% of annual sales. The firm’s ending...
Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information...
Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below to prepare the financial plans. Red Queen Restaurants Income Statement for the Year Ended December 31, 2019   Sales revenue    $799,000 Less: Cost of goods sold   599,000 Gross profits    $200,000 Less: Operating expenses   101,000 Net profits before taxes    $99,000 Less: Taxes (21%)   20,790 Net profits after taxes    $78,210 Less: Cash dividends   20,500 To retained earnings    $57,710       Red...
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in...
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in this case are budgeted statements for 2018 based on the new location scenario at the bottom of the page) Pro Forma Income Statement Pro Forma Balance Sheet PEYTON APPROVED PRO FORMA INFORMATION The company is planning to open another location in 2018 . Prepare pro forma financials for 2018 for the new location using the following information: 1. Cost of leasing commercial space: $1,500...
A. What do pro forma financial statements show? B. What are pro forma financial statements based...
A. What do pro forma financial statements show? B. What are pro forma financial statements based on? C. What are the strategic benefits of making financial projections on pro forma statements?
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
Use the pro forma financial statements to answer the questions below. Change the assumptions in the...
Use the pro forma financial statements to answer the questions below. Change the assumptions in the assumptions box as needed to answer the questions. In addition to the assumptions listed on the spreadsheet, also assume that all asset accounts will grow at the same rate as sales and that no new equity will be issued in 2018. 1. Enter a formula for external funding required in the first green box. How much external financing does Ottawa need in 2018? 2....
Discuss the differences between GAAP financial statements and pro forma statements?
Discuss the differences between GAAP financial statements and pro forma statements?
How do you prepare pro-forma financial statements and describe their relationship to the master budget components?
How do you prepare pro-forma financial statements and describe their relationship to the master budget components?
Ottawa Corporation Instructions: Financial Statements, 2013 and Projected 2014 ($ millions) Use the pro forma financial...
Ottawa Corporation Instructions: Financial Statements, 2013 and Projected 2014 ($ millions) Use the pro forma financial statements to answer the questions below. Change the assumptions in the assumptions box as needed to answer the questions. In addition to the assumptions listed on the spreadsheet, also assume that all asset accounts will grow at the same rate as sales, and that no new equity will be issued in 2014. INCOME STATEMENT BALANCE SHEET Questions: Actual Projected Actual Projected a. Enter a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT