Calculating A Monthly Loan Repayment With Excel Using The PMT Function

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to for professional help and Excel Tutorials

o explain very briefly, a few months ago I made a purchase with my parents. They paid the condo in cash and I was left with my part that I would pay them 5 years later without interest (good deal hey?). So I’ve been saving money every month and investing it in a few stocks. I use a very simple spreadsheet to calculate how much I’ll need to save every month. If my money was invested in a fixed rate account, that number would remain the same. But since my investments values increase and decrease every month, the number actually changes.

I will use the PMT function to calculate what I need. In order to get started I will need:

Rate = my expected return (I will use a monthly return since I’m looking for a monthly amount)
Nper = how many months between now and me paying that amount back
PV = how much I currently have in that account
FV = how much I’ll need to pay at the end

Rate: I will assume a 7% annual return. To get the monthly return, I’ll simply do:


Nper = 47 months
PV = $13,000
FV = -$50,000

You can see both the table, formula and answer here:

Simple enough? It gets better. Since I linked my PV amount to a page where I get live stock quotes, that numbers can become “live”. You can download the spreadsheet here.


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


47 Feedbacks on "Calculating A Monthly Loan Repayment With Excel Using The PMT Function"


I’m really impressed with your writing skills as well as with the layout on your weblog.
Is this a paid theme or did you customize it yourself?
Anyway keep up the excellent quality writing, it’s rare to see
a great blog like this one today.

_______ ______ ___

Very soon this web site will be famous amid all
blog users, due to it’s pleasant articles or reviews

______ ___ __

Excellent post. I’m going through many of these issues as well..

___ adidas _____

I just couldn’t depart your website prior to suggesting that
I extremely enjoyed the usual information an individual supply
to your visitors? Is gonna be back frequently to check out
new posts

___ ______

I seldom create responses, but i did some searching and wound up here Calculating A Monthly
Loan Repayment With Excel Using The PMT Function
| Experiments in Finance. And I do have a couple of questions for you if you tend
not to mind. Is it simply me or does it appear like a few of
these comments appear as if they are coming from
brain dead visitors? :-P And, if you are writing at additional
online sites, I would like to keep up with everything
new you have to post. Could you list of the complete urls
of your shared sites like your Facebook page, twitter feed, or linkedin profile?

_____ __

Hi, just wanted to tell you, I enjoyed this blog post.
It was funny. Keep on posting!

___ ____

I drop a leave a response each time I appreciate a post on
a site or I have something to contribute to the conversation.
Usually it’s triggered by the fire displayed in the article I looked at.
And after this post Calculating A Monthly Loan Repayment With Excel Using The PMT
Function | Experiments in Finance. I was actually moved enough to write a
comment ;-) I do have some questions for you if it’s allright.
Could it be just me or do some of these remarks come across as
if they are written by brain dead people? :-P And,
if you are posting on additional online social sites, I’d
like to keep up with anything new you have to post.
Would you make a list every one of all your public sites like your Facebook page, twitter
feed, or linkedin profile?

____ ___

Heya i’m for the first time here. I found this board and I to find It truly useful & it helped me out a lot.

I hope to give one thing again and aid others like you helped

__ ____ ______ __

I read this article fully regarding the difference of most recent and previous
technologies, it’s remarkable article.

___ ___ __

Wonderful goods from you, man. I have understand your stuff previous to and you are just extremely
great. I really like what you have acquired here,
certainly like what you’re stating and the way in which
you say it. You make it entertaining and
you still take care of to keep it smart. I cant wait to read much more from you.
This is really a great website.

____ _________

I really like it whenever people come together and share thoughts.
Great site, keep it up!

___ __

Hi there! I simply would like to give you a big thumbs up for your excellent information you’ve got right here on this post.
I will be coming back to your blog for more soon.


great points altogether, you just received a brand new reader.

What may you recommend about your submit that you simply made some days in the past?

Any certain?

_____ _____

You made some really good points there. I looked on the net to find out
more about the issue and found most individuals will go along with your views on
this website.

______ _______ __

Your means of explaining everything in this article is in fact nice, every
one can effortlessly be aware of it, Thanks a lot.


I’m amazed, I must say. Seldom do I come across a blog
that’s both equally educative and amusing, and without a doubt, you have hit the nail on the
head. The problem is an issue that not enough folks are speaking intelligently about.
Now i’m very happy that I stumbled across this in my search
for something concerning this.

__ _______

I will immediately grasp your rss as I can not to
find your e-mail subscription link or e-newsletter service.

Do you have any? Please permit me know so that I may just subscribe.

2014 ____ ____

Ahaa, its nice dialogue on the topic of this piece of writing at this place at this webpage, I have read all
that, so at this time me also commenting at this place.


I for all time emailed this blog post page to all my associates, as
if like to read it afterward my contacts will too.


I’m not sure where you are getting your info, but good topic.
I needs to spend some time learning much more or understanding more.
Thanks for magnificent information I was looking for this info for my mission.

____ __________ ___

Heya i am for the first time here. I came across
this board and I find It really useful & it helped me out a
lot. I hope to give something back and aid
others like you helped me.


Hey just wanted to give you a quick heads up. The words in your post seem to be running off the
screen in Chrome. I’m not sure if this is a format issue or something to do with
web browser compatibility but I figured I’d post to let you
know. The design look great though! Hope you get the issue fixed soon.

