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
1
vote
0answers
24 views

Enhancement of the open source lib for calculation of IRR (internal rate rate)

I am cs student , and has been asked to enhance the documentation for open source lib finance.js for IIR (internal rate of return) for various industry Here I am trying to calculate IIR for the ...
0
votes
2answers
29 views

How does the Positive Volume Index (PVI) formula work?

I'm completely new to calculation of trading indicators and I can't understand this PVI formula: PVI = {yesterday’s PVI X [(today’s CP – yesterday’s CP) ÷ yesterday’s CP]} + yesterday’s PVI If I ...
1
vote
0answers
28 views

How To Calculate Daily Volatility?

I'm working in SQL Server and I'm trying to find the daily volatility of a stock's price. Is it simply day2price/day2price-1? Is that considered daily volatility? Or, is there something else to it? ...
3
votes
4answers
98 views

What formula can I use to calculate compounding interest with recurring investments?

Assume I am saving X dollars per year every year, and every year I earn 10 percent on what I saved the previous year. e.g. if I am saving 100 dollars every year I would see the trend: 100, 210, 331, ...
0
votes
1answer
68 views

Calculate percent of goal where start is not zero

How would I calculate the percent to a goal between two numbers where the starting number is not zero? for example: purchase price = $10 target price = $80 current price = $61 What percent to $80 ...
1
vote
2answers
68 views

Online portfolio return calculator [closed]

Is there a online calculator where I can punch in ETFs that I want in my portfolio and it shows the return over time? I want to add GLD, VOO, VGT to see what my return would have been and then ...
7
votes
8answers
5k views

Would the minimum payment or full CC amount be considered monthly debt?

Based on Is rent considered a debt? The question of: What is your total monthly debt payment (e.g. student loans, vehicles, credit cards, personal loans, etc.)? got me thinking. If you rack up $...
1
vote
1answer
97 views

How do Ontarians calculate optimal RRSP contribution?

Pls see my dad in Ontario's facts. He maxed out his TFSA, and his annual pre-tax income (henceforward "APTI") is $50K. CRA website shows his 2019 RRSP deduction limit is $100K. If I understood this ...
2
votes
2answers
64 views

Profitability of Holding a Loan from Issue to Maturity

The loans that I invest in pay a fixed amount of money per month. A portion of it is principal and another portion of it is interest. As the loan matures, a smaller proportion of each payment is ...
0
votes
0answers
73 views

Why is this stock's P/E ratio so different from Price/EPS?

I was looking at Alibaba Group Holding Ltd ADR (BABA)'s P/E ratio of 28.55 from Morningstar. While looking at its financials, Morningstar says that its diluted EPS TTM is 26.41. But its stock price ...
1
vote
1answer
84 views

Does the amortizing payment on a loan depend on whether interest is calculated daily or monthly?

Assume two banks offer a $100,000 mortgage at 6% annual interest for 30 years with payments due monthly. One bank assumes each month has 30 days. The other bank uses the actual number of days in ...
2
votes
4answers
143 views

What is an appropriate metric measure average annualized rate of return for an average investor?

Let us say an investor invests $X per year for N years. Let us say the final portfolio value is $Y. In this scenario, how should I measure a metric that quantifies "average annualized return"? I ...
0
votes
0answers
34 views

Explanation of Macaulay duration for bonds?

I understand how to calculate duration but I'm a bit confused about what it actually tells me and how it is useful and I can't seem to find anything that tells me. If a bond has a maturity of 5 years ...
1
vote
2answers
138 views

Formula for retirement withdrawal amount same as principal decreases

I created a retirement calculator The idea is if you save enough you can so when you withdraw say 4% you don't eat too much into your savings. But based on my calculation 4% of 500000 is $20k but ...
-3
votes
1answer
342 views

$100 divided by 3: What happens to the $0.01? [closed]

Frustrated with the current bookkeeping app I use, I've decided to start making my own with the intent to publish it. While I was on it, one thing that was immediately apparent is what happens to ...
0
votes
1answer
63 views

What is the formula to get the Interest percentage from Interest Rate?

What is the formula to get the Interest percentage from Interest Rate? Given : Principal Amount : $1000 Interest Rate : $1 / Month Number of payments : 10 What is the formula to fetch the ...
2
votes
1answer
160 views

How should I calculate how much my money is _grown_?

