FINANCE HOMEWORK

PRINCIPLES OF FINANCIAL ANALYSIS

SPREADSHEET ASSIGNMENT: Jackson Products Company

Tarheel Furniture Company

1. Retrieve the file CFM0310P.XLS.

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

cells: D10, D26, D39, D42, D52, D54, D56, D60, D62, D66, D70,

D72, and D74.

3. Print the worksheet.

4. Suppose Jackson Products Company managed its working capital to

include $140,000 less inventory and $60,000 of reduced accounts

receivable, enabling $100,000 of notes payable to be repaid and

$100,000 of additional cash balances. Enter these four changes

into their respective cells.

5. Print the revised worksheet.

6. Retrieve the file CFM0306P.XLS.

7. Right-align cells A13 and A22 and center cells A27 and A39.

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

cells: C13, C22, C32, C58, and C77.

9. Print the worksheet.

Grade Value: 15 points

Submission date:

NO LATE ASSIGNMENTS WILL BE ACCEPTED.