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
1answer
153 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 ...
2
votes
0answers
41 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 ...
4
votes
2answers
299 views

Formula to decide when to break a Certificate of Deposit (CD)?

I'm trying to create a certificate of deposit (CD) comparison tool and have been working on a formula to compare a CD with a higher interest rate to a CD I might own with a penalty period. I believe ...
5
votes
2answers
3k views

How to translate old price amounts to their modern day equivalents?

I hope this is the right place to ask. :) I'm currently working on what is to be a wiki/encyclopedic website. Some articles contain amounts or prices like construction costs and such, but since these ...
1
vote
1answer
65 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 ...
6
votes
6answers
4k views

Why do mortgage affordability recommendations use gross income?

Whenever I see someone ask how to calculate how big a mortgage he can afford, the answer almost always comes back as a percentage of gross income. Why use gross income as the baseline? Why not net ...
0
votes
2answers
42 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
70 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
35 views

Calculate a realistic project valuation?

If we have a profitable project where profit is x and cost of equity is y and the project has 0 growth and nothing else changes, then the value according to a perpetuity will be x/y e.g. profit this ...
0
votes
0answers
35 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
60 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
28 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
97 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
51 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 ...
9
votes
4answers
389 views

How do you go about calculating how much you need after retirement?

I am posting this question after reading this article on WSJ, where it says: Just 42% of working-age Americans have even tried to calculate what they will need in retirement, according to the ...
0
votes
2answers
240 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 ...
0
votes
3answers
64 views

Personal Loan issuer online service

I have chunk of money that I would like to loan to my brother. I would like to charge him interest same as banks do. Is there a website or online service where I can enter the "loan" amount, ...
9
votes
3answers
2k views

Buying a more expensive house as a tax shelter (larger interest deduction)?

I've heard that some people buy a more expensive house as a tax shelter. In my simple mind I imaging the scenario: Pay 10,000 annual interest on the mortgage 50,000 annual income = 40,000 ...
0
votes
3answers
40 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: ...
1
vote
0answers
37 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 ...
0
votes
1answer
51 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
137 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 ...
1
vote
1answer
172 views

Find monthly interest rate from principal, monthly payment, and loan's term?

Is there a formula to find the monthly interest rate required on a compounded interest fixed-rate mortgage loan, given the principal, the monthly payment, and the loan's term?
3
votes
2answers
3k views

What is the equation for an inflation adjusted annuity held in perpetuity?

What is the equation relating an initial investment, a fixed rate of return, an inflation rate, and a perpetual payment adjusted for that inflation rate?
2
votes
2answers
8k 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?
5
votes
3answers
854 views

Is this the correct math for estimating federal taxes using marginal tax brackets?

(I updated this because I think I wasnt making myself clear in the first part of the question and I clarified what I'm trying to do. I'm just looking to use marginal tax brackets to derive a good ...
4
votes
1answer
412 views

How do we correctly sum up returns

Assume I have done 8 trades and calculated the profit (or loss) of each trade: Balance PnL 100 102 2.00% 105 2.94% 103 -1.90% 101 -1.94% 98 -2.97% 97 ...
3
votes
1answer
47 views

How should I include pension contributions in my UK Child Benefit calculations?

I'm using the gov.uk Child Benefit Tax Calculator and I don't know how I include my pension contributions in the "Pension contributions deducted from your pay" and "Pension contributions not paid from ...
6
votes
2answers
224 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 ...
7
votes
2answers
880 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 ...
9
votes
7answers
401 views

What single metric is the ultimate measure of personal wealth?

More specifically, what is the single metric you would use to monitor personal wealth?
1
vote
3answers
104 views

What is the meaning of “$N industry”?

For example, in the sentence "Semiconductor fabrication is a $100 billion industry.", what exactly is being said?
-1
votes
1answer
177 views

How to calculate forward price for asset with dividend?

I have this exercise question: A particular forward contract costs nothing to enter into at time t and obliges the holder to buy the asset for an amount F at expiry T. The asset pays a dividend DS at ...
4
votes
3answers
144 views

How can I calculate yearly interest of my investment gain?

I'm trying to figure out the yearly interest of a potential investment. Lets say I invested $10 000, 13 days later i cash out and I now have $10 500. The interest here is 4,76% for 13 days. But can I ...
2
votes
2answers
110 views

How to calculate whether it's better to pay my education loan, or my home investment loan?

I have an education loan @ 11.5 % for 1,000,000. I can pay it in 3 years. I am planning to make an investment by buying a home @ 10.5% for 2,200,000. Term = 20 yrs. I am thinking if I sell the house ...
6
votes
3answers
707 views
3
votes
3answers
606 views

Negative properties of continuously compounded returns

I'm taking an intro to quant finance course online. I'm trying to better understand the properties and uses of continuously compounded returns. Specifically for this question, how can you have ...
2
votes
2answers
559 views

When to use geometric vs. arithmetic mean? Why is the former better for percentages?

While computing the average price of a stock or index over a period of time, I have the choice between using an arithmetic mean or a geometric mean. Which should I use and when? I am reading a book ...
0
votes
1answer
337 views

Google Finance: Input Parameters For Simple Moving Averages

I'm having some trouble understanding the simple moving average lines that can be added to a quote graph from Google finance. This related Stack Exchange question indicates that the only input ...
2
votes
2answers
152 views

How to calculate ROI on investments? [duplicate]

I looked through the previous questions, and couldn't find one that quite addresses my question. If I start with $1000, and through investing it goes to $1200(100 shares at $10 go to $12), I can say I ...
4
votes
5answers
34k views

How do I calculate net monthly salary (after taxes) in Germany?

If I were to say that my yearly, gross salary was 50,000 euros, then what would be my monthly net after-tax income? For example, this calculator looks OK to me: ...
3
votes
2answers
184 views

How can I calculate (approximate) the future value of my investments? Is this formula appropriate?

I want to check to see if I'm meeting my investment goals, so I want to project forward my assets given a growth rate and a monthly deposit amount. What is the best formula to use for this? Is this ...
1
vote
1answer
79 views

How can I check if my mortgage balance is correct?

Since I couldn't easily get my unpaid principal balance, I calculated my mortgage balance using a handful of online calculators. Today I took a look at the actual balance, and was rather surprised to ...
1
vote
1answer
67 views

Reasonable alternatives to using the Treasury rate as the risk free rate, e.g. for CAPM calculation?

For all practical purposes, the risk free interest rate is taken to be the short term Treasury bill interest rate. Let's say this rate is 0.5% per annum. But for an individual investor, if his bank ...
5
votes
3answers
2k views

In the event of a corporate spin-off, how can I calculate the correct cost basis for each company's shares?

Consider this example: Siemens is going to have a spin-off (next Monday). If I owned, say, 10,000 shares of Siemens bought at an average price of 80 euros, my cost would be 800,000 euros. In the ...
2
votes
1answer
2k views

How do you calculate the P/E ratio by industry?

I would like to know how to calculate the P/E ratio by industry. On this website, it displays the P/E ratio for the current stock, the industry and the sector: FINANCIALS DTV.O ...
3
votes
1answer
136 views

How to determine withholding so at end of the year I neither owe more, nor get a refund?

A while back I was on a W2 job and I would get a large sum on my tax return. At one point I found a calculator that helped me figure out how to configure my W4 so that I would neither owe nor be owed ...
1
vote
1answer
139 views

How to calculate how far a stock price can drop before a broker would issue a margin call?

Let's say the margin requirement for a stock XYZ is 50%. The current price of XYZ is $150/share. Let us say I put in $100, and borrow $50 from the broker to buy a share. Typically, how far can the ...
2
votes
4answers
2k views

How to calculate money needed for a retirement based on an hypothetical death date & expenses?

I would like to know what formula or tool I need to use to calculate the capital needed for a hypothetical retirement that will start at date X and end at date Y. Here is an example: Variable1 = ...
1
vote
2answers
122 views

Suppose earning an APR of 7% for 5 years, with interest compounded quarterly. What is the EAR? What is the Total Return?

Suppose you earn an APR of 7% for 5 years, with interest compounded quarterly. What is your EAR? What is your Total Return? The part I am confused is "with interest compounded quarterly" The ...