Determine net short-term assets or liabilities.
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
$32,000
Accounts receivable
28,000
Interest payable
8,000
Interest receivable
1,000
Inventory
66,000
Total current assets
$167,000
Total current liabilities
$40,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
295,000
Total liabilities and equity
$295,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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
