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.
Attachment:- Worksheet.rar