NEW YORK (TheStreet) -- Bank of America's (BAC - Get Report) Merrill Lynch last month reinstated its coverage of Tesla Motors (TSLA - Get Report) with a "neutral" rating and a target price of $33. Earlier this week, Morgan Stanley (MS - Get Report) raised its rating from "underweight" to "overweight" and increased its target price from $45 to $50.Both reports included a fundamental financial modeling error that overestimates Tesla's year-end cash position by roughly 200%. The error was simple. Both firms accounted for expected sales and expected new reservation payments during the second half of the year. Neither firm properly accounted for the fact that reservation payments and cash will decline by $40,000 for each Model S Signature Edition and $5,000 for each additional Model S Tesla deliveries this year. Merrill Lynch forecast 2012 Model S deliveries of 5,000 units. Reservation deposits for the first 2,000 Model S Signature editions were $40,000 each for a total of $80 million. Reservation deposits for the next 3,000 standard Model S versions were $5,000 each for a total of $15 million more. Overall, the total Merrill Lynch error was $95 million. Morgan Stanley was more conservative at 2,230 Model S deliveries. So its error was $81 million. As of June 30, Tesla reported $211 million in cash, $133 million in reservation payments, $31 million in working capital and $62 million in stockholders' equity. In its report, Merrill Lynch forecast a second-half loss of $129 million and year-end balance sheet values of $149 million in cash, $242 million in reservation payments, a working capital deficit of $86 million and a stockholders' equity deficit of $54 million. Similarly, Morgan Stanley forecast a second-half loss of $158 million and year-end balance sheet values of $132 million in cash, $169 million in reservation payments, a working capital deficit of $127 million and a stockholders' equity deficit of $74 million. Since June 30, I've been cautioning readers that Tesla's working capital would be eradicated by the end of July, its stockholders equity would be obliterated by the end of August, and its planned cash low point left little or no room for errors, delays or other uncertainties. I was surprised when two of the most highly regarded investment-banking firms in the country didn't share my reservations. Now I understand why and so do you. Their financial modeling was catastrophically wrong and Tesla's year-end cash balance is on track to come in at about a third of the estimates disseminated to their clients. Disclosure: I have no direct or indirect interest in Tesla, and I have nothing to gain or lose from its success or failure.
TheStreet’s Fundamentals of Investing Course will teach you the keys to making the right decisions in any market.
TheStreet’s Personal Finance Essentials Course will teach you money management basics and investing strategies to help you avoid major financial pitfalls.
TheStreet Courses offers dedicated classes designed to improve your investing skills, stock market knowledge and money management capabilities.
More from Investing
What Stocks and Sectors Investors Should Watch During the Second Half of 2019
Curious about stocks or sectors that investors should watch now that we're transitioning into the second half of 2019? Here's what Real Money contributor Stephen Guilfoyle thinks.
Facebook's Mark Zuckerberg Pushes Back on Antitrust Talk
In an interview, Zuckerberg argued that Facebook's size helps, not hinders, progress on security and other issues.
How Investors Should Approach the Trade Talks, the Federal Reserve and Micron
United States Secretary of the Treasury Steven Mnuchin made comments on the trade talks early Wednesday. Mnuchin says that he believes that the U.S. and China were almost 90% of the way through trade talks. Fed chair Jerome Powell spoke about the need for the central bank to remain independent and to not cave to "short-term political interests." And, of course, we have Micron MU, which is Real Money's stock of the day and it also released earnings Tuesday after the bell. The company beat expectations.
Using Technical Analysis: Cramer's 'Mad Money' Recap (Wednesday 6/26/19)
Jim Cramer explains the art and science of technical analysis.