Calculations (rows 24 to 55): Calculate intermediate results of benefits (cash inflows) and costs (cash outflows) for NP

[answerhappygod]

Calculations (rows 24 to
55): Calculate intermediate results
of benefits (cash inflows) and costs (cash outflows) for NPV
analysis.
Net Present Value (NPV) calculation (rows 58 –
61): This is based on the net cash flows in the
5-year investments. The net present value of an investment is
calculated by using a discount rate and a time series of payments
/costs (negative values) and income/benefits (positive values). The
net cash flow in a year is the difference between cash inflows (or
investment benefits) and cash outflows (or costs). Formulae for
rows 58 to 61 are given, their descriptions are given below;
Net present value (cell B61): Use Microsoft Excel’s function -
NPV(), to calculate the NPV at 25% discount rate (row 18) for the
5-year contract with BI if the call centre is off-shored to
India.
PLS ANS C24 TO C55

Calculations Rows 24 To 55 Calculate Intermediate Results Of Benefits Cash Inflows And Costs Cash Outflows For Np 1 (242.24 KiB) Viewed 106 times

2021 =INT(B24*1.02) =INT(B25*1.01) =INT(C24*C10) =IF(C20="F", C25*0.1, C25*0.25) NA NA NA 2022 2023 2024 2025 Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste [2 marks] Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste =INTO [3 INT(number) [3 marks] [1 mark] [1 mark] [2 marks] [1 mark] Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste NA NA NA NA NA NA NA NA NA NA NA [1 mark] [1 mark] [2 marks] 3 CALCULATIONS 2020 4 NUMBER OF U.S. EMPLOYEES 800 5 NUMBER OF INDIAN EMPLOYEES 800 6 NEW U.S. EMPLOYEES 7 INDIAN EMPLOYEE TURNOVER RATE 8 NEW INDIAN EMPLOYEES 9 AVERAGE INDIAN EMPLOYMENT COS 16000 0 NUMBER OF RUPEES PER U.S. DOL 45.85 1 INDIAN EMPLOYMENT COST: 2 INDIAN EMPLOYMENT COST (US$) 3 INDIAN EMPLOYMENT COST (RUPEE 4 ACTUAL US$ NEEDED FOR INDIAN E 5 COST OF LIAISON EMPLOYEES in U. 6 INDIAN LIAISON EMPLOYEE COST: 7 COST OF LIAISON EMPLOYEES in INI 8 PAYMENT FOR INDIAN LIAISON EMPL 9 ACTUAL US$ NEEDED FOR INDIAN LI 0 INDIAN BACKGROUND CHECK COST 1 COST OF BACKGROUND CHECKS in 2 PAYMENT OF INDIAN BACKGROUND 3 ACTUAL USS NEEDED FOR INDIAN B. 4 INDIAN TRAINING COST: 5 COST OF TRAINING INDIAN WORKER 6 PAYMENT OF INDIAN TRAINING (RUPI 7 ACTUAL US$ NEEDED FOR INDIAN TI 8 COST OF BACKGROUND CHECKS IN 9 U.S. TELECOMM COSTS 0 U.S. COMPUTER COSTS 1 U.S. REAL ESTATE COSTS 2 U.S. TRAINING COSTS 3 NUMBER OF U.S. SUPERVISORS 4 U.S. SUPERVISORY COSTS 5 COST OF U.S. EMPLOYEES 6 Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste NA NA [1 mark] [1 mark] [2 marks] Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste NA NA NA NA NA NA NA NA NA NA NA NA [1 mark] [1 mark] [2 marks] [1 mark] [1 mark] [1 mark] [1 mark] [1 mark] [1.5 marks] [1 mark] [1 mark] Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste Copy & paste