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 called FIN2030_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.

 

 

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 is http://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

Class, for Part II Part A of the referenced assignment, you need only complete Requirement # 1 regarding the online trading companies.  In turn, you can complete this section in 2 – 3 pages.  Part II Part B of the referenced assignment, let’s all just use the following basis//table to perform Bond Valuation:

                           AT&T                  Dell                 IBM 

Coupon                 6.80%               6.50%              8.40% 

Maturity                26 years           27 years            9 years

Frequency          Semi-Annual     Semi-Annual      Semi-Annual

Rating                     A                     A –                    A +

Yield To Maturity      5%                  6.5%                 8.0%

Hopefully, these guidelines will help us complete the assignment in an effective and efficient manner.  I thank you for your attention to and adherence regarding this matter.  

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency