# Tag Info

### How do I calculate monthly compound interest in Google Sheets?

You just use the compound interest formula: Principle * (1 + Rate / Time) ^ Time For Cell C2 you want this formula: =B2*(((1+(D\$1/360))^(C\$1-\$A2))-1) Column A is deposit date Column B is deposit ...

### Do bank use the same math formula to calculate the mortgage amortization table?

Banks don't necessarily use the same formula, but in most countries they must disclose the effective interest you'd be paying (which may vary from the nominal interest due to extra charges and ...

I would say that all of the reasons you list in your question are valid, and I would add the following... You are in the landscaping business, not the accounting business. If you manage everything in ...

### How do I calculate monthly compound interest in Google Sheets?

The "Future Value" function does this. =FV(rate, number_of_periods, payment_amount, present_value, [end_or_beginning]) For example: =FV(2%, 12, -100, -400, 0) Note that the payment_amount and ...

### Help me understand and calculate credit union interest in Google Sheets

0.250% of what? Because \$100 x 0.25% = \$25. How am I getting \$0.02 a month? You're confusing "25%" (twenty-five percent) with "0.25%" (one quarter of one percent). Your credit union is making ...

### Shared groceries expenses between roommates to be divided as per specific consumption ratio and attendance

Bren's comment is right on the mark. The typical solution is to divide all bills by 5, and for special items, the person buying it just marks his name that it's not community food. Your attempt at a ...

I think your reasons are good. Fundamentally accounting software is built to ensure you record your accounting data effectively with minimal mistakes and good auditing. But you still need to use the ...

### Do bank use the same math formula to calculate the mortgage amortization table?

The mathematics on which the usual formula is based is that the sum of the payments d, each discounted to present value (PV) by 1/(1 + r)^k, should equal the initial (present value) value of the loan ...

### Clarify Microsoft's explanation of MIRR

The MIRR formula uses the finance rate to discount negative cash flows, but since the only negative cash flow in the example in in the current period, there's nothing to discount. It's meant to solve ...

### Shared groceries expenses between roommates to be divided as per specific consumption ratio and attendance

For a personal finance forum, this is too complicated for sustained use and you should find a simpler solution. For a mathematical exercise, you are missing information required to do the split fairly....

### Shared groceries expenses between roommates to be divided as per specific consumption ratio and attendance

When I was in grad school (at an engineering school) my apartment-mates and I came up with this formula: We each bought 100% of the food we intended to consume. We each consumed 0% of the food ...
Accepted

### Excel calculating interest rate on loan

The solution uses the PMT function which has the syntax: PMT(rate, nper, pv, [fv], [type]) where Fv is Optional: The future value, or a cash balance you want to attain after the last payment is ...

Use this formula in Google Sheets: =IMPORTXML("https://www.google.com/finance/quote/TSLA:NASDAQ","//table//tr[contains(@class,'roXhBd')]") This will bring up a list of the company'...

I would add to your reasons: QuickBooks makes it easy to send statements or invoices to customers that request them QuickBooks has a number of built in reports that may give you insight into how your ...

### How do I calculate portfolio standard deviation in Excel?

To calculate the variance of a portfolio you also need the weights of each asset (ω(i)), and the correlation (or covariance) between each asset (ρ(ij) or COV(ij)). From there, the formula is: σ²(p) =...
Accepted

### How to calculate the number of months until a loan is paid off (given principal, APR and payment amount)?

The formula for determining the number of payments (months) you'll need to make on your loan is: where i=monthly interest rate (annual rate / 12), A=loan amount (principal), and P=monthly payment. To ...
Accepted

### XIRR not working for this dataset. Any other method to calculate rate of return?

This is the internal rate of return (IRR) calculation for the second case. There are 731 days from 2016-02-16 to 2018-02-16. f2 = -13660 - 20000/(1 + r) - 19900/(1 + r)^(700/731) - 19880/(1 + r)^(...
Accepted

### Excel formula for calculating interest rate of earning

I believe the 2.63% is the rate. That's what: =RATE(20,-1238,0,32880,1) gives, as does: =XIRR(R2C2:R22C2,R2C1:R22C1) (with 1238 in R2C2:R21C2, -32880 in R22C2, 1/1/95 through 1/1/14 in R2C1:R21C1, ...

### Shared groceries expenses between roommates to be divided as per specific consumption ratio and attendance

So your whole approach, and the attempt to scale this is flawed. You will alienate roomates, provoke arguments, and make everyone's life more difficult. There are too many variables and unforeseen ...
Accepted

### Building Marcus Savings Calculator in Excel

The 2.25% is an annual effective rate (same as APY) e = 0.0225 Converting the annual effective rate to a monthly rate r = (1 + e)^(1/12) - 1 = 0.00185594 Compounding the principal, with n = 24 ...
Accepted

### How to adjust for long term inflation in an investment plan

(1+return)/(1+inflation)-1 would be more accurate (it discounts each year's return by the level of inflation), but your formula is often used as an easy estimate for small levels of inflation: (1.11 /...
Accepted

### Monthly Compound Interest calculation

Your formula gives you daily compounding, assuming the annual interest rate was calculated on 360 days (a slightly shorter ‘year’ than a natural year, but not unheard of in the finance industry). If ...
Accepted

### Is the S&P500's excess return above Treasuries after investing monthly for forty years really 3.6% annualized?

Self-answer—how awfully embarrassing, I had a bug in how I was handling dividends, in both the Google Sheets spreadsheet and in the webapp, in JavaScript. (I was basically not reinvesting dividends…)...
Accepted

Now I try to cumulate the interest (for 1 month) with following formula: CUMIPMT(annualRate/12, loanYears*12, loanReceived, 1, 2, 0) - I receive 237 That formula is calculating the first two months. ...

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

Assuming the rate is 4.35% nominal, compounded monthly, in Excel the formula would be =PMT(0.003625,360,275000) resulting in -\$1,368.98 You can also use the mathematical formula here: http://www....

Why use spreadsheets rather than writing your forms and formulas directly in a programming lanuage? Because you've got better things to do than reinvent the wheel, right? Same answer. ===== ...

Since this is a cooperative I'm guessing your partners may want to be able to view the books so another key point you may want to consider is collaboration. Who is going to keep the "master" .xls ...
Accepted

### Shared groceries expenses between roommates to be divided as per specific consumption ratio and attendance

The solution to this problem is somewhat like grading on a curve. Use the consumption ratio multiplied by the attendance (which is also a ratio, out of 100 days) to calculate how much each person owes....