Explain how you rank each bond for risk and return

Assignment Help Corporate Finance
Reference no: EM131593413

Quantitative Exercises and Project Assignment: 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.

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

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 matte.

Attachment:- Template.rar

Reference no: EM131593413

Questions Cloud

Identify a personal economic decision : Identify a personal economic decision that was driven by a behavioral bias rather than by pure rational behavior.
Briefly characterize notes from underground : Briefly characterize ALL the characters and show why they are necessary for this story
Market demand and supply functions : You have just graduated and moved to this city; as a new MBA and an entrepreneur, you are considering entering the market for this product.
Summarize the company and explain cvp : Summarize the company and explain CVP and Capital budgeting. Use outside resources to best explain CVP and capital budgeting.
Explain how you rank each bond for risk and return : Explain how you rank each bond for risk and return. Calculate the value of the bond if your required return is 5% on AT&T, 6.5% on Dell, and 8% on IBM.
Who is art for according to marcel duchamp : Who is art for according to Marcel Duchamp? Who is art for according to Malevich?
Which of the three bonds offers the highest current yield : Which of the following bonds offers the highest current yield? Which of the three bonds offers the highest current yield?
Tickets for a regular seat at super bowl : Suppose tickets for a regular seat at Super Bowl XXXVII cost just $500 when bought at face value (the cost at the box office).
Define measurement process of accrual versus cash accounting : (Pension Terminology and Theory) Many business organizations have been concerned with providing for the retirement of employees since the late 1800s.

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd