u/LadyAryQuiteContrary

Hi all,

I’m trying to set up a loan schedule in excel and none of my attempts are quite right.

This is an 11 year $13,375 loan at 15.49% interest rate/APR with an introductory 1 year (technically 11 months) with no interest. The first 11 months have a payment of $200.63 then it goes up to $215.26. Total finance charges if paid over the 11 years is $14,662.58 making to total of all payments $28,037.58.

How can I set this up in excel?

I’m just really excited and wanted to share!

I posted on here a couple times about a job offer that got rescinded. Basically it boiled down to them being upset I didn’t accept right away and was still interviewing elsewhere. But I had the interview scheduled already prior to their offer and this company was my top choice while the one that made the offer was more of my second or fall back choice. Well, I got the job offer from the other company! I signed the offer over the weekend and have a start date set up!