If the following projections have been made, what is the projected ending cash balance?
Cash sales, $380,000
Beginning cash balance, $30,000
Operating expenses of $420,000, including depreciation of $20,000
Interest expense of $12,000 is included in operating expenses
Borrowing $50,000
End-of-period accrued liabilities of $20,000 for operating expenses
a. $80,000
b. $40,000
c. $52,000
d. $48,000
Ending cash balance = Beginning cash Balance + cash sales + borrowing - operating expenses paid
= $30000 +380000+50000-(420000-20000-20000)
= $80000
Option a. is correct answer.
If the following projections have been made, what is the projected ending cash balance? Cash sales,...
The independent cases are listed below includes all balance sheet accounts related to operating activities: Net income Depreciation expense Accounts receivable increase (decrease) Inventory increase (decrease) Accounts payable increase (decrease) Accrued liabilities increase (decrease) Case A $310, 689 40,000 100,000 (50,000) (50,000) 60,000 Case B $ 15,000 150,000 (200,000) 35,000 120, (220,000) Case C $420,000 80,000 (20,000) 50,000 70,000 (40,000) Show the operating activities section of cash flows for each of the given cases. (Amounts to minus sign.) Case A...
Calculate the Quick Ratio for this
year
PETE'S POTATO & PASTA, INC. BALANCE SHEET ENDING DECEMBER 31st ASSETS This year Last year $ 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 machinery Less depreciation Land Intangible Assets TOTAL ASSETS 20,000 -12,000 8,000 2,000 88,000 20,000 -10,000 8,000 1,500 79,500 LIABILITIES and SHAREHOLDERS' EQUITY $ Liabilities Accounts payable Taxes payable Long-term bonds issued TOTAL...
Calculate Working Capital for last
year
PETE'S POTATO & PASTA, INC. BALANCE SHEET ENDING DECEMBER 31st ASSETS This year Last year $ 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 machinery Less depreciation Land Intangible Assets TOTAL ASSETS 20,000 -12,000 8,000 2,000 88,000 20,000 -10,000 8,000 1,500 79,500 LIABILITIES and SHAREHOLDERS' EQUITY $ Liabilities Accounts payable Taxes payable Long-term bonds issued TOTAL LIABILITIES...
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...
Smith Company has budgeted activity for December using the following data: Cash sales $25,000 Credit sales (60% collected in month of sale) 380,000 Selling and administrative costs (including depreciation) 50,000 Depreciation expense 5,000 Merchandise Inventory, December 1 21,000 Merchandise Inventory, December 31 20,000 Beginning cash balance 3,000 Minimum cash balance required 2,500 Cost of goods sold is 55% of Cooper’s selling price All purchases are paid in cash Selling and administrative costs are paid in month of purchase Prepare a...
Greasy Spoon Restaurant - Case 1 Greasy Spoon Restaurant Balance Sheet ASSETS 2017 2016 Cash Marketable Securities Accts. Rec. Inventories Total Current Assets $12,000 66,000 152,000 191,000 $421.000 $31,000 82,000 104,000 145,000 $362,000 Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets $195,000 63,000 $132,000 $180,000 52,000 $128,000 Total Assets $553,000 $490,000 Liabilities and Equity A/P Notes Payable Accruals Total Current Liabilities $136,000 200,000 27,000 $363,000 $126,000 190,000 25,000 $341,000 Long Term debt 38,000 40,000 $381,000 Total Liabilities $401,000 Equity...
You have the following information on your 2021 outdoor public swimming pool operation: Projected Cash Balance on May 31: $ 10,000 Projected sales (all collected in cash): June July August $ 45,000 $ 50,000 $ 55,000 Projected operating expenses: all paid in month following the month indicated: May $ 42,000 June $ 30,000 July $ 35,000 August $ 10,000 Additional monthly operating expenses: Depreciation $ 6,000 Planned locker room reconstruction (will pay cash): July $ 55,000 You have a policy...
2. Ricardo Martinez has prepared the following financial statement projections as part of his business plan for starting the Martinez Products Corporation. The venture is to manufacture and sell electronic components that make standard overhead projectors "smart" by allowing them to operate through voice command. Below are Martinez Products projected financial statements: Martinez Products Corporation Projected income statement for year $200,000 Sales COGS -100,000 Operating expense Depreciation Interest expense -75,000 -4,000 -1000 20,000 -5,000 EBIT Тахes (25%) Net income 15,000...
Prepare Statement of cash flows for current year using indirect
method.
Dynamic Drones Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, Net Merchandise Inventory Prepaid Rent Total Current Assets $60,000 $140,000 $110,000 $20,000 $330,000 $80,000 $100,000 $70,000 $10,000 $260,000 Property, plant, and Equipment: Equipment $400,000 Less: Accumulated Depreciation - Equipment ($60,000) Total Property, Plant, and Equipment $340,000 Total Assets $670,000 $191,000 ($42,400) $148,600 $408,600 2019 2018 Liabilities and Stockholders' Equity Current Liabilities:...
14. What is company's margin of safety in units for projected Year 16? 15. What is the company's margin of safety as a percentage for projected Year 16? not for the projected Year 16 relative to Year 15 and 16. Is the margin of safety as a percentage improving or by how much? Eoxtrot Manufacturing Company, LLC Functional Format Income Statement Latest Operating Year Proforma for Year Year 15 15% Next Operating 16% ear 16 a units sold Average price...