Determine net short-term assets or liabilities.
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds
