Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bitcoin Mining The New Gold Rush Bitcoin Mining Is The Future

Authors: Sam Sutton

1st Edition

1985654717, 978-1985654716

More Books

Students also viewed these Finance questions

Question

1. Signs and symbols of the map Briefly by box ?

Answered: 1 week ago

Question

Types of physical Maps?

Answered: 1 week ago

Question

Explain Intermediate term financing in detail.

Answered: 1 week ago