Business valuation | Accounting homework help

 
   

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadlines.


  Order a Similar Paper    Order a Different Paper  

 In 2001, John and Mary Drake founded the Baltimore Resins Corporation (BRC). Their business was finding waste products and plastics manufacturing that had been simply discarded, and finding ways to harvest this material and actually sell it for profit to possible manufacturing groups that could use this material. At the time, a big company (Waste Management) was actually charging customers to pick up and discard what was once considered waste. BRC was an innovator; it began to get these “waste” items for re-cycling and new uses by paying creators of this “waste” a penny a pound. Staff was hired, and the business grew. In March of 2013, John and Mary were divorced. The court specified a division of assets.

Subsequently, several years later, Mary Drake brought suit against the attorney that had represented her in the divorce proceedings. Her claim was that that attorney had not commissioned a business valuation, and therefore the proper value of the company wasn’t established, and hence the cash consideration associated with the judge’s decree was inappropriate or lacking in full factual basis.

In this legal malpractice suit, Mary Drake, the plaintiff, commissioned a financial economist to place a value on the company around the time of the divorce decree. However, several facts make this choice of date less than straightforward.

First, the husband John Drake, had apparently for several years been planning to found a new company (called Towson Resins Corporation) to which he migrated several of the clients of Baltimore Resins Corporation. In other words there was some pilferage of Baltimore Resin’s business. Second, in addition despite vigorous efforts at what lawyers call discovery, the last set of financial documents for Baltimore Resins Corporation that is available to the financial economist are as of the close of calendar year 2011. In addition, the only balance sheet available was 2010 (note I may be able to add 2011). No doubt, you will find industry analyses such as IBIS WORLD that offer much more recent data. The assignment from the client is to value the company as of the divorce date. Part of your job is to decide whether or not to use recent data, or to act as if you only have data for 2011-2013. Be sure to explain your choice.

In a separate document you are provided with several years of financial data such as P & L Statements, and tax data compiled from subchapter S corporation returns (Form 1120S) for Baltimore Resins Corporation. It’s very common for tax return data and P&L data to differ, and the analyst has to attempt to ask the client about that, or study the line items for clues. In your assignment, please describe your choice.

You are also provided with data for several SIC codes obtained from Business Valuation Resources Dealstats database. You are also provided with several background articles on the industry. Some of these are random data dumps, and are best disregarded.  Others DO seem relevant, in terms of DCF or valuation multiples, on which you will rely in valuing the business. In real-world valuation engagements, picking good sources, and eschewing bad ones, is a big part of the job.

THE OVERALL TASK SUMMARY: Imagine that I am the attorney who is bringing forth the malpractice suit, and I “engage (hire you)” you to do a complete formal business valuation of Baltimore Resins Company, as of (or close to, since 2013 financial statements are not available). 

Here are the questions (think of this as a way to choose topics to address and organize in  your full report):

1) Describe, as best you can, each of the ATTACHMENTS below (mostly Business Valuation Resources Dealstats data sheets) that you actually used in formulating your opinion (a phrase used in litigation).  State what you think each exhibit might be, and how each one might be used by an analyst….it’s part of the digging process as one prepares to do a valuation. The format of each exhibit is what I got from DEALSTATS, as I entered queries….some search queries were casual attempts,  just to see what the transactions looked like. Some, I used in my valuation report. You must decide which ones are useful and usable and relevant.

2) Giving considerable detail, propose which multiples and metrics from the Dealstats downloaded data sheets you feel would be valuable or appropriate in placing a value on Baltimore Resins Corporation as of the end of 2011. To be more specific: View the exhibit titled MAIN DATA-BALTIMORE RESINS CASE-EXHIBITS A-F. Look at B,C,D,E AND F. Each one is a download of BVR’s DEEALSTATS reported transactions. But on each one, I specified slightly different search criteria, such as SIC code or sales level, etc (read the heading very carefully to see what I did). Your task is to glean from this mass of data what you feel are appropriate valuation multiples/metrics to actually apply. For example, for one of the group of metrics that you apply, you might choose the average of MVIC/NET SALES from Exhibit B and Exhibit C. Try to justify your choices. When you look at Exhibit F, you might choose specific transactions that have the word resins or plastics within. Your pdf “app” may have scanning ability-for example Adobe Acrobat can scan for words within a pdf document.

Note-One non-standard term used in DEALSTATS is SDE “Seller’s discretionary income.” That is defined as EBITDA +owner’s salary and perks (perquisites such as car, food, salaries for the owner’s children).

3) Using the background articles provided (last six files), write between two and three typed pages about the industry in which Baltimore Resins Corporation operates. Consider both microeconomic and macroeconomic trends. Consider industry-specific information that you glean from the documents.  You may also find the following three websites relevant. They contain industry definitions and the industry’s outlook.

https://www.plasticsindustry.org/

https://www.isri.org/

https://wasterecycling.org/

4) Now proceed to a final write-up to turn in to Sakai, which includes lengthy and complete descriptions of what you did in every single one of the steps above, and then at the end, present a shorter section that summarizes all the steps taken above. This will lead to and support your formal estimate of the value of Baltimore Resins Corporation. Your write-up should have a well-formatted reference list and include whatever exhibits you choose to create and to provide.

Examples of a full valuation report of this nature appear in the Trugman text, and I have also posted some in LESSONS.

This is how it would be in a real consulting context. A client would concentrate on your report, even if you made a presentation, or shared calculations.

In conducting this work, you will employ various documents that are posted. In this assignment, you do not have to gather additional outside industry information (you may be asked to do that on other cases). It is sufficient to process and summarize, in your own words, a subset of the information in the articles and sources that I provided above. In summary, you will submit THREE DELIVERABLES:

1-WORD or pdf document describing everything about your research and your calculations that lead to a statement of the business’s value. Format this in any way you think adds to the reader’s comprehension, I am agnostic with respect to formatting. TURNITIN will check for plagiarism. 

2-EXCEL document showing valuation calculations

3-PPT document which is your “presentation.” This does not need to have video of the team doing the talking, but it does have to include audio.  PPT lets you record your voice, but there are many equivalent routes. 

CH 10   TRUGMAN TEXTBOOK refers to PRATT’s STATS—a private transactions database (now named DEALSTATS)

A big part of your job is to choose which list of “comps” to use.

 I attach a rough valuation (VALUATION SPREADSHEET-2018 Goodwill article) workbook that I wrote, and I adapt all sorts of changes to it for specific situations. You should probably do a lot of personal editing for this case (I use this one mainly for doing sensitivity analysis). 

I also attach a template that I think is good for working with DEALSTATS data (titled VALUATION METRICS AND WEIGHTS use with DEALSTATS). 

You are TOTALLY free to edit these spreadsheets to suit your data, your “opinion,” as they say in court proceedings. In fact, you can probably do better with your own custom EXCEL workbooks. I just wanted to give you tools if you wanted a good headstart.

This is a big assignment. This was a real-life consulting assignment. Part of your job, as students, is to parse through the masses of data, and boil this down to a usable product (i.e., your report, as if it were submitted to an attorney who engaged you).

Here are some responses to questions that have been asked by students:

1-You are not writing an engagement letter…that would be the job of the client who is “engaging you.” Unless perhaps you mean a letter that YOU write to the client, outlining what you plan to do.

2-You ARE most definitely doing a full evaluation of Balt Resins Co. When I used the word “summary” in the assignment, I simply meant that you do all the steps of a valuation of the company, and then, in addition, you summarize all your steps, which of course you have written in report format. This is like anything you write at MSB…you do the job, and then you summarize at the end.

3-You are doing a full valuation as of 2013, or as close to that as the data allows, because the legal issue is that when the divorce decree happened, the court did not have information on the value of Baltimore Resins Co. And thus, it is claimed (in real life), that the settlement decree promulgated an inappropriate, and possibly unfair,  asset split.