This is 4 part project, the first 2 has been done and I require the next 2. This is an investment class project, so, basically what we are doing is that hypothetically I have 1 million dollars to invest in 5 stocks (the name of the stocks, amount invested, starting dates are mentioned in the excel). Below are the two parts which I require seprately.
Part 3 of the Project is about tracking the stock price during the semester and recording the data on a spreadsheet, analyzing and presenting the data for each of your stocks in graphic form.
Instructions are as follows:
Project Part 3. Track your portfolio and companies throughout the term and on the Discussion Board, describing the stocks and their performance. Use the requirements for the Discussion Boards defined above. Also discussed would there be any changes you have made in your portfolio. (This Part is 30% of 30 points for your Project grade or 9 points total and also counts toward Discussion Board/Class Participation).
Keep up with the performance of your portfolio and major news, both domestic and globally, concerning your stocks. You will regularly discuss and review your portfolio on the Discussion Board (DB). You will do this referring to domestic and global events including the performance of international financial markets that affect your stocks and your portfolio. This requires that you check the DB regularly. On the DB, explain why you have requested any trade. This should be fun and these are easy participation points!
An easy way to set up your portfolio is to track it in Yahoo finance or Google finance, but you can also record the prices in a spreadsheet yourself this will help later.
Part 4
Purpose of Assignment (WHY)
The purpose of this fourth assignment in the 4-Part Project is to familiarize the FIN 3340 student with the process of investing through the US stock market, also called the equities market (to distinguish the market for trading equities from the market for trading bonds which are debt). The stock trades that will be made by each student are designed to gain experience in a controlled environment investing hypothetical funds and transferring those skills to future actual funds held by students or the student as the representative of a corporation including the research analytics that encourages a better investing result, the markets investors use, the specifics of trading language and trading process and the ability to understand the reasons trades were made and analysis of the performance of the trades after the trades have concluded.
Program Competencies
Global
Program Learning Outcome
PLO4: Assess the structure and functions of the U.S. and international financial markets and institutions.
Course Learning Outcomes
Apply risk-return analysis in making decisions on stock ownership.
Analyze the performance of individual and portfolio investments.
Understanding how and why a student personally chooses an investment provides a greater understanding of what investment criteria is important to that student; what emotional factors affect that student (example: are they a risk taker or risk avoider), what types of firms is the student interested in for investing (examples; what industry, what size, level of technology, geographic location). Additionally, the student will learn to organize and track the investments made in the class structure with a global perspective in mind.
Assignment Description (WHAT)
For this Part, you will be making a report to your investment committee that discusses and summarizes the performance of your stock portfolio. Use closing prices as of Thursday of Week 13, Dec 2, to calculate your returns. What is the final market value of your portfolio (including dividends received and added to non-interest earning cash)? If the final market value of your portfolio is less than $1,000,000, your portfolio lost money.
Provide a graph of the daily stock prices (high, low, and closing) for each of your stocks. Include the volume on each graph, with the scale shown on the right side of the graph. Be sure to label the graphs!
Provide a graph of the value of your portfolio and the value of the closing S&P 500 if $1,000,000 were invested in that initially. This is the normalized value. By normalized, you have scaled the S&P 500 closing prices so that its price on the first day ($1,000,000) is the same as the portfolios closing price on that first day.
In the final section of your report, recommend for or against the inclusion of each of these stocks in the portfolio and defend your recommendation. Use the information you have obtained in Part 1 Deliverable 2 to support your argument.
Calculations: Use the closing price of your stocks on Thursday of Week 13, Dec 2, to calculate your returns.
1. Report the purchase and sale price of your stocks from the beginning and end of the semester along with any dividends you might have received. Calculate the buy-and-hold return of each stock [(MVend MVbeginning + DIV) / MVbeginning] and the buy-and-hold return on your portfolio.
2. Determine the final market value of your portfolio (including dividends received). If the final market value of your portfolio is less than $1,000,000, your investment lost money.
3. Calculate the market value of
1. Your portfolio for each day (including cash). I suggest that you do this by adding up the daily closing market values of your assets held and the cash you hold, including the total dividends received up to date.
2. The S&P 500 index portfolio over this same period assuming you keep the same amount in cash. We are using the S&P 500 index as our proxy for the market.
4. Plot the daily market value of your portfolio and the daily market value of the S&P 500 using your calculations in #3.
5. Using the market values you calculated in #3, calculate the daily returns (percent) for
1. your portfolio
2. The S&P 500 index portfolio.
6. Using your calculations in #5, calculate
1. The average daily return and the standard deviation of daily returns for both the S&P 500 index and your portfolio.
2. your portfolios beta by calculating the covariance of your portfolios daily returns with the S&P 500s daily returns and dividing that by the variance of the S&P 500.
Write-up: Assume that you are preparing a relatively short report (maximum of 10 pages double-spaced) for your investment committee. You will be graded on the quality of your writing as well as the quality of your analysis. Do not simply answer the following questions this should be financial report! These questions are intended to provide guidance.
1. Introduction
2. Comment on the individual and portfolio returns and on any information/events (market-wide or firm-specific) that may have contributed to the performance of your stocks. Describe and explain any trades you made. (Suggested length: a short, concise paragraph for each stock).
3. From your calculations, if you held the S&P 500 instead of your stocks, how much money would you have ended up with? Would you have been better or worse off to hold the index? Analyze the reasons for any differences.
4. Based on your calculations for standard deviation and beta, how risky was your portfolio compared to the index? Again, analyze the causes of the differences.
5. Finally, what are your plans going forward? That is, if this class continued and you had the chance to alter your portfolio holdings now, would you choose to sell any of your stocks or would you want to keep holding them? What will you tell the investment committee? Be explicit.
Deliverables:
1. Your report (8 – 10 pages double-spaced, 12 pt. font) plus graphs.
2. Spreadsheet of returns and calculations, and market value plot 2-pages maximum make it neat and readable.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
Ace Writing Center has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
Essays
At Ace Writing Center, Nowadays, students normally have extremely busy schedules. You will note that some of them have to take on some evening or weekend jobs in order to get some income that can help them to sustain in college or in the university. This can deny them a chance to write all the essays given. Others usually get bombarded with a lot of work by their lecturers. This can still delay such students from working on all their essays. However, some of them usually try to work on all these essays but end up delivering their work late. This can prevent them from graduating since most lecturers are strict on deadlines. If you want to write a business essay, the wise way is to hire an outstanding essay writing service like us, so that you can get the best results. If you are keen, you will note that many companies usually overcharge their customers. Some of them are there only to make money. And in reality, they really don’t care to build a long term commitment with students. You should not choose such companies. You should take your time and choose a reliable company to work with. Ace Writing Center is the ultimate solution for you. We have been offering our writing service for more than 7 years. This is a clear indication that you will get quality essay writing service. We have a wide range of writers who can work on any business essay that you might have. We believe in doing extensive research so that we can provide quality work to all our clients. .
Admissions
Admission and Business Papers
Have you ever had to write an admission essay for college? The majority of students face the same issues when applying to a university or college and many in such situations decide they need professional help to cope with this matter. They get in a situation when the deadline keeps coming closer but lack motivation to start because they are just not sure if their writing skills are strong enough. We have a solution for you! Ace Writing Center is the best admission essay writing service with a large professional team and years of experience in providing high-quality papers to students of all levels and faculties. The mission of our team is to help students make their dreams of entering a good college come true and that’s what we offer!.
Editing
Editing and Proofreading
Sometimes all the words for your paper just flow out of your mind and into your fingers. You type quickly at your keyboard and there they are, your beautiful words right there on the screen. But you have no idea how to polish it up. You may be wishing there was a paper writing service that offered this type of writing service. Look no more! Here at Ace Writing Center, we offer you an editing and proofreading option that you can't find anywhere else..
Coursework
College Essay Writing
In case you are familiar Ace Writing Center, you know the way to distinguish a better company from a cheap one exactly. First of all, poor service website does not have a sufficient support. We think support team is an essential part of success; it has to answer all clients’ questions and be a connecting link between clients and their writers. On our web-service you will get answers about anything you need and your writer will receive all your instructions, assignments and requirements exactly and swiftly. A writing service that we run has got a flexible pricing system that will save you from senseless wastes and many bonus systems that let you sparing money for something important for you.