Opening balance Machines and Inventory 3 800 8 900 Stock 3 500 7 150 Bankloan Equity...

 

Transcribed Image Text:

Opening balance Machines and Inventory 3 800 8 900 Stock 3 500 7 150 Bankloan Equity Bank 5 600 5 750 Acc. Payables Acc. Receivables 8 900 21 800 21 800 Make a master Budget for the following year. The sales for the company is in January-March 48 000 , April-June 52 000 , July-September 76 000 and October-December 60 000 . The payment time for the acc. Receivables is 12 days. The contribution margin rate is 56 %. The payment time for purchases is 30 days. The company has two employees, both get paid 2 150 /month. In summer we hire six summer employees for the months May-August, each is paid 1540 /month The social costs are 30 % on top of the salaries. The rent is 650 /month. The company has a bankloan of 8 900 of which an interest of 6 % is paid each month. The loan is amortized 31st of March with 1 100 and 30th of September with 1 100 . 2 200 is amortized during the following year. The company makes investments in machines and inventory in January 1 250 and in September 2 850 The owner will make a private withdrawal of 1 500 each month. The Machines and inventory is depreciated with 25 % at the end of the year. Your task: 1. Create a sales, purchase and Contribution margin Budget for each quarter. 2. Create an Operating Budget for the whole year 3. Create a cashflow budget per quarter 4. Create a Pro Forma Balance per 31.12. 5. Write a short Management report how you think the budget for this company looks like. Opening balance Machines and Inventory 3 800 8 900 Stock 3 500 7 150 Bankloan Equity Bank 5 600 5 750 Acc. Payables Acc. Receivables 8 900 21 800 21 800 Make a master Budget for the following year. The sales for the company is in January-March 48 000 , April-June 52 000 , July-September 76 000 and October-December 60 000 . The payment time for the acc. Receivables is 12 days. The contribution margin rate is 56 %. The payment time for purchases is 30 days. The company has two employees, both get paid 2 150 /month. In summer we hire six summer employees for the months May-August, each is paid 1540 /month The social costs are 30 % on top of the salaries. The rent is 650 /month. The company has a bankloan of 8 900 of which an interest of 6 % is paid each month. The loan is amortized 31st of March with 1 100 and 30th of September with 1 100 . 2 200 is amortized during the following year. The company makes investments in machines and inventory in January 1 250 and in September 2 850 The owner will make a private withdrawal of 1 500 each month. The Machines and inventory is depreciated with 25 % at the end of the year. Your task: 1. Create a sales, purchase and Contribution margin Budget for each quarter. 2. Create an Operating Budget for the whole year 3. Create a cashflow budget per quarter 4. Create a Pro Forma Balance per 31.12. 5. Write a short Management report how you think the budget for this company looks like.