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...