Extrapolation of the Growing for Broke Case (HBS Publishing) Should Paragon Acquire MonitoRobotics? ASSIGNMENT: the deliverable...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Extrapolation of the Growing for Broke Case (HBS Publishing) Should Paragon Acquire MonitoRobotics? ASSIGNMENT: the deliverable is a series of three spreadsheets (3) and an explanation (justification) of your assumptions in each. The spreadsheets will show 5-year EPS projections for • Paragon if they don't merge • MonitoRobitics (MR) if they don't merge • Paragon if it acquires MR Based on your analysis, explain whether you would make the acquisition. Expect to be required to defend your analysis individually and orally in class in about a 5 minute session. Using the data below and any observations you think would warrant a change in gross or operating margins, construct a spreadsheet that projects the income statement for five years for both companies assuming they do not merge, and one spreadsheet showing the merger. As a small company scales-up, expansion of gross margin is expected and SGA as a percent of sales normally decreases. Notice these trends in MR's income statement. Determine a purchase price for MonitoRobotics (MR) based on data given, and show how you would pay for it. You MUST, use debt and equity but not cash shown on the balance sheet for the purchase. To the extent you use equity, be sure to show how the issue of incremental shares will impact earnings per share. Likewise, if you use debt, be sure to show the impact of debt (additional interest) on the projected income statement. You will want to turn in the spreadsheets and an explanation of whether you would pursue the acquisition further. You will need to build in assumptions (about growth rates of revenues, purchase price, margins, etc.). Be sure to state them explicitly AND THE RATIONALE behind them. In many ways, the most critical aspect of modeling is being able to support your assumptions. Note: In year C-1, (current year minus one year) Paragon closed an acquisition of Dover Machine Tools to expand their product line, thus accounting for the significant increase in revenues and related expenses over year C-2. "Current" year means the year just completed. PARAGON'S INCOME STATEMENT (MILLIONS) YEAR Sales COGS Gross Profit GSA Op. Income (EBIT) Interest expense Taxes Net Income Current 624 430 194 120 74 40 10 24 C-1 580 405 175 116 59 40 13 6 C-2 480 348 132 101 82 15 4 PARAGONS BALANCE SHEET (MILLIONS) Inventory A/R Other Current assets total current assets Plant property & Equipment Total Assets Total current liabilities Long term liabilities Total Liabilities 150 120 42 312 420 510 Stockholders Equity 222 OP. CASH FLOW net of CAPEX 18 YEAR Sales COGS Gross Profit GSA 732 250 260 Operating Income Interest Taxes NI MONITOROBOTICS: INCOME STATEMENT (Millions USD) Current Current -1 42 22 20 12 8 ON 155 135 48 338 400 6 738 240 244 484 254 20 18 10 8 7 1 0 DOH 1 110 91 39 240 250 490 160 100 260 230 10 Current -2 6 4 2 5 (3) 0 (3) BALANCE SHEET HIGHLIGHTS (Millions USD) Inventory A/R Other Current assets total current assets Plant property & Equipment Total Assets Total current liabilities Long term liabilities Total Liabilities Stockholders Equity MonitoRobotics (MR) Operating Cash Flow 6 5 3 14 3 17 4 0 4 13 1 2 NON NONO 2 5 9 2 11 2 0 2 9 (3) 1 1 7 9 1 10 1 0 1 9 (5) Experts Comments: The Investment banker thinks that MR will probably sell for about 2.5X "current" year's sales, but this number could be as high as 3.5 X sales because another company is interested. Paragon could borrow funds at 8% for the purchase. Paragon currently has 40 million shares outstanding, and their stock is trading at $6 per share. The shares have ranged between $5.25 and $7.75 over the past 6 months. Analysts are impressed with MRs revenue growth and with the fact that they have broken even on an operating cash flow basis. However, there is something of a divided view about where the revenue growth of the industry will go from here. The range of annualized growth for MR industry over the next 5 years ranges from 10 to 20%. The engineers of Paragon and MR held a week off-site to develop a realistic sense of costs and timetable to integrate MRs Software with Paragon's software. They estimate that it would cost $5 million of research and development and 12 months to bring a product to market. Interest charges at Paragon run $40m/yr. The loan does not amortize, so the interest charge remains constant for the next 5 years unless Paragon buys MR. For taxes, use 30% of net income before taxes. Assume any differences in the tax rate in prior years result from tax loss carryforwards. After conducting a market research study with a consultant, Paragon believed that without a merger, they should expect to grow revenues at the industry-wide growth rate of about 2% / year. After the development year, the merger would increase sales of Paragon's products by about 3% above any growth expected in the absence of a merger. The gross margin would remain at about the current levels. However, launching the software services division would require a budget of $4 million per year of additional GS&A. The study also predicted that the MR software business would grow by an incremental (above what it would grow without the merger) 5% per year if it was purchased by Paragon. Gross margin and operating margin should both improve at MR as it achieves economies of scale. Helpful EXCEL Hints: Merged sales = (unmerged P+*1.03) + (umerged MR*1.05) Be sure to capture Unmerged sales cells by formula from the respective spreadsheets. Merged COGS = (merged salesPara * COGS % : PARA) + (merged salesMR* COGS%:MR) Merged SGA = (merged salesPara * SGA%: PARA) + (merged salesMR * SGA%:MR) Note that all EXPENSE ITEMS above are derived as a percent of THAT YEAR's sales.... NOT by some growth rate applied to last year's numbers. This will help you avoid some serious math errors. Extrapolation of the Growing for Broke Case (HBS Publishing) Should Paragon Acquire MonitoRobotics? ASSIGNMENT: the deliverable is a series of three spreadsheets (3) and an explanation (justification) of your assumptions in each. The spreadsheets will show 5-year EPS projections for • Paragon if they don't merge • MonitoRobitics (MR) if they don't merge • Paragon if it acquires MR Based on your analysis, explain whether you would make the acquisition. Expect to be required to defend your analysis individually and orally in class in about a 5 minute session. Using the data below and any observations you think would warrant a change in gross or operating margins, construct a spreadsheet that projects the income statement for five years for both companies assuming they do not merge, and one spreadsheet showing the merger. As a small company scales-up, expansion of gross margin is expected and SGA as a percent of sales normally decreases. Notice these trends in MR's income statement. Determine a purchase price for MonitoRobotics (MR) based on data given, and show how you would pay for it. You MUST, use debt and equity but not cash shown on the balance sheet for the purchase. To the extent you use equity, be sure to show how the issue of incremental shares will impact earnings per share. Likewise, if you use debt, be sure to show the impact of debt (additional interest) on the projected income statement. You will want to turn in the spreadsheets and an explanation of whether you would pursue the acquisition further. You will need to build in assumptions (about growth rates of revenues, purchase price, margins, etc.). Be sure to state them explicitly AND THE RATIONALE behind them. In many ways, the most critical aspect of modeling is being able to support your assumptions. Note: In year C-1, (current year minus one year) Paragon closed an acquisition of Dover Machine Tools to expand their product line, thus accounting for the significant increase in revenues and related expenses over year C-2. "Current" year means the year just completed. PARAGON'S INCOME STATEMENT (MILLIONS) YEAR Sales COGS Gross Profit GSA Op. Income (EBIT) Interest expense Taxes Net Income Current 624 430 194 120 74 40 10 24 C-1 580 405 175 116 59 40 13 6 C-2 480 348 132 101 82 15 4 PARAGONS BALANCE SHEET (MILLIONS) Inventory A/R Other Current assets total current assets Plant property & Equipment Total Assets Total current liabilities Long term liabilities Total Liabilities 150 120 42 312 420 510 Stockholders Equity 222 OP. CASH FLOW net of CAPEX 18 YEAR Sales COGS Gross Profit GSA 732 250 260 Operating Income Interest Taxes NI MONITOROBOTICS: INCOME STATEMENT (Millions USD) Current Current -1 42 22 20 12 8 ON 155 135 48 338 400 6 738 240 244 484 254 20 18 10 8 7 1 0 DOH 1 110 91 39 240 250 490 160 100 260 230 10 Current -2 6 4 2 5 (3) 0 (3) BALANCE SHEET HIGHLIGHTS (Millions USD) Inventory A/R Other Current assets total current assets Plant property & Equipment Total Assets Total current liabilities Long term liabilities Total Liabilities Stockholders Equity MonitoRobotics (MR) Operating Cash Flow 6 5 3 14 3 17 4 0 4 13 1 2 NON NONO 2 5 9 2 11 2 0 2 9 (3) 1 1 7 9 1 10 1 0 1 9 (5) Experts Comments: The Investment banker thinks that MR will probably sell for about 2.5X "current" year's sales, but this number could be as high as 3.5 X sales because another company is interested. Paragon could borrow funds at 8% for the purchase. Paragon currently has 40 million shares outstanding, and their stock is trading at $6 per share. The shares have ranged between $5.25 and $7.75 over the past 6 months. Analysts are impressed with MRs revenue growth and with the fact that they have broken even on an operating cash flow basis. However, there is something of a divided view about where the revenue growth of the industry will go from here. The range of annualized growth for MR industry over the next 5 years ranges from 10 to 20%. The engineers of Paragon and MR held a week off-site to develop a realistic sense of costs and timetable to integrate MRs Software with Paragon's software. They estimate that it would cost $5 million of research and development and 12 months to bring a product to market. Interest charges at Paragon run $40m/yr. The loan does not amortize, so the interest charge remains constant for the next 5 years unless Paragon buys MR. For taxes, use 30% of net income before taxes. Assume any differences in the tax rate in prior years result from tax loss carryforwards. After conducting a market research study with a consultant, Paragon believed that without a merger, they should expect to grow revenues at the industry-wide growth rate of about 2% / year. After the development year, the merger would increase sales of Paragon's products by about 3% above any growth expected in the absence of a merger. The gross margin would remain at about the current levels. However, launching the software services division would require a budget of $4 million per year of additional GS&A. The study also predicted that the MR software business would grow by an incremental (above what it would grow without the merger) 5% per year if it was purchased by Paragon. Gross margin and operating margin should both improve at MR as it achieves economies of scale. Helpful EXCEL Hints: Merged sales = (unmerged P+*1.03) + (umerged MR*1.05) Be sure to capture Unmerged sales cells by formula from the respective spreadsheets. Merged COGS = (merged salesPara * COGS % : PARA) + (merged salesMR* COGS%:MR) Merged SGA = (merged salesPara * SGA%: PARA) + (merged salesMR * SGA%:MR) Note that all EXPENSE ITEMS above are derived as a percent of THAT YEAR's sales.... NOT by some growth rate applied to last year's numbers. This will help you avoid some serious math errors. Extrapolation of the Growing for Broke Case (HBS Publishing) Should Paragon Acquire MonitoRobotics? ASSIGNMENT: the deliverable is a series of three spreadsheets (3) and an explanation (justification) of your assumptions in each. The spreadsheets will show 5-year EPS projections for • Paragon if they don't merge • MonitoRobitics (MR) if they don't merge • Paragon if it acquires MR Based on your analysis, explain whether you would make the acquisition. Expect to be required to defend your analysis individually and orally in class in about a 5 minute session. Using the data below and any observations you think would warrant a change in gross or operating margins, construct a spreadsheet that projects the income statement for five years for both companies assuming they do not merge, and one spreadsheet showing the merger. As a small company scales-up, expansion of gross margin is expected and SGA as a percent of sales normally decreases. Notice these trends in MR's income statement. Determine a purchase price for MonitoRobotics (MR) based on data given, and show how you would pay for it. You MUST, use debt and equity but not cash shown on the balance sheet for the purchase. To the extent you use equity, be sure to show how the issue of incremental shares will impact earnings per share. Likewise, if you use debt, be sure to show the impact of debt (additional interest) on the projected income statement. You will want to turn in the spreadsheets and an explanation of whether you would pursue the acquisition further. You will need to build in assumptions (about growth rates of revenues, purchase price, margins, etc.). Be sure to state them explicitly AND THE RATIONALE behind them. In many ways, the most critical aspect of modeling is being able to support your assumptions. Note: In year C-1, (current year minus one year) Paragon closed an acquisition of Dover Machine Tools to expand their product line, thus accounting for the significant increase in revenues and related expenses over year C-2. "Current" year means the year just completed. PARAGON'S INCOME STATEMENT (MILLIONS) YEAR Sales COGS Gross Profit GSA Op. Income (EBIT) Interest expense Taxes Net Income Current 624 430 194 120 74 40 10 24 C-1 580 405 175 116 59 40 13 6 C-2 480 348 132 101 82 15 4 PARAGONS BALANCE SHEET (MILLIONS) Inventory A/R Other Current assets total current assets Plant property & Equipment Total Assets Total current liabilities Long term liabilities Total Liabilities 150 120 42 312 420 510 Stockholders Equity 222 OP. CASH FLOW net of CAPEX 18 YEAR Sales COGS Gross Profit GSA 732 250 260 Operating Income Interest Taxes NI MONITOROBOTICS: INCOME STATEMENT (Millions USD) Current Current -1 42 22 20 12 8 ON 155 135 48 338 400 6 738 240 244 484 254 20 18 10 8 7 1 0 DOH 1 110 91 39 240 250 490 160 100 260 230 10 Current -2 6 4 2 5 (3) 0 (3) BALANCE SHEET HIGHLIGHTS (Millions USD) Inventory A/R Other Current assets total current assets Plant property & Equipment Total Assets Total current liabilities Long term liabilities Total Liabilities Stockholders Equity MonitoRobotics (MR) Operating Cash Flow 6 5 3 14 3 17 4 0 4 13 1 2 NON NONO 2 5 9 2 11 2 0 2 9 (3) 1 1 7 9 1 10 1 0 1 9 (5) Experts Comments: The Investment banker thinks that MR will probably sell for about 2.5X "current" year's sales, but this number could be as high as 3.5 X sales because another company is interested. Paragon could borrow funds at 8% for the purchase. Paragon currently has 40 million shares outstanding, and their stock is trading at $6 per share. The shares have ranged between $5.25 and $7.75 over the past 6 months. Analysts are impressed with MRs revenue growth and with the fact that they have broken even on an operating cash flow basis. However, there is something of a divided view about where the revenue growth of the industry will go from here. The range of annualized growth for MR industry over the next 5 years ranges from 10 to 20%. The engineers of Paragon and MR held a week off-site to develop a realistic sense of costs and timetable to integrate MRs Software with Paragon's software. They estimate that it would cost $5 million of research and development and 12 months to bring a product to market. Interest charges at Paragon run $40m/yr. The loan does not amortize, so the interest charge remains constant for the next 5 years unless Paragon buys MR. For taxes, use 30% of net income before taxes. Assume any differences in the tax rate in prior years result from tax loss carryforwards. After conducting a market research study with a consultant, Paragon believed that without a merger, they should expect to grow revenues at the industry-wide growth rate of about 2% / year. After the development year, the merger would increase sales of Paragon's products by about 3% above any growth expected in the absence of a merger. The gross margin would remain at about the current levels. However, launching the software services division would require a budget of $4 million per year of additional GS&A. The study also predicted that the MR software business would grow by an incremental (above what it would grow without the merger) 5% per year if it was purchased by Paragon. Gross margin and operating margin should both improve at MR as it achieves economies of scale. Helpful EXCEL Hints: Merged sales = (unmerged P+*1.03) + (umerged MR*1.05) Be sure to capture Unmerged sales cells by formula from the respective spreadsheets. Merged COGS = (merged salesPara * COGS % : PARA) + (merged salesMR* COGS%:MR) Merged SGA = (merged salesPara * SGA%: PARA) + (merged salesMR * SGA%:MR) Note that all EXPENSE ITEMS above are derived as a percent of THAT YEAR's sales.... NOT by some growth rate applied to last year's numbers. This will help you avoid some serious math errors. Extrapolation of the Growing for Broke Case (HBS Publishing) Should Paragon Acquire MonitoRobotics? ASSIGNMENT: the deliverable is a series of three spreadsheets (3) and an explanation (justification) of your assumptions in each. The spreadsheets will show 5-year EPS projections for • Paragon if they don't merge • MonitoRobitics (MR) if they don't merge • Paragon if it acquires MR Based on your analysis, explain whether you would make the acquisition. Expect to be required to defend your analysis individually and orally in class in about a 5 minute session. Using the data below and any observations you think would warrant a change in gross or operating margins, construct a spreadsheet that projects the income statement for five years for both companies assuming they do not merge, and one spreadsheet showing the merger. As a small company scales-up, expansion of gross margin is expected and SGA as a percent of sales normally decreases. Notice these trends in MR's income statement. Determine a purchase price for MonitoRobotics (MR) based on data given, and show how you would pay for it. You MUST, use debt and equity but not cash shown on the balance sheet for the purchase. To the extent you use equity, be sure to show how the issue of incremental shares will impact earnings per share. Likewise, if you use debt, be sure to show the impact of debt (additional interest) on the projected income statement. You will want to turn in the spreadsheets and an explanation of whether you would pursue the acquisition further. You will need to build in assumptions (about growth rates of revenues, purchase price, margins, etc.). Be sure to state them explicitly AND THE RATIONALE behind them. In many ways, the most critical aspect of modeling is being able to support your assumptions. Note: In year C-1, (current year minus one year) Paragon closed an acquisition of Dover Machine Tools to expand their product line, thus accounting for the significant increase in revenues and related expenses over year C-2. "Current" year means the year just completed. PARAGON'S INCOME STATEMENT (MILLIONS) YEAR Sales COGS Gross Profit GSA Op. Income (EBIT) Interest expense Taxes Net Income Current 624 430 194 120 74 40 10 24 C-1 580 405 175 116 59 40 13 6 C-2 480 348 132 101 82 15 4 PARAGONS BALANCE SHEET (MILLIONS) Inventory A/R Other Current assets total current assets Plant property & Equipment Total Assets Total current liabilities Long term liabilities Total Liabilities 150 120 42 312 420 510 Stockholders Equity 222 OP. CASH FLOW net of CAPEX 18 YEAR Sales COGS Gross Profit GSA 732 250 260 Operating Income Interest Taxes NI MONITOROBOTICS: INCOME STATEMENT (Millions USD) Current Current -1 42 22 20 12 8 ON 155 135 48 338 400 6 738 240 244 484 254 20 18 10 8 7 1 0 DOH 1 110 91 39 240 250 490 160 100 260 230 10 Current -2 6 4 2 5 (3) 0 (3) BALANCE SHEET HIGHLIGHTS (Millions USD) Inventory A/R Other Current assets total current assets Plant property & Equipment Total Assets Total current liabilities Long term liabilities Total Liabilities Stockholders Equity MonitoRobotics (MR) Operating Cash Flow 6 5 3 14 3 17 4 0 4 13 1 2 NON NONO 2 5 9 2 11 2 0 2 9 (3) 1 1 7 9 1 10 1 0 1 9 (5) Experts Comments: The Investment banker thinks that MR will probably sell for about 2.5X "current" year's sales, but this number could be as high as 3.5 X sales because another company is interested. Paragon could borrow funds at 8% for the purchase. Paragon currently has 40 million shares outstanding, and their stock is trading at $6 per share. The shares have ranged between $5.25 and $7.75 over the past 6 months. Analysts are impressed with MRs revenue growth and with the fact that they have broken even on an operating cash flow basis. However, there is something of a divided view about where the revenue growth of the industry will go from here. The range of annualized growth for MR industry over the next 5 years ranges from 10 to 20%. The engineers of Paragon and MR held a week off-site to develop a realistic sense of costs and timetable to integrate MRs Software with Paragon's software. They estimate that it would cost $5 million of research and development and 12 months to bring a product to market. Interest charges at Paragon run $40m/yr. The loan does not amortize, so the interest charge remains constant for the next 5 years unless Paragon buys MR. For taxes, use 30% of net income before taxes. Assume any differences in the tax rate in prior years result from tax loss carryforwards. After conducting a market research study with a consultant, Paragon believed that without a merger, they should expect to grow revenues at the industry-wide growth rate of about 2% / year. After the development year, the merger would increase sales of Paragon's products by about 3% above any growth expected in the absence of a merger. The gross margin would remain at about the current levels. However, launching the software services division would require a budget of $4 million per year of additional GS&A. The study also predicted that the MR software business would grow by an incremental (above what it would grow without the merger) 5% per year if it was purchased by Paragon. Gross margin and operating margin should both improve at MR as it achieves economies of scale. Helpful EXCEL Hints: Merged sales = (unmerged P+*1.03) + (umerged MR*1.05) Be sure to capture Unmerged sales cells by formula from the respective spreadsheets. Merged COGS = (merged salesPara * COGS % : PARA) + (merged salesMR* COGS%:MR) Merged SGA = (merged salesPara * SGA%: PARA) + (merged salesMR * SGA%:MR) Note that all EXPENSE ITEMS above are derived as a percent of THAT YEAR's sales.... NOT by some growth rate applied to last year's numbers. This will help you avoid some serious math errors.
Expert Answer:
Answer rating: 100% (QA)
To answer the question of whether Paragon should acquire MonitoRobotics MR we will need to project the income statements for both companies for the next five years assuming they do and do not merge We ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
In two to three pages, explain whether you would prefer to work alone or as part of a team.
-
Explain whether you would expect KBr or CH3Br to have the higher melting point.
-
Explain whether you would recognise each item below as an asset, justifying your answer by reference to the Conceptual Frameworks asset definition and recognition criteria: (a) A trinket of...
-
A particular automatic sprinkler system has two different types of activation devices for each sprinkler head. One type has a reliability of 0.9; that is, the probability that it will activate the...
-
Determine the critical value(s) for a one-mean z-test at the 1% significance level if the test is a. Right tailed. b. Left tailed. c. Two tailed.
-
Texmart is a locally owned big-box retail store chain in Texas with 75 stores, primarily located in the DallasFort Worth area. In order to compete with national big-box store chains, Texmart is...
-
What are the primary components of an insurance policy?
-
Kiel Centers sales are all made on account. The firms collection experience has been that 35% of a months sales are collected in the month the sale is made, 55% are collected in the month following...
-
Selected information from the Iowa Instruments accounting records for April follows: Materials Inventory Debit Credit BB ( 4 / 1 ) 2 7 , 0 0 0 2 1 1 , 0 0 0 1 7 6 , 0 0 0 Work - in - Process...
-
A village has six residents, each of whom has accumulated savings of $100. Each villager can use this money either to buy a government bond that pays 15 percent interest per year or to buy a year-old...
-
Which behind the scenes image shows what happens when you write a check on March 1 to purchase a service that will be consumed over six months? A. Insurance Expense Prepaid Insurance March 1, 20XX...
-
Define and give an example of each of the following: a. appropriation b. unreasonable intrusion c. public disclosure of private facts d. false light
-
True Or False Punitive damages may be awarded in matters of private concern with only a showing of negligence.
-
A privilege can be lost if it is ____________.
-
True Or False A statement that is substantially true, even if it is not true in all respects, is considered a true statement.
-
True Or False A statement can be defamatory if spoken only to the plaintiff.
-
2. (15 points) In the episode, The One with the Tea Leaves, Chandler moves in with Monica, Monica finds out Chandler has two identical copies of the 1982 hit Broadway musical, Annie. Chandler loves...
-
A handrail, which weighs 120 N and is 1.8 m long. was mounted to a wall adjacent to a small set of steps (Figure P4.26). The support at A has broken, and the rail has fallen about the loose bolt at 8...
-
An article on barrons.com observed that the U.S. dollar has been droppingand thats good news for the stock market and companies that get a large chunk of their sales from overseas. a. What does the...
-
In May 2023, the Bureau of Economic Analysis (BEA) issued a revised estimate of the change in real GDP during the first quarter of 2023. The BEAs news release describing the revisions noted that the...
-
During the second quarter of 2020, real inventories declined by $274 billion, by far the largest decline on record. During the third quarter of 2020, real GDP increased by 35 percent, by far the...
Study smarter with the SolutionInn App