Fee Worksheet Template PDF Details

Understanding the dynamics of real estate transactions involves grappling with various documents, one of the most detailed being the Fee Worksheet. This comprehensive form plays a pivotal role for service providers and investors by offering an outline of estimated charges likely to emerge at the settlement of a loan. It underscores the financial intricacies that borrowers navigate, detailing everything from loan origination fees, title charges, to government recording and transfer charges, among others. The Fee Worksheet also estimates closing costs, reserves prepaid by the lender, and provides a transaction summary that includes estimated monthly payments and total funds needed to close. Notably, while the form enumerates potential expenses, it clarifies that actual charges may vary, and not every item listed might incur a fee. Furthermore, it functions as a transparent tool for borrowers to understand the breakdown of costs, facilitating better financial planning and decision-making in the context of purchasing property. This document's nuanced approach in itemizing potential fees—while highlighting that some charges might fluctuate—underscores the complexity of real estate transactions and the importance of thorough financial preparation.

QuestionAnswer
Form NameFee Worksheet Template
Form Length1 pages
Fillable?No
Fillable fields0
Avg. time to fill out15 sec
Other namesfee sheet template, itemized fee worksheet fillable, fee worksheet, itemized fee worksheet

How to Fill Out Itemized Fee Worksheet

Itemized Fee Worksheet at a glance

What it is: The Itemized Fee Worksheet is for use with Service Providers and Investors.

A filled-in Itemized Fee Worksheet example: a lender estimates fees for a home purchase

Itemized Fee Worksheet example filled out, example: a lender estimates fees for a home purchase
A lender prepares an Itemized Fee Worksheet for Jane Ann Sample. The home sells for 250,000.00 and the base loan amount is 200,000.00. The picture shows the filled worksheet, and none of its entries is real. No fee is financed, so Total Loan Amt equals Base Loan Amt. Loan Origination Fees are 1.00% of the base loan amount. Nothing goes in Broker Fees because no broker is paid, and nothing goes in Credit or Charge for Interest Rate because the rate carries no credit or charge.

How to fill out Itemized Fee Worksheet, box by box

Provided By, Subject Property and Borrower(s)

Itemized Fee Worksheet example filled out, provided By, Subject Property and Borrower(s)

Enter Provided By, Subject Property and Borrower(s).

Loan Number, Interest Rate, Type of Loan and Loan Amt

Itemized Fee Worksheet example filled out, loan Number, Interest Rate, Type of Loan and Loan Amt

Enter Loan Number, Interest Rate, Type of Loan, Base Loan Amt, Loan Program, Term, Sales Price and Total Loan Amt.

Items Payable in Connection with Loan and Title Charges

Itemized Fee Worksheet example filled out, items Payable in Connection with Loan and Title Charges

Under 800, Items Payable in Connection with Loan, enter Loan Origination Fees (% and $), Application Fees, Processing Fees, Underwriting Fees, Broker Fees (% + $) and 802 Credit or Charge for Interest Rate.

Enter 803 Adjusted Origination Charges.

Under 1100, Title Charges, enter 1102 Settlement or Closing Fee, 1103 Owner's Title Insurance, 1104 Lender's Title Insurance, 1109, 1110, 1111, 1112, 1113 and 1114.

Enter Total Title Charges.

Government Recording and Transfer Charges and Appraisal Fee

Itemized Fee Worksheet example filled out, government Recording and Transfer Charges and Appraisal Fee

Under 1200, Government Recording and Transfer Charges, enter 1202 Recording Fees, 1203 Transfer Taxes, 1204 City/County Tax/Stamps, 1205 State Tax/Stamps, 1206, 1207 and 1208.

Enter 804 Appraisal Fee to, 805 Credit Report to, 806 Tax Service to, 807 Flood Certification, 808, 809, 810, 811, 812, 813, 814, 815, 816 and 817.

Enter Total Recording/Transfer Charges.

If your situation is different

Estimated charges

The information provided 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.

Additional Settlement Charges

Under 1300, Additional Settlement Charges, enter 1302, 1303, 1304, 1305, 1306, 1307, 1308 and 1309.

Enter Total Estimated Closing Costs.

Estimated Reserve/Prepaid Costs

Under Estimated Reserve/Prepaid Costs, 900, Items Required by Lender to be Paid in Advance, enter 901 Daily Interest (Days @ $), 902 Mortgage Ins Premium to, 903 Homeowner's Insurance to, 904, 905 VA Funding Fee, 906 Flood Insurance, 907, 908 and 909.

Under Reserves Deposited with Lender, enter 1001 Initial Deposit into Escrow Account, 1002 Homeowner's Ins (mths @ $), 1003 Mortgage Ins (mths @ $), 1004 Property Taxes (mths @ $), 1005 City Property Tax (mths @ $), 1006 Flood Reserve (mths @ $), 1007, 1008 and 1009 (mths @ $) and 1010 Aggregate Adjustment -.

Enter Total Estimated Reserve/Prepaid Costs.

Transaction Summary

Under Transaction Summary, Total Estimated Monthly Payment, enter Principal and Interest, Other Financing (P & I), Hazard Insurance, Real Estate Taxes, Mortgage Insurance, HOA Dues, Other and Total Monthly Payment.

Under Total Estimated Funds Needed to Close, enter Purchase Price/Payoff (+), Total Estimated Closing Costs (+), Total Estimated Reserve/Prepaid Costs (+), Discounts (if borrower will pay) (+), FHA UFMIP/VA Funding Fee (+) and Total Costs (c), then Loan Amount (-), Non-Borrower Paid Closing Costs (-), FHA UFMIP/VA Fee Financed (-), First Mortgage (-), Second Mortgage (Sub Financing) (-), Closing Costs from (-) and Total Credits (d).

Closing Costs Summary

Under Closing Costs Summary, enter Borrower Paid Closing Costs (a) and Total Non-Borrower Paid CC (b).

Enter Total Closing Costs (a + b).

Paid by Seller, Broker, Lender or Other

S - Paid by Seller; S/ - Split by Seller & Others; B - Paid by Broker; L - Paid by Lender; A - APR Affected by Cost; O - Paid by Other; P - Paid Outside Closing (POC).

Sources

[1] Itemized Fee Worksheet (For Use with Service Providers and Investors), 02/2010 (the Official source link on this page).

Please rate Fee Worksheet Template

1 Votes
If you believe this page is infringing on your copyright, please familiarize yourself with and follow our DMCA notice and takedown process - click here to proceed .