Answered step by step
Verified Expert Solution
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?
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
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