___ _________ 2014

Howdy, i read your blog from time to time and i own a similar one and i was just wondering if you get
a lot of spam remarks? If so how do you stop it,
any plugin or anything you can advise? I get so much lately it’s driving me mad
so any help is very much appreciated.


I am sure this piece of writing has touched all the internet visitors, its really really fastidious piece of writing on building
up new webpage.


Hi there just wanted to give you a quick
heads up. The text in your article seem to
be running off the screen in Internet explorer.
I’m not sure if this is a formatting issue or something to do
with web browser compatibility but I thought I’d post
to let you know. The design look great though!

Hope you get the problem solved soon. Cheers

___ ___ __

Hey there would you mind letting me know which webhost you’re using?
I’ve loaded your blog in 3 completely different web browsers and I
must say this blog loads a lot quicker then most.
Can you recommend a good hosting provider at a honest price?
Thanks, I appreciate it!

__________ __

I absolutely love your website.. Very nice colors & theme.

Did you develop this site yourself? Please reply back as I’m wanting to create my own
website and want to find out where you got this from or exactly what the theme is
called. Thanks!


I wanted to thank you for this good read!! I definitely loved every bit of it.

I have you saved as a favorite to look at new things you post_


Greetings from Los angeles! I’m bored to death at work so I
decided to check out your blog on my iphone during lunch break.

I love the info you provide here and can’t wait to take a
look when I get home. I’m shocked at how fast your blog loaded on my phone ..
I’m not even using WIFI, just 3G .. Anyhow, great site!


Wonderful work! This is the type of information that should be shared around the internet.
Disgrace on Google for now not positioning this submit upper!
Come on over and visit my web site . Thank you


I do accept as true with all the ideas you’ve offered for your post.
They’re very convincing and will certainly work. Still, the posts are too quick for beginners.
May just you please prolong them a little from next time?
Thank you for the post.

___ _______ _____

Hi! I know this is kinda off topic nevertheless I’d figured I’d ask.
Would you be interested in exchanging links or maybe guest writing a blog article or vice-versa?
My blog addresses a lot of the same subjects as yours and I believe we could
greatly benefit from each other. If you happen to be interested feel free to shoot me an e-mail.

I look forward to hearing from you! Great blog by the way!


Your means of describing the whole thing in this paragraph
is actually pleasant, every one be capable of effortlessly understand it, Thanks a lot.


My coder is trying to convince me to move to .net
from PHP. I have always disliked the idea because of the costs.
But he’s tryiong none the less. I’ve been using WordPress on several websites for about a year and am
concerned about switching to another platform. I
have heard great things about Is there a way I
can transfer all my wordpress posts into it?
Any kind of help would be greatly appreciated!


It’s very trouble-free to find out any matter on web as compared to books, as I found this paragraph at
this site.

Hi! I simply want to offer you a big thumbs up for your excellent information
you have got right here on this post. I’ll be returning to
your blog for more soon.

telecharger teamviewer

Have you ever thought about including a little bit more than
just your articles? I mean, what you say is fundamental and all.
Nevertheless think about if you added some great graphics or video clips to give your posts more,
“pop”! Your content is excellent but with images and video clips,
this site could undeniably be one of the best in its niche.
Amazing blog!

aol email signin

Im gone to say to my little brother, that he should also go to see this webpage on regular basis to obtain updated from hottest news.

windows 8 product key

Paragraph writing is also a excitement, if
you know afterward you can write or else it is difficult to write.

rust free

Parents want to train for rust download 12 hours a day.
Absolutely yes, things can now use the video game standards.
Yes, that’s it. Does the Orange Box’s five games deliver their game of chess namely, the child.

microsoft office 2010 serial number

I was suggested this blog by my cousin. I am not sure whether this
post is written by him as nobody else know such
detailed about my problem. You are wonderful! Thanks!

mortgage rates wells fargo va

Hey there! Quick question that’s completely off topic.
Do you know hhow to make your site moble friendly?
My website looks weird when browsing from
my iphone. I’m trying to find a theme or plugin that
might be able to resolve this issue. If you have any recommendations, please share.
With thanks!


In the end, you will have assigned 136 confidence points (16+15+14+.
Most online football managers give you a team when you sign up and you’re
stuck with them forever, no matter how well you do.
Fan evaluations of the seat ranges will give you a great idea if
the tickets you are bearing in mind are worth what you will splurge.


Fantastic blog! Do you have any tips and hints for aspiring writers?
I’m planning to start my own blog soon but I’m a little lost on everything.

Would you suggest starting with a free platform like WordPress or
go for a paid option? There are so many choices out there that I’m completely overwhelmed ..
Any suggestions? Bless you!

pawn shops open on sunday in okc

I am now not positive the place you are getting your info, however great topic.
I needs to spend a while finding out much more or figuring out more.
Thanks for fantastic information I was looking for this info
for my mission.

Gabriel Patterson

Gabriel Patterson

Calculating A Monthly Loan Repayment With Excel Using The PMT Function | Experiments in Finance

Dr. Erik T. Goluboff

Dr. Erik T. Goluboff

Calculating A Monthly Loan Repayment With Excel Using The PMT Function | Experiments in Finance


Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.