What's hot



    John Wiley & Sons
    Book (John Wiley & Sons)
    List Price: $16.99
    Price: $9.12
    You Save: $7.87 (46%)




    Calculated Industries
    Home Improvement (Calculated Industries)
    List Price: $79.95
    Price: $49.95
    You Save: $30.00 (38%)

    • Complete Payment Solutions, Including PITI and Interest-Only to Demonstrate "What If" Solutions
    • Perfect for Investors and Commercial Lenders Provides Commercial Investment Solutions for Clients Without Complicated Formulas
    • Calculate Combo Loans (80:10:10 and 80:15:05), Bi-Weekly Loans, ARMs provide Client withFlexible Payment Options
    • Versatile Buyer Pre-Qualifying for Conventional and FHA/VA Loans to Show Homes Within an Affordable Price Range
    • Easy Rent vs. Buy Comparisons and Estimated Tax Savings Show Benefits of Homeownership



    Calculated Industries, Inc
    Home Improvement (Calculated Industries, Inc)
    List Price: $44.95
    Price: $33.49
    You Save: $11.46 (25%)

    • Complete taxes and insurance for PITI payments; automatic sales price and down payment calculations; more
    • 5-1/2 by 3 by 0-1/2 inches; display dimensions 0.86 by 2-1/2 inches; 3.2 ounces; 1-year warranty
    • Plastic back, aluminum front, soft rubbed buttons
    • Financial calculator designed for real estate and mortgage professionals
    • Includes 2 3-volt lithium batteries, pocket user guide, quick reference guide, protective slide cover



    Calculated Industries
    Home Improvement (Calculated Industries)
    List Price: $64.95
    Price: $47.89
    You Save: $17.06 (26%)

    • Versatile buyer pre-qualifying for conventional and FHA/VA loans to show homes within price range
    • Complete PITI payment solutions to demonstrate interest only and other "What If" scenarios
    • Easy rent vs. buy comparisons and estimated tax savings show benefits of ownership
    • Calculate combo loans (80:10:10 and 80:15:05), bi-weekly loans, ARMs provide flexible payment options
    • Amortization with remaining balances



    For Dummies
    eBooks (For Dummies)
    List Price: $16.99




    Casio Inc.
    CE (Casio Inc.)
    List Price: $59.99
    Price: $23.99
    You Save: $36.00 (60%)

    • Full dot, 4-line display
    • Cost/sell/margin, investment appraisal, amortization
    • Simple and compound interest calculations, depreciation
    • Slide-on hard case; solar power with battery back-up
    • Converts between percentage interest rate and effective interest rate



    Calculated Industries, Inc
    Home Improvement (Calculated Industries, Inc)
    List Price: $79.95
    Price: $59.95
    You Save: $20.00 (25%)

    • Offer clients complete payment solutions, including PITI and interest-only.
    • Calculate combo loans (80:10:10 and 80:15:05), bi-weekly loans, ARMs - provide flexible financing solutions.
    • Ideal for agents and brokers, or any residential real estate finance professional - Get up to speed quickly and easily.
    • Quickly pre-qualifying buyers using conventional and FHA/VA ratios.
    • Valuable training tools for students and seasoned professionals.



    Calculated Industries, Inc
    Home Improvement (Calculated Industries, Inc)
    List Price: $79.95
    Price: $54.95
    You Save: $25.00 (31%)

    • Cash flow, IRR, NVP and NFV; perfect for investors and commercial lenders provides commercial investment solutions for clients without complicated formulas
    • Complete payment solutions, including PITI and interest-only to demonstrate "what if" solutions
    • Calculate combo loans (80:10:10 and 80:15:05), bi-weekly loans, ARMs provide client with flexible payment options
    • Easy rent vs. buy comparisons and estimated tax savings show benefits of homeownership
    • Versatile buyer pre-qualifying for conventional and FHA/VA loans to show homes within an affordable price range



    VictoryStore
    CE (VictoryStore)
    List Price: $9.99
    Price: $6.99
    You Save: $3.00 (30%)

    • The Real Estate calculator easily calculates loan payments for your home, car or other loan.
    • Size : 2 5/8"w x 4"h (6.67cms x 10.16cms)
    • Brand new item, but batteries have been dieing out. A new battery may be required.
    • Color: Silver
    • Real Estate Calculator # C-138



    hp
    CE (hp)
    List Price: $151.28
    Price: $79.99
    You Save: $71.29 (47%)

    • More than 120 built-in functions
    • Keystroke programming
    • Good choice for home finances, business professionals and accountants

Please advise, how to set up a formula in Excel to calculate the monthly payment on a home loan?

Montly payment would equal the loan amount, the term which is a 30 year term, and the interest rate.

Thanks much!


Simple Mortgage Calculator
http://www.mortgagecalculator.org/


Related Help
http://www.mortgage-calc.com/

Free Home Mortgage Calculator for Excel
http://www.vertex42.com/Calculators/home -mortgage-calculator.html


Simple Mortgage Calculator
http://www.mortgagecalculator.org/


Related Help
http://www.mortgage-calc.com/

Free Home Mortgage Calculator for Excel
http://www.vertex42.com/Calculators/home -mortgage-calculator.html

Can you explain the USDA direct home loan payment assistance?

I understand that if I use the USDA Direct loan I may be eligible for payment assistance/government subsidy. I know that I will have to repay the subsidy under certain situations, but I don't understand how they determine if you are eligible for the assistance


Never heard of this & I do RD (USDA) loans all the time.

student Loan extra payment caLcuLator mortgage Loan extra payment caLcuL

