A B C D E F H 1 Ch27 Problem: In the following spinner control, figure out a way so you can use spin button in D6 to vary sales growth in C6) between - 10% and 20%. 2 3 4 taxrate 0.4 5 Year1 sales 10000 6 Sales growth 0.5 50 7 Year1 price $ 9.00 8 Year1 cost $ 9 intrate 10 costgrowth 11 pricegrowth 12 Year 1 13 Unit Sales 10000 14 unit price $ 9.00 $ 15 unit cost $ 6.00 $ 16 Revenues $ 90,000.00 $ 17 Costs $ 60,000.00 $ 18 Before Tax Profits $ 30,000.00 $ 19 Tax $ 12,000.00 $ 20 Aftertax Profits $ 18,000.00 $ 21 22 NPV $138,182.65 23 24 25 26 27 28 6.00 0.15 0.05 0.03 2 3 4 5 15000 22500 33750 50625 9.27 $ 9.55 $ 9.83 $ 10.13 6.30 $ 6.62 $ 6.95 $ 7.29 139,050.00 $ 214,832.25 $ 331,915.83 $ 512,809.95 94,500.00 $ 148,837.50 $ 234,419.06 $ 369,210.02 44,550.00 $ 65,994.75 $ 97,496.76 $ 143,599.93 17,820.00 $ 26,397.90 $ 38,998.71 $ 57,439.97 26,730.00 $ 39,596.85 $ 58,498.06 $ 86,159.96 A B C D E F H 1 Ch27 Problem: In the following spinner control, figure out a way so you can use spin button in D6 to vary sales growth in C6) between - 10% and 20%. 2 3 4 taxrate 0.4 5 Year1 sales 10000 6 Sales growth 0.5 50 7 Year1 price $ 9.00 8 Year1 cost $ 9 intrate 10 costgrowth 11 pricegrowth 12 Year 1 13 Unit Sales 10000 14 unit price $ 9.00 $ 15 unit cost $ 6.00 $ 16 Revenues $ 90,000.00 $ 17 Costs $ 60,000.00 $ 18 Before Tax Profits $ 30,000.00 $ 19 Tax $ 12,000.00 $ 20 Aftertax Profits $ 18,000.00 $ 21 22 NPV $138,182.65 23 24 25 26 27 28 6.00 0.15 0.05 0.03 2 3 4 5 15000 22500 33750 50625 9.27 $ 9.55 $ 9.83 $ 10.13 6.30 $ 6.62 $ 6.95 $ 7.29 139,050.00 $ 214,832.25 $ 331,915.83 $ 512,809.95 94,500.00 $ 148,837.50 $ 234,419.06 $ 369,210.02 44,550.00 $ 65,994.75 $ 97,496.76 $ 143,599.93 17,820.00 $ 26,397.90 $ 38,998.71 $ 57,439.97 26,730.00 $ 39,596.85 $ 58,498.06 $ 86,159.96