Please solve in excel and include the formula

1. Indiana Jones finds an ancient Chinese bracelet that is worth $100,000 today. In one year, he finds a ring worn by King James that is worth $290,000. In five years, he finds a necklace that was a gift to Princess Katya that is worth $150,000. Each appreciates in value by 7.2% per year. What is the total value of the jewelry exactly 20 years from today? 2. Indiana Jones invests $57,000 in a financial asset that earns 6.1% annually. Jones wants to use that money as a down payment on a villa in Bermuda that he will purchase in 4 years. The villa will cost $600,000 and Jones will take out a 9 year loan at 4.6%. Compute the monthly payment on the loan. 3. Indiana Jones pays $230,000 today for a boat that is able to travel through thick ice. He uses the boat to explore the North Pole. Over the next five years, Jones finds enough gold in the ice to generate annual cash flows of $55,000. The risk-free rate of interest is 3%, the market return is 9%, and Jones can borrow at 5%. Compute the NPV and the MIRR of the asset (boat).4. Indiana Jones eats 7 spiders on a trip to Africa, 12 spiders on a trip to Spain, 11 spiders on a trip to Vietnam, 8 spiders on a trip to Canada, and 14 spiders on a trip to the US. Compute the average number of spiders eaten, the standard deviation, and the probability that Jones will eat more than 13 spiders on his next trip. 5. Indiana Jones hopes to save every quarter (beginning today) so that he can purchase a team of special horses for a trip through the Sahara Desert. He will make this trip in exactly one and one-half years and the horses are expected to cost $50,000. The interest rate is 3.8%. Compute his quarterly annuy