Loading
Form preview
  • US Legal Forms
  • Other Templates
  • More Forms
  • More Uncategorized Forms
  • Mortgage Shopping Worksheet Excel

Get Mortgage Shopping Worksheet Excel

Mortgage Shopping Worksheet Lender 1 Lender 2 Name of Lender Name of Contact Date of Contact Mortgage Amount BASIC INFORMATION ABOUT THE LOAN What type of loan is it? Fixed Rate Variable (Adjustable).

How it works

  1. Open form

    Open form follow the instructions

  2. Easily sign form

    Easily sign the form with your finger

  3. Share form

    Send filled & signed form or save

How to fill out the Mortgage Shopping Worksheet Excel online

The Mortgage Shopping Worksheet Excel is a valuable tool for users seeking to compare different mortgage options. This guide provides clear instructions on how to fill out the worksheet effectively, ensuring you gather all necessary information to make informed decisions.

Follow the steps to complete the Mortgage Shopping Worksheet effectively.

  1. Click the ‘Get Form’ button to access the Mortgage Shopping Worksheet and open it in your online editor.
  2. Begin by entering the details for Lender 1 and Lender 2 in the designated sections. Include the name of each lender and the contact information of a representative.
  3. Fill out the Basic Information About the Loan section. Specify the type of loan by selecting from options such as Fixed Rate, Variable Rate, or Conventional, among others. Additionally, input the mortgage amount, minimum down payment, loan term, contract interest rate, and annual percentage rate (APR).
  4. Indicate if points apply and provide the estimated monthly payment. If your monthly payment includes escrow for taxes and insurance, specify the amount allocated for escrow as well.
  5. In the Fees section, document various lender fees such as origination or underwriting fees, broker fees, application or loan processing fees, and any other relevant fees. Make sure to list all applicable fees for each lender.
  6. Continue to Other Closing or Settlement Costs. Note costs such as title search, title insurance, state and local taxes, and any surveys or inspections required. Total these costs.
  7. Address Other Questions & Considerations about the loan. Record any prepayment penalties, the length of such penalties, and other details pertaining to the loan terms like balloon payments or rate lock options.
  8. Once all fields are completed, review your entries for accuracy and completeness.
  9. Finally, save changes to your document. You can also choose to download, print, or share the completed worksheet for your records or consultations.

Start using the Mortgage Shopping Worksheet online to compare mortgage options and make informed decisions.

Get form

Experience a faster way to fill out and sign forms on the web. Access the most extensive library of templates available.
Get form

Related content

Mortgage Shopping Worksheet - Consumer.ftc.gov
mortgage 1 mortgage 2. Basic Information on the Loans. Type of Mortgage: fixed-rate...
Learn more
Mortgage Shopping Worksheet - FDIC
Mortgage Shopping Worksheet. Mortgage 1. Mortgage 2. Name of lender or broker & contact...
Learn more
MATH 2223 Finite Mathematics - Arkansas Tech...
Aug 10, 2012 — you an interest-free loan of $1,500 for a fee of $60 to be repaid by...
Learn more

Related links form

Boiler & Machinery Quick Application WOMANS CHANGE OF ADDRESS AND OR NAME CHANGE (MICHIGAN FORM) SPECIAL BMI DISCOUNT RATE $499 - BMI.com Monsignor Donovan High School Course Selections 2011-2012

Questions & Answers

Get answers to your most pressing questions about US Legal Forms API.

Contact support

The rate argument is the interest rate per period for the loan. For example, in this formula the 17% annual interest rate is divided by 12, the number of months in a year. The NPER argument of 2*12 is the total number of payment periods for the loan. The PV or present value argument is 5400.

If you want to do the monthly mortgage payment calculation by hand, you'll need the monthly interest rate just divide the annual interest rate by 12 (the number of months in a year). For example, if the annual interest rate is 4%, the monthly interest rate would be 0.33% (0.04/12 = 0.0033).

To figure out how much you must pay on the mortgage each month, use the following formula: "= -PMT(Interest Rate/Payments per Year,Total Number of Payments,Loan Amount,0)". For the provided screenshot, the formula is "-PMT(B6/B8,B9,B5,0)".

Use the PPMT function to calculate the principal part of the payment. ... Use the IPMT function to calculate the interest part of the payment. ... Update the balance. Select the range A7:E7 (first payment) and drag it down one row. ... Select the range A8:E8 (second payment) and drag it down to row 30.

0:00 4:49 Suggested clip How to build an Amortization table in EXCEL (Fast and ... - YouTubeYouTubeStart of suggested clipEnd of suggested clip How to build an Amortization table in EXCEL (Fast and ... - YouTube

Mortgages Pro. Compatible with most Apple devices that run iOS 3.0 or later, Mortgages Pro is a no-frills payment-tracking app that provides new homeowners with a clear, dynamic picture of their home loans. ... Mortgage Payoff Track. ... Mortgage Mentor. ... Loan Calculator Pro. ... Bill Payment Log.

Launch Microsoft Excel. ... Type "Principal" into cell A1 on the Excel worksheet. ... Enter the amount of the mortgage principal in cell B1. Enter the interest rate in cell B2. ... Enter the number of months in the loan term in cell B3. ... Enter the following formula in cell A4, beginning with the "equals" sign: \\=B2/1200.

Launch Microsoft Excel. ... Type "Principal" into cell A1 on the Excel worksheet. ... Enter the amount of the mortgage principal in cell B1. Enter the interest rate in cell B2. ... Enter the number of months in the loan term in cell B3. ... Enter the following formula in cell A4, beginning with the "equals" sign: \\=B2/1200.

Principle = the amount you want to borrow. The Interest Rate = the per annum interest rate divided by 12. So if the interest rate is 6.5%pa then calculate it as: The term = how long you'll have the loan in months. So if it's a 30 year loan calculate it as:

If you want to do the monthly mortgage payment calculation by hand, you'll need the monthly interest rate just divide the annual interest rate by 12 (the number of months in a year). For example, if the annual interest rate is 4%, the monthly interest rate would be 0.33% (0.04/12 = 0.0033).

Get This Form Now!

Use professional pre-built templates to fill in and sign documents online faster. Get access to thousands of forms.
Get form
If you believe that this page should be taken down, please follow our DMCA take down processhere.
Get Mortgage Shopping Worksheet Excel
Get form
  • Adoption
  • Bankruptcy
  • Contractors
  • Divorce
  • Home Sales
  • Employment
  • Identity Theft
  • Incorporation
  • Landlord Tenant
  • Living Trust
  • Name Change
  • Personal Planning
  • Small Business
  • Wills & Estates
  • Packages A-Z
  • Affidavits
  • Bankruptcy
  • Bill of Sale
  • Corporate - LLC
  • Divorce
  • Employment
  • Identity Theft
  • Internet Technology
  • Landlord Tenant
  • Living Wills
  • Name Change
  • Power of Attorney
  • Real Estate
  • Small Estates
  • Wills
  • All Forms
  • Forms A-Z
  • Other Templates
  • Legal Hub
  • About Us
  • Help Portal
  • Legal Resources
  • Blog
  • Affiliates
  • Contact Us
  • Delete My Account
  • Site Map
  • Industries
  • Forms in Spanish
  • Localized Forms
  • State-specific Forms
  • Forms Kit
  • Real Estate Handbook
  • All Guides
  • Notarize
  • Incorporation services
  • For Consumers
  • For Small Business
  • For Attorneys
  • USLegal
  • FormsPass
  • pdfFiller
  • signNow
  • altaFlow
  • DocHub
  • Instapage
Form Packages
  • Adoption
  • Bankruptcy
  • Contractors
  • Divorce
  • Home Sales
  • Employment
  • Identity Theft
  • Incorporation
  • Landlord Tenant
  • Living Trust
  • Name Change
  • Personal Planning
  • Small Business
  • Wills & Estates
  • Packages A-Z
Form Categories
  • Affidavits
  • Bankruptcy
  • Bill of Sale
  • Corporate - LLC
  • Divorce
  • Employment
  • Identity Theft
  • Internet Technology
  • Landlord Tenant
  • Living Wills
  • Name Change
  • Power of Attorney
  • Real Estate
  • Small Estates
  • Wills
  • All Forms
  • Forms A-Z
  • Other Templates
Customer Service
  • Legal Hub
  • About Us
  • Help Portal
  • Legal Resources
  • Blog
  • Affiliates
  • Contact Us
  • Delete My Account
  • Site Map
  • Industries
  • Forms in Spanish
  • Localized Forms
  • State-specific Forms
  • Forms Kit
Legal Guides
  • Real Estate Handbook
  • All Guides
Prepared for you
  • Notarize
  • Incorporation services
Our Customers
  • For Consumers
  • For Small Business
  • For Attorneys
Our Sites
  • USLegal
  • FormsPass
  • pdfFiller
  • signNow
  • altaFlow
  • DocHub
  • Instapage
Social Media
Call us now toll free:
+1 833 426 79 33
As seen in:
© Copyright 1999-2026 airSlate Legal Forms, Inc. 17 Station Street, Ste. 203, Brookline, MA 02445
  • Your Privacy Choices
  • Terms of Service
  • Privacy Notice
  • Content Takedown Policy
  • Bug Bounty Program