Question

In: Finance

Balance Sheet at end of April Cash -60,000                 Stock 400,000 Receivables 350,000 Inventories 280,000         Retained Earni

Balance Sheet at end of April

Cash -60,000                 Stock 400,000

Receivables 350,000

Inventories 280,000         Retained Earnings 170,000

Totals 570,000                Totals 570,000

Assume the owner, Derrick, got a loan in April to cover his cash shortfall. Also assume that sales in May, June, and July remained at 7,000 units per month and that all other assumptions in the problem remain the same (stock and costs/sales costs of the units). Construct Derrick's July balance sheet.

Units are sold for $5.00

Production cost per unit is $4.00

I've seen a couple solutions to this problem, but they don't seem to add up for me. I could be wrong. None of the solutions include a new liability equaling 60,000 to offset the shortfall of -60,000.

Solutions

Expert Solution

The Balance sheet immediately after availing the loan would be:
Assets Total liabilities and equity
Cash $                 -   Loan $         60,000
Receivables $    3,50,000 Stock $      4,00,000
Inventories $    2,80,000 Retained earnings $      1,70,000
Total assets $    6,30,000 $      6,30,000
Balance sheet at the end of JULY
Assets Total liabilities and equity
Cash $        21,000 Loan $         60,000
Receivables $    3,50,000 Stock $      4,00,000
Inventories $    2,80,000 Retained earnings [170000+1*21000] $      1,91,000
Total assets $    6,51,000 $      6,51,000

Related Solutions

Balance Sheet Cash&MS- 30,000 Accruals- 20,000 Receivables- 70,000 Accounts Payable- 60,000 Inventories- 120,000 Notes Payable- 80,000...
Balance Sheet Cash&MS- 30,000 Accruals- 20,000 Receivables- 70,000 Accounts Payable- 60,000 Inventories- 120,000 Notes Payable- 80,000 Fixed Assets- 480,000 L-T Liabilities- 140,000 Total Assets= 700,000 Common Equity- 400,000 Annual Sales- 1,400,000 Cost of Goods Sold- 960,000 Net Income- 63,000 Number of Shares Outstanding- 30,000 What is the current ratio, debt ratio, total asset turnover ratio of the firm? What is the days sales outstanding (DSO) of the firm? (Use a 360-day year.) What is the profit margin of the firm?...
Rutner Rope – Balance Sheet Current Assets (Thousands) Cash 23.2 Net Receivables 109.5 Inventories 68.6 Other...
Rutner Rope – Balance Sheet Current Assets (Thousands) Cash 23.2 Net Receivables 109.5 Inventories 68.6 Other Current Assets 4.6 Total Current Assets 171 Net Fixed Assets 466.8 Other Noncurrent Assets 715.7 Total Assets 1353.5 Liabilities and Shareholders' Equity Current Liabilities Accounts Payable 58.1 Short-Term Debt 4 Other Current Liabilities 103.8 Total Current Liabilities 155.9 Long-Term Debt 849.8 Other Noncurrent Liabilities 95.5 Total Liabilities 1320.7 Revenue 2456.3 COGS 2068.4 Gross Profit 387.9 What are accounts payable in days? What are inventories...
Prepare a 2018 balance sheet for Rogers Corp. based on the following information: Cash = $280,000;...
Prepare a 2018 balance sheet for Rogers Corp. based on the following information: Cash = $280,000; Patents and copyrights = $720,000; Accounts payable = $460,000; Accounts receivable = $159,000; Tangible net fixed assets = $3,700,000; Inventory = $255,000; Notes payable = $180,000; Accumulated retained earnings = $1,345,000; Long-term debt = $1,930,000. What is the common stock account balance for the company?
Cash & M/S 30,000 Accruals 20,000 Receivables 70,000 Accounts Payable 60,000 Inventories      120,000           Notes Payable 80,000...
Cash & M/S 30,000 Accruals 20,000 Receivables 70,000 Accounts Payable 60,000 Inventories      120,000           Notes Payable 80,000 Fixed Assets 380,000 L-T Liabilities 140,000 Total Assets 600,000 Common Equity 300,000 Total 600,000 Annual Sales   = $1,200,000 Net Income     = $48,000 Cost of Goods Sold = $960,000 Number of Shares Outstanding = 30,000 What is the current ratio of the firm? What is the debt ratio of the firm? What is the total asset turnover ratio of the firm? What is the...
the balance in retained earnings at the end of the year is determined by retained earnings...
the balance in retained earnings at the end of the year is determined by retained earnings balance at the ''beginning of the year: a. plus revenues, minus liabilities b. plus net income, minus dividends c. plus assets, minus liabilities d. plus accounts, minus deferrals
Year-End Balance Sheet and Statement of Cash Flows–Indirect Method The balance sheet of Poodle Company at...
Year-End Balance Sheet and Statement of Cash Flows–Indirect Method The balance sheet of Poodle Company at the end of 2016 is presented here, along with certain other information for 2017: December 31, 2016 Cash $155,000 Accounts receivable 140,000    Total current assets $295,000 Land $100,000 Plant and equipment 700,000 Accumulated depreciation (175,000) Investments 125,000    Total long-term assets $750,000       Total assets $1,045,000 Current liabilities $325,000 Bonds payable $100,000 Common stock $500,000 Retained earnings 120,000    Total stockholders’ equity $620,000       Total liabilities and stockholders’...
Year-End Balance Sheet and Statement of Cash Flows–Indirect Method The balance sheet of Poodle Company at...
Year-End Balance Sheet and Statement of Cash Flows–Indirect Method The balance sheet of Poodle Company at the end of 2016 is presented here, along with certain other information for 2017: December 31, 2016 Cash $155,000 Accounts receivable 140,000    Total current assets $295,000 Land $100,000 Plant and equipment 700,000 Accumulated depreciation (175,000) Investments 125,000    Total long-term assets $750,000       Total assets $1,045,000 Current liabilities $325,000 Bonds payable $100,000 Common stock $500,000 Retained earnings 120,000    Total stockholders’ equity $620,000       Total liabilities and stockholders’...
A firm's year-end retained earnings balances are $350,000 and $420,000, for 2018 and 2019 respectively. The...
A firm's year-end retained earnings balances are $350,000 and $420,000, for 2018 and 2019 respectively. The firm reported net profits after taxes of $100,000 in 2019. The firm's dividend payment for 2019 is ____.         $30,000         $50,000         $0         $70,000
On January 1, 2018, Sledge had common stock of $280,000 and retained earnings of $420,000. During...
On January 1, 2018, Sledge had common stock of $280,000 and retained earnings of $420,000. During that year, Sledge reported sales of $290,000, cost of goods sold of $150,000, and operating expenses of $56,000. On January 1, 2016, Percy, Inc., acquired 70 percent of Sledge's outstanding voting stock. At that date, $76,000 of the acquisition-date fair value was assigned to unrecorded contracts (with a 20-year life) and $36,000 to an undervalued building (with a 10-year remaining life). In 2017, Sledge...
1.The balance sheet for PalletPaper, Inc. shows cash is $73,500, accounts receivable are $185,400, inventories are...
1.The balance sheet for PalletPaper, Inc. shows cash is $73,500, accounts receivable are $185,400, inventories are $447,300, fixed assets are $820,000, current liabilities are $489,450, accounts payable are $132,500, accrued payroll is $145,000 and long-term debt is $900,000? What is the current ratio for PalletPaper? A.more than 1.5 B.more than 1.46but less than 1.53 C.more than 1.39but less than1.4 D.more than 1.32 but less than 1.39 E.less than 1.32 2.Which of the following statements is correct?(x)If a firm undertakes a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT