All posts by synergy

2018 Mortgage Compliance Trends – Be Prepared

2017 began with a bang as hope permeated the banking industry.

A new administration promised to ease the compliance burden through deregulation, even commanded such through an Executive Order to revoke two existing regs for each new one issued.

Despite these attempts, the year went out with a whimper. The industry has yet to see any substantive change that could be considered burden reduction. While many changes remain bottlenecked inside the legislative process, agencies continued to finalize new regulatory requirements that had already been in the reg-writing pipeline before the reduction order took effect.

Because of this uncertainty, financial institutions have had to rethink their regulatory change management processes. In a climate rife with continuous and often complicated change, the industry turned to technology, which some call “regtech”—as well as hybrid solutions that combine expertise with technology—as a source of stability and to generate predictable outcomes.

Last year presented more “actionable items”—our term for a regulatory tweak that requires a financial institution to take some sort of action in response—than any time in recent banking history. There were more final rules issued (including one repeal); guidance documents published; updated booklets; and manuals updated—than ever before. Regulators issued a staggering 200-plus of these actionable items.

Against the backdrop of a desire for deregulation, other key themes rounded out the year:

• New exam criteria sharpened supervisory expectations for consumer compliance.

• Administrative controversy plagued the CFPB, as its authority (and existence) underwent review.

• Public sentiment turned against regulators in the wake of high-profile scandals and breaches.

• Controversial rules on payday lending and arbitration were delayed or modified.

• Mayhem prevailed in mortgage compliance with HMDA reporting and servicing rules seeing significant overhaul.

Let’s look at each of these developments in more detail.

New exam criteria

During this murky time, an element of clarity was the newly updated consumer compliance rating system. The first upgrade to this rating methodology in over 40 years offered meaningful and actionable guidance on how financial institutions can prepare for examinations across 12 assessment criteria.

The new criteria require examiners to assess four elements of board and management oversight (including how well institutions manage regulatory change), plus four elements of the compliance program in place. The last four criteria direct examiners how to evaluate violations of law, if found, and the extent of consumer harm such violations caused. Examinations taking place after March 31 applied the new rating system.

Confusion at CFPB

Since its inception, and well before Director Cordray’s resignation, CFPB has been a source of controversy. Legislators have sought to eliminate or modify the single-Director structure of the bureau, with several different bills proposing a panel structure or various advisory councils for governance. Talk also surfaced at various times about decommissioning or de-funding the bureau. Previously, the U.S. Appeals Court announced that a case deeming the CFPB unconstitutional in its nature would move forward in 2018.

Richard Cordray’s resignation, preceded by his nomination of Leandra English as his acting replacement, and President Trump’s appointment of Mick Mulvaney to the same acting post, has stoked ambiguity. The situation is still unfolding, in part because New York-based Lower East Side People’s Federal Credit Union has called on a federal court to remove Mulvaney and affirm English as the acting head of the bureau, citing the regulatory chaos that his appointment has caused. Meanwhile, English has been pursuing an injunction intended to install herself as acting head of the bureau.

While the fate and nature of CFPB remains uncertain, the silver lining is that even a shift in structure or leadership is unlikely to impact the methodology by which banks and credit unions are evaluated. The last methods were applied for four decades, so change in the short term is unlikely. Developing a solid compliance management system that adheres to the principles mandated in the assessment criteria was and will remain a sound strategy for years.

Changing public sentiment toward regulators

Two significant events impacted public sentiment toward regulatory bodies: Wells Fargo’s ongoing woes and the Equifax security breach.

In July, Wells Fargo’s forced placement of collision insurance on approximately 800,000 consumer auto loans resulted in thousands of wrongful delinquencies and repossessions. This public scandal came less than a year after CFPB fined Wells Fargo $185 million for wrongfully opening accounts for consumers without their.

During the first Wells Fargo scandal, there was speculation that CFPB would issue rules or guidelines on account opening incentives to discourage similar activity in the future. Although both events were widely discussed, consumers typically have a short memory for these types of controversies and public outcry quickly died down.

The Equifax data breach happened in March, and was publicly disclosed by the company in September. This breach had a more widespread impact on consumers, and heightened industry concerns around cybersecurity. Modest estimates placed the impact of the data breach at 143 million consumers, nearly half of the population of the U.S.

Experts were surprised and dismayed to learn of the vulnerabilities of a service provider as large and sophisticated as Equifax. Financial institutions reacted strongly, taking a renewed interest in how their third-party vendors manage cybersecurity risks.

The number of affected consumers added to the industry’s concerns regarding cybersecurity, and underlined the need for more direct and specific regulatory oversight of this area at the federal level. Consumer-friendly states like New York led the charge on adopting enhanced regulations. Federal regulators have yet to follow suit, though in his first meeting with reporters new Comptroller Joseph Otting indicated concerns in this area.

Controversy around payday lending

One of the more controversial regulations of the year was the CFPB payday lending rule finalized in October. The new regulations place an emphasis on lenders determining a borrower’s ability to repay; enforce cutoffs that restrict how often lenders can attempt to debit a borrower’s account; and encourage smaller loan amounts with longer repayment timelines and less risky loan options for lenders.

The ruling becomes effective on Jan. 16, 2018, and has a mandatory compliance deadline of Aug. 19, 2019.

While traditional bankers see the rule as an overdue attempt to curtail predatory lending, many payday lenders have taken steps to sue CFPB over the new reg. And last December 2017, a bipartisan resolution to repeal the rule was introduced in the House. Supporters cited the importance of these loan types for consumers with short-term cash flow issues.

In addition to legislative threats, the rule is even more vulnerable thanks to the bureau’s leadership controversy. Acting Director Mulvaney lacks authority to repeal the rule, but he can extend its effective date or reopen the comment period. The drama unfolding around payday lending regulations showcases the divided perception of the role of regulatory requirements, especially in 2017, when this sharp rift has resulted in so many consecutive changes to the same regulations (i.e. HMDA and Mortgage Servicing).

Arbitration: perfect snapshot of 2017 regulatory environment

The finalization and subsequent congressional repeal of the CFPB arbitration agreements rules illustrates the confusion and uncertainty in the regulatory environment.

The original rule prevented financial services providers from forcing consumers into arbitration instead of enabling them to pursue lawsuits. Immediately following publication of the final rule, certain members of Congress and lobbyists called for its repeal.

That repeal, by way of a House-passed Congressional Review Act resolution, was approved by the Senate and signed by the President in November. The industry had never seen a regulation issued and then repealed so quickly.

HMDA amendments impacting lending, including CRA and ECOA

2017 saw amendments to amendments as well. This year’s changes to the 2015 HMDA Amendments had a profound impact on the industry upon their release in August organizations have scrambled to prepare for the Jan. 1, 2018, deadline.

In keeping with the tone of uncertainty, industry insiders believe bankers should brace for the possibility of even more HMDA changes in 2018. Congress may even attempt to extend the due date and revise the reporting criteria.

Amendments to the Community Reinvestment Act (CRA) and the Equal Credit Opportunity Act (ECOA) were also needed to align with the HMDA amendments.

The CRA amendments use definitions of “home mortgage loan” and “consumer loan” that are consistent with the revised HMDA reporting criteria. ECOA was amended to permit creditors to collect the expanded demographic information required by the new HMDA rules. Without these updates to CRA and ECOA, lenders would be forced to apply disparate definitions for the same loan types, and the different demographic data collection rules would also make reporting extremely challenging.

Guidance offered on TRID through amendments

CFPB finalized amendments to TRID in 2017 and proposed additional amendments. (TILA RESPA Integrated Disclosures) Some additional mortgage lending regulations that CFPB proposed this year focused on clarifying TRID, specifically offering guidance around common questions that lenders had raised over the last two years. Some of those updates include clarification around common construction lending questions and whether making changes to a loan a few days before closing requires a new statement. This represents one attempt of many in 2017 to clarify existing regulations.

