Exercise 1 - Cash budget Prepare the cash budget for Beta in 2023, knowing that: - The company's revenues are not subject to seasonality. The DSO for monthly sales from January to June is 60 days, while for the sccond half of the year is 120 days. in addition, the company collects 2022 account receivables uniformly in the first four months of 2023. - Monthly purchases of raw materials amount to 55\% of May and June monthly sales and 40% in all other months of the year. In January, February, and March 2023, payments are deferred by 90 days, while for the remaining months of the year (April-Deccmber) they are deferred by 75 days. Account payables in 2022 amount to 18,000 curos, of which 3,000 curos relate to debts arising in December 2022 and the rkmaining part in November 2022. The DPO for 2022 was 60 days. - General expenses are paid monthly and they amount to 10% of monthly purchaser. - In the personnel cost, the company records severance payment provisions of 600 curos. The company pays salaries in fourteen regular instalments, two of which are puid in June and two in December. In addition, in May 2022, an cmployee left the company; therefore, in July, the company pays the employee's severance of 200 euros. - Ending inventory is equal to 30%6 of total purchases. - The tax rale is 30%, and taxes are paid the following year. Taxes for 2022 will be paid in June, for a total of 325 curos. - In 2023, the company will invest 10,000 curos in renewing an old machine. The machine is paid in two regular instalments, in June and August. In February, the coapany recordod a revaluation of existing real estate assets of 10,000 curos. - Only half of the cash balance in the 2022 bulance sheet is functional to the company's operations. Therefore, in January, the company uses the remaining half of the cach balance to reduce debt. - 500 curos dividends will be paid in September. - The company plans to repay an instalment of 10,000 curos in April; the capital portion of the repaid loan is 7,000 curos. - The nominal annual interest rate for both active and passive interests is 6% and is paid erery three months. Please complete the cash budget, income statement, balance sheet, and financial statement. Please create the cash flow statement for 2022 using the financial statement data provided in the "Long-Exercise 2" tab of the Excel file 30433 - Framework.xlsx. Exercise 1 - Cash budget Prepare the cash budget for Beta in 2023, knowing that: - The company's revenues are not subject to seasonality. The DSO for monthly sales from January to June is 60 days, while for the second half of the year is 120 days. In addition, the company collects 2022 account receivables uniformly in the first four months of 2023. - Monthly purchases of raw materials amount to 55% of May and June monthly sales and 40% in all other months of the year. In January, February, and March 2023, payments are deferred by 90 days, while for the remaining months of the year (April-December) they are deferred by 75 days. Account payables in 2022 amount to 18,000 euros, of which 3,000 euros relate to debts arising in December 2022 and the remaining part in November 2022. The DPO for 2022 was 60 days. - General expenses are paid monthly and they amount to 10% of monthly purchases. - In the personnel cost, the company records severance payment provisions of 600 euros. The company pays salaries in fourteen regular instalments, two of which are paid in June and two in December. In addition, in May 2022, an employee left the company; therefore, in July, the company pays the employee's severance of 200 euros. - Ending inventory is equal to 30% of total purchases. - The tax rate is 30%, and taxes are paid the following year. Taxes for 2022 will be paid in June, for a total of 325 curos. - In 2023 , the company will invest 10,000 curos in renewing an old machine. The machine is paid in two regular instalments, in June and August. In February, the company recorded a revaluation of existing real estate assets of 10,000 euros. - Only half of the cash balance in the 2022 balance sheet is functional to the company's operations. Therefore, in January, the company uses the remaining half of the cash balance to reduce debt. - 500 euros dividends will be paid in September. - The company plans to repay an instalment of 10,000 curos in April; the capital portion of the repaid loan is 7,000 euros. - The nominal annual interest rate for both active and passive interests is 6% and is paid every three months. Please complete the cash budget, income statement, balance sheet, and financial statement. Please create the cash flow statement for 2022 using the financial statement data provided in the "Long-Exercise 2" tab of the Excel file 30433 - Framework.xlsx. Exercise 1 - Cash budget Prepare the cash budget for Beta in 2023, knowing that: - The company's revenues are not subject to seasonality. The DSO for monthly sales from January to June is 60 days, while for the sccond half of the year is 120 days. in addition, the company collects 2022 account receivables uniformly in the first four months of 2023. - Monthly purchases of raw materials amount to 55\% of May and June monthly sales and 40% in all other months of the year. In January, February, and March 2023, payments are deferred by 90 days, while for the remaining months of the year (April-Deccmber) they are deferred by 75 days. Account payables in 2022 amount to 18,000 curos, of which 3,000 curos relate to debts arising in December 2022 and the rkmaining part in November 2022. The DPO for 2022 was 60 days. - General expenses are paid monthly and they amount to 10% of monthly purchaser. - In the personnel cost, the company records severance payment provisions of 600 curos. The company pays salaries in fourteen regular instalments, two of which are puid in June and two in December. In addition, in May 2022, an cmployee left the company; therefore, in July, the company pays the employee's severance of 200 euros. - Ending inventory is equal to 30%6 of total purchases. - The tax rale is 30%, and taxes are paid the following year. Taxes for 2022 will be paid in June, for a total of 325 curos. - In 2023, the company will invest 10,000 curos in renewing an old machine. The machine is paid in two regular instalments, in June and August. In February, the coapany recordod a revaluation of existing real estate assets of 10,000 curos. - Only half of the cash balance in the 2022 bulance sheet is functional to the company's operations. Therefore, in January, the company uses the remaining half of the cach balance to reduce debt. - 500 curos dividends will be paid in September. - The company plans to repay an instalment of 10,000 curos in April; the capital portion of the repaid loan is 7,000 curos. - The nominal annual interest rate for both active and passive interests is 6% and is paid erery three months. Please complete the cash budget, income statement, balance sheet, and financial statement. Please create the cash flow statement for 2022 using the financial statement data provided in the "Long-Exercise 2" tab of the Excel file 30433 - Framework.xlsx. Exercise 1 - Cash budget Prepare the cash budget for Beta in 2023, knowing that: - The company's revenues are not subject to seasonality. The DSO for monthly sales from January to June is 60 days, while for the second half of the year is 120 days. In addition, the company collects 2022 account receivables uniformly in the first four months of 2023. - Monthly purchases of raw materials amount to 55% of May and June monthly sales and 40% in all other months of the year. In January, February, and March 2023, payments are deferred by 90 days, while for the remaining months of the year (April-December) they are deferred by 75 days. Account payables in 2022 amount to 18,000 euros, of which 3,000 euros relate to debts arising in December 2022 and the remaining part in November 2022. The DPO for 2022 was 60 days. - General expenses are paid monthly and they amount to 10% of monthly purchases. - In the personnel cost, the company records severance payment provisions of 600 euros. The company pays salaries in fourteen regular instalments, two of which are paid in June and two in December. In addition, in May 2022, an employee left the company; therefore, in July, the company pays the employee's severance of 200 euros. - Ending inventory is equal to 30% of total purchases. - The tax rate is 30%, and taxes are paid the following year. Taxes for 2022 will be paid in June, for a total of 325 curos. - In 2023 , the company will invest 10,000 curos in renewing an old machine. The machine is paid in two regular instalments, in June and August. In February, the company recorded a revaluation of existing real estate assets of 10,000 euros. - Only half of the cash balance in the 2022 balance sheet is functional to the company's operations. Therefore, in January, the company uses the remaining half of the cash balance to reduce debt. - 500 euros dividends will be paid in September. - The company plans to repay an instalment of 10,000 curos in April; the capital portion of the repaid loan is 7,000 euros. - The nominal annual interest rate for both active and passive interests is 6% and is paid every three months. Please complete the cash budget, income statement, balance sheet, and financial statement. Please create the cash flow statement for 2022 using the financial statement data provided in the "Long-Exercise 2" tab of the Excel file 30433 - Framework.xlsx