Ask Your Question

Formula for Bi-Weekly Payment on Monthly Loan

asked 2016-08-03 17:47:54 +0200 gravatar image

Hi All,

I'm trying to figure out the formula for a mortgage where the interest is monthly but you make two equal payments every other week.

Simple example: $1000 principal 1 year 1% interest

Using PMT it's super easy to solve the payments and from there I've made an amortization schedule. The payments on that loan would be $83.79/month for 12 payments.

Now I want to do an amortization table if you were to make payments of 1/2 of that amount ($41.885) every other week. Here is basically what I want it to look like at the end:

Thanks in advance

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-08-03 21:18:54 +0200

mark_t gravatar image

For the end of each payment period calculate the new balance from the previous balance minus the payment plus the interest for that period.

Attached example.

C:\fakepath\Untitled 4.ods

You might need to adjust this to round the payment of each period to the nearest cent.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-03 17:47:54 +0200

Seen: 312 times

Last updated: Aug 03 '16