you work as an assistant in a small, family-run business. The business does not yet have...

 

Transcribed Image Text:

you work as an assistant in a small, family-run business. The business does not yet have any cloud accounting software and completes financial activities using paper books. Tracking financial information on pieces of paper has been a nightmare for your manager. Your manager approaches you one day and asks if you would be able to make an Excel workbook that can be used to prepare basic financial statements on a monthly basis. Your manager needs to be able to open up one Excel workbook at the end of every month and easily populate data into the spreadsheet so that they can see the financial situation of the business. You will have to prove to the manager that the workbook you create will accomplish the task. The goal of the workbook is to make your manager's life much easier. Remember, up until this point the manager has been using paper books to track finances and it is a substantial waste of time. Any automation of calculation and population of data in the spreadsheets will make workplace efficiencies. Make sure you use advanced Excel functions to analyze and organize the data. You will have to prepare a worksheet template that includes a balance sheet, income statement, statement of owner's equity, general journal, and a general ledger. Remember that this is a small business and it does not need elaborate financial statements. You will have to create the business. You can make up all of the data about the business (what service or products it provides, its assets and liabilities, its revenue, its expenses, its equity, etc.) You are permitted to use a business idea you had used in a previous course or create an entirely new business. You will have to make assumptions about the business and create all of the financial data yourself. You will have to create the financial statement structure in the workbook. Make sure you use formulas to link the financial statements together and create automated calculations that will populate cells in all of the financial statements. Use formulas, charts, or other Excel functions to set up the capacity for the Excel workbook to analyze financial data automatically. Submission: submit two Excel workbooks: one template for the instructor to test and one with populated data to prove that it works. you work as an assistant in a small, family-run business. The business does not yet have any cloud accounting software and completes financial activities using paper books. Tracking financial information on pieces of paper has been a nightmare for your manager. Your manager approaches you one day and asks if you would be able to make an Excel workbook that can be used to prepare basic financial statements on a monthly basis. Your manager needs to be able to open up one Excel workbook at the end of every month and easily populate data into the spreadsheet so that they can see the financial situation of the business. You will have to prove to the manager that the workbook you create will accomplish the task. The goal of the workbook is to make your manager's life much easier. Remember, up until this point the manager has been using paper books to track finances and it is a substantial waste of time. Any automation of calculation and population of data in the spreadsheets will make workplace efficiencies. Make sure you use advanced Excel functions to analyze and organize the data. You will have to prepare a worksheet template that includes a balance sheet, income statement, statement of owner's equity, general journal, and a general ledger. Remember that this is a small business and it does not need elaborate financial statements. You will have to create the business. You can make up all of the data about the business (what service or products it provides, its assets and liabilities, its revenue, its expenses, its equity, etc.) You are permitted to use a business idea you had used in a previous course or create an entirely new business. You will have to make assumptions about the business and create all of the financial data yourself. You will have to create the financial statement structure in the workbook. Make sure you use formulas to link the financial statements together and create automated calculations that will populate cells in all of the financial statements. Use formulas, charts, or other Excel functions to set up the capacity for the Excel workbook to analyze financial data automatically. Submission: submit two Excel workbooks: one template for the instructor to test and one with populated data to prove that it works.