Bus 500 module 2 slp

Module 2 – SLP

BALANCE SHEET

Below find a balance sheet for VWV Company. 

VWV Company

 

Balance Sheet

 

 December 31, 20XX

 

 

 

 

 

 

 

 

 

Assets

 

 

 

Liabilities

 

 

 

 

 

 

 

 

 

 

 

Current assets

 

 

 

Current liabilities

 

 

 

 

 

 

 

 

 

 

 

 

Cash

 $72,000

 

 

Accounts payable

 $12,000

 

 

Accounts receivable

 18,000

 

 

Interest payable

 12,000

 

 

Interest receivable

 1,000

 

 

 

 

 

 

Inventory

 60,000

 

 

 

 

 

Total current assets

 

 $151,000

 

Total current liabilities

 

 $24,000

 

 

 

 

 

 

 

 

 

Long-term assets

 

 

 

Long-term liabilities

 

 

 

 

 

 

 

 

 

 

 

 

Equipment (net of depreciation)

 $128,000

 

 

Note payable

 100,000

 

 

 

 

 

 

 

 

 

Total long-term assets

 

 $128,000

 

Total long-term liabilities

 

 $100,000

 

 

 

 

 

 

 

 

 

 

 

 

 

Equity

 

 

 

 

 

 

 

 

Common stock

 10,000

 

 

 

 

 

 

Paid-in capital

 50,000

 

 

 

 

 

 

Retained earnings

 95,000

 

 

 

 

 

 

 

 

 

 

 

 

 

Total equity

 

 $155,000

 

 

 

 

 

 

 

Total assets

 

279,000

 

Total liabilities and equity

 

 $279,000

                           

Required: 

Recreate the balance sheet in an Excel spreadsheet. Use cell formulae to add and subtract numbers. Add a column next to the balance sheet for answers to the questions in this case.

  • Is accounts payable larger or smaller than accounts receivable? What is the difference? What do the numbers indicate? Explain.
  • What does equipment net of depreciation mean?
  • Are payables short-term or long-term?
  • Determine total liabilities.
  • Determine net short-term assets or liabilities.
  • Determine the total amount owed by VWV owed at the end of the year.
  • How do we know that the above is a corporate (not a sole proprietor) balance sheet?
  • Both content and presentation matter.

SLP Assignment Expectations

Submit the Excel spreadsheet. All information should be part of the spreadsheet. Written comments should be brief and refer to the balance sheet.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer