Unformatted text preview: MONTHLY RATE OF INCREASE IN SALES REVENUE 6.20% MONTHLY RATE OF INCREASE IN CONSULTING INCOME 2.00% MONTHLY RATE OF INCREASE IN SALARIES 5.00% MONTHLY RATE OF DECREASE IN COST OF EQUIPMENT 3.50% MONTHLY RATE OF INCREASE IN INSURANCE COSTS 1.80% low tax rate 4.00% high tax rate 8.50% limit on gross income for low tax rate $1,100,000 TAXES SHOULD BE CALCULATED DIFFERENTLY, BASED ON GROSS INCOME. WHEN GROSS INCOME IS LESS THAN 1.1 MILL, USE TAX RATE OF 4%, OTHERWISE USE TAX RATE OF 8.5% IF statement - conditional statement in Excel IF(condition, formula to use when cond is true, formula to use when cond is false) if(gross income<1.1 mill, gross income*4%, gross income*8.5%) TOTALS FOR 6 MONTHS...
View Full Document
This note was uploaded on 12/03/2011 for the course MIS 240 taught by Professor Ezwa during the Fall '11 term at Lindenwood.
- Fall '11