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

0
votes
0answers
46 views

Predicting future expenses

I'm trying to develop a tool that predicts my future expenses based on my past expenses. Example: I've spent $150, $200, and $180 on fuel during each of the last three months. Accounting for the ...
0
votes
1answer
34 views

How do I calculate the Present Value of a future amount

I have a requirement to calculate the present value of a future value taking into consideration an interest rate and tax rate. This is to be used in an insurance calculator so I need the answer to be ...
3
votes
0answers
67 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 ...
3
votes
1answer
273 views

How to find an optimum linear combination of various investments?

Say an investor with 1 million dollars want to put his money on several investments. Say investment outcomes on those investments are $x_1, x_2, x_3, x_4, ... x_n$ The investor need to put w1 on x1, ...
0
votes
1answer
117 views

How to calculate depreciation?

I am not accountant and my question could be trivial but I will ask it. Let's say that I bought a car that cost $50,000. The maintenance cost over 5 years is $25,000. The revenue of the car over 5 ...
0
votes
1answer
48 views

Why Are Percentage Gains Used for Capital Gains Tax Calculations?

In the context of UK investments, I'm led to believe that encashing a general investment account (OEIC/UT) can result in a capital gains tax liability. My understanding is that when calculating this ...
4
votes
1answer
48 views

How do I calculate the modern-day value of pre-euro currencies (inflation correction)

I'm trying to calculate the modern value of 1950's Dutch guldens (guilders). Usually I'd use Wolfram Alpha for such a task, but it doesn't seem to understand pre-euro currencies. This works fine: ...
3
votes
1answer
73 views

Does the Social Security taxable wage cap also cap payouts, not just contributions?

I recently saw Bernie Sander's quote: Right now, Trump pays the same amount of money into Social Security as someone who makes $118,500 a year. Time for a change. Now this seems to be true. ...
4
votes
5answers
830 views

If you buy something and sell it later on the same day, how do you calculate 'investment'?

Source: p 603, A Concise Introduction to Logic (12 Ed, 2014) by Patrick Hurley A similar misuse of percentages is committed by businesses and corporations that, for whatever reason, want to ...
4
votes
3answers
150 views

How do I calculate the starting balance required

Suppose I require a payment of $25,000 per year over 20 years, with an inflation rate of 3%, an earning rate of 5%, a tax rate of 20% and a final balance of $0. What is my starting balance to achieve ...
1
vote
1answer
66 views

How to calculate mutual fund return

How do you calculate the annual return of a mutual fund? I understand roughly how mutual funds work, and I'm trying to decide which mutual funds to invest in, but to prove to myself that I understand ...
2
votes
3answers
108 views

Simple Interest to Compound Interest

In simple annual interest terms 60/2000 is 3%. But what is the rate if this is the total interest paid on 2000 after monthly compounding over 3 years?
1
vote
1answer
45 views

IRR vs. Interest Rate

I'm working on a project, and I have problems with the understanding of certain areas. I don't understand why the increase in interest rates increases the IRR? Could someone explain this to me?
-3
votes
1answer
43 views

Can I evaluate the performance of a company using just OHLC data?

Is there any way to calculate finance for a company if I have Open, Close, Low, High, Adjusted Value of stocks and it's trade volume in each day, for 6 months? I read many ways to calculate the ...
4
votes
2answers
89 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 ...
2
votes
2answers
91 views

Compounded Interest on Mutual Funds

I may be missing or misunderstanding something regarding how compound interest works with mutual funds and ETFs. Let's say I have $10,000, and I invest said monies in mutual fund XXXXX at $100/share, ...
9
votes
2answers
156 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 ...
0
votes
0answers
25 views

Calculate rate of return

If I sell my bond at $982, then reinvest it with market rate of 12% Coupon is $100, face value is 1000, what would be my rate of return my 2nd year? Yield to maturity is 2 years. I've calculated my ...
2
votes
2answers
161 views

How would I compute the difference between purchase and lease-to-purchase offers?

I'm looking at getting a new car, and this Toyota Avalon lease deal seems like a better deal then buying. However, I've always heard that leases are not the smart way to go. When I do the math the ...
2
votes
1answer
43 views

Why do dividend reinvestments not match my calculator?

I've seen this occur numerous times in my IRAs. In the transaction section of my Fidelity IRA, it shows a line item Reinvestment XXX with a dollar amount. Clicking the details will display the ...
9
votes
3answers
1k 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. ...
4
votes
2answers
135 views

How do you calculate the annualised return of your portfolio from the annualised returns of each of your funds?

I've invested in a number of mutual funds, and I've calculated the annualised return of each of them, using a spreadsheet (and the xirr function). I want to calculate the annualised return of the ...
2
votes
2answers
43 views

