Tableau DA 2-3: Mini-Case, Preparing an income statement, statement of retained earnings, and balance sheet...

80.2K

Verified Solution

Question

Accounting

Tableau DA 2-3: Mini-Case, Preparing an income statement, statement of retained earnings, and balance sheet LO P3

Maria Gomez owns and manages a consulting firm called Accel, which began operations on December 1. She asks us to assist her with some financial reporting questions. On December 31, we are provided with a Tableau Dashboard that includes selected accounts and amounts for the month of December. imageAnother half of this part

imageimageAdvertising expense is $2,800 Rent Expense is $4,000 Salaries Expense is $6,000 Utilities Expense is $2,400 Consulting Revenue is $34,000 and Rental Revenu is $7,000

1. Prepare an income statement for the month ended December 31. 2. Prepare a statement of retained earnings for the month ended December 31. The retained earnings account balance at December 1 was $0. Hint: Use the net income calculated in part 1. 3. Prepare a balance sheet as of December 31. Hint: Use the ending retained earnings balance calculated in part 2.

Prepare an income statement for the month ended December 31.

image

options for the left column

image

image

OPtions for the left column

imageimageOPtions are the same for 1st and 3rd columns

image

Assets Liabilities $14,000 $12,000 -- Notes Payable Unearned Revenue $10,000 $8,000 -- $6,000 -- $4,000 -- Accounts Payable Notes Payable Unearned Revenue $10,000 ------ ----------- ------------ ----- $8,000 $6,000 $4,000 -- Accounts Payable $2,000 Equity Common Stock $9,200 Cash Supplies Accounts Receivable Equipment Notes Prepaid Receivable Insurance Dividends $4,000 Advertising Expense Rent Expense Salaries Expense Utilities Expense Revenues Consulting Revenue Rental Revenue ACCEL Income Statement ACCEL Income Statement Accounts payable Accounts receivable Advertising expense Cash Required 1 Required 2. Required 3 Prepare a statement of retained earnings for the month ended December 31. The retained earnings account balance at December 1 was $0. Hint: Use the net income calculated in part 1. ACCEL Statement of Retained Earnings sta Required 1 Required 2 Required 3 Prepare a statement of retained earnings for the month ended December 31. The retained earnings account balance at December 1 was $0. Hint: Use the net income calculated in part 1. ACCEL Statement of Retained Earnings Accounts payable Accounts receivable Cash Equipment Prepare a balance sheet as of December 31. Hint: Use the ending retained earnings balance calculated in part 2. ACCEL Balance Sheet Prepare a balance sheet as of December 31. Hint: Use the ending retained earnings balance calculated in part 2. ACCEL Balance Sheet Accounts payable Accounts receivable Advertising expense Cash

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students