24 Jul WHAT WILL BE THE MAXIMUM AMOUNT OF ADDITIONAL FUNDS NEEDED DURING YOUR FIVE-YEAR FORECAST?
The GENENTECH CORPORATION spent several years working on developing a DHA product that can be used t Show more The GENENTECH CORPORATION spent several years working on developing a DHA product that can be used to provide a fatty acid supplement to a whole variety of food products. DHA stands for docsahexaenoic acid an omega-3 fatty acid found naturally in cold-water fish. The benefits of fatty fish oil have been cited in studies of the brain eyes and the immune system. Unfortunately it is both difficult to consume enough fish to get the benefits of DHA and most individuals might be concerned about the taste consequences associated with adding fatty fish oil to eggs ice cream or chocolate candy. To counter these constraints Genentech and several competitors have been able to grow algae and other plants that are rich in DHA. The resulting chemical compounds then are used to enhance a variety of food products. Genentechs initial DHA product was designed as additives to dairy products and yogurt. For example the ventures DHA product was added to cottage cheese and fruit-flavored yogurts to enhance the health benefits of those products. After the long product development period Genentech began operations in 2012. Income statement and balance sheet results for 2013 the first full year of operations have been prepared. Genentech however is concerned with forecasting its financial statements for next year because it is uncertain as to the amount of additional financing of assets that will be needed as the venture ramps up sales next year. Genentech expects to introduce a DHA product that can be added to chocolate candies. Not only will consumers get the satisfaction of the taste chocolate candies they will benefit from the DHA enhancement. Since this is expected to be a block buster new product sales are expected to increase 50 percent next year (2014) even though the new product will come on line in mid-year. An additional 80 percent increase in sales is expected the following year (2015). _______________________________ GENENTECH CORPORATION Income Statement for December 31 2013 (Thousands of Dollars) __________________________________ Sales $15000 Operating expenses -13000 EBIT 2000 Interest 400 EBT 1600 Taxes (40%) 640 Net income 960 Cash dividends (40%) 384 Added retained earnings $576 GENENTECH CORPORATION Balance Sheet as of December 31 2013 (Thousands of Dollars) ________________________________________________________________________ Cash & marketable securities $ 1000 Accounts payable $ 1600 Accounts receivable 2000 Bank Loan 1800 Inventories 2200 Accrued liabilities 1200 Total current assets 5200 Total current liabilities 4600 Long-term debt 2200 Fixed assets net 6800 Common stock 2400 Total assets $12000 Retained earnings 2800 Total liabilities & equity $12000 ________________________________________________________________________ A.Estimate the additional funds needed (AFN) for 2014 using the formula method based on percent of sales relationships. B.Estimate the AFN for Genentech for 2015. C.Prepare pro forma income and balance sheet statements for 2014 before obtaining any additional financing. Why does the AFN from the spreadsheet projections differ from the AFN estimated in Part A? D.Prepare a second iteration of your pro forma financial statements for 2014 if the initial AFN estimate is to be financed by additional long-term funds at a 10 percent interest rate. E.Prepare pro forma financial statements for 2015 that build on to the pro forma results obtained in Part D. F. Prepare projected income statements balance sheets and statements of cash flow for Genentech for 2014 and 2015 before obtaining of any additional financing. What are the amounts of additional funds needed? G. Assume that sales are expected to grow at 100 percent in 2016 (over the 2015 sales level) 50 percent in 2017 and 20 percent in 2018. Extend your projected financial statements prepared in Part E to include years 2016 2017 and 2018. What will be the maximum amount of additional funds needed during your five-year forecast? H. Assume that you will acquire the amount funds needed in Part F by selling or issuing more common stock and by borrowing from lenders at a 10 percent interest rate. Prepare a second round of projected five-year financial statements showing that the initial financing needed will be obtained equally each year by issuing new stock (50 percent) and by borrowing from lenders (50 percent). Will offer max points please show detailed Steps!!!!!!! Show less
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.