LiveForever Biotechnology Corporation (LFBC) has a new potential drug developed by their research group.LFBC is debating whether to produce and sell the product themselves.The available information is listed below with production and sales to start in year 1.Depreciation is to be computed as straight line (no half year rule for straight line).
To simplify this question a little, assume that there is no salvage value.Working capital will be put in place during year 1 with Inventory being 20% of revenues, Accounts Receivable being 40% or revenues, and Accounts Payable being 65% of Costs of Goods Sold.All the working capital will be converted back into cash by the end of year 5.
Prepare an Income statement and Cash Flow Statement and determine the Present Worth and Internal Rate of Return of the proposal.
Year12345
Sales Revenue Forecast (millions)$50.00$75.00$125.00$200.00$300.00
Past research costs$100million
Cost of production facilities$24million
Start up costs (hiring, training, development)$12million
Cost of Goods Sold (COGS)48%of revenues
Sales, General & Administrative (SG&A)$50million annually
Depreciation (not in SG&A)5years straight line
Inventory20%of revenues
Accounts Receivable40%of revenues
Accounts Payable65%COGS
MARR12%
Tax Rate20%
FacilitiesStartupTotal
Investment$24$12$36