Everyone covets to pass his life with comfort or luxury but once in while some financial requirements disturb you abruptly. Then you think how to ...

Refinance Home to Pay for College?

Dear Dr. Don,

I can refinance my current mortgage with a 15-year 3.5% product and take out $40,000 to completely pay off two of my daughters' student loans, which are at a 7% interest rate. The monthly mortgage payment on the cash-out refinancing will remain virtually the same as my existing mortgage.

There are still two more kids to finance through college. One is in her final year of college and the other is a high school junior. My plan is to use the $700 I would not be sending out each month in mortgage payments into our retirement accounts and toward future college savings for the high school student. My husband is 59 and I am 58.

calculate home loan payment - Bookshelf


The Personal Finance Calculator, How to Calculate the Most Important Financial Decisions in Your Life
224 pages
The Personal Finance Calculator, How to Calculate the Most Important Financial Decisions in Your Life

FINANCIAL CALCULATOR #21 Determine Your Mortgage Balance When Additional Principal Payments Are Made There are many trade-offs when choosing a mortgage/ loan ...

New Perspectives on Microsoft Office 2007
1168 pages
New Perspectives on Microsoft Office 2007

To set up the monthly loan payment calculation: 1. Insert a new worksheet named Loan Analysis at the end of the workbook. 2. In cell A1, enter Home Loan, ...

New perspectives on Microsoft Office Excel 2007, comprehensive
700 pages
New perspectives on Microsoft Office Excel 2007, comprehensive

To set up the monthly loan payment calculation: 1. Insert a new worksheet named Loan Analysis at the end of the workbook. 2. In cell A1, enter Home Loan, ...

Home Loan Got Ina Better Way Using Home Loan Calculator.

&Bull; Interest o be paid

The projected loan amount refers to how much money you need to buy a property. You can enter one or more repayment terms and interest rates so that you can receive different figures and then make your final decision.

|There are different interest rates you can choose from depending on the prevailing market conditions, credit profile and reasons for your loan. Loan calculators can be used to estimate home loans, auto loans etc. The interest rate will depend on the type of loan you require. Most online home loan calculators will allow you to enter many combinations to get different outputs. For example, if you want a home loan of $ 100,000, then you can calculate how much you will need to repay if you take the loan for 15 or 30 years. For each loan period, the interest rate will vary. So, if it is 6.5% for a 30 year period, then your monthly repayment amount will be approximately $632.|Loan calculators can help you to choose different interest rates based upon the market rates, your finance resources and so on. Loans for vehicle and home can be calculated by this and the interest rate is different in each case and the type of loan you need.Online calculators allow different entries to be made in it and for example You need a home loan of $ 100,000,for 30 years and if it is 6.5%/year then the repayment amount comes to $632 a month.|Home Loan calculators allow you to choose the interest rates from the existing market rates and it ask you some credit details and the reason for your loan All types of loans can be calculated with this and this provides you to enter different category of details so that you can estimate the correct amount to be repaid .For example if the loan s for $ 100,000, at the interest rate of 6.5% per year for 30 years then the amount you have to pay per month comes to $632,}

...

Read more...

calculate home loan payment - News


Refinance Home to Pay for College?
By Don Taylor, Ph.D., CFA & CFP I can refinance my current mortgage with a 15-year 3.5% product and take out $40000 to completely pay off two of my daughters' student loans, which are at a 7% interest rate. The monthly mortgage payment on the cash-out

Home loan protection defend your future
The amount of payment paid under insurance will be the same as the balance outstanding on the home loan at the time of claim. Calculate EMI with Home Loan EMI Calculator How is it structured? In many ways a housing loan protection plan is similar to

Swift calculations for homeowners-to-be
Here are just a few: Bankrate.com: Offers calculators to gauge mortgage payment amounts and how much you can afford. bankrate.com/calculators/mortgages/mortgage-calculator.aspx HGTV FrontDoor: Supplies a calculator that also considers property taxes,

Snag Mortgage or Pay Cash for Home?
I used Bankrate's mortgage payment calculator to calculate a monthly mortgage payment on a 15-year fixed-rate mortgage at 3.5% for a $120000 loan, assuming you would make at least a 20% down payment on the $150000 purchase price.

When to Refinance Your Mortgage?
When to Refinance Your Mortgage? Use a mortgage calculator to figure out how much you'll save each month on the new mortgage versus the old one, then figure how many months it will take for your savings to exceed what you'll pay in closing fees. That's your break-even point.

Call for a free credit repair consultation today (877) 278-5682

Related deals

  • calculating cost of equity Media

    Kevin Rasher of Modify Law Center

    Which modifications are possible depends upon the particular circumstances of the borrower, but for any homeowner facing foreclosure, a consultation with Kevin Rasher should be undertaken to examine the possibilities.



    Mississauga Real Estate Calculator

    Mississauga Real Estate Calculator


    www.minmaxx.com
    Minmaxx Real Estate
    6655 Kitimat Road, Unit 2 Mississauga, Ontario L5N 6J4
    1-416-264-1111 or 1-888-MIN-MAXX



    Loanleaders of America, Loan Leaders of America, Loanleaders of America Inc, Loan Leaders of America Inc

    It is our Business Philosophy and Strategy to provide high quality mortgage loans, at the most affordable rates, using a wide variety of Mortgage Lenders and a vast selection of Mortgage Loan Programs. Loan Leaders of America knows that great rates are not enough, so they maintain an...

    Penilaian Hartanah di Malaysia dan secara Individu(Pemilik HArtanah,rumah)

    House sitting on calculator isolated on white background



    Home Market Evaluation

    Where does your house add up?