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
2k 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 ...
0
votes
1answer
2k views

How to determine if a bid-ask spread is “good” or “bad”?

Is it possible to weight the bid-ask spread? I'll explain ... In the moment, for a share X, to trade I use the price, volume, $ volume, # trades, % chg and the bid-ask spread (BAS). To make day ...
1
vote
2answers
151 views

What would be my total saving with an increasing and regular yearly deposit after 30 years?

Let's say I deposit $50,000 into the bank and in the first year I put in an installment of 5,000 and the interest is calculated monthly at 7%. In the second year, all is the same except for my yearly ...
3
votes
2answers
3k views

What is the formula for calculating the mortgage constant when payments are made at the beginning of the period?

In this case, the mortgage constant (or loan constant or debt constant) is the (in my case, annual) ratio of constant payments to the original amount, like here: http://www.double-entry-bookkeeping....
3
votes
2answers
163 views

How to compare loans of same principal, same interest but with different tenors

I have a scenario where there are 2 loans that can be provided (assuming I am providing the loan). The principal amount is the same, 30,000 in case of both the loans. The interest is also same at 17%. ...
3
votes
2answers
4k views

Compound daily interest with monthly deposits over x amount of years in excel

This is compound interest calculated daily and topped up with deposits every month e.g Begin with $100, earn 2% interest earned daily even on weekends, and then come month end invest another $100 on ...
3
votes
1answer
2k views

If I earned 40 Social Security credits by age 40, do I get benefits regardless of work or income in the years after I earned the 40 credits?

If I earned 40 Social Security credits by age 40, do I get retirement and disability benefits regardless of work and income in the years after I earned the 40 credits? So for example: if by age 40 I ...
1
vote
2answers
699 views

Calculate APR from balloon loan

I need formula to calculate nominal APR from balloon loan with contract fee. The initial data and payment schedule is: Loan sum: 10 000€ Interest rate per year: 15% Loan period: 2 years Payments ...
2
votes
2answers
227 views

When does a work calendar-month start and end?

This question might sound stupid, but I am unable to find any answer to this. Suppose I am getting paid on 26th Jan, does that mean January started or ended on the 26th? I am building an app that ...
4
votes
2answers
135 views

Daily Interest Monthly Compounding Multiyear

I downloaded the Excel spreadsheet mentioned in the accepted answer to this question: Daily interest calculation combined with monthly compounding: Why do banks do this, and how-to in Excel? It was ...
-2
votes
1answer
114 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.) ...
5
votes
3answers
23k views

How to calculate stock price (value) based on given values for equity and debt?

If a company has $80 million in equity and $20 million in debt, this means that total firm value = D + E = $100 million. Am I then right to assume that if there are 1 million shares outstanding, then ...
6
votes
4answers
28k views

What Excel function to use to calculate the return or interest rate on a savings account?

I'm getting confused by Excel's various different financial functions. Which one would I use to answer the following two questions and how? Suppose that on October 1st, 2012 I open a savings account ...
3
votes
2answers
1k views

Adjusting a value for inflation each month using rolling 12-monthly inflation figures

I have a figure that I want to adjust for inflation each month. I have monthly values for the UK Consumer Price Index but these are each for the change over the preceding 12 months. If my base value ...
2
votes
2answers
273 views

How to calculate worth of money N year ago from given inflation value

I want to calculate worth of money N years ago. Based on this post, it can be calculated using CPI, but I want to use given inflation value N years ago. It better if I can get reference(s) of formula ...
1
vote
1answer
146 views

Calculating gain percentage for 24h, 7d, 30d, 3m, and so on

