Hi there! Please Help:

1) Acme Manufacturing Company (AMC) borrows $7.5 million under a short-term, working capital loan facility from its bank.

2) AMC purchases $3 million raw materials and consumables from a supplier whose sales terms give AMC 30 days to pay.

3) AMC uses $1.5 million of labor and $500,000 of energy to turn the raw materials and consumables into semi-finished products, or work-in-process.

4) AMC finishes its products into salable form, using another $1.5 million of labor and $500,000 of energy.

5) AMCs power utility bills the company for the $1 million of energy used in the production process, and the invoice is due in 20 days.

6) AMCs month-end payroll comes and it pays its employees for their production labor on these products.

7) AMC pays its supplier the $3 million for the raw materials and consumables purchased.

8) AMC sells its finished products for $10 million to a customer on 30-day payment terms.

9) AMC incurs $25,000 of packaging and handling expenses to prepare the finished products for shipping to the customer. Assume that AMC pays those in cash immediately.

10) AMC receives full payment from its customer for the sale.

11) AMC pays its $1 million utility bill.

12) AMC repays its bank the $7.5 million borrowed for working capital, plus $100,000 of interest on the loan.

On a second tab in the Excel workbook, using information from the Expanded Accounting Equation template, show what the simple balance sheet looks like after step 5, After step 9? After step 11?

Here is a picture of what to fill out:

Expanded Accounting Equation