 |
|
|
 |
New Member
|
|
Jul 28, 2011, 10:14 AM
|
|
I need help filling this excel sheet in. Thank you
Accounting, 9e
P1-36A Preparing financial statements and evaluating business performance
LO 9 [20-30 minutes]
Students please fill-in areas that are shaded
Student Name
Course Name Accounting
Student ID:
Date: July 26, 2011
Studio Photography, works weddings and prom-type parties. The balance of
Ansel, capital was $16,000 at December 31, 2011. At December 31, 2012, the
business's accounting records show these balances:
Insurance expense $8,000 Accounts receivable $8,000
Cash 37,000 Note payable 12,000
Accounts payable 7,000 Ansel, capital, Dec. 31, 2012 125,000
Advertising expense 3,000 Salary expense 25,000
Service revenue 80,000 Equipment 50,000
Ansel, drawing 13,000 Owner investment, 2012 29,000
Requirements
1. Prepare the following financial statements for Studio Photography for the
year ended December 31, 2012:
a. Income statement
b. Statement of owner's equity
c. Balance sheet
Test Your Knowledge
P1-36A
Req. 1
Studio Photography
Income Statement
Year Ended December 31, 2012
Revenue: Accounts Recieveable 8,000
Service revenue $80,000
Expenses:
Total expenses -
Net income $80,000
Req. 2
Studio Photography
Statement of Owner's Equity
Year Ended December 31, 2012
$16,000
Owners Investment 2012 29,000
80,000
125,000
Ansel, capital, December 31, 2012 $125,000
Studio Photography
Balance Sheet
December 31, 2012
ASSETS LIABILITIES
Total liabilities $-
OWNER'S EQUITY
Ansel, capital 125,000
Total assets $- Total liabilities and owner's equity $125,000
|
|
 |
Ultra Member
|
|
Jul 28, 2011, 10:55 AM
|
|
Please read the following.
Announcement:
If you'll post your week (attach your spreadsheet), we can check it and help you. We'll want to see that you made an effort and that will help us see where you are having problems, which we can then explain. Thanks.
|
|
 |
New Member
|
|
Jul 28, 2011, 10:10 PM
|
|
Great thank you so much. I think I attached it correctly!
|
|
 |
Ultra Member
|
|
Jul 28, 2011, 11:12 PM
|
|
Is there any chance you've left something out of the acounts? I can't get it to balance, making me think something is missing.
For now, let's address the work as is. Your Income Statement should only include Revenue and Expenses. Your Balance Sheet should only include Assets, Liabilities, and Equity accounts. You have a mixture in both.
The Owner's Equity statement should start with the balance last year, show the adjustments for this year, and end with the current ending balance. However, until we figure out why you are not in balance to start you won't be able to complete that part.
|
|
 |
New Member
|
|
Jul 29, 2011, 07:02 AM
|
|
I scanned the textbook and uploaded, thank you so very much for all of your help.
|
|
 |
New Member
|
|
Jul 29, 2011, 07:31 AM
|
|
I am not sure what I am missing, I am trying to attached the pages from the text book, but it will not let me. I can not thank you even for all your help!
|
|
 |
New Member
|
|
Jul 29, 2011, 07:32 AM
|
|
Comment on katelloyd11's post
The ones below I oculd not get to open, please let me know if you were able to view them. Again tahnk you so much!
|
|
 |
Ultra Member
|
|
Jul 29, 2011, 08:16 AM
|
|
Yes, I can open them. Okay, this is making more sense. They have a ? For the Capital at 12/31/12. In your first worksheet, you were showing that at $125,000. Let's do this step by step. Can you correct your worksheet for the Income Statement? It should only show Revenues and Expenses. You will be able to identify those by the account titles. If you'll repost your work, I'll check it. Once you have that right, we can move on.
|
|
 |
New Member
|
|
Jul 29, 2011, 11:38 AM
|
|
Ok I think I got it right for the Income statement. Thank you so much!
|
|
 |
Ultra Member
|
|
Jul 29, 2011, 11:47 AM
|
|
Not quite. It should only have those accounts that are revenues or expenses, and their account titles tell you this. As one example, Notes Payable does not have "expense" in it. I notice that you have it included in the total for your first column, but not in the second. Maybe you understand and just need to show it correctly? Same with Accts Rec cash.
Where did you get the amount for Advertising Expense? Look at that figure again.
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
Eliminate data in sheet 1 from sheet 2 in excel
[ 1 Answers ]
I've got 4000 names in Sheet 1 and I've got 200 names is Sheet 2. The names of 200 person in Sheet 2 also contain in Sheet 1. I would like to ask how can I eliminate names in Sheet 1 (4000 names) based on names in Sheet 2 (200 names).
Strawberry filling sheet cake
[ 4 Answers ]
I need some advice. What is best way to fill the cake and place the 2 layers on top of each other thanks
View more questions
Search
|