Toy World Assumptions for Pro Forma
Assumptions for Pro Forma Statements
Income Statement
Net sales - Sales forecast for 1994 is used as there is no big difference in terms of sales for seasonal or level production.
COGS - According to the case 65.1% of sales for the current month.
Operating expenses - Seasonal projection 200 plus additional storage and handling cost 115/12 in case of shift to level production. The amount is the same for each month because in case study it is assumed operating expenses are likely to be incurred evenly throughout the year.
Interest expense - Long-term Loan - 9.63%/12, Notes payable to bank - 9%/12.
Interest Income - Cash - 4%/12.
Provision for income taxes - Income tax rate 34% as it was under seasonal assumption.
Balance Sheet
Cash - Minimum requirement is 200. Excess of total liabilities over total assets is added to the minimum amount in order to balance sides of the balance sheet.
Accounts receivable, net - Accounts Receivable are not affected by change in approach as in case of sales.
Inventory = Beg. Inventory + production - COGS. Production is calculated based on assumption that total yearly production equals total COGS for 1994, in other words, what is produced is sold. The logic is that inventory is set at 586 at the beggining of the year, in order to maintain this minimum balance we have to assume that sales (COGS) must be the same as goods produced. The number is evenly allocated\ to months in 1994.
Net Plant and Equipment - There is no intention of acquiring new fixed asset. In this case there is no difference between seasonal and level production.
Accounts payable - According to the case the company plans to purchase materials needed for production costing 3,000 during 1994. We get monthly 250 for purchases. Credit terms are Net 30 meaning that this amount is due in 30 days. To illustrate, suppose company has 250 payable at the end of January, at the end of February it will cover the payable however balance sheet will still show 250
Income Statement
Net sales - Sales forecast for 1994 is used as there is no big difference in terms of sales for seasonal or level production.
COGS - According to the case 65.1% of sales for the current month.
Operating expenses - Seasonal projection 200 plus additional storage and handling cost 115/12 in case of shift to level production. The amount is the same for each month because in case study it is assumed operating expenses are likely to be incurred evenly throughout the year.
Interest expense - Long-term Loan - 9.63%/12, Notes payable to bank - 9%/12.
Interest Income - Cash - 4%/12.
Provision for income taxes - Income tax rate 34% as it was under seasonal assumption.
Balance Sheet
Cash - Minimum requirement is 200. Excess of total liabilities over total assets is added to the minimum amount in order to balance sides of the balance sheet.
Accounts receivable, net - Accounts Receivable are not affected by change in approach as in case of sales.
Inventory = Beg. Inventory + production - COGS. Production is calculated based on assumption that total yearly production equals total COGS for 1994, in other words, what is produced is sold. The logic is that inventory is set at 586 at the beggining of the year, in order to maintain this minimum balance we have to assume that sales (COGS) must be the same as goods produced. The number is evenly allocated\ to months in 1994.
Net Plant and Equipment - There is no intention of acquiring new fixed asset. In this case there is no difference between seasonal and level production.
Accounts payable - According to the case the company plans to purchase materials needed for production costing 3,000 during 1994. We get monthly 250 for purchases. Credit terms are Net 30 meaning that this amount is due in 30 days. To illustrate, suppose company has 250 payable at the end of January, at the end of February it will cover the payable however balance sheet will still show 250