Never Give Up Workshops

Selling the dream

The owners of Never Give Up have decided to retire and embark on new life adventures. Assume they own all the common shares of the business and are looking to sell those shares to the right person or team who can continue to build upon the sterling reputation of the business. Youre going to switch sides and your team is considering purchasing 100% of the shares of this business.

Based on the information provided on the next page, answer the following:

1. There is inherent risk to this business model being that it operates in the ever-changing workshop/education/training industry, so we would like to set a hurdle rate. If our hurdle rate is 15%, should we still buy the business? At this rate, what purchase price should we offer?
2. What is the internal rate of return?

Never Give Up Information

• The company is concluding Year 10 of operations.
• The original loan to start the business will be paid off in Year 10 (Challenge 1).
• In Year 4, Never Give Up added a new location in Kelowna (Challenge 4).
• In Year 5, Never Give up renovated and expanded the Kamloops location (Option 2 from Challenge 5).
• Despite a retained earnings deficit lasting through its life, Never Give Up paid a flat rate dividend of $45k annually since Year 5.
• For the last four years the company has been recognized as a trusted brand and innovative workshop company that provides significant online and in-person learning opportunities.

Valuation Elements (Restating the Balance Sheet)

• The market value of the capital assets has been estimated to be $1.5 million, an increase of about 235% over the book value of the sellers non-current assets ($447,500).
• As the buyers, we are interested in purchasing all the assets of the business including goodwill, which is estimated to be $1 million for the name and the business.
• Prepaid Expenses and Cash accounts show their actual balances and can be carried forward.
• Based on a detailed audit of the companys inventories and A/R, they have each been reduced by 45%.
• All current liabilities are brought forward to the restated balance sheet.
• The buyers will borrow $2 million to purchase some of the assets of the business (new amount for non-current liabilities).
• An amount of $853,671 would be invested in the business by the buyers (this share capital replaces sellers owners equity on the restated balance sheet).

Valuation Elements (Discounting Cash Flows)

• As the buyers, we are planning on keeping the business for 10 years then exiting. The estimated sale price at that time is $6 million.
• Estimated annual cash inflows are determined by adding depreciation expense to Net Income in Year 10.

Income statement for the period ending Year 10 Revenues 650,883 Expenses 125,000 110,000 97,632 17,395 16,272 Full Time Salaries Part Time Wages Direct Expenses (15%; supplies and admin) Pre-Opening Marketing, Website, Public Relations Professional fees Rent Utilities Insurance Technology Interest Expense (Short & Long-term) Depreciation 69,582 15,437 13,180 7,241 32,349 110,500 Total expenses 614,589 $ Net income (loss) before income taxes Income tax Net income (loss) after taxes 36,294 4,355 31,939 Balance Sheet as at the end of Year 10 Current assets Cash Accounts receivable Inventory (Supplies) Prepaid Expenses Total Current Assets 218,526 175,000 95,000 26,000 514,526 Non-Current Assets New Kelowna Location (Year 4; Depreciation Starts Year 5) Capital Upgrades (Year 5; Option #2) Property Plant & Equipment Accumulated Depreciation Goodwill Total Non-Current Assets Total assets 875,000 195,000 35,000 (657,500) 447,500 962,026 $ Liabilities and Owners' Equity Current Liabilities 35,000 Accounts payable Wages payable Income taxes payable Total Current Liabilities 4,355 39,355 Non-Current Liabilities 106,514 749,571 New Term Loan for Renovation (15 years; 3.85%) (Year 5) New Mortgage Loan for New Location (25 years; 3.5%) (Year 4) Original Long term loan (10 years; 6%) Total Non-Current Liabilities Total Liabilities 856,085 895,440 Owners' Equity Retained Earnings (deficit) Less: Dividends paid Common shares (379,665) (45,000) 491,250 66,585 962,026 Total liabilities and owners' equity $ Income statement for the period ending Year 10 Revenues 650,883 Expenses 125,000 110,000 97,632 17,395 16,272 Full Time Salaries Part Time Wages Direct Expenses (15%; supplies and admin) Pre-Opening Marketing, Website, Public Relations Professional fees Rent Utilities Insurance Technology Interest Expense (Short & Long-term) Depreciation 69,582 15,437 13,180 7,241 32,349 110,500 Total expenses 614,589 $ Net income (loss) before income taxes Income tax Net income (loss) after taxes 36,294 4,355 31,939 Balance Sheet as at the end of Year 10 Current assets Cash Accounts receivable Inventory (Supplies) Prepaid Expenses Total Current Assets 218,526 175,000 95,000 26,000 514,526 Non-Current Assets New Kelowna Location (Year 4; Depreciation Starts Year 5) Capital Upgrades (Year 5; Option #2) Property Plant & Equipment Accumulated Depreciation Goodwill Total Non-Current Assets Total assets 875,000 195,000 35,000 (657,500) 447,500 962,026 $ Liabilities and Owners' Equity Current Liabilities 35,000 Accounts payable Wages payable Income taxes payable Total Current Liabilities 4,355 39,355 Non-Current Liabilities 106,514 749,571 New Term Loan for Renovation (15 years; 3.85%) (Year 5) New Mortgage Loan for New Location (25 years; 3.5%) (Year 4) Original Long term loan (10 years; 6%) Total Non-Current Liabilities Total Liabilities 856,085 895,440 Owners' Equity Retained Earnings (deficit) Less: Dividends paid Common shares (379,665) (45,000) 491,250 66,585 962,026 Total liabilities and owners' equity $