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
1answer
215 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) ...
0
votes
1answer
57 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 ...
1
vote
1answer
76 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
60 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 ...
12
votes
3answers
44k 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 ...
1
vote
1answer
81 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 ...
11
votes
7answers
12k 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 ...
1
vote
2answers
169 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
0answers
72 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 ...
4
votes
2answers
2k views

How to recalculate an amortization table after making a large payment?

I have an auto loan I wish to apply a very large amount to. I have a amortization table that shows me details for each payment I make. Here's where it gets complicated... My lender does not allow ...
7
votes
2answers
27k 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 ...
2
votes
4answers
141 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 ...
2
votes
2answers
21k 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 ...
0
votes
2answers
431 views

Exchange rates - is my math correct here?

Using an online exchange rate calculator, and Numi (a calculator that does it as if it's written by hand, for Mac OS X) for my calculations, it says: 1 GBP in USD = $1.32 1 USD in GBP = £0.76 Is ...
0
votes
0answers
32 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
126 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 ...
2
votes
2answers
180 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 ...
2
votes
1answer
4k views

How to calculate new price for reverse split?

I have the following position ABC 500 shares @ $120.00 ABC is trading at $15.00. $60000 - $7500 = -$52500 ABC did a reverse split 1:5. An 80% decrease in shares. After the split, it is trading ...
-3
votes
1answer
337 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
61 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 ...
0
votes
1answer
560 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% ...
4
votes
2answers
6k views

What are the standard industry practices or disclosures for computing compounded interest on retail deposit accounts in the United States?

I'm seeking to understand how my bank calculates the interest on my various deposit accounts (Money Market, Interest Checking, Savings, Certificate of Deposit) in order to simulate and predict it to a ...
3
votes
2answers
37k views

converting annual interest rate to monthly when compounding frequency known

Just like the title I'm looking for the formula to convert APR to monthly when I also know compounding frequency eg APR is 8% and being compounded daily what is the monthly interest rate I earn. Or ...
2
votes
1answer
156 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 ...
3
votes
2answers
986 views

A calculator that takes into account portfolio rebalancing? [closed]

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 $10,...
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-...
3
votes
2answers
304 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
31k 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?
6
votes
4answers
6k 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 ...
2
votes
3answers
342 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
108 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
56 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
61 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
240 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 ...
-1
votes
2answers
91 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 ...
11
votes
4answers
68k 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 ...
3
votes
3answers
14k 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 ...
2
votes
2answers
217 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 ...
2
votes
1answer
288 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
80 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
339 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
324 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://...
1
vote
2answers
53 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 ...
2
votes
2answers
305 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 ...
4
votes
2answers
1k 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 ...
0
votes
1answer
82 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
303 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 ...
2
votes
3answers
4k views

compute the principal and interest for a specific month (period) on an amortized loan

I can easily compute the monthly payment for a loan given the amount, the number of periods, and the periodic rate. From that, I can easily build an amortization table iteratively by subtracting the ...