Mortgage Credit Analysis Worksheet

Metavantes loan origination studio supports the eha loan transmittal the maximum mortgage worksheet for 203 k and 203 k streamline loans and the mortgage credit analysis worksheets according to cy brinn president of metavante lending solutions. This loan analysis worksheet template is specially designed for the purpose of analyzing loans with functions and formula built in within the worksheet.

Quality Control Plan 10 20 2008

The following is a description of the steps to be taken when completing any of the section 184 mortgage credit analysis worksheets mcaws.

Mortgage credit analysis worksheet. The mortgage credit analysis worksheet has been revised to reflect changes to the percentage of financeable closing costs. The first seven lines set the basis for the analysis and the remaining lines track the balance of the mortgage from the initial loan balance until the loan is paid off a process known as amortization. The most popular abbreviation for mortgage credit analysis worksheet is.

Line 5 closing costs. Use this accessible template to analyze various loan scenarios. Keep your career on the right track our income analysis tools are designed to help you evaluate qualifying income quickly and easily.

Exceed the lesser of line 10f1 or 10f2. Crv data va use 46. Enter the interest rate loan term and amount and see the monthly payment total payments and total interest calculated for you.

Other interest rates and loan terms are provided for comparison to help you make the choice thats right for your situation. Our income analysis tools and worksheets are designed to help you evaluate qualifying income quickly and easily. For additional information about completing a mortgage credit analysis see hud 41551 4c.

On line 5b subtract any amount of buyers closing costs paid by the seller. Determine the type of transaction you are working with. Mortgage payment to income line 13hline 111.

Remarks use reverse or attach a separate sheet if necessary 48c. Borrower rating enter a for acceptable or r for reject. This loan analysis worksheet template in excel features a comprehensive table of the loan rates over the years for various terms of mortgages and installment loans.

Payments 4 through 359 are not shown. On line 5a show the total buyers closing costs of the transaction. Mortgage without ufmip note.

Several of the more important changes are discussed below. Select the appropriate tab at the bottom of the excel worksheet to display the mcaw designed for your specific transaction. Past credit record 48a.

Does loan meet va credit standards give reasons for decision under remarks if necessary eg borderline case satisfactory unsatisfactory. Below is a worksheet you can use to start to do some economic analysis to compare mortgages. Credit analysis a mortgage credit analysis is used to determine a borrowers credit and hisher capacity to repay the mortgage whether or not there are sufficient funds to close and to limit foreclosures or collection difficulties.

Mortgage Pricing Adjustments The Truth About Mortgage