Microsoft Teams Edit View Window Help OO AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View X 12 ( Calibri (Body) BIUV Wrap Text v Merge & Centre Insert v x Delete v Format v Paste V Av = = = +=+= Cell Conditional Format Formatting as Table Styles Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? C29 x B C D E F G H I J K L M 89 90 91 92 Exercise 5. 93 A company is looking at launching a new business line and is considering the following options: country A or country B, with the following initial investments and expected cash flows: 94 95 Product A 650.000 Product B 810.000 96 II (initial investment) 97 year 1 310.000 205.000 98 year 2 200.000 175.000 99 year 3. 50.000 155.000 100 year 4 150.000 365.000 101 102 Where should the company expand, A or B, according to the payback period and IRR of each project? 103 Considering that the discount factor is 4%, calculate the net present value and benefit cost ratio for each project and advise. 104 105 106 107 108 109 110 111 112 113 114 115 Formulas + 0 20 BA #tv 9 T Ready A Task brief 2 0122 BC0222 FINAL task brief Bus Finance II Tell me General C%9 MEN 1 Share WE Mon 2 May 15:22 Q Comments No v Sort & Filter O Find & Select Yes N 125% Y