Skip to main content

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
18 votes
3 answers
47k views

If I were to buy something a day before my due date for my credit card bill, would I be charged interest?

First of all, I am a resident of Canada. I am new to credit cards, so I hope my question makes sense. I've had my card for a few months ago and I've always paid the balance in full by the time the ...
Rendezvous's user avatar
2 votes
3 answers
2k views

Calculating interest accrued with extended Initial Payment Date

I'm wondering how do I calculate the interest accrued if the intervals aren't perfect. For example Principal - $100,000 Interest - 8% Compounding monthly Disbursal Date - January 1st, 2016 Initial ...
user3276954's user avatar
2 votes
1 answer
3k views

Seasonal Loan Amortization

Hi I can compute a Basic Loan Amortization Schedule, But now I'm trying to Calculate a Seasonal Loan Amortization Schedule . So for example A loan starts at January And Will go on for 3 years, with ...
user3276954's user avatar
92 votes
11 answers
72k views

15 year mortgage vs 30 year paid off in 15

I've found similar questions, but they all seem to focus on a preexisting 30 year mortgage and whether or not it makes sense to refinance to a 15. My question is a bit different. I have not yet ...
user24676's user avatar
  • 923
27 votes
4 answers
50k views

Daily interest calculation combined with monthly compounding: Why do banks do this, and how-to in Excel?

