I NEED ALL CALCULATIONS TO GET THE ANSWER SHOWN IN EXCEL OTHERWISE THE ANSWER IS NO GOOD TO ME. PLEASE SHOW ALL WORK

1) Arnold Inc. purchases merchandise on terms of 2/10 net 30, and it always pays on the 30th day. The CFO calculates that the average amount of costly trade credit carried is $375,000. What is the firm's average accounts payable balance? (Assume a 365-day year.)

2)Palmer Company has $5,000,000 of 15-year maturity bonds outstanding. Each bond has a maturity value of $1,000, an annual coupon of 12.0%. The bonds can be called at any time with a premium of $50 per bond. If the bonds are called, the company must pay flotation costs of $10 per new refunding bond. Ignore tax considerations-assume that the firm's tax rate is zero. The company's decision of whether to call the bonds depends critically on the current interest rate on newly issued bonds. What is the breakeven interest rate, the rate below which it would be profitable to call in the bonds?

3)McGovern Enterprises is interested in issuing bonds with warrants attached. The bonds will have a 30-year maturity and annual interest payments. Each bond will come with 20 warrants that give the holder the right to purchase one share of stock per warrant. The investment bankers estimate that each warrant will have a value of $10.00. A similar straight-debt issue would require a 10% coupon. What coupon rate should be set on the bonds-with-warrants so that the package would sell for $1,000?