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 will change directly with changes in sales in 2020.
A new machine costing $42,000 will be purchased in 2020. Total depreciation for 2020 will be $17,000.
Accounts payable will change directly in response to changes in sales in 2020.
Taxes payable will equal one-fourth of the tax liability on the pro forma income statement.
Marketable securities, other current liabilities, long-term debt, and common stock will remain unchanged.
Prepare a pro forma income statement for the year ended December 31, 2020, using the percent-of-sales method.
Prepare a pro forma balance sheet dated December 31, 2020, using the judgmental approach.
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,000Red 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,000In: Accounting
Vandals Company has not yet prepared a formal statement of cash flows for the 2020 fiscal year. Comparative balance sheets as of December 31, 2019, and 2020, and a statement of income and retained earnings for the year ended December 31, 2020, are presented below.
|
Vandals Company |
||||||
|
Statement of Income and Retained Earnings |
||||||
|
For The Year Ended December 31, 2020 |
||||||
|
($000 Omitted) |
||||||
|
Sales |
$4,250,000 |
|||||
|
Expenses |
||||||
|
Cost of goods sold |
$765,000 |
|||||
|
Bad debt expense |
$21,250 |
|||||
|
Salaries and benefits |
510,000 |
|||||
|
Heat, light, and power |
255,000 |
|||||
|
Depreciation |
8,925 |
|||||
|
Property taxes |
127,500 |
|||||
|
Patent amortization |
1,275 |
|||||
|
Miscellaneous expenses |
116,688 |
|||||
|
Interest |
77,792 |
|||||
|
Total expenses |
1,883,430 |
|||||
|
Income before income taxes |
2,366,570 |
|||||
|
Income taxes |
637,500 |
|||||
|
Net income |
1,729,070 |
|||||
|
Retained earnings - January 1, 2020 |
318,750 |
|||||
|
2,047,820 |
||||||
|
Cash dividend declared and issued |
12,750 |
|||||
|
Retained earnings - December 31, 2020 |
$2,035,070 |
|||||
|
Vandals Company |
||||||
|
Comparative Balance Sheet |
||||||
|
December 31 |
||||||
|
($000 Omitted) |
||||||
|
Assets |
2020 |
2019 |
||||
|
Current assets |
||||||
|
Cash |
$1,782,960 |
$118,575 |
||||
|
U.S. Treasury notes (Available-for-sale) |
17,000 |
85,000 |
||||
|
Accounts receivable |
221,850 |
136,000 |
||||
|
Allowance for doubtful account |
(12,325) |
(12,750) |
||||
|
Inventory |
23,800 |
29,750 |
||||
|
Total current assets |
2,033,285 |
356,575 |
||||
|
Long-term assets |
||||||
|
Land |
19,125 |
4,250 |
||||
|
Buildings and equipment |
51,000 |
21,250 |
||||
|
Accumulated depreciation |
(21,675) |
(12,750) |
||||
|
Patents (less amortization) |
7,225 |
8,500 |
||||
|
Total long-term assets |
55,675 |
21,250 |
||||
|
Total assets |
$2,088,960 |
$377,825 |
||||
|
Liabilities and Stockholders' Equity |
||||||
|
Current liabilities |
||||||
|
Accounts payable |
$20,400 |
$25,500 |
||||
|
Income taxes payable |
4,080 |
5,100 |
||||
|
Short-term Notes payable |
10,625 |
10,625 |
||||
|
Total current liabilities |
35,105 |
41,225 |
||||
|
Long-term notes payable - due 2020 |
17,000 |
17,000 |
||||
|
Total liabilities |
52,105 |
58,225 |
||||
|
Stockholders' equity |
||||||
|
Common stock outstanding |
1,785 |
850 |
||||
|
Retained earnings |
2,035,070 |
318,750 |
||||
|
Total stockholders' equity |
2,036,855 |
319,600 |
||||
|
Total liabilities and stockholders' equity |
$2,088,960 |
$377,825 |
||||
Instructions:
Prepare a statement of cash flows using the direct method. Changes in accounts receivable and in accounts payable relate to sales and cost of sales. Do not prepare a reconciliation schedule.
In: Accounting
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 Queen Restaurants Balance
Sheet December 31, 2019
Assets Liabilities and Stockholders' Equity
Cash $32,700 Accounts payable
$99,900
Marketable securities 17,800
Taxes payable 20,600
Accounts receivable 149,800
Other current liabilities
4,500
Inventories 100,400 Total current
liabilities $125,000
Total current assets $300,700
Long-term debt $199,700
Net fixed assets 349,500 Common stock
$150,500
Retained earnings $175,000
Total assets $650,200 Total liabilities and equity
$650,200
The following financial data are also available:
(1) The firm has estimated that its sales for 2020 will be $899,700.
(2) The firm expects to pay $34,400 in cash dividends in 2020.
(3) The firm wishes to maintain a minimum cash balance of $31,500.
(4) Accounts receivable represent approximately 21% of annual sales.
(5) The firm's ending inventory will change directly with changes in sales 2020.
(6) A new machine costing $43,100will be purchased in 2020.Total depreciation for 2020 will be $15,800.
(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.
Questions:
a. Prepare a pro forma income statement for the year ended December 31, 2020, using the percent-of-sales method.
b. Prepare a pro forma balance sheet dated December 31, 2020, using the judgmental approach.
c. Analyze these statements, and discuss the resulting external financing required.
In: Finance
On March 1 the spot price of a commodity is $20.00 and the July futures price is $18.75. On June 1 the spot price is $24.10 and the July futures price is $23.50. A company entered into a futures contracts on March 1 to hedge the purchase of the commodity on June 1. It closed out its position on June 1. What is the effective price paid by the company for the commodity?
In: Finance
On March 1, the price of a commodity is $1,000, and the December futures price is $1,015. On November 1, the price of commodity is $980, and the December futures price is $981. A producer of the commodity entered into a December futures contracts on March 1 to hedge the sale of the commodity on November 1. The producer closed out its position on November 1. The hedging futures makes_____.
loss
gain
In: Finance
The market price for Microsoft Corporation closed at $55.48 and $46.45 on December 31, current year, and previous year, respectively. The dividends per share were $1.24 for current year and $1.12 for previous year.
a. Determine the dividend yield for Microsoft on December 31, current year, and previous year. Round percentages to two decimal places.
b. Interpret these measures
In: Accounting
Consider the mathematical system with the single element {1} under the operation of multiplication. Answer and explain the following:
a) Is the system closed?
b) Does the system have an identity element?
c) Does 1 have an inverse?
d) Does the associative property hold?
e) Does the commutative property hold?
f) Is {1} under the operation of multiplication a commutative group?
In: Advanced Math
Compare the impact of an increase in the government's budget deficit on national saving, interest rate and investment spending in two cases: a small open economy and a closed economy. The two economies are otherwise comparable. Assume prices are flexible and that factors of production are fully employed in both economies. Assume there is perfect capital mobility for the small open economy. (125 words maximum)
In: Economics
In 1979, the Federal Reserve Board sought to lower inflation in the U.S. through a contractionary monetary policy. GDP fell much more severely than expected, as did the rate of inflation. Why would the open-economy IS/LM/BP model do a better job of explaining the depth of the recession and the rapid decline in inflation than the closed economy IS/LM model?
In: Economics
Which of the following is false?
A. closed primaries allow independents to participate in the party's primary of their choosing
B. open primaries allow independents to participate in the party's primary of their choosing.
C. the goal of the primary is to reduce the number of candidates running in the general election.
D. some states use the caucus method to determine which candidate the state parties will support in the primary.
In: Economics