Module- SLP Assignment
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
|
|
|
|
50,000
|
|
|
|
95,000
|
|
|
|
$155,000
|
|
Total assets
|
279,000
|
|
$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 listed below.
Questions:
• 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 at the end of the year.
• How do we know that the above is a corporate (not a sole proprietor) balance sheet?
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. Both content and presentation matter.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.