Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assume you are the Financial Analyst for Olympus Inc., and it is the end of December 2019. Olympus Inc., a manufacturing company, has been growing
Assume you are the Financial Analyst for Olympus Inc., and it is the end of December 2019. Olympus Inc., a manufacturing company, has been growing quickly, but it has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service, resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days, which is well above the terms of 30 days. To address the financial concerns, Olympus Inc. is forecasting level production and the impact of plans by the credit department to bring the average collection period down to 35 days. Forecasted sales for the upcoming months are as follows: January February March April May June $2,174,978 2,299,977 2,449,976 2,624,974 2,749,973 2,849,972 Sales for November were $1,924,981 and will be approximately $2,049,980 for the current month of December. It is projected that the current collection period of 60 days will be reduced to 50 days for January and February and to 42 days for March and April and will meet the target of 35 days in May and June. Purchases are forecast to be $590,000 a month beginning in January. In November they were $670,000, and in December they are expected to be $610,000. The purchases are paid in 40 days. Labour expense will be paid as incurred and will be $198.000 a month. Other expenses of manufacturing will also be paid as incurred and are expected to be $360,000 a month. Cost of goods sold has regularly been 70% of sales. Amortization is $39,000 per month. Selling and administrative expenses are expected to be 13 percent of sales. The tax rate is 42 percent. There will be payments on Notes Payable of $680,000 in each of February and May. Income taxes of $340,000 are due and paid in April. Dividends of $24,000 and interest of $270,000 (3 months of interest) are paid in January and April. OLYMPUS INC. Balance Sheet (Estimated) December 31, 2019 (S thousands) ASSETS Current Assets: Cash Accounts Receivable Inventory Total Current Assets Capital Assets: Plant and Equipment Less: Accumulated Amortization Total Assets $666 3,578 8,231 $12,475 $11,273 4,784 6,489 $18.964 LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities: Accounts Payable Notes Payable Accrued Liabilities Total Current Liabilities Long-term Debt Common Stock Retained Earnings Total Liabilities and Shareholders' Equity $945 3,700 2,596 $7,241 4,725 4,500 2,498 $56,892 Required: Using the information above, prepare pro forma statements for Olympus Inc. for the six months ending January to June 2020. Also construct a cash budget for the six-month period and identify any need for short-term financing. There are no changes in accounts not mentioned above. Comment on the policy changes and examine the consequences if the collection period remains at 60 days. Assume capital assets are sufficient for increased sales. Assume you are the Financial Analyst for Olympus Inc., and it is the end of December 2019. Olympus Inc., a manufacturing company, has been growing quickly, but it has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service, resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days, which is well above the terms of 30 days. To address the financial concerns, Olympus Inc. is forecasting level production and the impact of plans by the credit department to bring the average collection period down to 35 days. Forecasted sales for the upcoming months are as follows: January February March April May June $2,174,978 2,299,977 2,449,976 2,624,974 2,749,973 2,849,972 Sales for November were $1,924,981 and will be approximately $2,049,980 for the current month of December. It is projected that the current collection period of 60 days will be reduced to 50 days for January and February and to 42 days for March and April and will meet the target of 35 days in May and June. Purchases are forecast to be $590,000 a month beginning in January. In November they were $670,000, and in December they are expected to be $610,000. The purchases are paid in 40 days. Labour expense will be paid as incurred and will be $198.000 a month. Other expenses of manufacturing will also be paid as incurred and are expected to be $360,000 a month. Cost of goods sold has regularly been 70% of sales. Amortization is $39,000 per month. Selling and administrative expenses are expected to be 13 percent of sales. The tax rate is 42 percent. There will be payments on Notes Payable of $680,000 in each of February and May. Income taxes of $340,000 are due and paid in April. Dividends of $24,000 and interest of $270,000 (3 months of interest) are paid in January and April. OLYMPUS INC. Balance Sheet (Estimated) December 31, 2019 (S thousands) ASSETS Current Assets: Cash Accounts Receivable Inventory Total Current Assets Capital Assets: Plant and Equipment Less: Accumulated Amortization Total Assets $666 3,578 8,231 $12,475 $11,273 4,784 6,489 $18.964 LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities: Accounts Payable Notes Payable Accrued Liabilities Total Current Liabilities Long-term Debt Common Stock Retained Earnings Total Liabilities and Shareholders' Equity $945 3,700 2,596 $7,241 4,725 4,500 2,498 $56,892 Required: Using the information above, prepare pro forma statements for Olympus Inc. for the six months ending January to June 2020. Also construct a cash budget for the six-month period and identify any need for short-term financing. There are no changes in accounts not mentioned above. Comment on the policy changes and examine the consequences if the collection period remains at 60 days. Assume capital assets are sufficient for increased sales
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