can you give me the function or formular to caculate each part of this problems

Below you see the income budget for Company Ine. Use the information to fill in the cash flow budget and answer the questions. (20p) Beginning cash balance 5 600. Accounts payable from the previous year 5 750 and accounts receivable from the previous year 8 900 Half of the sales are credit sales with the payment time of 30 days The other half is in cash. Sales and purchases are divided equally on all the days of the period. NOTE! All months are calculated with 30 days. Payment time for the purchases is 30 days. Salaries are 4 500 /month Rent is 2 500 month In the beginning of the year the company has a bankloan of 25 000 . Interest is payed in March 500 . in September 500 and in December 500 At the same time with paying the interest we arbortare the loan with 1 000 Investments in new machinery is done in January 1 250 and in September 2850 If we don't have enough money we can get a short-term loan from the bank. Always round up to the next 1000 . The loan is payed back as soon as we have the money. The owner makes a private withdrawal 1 500 each month Income budget January March April-June July-September October-December Sales 36 42 48 Purchase 21,12 Contribution marg 20160 26880 Salari Rest Depreciation Interest Tot fired Bated result 15 84 48 21,12 2637 18.48 23520 April June July-September October-December CASH FLOW BUDDET March Reginning cash balance Sales Aos Receivable Lean(shem Total Purchase Ace Payable Salaries Romi Interest Amandlange Investments Private withdrawal Amor short Total Net cast the How much loan does the company have at the end of the year! How much accounts receivable does the company have at the beginning of next year? How much accounts payable does the cottipany have at the beginning of next year? If we don't have enough money we can get a short-term loan from the ank. Always round up to the next 1000 . The loan is payed back as soon as we - The owner makes a private withdrawal 1 500 each month. Income budget January March April-June July-September October December Total Sales 36,000 48.000 42,000 48,000 174000 Purchase 15,840 21,120 18.480 21,120 76560 Contribution margin 20160 26880 23520 26880 97440 Salaries 54,000 Rent 30000 Depreciation 2500 interest 1500 Total fixed costs 80,000 Audgeted result 9440 CASH FLOW BUDGET Beginning cash balance Sales Acc. Receivable Loan (short-term) Total January - March 5,600 18,000 8.900 April June 21.940 48.000 18,000 July-September 73,860 42.000 48,000 October December 151.540 48.000 42.000 32.500 87,940 163,860 241,540 .. Below you see the income budget for Company Inc. Use the information to fill in the cash flow budget and answer the qu 2 3 5 6 7 5 Beginning cash balance 5 Accounts payable from the previous year 5 750 and accounts receivable from the p Half of the sales are credit sales with the payment time of 30 days. The Sales and purchases are divided equally on all the days of the period. NOTE! All months are calcule Payment time for the purchases is 30 day Salaries are 4 500 /month Rent is 2 500 month In the beginning of the year the company has a bankloan of 25 000 . Interest is payed in March 500 1 September 500 ani At the same time with paying the interest we amortize the loa Investments in new machinery is done in January 1 250 and in Septe If we don't have enough money we can get a short-term loan from the bank. Always round up to the next 1000 . The loan is payed back as soon as we have ! - The owner makes a private withdrawal 1 500 each month T 14 15 17 20 21 22 Income budget January-March Sales 36 Purchase 15,84 Contribution mi 20160 April-June 28 21.12 26BBD July-Septemberctober Decembe 42 45 18.48 21.12 23520 26880 24 25 Total 174000 75550 97440 54 30000 2500 1500 88 20 27 21 Rent Depreciation Interest Totaled costs Budgeted result 22 30 31 32 13 April July-September betober December 34 35 37 30 0 41 CASH FLOW BUDGE January March Beginning cash balance Sales Acc Receivable Loen Ishort termi Total Purchase Ace Payable Salaries Rent interest Amortation long-term Investments Private withdrawal Amortization thort term Total Net cash flow 2 4 es 47 50 55 52 How much loan does the company have at the end 53 54 66 SA How much accounts receivable does the company have at the begin 3SS63&S 57 How much accounts payable does the company have at the beginnin 50 Below you see the income budget for Company Ine. Use the information to fill in the cash flow budget and answer the questions. (20p) Beginning cash balance 5 600. Accounts payable from the previous year 5 750 and accounts receivable from the previous year 8 900 Half of the sales are credit sales with the payment time of 30 days The other half is in cash. Sales and purchases are divided equally on all the days of the period. NOTE! All months are calculated with 30 days. Payment time for the purchases is 30 days. Salaries are 4 500 /month Rent is 2 500 month In the beginning of the year the company has a bankloan of 25 000 . Interest is payed in March 500 . in September 500 and in December 500 At the same time with paying the interest we arbortare the loan with 1 000 Investments in new machinery is done in January 1 250 and in September 2850 If we don't have enough money we can get a short-term loan from the bank. Always round up to the next 1000 . The loan is payed back as soon as we have the money. The owner makes a private withdrawal 1 500 each month Income budget January March April-June July-September October-December Sales 36 42 48 Purchase 21,12 Contribution marg 20160 26880 Salari Rest Depreciation Interest Tot fired Bated result 15 84 48 21,12 2637 18.48 23520 April June July-September October-December CASH FLOW BUDDET March Reginning cash balance Sales Aos Receivable Lean(shem Total Purchase Ace Payable Salaries Romi Interest Amandlange Investments Private withdrawal Amor short Total Net cast the How much loan does the company have at the end of the year! How much accounts receivable does the company have at the beginning of next year? How much accounts payable does the cottipany have at the beginning of next year? If we don't have enough money we can get a short-term loan from the ank. Always round up to the next 1000 . The loan is payed back as soon as we - The owner makes a private withdrawal 1 500 each month. Income budget January March April-June July-September October December Total Sales 36,000 48.000 42,000 48,000 174000 Purchase 15,840 21,120 18.480 21,120 76560 Contribution margin 20160 26880 23520 26880 97440 Salaries 54,000 Rent 30000 Depreciation 2500 interest 1500 Total fixed costs 80,000 Audgeted result 9440 CASH FLOW BUDGET Beginning cash balance Sales Acc. Receivable Loan (short-term) Total January - March 5,600 18,000 8.900 April June 21.940 48.000 18,000 July-September 73,860 42.000 48,000 October December 151.540 48.000 42.000 32.500 87,940 163,860 241,540 .. Below you see the income budget for Company Inc. Use the information to fill in the cash flow budget and answer the qu 2 3 5 6 7 5 Beginning cash balance 5 Accounts payable from the previous year 5 750 and accounts receivable from the p Half of the sales are credit sales with the payment time of 30 days. The Sales and purchases are divided equally on all the days of the period. NOTE! All months are calcule Payment time for the purchases is 30 day Salaries are 4 500 /month Rent is 2 500 month In the beginning of the year the company has a bankloan of 25 000 . Interest is payed in March 500 1 September 500 ani At the same time with paying the interest we amortize the loa Investments in new machinery is done in January 1 250 and in Septe If we don't have enough money we can get a short-term loan from the bank. Always round up to the next 1000 . The loan is payed back as soon as we have ! - The owner makes a private withdrawal 1 500 each month T 14 15 17 20 21 22 Income budget January-March Sales 36 Purchase 15,84 Contribution mi 20160 April-June 28 21.12 26BBD July-Septemberctober Decembe 42 45 18.48 21.12 23520 26880 24 25 Total 174000 75550 97440 54 30000 2500 1500 88 20 27 21 Rent Depreciation Interest Totaled costs Budgeted result 22 30 31 32 13 April July-September betober December 34 35 37 30 0 41 CASH FLOW BUDGE January March Beginning cash balance Sales Acc Receivable Loen Ishort termi Total Purchase Ace Payable Salaries Rent interest Amortation long-term Investments Private withdrawal Amortization thort term Total Net cash flow 2 4 es 47 50 55 52 How much loan does the company have at the end 53 54 66 SA How much accounts receivable does the company have at the begin 3SS63&S 57 How much accounts payable does the company have at the beginnin 50