BIU A- Merge & Center $ % 1.00 Paste Format Painter Clipboard Conditiona Formatting Font Alignment Number F30 7.50% A B D E F. G H 1 What if analysis 2 Bonus 200000 3 comission 5.75% 4 Margin 57.50% 5 Marketing 15.00% 6 Research and development 7 Sales Revenue For Bonus 3500000 8 Support, General, Adminstrative 0.1875 9 10 Modern, music shops 11 Six months Financial Projection 12 July August September October November December Total 13 Revenue 3113612.16 7962235.53 5112268.58 2924627.87 7630534.65 3424270.23 14 cost and goods sold 15 Gros margin 16 17 comission 18 Marketing 19 Reserch and Development 20 Support, General, Adminstrative 21 Total Expenses 22 23 Operating Income 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Sheet1 Sheet2 Sheet3 Ready Type here to search o E HII File Home Insert Page Layout Formulas Data Review View % Cut Ea Copy Calibri 11 A A = Wrap Text General Paste B I U Merge & Center $ % Format Painter Clipboard Font 5 Alignment Number Formulas Data Normal Bad Good Neutral Calculation File Home incert Page Layout X Cut Calibri Copy Paste Format Painter BIU Clipboard Font 329 . -A AN A. Review View Wrap Text General Merge Center$.%. Alignment Number 4 Conditional Format Formatting Table Check Cell Input insert De Form Explanatory Followed H. Hyperlink Shtes B D E F 200000 0.0575 0.575 0.15 0.075 3500000 0.1875 Dece 342 July 3113612.16 =B13*(1-$B$4) =B13-314 August 7962235.53 =C13"(1-$B$4) =C13-014 September 5112268.58 =D13"(1-$B$4) B =D13-014 October 2924627.87 =E13"(1-$B$4) =E13-E14 November 7630534.65 =F13*(1-$B$4) =F13-F14 G1 G1 1 What if analysis 2 Bonus 3 comission 4 Margin 5 Marketing 6 Research and development 7 Sales Revenue For Bonus 8 Support General Adminstrative 9 10 Modern, music shops 11 Six months Financial Projection 12 13 Revenue 14 cost and goods sold 15 Gros margin 16 17 comission 18 Marketing 19 Reserch and Development 20 Support General Adminstrative 21 Total Expenses 22 23 Operating Income 24 25 26 27 28 29 30 31 32 33 34 HH Sheet Sheet2 Sheet3 Ready =B13"$B$3 =B13SB95 =B13'5856 =B13 $B$8 =SUM(B17:320) =C13'$B$3 =C13'B$5 =C13'$B$6 =C13"$B$8 =SUM(C17:020) =D13 $B$3 =D13'$B$5 =D13 $B$6 =D13"$B$8 =SUM(D17:020) =E13"$B$3 =E13"$B$5 =E13"$B$6 =E13"$B$8 =SUM(E17:20) =F130$B$3 =F13$B$5 =F13$B$6 =F13 $B$8 =SUM(F17:F20) G1 =G1 G1 =G1 =SU =B15-B21 C15-021 =D15-021 =E15-E21 =F15-F21 GT Type here to search o e L W Instructions Merge and center A1 to B1 Vir Wrap Test Normal Calculation AutoSum General S- %. Conditional Format Formatting Table Bad Good Neutral Damlanatory followed H. Hyperlink Check Cell Input Insert Delete Format Clear Merge a Center Allan Sort & Find a For Seled Editing Cell B D F G H 200000 0.0575 0.575 0.15 0.075 3500000 0.1875 July 3113612.16 =B13' (1-$B$4) =B13-814 August 7962235.53 =C13"(1-5854) =C13-C14 September 5112268.58 2013 (1-$B$4) =D13-014 October 2924627.87 =E13' (1-$B$4) =E13-14 November 7630534.65 =F13"(1-SB$4) =F13-F14 December 3424270.23 =G13' (1-$B$4) =G13-614 Total =SUM(B13:13) =SUM(B14:614) =SUM(815:15) =B13"$B$3 =813"$B$5 =B13'$B$6 =813"$B$8 =SUM(B17:320) =C13"$B$3 =C13"$B$5 =C13"$B$6 =C13"$BSS =SUM(C17:020) =D13 $B$3 =D13$B$5 =D13 $B$6 =D13$B$8 =SUM(D17:20) =E13*$B$3 =E13 SBSS =E13 $B$6 =E13"$B$8 =SUM(E17:E20) =F13 $B$3 =F13"$B$5 =F13"$B$6 =F13 $B$8 =SUM(F17:F20) =G13*$B$3 -G13"$B$5 =G13"$B$6 =G13 $B$8 =SUM(G17:520) =SUM(817:417) =SUM(B18:G18) =SUM(B19:19) =SUM(B20:G20) =SUM(B21:421) =815-821 c15-11 2015-021 =E15-E21 =F15-F21 =G15-G21 =H15-H21 120% W 9 d) ENG 11:46 AM 2020-06-21 B1 Instructions Merge and center A1 to B1 Apply percent style from B3 to B6 and B8 Merge and center A10 to H10 A10 to H10 font size 36 and purple background color Merge and center A11 to H11 A11 to H11 font size 18 and purple background color Rotate Headings B12 to H12 anticlockwise B13 to H13 apply accounting style B14 to H20 apply comma style A21 to H21 apply Total style B23 to H23 apply Currency style TIL 0 T