New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!Order Now

BSBFIM601 Manage Finances

Published : 18-Oct,2021  |  Views : 10

Question:

Analyse the case study information and write summery of the current status of the company.Analyse the case study information (including business plan summary and previous financial data) and complete the following.Sales and Profit budget (including detailed expenses) budget for 2011/12 by department by quarter.
 
Develop budget notes/comments which include:identification of reasons for previous profits and losses your comment on the effectiveness of existing financial management approaches all assumptions and basis that have been made or used to form budgets any relevant notes regarding implementation and monitoring of budget expenditure.
 
Identify the current statutory requirements for tax compliance and list and calculate the tax liabilities for Houzit Pty Ltd under taxation legislation.Identify the current compliance requirements and liabilities for this organisation under the Corporations Act 2001.Review commercially available financial management software to select the most suitable software for Houzit Pty Ltd. and outline the reasons that lead you to this recommendation.

Answer:

Houzit Pty Ltd is located in Brisbane and they are running retail chain of 15 stores. They are the leader in the retail sector of home ware and provide the new and renovated furnishing all over the Greater Brisbane area. over the past five years they have grown from a single store to the 15 chain store. They are well known for their superior after sales service and this is the crucial reason behind their growth in sales and increase in profit.

Financial statements

  1. Sales and profit budget

Particulars

2015/16

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Sales

 $    16,814,136.02

 $    3,362,827.63

 $    4,035,392.73

 $    4,371,675.28

 $      5,044,240.38

(-) Cost of Goods Sold

 $      9,151,896.00

 $    1,830,379.43

 $    2,196,455.09

 $    2,379,492.91

 $      2,745,568.57

Gross Profit

 $   7,662,240.02

 $ 1,532,448.20

 $ 1,838,937.64

 $ 1,992,182.37

 $  2,298,671.81

Gross Profit %

46%

46%

46%

46%

46%

 Accounting Fees

 $           10,000.00

 $           2,500.00

 $           2,500.00

 $           2,500.00

 $             2,500.00

 Interest Expenses

 $           84,508.00

 $         21,127.00

 $         21,127.00

 $         21,127.00

 $           21,127.00

 Bank Charges

 $             1,200.00

 $              300.00

 $              300.00

 $              300.00

 $                300.00

 Depreciation

 $         170,000.00

 $         42,500.00

 $         42,500.00

 $         42,500.00

 $           42,500.00

 Insurance

 $           13,390.00

 $           3,347.50

 $           3,347.50

 $           3,347.50

 $             3,347.50

 Store Supplies

 $             3,749.20

 $              749.84

 $              899.81

 $              974.79

 $             1,124.76

 Advertising

 $         350,000.00

 $       200,000.00

 $         50,000.00

 $         50,000.00

 $           50,000.00

 Cleaning

 $           16,282.24

 $           3,256.45

 $           3,907.74

 $           4,233.38

 $             4,884.67

 Repairs & Maintenance

 $           64,272.00

 $         16,068.00

 $         16,068.00

 $         16,068.00

 $           16,068.00

 Rent

 $      2,640,508.00

 $       660,127.00

 $       660,127.00

 $       660,127.00

 $         660,127.00

 Telephone

 $           14,996.80

 $           2,999.36

 $           3,599.23

 $           3,899.17

 $             4,499.04

 Electricity Expenses

 $           26,780.00

 $           5,356.00

 $           6,427.20

 $           6,962.80

 $             8,034.00

 Fringe Benefits Tax

 $           28,000.00

 $           7,000.00

 $           7,000.00

 $           7,000.00

 $             7,000.00

 Superannuation

 $         187,020.00

 $         37,404.00

 $         44,884.80

 $         48,625.20

 $           56,106.00

 Wages & Salaries

 $      2,078,000.00

 $       415,600.05

 $       498,720.01

 $       540,279.99

 $         623,399.95

 Payroll Tax

 $           93,510.00

 $         18,702.00

 $         22,442.40

 $         24,312.60

 $           28,053.00

 Workers Compensation

 $           41,560.00

 $           8,312.00

 $           9,974.40

 $         10,805.60

 $           12,468.00

Total Expenses

 $      5,830,358.24

 $    1,451,931.21

 $    1,393,825.09

 $    1,443,063.03

 $      1,541,538.91

