The bonus rates for each salesperson are determined by sales amounts using the following scale:. Sales greater than $35,000 earn a bonus rate of 5%, sales greater than $25,000 earn a bonus rate of 4%.
All other sales (any amount greater than 0) earn a bonus rate of 2%.
With the sheets still grouped, in cell C5 use an IFS function to determine the commission rate for the first salesperson whose sales are in cell B5.
Fill the formula down through cell C8.

Biochemical corp. requires $600,000 in financing over the next three years. the firm can borrow the funds for three years at 10.80 percent interest per year. the ceo decides to do a forecast and predicts that if she utilizes short-term financing instead, she will pay 7.50 percent interest in the first year, 12.15 percent interest in the second year, and 8.25 percent interest in the third year. assume interest is paid in full at the end of each year. a)determine the total interest cost under each plan. a) long term fixed rate: b) short term fixed rate: b) which plan is less costly? a) long term fixed rate plan b) short term variable rate plan