Premium Essay

Return Calculations

In:

Submitted By ctscts
Words 7466
Pages 30
Chapter 1 Return Calculations
In this Chapter we cover asset return calculations with an emphasis on equity returns. Section 1.1 covers basic time value of money calculations. Section 1.2 covers asset return calculations, including both simple and continuously compounded returns. Section 1.3 illustrates asset return calculations using R. Updated: June 23, 2011

1.1

The Time Value of Money

This section reviews basic time value of money calculations. The concepts of future value, present value and the compounding of interest are dened and discussed.

1.1.1

Future value, present value and simple interest.

Consider an amount $ invested for years at a simple interest rate of per annum (where is expressed as a decimal). If compounding takes place only at the end of the year the future value after years is: = $ (1 + ) × · · · × (1 + ) = $ · (1 + ) (1.1)

Over the rst year, $ grows to $ (1+ ) = $ +$ × which represents the initial principle $ plus the payment of simple interest $ × for the year. Over the second year, the new principle $ (1+ ) grows to $ (1+ )(1+ ) = $ (1 + )2 and so on. 1

2

CHAPTER 1 RETURN CALCULATIONS

Example 1 Future value with simple interest. Consider putting $1000 in an interest checking account that pays a simple annual percentage rate of 3% The future value after = 1 5 and 10 years is, respectively,
1 5 10

= $1000 · (1 03)1 = $1030 = $1000 · (1 03)5 = $1159 27 = $1000 · (1 03)10 = $1343 92

Over the rst year, $30 in interest is paid; over three years, $159 27 in interest is accrued; over ve years, $343 92 in interest is accrued ¥ The future value formula (1.1) denes a relationship between four variand Given three variables, the fourth variable can be ables: determined. Given and and solving for gives the present value formula: (1.2) = (1 + ) Given as: and the annual interest rate on the investment is dened =

Similar Documents

Free Essay

Meow

...S&P 500 index. We also found the monthly yield on a 30-year T-bond to also use as a comparison for our two stocks. Once we collected all of these findings we were able to calculate various risk and return measures that we would use later when forming our portfolio. RESULTS: Since 2008 we found that there has been a gradual rise in the stock prices for both Microsoft and Wal-Mart. At the end of 2008, they were trading at $17.10 and $49.73 respectively. As of December 2013, they are now trading at $37.41 and $78.69, which are both significant rises since five years ago. After finding the closing monthly stock prices for Wal-Mart, Microsoft and the S&P 500, as well as the monthly yield for a 30-year T-bond, we took their average for each to find the expected return. Respectively for Microsoft and Wal-Mart we found the expected returns were 1.54% and 0.88%. For Microsoft this is well above the benchmark of the S&P’s expected return, which was 1.30%, while for Wal-Mart it is well below the benchmark. We also found that Microsoft and Wal-Mart’s expected returns are higher than the average monthly yield of a 30-year T-bond, which is good because it shows they are outperforming a risk free asset. Following our calculation of expected return we went onto other risk and return measures like variance and covariance. The variances of Microsoft and Wal-Mart are 0.47% and...

Words: 682 - Pages: 3

Premium Essay

Bad Things

...break your program into individual pieces with methods Preparation • • • Read 3.13, 5.2,5.3, 5.5 and 6 Read class notes Try problems 4.18, 5.32, 6.20 Instructions Create a program that can be used by nursing students to help them with calculations. You program should contain the following menu items. 1) Dosage Calculation Amount Given= D ×V H D = dose ordered or desired dose H = dose on the container label or dose on hand V = form and amount in which drug comes(tablets, capsule, liquid) Example: D =50mg, H = 125mg, V = 5ml Amount Given = 2ml. For this option create a subroutine that prompts for quantity and units of D , H . In addition to asking for the quantity of D and H ask for their units as well. Make sure their units match. 2)IV rate calculation using calibrated tubing gtt /min= V ×C minutes or gtt /min= V ×C hours∗60 V = is the volume in milliliters C = is the calibration of the tubing in gtt/ml Time = in minutes or hours. For this option create a subroutine that prompts for V,C and time and calculates gtt/min. Be sure to ask the user if the time is entered in hours or minutes, so that the right equation can be used. 3)Infusion time calculations R T =V /( ×60 ) C T = time in hours V = volume in milliliter R = rate in gtt/min C = calibration gtt/ml For this option create subroutine that prompts for V,R and C and...

Words: 456 - Pages: 2

Premium Essay

Renqing887

...past one year, to calculate the expect return and standard deviation for each of them. According to the ANZ dividend payment history, it shows that the ANZ dividend paid semi-annually (every July and December). So it is still no dividend payment in 2013. According to the BHP dividend payment history, it shows that the BHP dividend paid semi-annually (every March and September). First of all, we should calculate the weekly expected return by formula (1). rt= Pt-Pt-1+ dtPt-1 (Formula 1.) rt= expected return of each week at time t. Pt= closing price at time t. Pt-1= opening price at time t. dt= dividend payment at time t. Then, according to the formula (2), we could get the expected return for each of the two stocks by calculating the mean of all weekly expected return in the past one year. r = t=1nrtn (Formula 2.) n = the number of weeks during the past one year. r = the mean expected return. After getting the mean expected return, we should use r to calculate the standard deviation for each of the two stocks by formula (3). σr= t=1n(rt-r)2n-1 (Formula 3.) rt= expected return of each week at time t. r = the mean expected return. σr= the standard deviation of return. In order to get the portfolio risk...

Words: 379 - Pages: 2

Premium Essay

Abbot Labortories

...Abbott Laboratories Problem Quanisha Duckworth Bus405: Principles of Investment Instructor: Mark Stricklett December 1, 2014 27. What is the sustainable growth rate and required return for Abbott Laboratories? Using these values, calculate the 2010 share price of Abbott Laboratories Industries stock according to the constant dividend growth model. Values: Beta = .60 Risk free rate = 3.13% Market risk premium = 7% Dividend declared per share = $1.60 2009 EPS = $3.65 2009 ROE = 28.00% Beta b = 1 – ($1.60 / $3.65) = .5616 Growth g = 28% × .5616 = 15.73% Risk adj. discount rate k = 3.13% + 0.60(7%) = 7.33% Present Value of divided stream P0 = $1.60(1 + .1573)2 / (.0733 – .1573) = ($25.52) I am really not capable of using the dividend growth model for my calculation since the required returned of $25.52 is lesser than the growth rate of 15.73. So, I squared the growth rate since the 2009 dividend is being used to see what the 2010 price of stock. 28. Using the P/E, P/CF, and P/S ratios, estimates the 2010 share price for Abbott Laboratories. Use the average stock price each year to calculate the price ratios. Average P/E CF P/S 5 yr avg. price ratio $17.08 $12.24 2.912 Current value per share $3.65 ...

Words: 1035 - Pages: 5

Premium Essay

Marketing

...the Monday we return from break and will be due on Friday of week 9 (so you have almost 2 weeks). 2) For the in-class test there is no formula sheet but also there is not much calculation. This test is mainly about concepts. You may need to be able to recognize the common formulas (for example the formulas for test statistics for t, F and chi-squared tests), but you will not need to have them strictly memorized. Those who want more calculation will have to wait for the take-home exam. Another reminder about the calculator policy for the in-class exam: Graphing calculators are fine, but any calculator with remote capability is not permitted. This includes all phones, iphones, ipods, ipads, and any other new technologies that may be invented before thursday for getting remote assistance. If you are caught with an illegal calculator you will be asked to leave the exam, with other penalties possible depending on circumstance 1) The Take-home portion has been delayed again. It will be available (really, truly, honestly) on the Monday we return from break and will be due on Friday of week 9 (so you have almost 2 weeks). 2) For the in-class test there is no formula sheet but also there is not much calculation. This test is mainly about concepts. You may need to be able to recognize the common formulas (for example the formulas for test statistics for t, F and chi-squared tests), but you will not need to have them strictly memorized. Those who want more calculation will have to...

Words: 360 - Pages: 2

Free Essay

Hp12C

...Hewlett-Packard Company 4995 Murphy Canyon Rd, Suite 301 San Diego, CA 92123 Printing History Edition 4 August 2004 2 File name: hp 12c_user's guide_English_HDPMBF12E44 Printered Date: 2005/7/29 Page: 2 of 209 Dimension: 14.8 cm x 21 cm Introduction About This Handbook This hp 12c user's guide is intended to help you get the most out of your investment in your hp 12c Programmable Financial Calculator. Although the excitement of acquiring this powerful financial tool may prompt you to set this handbook aside and immediately begin “pressing buttons,” in the long run you’ll profit by reading through this handbook and working through the examples it contains. Following this introduction is a brief section called Making Financial Calculations Easy—which shows you that your hp 12c does just that! The remainder of this handbook is organized...

Words: 53555 - Pages: 215

Free Essay

Nike Case

...NIKE INC. CASE 14 Philip Chen, Choco Huang, Ariel Chou, Matt Krieger In this report we analyzed Cohen’s approach in calculating WACC. After observing how Cohen derived his figures we came up with our own WACC, terminal value, and EPS. Cohen broke down his calculations into five parts 1) Single or Multiple Costs of Capital 2) Proportion of capital from debt and equity 3) Cost of Debt 4) Cost of Equity 5) WACC In part one; we disagreed with Cohen where he decided to value the company as a whole instead of valuing each division separately. Since Nike is a multidivisional firm Cohen should of aggregated the values of the individual divisions and calculate a different cost of capital for each one. Since the exhibit 1 and 3 provide a consolidated income statement and balance sheet it is difficult to segregate the divisions. Therefore when we did our own calculations we used Cohen’s assumption of a single cost of capital. In part two Cohen allocated the weight of debt and equity based on book value. This method is incorrect because the allocation should be based on market value. The table below is our calculation of capital allocation. Table 1.1   | Price: Exhibit 4 | shares outstanding | Total | % of Capital | Debt | 95.60 | 271.50 | 25,955.40 | 69.43% |   |   |   |   |   |   | Price: Exhibit 2 |  shares outstanding |  Total |  % of Capital | Equity | 42.09 | 271.50 | 11,427.44 | 30.57% |   |   |   | 37,382.84 | 100.00% | Part 3 is the cost...

Words: 685 - Pages: 3

Free Essay

Homework3

...CMIS 102 6382 September 28, 2014 A. Problem Analysis • The purpose of the program is to calculate the area ,perimeter and diagonal length of a rectangle with dimensions (Length and width) are provided by a user. • Input the values of length and width from the user • For finding the area, the calculation is length * width • For the perimeter, calculation is (length + width) * 2 . • For finding the diagonal length , the formula is sqrt( length*length + width* width) B. Program Design Input/Output The program will prompt user to input: • Legth • Width Calculate the area • Area= length * width • Display the area Calculate the perimeter • Perimeter =( length + width) * 2 . • Display the perimeter Calculate the diagonal length • diagoanllength = sqrt( length*length + width* width) • Display the diagonal length Pseudo Code Start Declare the variables length, width, area, perimeter, diagoanlLength as double GetInput() CalcArea() CalcPerimeter() CalcDiagonalLength() Stop Function GetInput() Display “Enter the length and width “ Accept length, width End Function Function CalcArea() area= length * width Display “The Area is :”,area End Function Function CalcPerimeter() perimeter = (length + width) * 2 Display “The Perimeter is :”, perimeter End Function Function CalcDiagonalLength() diagoanlLength...

Words: 470 - Pages: 2

Premium Essay

Marriott Solution

...13.1% Calculation: WACC = (1-t) * rd * (D/V) + re* (E/V) Where: D= market value of DEBT E = market value of EQUITY rd = pretax cost of debt re = aftertax cost of equity V = D+E t = tax rate To calculate the formula above, we need to determine each component Tax rate (t) 56% --> calculated before LODGING Step 1: Calculate unlevered beta using similar companies Weigh Unlever . Avg. ed Beta (βu) Sales Sales 0.70 0.77 23% 0.43 1.66 50% 0.40 0.17 5% 0.67 0.75 22% 3.35 Beta (β) Debt (D/V) E/V Hotel D/E Tax HILTON HOTELS CORPORATION 0.76 14% 86% 0.16 44% HOLIDAY CORPORATION 1.35 79% 21% 3.76 44% LA QUINTA MOTOR INNS 0.89 69% 31% 2.23 44% RAMADA INNS, INC. 1.36 65% 35% 1.86 44% Total Sales Calculate unlevered beta for the Marriott Lodging using Weighed Average of Sales βu = 23%*0.70+ 50%*0.43+5%*0.40+22%*0.67 βu lodging = 0.54 Note: βu = βe / (1+ (1-t) * D/E) Step 2: Re-lever the beta ( βl ) for lodging βl = βu * (1+ (1-t) * D/E) Use 74% debt target ratio --> Calculation βl = βu * (1+ (1-t) * D/E) βl = 0.54 * (1 + (1-0.44)*(.74/.26)) βl = 1.41 Calculation re = rf + β * (rm - rf) re = 8.95% + 1.41*7.43% re =19.4% Step 3: Calculate cost of equity (re) re = rf + β * (rm - rf) Where rf = risk free β = beta levered risk premium = rm - rf rm = market risk --> rf used is 8.95% since Marriotts uses the long-term debt for its lodging cost-of-capital Risk premium used is 7.43% or spread between S&P 500 composite returns and long-term US gov. bond return Step 4:...

Words: 1056 - Pages: 5

Free Essay

Hp 12c

...4995 Murphy Canyon Rd, Suite 301 San Diego, CA 92123 Printing History Edition 4 August 2004 2 File name: hp 12c_user's guide_English_HDPMBF12E44 Printered Date: 2005/7/29 Page: 2 of 209 Dimension: 14.8 cm x 21 cm I ntroduction A bout This Handbook This hp 12c user's guide is intended to help you get the most out of your investment in your hp 12c Programmable Financial Calculator. Although the excitement of acquiring this powerful financial tool may prompt you to set this handbook aside and immediately begin “pressing buttons,” in the long run you’ll profit by reading through this handbook and working through the examples it contains. Following this introduction is a brief section called Making Financial Calculations Easy—which shows you that your hp 12c does just that! The...

Words: 54268 - Pages: 218

Premium Essay

Roma Corral

...In the RomaCorral Case two constraints were to achieve an average return on investment of 10% and increase after tax profit by 5%. When I did my NPV and discounted using 10% I got positive NPV so it would satisfy this constraint of 10%. How do I calculate the after tax 5% constraint? Can you please help to work with an example? You can do pro forma statements showing after tax profit before and after alternative implementation - show the % increase between the two to calculate the constraint. Hello, this might be a silly q but when I did my quants for RomaCorral I got a positive NPV for coffee shops and negative NPV's for expanding (probably did the calcs wrong). To me the Strategic Issue was to make sure we met the mandate of the 5% profit increase over 2 years and the dividends and the expanding of restaurants contributed to this big time...the coffee shops contributed to this too but very minimal. Therefore I said implement both even though the restaurant expansion had a negative NPV. Therefore the question is: do we always reject a negative NPV or if it solves the Strategic Issues do we accept the alt? I heard somewhere that this is accepted. If not accepted, then do we lose big time marks? If you get a negative NPV for an alternative, you should not be recommending it becaue at the end of the day, every company, even a non for profit, needs to be profitable to survive. If however you feel that this alternative is in fact very strong and touches on a lot of...

Words: 1851 - Pages: 8

Free Essay

App Development

...CS193P IPHONE APPLICATION DEVELOPMENT FALL 2011 Assignment I: Calculator Objective This assignment has two parts. The goal of the first part of the assignment is to recreate the demonstration given in the second lecture. Not to worry, you will be given very detailed walk-through instructions in a separate document. It is important, however, that you understand what you are doing with each step of that walk-through because the second part of the assignment (this document) is to add a couple of extensions to your calculator which will require similar steps to those taken in the walk-through. This assignment must be submitted using the submit script (see the class website for details) by the end of the day next Wednesday. You may submit it multiple times if you wish. Only the last submission will be counted. For example, it might be a good idea to go ahead and submit it after you have done the walk-through and gotten that part working. If you wait until the last minute to try to submit and you have problems with the submission script, you’ll likely have to use one of your valuable late days. Be sure to check out the Hints section below! Materials • Before you start this assignment, you will need to download and install the iOS SDK and Xcode 4 from http://developer.apple.com or using the App Store on Mac OSX. It is critical that you get the SDK downloaded and functioning as early as possible in the week so that if you have problems you will have a chance to talk...

Words: 1918 - Pages: 8

Premium Essay

Youngstown

...on the four products are provided below: Product A B C D Total Production Volume (units) 10,000 8,000 6,000 4,000 Selling Price $15.00 18.00 20.00 22.00 Direct Materials/unit $ 4.00 $ 5.00 $ 6.00 $ 7.00 Direct Labor Hours/unit 0.24 0.18 0.12 0.08 Total Direct Labor Hours 2,400 1,440 720 320 4,880 Plant Overhead $122,000 DL rate/hour $30 Youngstown has a traditional cost system with the plant-wide overhead rate calculated by dividing total overhead costs by total direct labor hours. Assume, for the calculations below, that plant overhead is a committed (fixed) cost during the year, but that direct material and direct labor are flexible (variable) costs. 1. Calculate the plant-wide overhead rate. Use this rate to assign overhead costs to products and calculate the profitability of the four products. 2. If any product is unprofitable with this cost assignment, drop this product from the mix. 3. Return to step 1. Recalculate the overhead rate based on the remaining total direct labor hours in the plant, and apply the new overhead rate to the remaining products. 4. Continue to cycle through steps 1–3 until all the products have been dropped and the plant is not longer producing any products. What is happening at Youngstown and...

Words: 274 - Pages: 2

Premium Essay

Case Study

...whether a floor price and taxing on alcohol would benefit Thailand’s population and also whether the UK should trial similar ideas. A Simple Model for Demand To be able to work out the effect that the increase in demand will have on the annual consumption I would have to interpret the data given in the report. As we are told, the price per litre of alcohol is expected to increase by 60% to 2,500 Baht in 2013, I was therefore able to work out that in 2012 the average price of alcohol would have been 1,562.5 Baht per litre by doing the following calculation: 2500 / 160% = 1562.5 2500 / 160% = 1562.5 378 / 100 1.5 = 372.33 378 / 100 1.5 = 372.33 Moreover, as we were also told in the report the annual amount of alcohol consumed in 2012 was 378 million litres and that this is expected to decrease by 1.5% by 2013. I was able to calculate the predicted amount of litres of alcohol consumed by doing the simple calculation: An Equation for the Demand Curve The information that I have formulated above has allowed me to be able to calculate the gradient and more importantly the equation of the demand curve between Thailand’s annual consumption of...

Words: 889 - Pages: 4

Premium Essay

Netw320

...Step 4 Calculation * Step 11 Calculation * Step 15 Calculation * Step 17 Calculation * Step 19 Calculation * Summary of RF Behavior | 2 2 2 2 2 15 | Calculate each of the five measurements in the project.In your own words, summarize what you have learned concerning RF behavior from your calculations, readings, and research. | Case Project 4-3: MIMO (page 156) 25 points * Introduction * Advantages/Disadvantages * Applications * Future | 55510 | Discuss MIMO antenna technology, including history, advantages, disadvantages, current applications, and future. | Total | 50 | A quality paper will meet or exceed all of the above requirements. | Deliverables IMPORTANT: A report template is provided beginning on the next page, and you must use it to submit your assignment. Before submitting your assignment, delete the pages containing the instruction and rubric. Your submitted assignment should begin with the title page and only contain your report. Don’t forget to place your name, your professor’s name, and the date on the title page. Week 2 iLab Report Francisco Santoya DeVry University NETW360: Wireless Technologies and Services COMPUTE RF BEHAVIOR AND MIMO Submitted to: Professor: Jalinous Date: 9/11/13 Compute RF Behavior Calculate each of the five measurements in the project by performing every step in sequence. In your own words, summarize what you have learned concerning RF behavior. Calculations Step...

Words: 727 - Pages: 3