Calculation for Hypothetical Short Position

I'm trying to calculate the gain on a short position. I think I have the correct calculation, I just want to make sure I am correct. Here's the data: 1. Entered position with stock price at $28.07. ...
1
vote
0answers
34 views

Add-On CD Formula

I'm starting to learn a lot about finance/investing on my own but I'm struggling with the calculations behind Add-On CDs. I opened an 14-Month Add-On CD with a $1000 deposit with a monthly $30 add-on ...
11
votes
1answer
694 views

Why might Social Security employee deductions from paycheck vary across pay periods?

What percentage of salary deducts for an employee's Social Security contribution? And why will there be a difference in % deducted? My salary statement for October and September 2015 has the same ...
1
vote
1answer
61 views

How much in CPP contributions do you pay when you are an independent contractor?

I am trying to figure out how much CPP contributions an IT contractor needs to make as per this CRA guide. It says that for self-employed people, we need to contribute $4959? So, if an independent ...
2
votes
1answer
80 views

Checking the math on a Truth-in-Lending Disclosure

Here is a shot of an actual Truth-in-Lending statement for a real home mortgage (mine). I'm trying to check the numbers but they seem slightly off: It's a 30-year fixed rate mortgage. The annual ...
1
vote
2answers
85 views

What would be my tax liability in Zurich, Switzerland?

What would be my tax liability as a single individual, resident of Zurich (not citizen), not a member of any church, with a 90,000 Swiss Franc yearly salary? Let's just take into consideration basic ...
1
vote
1answer
45 views

Excel formula for calculating interest rate of earning

On January 1st I invest 1238. I do this every January 1st for 20 years. At the end of 20 years (So December 31st of the 20th year), I have 32880 in the account. What's my rate of interest? By playing ...
1
vote
1answer
39 views

Calculating long intervals of Interest with Simple Interest Formula

My last post Calculating long intervals of Interest calculates interest using compounding formula. But what about calculating simple interest accrued where the day count is actual/actual and it goes ...
2
votes
2answers
62 views

Calculating long intervals of Interest

Small interval calculations is fairly straight forward. But what about long intervals. If a loan's daycount is set to Actual/Actual and the duration has run into two different DayCount intervals, how ...
4
votes
2answers
118 views

Stochastic Oscillator for Financial Analysis

I have been using the stochastic oscillator indicator to get some insight on particular stocks. Below is an example of a 14-day lookup period for K where D is a calculated as a 3-day average of K. ...
2
votes
3answers
437 views

Hypothetical: can taxes ever cause a net loss on otherwise-profitable stocks?

Let's imagine a hypothetical situation: I start with $100, and buy 10 shares of a company at $10 each. The next day I sell the 10 shares at $12 each. A week later, the price drops back to $10 and ...
2
votes
1answer
194 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
2answers
62 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 ...
1
vote
1answer
29 views

Why SUM(PMT) is not identical to FV?

I'm exploring financial functions in a spreadsheet. When I use FV, which is based on FV = PV*(1+r)^n I get a different number than when using PMT and multiplying by the number of periods. For ...
3
votes
2answers
93 views

Getting correlation from regression slope (Completely stumped)

This question is from a book (Active Portfolio Management), but unfortunately there are no provided solutions. "Assume that residual returns are uncorrelated across stocks. Stock A has a beta of ...
3
votes
2answers
142 views

Is it beneficial for me to refinance my house at a lower rate?

Is it advantageous for me to refinance my house at a lower rate? My loan has the following information: Primary Residential Home: Current Principal Balance* $53,128.51 Current Interest Rate 4.125 % ...
2
votes
4answers
195 views

Why does ExxonMobil's balance sheet show more liabilities than assets?

In analyzing balance sheet of ExxonMobile, based off of Yahoo Finance report, we run into the following figures for the year: Current Assets: 51,647,000 Total Liabilities: 175,592,000 Now Current ...
1
vote
1answer
88 views

Calculating average interest rate with intermittent deposits

I invest in a few medium to low risk accounts online (peer to peer loans and buy to let property crowdfunding). I make regular deposits into these accounts, usually when the monthly salary comes in, ...
2
votes
2answers
70 views

Liquidity Balance Sheet

Should be or should we not deduct long term debt along with current liabilities from total current assets to arrive at current asset value per share?
1
vote
1answer
128 views

Formula to compute 10 year US governement bond price given yield

What is the formula to convert US govy 10 year yields (as those shown here) in to bond prices? I know in general the math looks like this but I don't know what the values of the variables are for a ...
1
vote
0answers
56 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
2answers
103 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 ...
2
votes
1answer
68 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
267 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 ...
2
votes
2answers
349 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 ...
1
vote
1answer
34 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
3answers
117 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
111 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 ...