Question: Please include the Excel function/formula used for this question. 5. Append Foreclosure Step (extract from the foreclosure comment). The field should be blank or n/a

Please include the Excel function/formula used for this question.

Please include the Excel function/formula used for this question. 5. Append Foreclosure

5. Append Foreclosure Step (extract from the foreclosure comment). The field should be blank or "n/a" for loans not in foreclosure. i.e.: "This Loan is in Step: Service" --> Service Foreclosure Step o u Loan Loan Number Seller Name Loan AmountAnnual Rate Term (Years) Payment Payments MadeCurrent Balance Loan Type Agency Delinquency (Months) Status 1 83449837 Shanna's Loan Headquarters 280,000 6.34% 30 $0.00 191 $0.00 VA 2 41209504 Shanna's Loan Headquarters 370,000 4.79% 30 $0.00 322 $0.00 UCONV 3 25055860 Shanna's Loan Headquarters 210,000 6.14% $0.00 32 $0.00 USDA 4 61173887 Shanna's Loan Headquarters 120,000 6.99% $0.00 $0.00 VA 5 51398733 Shanna's Loan Headquarters 350,000 5.01% $0.00 154 $0.00 UCONV 76906141 Shanna's Loan Headquarters 220,000 4.28% $0.00 $0.00 ICONV 49304139 Shanna's Loan Headquarters 330,000 7.99% $0.00 $0.00 USDA 8 23473039 Shanna's Loan Headquarters 160,000 3.78% $0.00 317 $0.00 USDA 9 53651842 Shanna's Loan Headquarters 370,000 5.65% $0.00 73 $0.00 ICONV 10 77159777 Shanna's Loan Headquarters 240,000 5.67% $0.00 174 $0.00 VA Foreclosure Foreclosure Comment 0 This Loan is in Step: n/a o This Loan is in Step: n/a 0 This Loan is in Step: n/a o This Loan is in Step: n/a o This Loan is in Step: n/a This Loan is in Step: n/a O This Loan is in Step: n/a O This Loan is in Step: n/a o This Loan is in Step: n/a O This Loan is in Step: n/a 30 5. Append Foreclosure Step (extract from the foreclosure comment). The field should be blank or "n/a" for loans not in foreclosure. i.e.: "This Loan is in Step: Service" --> Service Foreclosure Step o u Loan Loan Number Seller Name Loan AmountAnnual Rate Term (Years) Payment Payments MadeCurrent Balance Loan Type Agency Delinquency (Months) Status 1 83449837 Shanna's Loan Headquarters 280,000 6.34% 30 $0.00 191 $0.00 VA 2 41209504 Shanna's Loan Headquarters 370,000 4.79% 30 $0.00 322 $0.00 UCONV 3 25055860 Shanna's Loan Headquarters 210,000 6.14% $0.00 32 $0.00 USDA 4 61173887 Shanna's Loan Headquarters 120,000 6.99% $0.00 $0.00 VA 5 51398733 Shanna's Loan Headquarters 350,000 5.01% $0.00 154 $0.00 UCONV 76906141 Shanna's Loan Headquarters 220,000 4.28% $0.00 $0.00 ICONV 49304139 Shanna's Loan Headquarters 330,000 7.99% $0.00 $0.00 USDA 8 23473039 Shanna's Loan Headquarters 160,000 3.78% $0.00 317 $0.00 USDA 9 53651842 Shanna's Loan Headquarters 370,000 5.65% $0.00 73 $0.00 ICONV 10 77159777 Shanna's Loan Headquarters 240,000 5.67% $0.00 174 $0.00 VA Foreclosure Foreclosure Comment 0 This Loan is in Step: n/a o This Loan is in Step: n/a 0 This Loan is in Step: n/a o This Loan is in Step: n/a o This Loan is in Step: n/a This Loan is in Step: n/a O This Loan is in Step: n/a O This Loan is in Step: n/a o This Loan is in Step: n/a O This Loan is in Step: n/a 30

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please include the Excel function/formula used for this question. 4a. Using the groups below, append Status to the table Status Current 30-60 90+ Delinquency 0 Months Delinquent 1-2 Months Delinquent...

PLEASE SHOW EXCEL FORMULA USED! THANK YOU! 5. Append Foreclosure Step (extract from the foreclosure comment). The field should be blank or "n/a" for loans not in foreclosure i.e.: "This Loan is in...

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

1004 Project Questions Questions and Calculations 1. What is the 30 year fixed "purchase money" market Interest rate at your bank? 2. What is the "APR" for #1? (you do not have to calculate this, it...

Please include the Excel function/formula used for this question. 3. Using the provided table, append 'Agency' to the portfolio Loan Type ICONV UCONV Agency FHLMC FNMA GNMA GNMA GNMA FHA VA USDA 191...

Boston all.xlsx contains housing data for 506 census tracts of Boston from the 1970 census. There are 13 variables and 506 observations: 1. crim: per capita crime rate by town. 2. zn: proportion of...

Please include the excel formula. Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two...

1. How might analytics be used in the following situations? Determining a personal investment plan Please answer using at least ten sentences. 2. Use Excels filtering capability in the Purchase...

Refer to the Excel Projects Guidelines file in the Group Corner folder. CAPM & Stock Valuation Project The estimation of company betas is normally brushed over in many introductory finance texts....

Required information [The following information applies to the questions displayed below.] O'Brien Company manufactures and sells one product. The following information pertains to each of the...

Hothouse Mfg. is considering a rights offer. The company has determined that the ex rights price will be $61. The current price is $68 per share, and there are 10 million shares outstanding. The...

Section 2 . Analysis Assume a broker has listed an , 8 0 , 0 0 0 square feet office property for $ 9 million at an advertised 6 . 0 % cap rate in a small suburban market approximately 3 0 minutes...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...