Rachel is putting together a growth plan for ESI. She is evaluating whether to substantially invest in company-owned equipment, and whether to outsource her online services personnel to a call center in New Dehli, India.

Rachel has asked for your analysis of the following two decisions facing ESI:

1. EQUIPMENT PURCHASE - ESI may decide to purchase outright additional computer equipment. ESI can continue to lease equipment from hardware vendors. Such a status quo decision comes with known margins and profitability metrics. The status quo is embodied in the income statement and balance sheet reported in 202x data given above. Rachel believes adding owned equipment to its existing leasing business will enable ESI to more fully utilize their fixed assets, grow faster and provide more customized services to a larger group of future clients. Rachel is proposing to purchase $500,000 of additional IT equipment. The equipment would be installed and prepared for use in the current year. When fully utilized the equipment would generate asset turnover of approximately 2x gross investment. It would likely take four years to reach full utilization. The useful life of equipment for accounting and tax purposes is 10 years. However, due to rapid life cycles in enterprise technology, after six years Rachel expects to sell the equipment for 10% of initial cost. The EBITDA (operating income plus depreciation and amortization) margin of business done with owned equipment is 1.1x the margin of business done with leased equipment.

2. OUTSOURCING ONLINE CONSULTANTS - Rachel may move her entire online service team to India. As she has tried to re-sign existing clients and win new business Rachel has been feeling pricing and margin pressure. For the time being Rachel has only re-signed or sought new business that matches her current margin profile. Rachel expects to be able to maintain the status quo in the online services business for several more years. However, for the most part Rachel’s regional and national competitors have outsourced online support to low-cost countries. ESI’s higher cost structure limits the future growth of ESI services. ESI’s five full time online consultants each make $60,000 per year. The online segment cost of goods sold is a little more than the $300,000 paid to the consultants in the most recent year. Consulting EBITDA is approximately $147,450. If ESI does not outsource its consultants it is estimated consultant margin dollars will remain about flat for the next several years. For comparison, online consultants in India make approximately $30,000 per year, growing at 10% per year. In the first year after moving to India Rachel expects consulting EBITDA margins dollars to be the same as in the US. However, in years 2 through 10 consulting revenue should grow by 20% per year, while the increase labor cost and productivity gains of India employees should just about offset. This means ESI could maintain its current consulting EBITDA margin on a growing revenue base. Uncertainty in technology life cycles means Rachel doesn’t think it is reasonable to plan an online services business beyond 10 years into the future. To make the move to India, ESI would pay the cost of a fairly generous severance. It is expected US employees would receive a package valued at 50% of annual compensation. ESI would sell five U.S. based computer terminals and desks for $8000. The setup costs in India, including new office space, equipment and telecom infrastructure is $100,000. The setup costs will be amortized over 10 years. For conservatism, after 10 years ESI assumes zero recovery on any office furniture, and no future lease liabilities.

Additional Capital Budgeting Assumptions:

• Marginal and average corporate tax rate of 21%.
• Pretax cost of bank borrowing is 5%.
• As a private firm ESI has an internally defined required return on equity of 10%.
• ESI’s banks charge a 2% premium for international investments. The required equity
• return should also be charged a risk premium over domestic investments.
• ESI expects to maintain the ratio of equity and long-term liabilities shown in the 202x
• balance sheet.
• The reinvestment rate earned on idle cash is 3%.

1-3 REQUIRED

1. Calculate the capital budgeting decision metrics for the proposed expansion in ESI owned computer equipment. Calculate each of NPV, IRR, MIRR, Payback and Profitability Index. Show all calculations including initial outlay, annual differential cash flows, terminal value, and weighted average cost of capital.
2. In addition to the capital budgeting calculations, discuss at least three important qualitative issues associated with the proposed purchase of additional computer equipment.
3. Calculate the capital budgeting decision metrics for the proposed outsourcing of ESI’s online help desk to New Dehli, India. Calculate each of NPV, IRR, MIRR, Payback and Profitability Index.
4.  

Transcribed Image Text:

ASSETS Cash Marketable Securities Accounts Receivable Uncollectible Accounts Inventory Supplies Prepaid Insurance Total Current Assets Total Assets Rachel's Enterprises Solutions Incorporated Balance Sheet As of December 31, 202x $ 37,000 10,000 63,000 Land $111,500 Equipment 217,000 Accumulated Depreciation -97,000 Building 590,000 Accumulated Depreciation -110,000 Intangible Assets 60,000 Total Long-Term Assets $771,150 -2,000 74,000 4,000 7,500 $193,500 Tax Net Income Shares Outstanding Earnings Per Share $965,000 Equipment Sales Revenue Consulting Service Revenue (Online Help) Total Revenue Cost of Goods Sold Selling, General & Administrative Depreciation & Amortization Earnings Before Interest and Tax (EBIT) Interest Earnings Before Tax (EBT) Equipment sales EBITDA Consulting Online Help EBITDA Total EBITDA LIABILITIES Accounts Payable Wages Payable Taxes Payable Short-Term Note Payable Interest Payable Unearned Revenue 20,000 Unearned Consulting Rev. 5,000 Total Current Liabilities $ 115,000 Long-Term Notes Payable $ 50,000 Bonds Payable 100,000 Mortgage Payable 350,000 Total Long-Term Liabilities $500,000 STOCKHOLDER EQUITY Capital Stock Paid in Capital Rachel's Enterprises Solutions Incorporated Income Statement and Segment EBITDA For the 12 Months Ending December 31, 202x $ 40,000 10,800 7,200 30,000 2000 Retained Earnings Total Stockholders Equity $350,000 Total Liabilities & Equity $965,000 1,333,440 450,000 1,783,440 934,450 33,820 58,665 756,505 35,576 720,929 152,686 568,243 14,000 40.59 $100,000 140,000 110,000 667,720 147,450 815,170 ASSETS Cash Marketable Securities Accounts Receivable Uncollectible Accounts Inventory Supplies Prepaid Insurance Total Current Assets Total Assets Rachel's Enterprises Solutions Incorporated Balance Sheet As of December 31, 202x $ 37,000 10,000 63,000 Land $111,500 Equipment 217,000 Accumulated Depreciation -97,000 Building 590,000 Accumulated Depreciation -110,000 Intangible Assets 60,000 Total Long-Term Assets $771,150 -2,000 74,000 4,000 7,500 $193,500 Tax Net Income Shares Outstanding Earnings Per Share $965,000 Equipment Sales Revenue Consulting Service Revenue (Online Help) Total Revenue Cost of Goods Sold Selling, General & Administrative Depreciation & Amortization Earnings Before Interest and Tax (EBIT) Interest Earnings Before Tax (EBT) Equipment sales EBITDA Consulting Online Help EBITDA Total EBITDA LIABILITIES Accounts Payable Wages Payable Taxes Payable Short-Term Note Payable Interest Payable Unearned Revenue 20,000 Unearned Consulting Rev. 5,000 Total Current Liabilities $ 115,000 Long-Term Notes Payable $ 50,000 Bonds Payable 100,000 Mortgage Payable 350,000 Total Long-Term Liabilities $500,000 STOCKHOLDER EQUITY Capital Stock Paid in Capital Rachel's Enterprises Solutions Incorporated Income Statement and Segment EBITDA For the 12 Months Ending December 31, 202x $ 40,000 10,800 7,200 30,000 2000 Retained Earnings Total Stockholders Equity $350,000 Total Liabilities & Equity $965,000 1,333,440 450,000 1,783,440 934,450 33,820 58,665 756,505 35,576 720,929 152,686 568,243 14,000 40.59 $100,000 140,000 110,000 667,720 147,450 815,170

Answer rating: 100% (QA)

Rachels Enterprises Solutions Incorporated ESI Investment Analysis Report Executive Summary This report analyzes two potential investment decisions fa... View the full answer