ngocdao27
Guest
- 31/3/15
- 4
- 0
- 1
- 32
Norton Company is an office supplies speciality store in Sydney. Recently, Daniel Davis, the manager of the store, has been concerned about cash flow shortages, which arose quite unexpectedly in the last three months of the past year. The store bank account went into overdraft and incurred interest charges. Davis believes that the main source of the cash flow difficulties is a lack of attention to outstanding customer accounts and the practice of purchasing office supplies in large quantities at irregular intervals. Actual sales for the last two months of 2014 and budgeted sales for 2015 follow (all sales are credit sales)
November (Actual) $200,000
December (Actual) $225,000
January $ 75,000
February $ 95,000
March $225,000
April $260,000
May $242,000
June $245,000
Experience has shown that of total sales, 50 per cent are collected in the month of sale, 20 per cent are collected in the following month, 20 per cent are collected two months after sale, and 10 per cent are uncollectible. In the budget year, new credit policies are expected to result in collections of 60 per cent in the month of sale, 20 per cent in the next month, 10 per cent are collected two months after sale and 10 per cent uncollectible.
The cost of office supplies was $50,000 in December and is budgeted as $400,000 for the first half of the year ($250,000 to be purchased in March and $150,000 to be purchased in May). Half of suppliers’ accounts are paid in the month they are incurred and half in the following month. Monthly salaries of $75,000, selling and
administrative expense of $40,000 and bank interest are paid in the month they are incurred. Bank overdraft as at 30 December 2014 was $200,000. The maximum credit limit of this overdraft facility is $500,000 and the applicable interest 18% per annum. The monthly interest on the overdraft is calculated on the overdraft balance at the beginning of the month. You are required to prepare a report to the manager of Norton Company showing the following:
1) The effect on the cash flows for the period from 1stJanuary to 30th June and the total amount to be
collected from the customers (Account Receivables) as at 30 June 2015.
2) Net profit before tax for the period from January to June, assuming that there was no beginning or ending
inventories. Ignore tax.
3) What steps the manager could take to ensure that the cash balance of the store remains positive and the ways in which budgeting may assist the company.
Tớ chỉ muốn hỏi phần cash flow của câu 2. Tớ đã tính được cash collection từ tháng 1 và tháng 6 là như sau
January: 130,000
February: 117,000
March: 161,500
April: 210,500
May: 219,700
June: 221,400
Đây là bảng cash flow. Tớ biết nó chưa chuẩn xác, mong mọi người giúp chỉ ra lỗi sai:
http://www.mediafire.com/view/w19hxyqy62vmeto/Cash_flow.png
Xin lỗi mọi người chịu khó down file từ đường link trên để xem bài của tớ. Tớ thắc mắc là:
- Theo tớ hiểu 200000 (overdraft) được coi là begining cash balance cho tháng 1. Nhưng mình còn phải tính ending cash balance cho tháng 12 để cộng cái này với 200000 ra tổng begining cash balance cho tháng 1?
- Khi coi 200000 là begining cash balance thì đến đoạn cuối có cần phải trừ net cash flow cho 200000 là overdraft này không để ra ending cash balance
- Cái overdraft interest giữ nguyên là 3000 (200000*18%/12) cho suốt thời gian hay khác nhau giữa từng tháng vì đề bài đề cập : The monthly interest on the overdraft is calculated on the overdraft balance at the beginning of the month
Tớ biết bài dài lại bằng tiếng anh nên làm khó mọi người nhưng Thật sự mong mọi người giúp đỡ. Cảm ơn!
November (Actual) $200,000
December (Actual) $225,000
January $ 75,000
February $ 95,000
March $225,000
April $260,000
May $242,000
June $245,000
Experience has shown that of total sales, 50 per cent are collected in the month of sale, 20 per cent are collected in the following month, 20 per cent are collected two months after sale, and 10 per cent are uncollectible. In the budget year, new credit policies are expected to result in collections of 60 per cent in the month of sale, 20 per cent in the next month, 10 per cent are collected two months after sale and 10 per cent uncollectible.
The cost of office supplies was $50,000 in December and is budgeted as $400,000 for the first half of the year ($250,000 to be purchased in March and $150,000 to be purchased in May). Half of suppliers’ accounts are paid in the month they are incurred and half in the following month. Monthly salaries of $75,000, selling and
administrative expense of $40,000 and bank interest are paid in the month they are incurred. Bank overdraft as at 30 December 2014 was $200,000. The maximum credit limit of this overdraft facility is $500,000 and the applicable interest 18% per annum. The monthly interest on the overdraft is calculated on the overdraft balance at the beginning of the month. You are required to prepare a report to the manager of Norton Company showing the following:
1) The effect on the cash flows for the period from 1stJanuary to 30th June and the total amount to be
collected from the customers (Account Receivables) as at 30 June 2015.
2) Net profit before tax for the period from January to June, assuming that there was no beginning or ending
inventories. Ignore tax.
3) What steps the manager could take to ensure that the cash balance of the store remains positive and the ways in which budgeting may assist the company.
Tớ chỉ muốn hỏi phần cash flow của câu 2. Tớ đã tính được cash collection từ tháng 1 và tháng 6 là như sau
January: 130,000
February: 117,000
March: 161,500
April: 210,500
May: 219,700
June: 221,400
Đây là bảng cash flow. Tớ biết nó chưa chuẩn xác, mong mọi người giúp chỉ ra lỗi sai:
http://www.mediafire.com/view/w19hxyqy62vmeto/Cash_flow.png
Xin lỗi mọi người chịu khó down file từ đường link trên để xem bài của tớ. Tớ thắc mắc là:
- Theo tớ hiểu 200000 (overdraft) được coi là begining cash balance cho tháng 1. Nhưng mình còn phải tính ending cash balance cho tháng 12 để cộng cái này với 200000 ra tổng begining cash balance cho tháng 1?
- Khi coi 200000 là begining cash balance thì đến đoạn cuối có cần phải trừ net cash flow cho 200000 là overdraft này không để ra ending cash balance
- Cái overdraft interest giữ nguyên là 3000 (200000*18%/12) cho suốt thời gian hay khác nhau giữa từng tháng vì đề bài đề cập : The monthly interest on the overdraft is calculated on the overdraft balance at the beginning of the month
Tớ biết bài dài lại bằng tiếng anh nên làm khó mọi người nhưng Thật sự mong mọi người giúp đỡ. Cảm ơn!
Sửa lần cuối bởi điều hành viên: