J K A B D E F G 10 Data Table for 'EXCEL Financial Functions' Sheet 11 12 Annual Growth Rate 6% 13 Discount Rate 10% 14 15 Growth 16 2%. 4% 6% 87 10%. 17 6% 18 8% 19 Discount Rate 10% 20 12%. 21 14% 22 23 Data Validation for 'EXCEL Financial Functions' Sheet 24 25 Use Data Validation on the green box below to limit entering any number beside a 'Whole number' between 1 and 5. 26 27 Use Data Validation on the green box immediately below to limit entering only the three values in the gray box below. 28 One Two Three 36 300 30 Data Table for 'MODEL Manufacturing Strategy' Sheet 31 32 Capacity Expansion 150 33 Discount Rate 12% 34 35 Capacity Expansion 100 150 37 38 Discount 10% 39 Rate 12% 40 14% 41 42 Data Table for 'MODEL Product Introduction' Sheet 43 Months to Advertise All 45 Monthly Growth 1.0% 46 47 Months to Advertise 48 0% All Exclude Deo 49 Monthly 1.02 0% 02 50 Growth 1.5% 0% 02 51 J K A B D E F G 10 Data Table for 'EXCEL Financial Functions' Sheet 11 12 Annual Growth Rate 6% 13 Discount Rate 10% 14 15 Growth 16 2%. 4% 6% 87 10%. 17 6% 18 8% 19 Discount Rate 10% 20 12%. 21 14% 22 23 Data Validation for 'EXCEL Financial Functions' Sheet 24 25 Use Data Validation on the green box below to limit entering any number beside a 'Whole number' between 1 and 5. 26 27 Use Data Validation on the green box immediately below to limit entering only the three values in the gray box below. 28 One Two Three 36 300 30 Data Table for 'MODEL Manufacturing Strategy' Sheet 31 32 Capacity Expansion 150 33 Discount Rate 12% 34 35 Capacity Expansion 100 150 37 38 Discount 10% 39 Rate 12% 40 14% 41 42 Data Table for 'MODEL Product Introduction' Sheet 43 Months to Advertise All 45 Monthly Growth 1.0% 46 47 Months to Advertise 48 0% All Exclude Deo 49 Monthly 1.02 0% 02 50 Growth 1.5% 0% 02 51