PLEASE HELP ME WITH MY HOMEWORK, FINANCE HOMEWORK

PRINCIPLES OF FINANCIAL ANALYSISPRIVATE

SPREADSHEET ASSIGNMENT: Eastland Products, Inc.

Amexicorp, Inc.

1. Retrieve the file CFM0318P.XLS. Boldface cell A1 and enter the

appropriate values in cells C7 and C17.

2. Enter the appropriate equations, not values, into the following

cells: C20, C29, C45, C46, C47, C48, C49, D9, and D16.

3. Print the worksheet.

4. Disregard the information presented in part (g) of the

Eastland problem and restore the original balance sheet values.

Construct a new balance sheet assuming 2 million common shares

were sold to net $25 per share, with the proceeds allocated as

follows: $25 million is used to discharge current liabilities,

and $25 million is added to liquid assets. Modify cells C52,

C53, C54, and C55.

5. Print the worksheet.

6. Retrieve the file CFM2A08P.XLS. Enter the label (words or

acronym) in cell A14 which describes the computations reported

in cells B14 and D14.

7. Enter the appropriate values in the following cells: B16, D16,

B18, and D18.

8. Enter the appropriate equations, not values, into the following

cells: B20, D21, B22 (assume a tax rate of 35%), and D27.

9. Print the worksheet.

Do not print equations or the contents of each cell. The pages you submit should report final results, revealing the business output (such as dollar values) of a financial statement.

Pages must be assembled in proper sequence and be stapled or clipped together.

Grade Value: 15 points

Submission date:

NO LATE ASSIGNMENTS WILL BE ACCEPTED.