Clarifying common mortgage servicing concerns

In July, CFPB published amendments to its 2016 Mortgage Servicing amendments, effective in October 2017 and April 2018. Early intervention notice requirements were amended effective Oct. 19, 2017, and proposed amendments to periodic statements will become law in April 2018.

The general rule established in 2016 states that once a borrower becomes delinquent, mortgage servicers must notify that consumer of available foreclosure prevention options every 45 days. At the same time, servicers are prohibited from sending the notices more than once in a 180-day period.

Lenders expressed concern about this 180-day window for providing a subsequent notice, observing that if the day fell on a weekend or holiday, it would be impossible to comply. In response to this concern, the amendment provides a ten-day extension period. CFPB also clarified timing requirements for modified statements for borrowers in bankruptcy.

In other important but less complicated developments:

• A revised Call Report template was introduced effective with the March 31 filing for use by financial institutions with no foreign branches and assets under $1 billion.

• Regulation CC was amended to modernize electronic check collection and return procedures. The new rules, effective July 1, 2018, establish warranties for electronic presentment.

Summing it up

In conclusion, 2017 presented the financial services industry with a challenging and confusing regulatory environment in a constant state of flux. Supervisory agencies and Congress seemed to have conflicting objectives at times, which manifested in startlingly swift responses or retractions of each other’s progress.

Regulatory change in all forms, whether new requirements or deregulation efforts, requires significant time and effort to implement.

Because of the incessant changes throughout this year, with more than 200 actionable items that financial institutions carefully implemented, the regulatory burden has been more strenuous than ever.

Part 2 of this series will offer insights for 2018 and strategies for managing regulatory change.

About the authors

Pam Perdue is chief regulatory officer and executive vice-president at Continuity. Donna Cameron is director of regulatory I/O, CRCM, CCBCO. Continuity is a provider of regulatory technology (regtech) solutions that automate compliance management for financial institutions of all sizes.

source:http://www.bankingexchange.com/news-feed/item/7273-2017-regulatory-review-a-mixed-bag?Itemid=639

Upcoming Mortgage Regulation & Compliance Changes for 2018

Getting a mortgage today is much different than it was before the financial crisis.

Loans have to meet certain standards and there are many rules lenders and servicers have to follow. But after a shakeup in leadership at the Consumer Financial Protection Bureau, the future of some policies is uncertain.

Here’s why: The new acting director of the CFPB, budget director Mick Mulvaney, is expected to review regulations that haven’t been finalized, and he may try to alter rules that are already in place.

Here are three policies Mulvaney could change and what adjustments to them might mean for homeowners and homebuyers. The CFPB has already announced plans to reconsider certain rules.

Home Mortgage Disclosure Act

When you apply for a mortgage, some information – including your race, ethnicity and sex – could be released to the public.

For thousands of lenders, reporting mortgage information is mandatory under the Home Mortgage Disclosure Act (HMDA). While the law has been around since 1975, the amount of data made publicly available is increasing, and not everyone is thrilled.

The mortgage industry believes that publishing so much data raises concerns about consumer privacy. And there’s no way to opt out of having your information shared, notes Richard Andreano Jr., partner at the Ballard Spahr law firm.

“They expanded the data set so much that there was a concern that if it was all made public, at what point are borrowers able to be identified using HMDA data?” asks Alexander Monterrubio, director of regulatory affairs at the National Association of Federally-Insured Credit Unions (NAFCU).

Consumer advocates want more information released. Doing so, they argue, protects borrowers from discriminatory lending. It also holds lenders accountable for their actions, says Jaime Weisberg, senior campaign analyst at the Association for Neighborhood & Housing Development (ANHD).

The latest HMDA requirements go into effect January 1, 2018, but the CFPB, the Federal Deposit Insurance Corp. and the Office of the Comptroller of the Currency announced that lenders won’t be penalized for mistakes made while collecting data in 2018 or reporting it in 2019. They also won’t have to resubmit data unless errors are “material.”

The CFPB also said that it would revisit certain aspects of HMDA.

“HMDA could be made almost worthless,” says Peter Smith, a senior researcher at the Center for Responsible Lending. “We need a good body of rules to make sure lenders are playing a fair game with consumers.”

Ability-to-Repay and Qualified Mortgage Standards

Another rule that has been subject to debate is the qualified mortgage (or ability-to-repay) rule implemented in 2014. It requires most lenders to make a “good-faith effort” to determine whether someone can afford a mortgage and eventually pay it back.

Critics say the new standards have kept many people, including low-income individuals, from becoming homeowners.

The CFPB is obligated to review the ability-to-pay rule since the bureau is required to assess existing regulations within five years.

With the CFPB’s change in leadership, there may be pressure to loosen lending requirements, says Barry Zigas, director of housing policy at the Consumer Federation of America. There’s already a Senate billaiming to give qualified mortgage status to loans offered by many banks and credit unions without requiring the lender to meet every condition under the ability-to-repay rule.

The bill’s supporters say it would give more consumers access to mortgages. But Zigas calls it a “dangerous effort to undermine consumer protections.” If it passes, a financial institution may legally avoid going through all of the steps lenders take to ensure borrowers can repay their loans, like considering their debt obligations, verifying income and employment history, and calculating their monthly debt-to-income ratio.

TRID Rule

In 2015, the CFPB combined the mortgage disclosure obligations required by the Truth in Lending Act and the Real Estate Settlement Procedures Act under the TILA-RESPA Integrated Disclosure (TRID) rule. One result of the TRID rule is that consumers preparing to close on a house have two documents explaining their closing costs and mortgage terms, rather than four.

While the new forms helped simplify the closing process for homebuyers, the TRID rule created other problems. For one, it could prevent buyers from closing on their homes as quickly as they want to, says Brandy Bruyere, vice president of regulatory compliance at NAFCU.

For many items on the disclosures, there’s little or no tolerance for last-minute changes, and lenders have had to choose between rejecting borrowers’ requests and eating additional fees.

The CFPB has worked to fix the TRID rule and clear up confusion for lenders. But it hasn’t addressed every issue, leading members of Congress to create a bill that would make additional adjustments.

“The TRID disclosures are solid, and any significant change would add additional costs and uncertainty to the closing process,” says Smith from the CRL.

Rules won’t change overnight

The CFPB’s final rules can’t be modified without issuing a notice and asking the public for feedback. Take these steps to ensure your voice is heard, especially if you’re concerned about how rule changes could affect you.

Comment on any potential policy changes. When the opportunity arises, visit the CFPB’s website and comment on the rules the agency is proposing. “The CFPB doesn’t have to do what the comments say, but they have to provide a reason for not doing so to avoid the rule being struck down as arbitrary and capricious,” says Benjamin Olson, a former deputy assistant director for the Office of Regulations at the CFPB. 

Contact your representative. Congressional leaders can review certain rules issued by the CFPB and potentially overturn them. That’s what happened with the CFPB’s arbitration rule. The policy would’ve made it easier for consumers to file class action lawsuits against banks, but lawmakers used their powers under the Congressional Review Act to kill it before it could take effect. Legislators are now considering the CFPB’s final rule on payday lending and may seek to repeal it. 

Use the complaint database. If you’ve had issues with your mortgage lender or servicer and you’re having trouble resolving them, file a complaint with the CFPB. Typically, you’ll receive a response within 15 days. You can use the same database if you’re having problems with other financial entities, like the bank managing your checking or savings account.

If you’re looking at mortgage rates and preparing to buy a home for the first time, read reviews and do your homework before choosing a lender.

source:https://www.bankrate.com/mortgages/borrowers-beware-these-mortgage-rules-could-soon-get-a-face-lift/

Why are There Too Few Homes For Sale

Almost anyone who has searched for a house recently knows there are not enough houses for sale.

One simple number defines the problem:

In October 2017, the nation had a 3.9-month supply of existing homes for resale. That means, at the pace seen then, it would have taken 3.9 months to sell all the homes on the market. A supply under six months puts home buyers at a disadvantage.

