put in excel and please answer immediately there is a time limit for this exam.

IV. Determine the gross and networking capital for Covitna Company from the following balance sheet: (P000) Cash 2.250 Notes payable Accounts receivable 8.400 Accounts payable Inventory 6,150 Long-term debts Equipment, net 9.500 Owner's equity Total Assets 26.300 Total Equities 4,200 2,650 7,050 12.400 26,300 Required: a. Recompute the gross and networking capital under each of the following independent conditions: 1. Long-term debts of P500,000 is paid off. 2. New equipment costing P500,000, to boost production, is to be acquired and financed by new short-term debt. 3. Additional inventory of P250,000 is to be acquired on supplier's credit 4. Capital stock worth P250,000 are to be issued. b. Which among the conditions will improve Covitna Company liquidity position? Why? ANSWER: Present Gross working capital Current liabilities Net working capital