Questions tagged [calculation]

A generic tag to understand the calculations in a specific case. Please give out a sample illustration and ask a specific question. Ideally should also be accompanied by specific subject tags like "credit-cards", "savings-account", "index-funds" etc.

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

How to calculate portfolio performance without tracking each individual transaction

How does one go about calculating the performance of a portfolio when the portfolio is robo-managed and rebalances often, therefore making tracking every transaction and exact holdings over time a ...
Hilikus's user avatar
  • 131
0 votes
0 answers
29 views

Calculating Interest Expense with amortization

Preface: I'm an engineer not an accountant so all this finical modeling stuff is new to me. I've been given the task to take an existing finical model in Excel and put it into a jupyter notebook. One ...
Matthew M. Osborn's user avatar
0 votes
0 answers
27 views

order of rounding fractional cent dividends and currency conversions

I have noticed that the share trading platform I use performs their calculations differently from the program I use to monitor my accounts. For example: s = shares held g = gross amount per share t = ...
jhnc's user avatar
  • 213
0 votes
0 answers
45 views

S&P 500 eps calculation

I am trying to calculate the eps for S&P 500 in order to validate the data I parsed (I got eps for 430 companies Q3 2022 year). I used different sources: seeking alpha API (is not connected with ...
Mark Khabarov's user avatar
2 votes
1 answer
40 views

Margin calculation on short and long positions combined

Assume an investor goes long on X1 and simultaneously short on X2 both of which cost $1. With margin rate at 50% he is required to deposit 0.5 + 0.5 = $1 margin to make the transaction. My question ...
Ferydoun Taherkhani's user avatar
2 votes
0 answers
93 views

The interest rate of a (U.S. Treasury) "Floating Rate Note" (FRN)

I am having trouble to reproduce the calculation of the interest rate of a (U.S. Treasury) "Floating Rate Note" (FRN). Can you help me to find my error? The calculation is described here: ...
311411's user avatar
  • 235
2 votes
2 answers
174 views

Calculating stock prices falls and rises

Let's say I close my investment of $25 in a stock which is currently down from 313 to 123, I calculate my loss with this equation: ( ( Close - Open ) / Open ) * 100 = %change Which would leave me with ...
Matt W's user avatar
  • 549
2 votes
1 answer
52 views

What is the difference between Capitalization Rate and Return on Assets?

In real estate, the capitalization rate (cap rate) is one of the metrics used to assess the rental profitability of a property. The formula for capitalization rate is net operating income divided by ...
Flux's user avatar
  • 16.8k
5 votes
2 answers
3k views

Why the calculated cost of a loan is less than expected? Is the bank working at a loss?

Let's say I want to borrow $1000 from a bank at an interest rate of 12% per year, for one year. The number of payments in this case is equal to 12 (one year * months per year) and the interest rate ...
g00dds's user avatar
  • 69
1 vote
2 answers
68 views

For mutual funds, does average annual return mean compounded annually or continually or daily?

Vanguard's Portfolio Allocations page (1926-2019) shows 9.21% Average annual return for 70% Equity and 30% Fixed income. Does this mean 9.21% compounded annually? GOAL... If at age full retirement age ...
Doug Null's user avatar
  • 596
0 votes
2 answers
33 views

How to deal with spinoffs when calculating money-weighted rate of return (MWRR) of a stock investment

I am using a spreadsheet's XIRR function to calculate the money-weighted rate of return (MWRR) of my investment in "X Corporation" stock. X conducted a spinoff of "Y Corporation". ...
Flux's user avatar
  • 16.8k
3 votes
3 answers
88 views

Discounted cash flow: meaning of terminal value formula

I am reading a book about stock valuation using fundamental analysis — Accounting for Value by Stephen Penman. The following discounted cash flow (DCF) formula appears in chapter 2 with almost no ...
Flux's user avatar
  • 16.8k
1 vote
1 answer
58 views

Calculate Loan Balance and Future Balance with Extra Repayments

So, here's the current situation. I took out a £7000 loan over 42 months at the insane interest rate of 47.4%. I needed the loan, couldn't borrow it off family, and the interest rate is due to some ...
ScottishTapWater's user avatar
0 votes
1 answer
156 views

Position size calculator which includes fees in the risk

Problem: I have a position calculator for scalping, but currently it does not include entry/exit fees in my risk calculation. Since scalping, in most scenarios, requires leverage, those fees really ...
Jericho's user avatar
  • 11
1 vote
1 answer
81 views

Is this a good strategy to calculate Mutual Fund returns?

I am trying to track my mutual funds performance in a meaningful way. I tried using XIRR but my understanding of it is not entirely clear. So what I am alternately doing is for every individual ...
user96551's user avatar
  • 113
1 vote
1 answer
90 views

What is the correct formula for Bond Yield?

Taking an introductory investment course, was following up on bond yields. I thought the yield is calculated as follows (sorry for some reason LaTex formatting doesn't work - so inserting an image): ...
hba's user avatar
  • 165
1 vote
1 answer
59 views

When using TWRR for an individual stock, how do I treat non-reinvested dividends?

I'm researching time-weighted rate of return calculations as a performance metric to use with individual stock security holdings. I've read multiple sources of information to include but not limited ...
tim.rohrer's user avatar
0 votes
0 answers
22 views

Market value + exposure for a short position

In a portfolio tracking application I am displaying a table of holdings like so: Symbol Quantity Direction Average Price Market Value Unrealised P/L. Exposure TSLA ...
Daniel Cooke's user avatar
18 votes
1 answer
4k views

Why does the TD Bank principal portion of a mortgage payment go up and down in sawtooth? (why is interest payment on annuity in arrears non-monotonic)

I'm trying to understand the amortization schedules of TD mortgages, as produced by the TD Calculator. The monthly payment amounts (on this fixed rate mortgage) are predictable and constant, but the ...
pf_init_js's user avatar
3 votes
1 answer
229 views

How do I calculate the performance of a stock investment in the presence of dividends, additional investment and partial sales?

What is a single metric I can use to calculate the performance of a stock investment in the presence of dividends, additional investment, and partial sales? Such a metric should be comparable across ...
Flux's user avatar
  • 16.8k
1 vote
2 answers
123 views

How does selling some shares affect cost basis + average price

I am building a stock portfolio tracking application, and I am having some difficulties wrapping my head around something very basic (maybe I'm just tired) How does selling a stock affect the cost ...
Daniel Cooke's user avatar
10 votes
4 answers
10k views

At 3% inflation rate, is $100 today worth $40 20 years ago?

I'm little bit confused... At 3% inflation rate, is $40 20 years ago worth $100 today? Is it as simple as adding 60% of $100 to get the worth of currency 20 years ago? Forgot about compound interest.....
Healbeanmen's user avatar
2 votes
2 answers
112 views

How can I calculate amortized payment when the payments are made in advance?

I'm trying to calculate the payment amount on an amortized loan with interest where the payments are made in advance. If the payments are made in arrears there's a simple formula, but since the first ...
Dadveloper's user avatar
2 votes
0 answers
31 views

How to calculate profits from a short position [duplicate]

Say I have a $100 balance, the margin requirement is 10%, I short a stock at $100, and the stock drops down to $10, is my profit 90% or 1000%? To more more specific, is the profit 90% relative to my ...
blahahaaahahaa's user avatar
0 votes
0 answers
45 views

Calculate stop loss

---- Preface ---- I am not sure if this is the correct place to post this kind of question. If not, please let me know, and I will remove it. If you need any clarifications or require more ...
Random Stuff's user avatar
0 votes
0 answers
67 views

Complete formula for calculating forex pip value for XAUUSD with account funded in euros

I'm currently developping forex robot using Python API for Metatrader 5. Among different things, this robot places trades given by external signals (with price, SL and TP). I use euro funded account, ...
nbonniot's user avatar
  • 109
0 votes
0 answers
82 views

How to calculate distribution return for ETF?

I'm trying to calculate Growth and Distribution returns for ASX:VGS for 2021 based on historical data, but the results do not match what's published. Here I can see that in the 2021 Calendar year it ...
Maxim Mazurok's user avatar
1 vote
0 answers
32 views

Is there a citation for an apparent change in UK Tax Return calculation process, going into 2021/2

Examining my Tax Returns for the past 4 years, it seems that HMRC have changed one of their rounding policies (from previously being less accurate but in the individual's favour, to being more ...
Brondahl's user avatar
  • 2,021
1 vote
2 answers
236 views

How, *exactly*, do I calculate my UK PAYE personal Tax Allowance ... since it's not quite the published figure?

See here: UK Taxation: Should I be able to calculate my PAYE tax for the year exactly? It turns out that, contrary to common-sense, if someone is a fairly average person in England and thus has the &...
Brondahl's user avatar
  • 2,021
3 votes
2 answers
102 views

UK Taxation: Should I be able to calculate my PAYE tax for the year exactly?

Consider a simple employed person in the UK, with nothing particularly unusual or exciting. At the end of a given (financial) year they look at their payslips and they can see (amongst other things): ...
Brondahl's user avatar
  • 2,021
0 votes
0 answers
92 views

How do I calculate Tax for a Long Term Capital Gain?

Do I calculate tax based on IRS tax tables on page 65 (or worksheet on page 77, 110) of https://www.irs.gov/pub/irs-pdf/i1040gi.pdf Or Do I calculate tax based on Qualified Dividends and Capital Gain ...
Marium's user avatar
  • 349
1 vote
6 answers
4k views

Why isn't there a universal investment standard/benchmark?

When I watch golf and look at the results of the top players, I can immediately know exactly how they compare both to the standard (called par) and to each other. Why doesn't investing have such a ...
soakley's user avatar
  • 320
2 votes
1 answer
78 views

What's the APR for this in combination with the Balloon Payment of 6525 USD?

I am trying to solve the following: Finance Amount: 24.951,82 USD Interest Rate: 2.29% Residual Value: 6.525 USD Number of Months: 60 Fee: 374.28 Years: 5 What's the APR for this in combination with ...
Sascha A's user avatar
0 votes
0 answers
34 views

How to calculate profit on real estate after x years?

If I want to calculate the "profit if sold" for a property after X years, what is this calculation based on? One thought is it is equal to the projected sale price (based on some assumption ...
fraxture's user avatar
  • 101
1 vote
1 answer
42 views

How do I Calculate this Estimated Weighted Return?

I am trying to figure out how to calculate an estimated weighted return. For example, imagine I have the following portfolio: | ETF | Quantity | Value | Weight | Estimated Return | Estimated ...
Dev's user avatar
  • 145
1 vote
1 answer
32 views

Mismatch Between FV Function and the Bankrate Simple Savings Calculator

I'm trying to replicate the functionality of the Bankrate Simple Savings Calculator in Google Sheets. I've assumed that I need to use the FV function, but I can't get the numbers to match exactly. ...
Frank's user avatar
  • 13
1 vote
2 answers
124 views

Finance Exam: Isn't the solution for this problem wrong?

Hey could you help me out, I think the given solution to this problem is wrong: Find the present value of $3000 due in 5 years and 6 months if the money is worth 4.5% compounded quarterly. Solution PV ...
João Duarte's user avatar
3 votes
2 answers
316 views

Time Value of Money — Interest Paid on Mortgage

You you bought a house worth $328,000. You paid 25% of the purchase price in cash and arranged a 25 year mortgage with a rate of 4.0% compounded semi-annually for the remaining balance. The mortgage ...
qmack's user avatar
  • 33
1 vote
1 answer
47 views

Core Processing - Month & Year Length in Calculations

I'm looking for information into how financial institutions and their core processors perform their calculations. More specifically, how the month and year lengths are factored in. First, are there ...
FamousAv8er's user avatar
0 votes
2 answers
72 views

Compute coupon of treasuries

How do you compute coupon starting from yield and price? Since yield is coupon / par, which is 2 / 100 in this case, would it just be yield * price, 0.01906 * (102 + 1 / 32) with the data below? ...
asdasd's user avatar
  • 1
1 vote
0 answers
33 views

How total volume indicator $TVOLI is calculated?

The value of dow jones industrial average total volume indicator "$TVOLI" is just about 50,000 , while there are millions of shares traded each day in these 30 stocks. How is this indicator ...
huab's user avatar
  • 917
2 votes
4 answers
717 views

Understanding S&P 500 profit

It is my understanding that opening larger stock positions will, if the stock climbs, produce a larger profit. For example, if I open a position of $200 on the S&P 500 and that position goes up by ...
Matt W's user avatar
  • 549
0 votes
2 answers
452 views

Why are weekends ignored when calculating moving averages?

Suppose we are calculating a 5-day simple moving average (SMA) of a stock's closing price: If it is now the end of the trading day on Friday, we can calculate the SMA using the closing price on ...
Flux's user avatar
  • 16.8k
0 votes
1 answer
453 views

How do I calculate Compound Interest with changing monthly contributions, quarterly contributions, and changing interest rate

John currently has $100 in a saving account that compounds quarterly at a .25% interest rate. When the account's balance reaches $2500 or more, the interest rate will change to .05%. I want to figure ...
Colin Fiedorowicz's user avatar
0 votes
2 answers
454 views

Does the calculation of moving averages include the current price?

Suppose I have the historical closing prices of a stock, and the current real-time price. I want to calculate a simple moving average (SMA). Historical prices: Day Closing price 1 $1.10 2 $1.20 3 $...
Flux's user avatar
  • 16.8k
1 vote
1 answer
564 views

Formula for time taken to pay off loan with annual interest and monthly repayments

I am trying to find how to work out the period of time it will take to pay off a loan. There are plenty of online calculators out there but I cannot find the formula they use. I want to recreate the ...
myol's user avatar
  • 113
2 votes
1 answer
71 views

Calculating an accelerating rate of growth as a formula

Suppose I start with a $1,000 trading account. During each 30 day period my account earns $1,000 in net profit from a trading strategy using one contract per trade. The max amount lost across any ...
eComEvo's user avatar
  • 245
0 votes
0 answers
53 views

How to calculate all fees to get exact price or profit on wealth simple stocks

I'm trying to calculate all the fees in a trade for a buy and sell, from me being in Canada (CA). So this is for buying or selling a CAD stock or a US stock. I have some theories but wanted to check ...
omega's user avatar
  • 113
-1 votes
2 answers
46 views

Help on HP12C SOYD function

HP12C SOYD function: I use the soyd function to calculate the percentage variation between two numbers. $1200 -> $1700 Clearly, we have an increase of 41,67%. But if I type $1700 first and then $...
Paulo Smith's user avatar
1 vote
2 answers
179 views

0% rate of return + inflation differs from inflation alone

Given that Real Rate of Return = (1 + nominal rate) / (1 + inflation rate) -1 If my nominal rate equals the inflation rate I get 0, meaning that my money is worth the same no matter the inflation ...
f.rodrigues's user avatar

1
2 3 4 5
11