FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Please include the Excel function/formula used for this question.image text in transcribed

3. Using the provided table, append 'Agency' to the portfolio Loan Type ICONV UCONV Agency FHLMC FNMA GNMA GNMA GNMA FHA VA USDA 191 322 4 Loan Loan Number Seller Name Loan AmountAnnual Rate Term (Years) Payment Payments MadeCurrent Balance Loan Type Agency 1 83449837 Shanna's Loan Headquarters 280,000 6.34% 30 $0.00 $0.00 VA 2 41209504 Shanna's Loan Headquarters 370,000 4.79% 30 $0.00 $0.00 UCONY 3 25055860 Shanna's Loan Headquarters 210,000 6.14% $0.00 $0.00 USDA 61173887 Shanna's Loan Headquarters 120,000 6.99% $0.00 $0.00 VA 51398733 Shanna's Loan Headquarters 350,000 5.01% $0.00 $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 23473039 Shanna's Loan Headquarters 160,000 3.78% $0.00 $0.00 USDA 53651842 Shanna's Loan Headquarters 370,000 5.65% $0.00 $0.00 ICONV 10 77159777 Shanna's Loan Headquarters 240,000 5.67% $0.00 174 $0.00 VA 154 317 73

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

Evidence Based Audit In General Practice

Evidence Based Audit In General Practice

Authors: Richard Baker, Robin C. Fraser MD FRCGP, Mayur Lakhani MRCP MRCGP DCH

1st Edition

075063104X, 978-0750631044

More Books

Students also viewed these Accounting questions

Question

★★★★★
Do all employees want to be empowered and make the decisions that their bosses used to make? Why or why not?

Answered: 1 week ago

Question

★★★★★
Vista Company manufactures electronic equipment. In 2015 it purchased from an outside supplier the special switches used in each of its products. The supplier charged Vista $2 per switch. As an...

Answered: 1 week ago

Question

★★★★★
34. A flea moves around the vertices of a triangle in the following manner: Whenever it is at vertex i it moves to its clockwise neighbor vertex with probability pi and to the counterclockwise...

Answered: 1 week ago

Question

★★★★★
Rons, Inc.s inventory records for a particular development program show the following at May 31: At May 31, 10 of these programs are on hand. Journalize for Rons: 1. Total May purchases in one...

Answered: 1 week ago

Question

★★★★★
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...

Answered: 1 week ago

Question

★★★★★
Time left 0:2 In 2 of the past 21 years there have been more than 100 days of rain for a particular city. Using the relative frequency method, what is the probability that there will be more than 100...

Answered: 1 week ago

Question

★★★★★
Find the amount (in $) of interest on the loan. Principal Rate (%) Time Interest $50,000 73 9 months tA $ 4

Answered: 1 week ago

Question

★★★★★
7. Make a table of values and graph each function. a) g(x) =-3x+5 for the domain (-3, -2, -1, 0, 1, 2, 3} b) h(x) = for the domain {x | -10 x 10, x = R} Apply 8. Mike currently has $200 and saves $20...

Answered: 1 week ago

Question

★★★★★
An important factor in choosing the best communication channel is its media richness. What does this concept meant, why it is useful to manager and briefly state how technology has contributed in...

Answered: 1 week ago

Question

★★★★★
Ms. Mary Mulenga and Ms. Joyce Hachiintu are second year students from the National Institute of Public Administration pursuing a Bachelor of Arts in Public Administration. After writing their final...

Answered: 1 week ago

Question

★★★★★
Watch this wonderfully made video where flight instruction in France is conducted in English. https://www.youtube.com/watch?v=Y5NOncG7WHY How effective is this instructor in his delivery with the...

Answered: 1 week ago

Question

★★★★★
1-10 Visit a job-posting Web site such as Monster.com. Spend some time at the site examining jobs for accounting, finance, sales, marketing, and human resources. Find two or three descriptions of...

Answered: 1 week ago

Question

★★★★★
1-1 How are information systems transforming business, and why are they so essential for running and managing a business today? Describe how information systems have changed the way businesses...

Answered: 1 week ago

Question

★★★★★
4. What would happen if UPSs information systems were not available? United Parcel Service (UPS) started out in 1907 in a closet-sized basement office. Jim Casey and Claude Ryantwo teenagers from...

Answered: 1 week ago

Previous Question Next Question