Excel

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 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. Please complete only 5 of the 10 mini projects. Each miniproject 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. Using you must also do written part for each mini project, making a recommendation based on the results that you obtain in Excel. Be thorough, include an introduction and conclusion to the whole body of the miniproject.

MiniProject List:

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 today and he will invest it for them.

Excel:

You'll need to demonstrate the present value of the $30 today versus the future value of the $25 million in 5 years to make your argument.