XLSX www.rd.usda.gov

Guarantee Fee Calculator (For Financing Entire Upfront Guarantee Fee)Guarantee FeeFee ReciprocalGRH Fee Reg FactorSelectSelectSelectAppraised Value of Property being Financed: =IF(B4>B5,1,IF(B4=0,-1,0))SELECTEnter Base Loan Amount (Must be less than or equal to the Appraised Value): 0.005=SUM(1-D5)0.0055556Select Guarantee Fee Percentage Rate: 0.01=VLOOKUP(B6,D4:E19,2)0.01=SUM(1-D6)0.0111111Guarantee Fee: =IF(B6="Select"," ",IF(C4=1,B5*B6,IF(C4=0,B4*B6," ")))0.0125=SUM(1-D7)0.0138889GRH Loan Without Guarantee Fee Financed: =IF(B6="Select"," ",IF(C4=0,B4,IF(C4=1,B5," ")))0.015=SUM(1-D8)0.0166666GRH Loan with Entire Guarantee Fee Financed in Loan: =IF(B6="Select"," ",IF(C4=0,B4/C6,IF(C4=1,B5/C6," ")))0.0175=SUM(1-D9)0.019444507755619Guarantee Fee with Entire Fee Financed In Loan: =IF(B6="Select"," ",IF(B5 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download