Recent content by bradles

I'd like to try and develop a formula for it...but I'm not sure it's possible. I can simulate it on a spreadsheet but it requires a lot of data and it gets slow in the calculations. I thought I could develop a formula to save all the number crunching.

Let me explain. I will change from a straight 30 days being one month though...just to make things more complicated...sorry. You start out with a loan of $500,000. Each day 8.59%/365 * $500,000 accrues in interest for 14 days until you make a payment of $2,500. So the balance at day 14...

Does anyone know how I can work out a formula to calculate how long it will take to pay a loan back to zero if the interest is on a loan is calculated daily but compounded at the end of the month. To add another level of complexity, assume you are making fortnightly repayments. P (Principal)...

Thanks Uart, Thats great. I see what you mean about binned data, especially the open ended upper range of the last category. I'm still learning. This is handy to reference. I'm going to see if I can experiment with it a bit more for collecting better data and getting better results...

Ok. I'm fairly new so go easy on me. I apologise if this is posted in the wrong section. Can someone point me in the right direction of being able to work out samples of a web poll. A web poll I did returned the following results for a sample of 40 people and spending habits of a...

Hi All, I was wondering if it is possible to work out a formula for calculating what your gross earnings would have to be to earn a certain net value. The tax on earnings scales go like this: Between $0 - $6000 you pay no tax. Between $6001 - $25000 you pay 15c per dollar. Between...