Budget Notesi. Analysis of the past cash flow trendsDebtor ageing summary
Aged Debtors Budget
Aged Debtors Budget
Total
Qtr 1
Qtr 2
Qtr 3
Qtr 4
Sales
$ 1,69,71,237
$ 33,94,247
$ 40,73,097
$ 44,12,522
$ 50,91,371
% Debtors sales
20.0%
20.0%
20.0%
20.0%
Total debtors
100%
$ 6,78,849
$ 8,14,619
$ 8,82,504
$ 10,18,274
Current (84%)
84%
$ 5,70,234
$ 6,84,280
$ 7,41,304
$ 8,55,350
30 Days (10%)
10%
$ 67,885
$ 81,462
$ 88,250
$ 1,01,827
60 Days (5%)
5%
$ 33,942
$ 40,731
$ 44,125
$ 50,914
90 Days (1%)
1%
$ 6,788
$ 8,146
$ 8,825
$ 10,183
Debtor Ageing Ratio
Particulars
2009/10
2010/11
2011/12
Trade Debtors
$ 8,50,000.00
$ 9,75,000.00
$ 33,94,247.33
Sales
$ 1,45,50,100.00
$ 1,57,14,108.00
$ 1,69,71,236.64
Debtor Days
21.32
22.65
73
The debtor days ratio measures how quickly cash is being collected from debtors. The longer ratio shows the greater number of days in collecting from debtors like customers.
Based on the above table, it can be determined that there is an increase in debtor days as company is adopting lenient policy for the customers by allowing them to pay their liabilities on longer duration.
However, it may cause an increase in number of customers due to longer debtor days but it may also cause lack of cash within the firm. It is because the delayed payment collection may affect the cash position of the firm that may influence its routine operations.
ii. Identify & explain reasons for previous profits and losses
Based on internal analysis and PEST, it can be stated that sales growth may be possible due to effective sales and marketing efforts of Houzit.
Apart from this, better capacity of the company in terms of cost reduction through introduction of advanced technologies may also help the firm to keep operational cost low and enhance profitability. Favourable political policies and increasing disposable income of people may also help to increase the demand of the products of the firm and contribute to its sales and profits growth.
In addition, the focus of the firm on customer satisfaction and innovation in the products may also raise the demand of the products of company that may contribute to sales and profits of the firm.
iii. Critical dates and initiatives
31-12-2011 – Amount of $100,000 paid for loan
2011-2012 – Increase in advertisement budget by $70,000
2011-2012- Increase in wages and salaries by $172,500
Cash flow effect of the GST payable per quarter to be prepared (scheduled compliance payment date is the 21st day after the end of the quarter)
iv. All financial bids, estimates, assumptions and basis
Luxury car tax rate at 33% based on sales ratio Insurance, repairs and maintenance, Rent – apportioned equally in each quarter.
Store supplies, cleaning, Telephone and Electricity, Wages and salaries using the same % as determined by the sales for each quarter.
Cost of goods sold is the inverse of the gross profit rate
Accounting fees, interest charges, bank charges paid equally in each quarter.
Sales growth 8% annually
% Debtors of total sales: 20%
Sales in quarters 2011/12 in the same % as sales 2010/11
GST collected at 10% of sales
GST paid at 10% of particular expenses
Depreciation same as 2011 and allocated equally in each quarter.
Advertising is to be apportioned to each quarter based on the business plan.
Inflation rate 4% affecting expenses
Same fringe benefits tax as 2011 and paid equally each quarter.
The statutory requirements are:
Superannuation: 9% of wages and salaries for each quarter
Payroll tax: 4.75% of wages and salaries for each quarter
Workers compensation: 2% of wages and salaries for each quarter
Tax rate 30%
v. Implementation and monitoring of budget expenditure
Proper meetings and time to time update are significant to monitor the budget expenditures while dealing with sensitive information. Comparison between actual and forecasted budget is also significant to monitor budget expenditure.
vi. Current statutory requirements and the tax liabilities
For tax compliance, the current statutory requirements incorporate superannuation at 9%, worker compensation at2% and payroll tax at4.75% of wages and salaries for each quarter. In addition, tax rate is 30% of net profit after tax.
For complying tax related statutory requirements, it is required to prepare three monthly rolling forecast of cash flows. The calculation of the tax liabilities for Houzit Pty Ltd is as follows:
2011/12
Q1
Q2
Q3
Q4
Net Profit (Before Tax)
$1456427
$10672
$353420
$449794
$642542
Income Tax (30%)
$436928
$3201
$106026
$134938
$192763
vii. Financial management software
The current financial management software system does not provide sufficient analysis of revenue and expenditure. This makes it difficult for making informed estimates of future profits. For this, the following software can be used by the firm:
Basic features + additional features on tailored pricing
OS Supported
All OS supported
All OS supported
Available Support
Support through phone and live and training
Support through phone and live
Free trial
No
30-day free trial
Language
USA
Different countries
(Source: Comparisons.financeonline.com, 2017)
QuickBooks Online can be recommended due to its cost effectiveness, availability in different languages and requirement of only basic features plus additional features based on tailored pricing.
viii. Effectiveness of the organisation’s existing financial management approaches
The existing financial management approaches are not effective due to inability to provide adequate financial information that lead to wrong decisions. Company is also based on the ‘gut feel’ of the experienced traders on the board and of the senior managers to estimate the financial performance.
Although, these approaches focus on the business activity statement (BAS) schedule regualted by the Australian Tax Office. In addition, it also considers security measures to store financial data.
ix. Items for inclusion in the budgets
Store supplies
Office expense
Luxury car tax
Water bills
Utilities
x. Internal controls
Authentication by the line manager
Signed or linked Service invoices for equipments to a purchase order
Checking process
Fix unique codes to assets
Feedback lines of communication
Monthly Debtor reconciliations
Allocation and segregation of duties
Knowledge Test questionsPrinciples of accounting and financial systems
Matching principle needs to be adopted in budget preparation due to matching revenues respective to expenses during a financial year.
Time periods principle is related to budget formation on monthly, quarterly and annual basis. Quarterly accounting is useful for internal stakeholders while annual accounting basis is crucial for the external stakeholders.
Requirements for financial probity while managing finance
Probity is valuable to implement and monitor the budget expenditure. It is also required to check ethical point of views regarding implementation and monitoring of budget expenditure.
Explain Australian, international and local legislation and conventions that are relevant to financial management in the organization
The Corporations Act 2001 is relevant to financial management of the company because it prepares disclosure reports, asset valuation and financial report.
It complies with requirement of preparing general ledger for business transactions, cash records including bank statements, sales and purchase records, inventory records, goods and returns tax, superannuation records, payroll tax and tax returns with calculations.
Current liability, fringe benefits tax for non-cash benefits and income tax are levied on earnings which need to paid by the company.
Requirements
Goods and Services Tax:
GST turnover of $75,000 or more
Non-profit organisation (turnover of $150,000 yearly or more)
awesome