This project brings together many of the objectives and concepts that you have covered in the course. This project is worth 300 points and 30% of your grade.  It must be completed and submitted by the date specified in the Academic Calendar.

 

Project Directions

 

Complete the activities specified in the Financial Markets I project guide.  Using the data that you download in the guide, apply the Black Scholes Model (using Excel). You have to do additional research and seek resources to complete the project:

 

1. Calculate the price of a call option using the Black Scholes model implemented earlier in Excel

 

2. Implement the Binomial Option Pricing Model in Excel

 

3. Download the oil price data, and calculate the average oil price, minimum and maximum, for the period given, identify factors that may contribute to the oil price changes for the period, and propose a trading strategy for oil prices

 

To help you, use the Support Files in the following spreadsheet.

 

Project Notes

 

• Cite at least three sources
• Use the rubric to review the project requirements  
• This project is worth 300 points or 30% of your overall grade

 

Submission Requirements

 

• Your submission should include the following two documents, uploaded in a single ZIP file:
1. A Word document with your three paragraph summary
2. An Excel spreadsheet outlining your results and your analysis of those results.

 

Instructions for Submitting Your Project

 

• Create one (1) ZIP file from the required Microsoft Word and Microsoft Excel documents
• Use the following naming convention Your_Name-Assignment_Name-Date with the ZIP file extension
• Example: Instructor-Final_Project-May_12_2016.zip
• Upload the single ZIP file below. Your project file must be fully uploaded before the deadline published in the course.
• If your coursework is submitted on time and correctly, the name of the uploaded file will be shown.

 

Note: Submitting more than one file will overwrite (delete) the previously submitted file. 

 

Attachments:

• 1523215983-Sample-Spreadsheet-Capstone-FMI.xlsx
• 1523216440-Financial Markets I Final Project Guide.docx