AutoSaveMGT120 Excel AssignmentO SearchffHaniaFileHomeInsertPage LayoutFormulasDataReviewViewHelpInsert- A AArialv 10GeneralE Delete vPasteConditional Format asCllSort & Find &$ - % 9 8 %В I U0 .00Formatting Table vStyles vFormat vFilter Select vClipboardFontAlignmentNumberStylesCellsEditingAY1frВCEGH.I J KLMN O PQRST U VWJune 30: Accrued $1750 in employee salaries. Employees are paid on the first day of each month.June 30: A count revealed that $350 worth of supplies are still on hand.19202122Other Information:231) In the past, Little Black Dog Inc. has used the following accounts on their income statement: Revenue, Depreciation Expense, SuppliesExpense, Interest Expense, Rent Expense, Salaries Expense, Advertising Expense, and Supplies Expense. They use the Dividends account torecord dividends. Not all accounts have been used each period.24252627Required:1) Create all necessary journal entries for the month of June 2021. Place your answer under "Requirement 1" in the "Answer" tab. Note that thedates have been pre-populated. Ensure your journal entries match the appropriate date. Explanations are not required.2829302) Analyze the effects of the above transactions on the accounting equation. Place your answer under "Requirement 2" in tre "Answer“ tab.3) Prepare the Income Statement for the month ended June 30, 2021. List expenses in decreasing order by amount. Place your answer under"Requirement 3“ in the "Answer“ tab.3132334) Prepare the Statement of Retained Earnings for the month ended June 30, 2021. Place your answer under "Requirement 4“ in the "Answer“34tab."355) Prepare the Balance Sheet at June 30, 2021. Place your answer under "Requirement 5" in the "Answer“ tab.6) Using the method outlined in the textbook, journalize the necessary closing entries for the month ended June 30, 2021. Place your answerunder "Requirement 6“ in the "Answer" tab.36373839InstructionsProblemAnswerwWEOlili HomeInsertPage LayoutFormulasDataReviewViewHelp- 10 - A AInsert vΣArialabGeneralEXDelete vBIU$- % 9 0 0Conditional Format asCellSort &FormattingTable -Styles vFormat vFilteroardFontAlignmentNumberStylesCellsEditingfrC DH.The following amounts summarize the financial position of Little Black Dog Inc. on May 31, 2021:ВFGIJK LMNO PQRSVWAssetsLiabilitiesShareholders' Equity%DCash +AccountsComputers++ Supplies + LandAccounts+NoteSalaries+InterestCommon+RetainedReceivable(net)PayablePayablePayablePayableSharesEarningsBalance 1820700708400560028002590During June 2021, the business completed these transactions:June 1: Received cash of $6300 and issued common shares.June 1: Bought two computers for a total of $5600 by paying $1400 down and signing a note payable for the rest. Interest of 5% to be paid with thenote payable on June 1, 2022. The computers are expected to last 5 years.June 5: Performed services for a client and received cash of $2450.June 9: Paid $2450 on accounts payable.June 13: Purchased supplies on account, $1400.June 20: Collected cash from a customer on account, $350.June 23: Consulted on the design of a business report, and billed the client for services rendered, $2800.June 25: Declared and paid a cash dividend of $980.June 30: Recorded the following business expenses for the month: paid office rent, $210; paid advertising, $350.June 30: Accrued $1750 in employee salaries. Employees are paid on the first day of each month.June 30: A count revealed that $350 worth of supplies are still on hand.InstructionsProblemAnswer

Question

AutoSaveMGT120 Excel AssignmentO SearchffHaniaFileHomeInsertPage LayoutFormulasDataReviewViewHelpInsert- A AArialv 10GeneralE Delete vPasteConditional Format asCllSort & Find &$ - % 9 8 %В I U0 .00Formatting Table vStyles vFormat vFilter Select vClipboardFontAlignmentNumberStylesCellsEditingAY1frВCEGH.I J KLMN O PQRST U VWJune 30: Accrued $1750 in employee salaries. Employees are paid on the first day of each month.June 30: A count revealed that $350 worth of supplies are still on hand.19202122Other Information:231) In the past, Little Black Dog Inc. has used the following accounts on their income statement: Revenue, Depreciation Expense, SuppliesExpense, Interest Expense, Rent Expense, Salaries Expense, Advertising Expense, and Supplies Expense. They use the Dividends account torecord dividends. Not all accounts have been used each period.24252627Required:1) Create all necessary journal entries for the month of June 2021. Place your answer under &#34;Requirement 1&#34; in the &#34;Answer&#34; tab. Note that thedates have been pre-populated. Ensure your journal entries match the appropriate date. Explanations are not required.2829302) Analyze the effects of the above transactions on the accounting equation. Place your answer under &#34;Requirement 2&#34; in tre &#34;Answer“ tab.3) Prepare the Income Statement for the month ended June 30, 2021. List expenses in decreasing order by amount. Place your answer under&#34;Requirement 3“ in the &#34;Answer“ tab.3132334) Prepare the Statement of Retained Earnings for the month ended June 30, 2021. Place your answer under &#34;Requirement 4“ in the &#34;Answer“34tab.&#34;355) Prepare the Balance Sheet at June 30, 2021. Place your answer under &#34;Requirement 5&#34; in the &#34;Answer“ tab.6) Using the method outlined in the textbook, journalize the necessary closing entries for the month ended June 30, 2021. Place your answerunder &#34;Requirement 6“ in the &#34;Answer&#34; tab.36373839InstructionsProblemAnswerwWEOlili HomeInsertPage LayoutFormulasDataReviewViewHelp- 10 - A AInsert vΣArialabGeneralEXDelete vBIU$- % 9 0 0Conditional Format asCellSort &FormattingTable -Styles vFormat vFilteroardFontAlignmentNumberStylesCellsEditingfrC DH.The following amounts summarize the financial position of Little Black Dog Inc. on May 31, 2021:ВFGIJK LMNO PQRSVWAssetsLiabilitiesShareholders' Equity%DCash +AccountsComputers++ Supplies + LandAccounts+NoteSalaries+InterestCommon+RetainedReceivable(net)PayablePayablePayablePayableSharesEarningsBalance 1820700708400560028002590During June 2021, the business completed these transactions:June 1: Received cash of $6300 and issued common shares.June 1: Bought two computers for a total of $5600 by paying $1400 down and signing a note payable for the rest. Interest of 5% to be paid with thenote payable on June 1, 2022. The computers are expected to last 5 years.June 5: Performed services for a client and received cash of $2450.June 9: Paid $2450 on accounts payable.June 13: Purchased supplies on account, $1400.June 20: Collected cash from a customer on account, $350.June 23: Consulted on the design of a business report, and billed the client for services rendered, $2800.June 25: Declared and paid a cash dividend of $980.June 30: Recorded the following business expenses for the month: paid office rent, $210; paid advertising, $350.June 30: Accrued $1750 in employee salaries. Employees are paid on the first day of each month.June 30: A count revealed that $350 worth of supplies are still on hand.InstructionsProblemAnswer

Accepted Answer

since you have posted a question with multiple subparts, we will solve first three parts for you.…