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.

learn more… | top users | synonyms

1
vote
0answers
38 views

Steps to calculate reduction in spending vs. savings till retirement

I'm stuck and I I think it's an algebra issue. I have a typical what do I need to save (today) so I can retire question for the first part. Let's say you need $1,239,926.43 in savings at retirement ...
0
votes
1answer
29 views

Cumulative Return between two dates

I have a table that carries data with cumulative return of some instrument. Data is described with start date, end date and cumulative return for date range (start-end): Start Date|End Date ...
1
vote
1answer
39 views

Gnucash: How to add up all charges on a credit card within a period

I have "Liability" account in Gnucash for my credit card. Each expense made using my card is shown there as "Charge", while each payment I made to the credit card account from my checking account is ...
0
votes
1answer
66 views

Getting compound interest calculation wrong but don't know why

Investopedia says that the formula for compound interest is Ic = P[(1 + rN) − 1] Which due to the Order of Operations can be heavily simplified to Ic = PrN (and I checked via Wolfram Alpha ...
1
vote
1answer
32 views

looking for research tool to plug in and evaluate theoretical historical returns

I am just starting to invest. I would like to find a calculator to which I could enter, say, a monthly amount - perhaps $100 - and put it into different classes of funds over arbitrary periods (say ...
2
votes
2answers
56 views

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

what is the formula for YTM for semiannual payments using handheld calculator ?? how can i able to calculate yield to maturity for semiannual bond payments with handheld calculator
2
votes
1answer
98 views

Unequal Loan Repayments

I am struggling with this question below. Present Value = 100000 Interest =12.25% per annum Number of months = 60 Payments =? Payments increase by 15% per annum. Calculate the ...
3
votes
1answer
62 views

Calculating return on a series of stock positions with multiple uneven transactions

How can I calculate the return on a series of stock positions with multiple uneven transactions that I can compare to the equivalent buy and hold return over the same period? Random Example: Starting ...
0
votes
0answers
34 views

Calculating a blended interest rate for amortization schedule

I have two interest rates, 3% and 3.018% compounded semi annually, I was wondering is it possibly to have one interest rate or do they have to be kept seperate to calculate interest properly. ...
1
vote
2answers
107 views

Calculating Stock Trading Profits

I buy 100 shares of Company A at $10/share and one month later I buy 100 more shares of Company A at $20/share. If one month later, I sell half of my shares how would I calculate my profit? I ...
1
vote
1answer
51 views

Pre- & post-tax calculations for comparing contribution amounts for traditional 401k vs. Roth IRA?

I currently have a rollover IRA which I no longer contribute to and a 401k which I currently contribute to. I would like a Roth account to be more diversified from a tax perspective. I currently put ...
3
votes
2answers
104 views

Division of Proceeds from sale of house

I bought a house ten years ago with a friend and I put down the 20% deposit. We have been fighting for years and recently decided to sell the house. We bought the house as joint tenants with right of ...
13
votes
1answer
1k views

Is the Social Security retirement benefit calculation based on the last 40 quarters, or overall?

Are Social Security payouts based on the last 40 quarters, or overall earnings? That is: If the last 40 quarters of my working career are lower than these past 40 quarters worth, how does this affect ...
0
votes
1answer
112 views

What is the formula for calculating the amount of money I end up with in a given period (salary and compounding effect)?

I'll give a concrete example (couldn't find a similar question): Let's say I have an amount of money M at time t = 0 (first month). Every month, I get a given amount (let's say constant) of R On my ...
0
votes
2answers
75 views

Could somebody explain Wikipedia's VAT example calculation to me?

Wikipedia example here. I could not understand why in this example ("With a value-added tax" subsection) the government charges 0.10 = $1 × 10%, but not 0.11 = $1.1 × 10% The manufacturer spends ...
1
vote
3answers
71 views

Average cost basis based on total shares held or specific shares sold?

Let's say I bought 1 share in a Vanguard mutual fund each year for 10 years. Its price started at $1 and went up by exactly $1 each year, so the price of the latest share bought is $10. The average ...
3
votes
3answers
102 views

