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 January
Journal – General journal for the company
Ledger – General ledger for relevant accounts
Trial Balance – Template for unadjusted and adjusted trial balances
IS – Income Statement template
SE – Statement of Stockholders’ Equity template
BS – Balance Sheet template
CF – Statement of Cash Flows template.
Required:
Part A
Prepare journal entries for all the transactions occurring in January
Post entries to the general ledger
Prepare the unadjusted trial balance as of January 31st
Prepare adjusting entries at January 31st
Post adjusting entries to the general ledger
Prepare the adjusted trial balance as January 31st
Prepare and post closing entries and prepare trial balance at February 1st
Prepare the four primary financial statements on January 31st
Include 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 B
In 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.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more