Description
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.
Explanation & Answer
Hello there, here is the complete balance sheet.Go through it and in case of anything, feel free to alert me.Regards
VWV COMPANY
BALANCE SHEET
DECEMBER 31, 20XX
Assets
Liabilities
Current Assets
Current Liabilities
Cash
72000
Accounts Receivable
18000
Interest Receivable
1000
Inventory
60000
Total Current Assets
151000 Total Current Liabilities
Long Term Assets
Long Term Liabilities
Equipm...