Manage Finance: Sales and Profit Budget, Cash Flow Analysis, and Internal Control

Running head: MANAGE FINANCE
Manage Finance
Name of the Student:
Name of the University:
Authors Note:

1MANAGE FINANCE
Table of Contents
Sales and Profit Budget...................................................................................................................1
Answer to Prompt Questions...........................................................................................................4
Answer to Question 1:.....................................................................................................................4
Answer to Question 2:.....................................................................................................................5
Answer to Question 3:.....................................................................................................................5
Answer to Question 4:.....................................................................................................................6
Answer to Question 5:.....................................................................................................................6
Answer to Question 6:.....................................................................................................................7
Answer to Question 7:.....................................................................................................................7
Answer to Question 8:.....................................................................................................................8
Reference.........................................................................................................................................9

2MANAGE FINANCE
Sales and Profit Budget
– Insurance $13,390 $3,348 $3,348 $3,348
– Store Supplies $3,749 $937 $937 $937
– Advertising $350,000 $200,000 $50,000 $50,000
– Cleaning $16,282 $3,256 $3,908 $4,233
$64,272 $16,068 $16,068 $16,068
– Rent $2,640,508 $660,127 $660,127 $660,127
– Telephone $14,997 $2,999 $3,599 $3,899
– Electricity Expense $26,780 $5,356 $6,427 $6,963
– Luxury Car Tax $12,000 $12,000 $0 $0
– Fringe Benefits Tax $28,000 $7,000 $7,000 $7,000
– Superannuation $187,020 $37,404 $44,885 $48,625
– Wages & Salaries $2,078,000 $415,600 $498,720 $540,280
– Payroll Tax $98,705 $19,741 $23,689 $25,663
$41,560 $8,312 $9,974 $10,806
Total Expenses $5,841,371 $1,458,676 $1,395,209 $1,444,476
Net Profit (Before Tax) $1,456,261 $851 $356,222 $452,908
Income Tax $436,878 $255 $106,867 $135,872
Net Profit $1,019,383 $596 $249,356 $317,036
Computation of Sales Growth Rate
Year Sales Sales growth % growth
2011-12 12,474,336
2012-13 13,472,315 997,979 8%
2013-14 14,550,100 1,077,785 8%
2014-15 15,714,108 1,164,008 8%
AVG 8%
– Repairs &
Maintenance
– Workers’
Compensation
Table 1: Sales and Profit Budget
(Source: Created by Author)