Fundamentals of creating a diversified portfolio based on numbers?

There are a number of articles and posts across the internet describing how to diversify your portfolio. But, each claim typically focuses on how to allocate your portfolio rather than describing ...
8
votes
5answers
3k views

Do I owe taxes if my deductions are higher than my income?

My total income this year was $16,604 (wages, interest, and business income). My deductions (including IRA, personal exemption, standard deduction, and self employment tax) was $17,404. TurboTax ...
1
vote
2answers
46 views

Is this the right tax statement for Roth IRA back conversion?

I moved $5500 from traditional IRA to Roth IRA in January 2014 for tax year 2013 . Then I moved another $5500 from traditional to Roth IRA for tax year 2014 in March 2014. When depositing fund in IRA, ...
3
votes
1answer
780 views

What is the full formula for calculating a FICO 9 credit score?

I'm familiar with the percentage breakdown of how a credit score is calculated. I'm wondering what is the exact formula is that can be used to come up with a point value based on specific input ...
5
votes
4answers
971 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 ...
1
vote
0answers
36 views

How is minimum payment calculated for this daily amortized loan?

I'm trying to figure out how the bank calculated the minimum payment for a personal loan. Starting Principle: $6,800 Interest Rate: 13.750% Loan Term: 36 months Payment Frequency: Monthly Start ...
3
votes
4answers
214 views

A calculator that takes into account portfolio rebalancing?

I'm looking for a calculator that takes into account rebalancing when estimating total returns using historical data. For example, I'd input the following into the calculator: I have an initial ...
1
vote
1answer
50 views

What Percentage of my Income do I Have to Pay in Employment Insurance (EI) Deductions?

I am from Calgary, Alberta, and I am wondering how much % of my hourly wage will be paid to my EI (employment insurance). Is the percent rate different for every worker, if not, what is the fixed ...
2
votes
1answer
74 views

What is a 10 Year Treasury Note and How Can it be Used to Calculate the Intrinsic Value of a Stock?

