70.2K

Verified Solution

Link Copied!

Below you see the income budget for Company Inc. 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! AII 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 300 At the same time with paying the interest we amortize the loan with 1 000 Investments in new machinery is done in January 1 250 and in September 2 850 . 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. April-June Total Income budget Sales Purchase Contribution margin January- March 36 000 15 840 20160 July- September 42 000 18 480 October December 48 000 21 120 48 000 21 120 174000 76560 26880 23520 26880 97440 54 000 30000 2500 1500 Salaries |Rent Depreciation Interest Total fixed costs Budgeted result 88 000 9440 CASH FLOW BUDGET Beginning cash balance January March April - June July September October December Sales Acc. Receivable Loan (short- term) Total Purchase Acc. Payable Salaries Rent Interest Amortization (long-term) Investments Private withdrawal Amortization (short-term) Total Net cash flow April-June Total budget Sales Purchase Contribution margin March 36 000 15 840 48 000 21 120 September 42 000 18 480 December 48 000 21 120 174000 76560 20160 26880 23520 26880 97440 Salaries Rent Depreciation Interest Total fixed costs Budgeted result 54 000 30000 2500 1500 88 000 9440 Janury- March April - June July September October December CASH FLOW BUDGET Beginning cash balance Sales Ace. Receivable Lean (short- term Total Purchase Ace. Payable Salaries Rent Interest Amortization (long-term) Investments Private withdrawal Amortization (short-term) Total Net cash flow How much does the hawa of the year? receivable des the y have the How payabled the have at the be

Answer & Explanation Solved by verified expert

See Answer