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.

PRINCIPLES OF FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Jackson Products Company Tarheel Furniture Company 1. Retrieve the file CFMO310P.XLS. 2. Enter the appropriate equations, not values, into the following cells: D10, D26, 039, D42, 152, D54, D56, D60, D62, D66, 070, 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. PRINCIPLES OF FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Jackson Products Company Tarheel Furniture Company 1. Retrieve the file CFMO310P.XLS. 2. Enter the appropriate equations, not values, into the following cells: D10, D26, 039, D42, 152, D54, D56, D60, D62, D66, 070, 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