Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use Microsoft Excel to answer this question and give the answer with Microsoft Excel it's a request. thank you Problem Topic #2: Financial Statements

image text in transcribedplease use Microsoft Excel to answer this question and give the answer with Microsoft Excel it's a request. thank you

Problem Topic #2: Financial Statements Scenario: 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. Problem Topic #2: Financial Statements Scenario: 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Finance

Authors: Brian Watts

8th Edition

0712110720, 978-0712110723

More Books

Students also viewed these Finance questions