03 Jan • Determine net short-term
BUS500 Financial Intelligence
Module 2 SLP
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 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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
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.
Chat with us today! We are always waiting to answer all your questions.