Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cary Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, and ships them to its chain of retail stores. Sales for
Cary Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, and ships them to its chain of retail stores. Sales for 2002 were $450 million. They are forecasted to increase to $500 million in 2003. Additional information and relevant financial ratios are given below.. Minimum cash balance required : $1.8 million Average collection period (accounts receivable/sales/365)): 60 days Inventory turnover (COGS/inventory): 3.18 Net fixed assets: Current level of $216 million. The firm expects to acquire new plant and equipment worth $8 million in 2003. Accounts payable: 4% of annual sales LT debt: existing LT debt is $110 million out of which the company expects to repay $15 million in 2003. Common stock, expected to remain constant at its 2002 level of $120 million. COGS: 70% of sales Depreciation: Annual depreciation for 2003 expected to be $15 million. Net profit margin: 6% of projected sales in 2003. Dividends: expected to be 40% of net income. Retained earnings at the end of 2002: 130 million. a) Based on the information given above, forecast the income statement for year ended December 31, 2003. b) Based on the information given above, and your estimate of retained earnings from part(a), forecast the pro forma balance sheet as of December 31, 2003, Assume that any additional funds requirement will be met by notes payable. The firm does not have any notes payable at the end of 2002. 3 (12pt) - - T- Paranranh Arial b) Based on the inven above, and your estimate of retained earre firm does not have any notes payable at the end of 2002. Question Completion Status: Cary Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, and ships them to its chain of retail stores. Sales for 2002 were $450 million. They are forecasted to increase to $500 million in 2003. Additional information and relevant financial ratins are given below. Minimum cash balance required : $1.8 million Average collection period (accounts receivable/sales/365): 60 days Inventory turnover (COGS inventory): 3.18 Net fixed assets: Current level of $216 million. The firm expects to acquire new plant and equipment worth $8 million in 2003, Accounts payable: 4% of annual sales LT debt: existing LT debt is $110 million out of which the company expects to repay $15 million in 2003. Common stock expected to remain constant at its 2002 level of $120 million, COGS: 70% of sales Depreciation: Annual depreciation for 2009 expected to be $15 million Net profit margin: 64 of projected sales in 2003, Dividends: expected to be 40% of net income. Retained earnings at the endjof 2002: 130 million a) Based on the information given above, forecast the income statement for year ended December 31, 2003 from (the December 31, 2003, Assume that any will be met notes payable Paragraph Artal 6 3 (12pt) 4 - E.T... XDOQES TT. ---- f Mashup @BESES Save Alerts Close Windows Answers to serve all answers. Click Save and Submit to save and submit. Click Save MacBook Air
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started