Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are interested in purchasing the Value Group, a local business that has caught your eye. You would like to buy them as of January

image text in transcribedYou are interested in purchasing the Value Group, a local business that has caught your eye. You would like to buy them as of January 1, 2022. The company has provided you with their historical income statement and balance sheet which is included below and on Canvas. The companys CFO told you that they expect they can increase sales by 15% per year for the next four years (2022-2025) after which time sales will grow by 4% per year forever. You expect that after 2026, free cash flows will increase by 4% per year forever. The company will need to maintain property plant and equipment to sales of 24% in the future and depreciation will be constant at 210,000 per year. The companys net working capital to sales is expected to remain at 19.8% in the future. The companys COGS/Sales has been steady at 60% for years and you expect that to stay constant going forward. The companys SG&A / Sales ratio has been 20% per year and the company believes it will keep the same SG&A/Sales ratio going forward. You are interested in the company because you think you can run the company more efficiently. You believe you can increase sales growth to 25% per year for the next four years (2022-2025) after which time sales will grow by 4% per year forever (and after 2026, free cash flows will still increase by 4% per year forever). You also believe that some of the administrative functions can be improved which should lower your SG&A/Sales ratio from 20% in 2021 to 18.25% in 2022 and then to 17 % in 2023 and all years thereafter. You expect all other elements of your forecasts will be the same as for the Value Group. Quickenal and TMI Enterprises operate in the same industry as the Value Group. Your friends tell you to calculate the appropriate discount rate for Value Group by looking at these two companies. Value Group is 100% equity financed and would be 100% equity financed if you acquired them. Assume all cash flows come at the end of the year and the tax rate is 21%. You know you need to determine how much the Value Group is worth. You are particularly interested as to: (1) how much the Value Group is worth under its current leadership, (2) how much the Value Group is worth to you, and (3) how much do you think you should bid for the company?

Figure 1. Value Group Financials 2019 257 2020 335 2021 412 26 34 Selected Balance Sheet Items (in thousands) Net Working Capital NWC Includes Cash Inventory Accounts Receivable Accounts Payable 143 186 2019 1,300 25.0% 779 521 40.1% 108 20.7% 210 203 2020 1,690 30.0% 1,015 675 39.9% 137 20.3% 210 328 72 2021 2,080 23.1% 1,249 831 40.0% 168 20.2% 210 453 95 Income Statement (in thousands) Sales Sales Growth - Cost of Goods Sold = Gross Profit Gross margin - SG&A SG&A/Sales - Depreciation = Operating Profit - Taxes Tax Rate = Net Income Net Profit Margin 42 229 291 150 182 94 237 122 63 31.0% 140 22.0% 256 15.1% 21.0% 358 10.8% 17.2% Figure 2. Market Data Companies Comparable to Value Group Equity Beta Debt Beta Quickenal 1.42 0.16 TMI Enterprises 1.52 0.28 Equity Value Debt Value 500 100 600 200 More Market Data U.S. Government 30 year bond Market Risk Premium 1.85% 5.50% Figure 1. Value Group Financials 2019 257 2020 335 2021 412 26 34 Selected Balance Sheet Items (in thousands) Net Working Capital NWC Includes Cash Inventory Accounts Receivable Accounts Payable 143 186 2019 1,300 25.0% 779 521 40.1% 108 20.7% 210 203 2020 1,690 30.0% 1,015 675 39.9% 137 20.3% 210 328 72 2021 2,080 23.1% 1,249 831 40.0% 168 20.2% 210 453 95 Income Statement (in thousands) Sales Sales Growth - Cost of Goods Sold = Gross Profit Gross margin - SG&A SG&A/Sales - Depreciation = Operating Profit - Taxes Tax Rate = Net Income Net Profit Margin 42 229 291 150 182 94 237 122 63 31.0% 140 22.0% 256 15.1% 21.0% 358 10.8% 17.2% Figure 2. Market Data Companies Comparable to Value Group Equity Beta Debt Beta Quickenal 1.42 0.16 TMI Enterprises 1.52 0.28 Equity Value Debt Value 500 100 600 200 More Market Data U.S. Government 30 year bond Market Risk Premium 1.85% 5.50%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Sterling Bonds And Fixed Income Handbook

Authors: Mark Glowrey

1st Edition

0857190423, 978-0857190420

More Books

Students also viewed these Finance questions