“Inventory is tighter than it appears. It’s much lower for entry-level buyers,” said Sam Khater, deputy chief economist for CoreLogic, a data provider for the real estate industry. He spoke at the Urban Institute’s annual housing finance symposium on Nov. 1.

Why don’t millennial, first-time buyers and Generation X move-up buyers have more to choose from? Who is responsible for the shortage of homes for sale and why? We’ve identified some suspects.

1. Boomers won’t move

More than three-quarters of baby boomers own their homes. For millennials to buy their first homes, and for homeowning Gen Xers to move up to their second home, boomers have to sell. But boomers are staying put.

Realtor.com conducted a survey this year that found that 85% of boomer homeowners planned to stay put over the next 12 months. “The reasons for that could be that they’re living longer, they’re living healthier and so staying in place is more possible for them,” says Danielle Hale, chief economist for Realtor.com.

“[Baby boomers] have been slower than previous generations to sell the family home, thus exacerbating the shortage of houses for sale,” concluded a Freddie Mac research report.

Also, thanks to rising home prices, would-be downsizers can’t find smaller homes that cost much less than their current homes, says Dennis Cisterna, chief executive officer of Investability Solutions, a real-estate investor marketplace. So they stay put. “There’s no urgency to sell right now unless you have to,” he says.

2. Landlords won’t sell

Millions of single-family homes were converted to rentals after the foreclosure crisis, Cisterna says. “Those investors have no incentive to sell,” he says. When a house goes up for sale, “now you’re competing not only with your neighbor who wants to buy that house, you’re also competing with investors.”

Renters made up 36% of households in the third quarter of 2017, up from 31% in 2005, according to the Census Bureau.

With greater demand for homes, but less supply, home values rise. Meanwhile, rents are rising faster than home prices. “Both of those factors would tend to encourage landlords to hold onto those homes and rent them out,” Hale says.

3. Owners are hooked on low mortgage rates

Over the last three years, the interest rate on outstanding mortgages averaged just 3.8%, according to the Department of Commerce. People savor their low mortgage rates and don’t want to give them up.

So as mortgage rates rise, homeowners tend to keep their homes a little longer, said Frank Nothaft, chief economist for CoreLogic, at the Urban Institute symposium.

“That means the inventory of homes for sale, which is already very low, is likely to remain that way if we see higher interest rates,” Nothaft said.

4. Builders ignore entry-level buyers

Through the first nine months of 2017, about 473,000 newly constructed houses were sold, according to the Census Bureau. Fifty-five percent of those homes cost $300,000 or more. “Of the new homes that we are building, the vast majority are move-up products,” Cisterna says. “They’re not for the entry-level buyer anymore.”

Builders counter that they pay $45,000 for a typical buildable lot nationally and around three times that in New England. And they say they face a shortage of skilled construction labor because experienced workers dropped out of the construction trades during the Great Recession, younger people aren’t replacing them, many job applicants can’t pass drug tests, and immigration enforcement is scaring some laborers away.

5. Regulations add costs

Homebuilders say regulations — including environmental protection, infrastructure fees and rules that specify minimum lot sizes — add tens of thousands of dollars to the cost of every home. Regulations account for about one-quarter of the cost of each home, said Michael Neal, assistant vice president for forecasting and analysis for the National Association of Home Builders.

A Freddie Mac report concurred. “Land-use regulations have become more burdensome” in the last 30 years, making it costlier to build, it said. Freddie Mac found that it takes just 3.5 months to get a building permit in lenient New Orleans, whereas it takes 17 months to get a building permit in restrictive Honolulu. A longer permitting process costs money as developers carry the investments on their books while awaiting permission to build.

6. Owners want to restrict supply

Local zoning and land-use regulations aren’t bestowed by a hidden hand. They’re enacted by officials who were elected by the people. When planning and zoning officials limit the number of houses that can be built in a neighborhood, or when they set minimum square footage for houses, they’re limiting the supply of homes and making them more expensive. They’re responding to constituents.

“There are regulations that are more about the neighbors’ sensibilities than they are about the safety of the people living in the houses,” says Miriam Axel-Lute, associate director of the National Housing Institute, a nonprofit that examines how social issues affect housing.

“It’s neighbors who want their property values to go up, in most cases, who are insistent upon some excess safety design standards or minimum lot sizes or other things,” she says. “They either want their property values to go up or they don’t want, quote, ‘the wrong sort of people’ in their neighborhoods. This is the pressure behind a lot of the most damaging regulations out there.”

How can home buyers respond?

Clearly, it will take time and concerted effort to fix the problem of not enough houses for sale. Meantime, there are things home buyers can do:

Be realistic about how long it will take to find and buy a home. Real-estate agents can provide an estimate, based on market conditions.

Save plenty of money for a down payment and reserves.

Improve your credit score to get a good mortgage deal.

Be ready to make a competitive offer when a suitable home comes on the market.

That advice works for any real-estate market, whether it favors sellers or buyers. But these tips are especially appropriate when inventory is low.

Source:  https://www.nerdwallet.com/blog/mortgages/6-reasons-there-arent-enough-homes-for-sale/

Want Higher Returns on Mortgages ?

With strict new federal mortgage regulations on banks coming in January, more borrowers – and investors – will be looking at alternative financing. Investing in alternative mortgage lending is already a fast-growing, multi-billion dollar industry.

Two key avenues for investors are Mortgage Investment Corporations (MICs) and syndicated mortgages. They both lend money to higher-risk borrowers, but  investors must understand the pros and cons of each, and what makes them so different.

Mortgage Investment Corporation (MIC)

An MIC is a pool of capital that is raised through shareholders and is collectively lent to a diversified pool of residential and commercial mortgages. You are buying shares in a corporation that invests on your behalf.

Pros:

Since you are investing in a pool of mortgages you can mitigate a great deal of the typical risk associated with direct private or syndicated mortgages.

An MIC has a team of professional mortgage underwriters who review mortgage loans every day and can determine the risk on your behalf.

It creates regular monthly cash flow that can be tax f ree savings account (TFSA) or registered retirement savings plan  (RRSP) eligible.

If a mortgage goes into default, it is only one of many, so the MIC can begin the foreclosure procedure without having to disrupt monthly cash distributions to the investor.

Targeted returns are typically from 7 per cent to 8 per cent, annually.

The monthly payment is a “flow-through” from the pool of monthly mortgage payments back to the shareholders. There is no term; it is continuous.

A MIC will have an offering memorandum that clearly outlines the parameters and lending restrictions, including: maximum loan to value and percentage allowable for commercial real estate, raw land or development.

Cons:

An MIC has higher overhead and, as such, charges a management fee. The gains are net after fees. Thus net returns are often closer to 7 per cent rather than the 10 per cent targeted by privates or syndicates.

Caution is required that the MIC does not do the following: allocate an excessive amount of loans to farmland, raw land or developments, since these are hard to foreclose on, and it can be difficult to recuperate the loan in the event of a forced sale; or loans lent to personal friends or management partners.

Check that the MIC you invest with has a third-party independent advisory board that oversees the nature of the loans and ensures that they are consistent with their operating memorandum.

Syndicated mortgages

This is the scenario in which two or more individuals lend their money to a specific project and borrower. The money could be lent on anything from a single-family house to a developer with a large project.

Pros:

A syndicated loan is a direct loan to an individual with no fees to a middleman, so the return can be higher – typically above 10 per cent.

The syndicated group can be on title.

A mortgage broker who tends to “de-risk” the investment typically sources syndicated mortgages.

You know exactly whom you are lending to and what you are lending on.

It provides monthly cash flow.

Cons:

The biggest downside is that you are lending directly to a single individual or developer.

Any individual can encounter problems beyond his or her control, which could cause a default on the mortgage, even foreclosure.

In the event of such trouble, the syndicated partners may not have the experience and/or willingness to foreclose, a process that can take months.

If you have to foreclose, your money, cash flow and return can be held in limbo for months. If you lent to a development that was half complete when foreclosed on, the syndicate could lose a large portion of its investment.

A syndicated loan can be re-paid early (depending on terms) and it may take time to find the next “deal” or person to lend to. The return on syndicated loans looks attractive but your money is not always at work for 365 days a year. Your real annualized returns over a five-year period may be closer to 8 per cent.

Not all syndicated mortgages are TFSA or RRSP eligible.

Summary

Investing through a syndicated mortgage will generate higher returns than an MIC, but in doing so you take on more risk.

There is always a risk that some people will default on their mortgage – remember, there is a reason they did not qualify at the bank. The single biggest difference between an MIC and a syndicated mortgage is that with an MIC, you bought shares in a fund that invests in a pool of mortgages, so if up to 5 per cent go into default, 95 per cent are still paying monthly. With a syndicated mortgage, if the person you lent to defaults, your income stops and your money is at risk.

Syndicated mortgages are more appropriate for the sophisticated investor who understands the risks associated and expects a higher return.

MICs are more suitable for the less-experienced investor who is willing to accept a slightly lower return in exchange for increased security.

 

Source: http://www.westerninvestor.com/news/finance/investing-in-alternative-mortgage-lending-risks-and-rewards-1.23105791

Thinking of Leaving Your Mortgage Company ?

Mortgage lender Guaranteed Rate alleges that while still employed at the company, one of its “most highly compensated executives” planned and participated in an exodus of more than 20 employees to a newly formed rival, according to a lawsuit filed by the Chicago-based company.

Joseph Caltabiano, the former senior vice president of mortgage lending at Guaranteed Rate who is named in the lawsuit, disputes those claims. “I deny the allegations that I did anything inappropriately,” he said.

The employees who left Guaranteed Rate allegedly joined the staff of Bemortgage, a recently launched mortgage lender that operates as a division of Bridgeview Bank Group, according to the lawsuit, filed Wednesday in Cook County Circuit Court. Caltabiano joined Bemortgage’s ranks as senior vice president of mortgage banking about two weeks ago, he said Friday.

Guaranteed Rate paid Caltabiano about $1.75 million this year through Nov. 15, according to the lawsuit. He was one of the three highest producing loan originators employed by the company, and remains the ninth largest shareholder, the complaint states.

The company “terminated” Caltabiano on Nov. 16, according to the suit. Court documents say Caltabiano allegedly coordinated the transition of Guaranteed Rate’s Chicago-area team to Bemortgage with senior executives at Bridgeview, some of who had also previously been employed at Guaranteed Rate.

Those team members’ transition allegedly had been planned while Caltabiano was still employed at Guaranteed Rate, according to the complaint. The lawsuit alleges that Caltabiano breached his fiduciary duties to Guaranteed Rate by soliciting its employees to leave and join Bemortgage and by competing with it on behalf of Bemortgage.

“Mr. Caltabiano was terminated for misconduct, as described in our lawsuit,” Guaranteed Rate said in a statement Friday.

Caltabiano denied those allegations and said he disagrees that Guaranteed Rate terminated him. He said he worked there for 15 years and that it was a good place to work, but the time had come to explore more opportunities.

“I have a staff that works with me that voluntarily decided to pursue other opportunities as well,” he said. “You’ve got a lot of new opportunities in the mortgage banking space that weren’t here five years ago.”

Also named in the suit is Bridgeview Bancorp, holding company of Bridgeview Bank, which has about 15 locations throughout the Chicago area. The lawsuit also alleges Bridgeview and Caltabiano conspired to breach their fiduciary duties. Peter Haleas, chairman of Bridgeview’s board, said the bank did nothing wrong.

“I know that Bridgeview conducted itself in the full spirit of the law and business ethics, and we have no culpability,” he said.

In May, Guaranteed Rate filed an unrelated lawsuit alleging an employee and two former employees solicited other workers to join competitor Cross Country Mortgage and planned to open competing branches while still employed by Guaranteed Rate. The case was dismissed in September, according to court documents.

 

Source: http://www.chicagotribune.com/business/ct-biz-guaranteed-rate-lawsuit-20171201-story.html

Fannie Mae Updates Selling Guide

Selling Guide Announcement SEL-2017-09  October 31, 2017 Selling Guide Updates

The Selling Guide has been updated to include changes to the following:

 Servicing Execution Tool™ (SET™) and Servicing Marketplace  Inter Vivos Revocable Trusts

 Consolidation of eSign and Electronic Transactions  Mortgages Paid by Others

 Form 1004D as Optional for Uniform Collateral Data Portal (UCDP)

 Miscellaneous Selling Guide Updates Each of the updates is described below.

The affected topics for each policy change are listed on the Attachment. The Selling Guide provides full details of the policy changes. The updated topics are dated October 31, 2017. In addition, revisions to the Texas Security Instrument are described in this Announcement.

Servicing Execution Tool (SET) and Servicing Marketplace In December 2014, we introduced the Servicing Execution Tool (SET) Bifurcation option for concurrent transfers of servicing via the Pricing & Execution – Whole Loan® (PE-Whole Loan) committing platform, under which the selling representations and warranties for the delivered loans are bifurcated from the servicing duties, obligations, and responsibilities. With this update, we are expanding access to the bifurcation of selling and servicing representations and warranties available through PE-Whole Loan. In addition, we are introducing the Servicing Marketplace, an application designed to enhance and bring new concurrent transfer of servicing options to customers. This expansion is designed to simplify the customer experience related to concurrent transfers of servicing transactions and provide certainty of sale, execution, and process efficiency. In order for a seller to join SET or Servicing Marketplace, the eligibility criteria outlined in the Selling Guide must be met. As a reminder, specific lender approval is required to participate in the SET and Servicing Marketplace solutions. Effective Date Loans delivered against PE-Whole Loan servicing released commitments taken on or after December 4, 2017 will be bifurcated if seller participates in SET or Servicing Marketplace. Inter Vivos Revocable Trusts Normally, Fannie Mae deems property in which no borrower has a direct ownership interest as ineligible collateral. An exception has been granted for inter vivos revocable trusts, a common estate planning tool that may involve instances where no individual borrower has an ownership interest in the mortgaged property. We have made changes to the Selling Guide to clarify the distinction between the individual borrower and the inter vivos revocable trust as owner of an interest in the mortgaged property. We also clarify our expectations for the execution of notes and mortgages. © 2017 Fannie Mae. Trademarks of Fannie Mae. SEL- 2017-09 2 of 4 Effective Date These updates are effective immediately. Consolidation of eSign and Electronic Transactions In line with our continued efforts to simplify and consolidate policies shared by the Selling and Servicing Guide, we have again updated and streamlined duplicative content in a few topics in Part A, Doing Business with Fannie Mae, pertaining to electronic records, signatures, and other electronic transactions. With this update, we have  consolidated into one topic the various policies that pertain to the management of electronic transactions and confirmed that sellers/servicers are authorized to originate, service, and modify loans using electronic records (special approval is still required for electronic promissory notes);  clarified that audio and video recording are not permitted formats except to the extent requested by us in connection with permitted remote notarizations;

 streamlined language to clarify that electronic records must accurately reflect information and formatting as it was presented to the intended beneficiaries and signers;

 required that systems generating electronic records generate them as valid records and be maintained as secure;

 confirmed that recorded mortgages and deeds of trust need not be maintained in paper format;

 confirmed that all electronic signatures must comply with ESIGN, UETA, and applicable law; and

 removed requirements for document custodians from the Guide as they were duplicative of requirements in Fannie Mae’s Requirements for Document Custodians (RDC). There are no policy changes associated with this consolidation of content. The duplicative content was removed from the Servicing Guide in the update published on October 11, 2017, and the consolidated policy now resides within Selling Guide A2-5.1-03, Electronic Records, Signatures, and Transactions. Effective Date These updates are effective immediately. Mortgages Paid by Others We recently updated our policies in the Selling Guide related to multiple financed properties and mortgage debts paid by others. With this update, we are clarifying that when a borrower is obligated on a mortgage, but another party has been making the mortgage payments  the lender may exclude the full monthly housing expense from the DTI ratio, provided the borrower is not using rental income from the applicable property to qualify; that is, the PITIA may be excluded and not just the principal and interest payment;  the mortgaged property must still be included in the borrower’s multiple financed property count and the unpaid principal balance for the mortgage must still be included in the calculation of reserves for multiple financed properties. Effective Date These clarifications are effective immediately. Form 1004D as Optional for Uniform Collateral Data Portal (UCDP) To align with the UCDP Release Notification from September 12, 2017, we updated our policy related to forms that can be submitted to UCDP. Lenders now have the option to submit the Appraisal Update and/or Completion Report, (Form 1004D) directly to the portal for conventional mortgage loans delivered to Fannie Mae. © 2017 Fannie Mae. Trademarks of Fannie Mae. SEL- 2017-09 3 of 4 Effective Date Effective immediately. Miscellaneous Selling Guide Updates  B4-1.3-01, Review of the Appraisal Report. We updated the overview to clarify the purpose of our appraisal report policies.  B5-5.2-03, DU Refi Plus and Refi Plus Property Valuation and Project Standards Condo, Co-op, and PUD Project Review Requirements. To align with our standard policy, we updated the condo, co-op, and PUD project insurance requirements for DU Refi Plus loans to remove the requirement for liability insurance coverage.  A2-4-01, Master Agreement Overview. The Selling Guide contains a list of the types of mortgage loans that currently require negotiated terms in a Master Agreement, which includes second mortgage loans. From time to time, we receive questions as to whether we are currently negotiating second mortgages. As a result, we have added a clarification that we are not approving lenders for or accepting deliveries of second mortgages. Revisions to the Texas Security Instrument Fannie Mae and Freddie Mac have revised the Texas Deed of Trust (Form 3044) to reflect recent changes to state law that affect the date of foreclosure sales. The revised Form 3044 (with a revision date of 10/17) is available on the SingleFamily Security Instruments page on our website. Effective Date Lenders are encouraged to use the updated document immediately, but must do so for mortgage loans with note dates on or after April 1, 2018. Proposed Texas Constitutional Amendments for Home Equity Lending Voters in Texas will be voting on proposed amendments to the Texas constitution on November 7, 2017. These amendments, if passed, will affect home equity lending in Texas, and will become effective on January 1, 2018. Fannie Mae is assessing the potential impact on our Texas home equity legal documents and will provide guidance and updates if the amendments are passed. ***** Lenders who have questions about this Announcement should contact their Customer Delivery Team.

Source: https://www.fanniemae.com/content/announcement/sel1709.pdf

CFPB Publishes Information Regarding Beta Launch HMDA Platform

The FFIEC and HUD have published the following resources for financial institutions required to file Home Mortgage Disclosure Act (HMDA) data:

Announcement

Updated November 2017:

The Bureau launched the beta version of the HMDA Platform.

A new short video introducing the HMDA Platform is now available on CFPB’s YouTube channel.

HMDA Platform

The beta version of the HMDA Platform allows financial institutions to upload sample HMDA files and perform validation on the data; review edits; confirm the test data submission; and conclude the test HMDA filing process.

Technology Preview

The Technology Preview provides resources for financial institutions preparing their systems to file HMDA data with the CFPB.

Filing Instructions Guide

Separate Filing Instructions Guides (FIG) are now available for data collected in 2017 and 2018.

For data collected in 2017

For data collected in or after 2018

For data collected in or before 2016, please visit the FFIEC website  for data submission resources.

Loan/Application Register (LAR) Formatting Tool

The LAR Formatting Tool is intended to help financial institutions, typically those with small volumes of covered loans and applications, to create an electronic file that can be submitted to the HMDA Platform.

File Format Verification Tool (FFVT)

The File Format Verification Tool is provided for filers who wish to confirm that a LAR file is formatted in the required pipe delimited text file format, and meets certain formatting requirements specified in the Filing Instructions Guide. Section 3 of the HMDA Tools Instructions guide provides further information on using the FFVT.

HMDA Loan Scenarios

The HMDA Loan Scenarios is provided as an illustrative aid to help HMDA filers prepare their loan/application register.

Frequently Asked Questions (FAQs)

Do you have additional questions? Please check out the FAQs.

Questions?

For technical questions about reporting HMDA data collected in or after 2017 use this form or email hmdahelp@cfpb.gov.

source :https://www.consumerfinance.gov/data-research/hmda/for-filers

CFPB Issues Updated Small Entity Compliance Guide

1. Introduction For more than 30 years, federal law required lenders to provide two different disclosure forms to consumers applying for a mortgage. The law also generally required two different forms at or shortly before closing on the loan. Two different federal agencies developed these forms separately, under two federal statutes: the Truth in Lending Act (TILA) and the Real Estate Settlement Procedures Act of 1974 (RESPA). The information on these forms was overlapping, and the language inconsistent. Consumers often found the forms confusing, and lenders and settlement agents found the forms burdensome to provide and explain. The Dodd-Frank Wall Street Reform and Consumer Protection Act (Dodd-Frank Act) directed the Consumer Financial Protection Bureau (Bureau) to integrate the mortgage loan disclosures under TILA and RESPA Sections 4 and 5. Section 1032(f) of the Dodd-Frank Act mandated that the Bureau propose for public comment rules and model disclosures that integrate the TILA and RESPA disclosures by July 21, 2012. The Bureau satisfied this statutory mandate and issued proposed rules and forms on July 9, 2012. To accomplish this, the Bureau engaged in extensive consumer and industry research, analysis of public comment, and public outreach for more than a year. After issuing the proposal, the Bureau conducted a large-scale quantitative study of its proposed integrated disclosures with approximately 850 consumers, which concluded that the Bureau’s integrated disclosures had on average statistically significant better performance than the pre-existing disclosures under TILA and RESPA. On December 31, 2013, the Bureau published a final rule with new, integrated disclosures – “Integrated Mortgage Disclosures Under the Real Estate Settlement Procedures Act (Regulation X) and the Truth In Lending Act (Regulation Z)” (TILA-RESPA Final Rule). On January 20, 2015 and July 21, 2015, the Bureau issued amendments to the TILA-RESPA Final Rule. Additionally, the Bureau published technical corrections on December 24, 2015, and a

correction to supplementary information on February 10, 2016. On July 7, 2017, the Bureau issued further amendments intended to formalize guidance, and provide greater clarity and certainty (2017 TILA-RESPA Rule or 2017 amendments).1 The 2017 amendments were published in the Federal Register on August 11, 2017. The TILA-RESPA Final Rule, the amendments, and corrections are collectively referred to as the TILA-RESPA Rule in this Guide. The TILA-RESPA Rule provides a detailed explanation of how the forms should be filled out and used. The Good Faith Estimate (GFE) and the initial Truth-in-Lending disclosure (initial TIL) were combined into a single form, the Loan Estimate. Similar to those forms, the Loan Estimate form is designed to provide disclosures that will be helpful to consumers in understanding the key features, costs, and risks of the mortgage loan for which they are applying, and must be provided to consumers no later than the third business day after they submit a loan application. Second, the HUD-1 and final Truth-in-Lending disclosure (final TIL and, together with the initial TIL, the Truth-in-Lending forms) were combined into another form, the Closing Disclosure, which is designed to provide disclosures that will be helpful to consumers in understanding all of the costs of the transaction. This form must be provided to consumers at least three business days before consummation of the loan. The forms use clear language and design to make it easier for consumers to locate key information, such as interest rate, monthly payments, and costs to close the loan. The Loan Estimate and Closing Disclosure forms also provide more information to help consumers decide whether they can afford the loan and to facilitate comparison of the cost of different loan offers, including the cost of the loans over time. The TILA-RESPA Rule applies to most closed-end consumer mortgages. It does not apply to home equity lines of credit (HELOCs), reverse mortgages, or mortgages secured by a mobile home or by a dwelling (other than a cooperative unit) that is not attached to real property.2 Itdoes not generally apply to loans made by persons who are not considered “creditors” under TILA.3 Generally, the TILA-RESPA Rule’s provisions were effective on October 3, 2015. The December 2015 corrections were effective on December 24, 2015, and the February 2016 corrections were effective on February 10, 2016. The 2017 amendments are effective and will be incorporated into the Code of Federal Regulations on October 10, 2017. However, compliance with the 2017 amendments is not mandatory on the effective date. Generally, compliance with the amendments is only mandatory for transactions for which a creditor or mortgage broker receives an application on or after October 1, 2018. However, the requirements for the Escrow Cancellation Notice (Escrow Closing Notice) and Mortgage Servicing Transfer Notice Partial Payment Policy Disclosure (Partial Payment Policy Disclosure) provided post-consummation apply starting October 1, 2018 without regard to when the creditor or mortgage broker receives the application. The 2017 amendments include an optional compliance period, which begins on October 10, 2017 and is for transactions for which a creditor or mortgage broker receives an application prior to October 1, 2018. During this period, early compliance with the 2017 amendments is allowed, but not required. Additionally, if a creditor or mortgage broker receives an application prior to October 1, 2018, optional compliance continues to apply to that transaction after October 1, 2018 (except as noted regarding the Escrow Closing Notice and Partial Payment Policy Disclosures). During the optional compliance period (beginning on October 10, 2017 and for transactions with applications received prior to October 1, 2018), the provisions of the 2017 amendments can be implemented all at once or phased in over this period. For example, if a creditor chooses to phase in the 2017 amendments, those changes can be phased-in over the course of a transaction or by application date. Notwithstanding this flexibility, a person cannot phase in the 2017 amendments in a way that would violate provisions of Regulation Z that are not being changed.4 The information provided in this Guide incorporates the changes and clarifications from the 2017 amendments, and explains the TILA-RESPA Rule as of the mandatory compliance date on October 1, 2018. To understand the rule as it existed prior to the 2017 amendments, please review version 4.0 of the Guide, available on the Bureau’s website at https://www.consumerfinance.gov/policy-compliance/guidance/implementationguidance/tila-respa-disclosure-rule/.

1.1 What is the purpose of this guide? The purpose of this Guide is to provide an easy-to-use summary of the TILA-RESPA Rule. This Guide also highlights issues that small creditors, and those that work with them, might find helpful to consider when implementing the TILA-RESPA Rule. This Guide also meets the requirements of Section 212 of the Small Business Regulatory Enforcement Fairness Act of 1996, which requires the Bureau to issue a small-entity compliance guide to help small entities comply with these new regulations. You may want to review your processes, software, contracts with service providers, or other aspects of your business operations in order to identify any changes needed to comply with this rule. Changes related to this rule may take careful planning, time, or resources to implement. This Guide will help you identify and plan for any necessary changes. To support rule implementation, the Bureau continues to coordinate with other agencies, publish and update plain-language guides, and publish updates to the Official Interpretations, if needed.

 

This Guide summarizes the TILA-RESPA Rule, but it is not a substitute for the rule. Only the rule and its Official Interpretations (also known as commentary) can provide complete and definitive information regarding its requirements. The discussions below provide citations to the sections of the TILA-RESPA Rule on the subject being discussed. Keep in mind that the Official Interpretations, which provide detailed explanations of many of the TILA-RESPA Rule’s requirements, are found after the text of the rule and its appendices. The interpretations are arranged by rule section and paragraph for ease of use. The 2013 Final Rule and the Official Interpretations, and related corrections and amendments, are available at www.consumerfinance.gov/policy-compliance/rulemaking/final-rules/2013-integratedmortgage-disclosure-rule-under-real-estate-settlement-procedures-act-regulation-x-and-truthlending-act-regulation-z/. The focus of this Guide is the TILA-RESPA Rule. This Guide does not discuss other federal or state laws that may apply to the origination of closed-end credit. The content of this Guide does not include any rules, bulletins, guidance, or other interpretations issued or released after the date on the Guide’s cover page. At the end of this Guide, there is more information about the TILA-RESPA Rule and related implementation support from the Bureau. 1.2 Who should read this guide? If your organization originates closed-end residential mortgage loans, you may find this Guide helpful to determine your compliance obligations for the mortgage loans you originate. This Guide may also be helpful to settlement service providers, secondary market participants, software providers, and other companies that serve as business partners to creditors.

1.3 Where can I find additional resources that will help me understand the TILARESPA Rule? Resources to help you understand and comply with the Dodd-Frank Act mortgage reforms and our regulations, including downloadable compliance guides, are available through the CFPB’s website at www.consumerfinance.gov/policy-compliance/guidance/implementationguidance/. On this website, we also offer the ability to sign up for an email distribution list 20 CONSUMER FINANCIAL PROTECTION BUREAU SMALL ENTITY COMPLIANCE GUIDE: TILA-RESPA INTEGRATED DISCLOSURE RULE v 5.0 through which we announce additional resources and tools as they become available. The eRegulations tool, which is available at www.consumerfinance.gov/eregulations, includes an unofficial version of Regulation Z (12 CFR part 1026), in which the TILA-RESPA Rule is codified. The tool provides updated versions of the regulatory text and commentary in a single location. If after reviewing these materials, as well as the regulation and official commentary, you have a specific regulatory interpretation question about the TILA-RESPA Rule, you can submit it to us on our website at https://reginquiries.consumerfinance.gov/. Please understand that the responses we provide are not official interpretations of the Bureau and are not a substitute for formal legal counsel or other compliance advice. Email comments about the Guide to CFPB_RegulatoryImplementation@consumerfinance.gov. Your feedback is crucial to making this Guide as helpful as possible. The Bureau welcomes your suggestions for improvements and your thoughts on its usefulness and readability. The Bureau is particularly interested in feedback relating to:  How useful you found this Guide for understanding the TILA-RESPA Rule;  How useful you found this Guide for implementing the TILA-RESPA Rule at your business; or  Suggestions you have for improving the Guide, such as additional implementation tips. 21 CONSUMER FINANCIAL PROTECTION BUREAU SMALL ENTITY COMPLIANCE GUIDE: TILA-RESPA INTEGRATED DISCLOSURE RULE v 5.0 2. Overview of the TILARESPA Rule 2.1 What is the TILA-RESPA Rule about? The TILA-RESPA Rule consolidates four disclosure forms that were required under TILA and RESPA for closed-end credit transactions secured by real property or cooperative unit into two forms: a Loan Estimate that must be delivered or placed in the mail no later than the third business day after receiving the consumer’s application, and a Closing Disclosure that must be provided to the consumer at least three business days prior to consummation.

2.2 What transactions does the rule cover? (§ 1026.19(e) and (f)) The TILA-RESPA Rule applies to most closed-end consumer credit transactions secured by real property or a cooperative unit (regardless of whether state law classifies it as real property). Credit extended to certain trusts for tax or estate planning purposes is not exempt from the TILA-RESPA Rule. (Comment 3(a)-10). However, some specific categories of loans are excluded from the rule. Specifically, the TILA-RESPA Rule does not apply to HELOCs, reverse mortgages, or mortgages secured by a mobile home or by a dwelling (other than a cooperative unit) that is not attached to real property. (§ 1026.19(e) and (f)). For further discussion of coverage, see section 4 below.

2.3 What are the record retention requirements for the TILA-RESPA Rule? (§ 1026.25) The creditor must retain copies of the Closing Disclosure (and all documents related to the Closing Disclosure) for five years after consummation. The creditor, or servicer if applicable, must retain the post-consummation Escrow Closing Notice and Partial Payment Policy Disclosure for two years. For additional information, see section 16 below. For all other evidence of compliance with the Integrated Disclosure provisions of Regulation Z (including the Loan Estimate) creditors must maintain records for three years after consummation of the transaction. Creditors are obligated to obtain and retain a copy of the completed Closing Disclosures provided separately by a non-creditor settlement agent to a seller under 1026.38(t)(5), but are not obligated to collect underlying seller-specific documents and records from that third-party settlement agent to support these disclosures. To the extent the creditor does receive documentation related to the seller’s disclosure, such as when the creditor is the settlement agent, or when seller-related documents are provided to the creditor by a third-party settlement agent along with the completed disclosure, the creditor should adhere to the record retention requirements that apply to the Closing Disclosure. 2.4 What are the record retention requirements if the creditor transfers or sells the loan? (§ 1026.25) If a creditor sells, transfers, or otherwise disposes of its interest in a mortgage and does not service the mortgage, the creditor shall provide a copy of the Closing Disclosure to the new owner or servicer of the mortgage as a part of the transfer of the loan file. Both the creditor and the new owner or servicer shall retain the Closing Disclosure for the remainder of the five-year period.

2.5 Is there a requirement on how the records are retained? Regulations X and Z permit, but do not require, electronic recordkeeping. Records can be maintained by any method that reproduces disclosures and other records accurately, including computer programs. (Comment 25(a)-2)

3. Effective Date 3.1 When do I have to start following the TILA-RESPA Rule and using the Integrated Disclosures? The TILA-RESPA Rule generally took effect on October 3, 2015 for applications received on or after October 3, 2015. The Integrated Disclosures (i.e., the Loan Estimate and the Closing Disclosure) must be provided by a creditor or mortgage broker that receives an application from a consumer for a closed-end credit transaction secured by real property on or after October 3, 2015.5 Creditors were required to use the GFE, HUD-1, and Truth-in-Lending forms for applications received prior to October 3, 2015. 3.2 Are there any requirements that take effect regardless of when an application was received? Yes. As discussed in section 13, below, the TILA-RESPA Rule includes some restrictions on certain activity prior to a consumer’s receipt of the Loan Estimate. These restrictions took effect on the calendar date October 3, 2015, regardless of when an application was received. These activities include:

Imposing fees on a consumer before the consumer has received the Loan Estimate and indicated an intent to proceed with the transaction (§ 1026.19(e)(2)(i));  Providing written estimates of terms or costs specific to consumers before they receive the Loan Estimate without a written statement informing the consumer that the terms and costs may change (§ 1026.19(e)(2)(ii)); and  Requiring the submission of documents verifying information related to the consumer’s application before providing the Loan Estimate. (§ 1026.19(e)(2)(iii)) Beginning on October 1, 2018, a creditor must provide the Escrow Closing Notice and Partial Payment Policy Disclosure when required, regardless of when the creditor or mortgage broker received the application.6 (Comment 1(d)(5)-1) For example, for an application received on October 10, 2010, if the escrow account was cancelled on April 14, 2020, the creditor would be required to give the Escrow Closing Notice, because the cancellation occurred after October 1, 2018 and after that time, Escrow Closing Notice and Partial Payment Policy Disclosure are given regardless of when the application was received. (Comment 1(d)(5)-1.v.E) For more information about the Escrow Closing Notice and Partial Payment Policy Disclosure, see section 16 of this Guide. 6 Prior to October 1, 2018, it is acceptable for a creditor to give the Escrow Closing Notice and Partial Payment Policy Notice only to transactions where the application was received on or after October 3, 2015. For example, for an application received on October 10, 2010, if the escrow account was cancelled on December 19, 2016, the creditor would not be required to provide the Escrow Closing Notice because the application was received before October 3, 2015 and the cancellation occurred prior to October 1, 2018. A consumer may indicate an intent to proceed in any manner the consumer chooses, unless the creditor requires a particular manner of communication. (§ 1026.19(e)(2)(i)(A)). For further discussion on intent to proceed, see section 13.5 below. 26 CONSUMER FINANCIAL PROTECTION BUREAU SMALL ENTITY COMPLIANCE GUIDE: TILA-RESPA INTEGRATED DISCLOSURE RULE v 5.0 3.3 Can a creditor use the Integrated Disclosures for applications received before October 3, 2015? No. For transactions where the application is received prior to October 3, 2015, creditors will still need to follow the disclosure requirements under Regulations X and Z as they existed before the Integrated Disclosures were created by the TILA-RESPA Rule. A creditor will need to use the Truth-in-Lending disclosures, GFE, HUD-1, etc., as applicable, for those transactions. 27 CONSUMER FINANCIAL PROTECTION BUREAU SMALL ENTITY COMPLIANCE GUIDE: TILA-RESPA INTEGRATED DISCLOSURE RULE v 5.0 4. Coverage 4.1 What transactions are covered by the TILA-RESPA Rule? (§§ 1024.5; 1026.3; and 1026.19) The TILA-RESPA Rule applies to most closed-end consumer credit transactions secured by real property or a cooperative unit (regardless of whether state law classifies it as real property), but does not apply to:  HELOCs;  Reverse mortgages; or  Chattel-dwelling loans, such as loans secured by a mobile home or by a dwelling (other than a cooperative unit) that is not attached to real property. Consistent with existing rules under TILA, the TILA-RESPA Rule also generally does not apply to loans made by a person or entity that is not considered a creditor under Regulation Z. (§ 1026.2(a)(17)) There is also a partial exemption for certain transactions associated with housing assistance loan programs for low- and moderate-income consumers. (§ 1026.3(h)) However, certain types of loans that are subject to TILA but are not subject to RESPA are subject to the TILA-RESPA Rule’s integrated disclosure requirements, including:  Construction-only loans; and  Loans secured by vacant land or by 25 or more acres.

Source :https://s3.amazonaws.com/files.consumerfinance.gov/f/documents/201710_cfpb_KBYO-Small-Entity-Compliance-Guide_v5.pdf

The 10 Most Useful Things in Excel

Every Excel user has their own favorite tip. So we decided to bring some method, data, and science to bear in this hotly debated topic.

We consulted the research of 30 of the world’s leading Excel experts, our own internal Excel experts, grouped up and consolidated the emerging features, and applied a scoring methodology and index to produce a definitive ordered list of the 100 most useful Excel features, hacks, tips and tricks.

These are the top 10 Excel tips as determined by our ranking.

Skills are ranked by usefulness and given a score out of 100. Each skill also has a difficulty rating (out of 5) based on the complexity and sophistication of the feature. Finally, we provide the average time in minutes it takes the average learner to go from no knowledge to proficient.

The videos and gifs inserted in this list were created by Business Insider.

1. Conditional Formatting

Utility: 100
Difficulty: 3
Learn in 180 mins

Making sense of our data-rich, noisy world is hard but vital. Used well, Conditional Formatting brings out the patterns of the universe, as captured by your spreadsheet. That’s why Excel experts and Excel users alike vote this the #1 most important feature. This can be sophisticated. But even the simplest colour changes can be hugely beneficial. Suppose you have volumes sold by sales staff each month. Just three clicks can reveal the top 10% performing salespeople and tee up an important business conversation.

2. PivotTables

Utility: 95
Difficulty: 3
Learn in 240 mins

At 4 hours to get to proficiency, you may be put off learning PivotTables but don’t be. Use them to sort, count, total or average data stored in one large spreadsheet and display them in a new table, cut however you want. That’s the key thing here. If you want to look only at sales figures for certain countries, product lines or marketing channels, it’s trivial. Warning: make sure your data is clean first!

3. Paste Special

Utility: 88
Difficulty: 3
Learn in 10 mins

Grabbing (ie Copying) some data from one cell and pasting it into another cell is one of the most common activities in Excel. But there’s a lot you might copy (formatting, value, formula, comments, etc) and sometimes you won’t want to copy all of it. The most common example of this is where you want to lose the formatting – the place this data is going is your own spreadsheet with your own styling.

4. Add Multiple Rows

Utility: 87
Difficulty: 0
Learn in 10 mins

Probably one of the most frequently carried out activities in spreadsheeting. Ctrl Shift + is the shortcut, but actually it takes longer, so Right Click is what we recommend. And if you want to add more than one, select as many rows or columns as you’d like to add and then Right Click and add.

5. Absolute References

Utility: 85
Difficulty: 2
Learn in 15 mins

Indispensable! The dollar in front of the letter fixes the column, the dollar sign in front of number fixes the row F4 toggles through the four possible combinations.

6. Print Optimisation

Utility: 84
Difficulty: 3
Learn in 120 mins

Everyone has problems printing from Excel. But just imagine if what you printed were always just what you intended to print. It IS actually possible. There are a few components to this though: print preview, fit to one page, adjusting margins, print selection, printing headers, portrait vs landscape and spreadsheet design. Invest the time to get comfortable with it. You’ll be carrying out this task many, many times in your working life.

7. Extend formula across/down

Utility: 84
Difficulty: 1
Learn in 5 mins

The beauty of Excel is its easy scalability. Get the formula right once and Excel will churn out the right calculation a million times. The + cross hair is handy. Double clicking it will take it all the way down if you have continuous data. Sometimes a copy and paste (either regular paste or paste formulas) will be faster for you.

8. Flash Fill

Utility: 84
Difficulty: 2
Learn in 30 mins

Excel developed a mind of its own in 2013. Say you have two columns of names and you need to construct email addresses from them all. Just do it for the first row and Excel will work out what you mean and do it for the rest. Pre-2013 this was possible but relied on a combination of functions (FIND, LEFT, &, etc). This is much faster and WILL impress people.

 9. INDEX-MATCH

Utility: 82
Difficulty: 4
Learn in 45 mins

This is one of the most powerful combinations of Excel functions. You can use it to look up a value in a big table of data and return a corresponding value in that table. Let’s say your company has 10,000 employees and there’s a spreadsheet with all of them in it with lots of information about them like salary, start date, line manager etc. But you have a team of 20 and you’re only really interested in them. INDEX-MATCH will look up the value of your team members (these need to be unique like email or employee number) in that table and return the desired information for your team. This is worth getting your head around this as it is more flexible and therefore more powerful than VLOOKUPs.

10. Filters

Utility: 81
Difficulty: 2
Learn in 60 mins

Explore data in a table quickly. Filtering effectively hides data that is not of interest. Usually there’s a value e.g. ‘Blue cars’ that you’re looking for and Filters will bring up those and hide the rest. But in more modern versions of Excel, you can now also filter on number values (e.g. is greater than, top 10%, etc), and cell color. Filtering becomes more powerful when you need to filter more than one column in combination e.g. both colors and vehicles to find your blue car.

Source: http://www.businessinsider.com/excel-tips-and-tricks-2017-11

8 Free Excel Add-Ins to Make Visually Pleasing Spreadsheets

Microsoft Excel has an array of useful features for creating powerful spreadsheets with charts and tables. But, when you want to take your spreadsheet to the next level, beyond fancy text or themes, you may need the help of an add-in.

With these handy tools, you can create more visually stimulating representations of your data. For printing, presenting, or providing a better view of your spreadsheets and what they contain, check out these awesome Excel add-ins.

1. Excel Colorizer

For an easy way to add color to your spreadsheet data, the Excel Colorizer add-in works great. To make your data simpler to read, just pick the colors and pattern and let the add-in do the rest of the work.

You can choose a type from uniform, horizontal, vertical, or matrix and pick your four colors. Then, adjust the interpolation to smooth or linear and the color space to RGB or HSV. You can also pick the pattern from interlaced or waves. So, select your data, make it look amazing, and hit Colorize! to finish.

2. Radial Bar Chart

While Microsoft Excel offers many chart options, Radial Bar Chart gives you one more. This add-in follows its name in providing exactly what it says: a radial bar chart. Access the add-in, select the cells containing your data, and then adjust the chart as you like.

You can pick the labels, numbers, and set a title. Hit Save and your chart will be created automatically. Move or resize your chart and run your mouse over the bars to display the data for each. The add-in is quick, simple, and gives you another chart style option for your data.

3. HierView

For displaying an organizational chart, HierView is the add-in for you. Your data should include a row identifier with the information included across the columns. Then, configure your data with filtering, automatic refreshing, column names, and data per node.

Once your chart is complete, you can zoom in or out, move in all four directions, or fit the chart to the plotted area. You can also move the entire chart or resize it if needed. Adjust the settings or get help at any time with the convenient buttons at the top of the chart.

4. Bubbles

Would your data look better in a bubble? If so, then Bubbles is the add-in you should try. This interactive bubble chart tool lets you display information in a unique way. Just open the add-in and select your table of data. When the chart is created, you can move the bubbles around while presenting or leave them as they are.

8 Types of Excel Charts & When You Should Use Them

Bubbles has a few settings you can adjust for basic or detailed mode, color range, and the title and column displays. You can also use the keyboard shortcuts shown at the bottom of the chart for things like hiding or showing more information or bouncing the bubbles about.Graphics are easier to grasp than text and numbers. Charts are a great way to visualize numbers. We show you how to create charts in Microsoft Excel and when to best use what kind.

5. Bing Maps

If adding a map to your spreadsheet is useful, the Bing Maps add-in makes it simple. Your data can include addresses, cities, states, zip codes, or countries as well as longitude and latitude. Just open the add-in, select your data cells, and click the Location button on the map.

The Bing Maps tool is ideal for displaying numeric data related to locations. So, if you work in sales, you can show new markets to cover or if you work for a company with multiple locations, you can present those facilities to clients clearly.

6. Geographic Heat Map

When a heat map is what you really need, the Geographic Heat Map add-in is terrific. From the same developer as the Radial Bar Chart add-in, you have similar settings. Select your data, choose a U.S. or world map, pick your column headings, and add a title.

You can reselect the data set if you add more columns or rows and if you change a value already in the set, you will see the heat map update automatically. For a fast glance at data related to countries, states, or regions, you can pop this heat map into your spreadsheet easily.

7. Pickit Free Images

For adding photos and other images to your spreadsheets, Pickit Free Images is the perfect tool. Once you access the add-in, you have a few options for finding the image you need. You can do a keyword search, browse through collections, or pick a category from a huge selection.

Click a spot to put it in your spreadsheet, select the image you want, and hit the Insert button. You can move, resize, or crop images as needed. And, if you create a free Pickit account, you can mark favorites to reuse and follow fellow users or categories to stay up-to-date on new uploads.

8. Web Video Player

Maybe your company has videos on YouTube or tutorials on Vimeo that would be beneficial to your workbook. With the Web Video Player add-in, you can pop a video from either of these sources right into your spreadsheet.

Open the add-in and then either enter the URL of the video or click to visit YouTube or Vimeo to obtain the link. Hit the Set Video button and you are done. Then, when you open the spreadsheet, the video is there and ready for you to click the Play button.

For a one-time $5 fee, you can set your videos to play automatically or start and end at specific spots in the clip. This option is included within the add-in.

Find, Install, and Use Add-Ins

You can access the add-ins store easily from within Excel. Open a workbook, select the Insert tab, and click Store. When the Office Add-Ins Store opens, browse by category or search for a specific add-in. You can also visit the Microsoft AppsSource site on the web and browse or search there.

15 Excel Add-Ins to Save Time on Your Business TasksDid you know Microsoft Office, including Excel and Word, supports add-ins? Excel add-ins can help you get through your tasks quicker because you never have to leave your Excel workbook.READ MORE

When you find the add-in you want, you can select it for further details or simply install it. However, it is wise to view the description first to check the terms and conditions, privacy statements, and system requirements.

Source: http://www.makeuseof.com/tag/free-excel-add-ins-visual-spreadsheets/

Web Statistics