Question

In: Accounting

4) Using the balance sheet from #3, construct an income statement and balance sheet for     ...

4) Using the balance sheet from #3, construct an income statement and balance sheet for

     the first month of operation, given the following information:

   

Sales

$104,000.00

Collections

$77,000.00

Purchases (paid for half)

$60,000.00

Ending inventory

$57,000.00

Equipment Depreciation

$18,000.00

Vehicle Depreciation

$2,000.00

Heat (due next month)

$450.00

Electricity

$325.00

Telephone

$230.00

Advertising

$1,200.00

Salaries

$15,500.00

Payroll Tax Expense

$1,700.00

Office Supplies

$200.00

Insurance (due next month)

$1,250.00

Loan payment

$3,500.00

    principal

$1,500.00

    interest

$2,000.00

Legal fees (due next month)

$500.00

Accounting

$250.00

Vehicle Expense

$700.00

Repairs & Maintenance

$1,500.00

Owner Draw

$3,000.00

Solutions

Expert Solution

Income Statement for the Month End

Revenues

104000

Total Revenue

104000

Purchases

60000

Electricity

325

Telephone

230

Advertising

1200

Salaries

15500

Office Supplies

200

Loan Payment

3500

Accounting

250

Vehicle Expense

700

Repairs & Maintenance

1500

Owner Drawing

3000

Depreciation

20000

Total Expenses

106405

Earnings Before Tax

-2405

Tax

1700

Net Loss

-4105

Balance Sheet at the Month End

Assets

Cash

16695

Short Term Receivable

27000

Inventories

57000

Prepaid Expenses

2200

Total Assets

102895

Liabilities

Short Term Debt

30000

Total Liabilities

30000

Equity

Common Stock

80000

Owners Draw

-3000

Retained earnings (Loss)

-4105

Total Equity

72895


Related Solutions

From the following information, construct a simple income statement and a balance sheet: Sales $900,000 Finished...
From the following information, construct a simple income statement and a balance sheet: Sales $900,000 Finished goods 190,000 Long-term debt 400,000 Raw materials 140,000 Cash 75,000 Cost of goods sold 480,000 Accounts receivable 170,000 Plant and equipment 490,000 Interest expense 50,000 Number of shares outstanding 110,000 Earnings before taxes 240,000 Taxes 100,000 Accounts payable 200,000 Other current liabilities 40,000 Other expenses 130,000 Equity 425,000 Round your answer for earnings per share to the nearest cent. Corporation X: Income Statement for...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 443555 Operating Costs 326133 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 54355 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 64355 Prepare an income statement and a balance sheet for is company using the information provided. Calculate: 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 499891 Operating Costs 359935 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 59989 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 69989 6. Interest coverage 7. Net profit margin 8. Sales to total assets (Asset turnover) 9. Return on assets 10. Equity multiplier 11. Return on equity
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct a cash flow statement for the year ended Dec 31, 2008. Note that this company has also paid dividends on the common stock, but you need to find out how much by yourself. Hint: take a look at retained earnings. The company had no preferred stock (50% of exam grade) BALANCE SHEET ASSETS 2007 2008 Cash 45,000 50,000 Marketable Securities 275,000 160,000 Accounts Receivable...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct a cash flow statement for the year ended Dec 31, 2008. Note that this company has also paid dividends on the common stock, but you need to find out how much by yourself. Hint: take a look at retained earnings. The company had no preferred stock (50% of exam grade) BALANCE SHEET ASSETS 2007 2008 Cash 45,000 50,000 Marketable Securities 275,000 160,000 Accounts Receivable...
construct an income statement and balance sheet for      the first month of operation, given the...
construct an income statement and balance sheet for      the first month of operation, given the following information:     Sales $104,000.00 Collections $77,000.00 Purchases (paid for half) $60,000.00 Ending inventory $57,000.00 Equipment Depreciation $18,000.00 Vehicle Depreciation $2,000.00 Heat (due next month) $450.00 Electricity $325.00 Telephone $230.00 Advertising $1,200.00 Salaries $15,500.00 Payroll Tax Expense $1,700.00 Office Supplies $200.00 Insurance (due next month) $1,250.00 Loan payment $3,500.00     principal $1,500.00     interest $2,000.00 Legal fees (due next month) $500.00 Accounting $250.00 Vehicle...
Construct Albert Retail Co's Pro Forma Income Statement and Balance Sheet for Years 1 to 3...
Construct Albert Retail Co's Pro Forma Income Statement and Balance Sheet for Years 1 to 3 under the following policies: COGS+SG&A+Depreciation = 60% of Revenue Dividend Payout = 50% Current Assets = 40% of Revenue Net Fixed Assets = 60% of Revenue Current Liabilities = 70% of Current Assets Corporate Tax Rate = 21% Year 0(2018) 1 2 3 Revenue 150.0 195.0 253.5 253.5 COGS+SG&A+Depreciation 90.0 EBIT 60.0 Tax (21%) 12.6 Net Income 47.4 Dividends 23.7 Addition to Retained Earnings...
Use the 2015 income statement and balance sheet (next page) to construct a statement of cash...
Use the 2015 income statement and balance sheet (next page) to construct a statement of cash flows for Laguna Surf Board Company. Determine the amount of financing they will need to raise in the capital markets. Remember to calculate subtotals for operating activities, investing activities and financing activities. Laguna Surf Board 2015 Income Statement $M Sales 700 Less COGS 400 Gross Profit 300 Depreciation 40 Operating Expenses 105 EBIT (Operating Profit) 155 Interest 25 EBT (Pretax Income) 130 Taxes 30...
eBook Problem 9-01 From the following information, construct a simple income statement and a balance sheet:...
eBook Problem 9-01 From the following information, construct a simple income statement and a balance sheet: Sales $1,300,000 Finished goods 100,000 Long-term debt 200,000 Raw materials 130,000 Cash 80,000 Cost of goods sold 650,000 Accounts receivable 190,000 Plant and equipment 530,000 Interest expense 90,000 Number of shares outstanding 110,000 Earnings before taxes 470,000 Taxes 120,000 Accounts payable 220,000 Other current liabilities 60,000 Other expenses 90,000 Equity 550,000 Round your answer for earnings per share to the nearest cent. Corporation X:...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE TAX RATE IS 40%. (COMMON EQUITY IS A PLUG IN NUMBER) ITEM 2010 2011 SALES 10,000 12,000 DEPRECIATION 3,000 3,000 COST OF GOODS SOLD 2,000 2,000 OTHER EXPENSES 3,000 4,000 INTEREST 1,000 1,000 CASH 1,000 1,000 ACCOUNTS RECEIVABLE 3,000 3,000 S.T. NOTES PAYABLE 1,000 1,000 L.T. DEBT 10,000 11,000 NET FIXED ASSETS 20,000 20,000 ACCOUNTS PAYABLE 2,000 2,000 INVENTORY 3,000 3,000 DIVIDENDS 600 600...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT