Question: please solve step by step in excel please show how to do IN EXCEL please show how to do 8 IN EXCEL 8. Teletech Co.

please show how to do IN EXCEL please show how to do 8 IN EXCEL 8. Teletech Co. sasts to uac a decition tree in evaluating a vearure capital inveitmeat in cable TV. The projected invectment has a life of three jears, asd the anceitied afteratat cash flows (5000) and probabtitics are as follows. 4. Constract in dectuice bee with the ropectes STV of each aiteraane t. Ghat il the copected NPV of the beit pointis estoone? What ar its spobabitity? 7. Peter to the 5tarthp poritct in Secrien 12 10. The following exhibit contains Beech's estimates of demand, price, and fived and variabie costs for the Starhip under three alternative economic forecain. - Dotilar in millions a. If all other variabies are assumed to be at their expecied value (normal foceart), hor sentitive in the propet's NPV to changes in fieed cout? Uhe a cost of capital of toth mas raloof 15 th, and project life at 10 years. th. How ucntitive a the project's NPY to changes in price? c. How unsitive a the project' NPV ro changts in variable cont? e. Is the Staribip is taky projeet? Explain please show how to do IN EXCEL please show how to do 8 IN EXCEL 8. Teletech Co. sasts to uac a decition tree in evaluating a vearure capital inveitmeat in cable TV. The projected invectment has a life of three jears, asd the anceitied afteratat cash flows (5000) and probabtitics are as follows. 4. Constract in dectuice bee with the ropectes STV of each aiteraane t. Ghat il the copected NPV of the beit pointis estoone? What ar its spobabitity? 7. Peter to the 5tarthp poritct in Secrien 12 10. The following exhibit contains Beech's estimates of demand, price, and fived and variabie costs for the Starhip under three alternative economic forecain. - Dotilar in millions a. If all other variabies are assumed to be at their expecied value (normal foceart), hor sentitive in the propet's NPV to changes in fieed cout? Uhe a cost of capital of toth mas raloof 15 th, and project life at 10 years. th. How ucntitive a the project's NPY to changes in price? c. How unsitive a the project' NPV ro changts in variable cont? e. Is the Staribip is taky projeet? Explain
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