I am a Canadian, and I am trying to use an "intrinsic stock value calculator" (found here: ...
2
votes
1answer
79 views

Question related to Public Provident Fund interest calculation

Consider the following extract from a newspaper article : The interest on your PPF balance is compounded annually, but the calculation is done every month. The interest is calculated on the ...
0
votes
1answer
165 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 ...
4
votes
1answer
563 views

Calculating equity split in selling a property

Purchased a property with another person in 1998. We remained equitable partners until April, 2009 when the other party stopped paying their share of the mortgage, condo fees, property tax, upkeep. I ...
2
votes
1answer
255 views

Calculating total number of monthly payments in Excel using NPER and PMT?

How to calculate the total number of monthly payments given the amount of loan ($275,000), the annual interest rate (4.35%) and the number of years (30)? I'm confused because I'm trying to use the ...
1
vote
2answers
180 views

How do you choose which mortgage structure is appropriate when buying a home?

My lease is up in 1 month, and I'm looking to buy a home in the next 4 weeks. I have narrowed it down to two that I am interested in. I'm wondering about the type of mortgage I should get. Which ...
3
votes
5answers
783 views

Why would one W-2 give so much more back than the other?

I'm a single male with no dependents. I had two W-2s for this year, one of which showed a gross earning of ~$30,000 while the second was for ~$20,000. When I fed the first one into TurboTax, I got a ...
1
vote
2answers
167 views

Not receiving a tax refund because local taxes weren't withheld on my paycheck?

For instance, if the local New York City tax wasn't taken out of my paycheck, does that directly affect my tax refund? From what I understand the calculation for a tax refund is dependent on whether ...
3
votes
2answers
610 views

How does “on the next percentage” work (for company matching)?

For example, if I contribute 5%, the company matches that contribution with: 100% on the first 2% 40% on the next 2% 25% on the next 1% How do you calculate the next percentage.. and of what ...
2
votes
2answers
441 views

What is the best way to calculate total yield on a stock portfolio?

What is the best way to calculate the total yield of a stock portfolio? I started managing my own investments last year and it looks like I leaned towards dividend investing. I am wondering how I ...
4
votes
1answer
901 views

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

If I met 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 ...
2
votes
2answers
140 views

Mathematics behind deciding to do a lump sum mortgage payment vs. RRSP contribution?

If I have 10,000 extra dollars, how could I decide between doing either: A lump sum mortgage prepayment (2.1% variable closed interest rate, 250k remaining balance), or, An RRSP contribution ...
0
votes
2answers
95 views

How would you figure the cost of something in the future including inflation?

Looking for an excel formula that can calculate the cost of something based on a current price that factors in price increases and inflation. For example a plane ticket cost (econ LAX to JFK) in 30 ...
1
vote
1answer
169 views

Income tax calculate on your per company or on my total income in year?

I don't know if this is right place of ask this question. But still need to ask. Now I start financial year with by company A. So company A only provide final settlement account ( including AVP ) in ...
0
votes
0answers
47 views

Options contract calculator - for non-equities

All of my options calculators are within stock trading platforms, or readily found on the internet and require stock/index symbols. I am trading illiquid options over the counter, on an asset. I have ...
1
vote
0answers
88 views

How to calculate interest charged on my loan given a series of dates & payments?

I want to calculate the interest rate payed for this loan using Mathematica. The initial amount was of 12000€, then they asked to pay 240€ for opening the loan and another 870€ for the insurance for ...
0
votes
0answers
47 views

How are the sub-periods derrived in TWRR Daily Valuation?

I've been looking at the TWRR Daily Valuation method and I'm trying to understand how to break the total performance period into sub-periods when there are irregular cash flows. As the article ...
2
votes
2answers
110 views

How can we determine how much income our savings could generate if we purchase an annuity?

I am 62 and my wife is 56. We have almost 1.5 M in retirement investment and 250 K in non retirement investments. I was wondering if we both retire in 6 years and turn all our investment into annuity, ...
1
vote
0answers
74 views

Excel Canadian Mortgage Formula Help

I need to get the ending balance formula for a project in excel calculating mortgage payout. I am hoping to develop a formula instead of formulating an amortization table. I have used the following ...
1
vote
1answer
86 views

How do I calculate the return on my stock _call_ option, similar to my _put_ example?

I'm trying to figure out the effective percentage return when I write ("sell to open") a stock call option. I think I've figured it out for put options. Consider this put example I think XYZ stock ...
0
votes
3answers
47 views

IRR Calculation

I have a series of cash flows, a $1000 deposit, and then 5 annual withdrawals of $500,$400,$200,$200,and finally, $100. I understand this is an IRR calculation, and set it up as follows: ...
0
votes
2answers
384 views

Formula for how to distribute a loan payment between multiple loans such that the remaining principal accrues the least interest?

Assume 4 loans (Balance @ p.a. interest): $10,000 @ 5.5% $5,500 @ 7.25% $2,000 @ 5.5% $1,000 @ 4.5% If I am looking to pay $7,250 towards principal only, how would I calculate the ...
2
votes
1answer
76 views

How does Value get rounded in figuring out Bonds Value?

I was reading up on Bonds here on About.com Why Do Bond Prices and Yields Move in Opposite Directions? In the second example it offers: In this example, the opposite scenario occurs. The same ...
2
votes
2answers
367 views

Calculate the optimum contribution to Provident Fund(PF) account

I am fresh out of college and started working and want to work out how much I should contribute to my Provident Fund account to maximize the benefit from tax deductions. I am from India, so for those ...
0
votes
1answer
62 views

How can I calculate minimum payment on quick loan? [closed]

I am working on calculator for quick loans. Client can select how much he will pay monthly. Base on it payment schedule will be calculated. Payment interest depends on 1 payment period. Number of ...
-2
votes
1answer
192 views

Which of these unrealized profit calculations is correct? And, why other calculations are wrong?

Which of these unrealized profit calculations is correct? And, why other calculations are wrong? @ $10 per unit, $1000 - Subscription (100 units) $0500 - Cash dividend (50 units) $0500 - Reinvested ...