Net Profit (Before Tax)

 $      1,831,881.78

 $         80,516.99

 $       445,112.55

 $       549,119.34

 $         757,132.90

Income Tax

 $         549,564.53

 $         24,155.10

 $       133,533.77

 $       164,735.80

 $         227,139.87

Net Profit

 $   1,282,317.25

 $      56,361.89

 $    311,578.79

 $    384,383.54

 $      529,993.03

Cash flow analysis – GST

Cash Flow Analysis - GST

2015/16

Quarter 1

Quarter 2

Quarter 3

Quarter 4

GST Collected

 $      1,681,413.60

 $     336,282.76

 $      403,539.27

 $    437,167.53

 $      504,424.04

Accounting Fees

 $             1,000.00

 $            250.00

 $             250.00

 $           250.00

 $             250.00

Insurance

 $             1,339.00

 $            334.75

 $             334.75

 $           334.75

 $             334.75

Store supplies

 $                374.92

 $              74.98

 $               89.98

 $             97.48

 $             112.48

Advertise

 $           35,000.00

 $       20,000.00

 $          5,000.00

 $        5,000.00

 $          5,000.00

Cleaning

 $             1,628.22

 $            325.64

 $             390.77

 $           423.34

 $             488.47

Repair & Maintenance

 $             6,427.20

 $         1,606.80

 $          1,606.80

 $        1,606.80

 $          1,606.80

Rent

 $         264,050.80

 $       66,012.70

 $        66,012.70

 $      66,012.70

 $        66,012.70

Telephone

 $             1,499.68

 $            299.94

 $             359.92

 $           389.92

 $             449.90

Electricity Expense

 $             2,678.00

 $            535.60

 $             642.72

 $           696.28

 $             803.40

(-) Total GST Paid

 $         314,656.02

 $       90,098.61

 $        74,687.65

 $      74,811.26

 $        75,058.50

GST Payable

 $  1,366,757.58

 $  246,184.15

 $   328,851.63

 $ 362,356.26

 $   429,365.54

Debtors ageing analysis

Particulars

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Sales

 $3,362,827.63

 $ 4,035,392.73

 $  4,371,675.28

 $ 5,044,240.38

% Debtors Sales

20%

20%

20%

20%

Total Debtors

 $   672,565.53

 $    807,078.55

 $     874,335.06

 $ 1,008,848.08

Current

 $   564,955.04

 $    677,945.98

 $     734,441.45

 $    847,432.38

30 Days

 $     67,256.55

 $      80,707.85

 $       87,433.51

 $    100,884.81

60 Days

 $     33,628.28

 $      40,353.93

 $       43,716.75

 $      50,442.40

90 Days

 $       6,725.66

 $        8,070.79

 $         8,743.35

 $      10,088.48

Budget notes:

The main issue related to the budget is that the performance of Houzit greatly depended on their gross margin viability and maintenance of finance. The impact on the retail segment is biggest as the company is going through the recession period. however, the revenue from sales are in a growing trend and that is visible from the budget. To achieve the level of sales the company is spending a big amount towards discounts. The fluctuating interest rate is also affecting the company adversely. Moreover, the payment term of debtors also working as a barrier for the cash flow.

Statutory requirements for tax compliance:

Houzit is liable to pay 4.75% on the the total wages as the payroll tax if the amount exceeds $850,000. Moreover, the organization is liable to pay a fringe benefit tax and luxury car tax that are charged by the Australian government to minimize the dishonest activities taken up by the firm. The tax rate applicable on the luxury car is 33% as prescribed by the Australian government.  

Calculation of tax

Particulars

2015/16

Quarter 1

Quarter 2

Quarter 3

Quarter 4

 Wages & Salaries

 $         342,500.00

 $   415,600.05

 $      498,720.01

 $      540,289.99

 $     623,399.95

Superannuation tax

 $        30,825.00

 $  37,404.00

 $     44,884.80

 $    48,626.10

 $    56,106.00

Payroll tax

 $        16,268.75

 $  19,741.00

 $     23,689.20

 $    25,663.77

 $    29,611.50

company tax

 $  1,055,116.73

 $  16,908.57

 $     93,473.64

 $  115,315.06

 $ 158,997.91

Total tax

 $  1,102,210.48

 $  74,053.57

 $   162,047.64

 $  189,604.94

 $ 244,715.40

