Show working out please or share a link with an excel file to how it was done with excel macros...both would be good as well if possible.

Question 22 0" 5 pt Consider the following two projects for Copper Mountain Sports. Both project are projected to produce cash flows for 5 years at which time the equipment will have been technologically obsolete. For these projects calculate the "cross-over rate", The cross -0\ er rate is the discount rate where both project would have the same NPV. Year Snow Shoes Snowmobiles 0 $250,000 $250,000 1 $25,000 $150,000 2 $80.000 $1 60,000 3 $200,000 $75,000 4 $190,000I $50,000 5 $150000 $5000 This Problem Counts 5 Points 32. 30% 33. 53% 3 3. 6?"?11 13. 5 5% T1050 two projects do not have a cross-over rate