I often see banks advertise (for accounts with fixed yearly interest, let's say 1.5%) – "interested is calculated daily, and compounded monthly". I have 2 questions: Why are they calculating ...
Saideira's user avatar
  • 385
13 votes
2 answers
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 ...
Brian's user avatar
  • 173
12 votes
2 answers
667 views

How do I account for newly added money when computing my rate of return?

I have a simple spreadsheet where I track the balance in my investment account. What should I do to handle new deposits in the account? For example: End of Day 1: balance = $100 End of Day 2: $...
Jer's user avatar
  • 2,974
6 votes
4 answers
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 ...
Hidden's user avatar
  • 179
10 votes
3 answers
4k views

Overpaying on mortgage - How is term reduction calculated?

Just for some example figures: Original Term: 25 Years Loan Amount: £100,000 Interest rate: 2% I'm trying to make an excel table which keeps track of my mortgage payments including overpayments. ...
Jimmy's user avatar
  • 255
5 votes
6 answers
11k views

Time-Weighted Rate of Return & Money-Weighted Rate of Return

Background I am trying to figure out the computational difference between Time-Weighted Rate of Return (TWRR) and Money-Weighted Rate of Return (MWRR). Let's say, I have a portfolio looking like ...
Drew's user avatar
  • 185
4 votes
3 answers
8k views

Loan repayment calculation and monthly compounding interest problem

I need to write a mock up application that returns a quote to potential borrowers. The specification says that "The monthly and total repayment should use monthly compounding interest". Program ...
user avatar
2 votes
1 answer
321 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 ...
Mark Barnes's user avatar
2 votes
8 answers
13k views

Help me understand the oddity of percentage gains and losses?

If you start with $100K, and you get a 50% gain, it's $150K. Then, you get a 50% loss: now it's $75K. Reverse the order (i.e. lose 50%, gain 50%), it's the same thing (a 25% loss). So, 50% up then ...
Ray K's user avatar
  • 1,355
0 votes
1 answer
1k views

Algorithm to calculate the Interest on Loan with a Balloon Payment

I am trying to understand the algorithm used by My Calculators.com - Balloon Payment Calculator If I enter the following details: Loan amount: 4556.75 Number of months: 5 Interest rate: 5.75% ...
matt90410's user avatar
  • 111
44 votes
9 answers
141k views

What is the correct answer for percent change when the start amount is zero dollars $0?

Percent change is a very common calculation in finance. It helps us track growth. The formula is: [(y2 - y1)/y1] x 100 = percent change If the start period is $0 (i.e. no money was made in the ...
user avatar
37 votes
6 answers
50k views

Should I pay an extra $100 every month on my mortgage or pay $1200 extra every year at the beginning of the year?

I can pay $1200 extra once a year or $100 every month - which is better? The first one does sound better, but for a 30 year mortgage, is it that significant? Say the mortgage is for $200,000. ...
Anonyms's user avatar
  • 371
15 votes
2 answers
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:...
colithium's user avatar
  • 283
11 votes
1 answer
1k views

Calculate Income Tax amount of UK Salary

I've recently been trying to calculate different take home amounts from different salaries, and have ended up getting confused over how the different tax brackets work. If I try to calculate the ...
Jaymz's user avatar
  • 213
9 votes
2 answers
3k views

What is the formula for calculating the total cost of a loan with extra payments towards the principal?

If I have a 30 year mortgage of $200,000 with an APR of 4.446% I can calculate how much my monthly payment will be and how much the total cost of the loan will be. But what if I have an extra $200 to ...
Shaylee T's user avatar
8 votes
2 answers
33k views

What is the formula for the monthly payment on an adjustable rate mortgage?

Can people tell me how monthly payments are calculated when a mortgage has an initial rate? What is the formula? I have seen online calculators but not formulae. My guess is: We assume that the ...
Lost1's user avatar
  • 193
6 votes
1 answer
656 views

How do I determine how long it will take to pay off my all my loans?

Right now I have a spreadsheet with the loans I have, the interest rates the are each at, and how much I am putting toward each in monthly payments. I then calculate how long each loan will take to ...
Ivan's user avatar
  • 161
5 votes
3 answers
750 views

Credit card grace period for pay, wait 1 day, charge?

Does a credit card grace period apply in this situation: March 1: I charge $1000 to my card. March 8: My billing cycle ends (ie, this my card's closing date). My due date is March 28th. March 9: ...
user avatar
5 votes
3 answers
15k views

How to calculate Social Security benefits if retiring before the early Social Security age?

How can I calculate my Social Security if I retire before my early Social Security age? I tried to use the official website's calculator, but it required entering too much data, and the website ...
Kevin Meredith's user avatar
4 votes
4 answers
28k views

Is there a mathematical formula to determine a stock's price at a given time?

I have been trying to find exact information on how stock prices are determined but still I haven't found any exact mathematical formulas how it happens. Wikipedia states: When prospective buyers ...
M.L.'s user avatar
  • 143
4 votes
1 answer
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 ...
Flux's user avatar
  • 17.1k
3 votes
2 answers
2k 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 ...
Arshiva's user avatar
  • 133
2 votes
2 answers
1k views

How does this retirement fund calculator work?

I found a retirement fund calculator on web: Inflation rate: 2% 0% 2% 0% Expected return rate: 5% 0% 0% ...
ohho's user avatar
  • 199
1 vote
2 answers
349 views

Calculating % profit on my investment of a short sale based on % loss of the stock price

Basically, when a stock price goes down by 50%, my profit is 100% of my sell price. When a stock goes down by 75%, my profit is 300% of my sell price. I'm curious what the relationship is between the ...
jwallis's user avatar
  • 13
1 vote
1 answer
583 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 ...
user avatar
-1 votes
2 answers
185 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 ...
Hari's user avatar
  • 419
-2 votes
1 answer
145 views

How to calculate the future expenditure of education :

Suppose the following: if a child's age is 2 years today and he/she will go to college at the age of 15 years for 2 years(duration of education) and for which Cost incurred P.A. as on today (Rs.) ...
user66908's user avatar
31 votes
12 answers
11k views

Investor Paradox. How can you calculate how much is a company worth when buying part of it changes the total value?

I have a (probably very simple) question to which I haven't been able to wrap my head around. Say I have a company, and I am told that it is worth 1 USD (100% of the company). My friend, who has 1 USD,...
Daniel Duque's user avatar
15 votes
3 answers
62k views

Calculate Future Value with Recurring Deposits

I am familiar with the formula for calculating FV and compound interest of a deposit, but I am wondering if there is a formula that will allow me to calculate how much money I will have after ...
ColorWP's user avatar
  • 151
12 votes
4 answers
75k views

If I earn 40 credits and stop working, would I get full Social Security benefits at age 67?

If I meet my 40 credit requirement in my 30s, and then left the States permanently and work at another country (and pay taxes there, not to the US), would I receive the full benefits when I become ...
Francisco Noriega's user avatar
10 votes
2 answers
3k views

Continuous compounding in practice

A common explanation for the mathematical constant e (2.71828...) is that it is the factor by which an investment would grow at 100% interest rate over a period if it is continuously compounded. In ...
jonallard's user avatar
  • 201
9 votes
2 answers
981 views

How does compounding of annual interest work?

I have tried reading up on it, but I just find it confusing. Apparently, if you started investing $150/month at a 15% annual return and kept reinvesting the profits, here is what you would have ...
oshirowanen's user avatar
  • 1,671
8 votes
2 answers
1k views

Credit card interest calculator with grace period & different interest rate calculation methods?

Is there an (ideally online) credit card interest calculator that includes grace periods and lets you choose the interest calculation method (eg, "adjusted balance", "average daily balance", "two-...
user avatar
8 votes
2 answers
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 ...
bstpierre's user avatar
  • 10k
7 votes
2 answers
1k views

Calculating savings from mortgage interest deduction vs. standard deduction?

I've read just about anything I can find on comparing cash-flow between owning a house versus renting. One new thing popped into my head yesterday, and I can't shake the feeling that it's an obvious ...
Mark E. Haase's user avatar
7 votes
8 answers
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 $...
MonkeyZeus's user avatar
  • 8,473
7 votes
3 answers
3k views

What is the "rule of 70" or "rule of 72" with regards to investment, and how do I apply it?

What is the "rule of 72" (sometimes called the "rule of 70") with regards to investment, and how do I apply it?
Computernerd's user avatar
7 votes
2 answers
2k views

How does a monthly inflation rate work?

I'm struggling to understand the following inflation numbers for South Africa given here: http://www.tradingeconomics.com/south-africa/inflation-cpi Year Month Inflation 2015 Jun 4.7 2015 Jul ...
Simon Streicher's user avatar
7 votes
3 answers
5k views

Is interest of credit cards caculated based on the amount unpaid within the grace period?

From Wikipedia if a user had a $1,000 transaction and repaid it in full within this grace period, there would be no interest charged. If, however, even $1.00 of the total amount remained unpaid,...
Tim's user avatar
  • 5,883
6 votes
2 answers
2k views

How do I calculate my net worth according to the book "The Millionaire Next Door"?

I remember reading about PAWs, UAWs, and AAWs. I also remember that the formula for what your net worth should be on average (to be an AAW) is your income (without inheritance[s]) multiplied by one ...
Kelsey's user avatar
  • 515
5 votes
2 answers
682 views

Calculating the most optimal way to pay off credit cards

I have 3 credit cards which I am slowly paying them off. Card# Balance Monthly Interest Months to pay of Minimum Payment at current rate Payment 1 $...
NeedAdvice's user avatar
  • 3,817
5 votes
2 answers
24k views

How to calculate total interest paid on a decreasing balance?

I am trying to come up with the equation which will give me the total interest to be paid on something given a fixed interest rate with a fixed payment for a given period of time. The interest is ...
Nathan Taylor's user avatar
5 votes
4 answers
9k views

How are bonuses taxed? Why is withheld amount not same as final amount?

I have not found any clarity looking at a lot of search engine results and articles. Most articles state that there are 2 possibilities, that taxes from bonuses can be withheld at a flat 25% rate, or ...
user2144412's user avatar
4 votes
2 answers
37k views

How do I calculate yield-to-maturity (YTM) with a simple handheld calculator?

Is there a way to calculate yield-to-maturity (YTM) using just the payments (not all equal) with just a simple handheld calculator and without using Excel?
The Mysterious's user avatar
4 votes
1 answer
110 views

Should you work out the yield on property or shares against the purchase price, or the current market price?

In What is a good rental yield?, there's some discussion about whether you should calculate yield by dividing the original purchase price, or the current market price. Which is the correct definition,...
poolie's user avatar
  • 2,213
4 votes
3 answers
2k views

What's the correct formula to calculate my monthly wage (deducting UK Income Tax and National Insurance)?

For a given salary, how do I work out what would be paid into my bank each month? The Income Tax part is explained for the main part in this question, but I can't make sense of the National Insurance ...
Drarok's user avatar
  • 213