![]() 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 |