Create a balance sheet using the account names and balances below. Make assumptions about the dollar...

Create a balance sheet using the account names and balances below. Make assumptions about the dollar values of each account so that the balance sheet balances. Remember that assets will equal liabilities plus stockholders’ equity. Please make the balance sheet so that it can be pasted into a word document and display any calculation, Thank you so much for your time and I will be sure to give you a 5-star rating for superior work.

Cash $32,800

Accounts Payable $49,000

Property and equipment $98,000

Marketable Securities $3,000

Common Stock $10,000

Prepaid Rent $1,000

Inventories $39,800

Accounts Receivable $300

Long Term Debt $99,500

Retained Earnings $11,950

Current Portion of Long Term Debt $4,450

Goodwill $2,000

Accumulated Depreciation $2,000

Expert Solution


Balance Sheet

	Amount ($)	Amount ($)
ASSETS

Current Assets
Cash	32,800
Marketable Securities	3,000
Inventories	39,800.00
Prepaid Rent	1,000
Accounts Receivables	300
Total Current Assets		76,900
Goodwill		2,000
Property, Plant & Equipment
Property, Plant & Equipment	98,000
Less: Accumulated Depreciation	-2,000	96,000

Total Assets		1,74,900

LIABILITIES & STOCKHOLDERS EQUITY
Current Liabilities
Accounts Payable	49,000
Current Portion of Long-term Debt	4,450
Total Current Liabilities		53,450
Long-term Liabilities
Long-term Debt		99,500
Total Liabilities		1,52,950
Stockholders’ Equity
Common Stock	10,000
Retained Earnings	11,950	21,950

Total Liabilities & Stockholders’ Equity		1,74,900

jeff jeffy answered 1 year ago

Complete the following balance sheet using the information given. Round account balances to the nearest dollar....

Complete the following balance sheet using the information given. Round account balances to the nearest dollar. Balance Sheet Income Statement Cash Sales (All Credit) $40,000 Accounts receivable Cost of goods sold 20,000 Inventory Operating expenses 12,000 Net fixed assets Interest expense 200 Total assets Taxes 2 730 Net income $5,070 Accounts payable Short-term notes payable $1,425 Ratios: Long-term debt Profit Margin = 12.675% Common stock $5,000 Return on Equity = 15% Retained earnings Quick Ratio = 1.2 Total Liabilities and...

Selected balance sheet account balances are:

Selected balance sheet account balances are: VIZQUEL COMPANY December 31 2002 2001 Cash $ 200,000 $ 300,000 Accounts Payable 60,000 80,000 Accounts Receivable 180,000 140,000 Salaries Payable 12,000 6,000 Land 120,000 140,000 Merchandise Inventory 100,000 160,000 Prepaid Rent 50,000 45,000 Unearned Consulting Revenue 70,000 50,000 Income statement items for the year are: Sales $800,000 Consulting Fees $200,000 Cost of Goods...

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...

Using the account balance below, prepare a classified balance sheet for the JAN Corporation for the...

Using the account balance below, prepare a classified balance sheet for the JAN Corporation for the year ending 2016 Accounts Balances Cash 2,100 Notes payable 5,000 Petty Cash 100 Temporary investments 10,000 Accounts payable 35,900 Accounts Receivable 44,500 Allowance for A/R 4,000 Wages payable 8,500 Interest payable 2,900 Taxes Payable 6,100 Notes Payable 20,000 Land 5,500 Land improvements 6,500 Goodwill 105,000 Trade names 200,000 Common Stock 110,000 Retained earnings 220,000 Unearned revenues 1,500 Equipment 201,000 Accumulated deprecaition 56,000 Supplies 3,800...

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...

Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below...

Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below Calculate the Net Working Capital and the Net Operating Working Capital for both years Perform vertical analysis on both statements, for both years Perform Horizontal analysis on both statements for the most current year What was the Net Operating Profit After Taxes for both years? 2016 Accounts Receivable 400 Sales 5000 Accounts Payable 650 Inventory 1400 COGS 3000 Common Stock 1500 Cash 1600 Oper....

B. Using the table below, create the balance sheet of MaineBank assuming the following information (in...

B. Using the table below, create the balance sheet of MaineBank assuming the following information (in millions $$): Reserves = $360, Loans = $1,240, Deposits = $1,800, Debt = $150, Securities = $400, Capital (owner’s equity) = $50. What is the reserve-deposit ratio assuming all reserves are required reserves? What is the leverage ratio? Show your work/calculations. (10 points) MaineBank Balance Sheet Assets Liabilities & Owner’s Equity Reserves Deposits Loans Debt Securities Capital (Owners’ equity) Total Total Reserve deposit...

The following CR account balances appeared in the balance sheet of Johns Jacks Ltd as at...

The following CR account balances appeared in the balance sheet of Johns Jacks Ltd as at 30 June 2007: $ Paid-up capital (1 000 000 ordinary shares) 1 000 000 Retained profits 350 000 Asset revaluation reserve 600 000 General Reserve 50 000 The following selected transactions took place during the financial year ended 30 June 2007. 1 July: A 1:4 bonus share dividend, valued at $2.00 per share, is declared (using funds from the asset revaluation reserve account) and...

Review the balance sheet presented above for possioble errors and make any comments about it below....

Review the balance sheet presented above for possioble errors and make any comments about it below. Balance Sheet Assets Current Assets Cash 10,000 Accounts Receivables 12,000 Inventory (20,000) Total Current Assets 2,000 Fixed Assets Building 100,000 Equipment 50,000 Accumulated Depreciation 75,000 Total Fixed Assets 225,000 Total Assets 227,000 Liabilities Current Liabilities Accounts Payable 8,000 Accrued Wages 10,000 Unearned Revenue 5,000 Payroll Liabilities (2,000) Total Current Liabilities 21,000 Long-Term Liabilities Bank Line of Credit 35,000 Equipment Loan 25,000 Total Long-Term Liabilities...

Based on the Trial Balance below and the Statement of Retained Earnings create a Balance Sheet...

Based on the Trial Balance below and the Statement of Retained Earnings create a Balance Sheet Statement: ACCT # Account Name Debit Credit 1000 Cash $402,575 1030 Treasury Bills $100,000 1031 Municiple Bonds $104,425 1032 Investments $770,500 1210 Accounts Receivable $30,000 1400 Inventory $20,000 1500 Furniture and Fixtures $0 1599 Accumulated Depreciation $30,000 2000 Accounts Payable $40,000 3000 Common Stock $0 3500 Retained Earnings $65,000 4000 Gross Sales $3,900,000 4100 Sales Returns $20,000 5000 Cost of Goods Sold $1,080,000 6000...

Question