You are the newest financial analyst in investments, you need to demonstrate your prowess in excel, your outstanding written skills and ability to communicate. mr. richards is the executive vice president and chief investment officer in your new firm. you are being asked to complete a series of "pet" projects for mr. richards. you have been told not to try to impress him, just do the work and stick to the facts. there are ten mini-projects for you to complete. each mini-project needs to have its own tab in an excel spreadsheet. it is critical to use cell referencing and the standard setup for tvm problems provided, he’s a stickler and wants to see all of the detail. mini-projects 1. a friend of mr. richards recently won a law suit for $30 million. they have the ability to either take the payments over 10 years or settle today for cash of $25 million today. mr. richard is optimistic that he can earn a 6% return on the money and that they should settle for $25 million today and he will invest it for them. excel: you’ll need to demonstrate the present value of the $30 million today versus the future value of the $25 million in 5 years to make your argument.