The Castillo Products Company was started in 2008. The company manufactures components for personal digital assistant (PDA) products and for other handheld electronic products. A difficult operating year, 2009, was followed by a profitable 2010. However, the founders (Cindy and Rob Castillo) are still concerned about the venture’s liquidity position and the amount of cash being used to operate the firm. Following are income statements and balance sheets for the Castillo Products Company for 2009 and 2010.

A. Use year-end data to calculate the current ratio, the quick ratio, and the NWC to-total-assets ratio for 2009 and 2010 for Castillo Products. What changes occurred?
B. Use Castillo Products’ complete income statement data and the changes in balance sheet items between 2009 and 2010 to determine the firm’s cash build and cash burn for 2010. Did Castillo Products have a net cash build or a net cash burn for 2010?
C. Convert the annual cash build and cash burn amounts calculated in Part B to monthly cash build and cash burn rates. Also indicate the amount of the net monthly cash build or cash burnrate.

Transcribed Image Text:

CASTILLO PRODUCTS COMPANY INCOME STATEMENT 2009 2010 Net sales $1,500,000 $900,000 540,000 360,000 90,000 250,000 40,000 20,000 45,000 65,000 Cost of goods sold Gross profit 900,000 600000 150,000 250,000 40,000 60,000 60,000 100,000 25,000 Marketing General and administrative Depreciation EBIT Interest Earnings before taxes Income taxes Net income (loss $65,000 S 75,000 2009 2010 Balance Sheet Cash Accounts receivable Inventories S 50,000 200,000 400,000 650,000 450,000 -100,000 S 20,000 280,000 500,000 800,000 540,000 -140,000 400,000 $1,200,000 Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Total assets 1000,000 S 160,000 70,000 100,000 330,000 400,000 150,000 200,000 120,000 $1,200,000 Accounts payable Accruals Bank loan Total current liabilities Long-temn debt Common stock (0.05 par) Additional paid-in-capital Retained eamings S 130,000 50,000 90,000 270,000 300,000 150,000 200,000 80,000 1000,000 Total liabilities and equity