Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am currently working an assignment in the Excel Applications for accounting Principles. I was doing okay until I started working on the balance sheet.
I am currently working an assignment in the Excel Applications for accounting Principles. I was doing okay until I started working on the balance sheet. I am showing -$5180 .00 for Accounts Payable. The solution manual is showing the balance of the Accounts Payable as $1500. and the capital doesn't match either. I just am trying to figure out what I may have done wrong.
PTRANS | |||||||||
Business Transactions | |||||||||
Assets | = | Liabilities | + | Equity | Running | ||||
Accounts | Office | Accounts | Wood | Cash | |||||
Cash | Receivable | Supplies | Payable | Capital | Balance | ||||
a) | $9,000 | $0 | $0 | $0 | $9,000 | $9,000 | |||
b) | (3,000) | (3,000) | 6,000 | ||||||
c) | 1,980 | 1,980 | 6,000 | ||||||
d) | 4,500 | 4,500 | 10,500 | ||||||
e) | (1,400) | (1,400) | 9,100 | ||||||
f) | (420) | 420 | 8,680 | ||||||
g) | 4,600 | 4,600 | 8,680 | ||||||
h) | (360) | (360) | 8,320 | ||||||
i) | (2,400) | (2,400) | 5,920 | ||||||
j) | 300 | (300) | 6,220 | ||||||
k) | 3,000 | (3,000) | 9,220 | ||||||
l) | (2,000) | (2,000) | 7,220 | ||||||
m) | (600) | (600) | 7,220 | ||||||
$7,220 | $1,600 | $1,500 | ($5,180) | $15,500 | |||||
Balance Verification | |||||||||
Total assets | $10,320 | ||||||||
Total liabilities and equity | 10,320 | ||||||||
Difference | $0 | ||||||||
4 | Transactions a thru l are transactions that have happened over the course of the month. | ||||||||
Transaction m is an adjusting entry to make an adjustment at the end of the accounting cycle.. | |||||||||
Woody's Web Services | |||||||||
Income Statement | |||||||||
For Month Ended June 30, 2016 | |||||||||
Revenue | |||||||||
Income | $ 7,500.00 | ||||||||
Expenses: | |||||||||
Rent Expense | $ 3,000.00 | ||||||||
Salary Expense | $ 2,400.00 | ||||||||
Office Supply | $ 1,520.00 | ||||||||
Utilities | $ 360.00 | ||||||||
Total Expenses | $ 7,280.00 | ||||||||
Net Income | $ 220.00 | ||||||||
Woody's Web Service | |||||||||
Statement of Owner's Equity | |||||||||
For Month Ended June 30, 2016 | |||||||||
Wilson Wood, capital June 1, 2016 | $ 9,000.00 | ||||||||
Net Income for June | $ 220.00 | ||||||||
Less Withdrawals for June | $ 2,000.00 | ||||||||
Less Increase in capital | $ (1,780.00) | ||||||||
Wilson Wood, capital June 30, 2016 | $ 7,220.00 | ||||||||
Woody's Web Service | |||||||||
Balance Sheet | |||||||||
For Month Ended June 30, 2016 | |||||||||
Assets | Liabilities | ||||||||
Cash | Cash | $ 7,220.00 | Accounts Payable | $ 1,500.00 | |||||
Accounts Receivable | $ 1,600.00 | Owner's Equity | |||||||
Office Supplies | $ 1,500.00 | Wilson Wood, capital | $ 8,820.00 | ||||||
Total Assets | $ 10,320.00 | Total | $ 10,320.00 | ||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started