Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Build an Excel spreadsheet using the accounting equation for all the below requirement? 5 D obi 2 ring amounts summarize the financial position of Little

Build an Excel spreadsheet using the accounting equation for all the below requirement?

image text in transcribed

5 D obi 2 ring amounts summarize the financial position of Little Spotted Dog Inc. on May 31, 2020: 3 Assets Liabilities Shareholders' Equity ACCOUNTS - ACCOUNTS Tote + Computers + Supplies + Land Javanes TETEST COTTOM Cash RUtamu + . his Davobin T Double Canvas 6 Balance 3840 1920 600 15600 10320 0 5520 6120 7 8 During June 2020, the business completed these transactions: 9 June 1: Received cash of $9600 and issued common shares. 10 June 1: Bought two computers for a total of $9600 by paying $2700 down and signing a note payable for the rest. Interest of 10% to be paid with the 11 note payable on January 1, 2021. The computers are expected to last 5 years. 12 June 5: Performed services for a client and received cash of $10800. 13 June 9: Paid $5400 on accounts payable. 14 June 13: Purchased supplies on account, $7800. 15 June 20: Collected cash from a customer on account, $240. 16 June 23: Consulted on the design of a business report, and billed the client for services rendered, $8400. 17 June 25: Declared and paid a cash dividend of $1560. 18 June 30: Recorded the following business expenses for the month: paid office rent, $1200; paid advertising, $360. 19 June 30: Accrued $6000 in employee salaries. Employees are paid on the first day of each month. 20 June 30: A count revealed that $1920 worth of supplies are still on hand. 21 22 prmation: 23 1) In the past, Little Spotted Dog Inc. has used the following accounts on their income statement: Revenue, Depreciation Expense, Supplies Expense, Interest Expense, Rent Expense, Salaries Expense, Advertising Expense, and Supplies Expense. They use the Dividends account to record dividends. Not all accounts have been used each period. 24 30 1) Create all necessary joumal entries for the month of June 2020. Place your answer under "Requirement 1" in the "Answer" tab. Note that the dates have been pre-populated. Ensure your journal entries match the appropriate date. Explanations are not required. 2) Analyze the effects of the above transactions on the accounting equation. Place your answer under "Requirement 2" in the "Answer" tab. 3) Prepare the Income Statement for the month ended June 30, 2020. List expenses in decreasing order by amount. Place your answer under "Requirement 3" in the "Answer" tab. Prepare the Statement of Retained Earnings for the month ended June 30, 2020. Place your answer under "Requirement 4" in the "Answer" tab." 5) Prepare the Balance Sheet at June 30, 2020. Place your answer under "Requirement 5* in the "Answer" tab. 5 D obi 2 ring amounts summarize the financial position of Little Spotted Dog Inc. on May 31, 2020: 3 Assets Liabilities Shareholders' Equity ACCOUNTS - ACCOUNTS Tote + Computers + Supplies + Land Javanes TETEST COTTOM Cash RUtamu + . his Davobin T Double Canvas 6 Balance 3840 1920 600 15600 10320 0 5520 6120 7 8 During June 2020, the business completed these transactions: 9 June 1: Received cash of $9600 and issued common shares. 10 June 1: Bought two computers for a total of $9600 by paying $2700 down and signing a note payable for the rest. Interest of 10% to be paid with the 11 note payable on January 1, 2021. The computers are expected to last 5 years. 12 June 5: Performed services for a client and received cash of $10800. 13 June 9: Paid $5400 on accounts payable. 14 June 13: Purchased supplies on account, $7800. 15 June 20: Collected cash from a customer on account, $240. 16 June 23: Consulted on the design of a business report, and billed the client for services rendered, $8400. 17 June 25: Declared and paid a cash dividend of $1560. 18 June 30: Recorded the following business expenses for the month: paid office rent, $1200; paid advertising, $360. 19 June 30: Accrued $6000 in employee salaries. Employees are paid on the first day of each month. 20 June 30: A count revealed that $1920 worth of supplies are still on hand. 21 22 prmation: 23 1) In the past, Little Spotted Dog Inc. has used the following accounts on their income statement: Revenue, Depreciation Expense, Supplies Expense, Interest Expense, Rent Expense, Salaries Expense, Advertising Expense, and Supplies Expense. They use the Dividends account to record dividends. Not all accounts have been used each period. 24 30 1) Create all necessary joumal entries for the month of June 2020. Place your answer under "Requirement 1" in the "Answer" tab. Note that the dates have been pre-populated. Ensure your journal entries match the appropriate date. Explanations are not required. 2) Analyze the effects of the above transactions on the accounting equation. Place your answer under "Requirement 2" in the "Answer" tab. 3) Prepare the Income Statement for the month ended June 30, 2020. List expenses in decreasing order by amount. Place your answer under "Requirement 3" in the "Answer" tab. Prepare the Statement of Retained Earnings for the month ended June 30, 2020. Place your answer under "Requirement 4" in the "Answer" tab." 5) Prepare the Balance Sheet at June 30, 2020. Place your answer under "Requirement 5* in the "Answer" tab

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Susan Hamlen

5th Edition

1618534246, 9781618534248

More Books

Students also viewed these Accounting questions

Question

=+What can I do to make this press worthy?

Answered: 1 week ago