Chapter 1, Problem 2.11CP

Ss.227. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell D9.

Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below.   Sales ($)                       Commission 1–5,999.99                   10% of sales 6,000–29,999.99          $600 plus 13% of the sales over 6,000 30,000 and over           $3,720 plus 14% of the sales over 30,000   Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000.   $700 if the salesperson travels.   Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total due

Use the _____________ function to calculate cumulative interest paid for a loan with 5 year period. CUMIPMT()   PMT   CUMFREQ()   none of the choices   CUMPRIN()