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

531 questions
Filter by
Sorted by
Tagged with
1 vote
83 views

This investment returns calc, which seems to be widely used, explicitly states that contributions are made at the beginning of each period. If I enter: 10 years 7% RoR \$10,000 initial investment \$1,...
396 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 ...
43k views

### How to determine contractor hourly rate and employee salary equivalents?

I am aware of the general differences between being an employee and being an independent contractor. However, I am unable to easily compare the two when it comes to after-tax compensation. Company A:...
201 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 ...
143 views

### How to calculate yearly average inflation rate having only percent changes?

I'm trying to calculate yearly average inflation rate across a period of years displayed in my screenshot having only percent changes for each year. I'm unsure how that should be done and have tried 3 ...
262 views

### Who gets fractional sales tax?

A 7% sales tax on an item costing \$10.00 would be 70¢. On \$9.99, it would come to 69.93¢, but the customer still pays 70¢. Where does that 0.07 of a cent go? Put another way, a hundred \$10 ...
1 vote
60 views

### How to Calculate Future Inflation-Adjusted Investment Balance with Monthly Contributions, Annual Interest, and Fees

I would like to calculate the future value of an investment, considering monthly contributions and an annual interest rate (i.e., return). I also want to adjust the final figure to account for annual ...
197 views

### How to calculate monthly payment of a loan

I am trying to solve this question: Your brother-in-law asks you to lend him \$100,000 as a second mortgage on his vacation home. He promises to make level monthly payments for 10 years, 120 payments ...
1 vote
44 views

### Instalment interest calculation in Canada for individuals

I made no instalments payments in 2023 as I thought my net tax owing in 2023 would be below \$3000. I received instalment reminders from CRA and I ignored the emails. Now, I believe my net tax will be \$...
1 vote
46 views

### How can I calculate the time weghted return?

I have switched frequently between ISA providers and I want to see how much my investments have truly increased. I have a spreadsheet where column 1 is the date I invested a certain amount, column 2 ...
80 views

### Price for a bond that was issued in the past?

I understand that for US treasury bonds, that the price, its current yield and annual coupon is related by price = coupon/yield. But the prices and yields when I look them up online are always denoted ...
138 views

### How to solve amortization schedule where 10% of the interest is paid back on 4th payment

I am trying to find an algorithm to solve this amortization schedule: P = 1000, term = 12 months, Interest=5%, calculation based on actual/365. 10% of the total interest of the loan is added to the ...
1 vote
52 views

### How to calculate PV of annuities for a home loan

I am trying to model investing in residential real estate vs investing fully in stock. I have a corpus of say 1M in S&P500. I also receive monthly income which will be used to either invest in ...
517 views

### What is the correct Formula for calculating fund growth with fees

I am considering two different options for a roth IRA. A managed fund that has a higher historical growth rate but 1% fee and a self directed vanguard account, which would have a lower growth rate but ...
113 views

### Money-Weighted Returns calculation clarification

I found out this is the calculation for the Money-Weighted Returns. From what I understand, PVO can also be seen as "Present Value of the portfolio". If this is the case, doesn't the right-...
26 views

### How do I calculate the NPV(of DCF) of a mutual fund investment?

How do I measure the yearly cash-flow of a lumpsum mutual fund investment (or an equity investment) (provided I am not cashing out each year), also what do I take as the discount factor?
221 views

### For this I-bond calculation there's a tiny adjustment to the rate (fixed rate x semiannual inflation rate) it barely changes the rate.Why is it there?

From https://www.treasurydirect.gov/savings-bonds/i-bonds/i-bonds-interest-rates/#cerates Composite rate formula: [Fixed rate + (2 x semiannual inflation rate) + (fixed rate x semiannual inflation ...
1 vote
89 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 ...
143 views

### Sales tax calculation algorithm

I need to code a tax calculation algorithm for a project. What is the correct algorithm for calculating sales taxes on an sales receipt? Given a sales receipt with 3 items (A,B,C) and a 4 taxes (W,X,Y,...
3k views

### Does the history of credit utilization affect FICO score?

Most people are aware that the debt to credit limit ratio is a vital part of the FICO score. The FICO score is updated every time new information is received by the credit bureaus. However, is it ...
197 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 ...
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 ...
166 views

### Refinance Calculator - use Interest Rate or APR?

I am using the NerdWallet Refinance Calculator to compare current loan with new loan. https://www.nerdwallet.com/mortgages/refinance-calculator/calculate-refinance-savings My question is should I put ...
36 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 ...
3k views

### Why we need to substract one period when calculating Present Value?

The question is: Grandparents are funding a newborn’s future university tuition costs, estimated at \$50,000/year for four years, with the first payment due as a lump sum in 18 years. Assuming a 6% ...
1 vote
449 views

### Why is that we discount all the coupons and par amount of a bond at the same rate?

Why is that we discount all the coupons and par amount of a bond at the same rate, our YTM? If we think of each coupon/par as a strip/single bond on its own, wouldn't then each coupon payment be ...
9k views

### How do I calculate the principal paid down on a mortgage?

I'm looking for an equation to find out the current principal on a mortgage. I have the following variables: n periods monthly payment amount interest rate of mortgage I'd like to know how much I'd ...
2k views

### Am I doing the math for this covered call/long put strategy correctly? What risks do I run with this strategy?

In this trade, I write an in-the-money covered call and buy an in-the-money put (as an example) on GM, expiring in September 2014. The call premium is \$10.02 with a strike of \$26, and the put premium ...
1 vote
60 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 ...
71 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 ...
1 vote
227 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 ...
138 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 ...
196 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: ...
245 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 ...
242 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 ...
1 vote
64 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". ...
216 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 ...
1 vote
185 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 ...
1 vote
100 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 ...
5k views

### How can I calculate a "running" return using XIRR in a spreadsheet?

I should say that I'm not married to XIRR, I just want to calculate the return on a running basis in a column next to dates, deposits and balances. Here's a screenshot of a simplified spreadsheet in ...
268 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): ...
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 ...
318 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 ...
1k 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 ...
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.....
2k views

### Annuities question - Equations of value

Chuck needs to purchase an item in 10 years. The item costs 200 today, but its price inflates at 4% per year. To finance the purchase, Chuck deposits 20 into an account at the beginning of each year ...
32 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 ...
2k views

### Formula for Cost of Potential Home from Monthly Mortgage

I'm trying to find a way to calculate the price of a home I can afford based on my potential downpayment, the monthly rent I can afford, and the interest of a potential loan. I've seen questions like ...
1 vote