YouTube Splash Mountain
Search:

student loan consolidation debt consolidation loan credit card debt student loan debt consolidator consolidate loans credit card loan




Celebrities Pictures

Motorola Bluetooth Wireless Car Charger Cigarette Lighter Adapter



Camera Connection Kit for Apple iPad
blackberry 8830 price

review buy

How to make a Fixed Rate Loan/Mortgage Calculator in Excel

You Tube Video Clips image
You Tube Video Clips image You Tube Video Clips image
You Tube Video Clips image

http://www.TeachMsOffice.com This video tutorial will show you how to make a fixed rate loan or mortgage calculator in excel. It is actually quite easy to do and after watching this step-by-step example and walk-through, you will be able to make your own also. This tutorial uses the PMT() function to calculate the required payments and it is also explained in the tutorial. To follow along with the spreadsheet seen in the tutorial or to get some free excel macros or tips & tricks, go to the website: http://www.TeachMsOffice.com

Channel: Education
Uploaded: November 30, 1999 at 12:00 am
Author: ExcelisHell

Length: 07:24
Rating: 4.878788
Views: 31669

Tags: excel  how  to  tutorial  loan  payments  pmt()  function  formula  mortgage  calculator  interest  rates  

Video Url:


Embed Code:

Video Comments

mortgageratecalculat (November 30, 1999 at 12:00 am)
This video was very interesting... well done. Check out my Mortgage rate calculator video if you get chance.
VFRodriguez (November 30, 1999 at 12:00 am)
Good for you. Well done.
vijaykhubchandani (November 30, 1999 at 12:00 am)
Test
ExcelisHell (November 30, 1999 at 12:00 am)
@samse15 It all depends on the type of calculation that you want to make.  And there are many different ways to make a mortgage calculator in Excel.
samse15 (November 30, 1999 at 12:00 am)
Why do you use the formula for monthly interest payment if it is a fixed rate loan? When I compare your answer to an online mortgage calculator, it comes out that they just use yearly interest/12 for the monthly interest, not the whole "compounded" formula you have in there. Thanks.
seoinmontreal (November 30, 1999 at 12:00 am)
bit . ly/tS7man --------- This video reveals how a kid in his 20′s started making over $100,000 per month on the internet. The shocking thing about this is that you actually get to see 12 checks in this video. So you know this guy know's what he's talking about.------------- bit . ly/tS7man ---------- copy in your browser and delete spaces before and after the point
grupotusolucion (November 30, 1999 at 12:00 am)
interesting
calcularhipoteca (November 30, 1999 at 12:00 am)
thanks for the video
xzy113 (November 30, 1999 at 12:00 am)
that s how I play bowling
110mhay (November 30, 1999 at 12:00 am)
where is the second part of this tutorials can you show it plzzzzzzzz.thank a lot i'll wait the part of this tutorials


Affordable Linux Hosting Image
Bookmark and Share

Student Consolidation 2007 All Rights Reserved.