As a free calculator in Microsoft Excel to build!
One of the really cool parts of Microsoft Excel is the Microsoft utility for use on your machine. This means that instead of a function to develop from scratch that you can use these pre-construction tasks to do, like building a fortune just your mortgage. Mortgage Calculator or PMT function is just one of many financial opportunities.
Okay, so how to design a calculator to build …
The first thing we do is start settingSome grassroots groups. So let's start with the beginning of a new workbook and clicking in the first cell A1. Enter the cell address A1 the heading – the monthly loan repayment. Next off, enter into cell address A2 – Loans, cell address A3 – interest rate, cell address A4 – Length of the loan and then in A6 – Monthly allowances.
In this example we calculated the loan amount, interest rate and length of the loan and calculate your monthly payment. And the equivalentB1 field, the value of $ 200,000 to feed and make sure that the layout of the area as a coin. In cell B2 enter a value of 9.25% and the size of a percentage and then type a value for the loan, 25 The value of loans added in the length of the field this year.
Now is the time to calculate, we arrive at the monthly repayment. The function that we use to calculate PMT function is called. The PMT function always gives anegative number and one of the things we need to do is to convert a positive number, but a bit 'of the next.
There are three arguments we will use this formula and it is -
= PMT (interest monthly, the number of installments, the amount borrowed)
So to calculate the monthly interest rate simply value in B3, and dividing by 12 – B3/12. The PMT function works on the basis of the number of payments that will make it if we want to domonthly payments from us, we have only the number of years in cell B4 and multiply it by 12 to 12 * B4
This means that the monthly rate of reimbursement for our purpose, we have the formula to enter –
= PMT (B3/12, B4 * 12, B2)
Now, when I said PMT function always gives a negative value, then the conversion of a positive value is entered in the PMT with Absolute take title as below –
=ABS (PMT (B3/12, B4 * 12, B2))
Enter the above formula in cell B6 and press Enter. You must now format the cell address B6 as a currency and you can do this simply by clicking on a dollar sign on the Formatting toolbar. Once the formula and press enter, you must be a result of the given $ 1,712.76. If you are not the answer, just go back and make sure you have the right formula.
The interesting part of this Mortgage Calculator is that itcan go back and one of the values in B2, B3 and B4, which is the loan amount, interest rate and maturity of the loan for the work that your monthly repayments will be correlated.
The interesting part of this simple tool to quickly see if this is the large amount of loans the bank is worth it and if we really afford the mortgage. Why not see what your repayments will be if the rate increased by 2 or 3%, can be really interesting to seeimpact on your budget.
Simple tools like this can save thousands of dollars, and may also help to see what changes in interest rates will have on your budget. It is worthwhile to build yourself a budget worksheet and a calculator to figure out what you can really afford, especially in these uncertain times.
Related posts:
- Excel Tutorial – How to Construct a Compounding Interest Financial Calculator periods
- Five ways to use free Home Loan Calculator
- Payment Amortization Calculator – The Facts
- Getting a loan for the calculation and figure your monthly payments
- Many uses of computers
- With a simple interest calculator – find the real cost of money
- Home Loan Calculator – a valuable tool Online Home Loan
- Auto loan repayment Calculator – How is it calculated and why they cost more
- Amortization Schedule Calculator
- Prime Mortgage Calculators