I invest in multiple streams - equities, mutual funds, bank deposits etc. Depending on the asset class, my rate of return is different, naturally. Some asset classes generate higher ROI (with higher ...
1
vote
3answers
97 views

How does a bond's coupon rate differ from its market yield rate?

I'm trying to understand how bonds work and am confused by coupon rate vs market yield rate. Suppose company Foo issues a bond with a face value of $1 million, a 4% annual coupon rate payable semi-...
2
votes
2answers
199 views

How to calculate the return from a mutual fund?

How do I calculate the return from a mutual fund invested as a monthly SIP of Rs. 5000 over a period of 3 years at a return rate of 20.4% per annum? The projected amount for the same is calculated by ...
4
votes
3answers
464 views

Please help me calculate interest on a loan

My Ex owes me $66000 and I need to give him a payment plan with 8% interest over 5 years. The monthly repayments need to tier roughly as follows (he's going to earn more in the 2nd and 3rd years and ...
1
vote
3answers
113 views

What would the formula for loan payoff with daily compounded interest and paid 5 days per wk?

I'm interested in calculating the impact of making payments on my student loans daily (5 payments per wk). For example my current loan is 50,000$ @ 5.05% interest compounded daily. The term of the ...
-1
votes
1answer
59 views

how to find flat rate of interest per annum and month if we have given reducing rate of interest or loan amount and tenure?

For example: For loan amount 500000 for 5 years at the rate of 12% (reducing interest rate), EMI is 11,122.22 per month Here 12% reducing is equivalent to flat 6.69% per annum or flat 0.55% per month. ...
0
votes
1answer
62 views

How to create an average of several unitized accounts?

I have a spreadsheet in which I track the unitized progress of three separate investment accounts (all made up of funds, bonds, etc). I think I'm using the Time-Weighted Return method described here ...
24
votes
3answers
5k views

20% APR means only 10% interest? (UK)

I am trying to get better grasp of what the APR figure means, so this example is purely hypothetical. I have entered a loan of £100,000 into an APR calculator on MoneySuperMarket with a 20% APR for ...
2
votes
1answer
267 views

Building Marcus Savings Calculator in Excel

I'm trying to do some analysis in Google Sheets which involves putting money in Marcus' High Yield savings account. For some reason, I can't seem to get my numbers to match the values from their ...
2
votes
2answers
232 views

What is the formula for calculating how many mortgage payments remain after variable extra payments?

I’m looking for a Wolfram Alpha equation to put in my rate, loan term, principal remaining, and monthly payment (and anything else) to solve how many payments I have left. All I seem to find are ...
0
votes
1answer
104 views

Calculate ROI over multiple trades

I'm looking for a formula to calculate my over all return based on N trades and avg return per trade (R). Let's say: My average return per trade (R) is 5% and the number of trades (N) made are 100. ...
0
votes
1answer
80 views

Simple Interest calculation on rent of specific period till date of payment

Hi I have to calculate simple interest on Rent of Rs.10,000 @6%. There are two parts to my problem. Calculation of simple interest on rent amounts due for 41 months progressively i.e. as rents keep ...
3
votes
3answers
395 views

How to know how much money was paid, and how much was spent paying off interest

I would like to buy a car, and found out about the 20/4/10 rule today. I definitely have more than 20% downpayment saved up, due to that I am not concerned with the 20 part. I am more concerned about ...
2
votes
1answer
402 views

Is their a formula for calculating Future Value of a series of payments with monthly deposit but annual compounding?

Exactly as the title suggests Is there a formula for the future value of monthly payments with annual compounding? Perhaps approximating the outcome achieved by the following calculator? https://...
2
votes
2answers
384 views

What is the formula for loan payoff date?

My goal is to calculate loan payoff date. Actually I'm making a wordpress plugin to calculate that. I made a form from I can have following inputs from user. Current Loan Information Original ...
1
vote
2answers
54 views

How do you calculate the rate in the present value of an annuity due calculation?

I have the formula for calculating the present value of an annuity due I have the Present value now, so I want to solve for r. In other words, I would like to find out the resultant rate. In the ...
0
votes
1answer
84 views

USD stock investment with EUR base currency

I can't wrap my head around this: In late 2011 I used EUR to purchase stock valued in USD. Dividend yield aside, the stock advanced a lot. However, EUR/USD also changed quite a bit. I am ...
1
vote
1answer
367 views

CAGR and Dividend Yield

I am brand new to this, but am looking for some guidance when it comes to calculating the estimated FV of an investment in stocks with dividends reinvested in the same company. I'm going to be really ...
-1
votes
2answers
104 views

How do I equally disburse appreciating assets over a fixed timeframe?

First, I apologize if the title is confusing or if there is a better wording. I am unfamiliar with many finance terms, so there may be something accurately describes my problem. I am trying to ...
1
vote
1answer
218 views

Pay off student loans vs pay myself and try to get PSLF? (is my math right?)

I am trying to decide between paying off my student loans in 5 years vs attempting to quality for Public Service Loan Forgiveness (PSLF), which I could conceivably do in 5 years. My options are to 1) ...
4
votes
2answers
433 views

How do I calculate the benefit of contributing to 401K vs paying off consumer debt?

I have a ~$15,000 loan with a 6% interest rate. My company matches half of my 401K contributions up to 6%, and I am in a 25% tax bracket. I currently contribute 15% of my income to my 401K. How do ...
0
votes
1answer
60 views

How are net income and yield calculated for margin trading?

You have purchased 150 shares at 10 each. You expect to sell these at 15 each. You only managed to sell 100. Out of your initial purchase price, 400$ were borrowed. Brokerage fee= 2% for the ...
2
votes
2answers
90 views

Simpler way of calculating duration for bonds?

So the question is: Find the duration of a 6% coupon bond making annual coupon payments if it has 3 years until maturity and has a yield to maturity of 6%. What is the duration if the yield to ...
3
votes
2answers
98 views

Does sigma in Black-Scholes attempt to take into account future events?

I am learning basic information about Black-Scholes wrt options pricing. I see that the standard deviation of the stock price is taken into account. This seems to only rely on existing (historical) ...
1
vote
1answer
138 views

Best way to allocate money? Mutual Fund VS Student Loan

I am a 21 year old Canadian who is employed full time. I have no wife or kids nor do I own any property. I have no type of savings set up (investments, CPP, etc.). Each month I have 400$ leftover ...
1
vote
3answers
657 views

Growing annuity where cash flow grows per second year

I'd like help with a formula for calculating Future Value given the following: An amount is invested at the END of every year, starting with amount of PMT at the end of this year, at an interest rate ...
3
votes
2answers
253 views

How to Calculate a BiWeekly Repayment Loan?

I want to calculate the biweekly repayment loan. I have gotten the monthly using this formula (D) = {[(1 + i) ^n] - 1} / [i(1 + i)^n] Monthly Payment = Loan_Amount / D How can I convert this to ...
-2
votes
2answers
287 views

Is this incremental Saving Formula Correct?

I'm planning to save some money. I earn in Pakistani Rupees. At the time of posting 1Usd = Rs 123.12. I came up with an idea to save a certain amount each month and add additional 10% of the saved ...
0
votes
2answers
256 views

How much can I save if I don't own a car? A worked example comparing car to pension

I don't drive and I've never enjoyed driving. Moreover my eyesight is very poor and I fear I may be a danger on the road. However, some 'friends' and family don't get this, so I want to show a ...
0
votes
1answer
1k views

How should you calculate the average daily return on an investment based on a history of gains?

I started an Acorns account several months ago to use as a glorified savings account. I don't make contributions on purchases, but I contribute 10% of my paycheck to it every two weeks (Richest Man ...
1
vote
2answers
2k views

How do I convert a 4% per annum interest rate, compounded semi-annually, to a monthly rate?

Trying to develop a budget model in Excel. I know a prospective savings account makes 4% per annum, compounded semiannual. I'd like to know how much this means it earns monthly. Does it even earn ...
1
vote
0answers
62 views

Security Analysis (Ben Graham): LIFO question

I'm currently reading/studying Benjamin Graham's work in Security Analysis (1951 edition) on page 112 & 113 he demonstrates the difference between FIFO and LIFO. Table 10 shows the difference ...
9
votes
2answers
317 views

Time, money and probability: Should i sell my electric bike

I bought a second hand electrical bike for a very reasonable price (600 euro) more than a year ago. Since then i changed jobs and i now commute by car and the bike just sits in the shed. If I sell it ...
1
vote
1answer
97 views

Can I calculate an average annualised return from investments held for different lengths of time?

My question is: given a number of investments of differing amounts, held for different lengths of time, how would I calculate an approximate average annualised growth for the entire portfolio over its ...