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