Produce the following formulas for the information below : Formula for Excel to prove out Loans are eligible Transaction type: Formula to show that True to Purchased loans for ACE and LCA TLTV: formula to prove out 80% is what is in column X Occupancy Status: Formula to prove either Primary residence, second home or investment property is true in column X Rep & Warrant decision: Formula to prove out eligible as true for column X Property Value: Formula for purchases, if -15% <= (Property value HVE)/HVE <=15% , brake down but try to use the complete formula Appraisal Effective date: Formula to prove out effective date of appraisal is no more than 120 days old