spreadsheet
It's got an awesome appetite: Tyrannosaurus Debt
apr | excel | interest | loan | loans | spreadsheet | studentloan | studentloansHow do you figure out daily interest from an APR on student loans due monthly? I have about 100k USD in student loan debt, at a fixed APR of 5.75%. I wanted to work out what the monthly rate was, but my debt holder tells me that the interest is actually calculated daily, though the payments are due monthly. Then they sent me twenty pages of amortization tables, I suppose imagining that it would help me somehow. Aside from seeing that 75-80% of each month's payment goes to interest before any of it goes to principal, the tables don't help me. I accrue and pay off a small amount of credit card debt each month, mostly in grocery bills. This is deliberate, since it's a monthly expense I'd have anyway, and paying by credit instead of debit is (I think) at least a slight help to my credit score.
It's got an awesome appetite: Tyrannosaurus Debt
apr | excel | interest | loan | loans | spreadsheet | studentloan | studentloansHow do you figure out daily interest from an APR on student loans due monthly? I have about 100k USD in student loan debt, at a fixed APR of 5.75%. I wanted to work out what the monthly rate was, but my debt holder tells me that the interest is actually calculated daily, though the payments are due monthly. Then they sent me twenty pages of amortization tables, I suppose imagining that it would help me somehow. Aside from seeing that 75-80% of each month's payment goes to interest before any of it goes to principal, the tables don't help me. I accrue and pay off a small amount of credit card debt each month, mostly in grocery bills. This is deliberate, since it's a monthly expense I'd have anyway, and paying by credit instead of debit is (I think) at least a slight help to my credit score.

