Reference no: EM131123629

The Pharma Biotech Corporation spent several years working on developing a DHA product that can be used to provide a fatty-acid supplement to a variety of food products. DHA stands for docosahexaenoic 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, the eyes, and the immune system. Unfortunately, it is 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, Pharma Biotech 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.

Part A
Pharma Biotech is interested in developing an initial "big picture" of the size of financing that might be needed to support its rapid growth objectives for 2011 and 2012.
A. Calculate the following financial ratios for Pharma Biotech for 2010: 
(a) Net profit margin, 
(b) Sales-to-total-assets ratio,
(c) Equity multiplier, and 
(d) Total-debt-to-total-assets. 
Apply the return on assets and return on equity models. Discuss your observations.
B. Estimate Pharma's sustainable sales growth rate based on its 2010 financial statements. What financial policy change might Pharma Biotech make to improve its sustainable growth rate? Show your calculations.
C. Estimate the additional funds needed (AFN) for 2011, using the formula or equation method presented in the chapter.
D. Also, estimate the AFN using the equation method for Pharma Biotech for 2012. What will be the cumulative AFN for the twoyear period?

Part B
Pharma Biotech is seeking your assistance in preparing its projected financial statements using the percent-of-sales method. Initial projected financial statements can be prepared by hand using a financial calculator or by constructing spreadsheet-based solutions.
A. Prepare a projected income statement for 2011 for Pharma Biotech before obtaining any additional financing. 
B. Prepare a projected balance sheet for 2011 for Pharma Biotech before obtaining any additional financing. 
C. Based on your projected balance sheet for Pharma Biotech for 2011, what is your estimate of the additional funds needed? Why does the AFN from your initial percent-of-sales projected financial statements differ from the AFN estimated using the formula method in Item C above?
D. Prepare a projected statement of cash flows for Pharma Biotech for 2011. 

Part C
The following tasks or challenges are best handled by setting up spreadsheet-based methods projecting financial statements.
A. Prepare projected income statements, balance sheets, and statements of cash flows for Pharma Biotech for 2012 that build upon the projections for 2011 prepared in Part B above. What is the cumulative (2011 and 2012) amount of additional funds needed?
B. Calculate the total-debt-to-total assets ratio and the equity multiplier ratio assuming the cumulative AFN is financed with debt funds. How would these ratios compare with the same ratios calculated for 2010 in Item Aabove?