Project #44049 - Intro to Finance

Assignment 2: Quantitative Exercises and Final Project 2: Portfolio Analysis

Part One: Quantitative Exercises  

In this part of the assignment, you will:

  1. Determine the value of stocks: preferred and common.
  2. Estimate the value of stock with high growth, and then estimate the value of stock with constant growth.
  3. Determine the components of stock valuation models.
  4. Determine the value of bonds paying annual and semiannual interest payments, and determine the yield to maturity of bonds paying annual and semiannual interest payments.

Download the Week 3 quantitative exercises calledFIN2030_W3_A2_Template.xlsx.

Complete the assignment using this template. You may use the formulas in Microsoft Excel and/or a financial calculator. Be sure to summarize your results with embedded formulas in the spreadsheet, using the mathematical equations, or the steps taken on the financial calculator.

Deliverable:

By Saturday, October 25, 2014, submit the completed assignment using the Microsoft Excel template provided, to the W3: Assignment 2 Dropbox. Show all your calculations.

Name your document SU_FIN2030_W3_A2_part1_LastName_FirstInitial.

Part Two: Final Project 2: Portfolio Analysis

Part A: Research Online Trading Sites and DRIPs

For this part of the assignment, you will evaluate the choices in purchasing stock via online brokerage accounts (where you can buy and sell stock via the Internet) and the use of dividend reinvestment plans (known as DIPs and DRIPs) or mutual funds or index funds.

For online brokers, you will be looking for the requirements to open the accounts: costs, minimum balances, and other features. Because most DIPs or DRIPs are available from publicly traded companies, you can search their Web sites or a search engine on these plans and their requirements.

Perhaps the most famous and useful Web site for these programs ishttp://www.directinvesting.com/. You are to compare and contrast online brokerage to DIPs and DRIPs.

Required:

Research online trading sites and DRIPS as outlined below, and summarize your findings. Make sure to include a summary table of the relevant information.

  1. Search three online trading sites, and determine the requirements for trading, including the price per trade. Compare and contrast the online trading companies. (2–3 pages)
  2. Search the Web for three companies (look for investor information) that offer DIPs or DRIPs. (2–3 pages)
  3. Compare and contrast the requirements, including minimum investments, nature of the return, costs, and other features. (1–2 pages)

Part B: Research Market Data on Bonds

Research the current (within the last two months) market data on bonds from AT&T, Dell, and IBM. Assume each bond has a par value of $1000, unless otherwise indicated.  Cite your sources.

 

AT&T

Dell

IBM

Coupon

 

 

 

Maturity

 

 

 

Frequency

 

 

 

Rating

 

 

 

Required:

    1. Complete the table above.
    2. Calculate the value of the bond if your required return is 5% on AT&T, 6.5% on Dell, and 8% on IBM.
    3. Determine the yield to maturity (YTM) on the bonds given the current price. Based on each bond’s ratings and your determination of its yield to maturity, explain how you rank each bond for risk and return.

Deliverable:

By Saturday, October 25, 2014, submit your responses to this Final Project assignment to the W3: Assignment 2 Dropbox. Your submission should be in a 5–10 page Microsoft Word or Excel document, showing your calculations. You can use the formulas embedded in Microsoft Excel and/or a financial calculator for these calculations.

Name your document SU_FIN2030_W3_A2_part2_LastName_FirstInitial.

Assignment 2 Grading Criteria
Maximum Points

Accurately completed the calculations for Part One of this assignment.

30
Compared and contrasted the online trading companies.
30
Researched the offerings of DIPs and DRIPs and compared the cost and return information.
40
Researched the bonds and gathered the necessary information to calculate the value of the bonds and their YTM.
40
Calculated and ranked the various securities in terms of risk and return.
40
Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; displayed accurate spelling, grammar, and punctuation. 
20
Total:
200

Subject Business
Due By (Pacific Time) 10/25/2014 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy