Fee Worksheet Template

Fee Worksheet Template

The Fee Worksheet form is a document that helps estimate the costs associated with a loan settlement. It includes various items such as title charges, application fees, and recording fees, allowing borrowers and lenders to understand potential expenses. To dive into this essential tool, consider filling out the form by clicking the button below.

Content Overview

The Fee Worksheet form plays a pivotal role in the financing and closing process of a property transaction. It outlines the various fees and costs associated with a loan, presenting a comprehensive estimate that helps borrowers understand what to expect at settlement. Key components of the form include an itemized list of charges, such as loan origination fees, title charges, and appraisal costs, along with their corresponding estimates. Borrowers are also provided with crucial details like the loan number, interest rate, and specifics about the property. The worksheet lists both items payable in connection with the loan and additional settlement charges, ensuring that potential costs are clearly enumerated. Additionally, it addresses estimated reserves and prepaid costs, including necessary payments like homeowner’s insurance and property taxes. By consolidating all these financial elements, the Fee Worksheet serves as an essential tool for borrowers to navigate their financial obligations, ensuring transparency and facilitating informed decision-making during the mortgage process.

Fee Worksheet Sample

Itemized Fee Worksheet

(For Use with Service Providers and Investors)

Date:

The information provided below reflects estimates of the charges that are likely to be incurred at the settlement of this loan. The fees listed are estimates; some actual charges may be more or less. This transaction may not involve a fee for every item listed.

 

Provided By:

 

 

Subject Property:

 

 

 

Borrower(s):

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Loan Number:

 

 

Interest Rate:

 

Type of Loan:

 

Base Loan Amt:

 

 

 

 

Loan Program:

 

 

Term:

 

 

 

 

Sales Price:

 

Total Loan Amt:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Estimated Closing Costs

 

 

 

 

 

800.

Items Payable in Connection with Loan

 

 

 

1100.

Title Charges

 

 

 

 

 

 

 

Loan Origination Fees

%

 

$

 

 

1102.

Settlement or Closing Fee

$

 

 

 

 

 

 

 

 

 

Application Fees

 

 

 

$

 

 

1103.

Owner’s Title Insurance

$

 

 

 

 

 

 

 

 

 

 

 

Processing Fees

 

 

 

$

 

 

1104.

Lender’s Title Insurance

$

 

 

 

 

Underwriting Fees

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

1109.

 

 

 

 

$

 

 

 

 

Broker Fees

 

% + $

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1110.

 

 

 

 

$

 

 

 

 

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1111.

 

 

 

 

$

 

 

 

 

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1112.

 

 

 

 

$

 

 

 

 

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1113.

 

 

 

 

$

 

 

 

 

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

$

 

 

1114.

 

 

 

 

$

 

 

 

 

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Title Charges

 

 

$

 

 

802.

Credit or Charge for Interest Rate

 

 

$

 

 

 

 

 

 

 

 

 

 

 

1200.

Government Recording and Transfer Charges

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

803. Adjusted Origination Charges

$

 

 

 

 

 

 

 

 

1202.

Recording Fees

 

 

$

 

 

804.

Appraisal Fee to

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

1203.

Transfer Taxes

 

 

$

 

 

 

 

 

 

 

 

 

805.

Credit Report to

 

 

 

$

 

 

1204.

City/County Tax/Stamps

$

 

 

806.

Tax Service to

 

 

 

$

 

 

 

 

 

 

 

 

 

1205.

State Tax/Stamps

 

 

$

 

 

807.

Flood Certification

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

1206.

 

 

 

 

$

 

 

808.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1207.

 

 

 

 

$

 

 

809.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1208.

 

 

 

 

$

 

 

810.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

811.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Recording/Transfer Charges

$

 

 

 

 

 

 

 

 

812.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1300.

Additional Settlement Charges

 

 

 

813.

 

 

 

 

$

 

 

 

 

 

814.

 

 

 

 

$

 

 

1302.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

815.

 

 

 

 

$

 

 

1303.

 

 

 

 

$

 

 

816.

 

 

 

 

$

 

 

1304.

 

 

 

 

$

 

 

817.

 

 

 

 

$

 

 

1305.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

1306.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

1307.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

1308.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

1309.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Estimated Closing Costs

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Estimated Reserve/Prepaid Costs

 

 

 

 

 

 

900. Items Required by Lender to be Paid in Advance

 

 

 

 

Reserves Deposited with Lender

 

 

 

901.

Daily Interest

Days @ $

$

 

 

1001.

Initial Deposit into Escrow Account

$

 

 

902.

Mortgage Ins Premium to

 

 

$

 

 

1002.

Homeowner’s Ins

mths @ $

$

 

 

 

 

 

 

 

 

903.

Homeowner’s Insurance to

 

 

$

 

 

1003.

Mortgage Ins

mths @ $

$

 

 

904.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

1004.

Property Taxes

mths @ $

$

 

 

905.

VA Funding Fee

 

 

 

$

 

 

 

 

 

 

 

 

 

1005.

City Property Tax

mths @ $

$

 

 

906.

Flood Insurance

 

 

 

$

 

 

 

 

 

 

 

 

 

1006.

Flood Reserve

mths @ $

$

 

 

907.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

1007.

 

 

mths @ $

$

 

 

908.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

1008.

 

 

mths @ $

$

 

 

909.

 

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

1009.

 

 

mths @ $

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1010.

Aggregate Adjustment

 

 

– $

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Estimated Reserve/Prepaid Costs

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Transaction Summary

 

 

 

 

 

 

Total Estimated Monthly Payment

 

 

 

 

 

 

Total Estimated Funds Needed to Close

 

 

 

 

Principal and Interest

 

 

 

$

 

 

 

Purchase Price/Payoff

 

 

(+) $

 

 

 

Other Financing (P & I)

 

 

 

$

 

 

 

Total Estimated Closing Costs

 

 

(+) $

 

 

 

Hazard Insurance

 

 

 

$

 

 

 

Total Estimated Reserve/Prepaid Costs

(+) $

 

 

 

Real Estate Taxes

 

 

 

$

 

 

 

Discounts (if borrower will pay)

 

 

(+) $

 

 

 

Mortgage Insurance

 

 

 

$

 

 

 

FHA UFMIP/VA Funding Fee

 

 

(+) $

 

 

 

HOA Dues

 

 

 

$

 

 

 

Total Costs

 

(c)

$

 

 

 

Other

 

 

 

$

 

 

 

 

 

 

 

 

 

 

 

 

Total Monthly Payment

 

 

 

$

 

 

 

Loan Amount

 

 

(–) $

 

 

 

 

 

 

 

 

 

 

 

 

Non-Borrower Paid Closing Costs

 

 

(–) $

 

 

 

 

 

 

 

 

 

 

 

 

FHA UFMIP/VA Fee Financed

 

 

(–) $

 

 

 

Closing Costs Summary

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(–) $

 

 

 

Borrower Paid Closing Costs

 

(a)

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(–) $

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(–) $

 

 

 

 

 

 

 

 

$

 

 

 

 

 

 

 

 

(–) $

 

 

 

 

 

 

 

 

$

 

 

 

First Mortgage

 

 

(–) $

 

 

 

 

 

 

 

 

$

 

 

 

Second Mortgage (Sub Financing)

 

 

(–) $

 

 

 

Total Non-Borrower Paid CC

 

(b)

$

 

 

 

Closing Costs from

 

 

(–) $

 

 

$

 

 

 

Total Credits

 

(d)

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Closing Costs

 

(a + b)

$

 

 

 

 

 

 

 

(c – d)

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

S – Paid by Seller

 

B – Paid by Broker

 

 

 

 

A – APR Affected by Cost

 

 

 

 

 

 

S/ – Split by Seller & Others

 

L – Paid by Lender

 

 

 

 

O – Paid by Other

 

P – Paid Outside Closing (POC)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Itemized Fee Worksheet ~ 02/2010 ~ Encompass360TM

Document Attributes

Fact Name Detail
Date of Completion The Fee Worksheet includes a date field, ensuring accurate and up-to-date information is reflected on the form.
Purpose of the Form This worksheet serves to provide a detailed estimate of the charges anticipated at the settlement of a loan.
Estimates of Charges The form contains estimates of various fees, which may vary when actual charges are incurred.
Borrower Information Sections dedicated to borrower(s) and loan details facilitate clear identification of parties involved.
Itemized Fee Breakdown Fees are categorized by type, including title charges, government recording, and additional settlement charges.
Governing State Laws Specific states may have regulations that govern the use of this worksheet, impacting disclosure requirements.
Estimated Closing Costs The worksheet summarizes all estimated closing costs, providing an overview of financial expectations before closing.
Disclosure of Reserves Reserves and prepaid costs are detailed, showing what funds must be available upfront for loan-related expenses.
Transaction Summary A summary section at the end presents the total estimated monthly payment and necessary funds needed to close.
Flexibility in Charges Some fee categories may not apply to every transaction, allowing the worksheet to be customized based on the loan specifics.

Fee Worksheet: Usage Instruction

It is important to accurately fill out the Fee Worksheet to ensure all expenses related to the loan process are documented correctly. This includes various fees and estimated costs incurred during the transaction. Follow the steps outlined below to provide the necessary information efficiently.

  1. Start by entering the Date: Fill in the date you are completing the form.
  2. Fill in Provided By: Enter the name of the individual or organization preparing the worksheet.
  3. Complete the Subject Property: Write the address of the property involved in the transaction.
  4. Input Borrower(s): List the names of all borrowers associated with the loan.
  5. Fill in Loan Number: Enter the assigned loan number for reference.
  6. Provide the Interest Rate: Write the applicable interest rate for the loan.
  7. Specify Type of Loan: Indicate whether it is a fixed, adjustable, or any other loan type.
  8. Enter the Base Loan Amount: Write the principal amount of the loan before interest.
  9. Detail the Loan Program: Specify the loan program being used for this transaction.
  10. Fill in the Term: Indicate the duration of the loan in years.
  11. Complete the Sales Price: Enter the agreed-upon price for the property.
  12. State the Total Loan Amount: Provide the total calculated loan amount.
  13. Next, list the Estimated Closing Costs: Include the detailed costs under sections labeled with specific line item numbers.
  14. For items payable in connection with the loan, fill in the corresponding fees for items such as title charges, loan origination fees, and processing fees, carefully following the numbering system provided.
  15. Move on to the Government Recording and Transfer Charges: Input recording fees and transfer taxes under the designated line items.
  16. Continue with Additional Settlement Charges: Provide any additional fees that may apply to the transaction.
  17. Then, list the Estimated Reserve/Prepaid Costs: Fill in costs that may need to be paid upfront or reserved with the lender.
  18. After completing all relevant sections, ensure you double-check for accuracy and completeness.

This methodical approach will help you finalize the Fee Worksheet. Once filled out correctly, you can proceed to submit the form as per your next steps in the loan process.

Frequently Asked Questions

  1. What is the purpose of the Fee Worksheet form?

    The Fee Worksheet form serves as a detailed estimate of the various charges associated with the settlement of a loan. It outlines potential costs related to loan origination, title services, assessments, and additional settlement charges. This structured format helps borrowers understand their financial responsibilities before finalizing a loan.

  2. Who should use the Fee Worksheet?

    This form is intended for use by service providers and investors involved in real estate transactions. It is particularly useful for lenders, real estate agents, and borrowers seeking clarity on expected costs during the closing process.

  3. How are the fees on the Fee Worksheet determined?

    Fees listed on the Fee Worksheet are estimates based on standard practices and previous transactions. They may fluctuate based on specific circumstances surrounding a loan, the property involved, and the agreements made between the borrower and service providers.

  4. Are the fees outlined in the Fee Worksheet final amounts?

    No, the fees provided on the Worksheet are estimates and are subject to change. Actual charges may be higher or lower depending on a variety of factors, including service provider fees and other economic conditions at the time of closing.

  5. What types of fees are included in the Fee Worksheet?

    The Fee Worksheet includes several categories of fees, such as:

    • Loan Origination Fees
    • Title Charges
    • Government Recording and Transfer Charges
    • Estimated Closing Costs
    • Reserve/Prepaid Costs
  6. What happens if additional fees arise during the closing process?

    If additional fees emerge that are not listed in the initial Fee Worksheet, it is crucial for borrowers to be informed in advance. Lenders are typically obligated to communicate any changes to the original estimate and should provide justification for these new costs.

  7. Can the Fee Worksheet form be modified?

    Yes, the Fee Worksheet can be tailored to fit the needs of a specific transaction. While certain standard entries and formats remain consistent, adjustments can be made based on the attributes of the loan or specific negotiations between parties.

  8. Why is it important to review closing costs?

    Reviewing closing costs is essential for borrowers, as it ensures transparency and enables them to be prepared for the financial commitment of the loan. Understanding these costs helps borrowers make informed decisions and potentially negotiate better terms.

  9. Is it possible for borrowers to negotiate fees listed in the Fee Worksheet?

    Borrowers may have the opportunity to negotiate certain fees with lenders and service providers. This can include exploring discounts or alternative service options, which might lead to reduced fees overall.

  10. How can I get a copy of the Fee Worksheet?

    Borrowers can typically obtain a copy of the Fee Worksheet from their lenders or service providers upon request. It’s important to ask for this document early in the process to allow for adequate time to review and discuss any questions or concerns.

Common mistakes

Filling out the Fee Worksheet form correctly is crucial for a smooth processing of any loan application. However, many individuals make common mistakes that can lead to confusion or delays. Recognizing these errors can help ensure a smoother experience.

One significant mistake is failing to provide accurate dates. The date on the Fee Worksheet is essential as it helps synchronize various documents involved in the transaction. If the date is outdated or incorrect, it can create discrepancies that may delay the loan process, as lenders rely on timely information.

Another frequent error is overlooking the section for itemized fees. Often, people focus only on major costs like loan origination fees while neglecting smaller charges, such as appraisal or recording fees. Every fee contributes to the total closing costs. Incomplete entries here can lead to unexpected costs at closing, which can be frustrating for borrowers.

Additionally, some individuals mistakenly use percentages without converting them to actual dollar amounts where specified. For example, if you have a fee listed as a percentage, it needs to be calculated into an actual fee amount. This oversight can easily lead to errors in the total closing costs tabulation.

It’s also common to see people leaving blank fields. Each section was designed to capture specific information. Each blank field provides an incomplete picture, which could raise questions during the review process. Where there is no applicable fee, it is wise to indicate that with a zero or “N/A” to avoid any confusion.

Another mistake often involves underestimating the initial deposit into the escrow account. An adequate understanding of how much needs to be deposited can prevent unexpected issues later on. Underreporting this amount can lead to funding delays or complications in closing.

Lastly, many individuals fail to review the transaction summary carefully. This summary includes all the crucial figures, including total estimated closing costs and funds needed to close. Any mistake or oversight here can lead to significant misunderstandings about the total expenses involved in securing the loan.

Making sure these common mistakes are avoided when filling out the Fee Worksheet form can not only help streamline the loan process but also enhance your overall experience with your lender. Being meticulous and thorough is key.

Documents used along the form

When preparing for a loan transaction, several documents can complement the Fee Worksheet form. Each document serves a specific purpose to ensure clarity and compliance throughout the process. Below is a list of related forms frequently used in conjunction with the Fee Worksheet.

  • Loan Estimate: This document provides an overview of the loan terms, including the estimated monthly payment, interest rate, and closing costs. It is designed to help borrowers understand their potential costs and make informed decisions.
  • Closing Disclosure: This form outlines the final loan terms and the closing costs. It must be provided at least three days before closing, allowing borrowers to review all financial details transparently.
  • Request for Transcript of Tax Return (4506-T): Borrowers use this form to request a transcript of their tax returns from the IRS. Lenders typically need this information to verify income, essential for loan approval.
  • Promissory Note: This is a legally binding document that outlines the borrower’s promise to repay the loan under specified terms. It includes details such as the loan amount, interest rate, and payment due dates.
  • Deed of Trust: This document secures the loan by transferring property interest to a trustee until the loan is paid off. It typically outlines the rights and duties of the borrower and the lender.
  • Homeowners Insurance Policy: Proof of insurance is often required by lenders to protect against potential damages to the property. The policy details coverage and terms of the insurance agreement.
  • Title Insurance Policy: This document protects lenders from financial losses arising from defects in the title, including liens or disputes. It ensures clear ownership of the property.
  • Affidavit of Title: This sworn statement by the seller guarantees that they hold the title to the property and can legally transfer ownership. It also confirms that there are no outstanding liens or disputes concerning the property.
  • HUD-1 Settlement Statement: This form provides a detailed breakdown of all charges and credits related to the real estate transaction. While not as common as it once was, it may still be required in specific circumstances.

Utilizing these documents alongside the Fee Worksheet can help facilitate a smoother loan process. Each item plays a vital role in ensuring that all parties involved have a comprehensive understanding of the financial aspects of the transaction.

Similar forms

The Fee Worksheet form is essential for detailing estimated charges at the settlement of a loan. It provides a structured breakdown of costs, ensuring transparency for all parties involved. Several documents share similarities with the Fee Worksheet form in terms of purpose and structure. Below are five such documents:

  • Loan Estimate (LE): Like the Fee Worksheet, the Loan Estimate outlines the estimated costs associated with a mortgage. It details loan terms, projected payments, and itemized closing costs, helping borrowers understand their financial commitments prior to closing.
  • Closing Disclosure (CD): The Closing Disclosure serves a similar function to the Fee Worksheet by providing a detailed summary of the final loan terms and costs. It allows borrowers to compare their estimated costs against actual figures before signing on the dotted line.
  • HUD-1 Settlement Statement: This document functions similarly by itemizing all financial transactions involved in a real estate closing. It breaks down costs in a clear format, allowing parties to see how funds are distributed during the settlement process.
  • Good Faith Estimate (GFE): The Good Faith Estimate was used prior to the implementation of the Loan Estimate. It provided an estimation of closing costs and loan terms, aligning closely with the Fee Worksheet's purpose of delivering upfront cost transparency.
  • Pre-Approval Letter: While primarily focused on qualifying borrowers, a Pre-Approval Letter often contains information about estimated loan amounts and potential costs. This document sets the stage for the more detailed breakdowns provided in the Fee Worksheet and other closing documents.

Each of these documents serves to clarify the financial obligations involved in securing a loan, mirroring the Fee Worksheet's intent to foster understanding and informed decision-making.

Dos and Don'ts

When filling out the Fee Worksheet form, keep the following tips in mind:

  • Do ensure all dates are filled in accurately.
  • Don’t leave any sections blank unless they are not applicable.
  • Do provide clear and concise estimates for each fee.
  • Don’t duplicate fees or charges in multiple sections.
  • Do review the totals to confirm they match your calculations.
  • Don’t submit the form without double-checking for errors.
  • Do keep a copy of the completed form for your records.
  • Don’t use abbreviations that may confuse others reading the form.
  • Do provide contact information in case follow-up is needed.
  • Don’t ignore additional comments or notes that could clarify entries.

Misconceptions

  • Misconception 1: The Fee Worksheet form is a final bill of costs.

    The Fee Worksheet provides estimates, not a final tally. Actual charges may differ at settlement.

  • Misconception 2: All listed fees will apply to every transaction.

    Not every transaction will incur all the fees listed. Some items may not be applicable to specific loans.

  • Misconception 3: The rates and charges listed are fixed.

    The fees are subject to change based on various factors, including the lender or specific circumstances of the loan.

  • Misconception 4: This form only applies to home purchases.

    The Fee Worksheet can be used for various loan types, not just purchases. It assists with refinancing and other loan transactions too.

  • Misconception 5: Completion of the form guarantees loan approval.

    Filling out the Fee Worksheet does not guarantee that a loan will be approved. It is just an estimation tool.

Key takeaways

  • The Fee Worksheet is a document that estimates charges related to the settlement of a loan.

  • It's important to remember that the fees listed are estimates; actual charges may vary.

  • Some transactions may not involve fees for every item listed on the worksheet.

  • Include essential details like the loan number, borrower(s), and property address at the top of the form.

  • Review the section on title charges, as these can include various fees like owner’s title insurance and closing fees.

  • Be aware of government recording and transfer charges, which can consist of recording fees and transfer taxes.

  • You'll also find sections for estimated reserves and prepaid costs, which indicate funds required by the lender in advance.

  • Once completed, use the information to estimate the total amount of funds needed to close the loan.

More PDF Forms