Panther Corporation appeared to be experiencing a good year. Sales in the first quarter were one-third ahead of last year, and the sales department predicted that this rate would continue throughout the entire year. The controller asked Janet Nomura, a summer accounting intern, to prepare a draft forecast for the year and to analyze the differences from last year's results. She based the forecast on actual results obtained in the first quarter plus the expected costs of production to be completed in the remainder of the year. She worked with various department heads (production, sales, and so on) to get the necessary information. The results of these efforts follow:
PANTHER CORPORATION Expected Account Balances for December 31, Year 2 |
|||||
Cash | $ | 4,800 | |||
Accounts receivable | 320,000 | ||||
Inventory (January 1, Year 2) | 192,000 | ||||
Plant and equipment | 520,000 | ||||
Accumulated depreciation | $ | 164,000 | |||
Accounts payable | 180,000 | ||||
Notes payable (due within one year) | 200,000 | ||||
Accrued payables | 93,000 | ||||
Common stock | 280,000 | ||||
Retained earnings | 432,800 | ||||
Sales revenue | 2,400,000 | ||||
Other income | 36,000 | ||||
Manufacturing costs | |||||
Materials | 852,000 | ||||
Direct labor | 872,000 | ||||
Variable overhead | 520,000 | ||||
Depreciation | 20,000 | ||||
Other fixed overhead | 31,000 | ||||
Marketing | |||||
Commissions | 80,000 | ||||
Salaries | 64,000 | ||||
Promotion and advertising | 180,000 | ||||
Administrative | |||||
Salaries | 64,000 | ||||
Travel | 10,000 | ||||
Office costs | 36,000 | ||||
Income taxes | — | ||||
Dividends | 20,000 | ||||
$ | 3,785,800 | $ | 3,785,800 | ||
Adjustments for the change in inventory and for income taxes have not been made. The scheduled production for this year is 450,000 units, and planned sales volume is 400,000 units. Sales and production volume was 300,000 units last year. The company uses a full-absorption costing and FIFO inventory system and is subject to a 40 percent income tax rate. The actual income statement for last year follows:
PANTHER CORPORATION Statement of Income and Retained Earnings For the Budget Year Ended December 31, Year 1 |
||||||||
Revenues | ||||||||
Sales revenue | $ | 1,800,000 | ||||||
Other income | 60,000 | $ | 1,860,000 | |||||
Expenses | ||||||||
Cost of goods sold | ||||||||
Materials | $ | 528,000 | ||||||
Direct labor | 540,000 | |||||||
Variable overhead | 324,000 | |||||||
Fixed overhead | 48,000 | |||||||
$ | 1,440,000 | |||||||
Beginning inventory | 192,000 | |||||||
$ | 1,632,000 | |||||||
Ending inventory | 192,000 | $ | 1,440,000 | |||||
Selling | ||||||||
Salaries | $ | 54,000 | ||||||
Commissions | 60,000 | |||||||
Promotion and advertising | 126,000 | 240,000 | ||||||
General and administrative | ||||||||
Salaries | $ | 56,000 | ||||||
Travel | 8,000 | |||||||
Office costs | 32,000 | 96,000 | ||||||
Income taxes | 33,600 | 1,809,600 | ||||||
Operating profit | 50,400 | |||||||
Beginning retained earnings | 402,400 | |||||||
Subtotal | $ | 452,800 | ||||||
Less dividends | 20,000 | |||||||
Ending retained earnings | $ | 432,800 | ||||||
Required:
Prepared a budgeted income statement and balance sheet. (Do not round intermediate calculations.)
calculations.)
(Enter all the values as positive value.)
Panther Corporation appeared to be experiencing a good year. Sales in the first quarter were one-third...
Q NA G 13-62. Comprehensive Budget Plan ( LO 13-4, 5, Q. excel Panther Corporation appeared to be experiencing a good year. Sales in the first quarter were one-third ahead of last year, and the sales department predicted that this rate would continue throughout the entire year. The controller asked Janet Nomura, a summer accounting intern, to prepare a draft forecast for the year and to analyze the differences from last year's results. She based the forecast on actual results...
Panther Corporation appeared to be experiencing a good vear. Sales in the first quarter were one-third ahead of last year, and the sales department predicted that this rate would continue throughout the entire year. The controller asked Janet Nomura, a sumener accounting intern, ta prepare a draft forecast for the year and to analyze the differences from last year's results. She based the forecast on actual results obtained in the first quarter plus the expected costs af production to be...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 $1,495.0 $1,300.0 1121.0 1105.0 $374.0$%195.0 42.0 33.0 $332.0 $162.0 33.0 29.0 $299.0 $133.0 119.6 53.2 $179.4$79.8 2016 Sales Operating costs excluding depreciation and amortization EBITDA Depreciation and amortization Earnings before interest and taxes (EBIT) Interest Earnings before taxes (EBT Taxes (40%) Net income Common dividends $161.0 $64.0 Powell Panther Corporation: Balance Sheets as of December 31 (Millions...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 2,990.0 $ 2,600.0 Operating costs excluding depreciation and amortization 2,243.0 2,210.0 EBITDA $ 747.0 $ 390.0 Depreciation and amortization 80.0 73.0 Earnings before interest and taxes (EBIT) $ 667.0 $ 317.0 Interest 65.8 57.2 Earnings before taxes (EBT) $ 601.2 $ 259.8 Taxes (25%) 240.5 103.9 Net income $ 360.7 $ 155.9 Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) Sales Operating costs excluding depreciation and amortization EBITDA Depreciation and amortization Earnings before interest and taxes (EBIT) Interest Earnings before taxes (EBT) Taxes (40%) Net income 2018 $1,560.0 1.170.0 $ 390.0 32.0 $ 358.0 34.0 $ 324.0 129.6 2017 $1,300.0 1.105.0 $ 195.0 29.0 $ 166.0 29.0 $ 137.0 54.8 $ 194.4 82.2 Common dividends $ 175.0 Powell...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $1,920.0 $1,600.0 Operating costs excluding depreciation and amortization 1,440.0 1,360.0 EBITDA $ 480.0 $ 240.0 Depreciation and amortization 56.0 46.0 Earnings before interest and taxes (EBIT) $ 424.0 $ 194.0 Interest 42.0 35.0 Earnings before taxes (EBT) $ 382.0 $ 159.0 Taxes (40%) 152.8 63.6 Net income $ 229.2 $ 95.4 Common dividends $ 206.0...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) Sales Operating costs excluding depreciation and amortization EBITDA Depreciation and amortization Earnings before interest and taxes (EBIT) Interest Earnings before taxes (EBT) Taxes (259) Net income Common dividends 2019 2018 $3,240.0 $2,700.0 2.592.0 2.295.0 $ 648.0 $ 405.0 71.0 62.0 $ 577.0 $ 343.0 213 59.4 $ 505.7 $ 283.6 2023 113.4 $ 303.4 $ 170.2 $ 273.1...
3-17 FREE CASH FLOW Financial information for Powell Panther Corporation is shown here. Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $ 1,200.0 $1,000,0 Operating costs excluding depreciation and amortization 1,020.0 850.0 EBITDA $ 180.0 $ 150.0 Depreciation and amortization 30.0 25.0 Earnings before interest and taxes (EBIT) $ 150.0 $ 125,0 Interest 21.7 20.2 Earnings before taxes (EBT) $ 1283 $ 104.8 Taxes (40%) 51.3 41.9 Net income $ 77.0 $...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 $3,375.0 $2,700.0 2.616.0 2.295.0 $759.0 $405.0 Sales EBITDA $688.0 $346.0 24.0 59.0 $614.0 $287.0 245.6 114.8 $368.4 $172.2 Earnings before interest and taxes (EBIT) Interest Earnings before taxes (EBT) Taxes (40%) Net income Common dividends $332.0 $138.0 Powell Panther Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash and equivalents Accounts...
FREE CASH FLOW Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $1,560.0 $1,200.0 Operating costs excluding depreciation and amortization 1,209.0 1,020.0 EBITDA $351.0 $180.0 Depreciation and amortization 29.0 25.0 Earnings before interest and taxes (EBIT) $322.0 $155.0 Interest 34.0 26.0 Earnings before taxes (EBT) $288.0 $129.0 Taxes (40%) 115.2 51.6 Net income $172.8 $77.4 Common dividends $156.0 $62.0 Powell Panther Corporation: Balance Sheets...