RETURN ON EQUITY AND QUICK RATIO

Lloyd Inc. has sales of $300,000, a net income of $33,000, and the following balance sheet:

Cash $38,400 Accounts payable $52,800

Receivables 84,480 Notes payable to bank 20,640

Inventories 211,200 Total current liabilities $73,440

Total current assets $334,080 Long-term debt 88,800

Net fixed assets 145,920 Common equity 317,760

Total assets $480,000 Total liabilities and equity $480,000

The new owner thinks that inventories are excessive and can be lowered to the point where the current ratio is equal to the industry average, 2.5x, without affecting sales or net income.

A) If inventories are sold and not replaced (thus reducing the current ratio to 2.5x); if the funds generated are used to reduce common equity (stock can be repurchased at book value); and if no other changes occur, by how much will the ROE change? Do not round intermediate calculations. Round your answer to two decimal places. %

B) What will be the firm's new quick ratio? Do not round intermediate calculations. Round your answer to two decimal places.

Could you show the work in excel so I can practice it.