M4A1 Preparing A Financial Report Using MS Excel

Documentation

Benjamin's Machinery Inc.
Author
Date
Purpose	To display Last Year's and This Year's balance sheet comparisons for Benjamin's Machinery Inc.

Balance Sheet

Benjamin's Machinery Inc.
Balance Sheet Document
Account	LAST YEAR	THIS YEAR	% Change
Assets	Cash
Accounts Receivable
Inventories
Prepaid Expenses
Current Assets
Other Assets
Fixed Assets (at cost)
Accumulated Depreciation
Net Fixed Assets
TOTAL ASSETS
Liabilities	Accounts Payable
Accrued Expenses
Current Portion of Debt
Income Taxes Payable
Current Liabilities
Long-Term Debt
Capital Stock
Retain Earnings
Shareholders' Equity
TOTAL LIABILITIES & EQUITY

1

2

3

4

5

6

7

8

9

A

B

Benjamin's Machinery Inc.

Balance Sheet Document

Account

Assets

Cash

Accounts Receivable

Inventories

Prepaid Expenses

Current Assets