Ask Experts Questions for FREE Help !
Ask
    katelloyd11's Avatar
    katelloyd11 Posts: 6, Reputation: 1
    New Member
     
    #1

    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


































































































    Just Looking's Avatar
    Just Looking Posts: 1,610, Reputation: 480
    Ultra Member
     
    #2

    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.
    katelloyd11's Avatar
    katelloyd11 Posts: 6, Reputation: 1
    New Member
     
    #3

    Jul 28, 2011, 10:10 PM
    Great thank you so much. I think I attached it correctly!
    Attached Files
  1. File Type: xls Lloyd_MK_Wk1_lesson3.xls (63.0 KB, 1801 views)
  2. File Type: xls Lloyd_MK_WK1_Lesson2.xls (60.5 KB, 491 views)
  3. Just Looking's Avatar
    Just Looking Posts: 1,610, Reputation: 480
    Ultra Member
     
    #4

    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.
    katelloyd11's Avatar
    katelloyd11 Posts: 6, Reputation: 1
    New Member
     
    #5

    Jul 29, 2011, 07:02 AM
    I scanned the textbook and uploaded, thank you so very much for all of your help.
    Attached Images
  4. File Type: pdf Wk1_Lesson_3_textbook.pdf (453.4 KB, 510 views)
  5. File Type: pdf Wk1_Lesson_2_textBook.pdf (907.6 KB, 2387 views)
  6. katelloyd11's Avatar
    katelloyd11 Posts: 6, Reputation: 1
    New Member
     
    #6

    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!
    katelloyd11's Avatar
    katelloyd11 Posts: 6, Reputation: 1
    New Member
     
    #7

    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!
    Just Looking's Avatar
    Just Looking Posts: 1,610, Reputation: 480
    Ultra Member
     
    #8

    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.
    katelloyd11's Avatar
    katelloyd11 Posts: 6, Reputation: 1
    New Member
     
    #9

    Jul 29, 2011, 11:38 AM
    Ok I think I got it right for the Income statement. Thank you so much!
    Attached Files
  7. File Type: xls Lloyd_MK_Wk1_lesson3.xls (63.0 KB, 332 views)
  8. Just Looking's Avatar
    Just Looking Posts: 1,610, Reputation: 480
    Ultra Member
     
    #10

    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

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).

How can I connect one sheet 1 in excel to sheet 2 so it will update the information. [ 7 Answers ]

What I am trying to do is I have a schedule with drop down boxes I want to beable to click on a name in the dropdown box next to a time slot for appointments which are listed under the days date like a calendar, but once clicked I need it to update the list on the first sheet next to the same name...

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