i just want the cash flow statement. All the other statements are here solved.

10:52 Blackboard ACCT 205 Solution Part 1 . . . Instructions Background Info Trial Balance Stmt. Of Comp Income Stmt of Shrs. Equity Stmt of F LEARNING OBJECTIVE OF THIS PROJECT I have designed this project to help reinforce your understanding of Financial Statements AND to enhance your excel skills. You will be asked to prepare all four Financial Statements from a Trial Balance that is provided You will also be exped spected to use Excel Formulae to link all Financial Statement Data back to the Trial Balance. In other word, if you change a number in the Trial Balance it should au where it is used in the Financial Statements. Financial Statements will be expected to be built in the format taught in this course and expected on tests and exams. The file will have features built into it to check for copying from another file. IF I GET TWO STUDENT FILES WITH THE EXACT SAME FORMULA AND FORMATTING IN T. TREAT THIS AS ACADEMIC DISHONESTY THAT WILL BE REPORTED, DO NOT COPY YOUR FILE OR ANY DATA FROM ANYONE ELSE, Have fun with this project, I an excel file together and use the summing formula and other formatting features to make an easy to read file, This is a skill you will be able to use in an accounting career and in your management (eg. to prepare your own personal budget perhaps?). This Project is an individual assignment. Anything that looks identical to another student's submission will be reported as Academic Dishonesty. Try to have fun with this. It is meant to solidfy a lot of your learning from Introductory Accounting and ACCT 205. The Project is worth 10% of your final grade. You will submit this Project for feedback at various checkpoints along the way. Your instructor will mark it and return it for you to carryon your work. Let's Get Started! INSTRUCTIONS On Background Information Worksheet: Read the background information very carefully. It contains information that you will need to create the financial statements Adjusted Trial Balances The trial balance contains all of the account balances for the company. Note that closing entries have not yet been ecorded. You may decide to use all of these accounts on your statements or to consolidate some accounts on your financial statements. Certain accounts, like Cash and tax expense, cannot be consolidated, while other expenses can be at your discretion. Your goal is to produce statements that will be as useful as possibl The company did not purchase or dispose of any fixed assets during 2020. 2019 Balance sheet Accounts The accounts from the 2019 balance sheet are presented (unformatted) You will need these when you prepare the Statement of Cash Flows You will also need them to prepare a comparative balance sheet. Statement of Comprehensive Income Using the appropriate accounts from the Trial Balance, prepare IN GOOD FORMAT a Statement of Comprehensive Income Use a single statementformat with OCI reported directly below Net Income. Note that the company plans to shut down its US operations. Be sure to record this properly on the Statement. Also take note of any revaluations of equipment due to the planned shut You statement must be a multi-step format. You may consolidate certain accounts (e.g. sales revenue and service revenue) however a detailed breakdown should be reported in your notes. Formatting counts!! Statement of Shareholders' Equity Prepare a properly formatted Statement of Shareholders' Equity. Remember that closing entries have not been recorded yet (i.c. think about if the equity balances on the trial balance are opening or closing balances!) Balance Sheet You need to prepare a properly formatted balance sheet for March 31. 2019 and 2020 (2019 data is given on the Comparative BS tab) You may show fixed asset accounts on a net basis - details of depreciation can be disclosed in the Notes. The company will have either a positive cash balance or a bank overdraft balance. It cannot have both in any given year. Statement of Cash Flows Using the Statement of Comprehensive Income and the Balance Sheet, prepare a Statement of Cash Flows You may use either the indirect (recommended) or direct method. Make sure that the calculated cash balance on the statement matches the ending cash balance on the Balance Sheet Hint: Overdraft is essentially negative cash and should not be included in working capital. Instead, it is part of the opening/closing cash balance Use information from Statement of Shareholders Equity as well as balance sheets to construct your cash flow statement.