Question: CF Probibility Expected CF Total Expected CF Year Good Bad Good Bad Good Bad 0 41000 41000 50% 50% -41000 1 28500 2000 50% 50%

 CF Probibility Expected CF Total Expected CF Year Good Bad Good

CF Probibility Expected CF Total Expected CF
Year Good Bad Good Bad Good Bad
0 41000 41000 50% 50% -41000
1 28500 2000 50% 50% 14250 1000 15250
2 28500 2000 50% 50% 14250 1000 15250
3 28500 2000 50% 50% 14250 1000 15250
Expected NPV $ (4,372.07)

Please help me answer the questions using excel. this is as far as I can get.

St. Margaret Beer Co. is considering a three-year project that will require an initial investment of $41,000. If market demand is strong, St. Margaret Beer Co. thinks that the project will generate cash flows of $28,500 per year. However, if market demand is weak, the company believes that the project will generate cash flows of only $2,000 per year. The company thinks that there is a 50% chance that demand will be strong and a 50% chance that demand will be weak. If the company uses a project cost of capital of 12%, what will be the expected net present value (NPV) of this project? (Note: Do not round intermediate calculations and round your answer to the nearest whole dollar.) $5,246 $4,372 $4,591 $3,716 St. Margaret Beer Co. has the option to delay starting this project for one year so that analysts can gather more information about whether demand will be strong or weak. If the company chooses to delay the project, it will have to give up a year of cash flows, because the project will then be only a two-year project. However, the company will know for certain if the market demand will be strong or weak before deciding to invest in it. What will be the expected NPV if St. Margaret Beer Co. delays starting the project? (Note: Do not round intermediate calculations and round your answer to the nearest whole dollar.) $7,571$3,839$3,199$2,879 What is the value of St. Margaret Beer Co.'s option to delay the start of the project? (Note: Do not round intermediate calculations and round your answer to the nearest whole dollar.) $3,839 $7,571 $3,199 $2,879 St. Margaret Beer Co. is considering a three-year project that will require an initial investment of $41,000. If market demand is strong, St. Margaret Beer Co. thinks that the project will generate cash flows of $28,500 per year. However, if market demand is weak, the company believes that the project will generate cash flows of only $2,000 per year. The company thinks that there is a 50% chance that demand will be strong and a 50% chance that demand will be weak. If the company uses a project cost of capital of 12%, what will be the expected net present value (NPV) of this project? (Note: Do not round intermediate calculations and round your answer to the nearest whole dollar.) $5,246 $4,372 $4,591 $3,716 St. Margaret Beer Co. has the option to delay starting this project for one year so that analysts can gather more information about whether demand will be strong or weak. If the company chooses to delay the project, it will have to give up a year of cash flows, because the project will then be only a two-year project. However, the company will know for certain if the market demand will be strong or weak before deciding to invest in it. What will be the expected NPV if St. Margaret Beer Co. delays starting the project? (Note: Do not round intermediate calculations and round your answer to the nearest whole dollar.) $7,571$3,839$3,199$2,879 What is the value of St. Margaret Beer Co.'s option to delay the start of the project? (Note: Do not round intermediate calculations and round your answer to the nearest whole dollar.) $3,839 $7,571 $3,199 $2,879

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!