Question: please help walk me through these steps; take your time please. please only help if you reslly can help this is very difficult. for me

please help walk me through these steps; take your time please. please only help if you reslly can help this is very difficult. for me at least. thanks so much
please help walk me through these steps; take your time please. please
only help if you reslly can help this is very difficult. for
me at least. thanks so much SCENARIO: For this part of the
project, you will instruct your employees to take the four years and
create an Excel workbook with four tabs (worksheets) in it. The tabs
(worksheets) will be labeled 1) Income Statement: 2) Trend Analysis-IS: 3) Balance
Sheet: and 4) Trend Analysis-BS. They will need to copy the company's
financial statements. The first tab should be information from the Income Statements
(Net income being the last entry), and the third tab should be
information from the Balance Sheets. The second tab will be a trend
analysis (one decimal point percentage) of the income statement numbers, and the
fourth tab will be a trend analysis (one decimal point percentage) for
the balance sheet numbers. It's important that any math (i.e. totals on
Income Statement and Balance Sheet, and all numbers on two trend analyses
tabs) be Excel formula driven (specifically using SUM for the Balance Sheet

SCENARIO: For this part of the project, you will instruct your employees to take the four years and create an Excel workbook with four tabs (worksheets) in it. The tabs (worksheets) will be labeled 1) Income Statement: 2) Trend Analysis-IS: 3) Balance Sheet: and 4) Trend Analysis-BS. They will need to copy the company's financial statements. The first tab should be information from the Income Statements (Net income being the last entry), and the third tab should be information from the Balance Sheets. The second tab will be a trend analysis (one decimal point percentage) of the income statement numbers, and the fourth tab will be a trend analysis (one decimal point percentage) for the balance sheet numbers. It's important that any math (i.e. totals on Income Statement and Balance Sheet, and all numbers on two trend analyses tabs) be Excel formula driven (specifically using SUM for the Balance Sheet and Income Statement and Excel cell references and SUM for the two trend analyses). Stress to your employees the importance of accuracy. You should not add or remove information. Copy the company's statements. The workbook should be set up with the following tabs: Income Statement Trend Analysis-IS Balance Sheet Trend Analysis-BS Page

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!