USING EXCEL,

Liz's Health Food Store has estimated monthly financing requirements for the next six months as follows: Short-term financing will be utilized for the next six months. Projected annual interest rates are: a. Compute total dollar interest payments for the six months. To convert an annual rate to a monthly rate, divide by 12 . (Round intermediate calculations and final answers to 2 decimal places.) Total dollar interest payments $ b-1. Compute the total dollar interest payments if long-term financing at 12 percent had been utilized throughout the six months. Assume a long-term rate is locked in on an interest-only loan. Total dollar interest payments $ b-2. If long-term financing at 12 percent had been utilized throughout the six months, would the total-dollar interest payments be large or smaller? Smaller Larger