Compliance under Corporation Act 2001:

Under the Corporation Act 2001, the Australian firms are required to comply with the following regulations:

  • The financial statement of the company must be prepared with respect to the accounting standards.
  • The firm is liable to state the actual financial records of the firm to the debtors, which will enable the debtors to understand their financial viability
  • The capital of the firm must be utilized in an efficient manner to pay off their liabilities

 Appropriate software for Houzit Pty Ltd

The current software that are used by the firm are not able to provide the sufficient analysis of expenses and revenues and made the estimation of profits tough for the company. Therefore they want to use any other software or upgrade the existing software for better management of the accounts over the long run. One option is to use the MYOB software as Houzit is a small business firm. This is a cheap and easy to install in simple situations. Moreover, it has low risk of failure and back-up is easy.

 Critical dates for generating resources in the next financial year

The most appropriate time for preparing the budget for next financial year is just after the publication of previous year’s financial year. It will give an idea about the income and expenses from the last year’s record. The proposal could be as follows:

  • The budget may be prepared with the newly installed software that will be useful for preparing more accurate budget.
  • The accounts are suggested to take the assumptions more appropriately to minimize the gap between the actual and budget and turn the unfavourable variances into favourable.

Recommendation for new budget

  • Increasing the privacy and safety level to minimize the exploitation in preparation of budget.
  • Implementation of proper authorization to access the budget will improve the conrol level.
  • The budget must be prepared taking into consideration the previous year’s result, so that, the budget can be prepare more realistically.
  • The budget must be prepared through the implementation of an system of accounting that will enable to prepare the budget accurately and easily.

List of modified internal control to maintain the audit trail

Audit trail is the system through which the transactions related to the items of accounting records are traced. To maintain the internal control, the following things are recommended:

  • Audits must be carried out physically on the available stocks of the company to prevent the theft of stocks
  • Duties of maintenance of records and preparation of financial statements must be segregated among two or most employees to minimize the manipulation of data.
  • All the transaction must be documented properly to have access at the time of requirement.
  • The financial record must be reconciled regularly to detect the loopholes in theinitial stages
  • The access over the financial records must be allowed after proper authorization from the approval authority.

References

Akinboade, Oludele Akinloye, and Mandisa Putuma Mokwena. "Understanding the tax compliance culture of private sector tax practitioners in South Africa." Journal of Economics and Behavioral Studies 6.3 (2014): 202.

Andre, Sean M., Marco Lam, and Mark O'Donnell. "budgetary slack: exploring the effect of different types, directions, and repeated attempts of influence tactics on padding a budget." Academy of Accounting and Financial Studies Journal 20.3 (2016): 147.

Berman, Larry. The Office of Management and Budget and the presidency, 1921-1979. Princeton University Press, 2015.

Chen, Cellina. "For personal use only." Change (2015).

Curtis, Veechi. MYOB Software for Dummies-Australia. John Wiley & Sons, 2015.

De Simone, Lisa, Matthew S. Ege, and Bridget Stomberg. "Internal control quality: The role of auditor-provided tax services." The Accounting Review 90.4 (2014): 1469-1496.

Hassan, Nadiah, Mohd Mohid Rahmat, and Zakiah Muhammaddun Mohamed. "Internal Control Systems, Management Support and Public Sector Internal Audit Effectiveness In Malaysia." ASIAN JOURNAL OF ACCOUNTING AND GOVERNANCE 6 (2015): 1-12.

Salim, Emil, et al. "The Influence of Myob Accounting Softwareonthe Performance of Company Financial Report." UPI YPTK Journal of Business and Economics 1.1 (2016): 75-84.

Get An Awesome Price Quote For Your Paper – Absolutely FREE!
    Add File
    Files Missing!

    Please upload all relevant files for quick & complete assistance.

    Our Amazing Features

    delivery

    No missing deadline risk

    No matter how close the deadline is, you will find quick solutions for your urgent assignments.

    work

    100% Plagiarism-free content

    All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.

    time

    500+ subject matter experts

    Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.

    subject

    Covers all subjects

    We offer academic help services for a wide array of subjects.

    price

    Pocket-friendly rate

    We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.

    Getting started with MyEssayAssignmentHelp is FREE

    15,000+ happy customers and counting!

    Rated 4.7/5 based on
    1491 reviews
    ;