Need accounting homework help | ACCT350

Prepare financial statements using the attached excel file. All data is in the excel file. Computer Depot is a major computer store chain with locations across North America, Europe, and Africa. The company is preparing to report on business transactions that occurred during January. Download the Excel spreadsheet for Computer Depot in the module folder. The spreadsheet includes the following tabs:Transactions – Details the transactions that occurred in the month of JanuaryJournal – General journal for the companyLedger – General ledger for relevant accountsTrial Balance – Template for unadjusted and adjusted trial balancesIS – Income Statement templateSE – Statement of Stockholders’ Equity templateBS – Balance Sheet templateCF – Statement of Cash Flows template.Required:Part APrepare journal entries for all the transactions occurring in JanuaryPost entries to the general ledgerPrepare the unadjusted trial balance as of January 31stPrepare adjusting entries at January 31stPost adjusting entries to the general ledgerPrepare the adjusted trial balance as January 31stPrepare and post closing entries and prepare trial balance at February 1stPrepare the four primary financial statements on January 31stInclude a ratio analysis of your company and include the industry averages. Calculate at least one ratio from each category listed: Liquidity, Solvency, and Profitability, and provide an explanation on what it means to the company.Part BIn your current position as financial accounting manager, it is your turn to present the financial statements at the monthly leadership meeting.  Prepare a PowerPoint presentation (at least four slides but) analyzing the company’s financial performance for the month of January.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *