Using Excel’s built-in amortization table

Excel function tutorials, Housing

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

Thanks to our nascent house hunt, I’ve been trying to back into figures on mortgages and monthly payments. Luckily, Excel has a handy just perfectly suited for this purpose.

Here’s how you get to the template in Excel 2007 (which according to my recent poll is the version most readers use, if only by a hair).

In Excel 2007, go to the “menu” button (the goofy-looking windows symbol in a circle) in the upper left-hand corner. Click on “New”. This will bring up the following window:

Click on “Installed templates”, which will bring up seven built-in templates for you to choose from. Double-click on “Loan Amortization”.

This will create a blank template for you to fill out, like so (click image below to enlarge):


You can fill in data in the orange boxes, and Excel will automatically calculate monthly payments, remaining amount on the principal, remaining balance, and interest paid to date, along with several other fields in the columns below. If you choose to make extra payments, the template automatically takes those into consideration as well. In the upper right-hand area is a summary of the loan scenario, including monthly payment amount and total interest to be paid.

Here’s an example of what all of this looks like for a hypothetical loan (click image below to enlarge):


In Excel 2003, you can get to the same template through the following steps. Go to “File” >> “New” >> “New Workbook” >> “On my computer…” >> “Templates” >> “Spreadsheet Solutions” >> “Loan Amortization”.

This template has helped me create a simple model to play around with figures to get a total picture of fund outlays, tax savings, and different mortgage scenarios in our nascent house-hunting process.


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


99 Feedbacks on "Using Excel’s built-in amortization table"

Boca Raton CPA jobs in texas

This will make your details simple and easy so that
employer can go through it at first instance. Here are 4 things bookkeeping and accounting services do
for their customers:. Understand that when you enter a major tax franchise or chain your taxes are
most likely being prepared by a trained.

long distance moving companies florida

Be sure to get more than one quote so you can take time
to compare them and go through each one thoroughly.

Individuals can check the availability of various companies on the
web. If you are not in the mood of spending much on moving,
the moving service provides the facility of a trailer.

Boca Raton Cpa Firms

Professional responsibility principles should
be incorporated into every area of office operations and procedures.
In a photography business in particular, here
are a number of items that are assets to be listed for your business.
It is being embraced by students all over the world
with a great vigor; a course called Sage line 50 certification was pursued
by a record no.

storage units memphis tn 38116

If you’d prefer to relocate completely hassle-free, Professional moving corporations area
unit the simplest resort. Plus, companies have slowly learned that when they add
up the costs associated with manufacturing overseas,
they might as well pay American workers those union wages.
The movers can easily clean the things from your house in very less time.

Jon's article tool

Your style is very unique compared to other folks I have
read stuff from. Thanks for posting when yyou
have the opportunity, Guess I will just bookmark this web

chloe sims tanning wii u mario kart release date

This will help to avoid streaking and will ensure results.
In the 1960s when many people were becoming the victims of sunburn and skin cancer for
the sake of Suntan, this method became very popular
as a safe alternative to sunbathing. The internet is also where you
will find the lowest prices and best deals on tanning products of all varieties, allowing you to easily browse enormous collections and
find reviews before you buy, and to fill your cart with
a selection of the best self tanners available at unbeatable prices.

hcg Weight loss kelowna

Many people will say it’s genetics, but that is not the case.
Using good times ahead for your weight loss situation can give you awesome
results each time you want to do something effective in making sure you can fit
in those pants or that dress for the special occasion. You will again get
a well toned body with perfect curves and shapes.

boca Raton financial advisors

These significant changes give an opening to a market of specialists when it comes to tax preparation,
auditing and bookkeeping. He or she should be a person who would be in a position to utilize resources for the benefit of the organization. The online offering
will cost you $99 to setup up with monthly fees.

delray beach social media marketing ideas

It’s official – social media marketing has arrived for good.
And the best thing ‘ you will be able to make a decent income in a
passive way. Furthermore, the post should be accompanied by relevant images to make posts compelling and to motivate the audience to continue
reading. A blog is your hub – a key component of
your online marketing. My name is Leon and I write a blog on social media marketing.
Build and maintain friendly relationships by posting frequent and helpful posts.
Veterinarians that test other mediums report numbers
that are quite different. Get engaged with your target audience
by answering questions to gain credibility and develop trust.
In recent days, social networking is really successful and the
marketing through these sites are very essential to a trade because millions of people are accessing these sites regularly.
The First Amendment also does not protect from use of obscenity, fighting
words, defamation, incitement to lawless action, true threats and
solicitation to commit crimes.

hcg weight loss kansas city Mo

Regular exercise is one of the best ways to enhance your energy, trim you_re down your weight and make you feel better.

However, there are risks along with negative penalty to
just cutting out many the calories that are apt to be eaten. Sometimes you’ll see no changes at all,
which might indicate that you need a more fundamental reevaluation of your diet and exercise, on a larger scale
than simply adding HCG to the mix and hoping everything else will work out on its own.

laser hair growth treatment prices

The older you get, the more likely it is that you’ll start
to experience thinning and hair loss. If the drugs damage cell activity during the
anagen phase, then hair loss is noticeable within a couple of weeks.
Hair loss is of concern to most people at one point in their

bodycon dresses flowers wholesale miami

If or when your favorite game in your youth was creating clothes for your toys as well as creating creative changes
in your very own apparel, then I think people
such as you are absolutely those which are destined to become a fashion designer.
Readers may refer to a related article entitled The Best Fashion Merchandising Degree
Schools in the U. It’s nice that at least parts of society and
media are recognizing that not all women are
shaped the same and we don’t all need to be a size 6
or smaller.

keratin treatments for natural hair

Keep the mixture cooled and pat it on your lips as often as
necessary. Never wash your hair with very hot or very cold water.

It becomes difficult to treat these scars and therefore acne must
be treated with the help of oral drugs and topical creams and lotions.

Triphala garcinia program

This paragraph is in fact a fastidious one it assists new the web users, who are wishing for blogging.

garcinia wow dr oz

Hey! This is my first comment here so I just wanted to
give a quick shout out and tell you I really enjoy reading your blog posts.

Can you suggest any other blogs/websites/forums that
go over the same topics? Thank you!

g3 lipo battery

You ought to be a part of a contest for one of the finest sites on the net.
I am going to recommend this site!

I have read several excellent stuff here. Definitely price bookmarking
for revisiting. I surprise how much effort you place to make any such
wonderful informative web site.


My family members always say that I am killing my time here at net, but I know I am
getting know-how daily by reading such fastidious content.

amazing garcinia

I was recommended this web site by my cousin. I’m not sure whether this post is written by him as no one else know such detailed
about my trouble. You’re incredible! Thanks!

buy Garcinia Ultra

buy Garcinia Ultra…

Using Excel’s built-in amortization table | Experiments in Finance…

web cam sale

I leave a response whenever I appreciate a article on a website or I
have something to contribute to the discussion. It is triggered by the sincerness displayed
in the post I browsed. And after this article
Using Excels built-in amortization table | Experiments in Finance.
I was actually moved enough to drop a comment ;) I actually do have
a couple of questions for you if you tend not to mind. Is it simply me or do some of
the responses come across like written by brain dead folks?
:-P And, if you are posting at other social sites, I’d
like to keep up with everything fresh you have to
post. Would you make a list every one of all your social sites like your linkedin profile, Facebook page or twitter


Great post. I’m dealing with some of these issues
as well..


Hey there! Quick question that’s entirely off topic. Do you know how to
make your site mobile friendly? My blog looks
weird when browsing from my apple iphone. I’m trying to find a template or plugin that might be able to resolve
this problem. If you have any recommendations, please share.

quotes app

It’s very effortless to find out any matter on net as compared to textbooks, as I found this paragraph at this web

Excel Table Templates | Furniture | Home Ideas

[…] Using Excels built in amortization table Experiments in Finance source […]

read more

read more

Using Excel’s built-in amortization table | Experiments in Finance

Need Loan Amortization Schedule Excel For Millions | Home

[…] Using Excel’s built-in amortization table | Experiments in … – You can fill in data in the orange boxes, and Excel will automatically calculate monthly payments, remaining amount on the principal, remaining balance, and interest …… […]

Kansas Loan Amortization Schedule In Excel 2007 |

[…] Using Excel’s built-in amortization table | Experiments in … – Your articles are helping me enhance my skills in Excel 2007. Thank you and keep it up!… […]



blog topic

girls spa birthday party ideas

girls spa birthday party ideas

Using Excel’s built-in amortization table | Experiments in Finance

vocational counselor

vocational counselor

Using Excel’s built-in amortization table | Experiments in Finance

led lamp

led lamp

Using Excel’s built-in amortization table | Experiments in Finance

australian gap year

australian gap year

Using Excel’s built-in amortization table | Experiments in Finance

Kansas City Car Loan Amortization Table For Excel |

[…] Using Excel’s built-in amortization table | Experiments in … – You can fill in data in the orange boxes, and Excel will automatically calculate monthly payments, remaining amount on the principal, remaining balance, and interest …… […]

charles abbott provo

Very nice write-up. I definitely love this site.


online american high school

online american high school

Using Excel’s built-in amortization table | Experiments in Finance

buy infrared sauna

buy infrared sauna

Using Excel’s built-in amortization table | Experiments in Finance

teaching in singapore international schools

teaching in singapore international schools

Using Excel’s built-in amortization table | Experiments in Finance

Pokemon X y Gratuit

Great blog you have here.. It’s difficult to
find high quality writing like yours nowadays.
I really appreciate individuals like you! Take care!!


Pretty great post. I just stumbled upon your weblog and
wanted to say that I’ve truly enjoyed surfing around your blog
posts. In any case I will be subscribing in your rss feed and I am hoping you write once more
very soon!

fun things to do in london

Your style is really unique in comparison to other people I have read stuff from.
Many thanks for posting when you’ve got the opportunity, Guess I will just book mark this blog.

Braces Colors selector

Braces Colors selector

Using Excel’s built-in amortization table | Experiments in Finance

resize image online

Hello to all, the contents present at this web site are really amazing for people knowledge, well, keep up the nice work fellows.

youtube subscribers

It’s going to be finish of mine day, but before end I am reading this fantastic post
to improve my experience.

viewdetails http://www

Why people still make use of to read news papers when in this technological globe all is presented on web?


I have a blog made with Blogger and it has Blogger logos at the top.. I’ve seen Blogger blogs without them, and it makes them a lot cooler..

mother of the groom songs

mother of the groom songs

Using Excel’s built-in amortization table | Experiments in Finance

homeopathic Diet

Hundreds of thousands of patients have safely and successfully used
this diet to lose weight. People who took HCG drops claim that the weight loss food supplement resulted
to changes in their eating behavior, thus hastening
the process of losing weight. This sort of delivery is
considerably much more preferable to day-to-day injections
due to the fact it is a whole lot quicker and significantly safer.
Although it is utterly proven to help people
shed unwanted weight, it’s safety is also being debated amongst both medical practitioners and users alike.

I noticed one store was carrying an HCG “supplement.

Amortization Of Finance Costs –

[…] Using Excel’s built-in amortization table | … – Because you shouldn’t need an MBA to be savvy about business and finance […]


Please Leave a Comment!

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