Questions tagged [returns]

The asset rate of returns is the profit on a particular investment; it includes any change in the asset value, interest, commission or dividends and so, all other cash-flows which an investors receive or pays due to the investment.

Filter by
Sorted by
Tagged with
3
votes
1answer
87 views

Is there an issue with estimating future returns from autocorrelated returns?

I have a time series $X_t$ generated from a standard GBM $$dS_t = \mu S_t dt + \sigma S_t dW_t$$ If I take the log returns over a rolling window of length $l$ $$r^{(l)}_i = \log \left( \frac{S_i}{...
0
votes
1answer
53 views

How to calculate Money-weighted Rate of Return when there are multiple negative cash flows during investment period?

I know that when there are multiple changes of sign in the sequence of cash flows of a project, the project may have multiple IRR, which render this criterion impractical. Therefore, in such ...
1
vote
1answer
49 views

Understanding Fama Macbeth Regressions of Returns

I'm trying to understand what the Fama-Macbeth regressions of returns actually mean. The source of confusion is a 2013 Novy-Marx paper, in which he states the following: "The first specification of ...
1
vote
0answers
58 views

Bloomberg Treasuries PX_Last and daily returns

I tried to search for this specific question, although I didn’t found a conclusive answer. I have a dataset containing the yields of several T-Bills and T-Notes that were downloaded from a Bloomberg ...
0
votes
3answers
81 views

Modelling NPV with negative cashflows?

When making capital investment decisions that have cost saving implications instead of cash flow generation, is NPV still valid? For example: A state wishes to decide whether to replace a section of ...
1
vote
1answer
47 views

What does a regression of squared returns of stock on squared index returns and lags show?

We have a squared stock return at t regressed on 3 variables: squared index return, squared stock return at t-1, and squared index return at t-1. My two questions would be: 1. What does this test ...
0
votes
1answer
48 views

Value-weighted return: which date should the market-capitalization be based on?

I got a short question regarding calculating the value-weighted return of portfolios. Example: The portfolio is constructed based on the value of a certain criteria on date 31.1 (Jan 31st). The ...
1
vote
1answer
32 views

Value premium analysis - Equal or Value-weighted Portfolios?

I got a question regarding the analysis of the value premium in the U.S. stock market. The task is to use the market-to-book-value ratio to split the S&P500 in five portfolios (rank 1-100,101-200,...
0
votes
0answers
28 views

Modern Linking Algorithm for Multi Period Performance Attribution

I'm looking for a modern description of the linking algorithms used in industry arithmetic performance attribution across multiple periods. Since the sum of the active return components in arithmetic ...
0
votes
0answers
18 views

Error distribution algorithms in performance attribution

Are there any known & generally accepted methods of scaling each return in a period such that the total cumulative return equals a more desired amount? For example, 0.5 and 0.3 have a total ...
1
vote
2answers
130 views

Returns and logreturns differences

I have a time series of stock prices and I tried to calculate simple returns and log returns. However, I end up that simple returns has positive mean, but log returns has negative mean. Is it possible ...
1
vote
3answers
274 views

How to calculate standard deviation of continuously compounded four-year stock returns?

Currently I am preparing for quant interview and I encounter the following question in Heard on the street. Question: If the standard deviation of continuously compounded annual stock returns is $...
1
vote
0answers
75 views

Relationship between ROE and IRR

In the textbook I read the following: We can increase the present value of a share of common stock with a new investment only if $ROE > r$ , where $r$ is a discount rate (capitalization rate). ...
1
vote
1answer
65 views

Derivation of the formula for $m$ compounding periods per year: $(1+\frac{i}{m})^{mt}$

A dollar return with interest $i$ invested for $T$ years with compounding interest frequency of $m$ times each year is: $$1*(1+\frac{i}{m})^{mt}.$$ My Question Why do we divide $i$ by $m$? Is this ...
0
votes
1answer
40 views

How to deal with intermittent NA values in a price series when calculating returns

Let's say a have a price series for a share for the year 2000. On the 27th of July 2000, there is a missing value represented by NA. This was not a holiday or any other non trading day as other shares ...
1
vote
2answers
87 views

How are returns on Bond Funds (or ETFs) calculated?

For example, if we consider the fund "iShares Core U.S. Aggregate Bond ETF (AGG)", I am trying to figure out how the yearly/Monthly returns are being calculated. I extracted the historical NAV values ...
2
votes
1answer
39 views

Convert arithmetic returns to log returns [closed]

I have a series of arithmetic returns and I need log returns. I do not have the underlying prices. How do I convert? All the posts I have found explain why using one versus the other is appropriate ...
1
vote
1answer
150 views

How to calculate standard deviation cone around expected returns?

I would like to evaluate the returns of an investment manager who has given me their return and volatility expectations for their fund. I would like to calculate both 1 and 2 standard deviations from ...
1
vote
1answer
67 views

Portfolio & Asset Returns across Multiple Periods

The stocks of CK Tan's, Robertson's, and Tamashimaya are held by the hedge fund SSK. They hold an equally weighted portfolio. The end-of month prices of the stock during five months this year is given ...
2
votes
1answer
35 views

Does Adjusted Closing Price take account the Expense Ratio?

first time posting at Quantitative Finance. I am trying to use the yfinance python library to load various ETF's data and compared the return. I understand the adjusted closing price handles the ...
1
vote
0answers
47 views

Autocorrelation in daily bond returns

I've been examining the returns of a few government bond series around the world. I found out that some have a positive daily autocorrelation. It's not big, but still seems at odds with efficiency. ...
3
votes
4answers
239 views

CAPM - Expected vs. actual returns

I'm trying to calculate alpha in excess of CAPM and have seen a few slightly different calculations for CAPM. The primary difference I am seeing is that some equations use expected market returns (e....
1
vote
1answer
71 views

EONIA capitalisé jour tr eur: can't find index data! Do you know what kind of index is?

To get EONIA capitalisé jour tr eur index returns (monthly returns from 01/2007 until the most recent) is challenging. First i googled the index name searching for the ISIN or the index provider ...
1
vote
1answer
85 views

Jensen’s Inequality for returns on short positions

this is puzzling me. Say you have an asset A, that on day t+1 returns 1%, and then on day t+2 returns 1% again. If you invest $1 in A on day t (take a long position), then on day t+2 you have earned:...
0
votes
0answers
41 views

What is the difference between Rolling Returns and Moving Average and how to calculate them?

So I understand what a moving average is and how to calculate it. I'm using this numpy function for it. I am somehow confused about how to calculate rolling returns. Different sites explain it ...
2
votes
0answers
86 views

Is it possible to compute implied returns from volatility?

If we assume that, broadly speaking: Assets in liquid markets are fairly priced to its value Volatility is predictable (volatility clustering, GARCH, etc) Investors are rewarded and earn a return for ...
0
votes
0answers
39 views

Why do these Monthly vs. daily plots differ?

I got my data from Thomson Reuters Datastream. As an Input for my plot i calculated daily Returns based on the Return-Index provided by datastream. Then i plotted the Monthly and the daily Returns.(...
0
votes
1answer
283 views

Squared returns and volatility

Squared returns are considered pillars of GARCH/ARCH modelling and most used method for forecasting or studying volatility. Can you tell me how to calculate it from simple stock price. Is it better ...
0
votes
1answer
70 views

Portfolio return with changing assets over time

I need some feedback on a very basic question regarding the calculation of the portfolio return. I have created an example of a portfolio with two assets and attempted to calculate the return: I've ...
1
vote
0answers
70 views

What's the interpretation behind this GARCH modeling?

I have an ARIMA model for monthly returns of the brazilian stock market index. Then I test the residuals of the model for ARCH effects. The ACF/PACF of squared residuals show that there are no ...
2
votes
2answers
91 views

How to calculate necessary gain to compensate a loss in a financial transaction?

(Feel free to suggest the correct Stackexchange community - or otherwise - if this is not the correct one) When trading financial markets, a gain of x%, won't ...
0
votes
0answers
43 views

Calculation of IRR Given Stage Assumptions

I am trying to replicate Union Square Ventures Fund #1 model. A number of assumptions are given and the outcomes are listed. I have copied these into google sheets. I am not sure exactly how IRR is ...
0
votes
0answers
74 views
1
vote
2answers
112 views

Why can we assume that asset return rates are normally (or lognormally) distributed?

In many theories of financial mathematics it is assumed that asset return rates are normally distributed (e.g. VaR models) or lognormally distributed (e.g. Black-Scholes model). In practice, asset ...
1
vote
0answers
23 views

Source for derivation of acquisition price for given IRR and cash flows

Does anyone know a quotable source - book/academic or practitioner's paper - that derives the acquisiton price for a target firm when the buyer's desired IRR and all cash flows over time of the target ...
2
votes
1answer
50 views

ETF performance/returns

I was going over some ETF return data on yahoo finance and encountered some numbers that did not make sense to me. The image below shows a ytd return of 17.94% and 13.52%. I checked ETF.com and ETFdb ...
1
vote
0answers
60 views

Predicting stock returns using principal components of macroeconomic variables

I'm trying to detect return predictability by regressing stock returns on the first couple of principal components of a set of macroeconomic variables. I'm doing this for different stock styles such ...
1
vote
1answer
62 views

Proof that IRR(A) < IRR(A+B) < IRR(B) ? Ie that the IRR of two cashflows together must be within the range of the IRR of the two cashflows?

The question The IRR of two sets of cashflow is not (necessarily) the weighted average of each set of cashflows. E.g. if ...
0
votes
1answer
91 views

Should the sum of daily returns be close to monthly returns

I am calculating value-weighted returns with monthly dividends reinvested and for some reason when I sum the daily returns some are a little bit off with monthly returns. Is this normal?
1
vote
1answer
67 views

Efficient Frontier Graph

I'm writing some C code to create different portfolios using a few stocks that are given as inputs. I am having some trouble trying to find if these results are correct. My biggest hesitation is that ...
1
vote
0answers
66 views

Logic behind calculating a Carry Multiple associated with Startup Valuation [closed]

I'm reading a book called "The #1 Guide to Startup Valuation: How to value your startup in 12 easy steps" (p. 22-23) by Joachim Blazer. As one of the building blocks, namely "Return", the Carry ...
2
votes
1answer
127 views

Convert Geometric Direct Alpha PME to Arithmetic Excess IRR (PME Alpha / Implied Private Premium)

As a followup to this old question, Private Equity: Direct Alpha vs Excess IRR, I have a new one. In automating PME calculations, the Direct Alpha (DA) approach is computationally simpler and ...
3
votes
2answers
158 views

Distribution of simple returns vs logreturns

I understand that stock prices are conditionally modeled using a log normal distribution by the relationship $ y_t/y_{t−1}∼logN(μ_{daily},σ^2_{daily})$ $y_t∼logN(log(y_{t-1})+μ_{daily},σ^2_{...
2
votes
0answers
53 views

Possible application of Polya's Urn on Portfolio's Investments?

I wanted to find some more information of this topic, but I found very little. I might be interested in optimizing a stock investment portfolio. Maybe I could use beta or some other common risk ...
0
votes
1answer
58 views

Return On a Spread

This is a beginner level question. I have a $spread = aluminium - 0.7*lead $ $s = a - 0.7*l$ I have two methods to calculate return on this spread: $ return = (s_t - s_{t-1})/(a_t + 0.7*l_t) $ ...
1
vote
1answer
99 views

How to calculate the daily rate of return for an actively traded account

I have a spot currency exchange account where the base currency is USD and where I can deposit and/or withdraw money from the account in any currency at any point in time. I can also exchange any ...
4
votes
1answer
137 views

Neural Networks for Estimation of Unmarked Private Asset Returns from Market Data

Let's assume it is March and my illiquid private assets portfolio is only 50% marked for 12/31, but I want to get the most accurate estimate of my final return for the quarter ended on 12/31. What is ...
2
votes
1answer
779 views

R: Calculating cumulative return of a portfolio

I've downloaded adjusted closing prices from Yahoo using the quantmod-package, and used that to create a portfolio consisting of 50% ...
2
votes
0answers
89 views

Calculate the True daily Time Weighted Return

I have an access database with records of securities in my portfolio as well as my trades for each security. My aim is to calculate the "Daily Time Weighted Return" then down the line, export it and ...
4
votes
2answers
145 views

Finding Lead-Lag Relationship [duplicate]

Given two series of data, volatility and returns, is there a way (Excel) of finding which one is the leading factor and lagging factor? Thank you for your help.

1 2 3 4 5 7