Question

In: Accounting

Create a Balance Sheet using the following data:                 Sales   $55,000     ...

Create a Balance Sheet using the following data:
               
Sales   $55,000           Accumulated Depreciation   19,000            
Cost of good sold   32,000           Accounts Receivable    7,300           
Depreciation Expense   3,800           Accounts Payable   6,500           
Interest Expense   2,600           Short-term notes payable   2,600           
Income taxes   5,985             Marketing, general and admin expenses   4,500  

Inventories   4,700           Gross fixed assets   64,800           
Long-term debt   36,000           Common stock   12,000           

Other assets   1,500           Retained earnings   13,850  

Cash   ?               
Include two columns Percentage of Total assets and Dollar Value.              
Also firm has paid $1,500 in common stock dividends during the year and has 1000 shares outstanding .

  

Solutions

Expert Solution

Answer Submitted


Related Solutions

BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.1x Days sales outstanding: 30.5 days^a Inventory turnover ratio: 4x Fixed assets turnover: 2.5x Current ratio: 2.4x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $    Current liabilities $    Accounts receivable    Long-term debt 41,250...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3x Days sales outstanding: 37.5 daysa Inventory turnover ratio: 7x Fixed assets turnover: 3.5x Current ratio: 2.1x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 35% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $   Current liabilities $   Accounts receivable    Long-term debt 52,500...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x Days sales outstanding: 31.5 daysa Inventory turnover ratio: 7x Fixed assets turnover: 3x Current ratio: 2.2x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $    Current liabilities $    Accounts receivable    Long-term debt 56,250...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x Days sales outstanding: 34 daysa Inventory turnover ratio: 4x Fixed assets turnover: 3.5x Current ratio: 2.5x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 35% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $    Current liabilities $    Accounts receivable    Long-term debt 56,250...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.2x Days sales outstanding: 39.5 daysa Inventory turnover ratio: 4x Fixed assets turnover: 3x Current ratio: 2.5x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $   Current liabilities $   Accounts receivable    Long-term debt 50,000...
Complete the balance sheet and sales data (fill in the blanks), using the following financial data:...
Complete the balance sheet and sales data (fill in the blanks), using the following financial data: Debt/net worth 60% Acid test ratio 1.2 Asset turnover 1.5 times Day sales outstanding in accounts receivable 40 days Gross profit margin 30% Inventory turnover 6 times Balance sheet Cash ________ Accounts payable ________ Accounts receivable ________ Common stock $15,000 Inventories ________ Retained earnings $22,000 Plant & equipment ________ Total assets ________ Total liabilities ________ & capital Sales ________ Cost of goods sold ________.
Solve the following problems: Using the balance sheet below: create a balance sheet for 2016 and...
Solve the following problems: Using the balance sheet below: create a balance sheet for 2016 and 2017. make a list of working capital accounts. what is the net working capital for 2016 and 2017? What is the change in net working capital for 2017? Balance Sheet Accounts of SimpleTec Corporation Account Balance 12/31/2013 Balance 12/31/2014 Accumulated Depreciation $2,030 $2,680 Accounts Payable $1,810 $2,070 Accounts Receivable $2,490 $2,700 Cash $1,310 $1,100 Common Stock $5,000 $5,000 Inventory $5,810 $6,040 Long-Term Debt $7,810...
Create an income statement and balance sheet using the data below. Important: double the balance of...
Create an income statement and balance sheet using the data below. Important: double the balance of the Net Sales and make the necessary corrections to balance. Inputs Accounts Payable 12,000 Accounts Receivable 10,000 Accruals 10,000 Accumulated Depreciation 100,000 Beginning of year Inventory 50,000 Beginning of year Retained Earnings 120,000 Cash 7,000 Common Stock 121,500 Cost of Goods Sold 200,000 Current Portion - Long Term Debt 1,500 Depreciation Expense 25,000 Dividends 40,000 Gross Property, Plant, and Equipment 400,000 Interest Expense 15,000...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3×...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3× Days sales outstanding: 73.0 daysa Inventory turnover ratio: 5× Fixed assets turnover: 3.0× Current ratio: 2.0× Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answers to the nearest dollar. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 48,000 Inventories Common stock Fixed...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x Days sales outstanding: 36.5 daysa Inventory turnover ratio: 4x Fixed assets turnover: 3x Current ratio: 1.9x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 50,000 Inventories Common stock Fixed...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT