Richmond Coffee, Inc. was founded by Gail McCornell and his wife in 2010 in Richmond, Indiana. Due to the lack of the related expertise, the company has not been using much financial planning for its investment needs. Therefore, RC is currently undergoing some hard times resulted in some severe cash flow problems. In addition to losing sales, RC is also falling short of profit to pay salaries to the founders. So, there is an urgent need for the company to prepare a financial plan for the next year to cope with the anticipated investment requirements. Richmond Coffee, Inc. 2015 Income Statement Sales $6,854,000 Cost of goods sold 5,231,000 Other expenses 472,000 Depreciation 186,000 EBIT $965,000 Interest 124,800 Taxable income $840,200 Taxes (40%) 336,080 Net income 504,120 Dividends $201,648 Add to retained earnings 302,472 Richmond Coffee, Inc. 2015 Balance Sheet Assets Liabilities and Equity Current assets Current liabilities Cash $282,000 Accounts payable $265,000 Accounts receivable 342,000 Notes payable 168,000 Inventory 650,000 Total current liabilities $433,000 Total current assets $1,274,000 Long-term debt $2,080,000 Fixed assets Net plant and equipment $2,854,000 Shareholder equity Common stock $450,000 Retained earnings 1,165,000 Total equity $1,615,000 Total assets $4,128,000 Total liabilities and equity $4,128,000 RC is looking forward to a growth rate of 14 percent in 2016 (i.e. its sales is expected to increase by 14%). The firm has decided to hire you as a financial consultant to fix all the cash flow problems for them. 1. You are expected to calculate the internal growth rate and sustainable growth rate for RC, and explain to the founders what these numbers mean. (20 points) 2. RC is currently operating at full (100%) capacity. Gail McCornell, one of the founders of the company, would like you to advise them on what amount of external financing will be needed (EFN) for 2016 and whether RC’s sales can rise at this particular rate of growth? 01 F15 BUS-F301 Case Study 1 - Description and Requirements 3/3 Please be reminded to include the necessary assumptions, pro forma income statement and pro forma balance sheet in your answer in addition to other workings. (50 points) 3. RC’s fixed assets can only be acquired in multiples of $1,500,000 (i.e. adding a new product line will call for an additional investment of $1,500,000 in new equipment) once RC has reached its full operating capacity. Gail is eager to know what the new external financing needed (EFN) should be as the firm is now already operating at its full capacity. In addition, he also asks you to estimate the new level of capacity utilization of the fixed assets for RD in next year when the new production line has been implemented. Please be reminded to include the new pro forma income statement and pro forma balance sheet in your answer in addition to other workings. (50 points) 4. Gail is interested in knowing as well how the firm’s ROE will change from 2015 to 2016 according to the projected growth rate (subject to the condition that the firm can only acquire the required fixed assets in multiples of $1,500,000, the owners are not going to put in more capital and the firm’s payout ratio remains at the 2015 level). You are expected to do a Du Pont analysis comparison between the two years. For the Du Pont analysis, you must include both the calculations and the explanations.