When we see gain percentage numbers like: +7.01% (24h), -0.43% (7d), +31.33% (30d), and so on, how are they usually calculated? For example for the 7d period, is it calculated using: ([average price ...
1
vote
2answers
102 views

How to pick from several products/services to maximize utility considering the cost of each option?

What is the proper way to consider the utility of a product/service versus its cost in order to make the best rational decision to get the "most for my dollar" if there are several choices for me to ...
0
votes
2answers
478 views

How to calculate APR for a fixed rate loan due before amortization end date?

I need help with the following question for a homework assignment related to finding the APR for an investment class. Here's the question: Calculate the APR for a $500000 fixed rate loan amortized ...
2
votes
0answers
54 views

Implied appreciation of a currency

I have a very specific question in regards to a forward calculation. The USDEUR spot rate today is 0.759503. Libor and Euribor forward rates for the NeXT year are as follows: Fwd 3m Libor 0.00288 0....
13
votes
5answers
3k views

How to calculate car insurance quote

I'm trying something in related to Auto Insurance and when I went through the State Farm's insurance portal, it asked me for a couple of questions like below. Vehicle ownership Car Age Person's Age ...
4
votes
3answers
15k views

How to calculate new price for bond if yield increases

I am learning for a class that is partly about finance and I don't have any background in finance at all. I am struggling with a question that was asked in last years exam: A bond trades at £1015, ...
0
votes
1answer
331 views

How to read WSJ US Treasury quotes

I am trying to understand how they calculated "asked yield". If anyone can explain it, I really appreciate it. I would like to see the mathematical formula and the calculation.
1
vote
2answers
717 views

Calculating theoretical Present Value

If I were to win the lottery and the present winnings were less than twenty million paid out over a time period of twenty years, how would I theoretically find the present value amount?
0
votes
2answers
60 views

How to model fees from trades on online platforms?

So stock exchanges like super trade or options express have thresholds for the way they price trades on their platform. So for instance, say for less than 100 trades it costs $17 per trade, and then ...
0
votes
1answer
63 views

How does a “minimum number of items to be bought” factor into break even analysis? [closed]

Let's say I am trying to find out how long it would take me to break even with a business venture. My fixed costs are x (let's say $20,0000) My Revenue per item sold is $50 My variable cost is $25 ...
1
vote
1answer
381 views

How do I calculate dividend growth rate if one of the years doesn't pay out any dividend?

According to http://www.investopedia.com/terms/d/dividendgrowthrate.asp , this is how I'm going to calculate dividend rate. Year 1 = $1.00 Year 2 = $1.05 Year 3 = $1.07 Year 4 = $1.11 Year 5 = $1.15 ...
2
votes
5answers
5k views

How do I calculate a simple moving average for stock prices?

To give a little context, this is for a programming assignment at school so the simplest form of proper moving average is all that's needed. I've searched around and seen the summation formulas and ...
1
vote
2answers
491 views

equivalent monthly cost with multiple interest rates

Is equivalent monthly cost equal to equivalent annual cost divided by 12? Also, using the equivalent annual cost HERE, how would I change the formula for differing rates over the period of time. ...
0
votes
2answers
1k views

How to calculate the price of a bond based with a yield to Maturity, term and annual interest?

I'm trying to help my nephew with finance but I'm not sure if I fully understand if I have all the necessary details to answer this question. Here's the question: Say you want to purchase a 7%, 15yr ...
2
votes
3answers
10k views

How is interest in my bank account calculated?

I am a software professional. I have one question. How do banks calculate interest on money deposited, if I get, say, 10% per annum? Say I deposit say Rs.1000 on the 1st day of the month; then I ...
0
votes
1answer
2k views

Risk free rate formula breakdown

In risk free rate formula below why is 1 added on numerator and denominator and the value is substracted by 1 Rf = (1+nominal risk free rate)/(1+inflation) -1
3
votes
2answers
121 views

Why is the estimated monthly income state-dependent on CNNMoney's annuity calculator?

Why is the estimated monthly income state-dependent on CNNMoney's annuity calculator? Example: CA (376 USD) vs. IL (385 USD) Estimated monthly income: $376 Estimated monthly income: $385 I ...
2
votes
1answer
107 views

Converting interest rates

I have found a monthly interest rate, 0.72% Now, I would like to convert this monthly rate to: Equivalent annual nominal rate of interest payable half yearly, and Equivalent annual nominal rate of ...
2
votes
1answer
831 views

Excel calculating interest rate on loan

Not sure if this is the right place to ask this type of question, apologies if it isn't. I am following this explanation on office support to answer my own question. Using the values they use, what ...
38
votes
9answers
55k 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 ...
11
votes
3answers
8k views

Is there a term that better describes a compound annual growth rate (CAGR) when it is negative?

When calculating rates of return for an investment or portfolio over time, whether to report or compare performance, one frequently calculates the Compound Annual Growth Rate (CAGR). I've got a ...
2
votes
2answers
2k views

paying with cash vs. paying by loan and investing the money

I recently read an interesting idea in Robert Kiyosaki's book "Rich Dad, Poor Dad". His suggestion was that even if you have enough money to buy a car with cash, you would better get a loan, invest ...
-1
votes
1answer
42 views

How to calculate Stamp duty of North Territory in Australia?

Northern Territory Stamp Duty - General Rate Duty is calculated on the purchase price or unencumbered value of the dutiable property, whichever is the greater, as follows: Where the dutiable value ...
8
votes
2answers
2k 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 ...
1
vote
1answer
241 views

What is the meaning of Volume factor?

I want to calculate T3 Moving Average. In order to calculate T3 Moving Average, it need Volume factor, But I don't know Volume factor. What is the meaning of Volume factor as a terminology of ...
7
votes
1answer
820 views

Thorough Description of Yield to Maturity?

After some studies for the last month, I have encountered a concept that has just completely eluded me, and that is Yield to Maturity (YTM). Can someone explain the purpose and reasoning behind this ...
2
votes
2answers
489 views

Cost of Living Adjustment [closed]

I am looking for an entry level Electrical Engineering Job and have 3 current offers. Assuming benefit packages are close to the same, which one is better when taking into account the cost of living ...
0
votes
1answer
52 views

Average Price and Percentage Gain

I am finding hard to arrive at the average price when there is a sell happened at much profitable price partially Could you please advice me to arrive at the average price and the % gain for the ...
0
votes
1answer
122 views

How do I calculate my average price for a share bought multiple times?

Let's assume below as my transactions: bought 10 at 120 bought 20 at 150 sold 15 at 170 What will be the average price of my holdings i.e., for 18 shares. Is it 110 ?
2
votes
1answer
9k views

How to calculate the return over a period from daily returns?

If I have daily returns of my portfolio over a period (let's say January to December), how do I calculate the total return over the period or per month? What I did now is the following: Calculate ...
3
votes
3answers
103 views

Calculating profits for a private fund

I'm running a small private mini-fund with and for a small group of friends. We pool the money and I use it to trade securities on all our behalf. Profits/losses are realised both from capital gains ...
1
vote
3answers
949 views

Calculate a weekly payment on a loan when payment is a month away

I'm trying to calculate a payment on a loan given the standard P=r(PV)/1-(1+r)^-n formula. How do I factor in interest accumulated if the first payment isn't due for 31 days? For reference, interest ...
1
vote
1answer
82 views

Is there a better term that means “the amount subject to a commission rate”? [closed]

If you were building a commission report laid out like the example below, is there a succinct term or word that would work well for the third column? Employee Commission Type ??????????????? ...
1
vote
1answer
138 views

Should I pay for the whole year first or pay in monthly installments?

I have two options for getting a new internet connection. Option A - Pay 2500 for the router and then pay 500 at the end of every month for the next twelve months. Option B - Pay 6000 for both the ...
0
votes
1answer
842 views

Calculating Interest Accrued for a late payment

I'm trying to calculate the interest accrued on my amortization schedule manually. I can calculate it fine if payments are exactly one month apart but this payment is More than 1 month apart. This ...