Preparing A Financial Report Using MS Excel

In this activity, you will prepare a financial report. For this, you will first read the following scenario and then complete the steps given below.

Indexed Machinery (IM) is a small manufacturing company located in Seekonk, MA. The owners are working on the company’s annual financial reporting. The first financial report is an MS Excel worksheet that compares the company's balance sheets for the previous two years. The report form already has the labels entered for the required line items.

The owners have asked you to complete the report by entering the numeric data and the formulas to perform the financial calculations. Complete the following steps: See Attachment