using excel please

- A company is evaluating four new technologies (A, B, C, D) to produce a new product. The payoffs for each technology are dependent on the eventual success of the new product, as noted in the payoff table below (dollar amounts are present values in millions). New product New product New product moderately highly Technology unsuccessful successful successful $20 $25 $40 B -$10 $30 $50 -$40 $35 $80 D -$80 $40 $100 A Based on market analysis and other factors, management estimates the probabilities of the levels of success of the product as P(Unsuccessful) = 0.2, P(Moderately successful) = 0.6, and P(Highly successful) = 0.2. Compare the alternatives using the expected monetary value (EMV) criterion, and clearly indicate which alternative should be selected. [8 points) Develop a model that will compute an amortization schedule for a 48-month installment loan. Your model should allow you to enter any loan amount and nominal annual interest rate. Create a table showing (for each of the 48 monthly periods) the beginning balance, interest owed, principal paid, total payment and ending balance. Use your model to compute the monthly payment amount and amortization schedule for the following values [8 points): Amount borrowed: $35,000 Nominal interest rate: 8.0% percent per year