Sown below are the totals from period budgets of Terrell corporation for the current year:
Revenue budget $100,000
Materials usage from production budget $15,000
Labor Cost Budget $20,000
Manufacturing overhead budget $20,000
General and Administrative budget $30,000
Capital expenditure budget $20,000
Work in process inventories:
Beginning of year $10,000
End of Year $5,000
Finished Goods inventory:
Beginning of year $15,000
End of Year $10,000
Tax Rate 40%
Required: Prepare a forecasted after tax Income Statement for the current year, be sure to show gross margin (GM), and profit before tax (PBT) and profit after tax (PAT).
|
Terrell Corporation Budgeted/ Comparative Income Statement |
||
| $ | ||
| Budgeted Sales Revenue | 100,000 | |
| Less : Budgeted Cost of Goods Sold | Note 1. | 65,000 |
| Gross Margin | 35,000 | |
| Budgeted Selling and Adminitration Expenses | ||
| General and Administrative budgeted | 30,000 | |
| Budgeted Profit before Tax (PBT) | 5,000 | |
| Tax @40% | 15000*40% | 2,000 |
| Budgeted Profit after Tax (PAT) | 3,000 |
Working Note
1) Statement of Budgeted Cost of Goods Sold
| $ | $ | |
| Material used in Production | 15000 | |
| Direct Labour Cost | 20000 | |
| Manufacturing overhead | 20000 | |
| Total Manufacturng Cost | 55000 | |
| Add : Beginning Work in Process Inventory | 10000 | |
| Less : Ending Work in Process Inventory | (5000) | |
| Cost of Goods Manufactured | 60000 | |
| Add: Beginning Finished Goods Inventories | 15000 | |
| Less :Ending Finished Goods Inventories | (10000) | |
| Budgeted Cost of Goods Sold | 65000 |
2. Capital Expenditure are not directly charge to the Income statement , Capital expenditure are the expenditure with future Benefit , and if incurre for purchase of Depreciable assets , then it amortised over the life of assets to Income statement by way of Depreciation . As nothing is Provided in Question relating to life or Depreciation . Assume capital expenditure is for non depreciable assets , hence no treatment will be given in Income Statement for capital Expenditure .
3. Selling and Administrative expenses are the after production expenses , and a Period cost , hence it does not include in Cost of Goods sold , but directly charge to Income Statement as Selling and Adminstrative expenses.
Sown below are the totals from period budgets of Terrell corporation for the current year: Revenue...
- - - - Eboyta Corporation reported the following results for the current year: Revenue Beginning inventory, Direct Materials Ending inventory, Direct Materials Purchases - Direct Materials Direct Labor Manufacturing Equipment Depreciation Plant Utilities Plant Equipment Maintenance Marketing Customer Service Beginning Work in Process Ending Work-in-Process Beginning Finished Goods Ending Finished Goods $950,000 15,000 20,000 325,000 100,000 80.000 15,000 35,000 84,000 22,000 25,000 30,000 70,000 55,000 Based on the data in the table above, Cost of Goods Sold equals: Multiple...
Calculate the:
1. Sales revenue budget
2. Production budget
3. Direct materials usage and purchases budget
4. Direct labour budget
5. Manufacturing overhead budget
6. Ending inventories budget
7. Cost of goods sold budget
8. Support department budget
9. Budgeted income statement
Budgets & Budgetory Controls The management accountant for Wow Wheels, a manufacturer of sports bikes, is in the midst of...
11 What is the impact on cash flow from operations in the current year based on the change in operating assets and liabilities listed below? 2 Balance sheets Prior Year Current Year 4 5 Accounts receivable 6 Inventories 7 Accounts payable 1,725 1,535 1,325 1,825 1,785 1,475 -200 -150 200 12 What's the forecasted capital expenditure based on the information below? Net PP&E beginning of period: 15,000 Net PP&E end of period: 17,500 Depreciation expenses: 2,400 2,500 4,900 100 -100...
Did the Current Ratio increase or decrease from
last year to this year?
PETE'S POTATO & PASTA, INC BALANCE SHEET ENDING DECEMBER 31st This year Last year ASSETS Current assets Cash and cash equivalents Accounts receivable Inventory Total current assets 10,000 35,000 25,000 70,000 10,000 30,000 20,000 60,000 Fixed assets Plants and mach inery Less depreciation 20,000 -12,000 -10,000 8,000 2,000 88,000 20,000 Land 8,000 1,500 Intangible Assets TOTAL ASSETS 79,500 LIABILITIES and SHAREHOLDERS' EQUITY Liabilities 20,000 15,500 Accounts payable...
The Dawson Company has just completed a number of budgets for the coming year. The cost of goods manufactured schedule, the pro forma income statement, and the balance sheet still have to be completed. The following information is available as 12/31/X8. Prior Year Balance Sheet Assets Cash $45,000 Accounts Receivable $55,000 Materials Inventory $40,000 Work-in-Process Inventory $30,000 Finished Goods Inventory $36,000 Prepaid Expenses $20,000 Plant and Equipment $500,000 Accumulated Depreciation ($140,000) Other Assets $22,000 Total Assets $608,000 Liabilities and Equity...
Plough Company reported net income of $180,000 for the current year. Depreciation recorded on buildings and equipment amounted to $80,000 for the year. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $20,000 $15,000 Accounts receivable 24,000 32,000 Inventories 50,000 65,000 Prepaid expenses 9,500 5,000 Accounts payable 12,000 18,000 Income taxes payable 1,600 1,200 Instructions Prepare the cash flows from the operating...
Hamza Corporation reported the following results for the current year: Revenue Beginning inventory, Direct Materials Ending inventory, Direct Materials Purchases - Direct Materials Direct Labor Manufacturing Equipment Depreciation Plant Utilities Indirect Plant Labor Marketing Customer Service Beginning Work-in Process Ending Work-in-Process Beginning Finished Goods Ending Finished Goods $800,000 35,000 20,000 175.000 225,000 90,000 50,000 60,000 30,000 40,000 80,000 85,000 90,000 75,000 Based on the data above, Cost of Goods Sold equals:
he McCumber Corporation data for the current year: Account Current year Prior year Current assets $76,200 $60,000 A/R $59,400 $44,000 Mdse. Inventory $51,200 $40,000 Current liabilities $82,500 $55,000 Long-term liabilities $38,000 $30,000 Common stock (5,000 shares) $47,880 $42,000 Retained earnings $18,420 $17,000 Net sales revenue $618,000 $515,000 COGS $478,140 $385,000 Gross Profit $139,860 $130,000 Selling/General expenses $47,860 $50,000 Net income before taxes $92,000 $80,000 Income tax expense $23,000 $20,000 Net Income $69,000 $60,000 With respect to net income before income...
For the current year, Klay Corporation reports the following information: Net cash inflows from investing activities: $ 40,000 Net cash inflows from financing activities: $ 45,000 Cash at the beginning of the year: $ 340,000 Cash at the end of the year: $ 420,000 What was the company’s cash flows from operating activities? A cash inflow of $5,000 A cash inflow of $15,000 A cash outflow of $5,000 A cash outflow of $15,000
The following December 31, 2018, fiscal year-end account balance information is available for the Stonebridge Corporation: Cash and cash equivalents Accounts receivable (net) Inventories Property, plant, and equipment (net) Accounts payable Wages payable Paid-in-capital $ 5,000 20,000 60,000 120,000 44,000 15,000 100,000 The only asset not listed is short-term investments. The only liabilities not listed are a $30,000 note payable due in two years and related accrued interest of $1,000 due in four months. The current ratio at year-end is...