Ok, my dad borowed a lot of money from me. He said he would give me my money back with an interest rate of 21.99% if I made an Excel program that counted it. Is there some special way doing it? Because I can't do anything but a manual formula for each line. Is there a formula that calculates the amount for entire amount of months automatically? Thanks. All I keep doing is "=A1*0.2199+A1" or something like that. I think there is something like "=A1:B4" so you wouldn't have to go to each cell.
How much did he borrow? How often is it compounded? And is it 21.99% percent per month or per year? Per year, that about what the cc companies charge, and that's a rip off, but per month that is just ridiculously high.
That's per year. And no, I am not worried about percentage being high because he told me that by himself. There are several amounts, $100 or $300 and such. What are compounds? Ok.
Your taking the money back...that's your father dude just give him the money and don't worry about getting it back...letting ppl borrow money ruins relationships....
you mean multiply the amount by 1.2199. Yes, so then multiply the next amount 1.2199 and the next one, and the next one? But I sorta did it with an option like, if he gives some money back, the interest would be lower, so like "amount = money given back and multiply by 1.2199" ?
you mean multiply the amount by 1.2199. Yes, so then multiply the next amount 1.2199 and the next one, and the next one? But I sorta did it with an option like, if he gives some money back, the interest would be lower, so like "amount = money given back and multiply by 1.2199" ?namby_trojan
Log in to comment