q4&5

D E F H L M N 0 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! All months are calculated with 30 days. Payment time for the purchases is 30 days. Salaries are 4500 /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 amortize the loan with 1000 Investments in new machinery is done in January 1 250 and in September 2850 C 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 benuary Mar April June y September Decer Total Sales 36.000 48.000 42.000 48,000 174000 Purchase 15,840 21,120 18.480 21.120 70500 Contribut 20160 26880 23520 26880 97440 Salaries 54.000 Rent 300 Depreciate 2500 interest 1500 Totaled 88,000 9440 CASH FLOW Mary MadAuristerber December Beginning cash balance Shot Sheet Number Fun les A B D F G H 28 29 K M N N 0 30 31 32 33 14 35 36 37 38 39 40 41 42 43 44 45 CASH FLOW Buhuary - Mar April - Jundy - September-December Beginning cash balance 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 46 47 48 49 How much loan does the company have at the end of the year? 50 How much accounts receivable does the company have at the beginning of next year? 52 53 How much accounts payable does the company have at the beginning of next year