XLS《Macros》

,,

,,

, Borrower , SecondaryBorrower2 , AtClosing , AutomatedUnderwritingCaseIdentifier , Text20 ,,

,,

,,

FreddieMacLoan# , Borrower , SecondaryBorrower3 , AtClosing , AutomatedUnderwritingRecommendation , AutomatedUnderwritingRecommendation , A1Accept , A2Accept , Accept , Approve , ApproveEligible , C1Caution , C2Caution , Caution , CautionEligibleForAMinus ,,

,,

,,

SellerLoan# , Borrower , SecondaryBorrower4 , AtClosing , AutomatedUnderwritingSystem , AutomatedUnderwritingSystem , Assetwise , Capstone , Clues , DesktopUnderwriter , ECS , LoanProductAdvisor , LoanProspector , Strategyware , Zippy , FirstMortgageCreditScore ,,

,,

,,

ServicerLoan# , Borrower , SecondaryBorrower5 , AtClosing , BalloonIndicator , BalloonIndicator , False , True ,,

,,

,,

, PartyInformation , PartyInformation , AtClosing , BaseLTVRatio , Percent ,,

,,

,,

, AtClosing , AtClosing , AtClosing , BorrowerCount , Number2 ,,

,,

,,

, AtModification , AtModification , AtClosing , BuydownContributorType , BuydownContributorType , Borrower , Lender , InterestedThirdParty ,,

,,

,,

, AtConversion , AtConversion , AtClosing , BuydownTemporarySubsidyIndicator , BuydownTemporarySubsidyIndicator , False , True ,,

,,

,,

, CurrentFirstLien , CurrentFirstLien , AtClosing , CapitalizedLoanIndicator , CapitalizedLoanIndicator , False , True ,,

,,

,,

, CurrentSecondLien , CurrentSecondLien , AtClosing , CeilingRatePercent , Percent ,,

,,

,,

, CurrentThirdLien , CurrentThirdLien , AtClosing , ClosingCostContributionAmount1 , Amount ,,

,,

,,

, CurrentFourthLien , CurrentFourthLien , AtClosing , ClosingCostContributionAmount2 , Amount ,,

,,

,,

, MortgageFunder , MortgageFunder , AtClosing , ClosingCostContributionAmount3 , Amount AtClosing , ClosingCostContributionAmount4 , Amount AtClosing , ClosingCostFundsType1 , ClosingCostFundsType , AggregatedRemainingTypes , BridgeLoan , CashOnHand , CheckingSavings , Contribution , CreditCard , EquityOnSoldProperty , EquityOnSubjectProperty , ForgivableSecuredLoan , GiftFunds , Grant , LifeInsuranceCashValue , LotEquity , PremiumFunds , RentWithOptionToPurchase , RetirementFunds , SaleOfChattel , SecondaryFinancingClosedEnd , SecondaryFinancingHELOC , SecuredLoan , StocksAndBonds , SweatEquity , TradeEquity , TrustFunds , UnsecuredBorrowedFunds AtClosing , ClosingCostFundsType2 , ClosingCostFundsType AtClosing , ClosingCostFundsType3 , ClosingCostFundsType AtClosing , ClosingCostFundsType4 , ClosingCostFundsType AtClosing , ClosingCostSourceType1 , ClosingCostSourceType , Borrower , CommunityNonProfit , Employer , FederalAgency , Lender , LocalAgency , PropertySeller , Relative , ReligiousNonProfit , StateAgency , AggregatedRemainingSourceTypes , FHLBAffordableHousingProgram , USDARuralHousing , AtClosing , ClosingCostSourceType2 , ClosingCostSourceType AtClosing , ClosingCostSourceType3 , ClosingCostSourceType AtClosing , ClosingCostSourceType4 , ClosingCostSourceType AtClosing , ConstructionLoanIndicator , ConstructionLoanIndicator , False , True AtClosing , ConstructionLoanType , ConstructionLoanType , ConstructionToPermanent AtClosing , ConstructionToPermanentClosingFeatureType , ConstructionToPermanentClosingFeatureType , AutomaticConversion , ModificationAgreement , NewNote AtClosing , ConstructionToPermanentClosingType , ConstructionToPermanentClosingType , OneClosing , TwoClosing AtClosing , ConstructionToPermanentFirstPaymentDueDate , Date AtClosing , ConversionType , ConversionType , ToFixedRate , ToMonthlyPaymentFrequency AtClosing , ConvertibleIndicator , ConvertibleIndicator , False , True AtClosing , CreditScoreImpairmentType , CreditScoreImpairmentType , InsufficientCreditHistory , SignificantErrorsScore AtClosing , DownPaymentAmount1 , Amount AtClosing , DownPaymentAmount2 , Amount AtClosing , DownPaymentAmount3 , Amount AtClosing , DownPaymentAmount4 , Amount AtClosing , DownPaymentSourceType1 , DownPaymentSourceType , Borrower , CommunityNonProfit , Employer , FederalAgency , LocalAgency , OriginatingLender , Relative , ReligiousNonProfit , StateAgency , AggregatedRemainingSourceTypes , FHLBAffordableHousingProgram , USDARuralHousing ,,