(1) In Range F2:K2, please type the sales volumes from 500 to 1750 Prepare the sensitivity analysis table as below screenshot shown: (4) In Cell B14, please type the formula =B13-B6-B7.Ģ. (3) In Cell B13, please type the formula =B11-B12 ![]() (2) In Cell B12, please type the formula =B5*B3 (1) In Cell B11, Please type the formula =B4*B3 ![]() Finish the Profit & Loss Statement table as below screenshot shown: This method will apply the Data Table feature to do a sensitivity analysis in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |