QUESTION: We would like a forecast of our net income projected for the next quarter, April to June 20X3. We have gathered the following information:
? sales ? $3,900,000
? cost of goods sold ? same percentage of sales as 20X2
? selling and marketing ? $26,000
? research and development ? $95,000
? general and administration ? $115,000
? other operating expenses ? $4,600
As at April 1, 20X3, the opening cash balance is $76,250 and the line of credit balance is $181,200. Starting in 20X3, the company now earns 1.5% on its cash balance. Note: Assume the cash balance and the line of credit balance do not fluctuate during the quarter. Use number of days to calculate interest expense. Round percentages to two decimals; for example, 26.67%.
Required: Prepare the information requested by BFG.
PROJECT DETAILS (Note: all amounts are in Canadian dollars.) Bio-Fuels Generation Incorporated (BFG) is a private company that produces biomass- based diesel fuel from feedstocks, including inedible corn oil, used cooking oil, and inedible animal fats. The diesel fuel is then sold to distributors. The company is also actively involved in research into the production of other types of biomass-based fuels. Recently, the research team had a breakthrough and discovered a new production process that will produce fuel from algae at a relatively low production cost. The benets of using algae as a feedstock for fuel production have long been known and include the fact that algae can be grown in large quantities in wastewater and can be genetically manipulated to produce many different types of fuel. But the main disadvantage to commercialization has been that algae production requires large amounts of water, nitrogen. and phosphorous, resulting in higher greenhouse gas emissions to produce algae than is saved by using it as a fuel, in addition to very high production costs. However, the BFG research team has recently discovered a process that will signicantly reduce the amount of these inputs required, resulting in a very cost- effective production process. BFG is owned by Eleanor Whiteman, a renowned scientist in the research of biomass- based fuels, and her husband, Michael Whiteman. Eleanor owns 300,000 common shares and Michael owns 100,000 common shares. Currently, the company has three directors on its board Eleanor, Michael, and Sherry LePage, a long-time friend. Sherry has a PhD in Biology, specializing in algae, and teaches at the local university. With her background and experience, Sherry advises on the research conducted at the rm. She is very interested in this project of using algae to produce fuel. Eleanor is very excited about the research results because this has been her area of research for the past 20 years. BFG now needs nancing to commercialize this algae production process. Michael is also excited about the company expanding into this area but has some concerns regarding how the financing should be raised and other finance issues affecting the company. You currently work as a nancial analyst for HRY Consultants Inc. BFG has hired your company in the past to assist with a variety of financial issues. Yesterday, Eleanor called you, asking about work she would like completed. The following appendixes provide additional information about BFG and its financial position: Appendix I 20x1 and 20x2 nancial statements Appendix II Current capital structure and nancing proposals Appendix III Assumptions for the capital budget analysis APPENDIX I 20X1 AND 20X2 FINANCIAL STATEMENTS Bio-Fuels Generation Incorporated Statement of financial position as at December 31, 20X2, and 20X1 20X2 20X1 $ $ ASSETS Current Cash 60,890 57,100 Accounts receivable 450,640 395, 100 Inventory 736,500 689,500 1,248,030 1, 141,700 Property, plant, and equipment 2,589,300 2,450,000 Total assets 3,837,330 3,591,700 LIABILITIES Current Line of credit 165,230 122,400 Trade and other payables 625,620 579,331 790,850 701,731 Non-current Long-term debt 1,658,560 1,658,560 Total liabilities 2,449,410 2,360,291 Shareholders' equity Common shares (400,000 shares outstanding) 415,000 415,000 Retained earnings 972,920 816,409 Total shareholders' equity 1,387,920 1,231,409 Total liabilities and shareholders' equity 3,837,330 3,591,700APPENDIX I 20x1 AND 20x2 FINANCIAL STATEMENTS Bio-Fuels Generation Incorporated Statement of comprehensive income for the year ended December 31 ZOXZ 20x1 $ 15 Revenue 10,456,240 9,734,502 Cost of goods sold 9,075,000 8,473,800 Gross prot 1,363,240 1,260,702 Expenses Selling and marketing 103,500 92,400 Research and development 370,020 365,100 General and administrative 458,200 423,900 Other operating costs 15,900 14,200 947,620 895,600 Operating income 435,620 365,102 Interest expense line of credit (8,650) (7,150) Interest expense long-term debt (149,270) (149,270) Earnings before taxes 277,700 208,682 Income taxes (69,425) (52,171) Net income 208,275 156,511 APPENDIX II CURRENT CAPITAL STRUCTURE AND PROPOSALS The company has the following issued capital: 1. Line of credit First Royal Bank The line of credit has a maximum amount of $200,000 and is secured by the accounts receivable and inventory. The line of credit bears interest at prime plus 2.5%. Currently, prime is at 3.5%. Long-term debt First Royal Bank The long-term debt matures December 31, 20X9, when the full amount of the principal is due. The loan bears interest at 9%, which is payable annually. The loan is secured by the property, plant, and equipment. The long-term debt has a covenant that the long-term debt to total asset ratio cannot exceed 0.70. Eleanor has approached two potential investors for investment in the algae bio-fuel project. The proposals from each party are outlined below: a. Trinity Venture Capitalists (Trinity) When BFG started operations, Trinity provided some initial funding which has since been paid back. Trinity is now proposing to invest $2,000,000, to be used to commercialize the algae production. BFG will issue 200,000 non-voting, cumulative preferred shares at a price of $10 per share. Cumulative dividends at the rate of 6% will be paid on the preferred shares. These shares are convertible into common shares on a one-to- one basis at the option of Trinity any time after 20x5. Any dividends in arrears must be fully paid prior to redemption or conversion. BFG may redeem these shares any time after zoxs and prior to conversion. Trinity requires that two representatives be members on the board of directors who will be involved in the day-to-day operating, strategic, and financial decisions. . Sherry LePage. a private investor and current board member Sherry recently inherited some cash and is looking to make an investment. She has offered to invest $2,000,000 in the form of a loan. The loan will bear annual interest at 7%, payable monthly. The loan matures in 20 years when the full amount of principal is due. Note: You are not required to recalculate the weighted average cost of capital under each proposal. 4. BFG's corporate income-tax rate is currently 25%. 5. Based on market data, you have determined that the current risk-free rate is 3% and the expected market price of risk is 5%. You have estimated that the industry beta is 1.9. APPENDIX III ASSUMPTIONS FOR THE CAPITAL BUDGET ANALYSIS The following are the assumptions for the production plant and sale of bio-fuel produced by the algae: Construction of the building and equipment will cost $1,500,000 and $500,000, respectively. The building qualies for Class 1 (4%) and the equipment qualies for Class 8 (20%) CCA for income-tax purposes. The half-year rule is applied to both classes in the year of addition. The company currently has vacant land that is being held for capital appreciation. This land will be used for the building. The land was purchased six years ago for $300,000. Today it is worth $400,000. The company has incurred development costs to date related to this project of $150,000. An initial working capital investment of $30,000 is needed for inventory and receivables, which remain unchanged throughout the project life. Annual revenues will be as follows: 0 20x3 $1,400,000 0 20x4 $1,800,000 0 20X5 and each year thereafter $2,300,000 Cost of goods sold will be 30% of revenue and selling and marketing costs will be 10.2% of revenues. Fixed operating costs will be $575,000 per year. These annual cash flows will occur for 10 years which is the estimated life of the project. At the end of the 10 years, the building can be sold for $250,000, the land can be sold for $400,000, and the equipment will have no value. Assume that there are still assets remaining in the CCA classes at this time after the proceeds of disposition. For this project, the company pays income taxes at 25% and has a discount rate of 17%
