Answered step by step
Verified Expert Solution
Question
1 Approved Answer
YR Figures Mth Figures GST Included Income Statement Budget for next year Revenue $252,000 Increase by 65% $415,800 $138,600 Cost of Goods Sold Pruning $24,720
YR Figures Mth Figures GST Included Income Statement Budget for next year Revenue $252,000 Increase by 65% $415,800 $138,600 Cost of Goods Sold Pruning $24,720 Increase by 2% $25,214 $25,214 Aug Only Fertiliser $52,550 Increase by 2.5% $53,864 $26,932 1/2 Oct & Nov $29,625 Pickers $15,350 $92,620 5% of revenue $20,790 $6,930 Gross Profit $159,380 $99,868 Operating Expenses Selling Expenses Cartage $4,420 2% of revenue $8,316 $2,772 $3,049.20 Salesman Salary $20,000 $24,420 No change $20,000 $10,000 Feb & Mar Administration Expenses Orchard Manager Salary $60,000 Increase by 5% $63,000.00 $5,250 Orchard Staff Salaries $80,000 Increase by 2% $81,600.00 $6,800 Utilities $10,380 Increase by 4% $10,795.20 $900 $989.56 Rates $5,210 Increase by 2% $5,314 $443 $487.14 Repairs/Maintenance $14,870 Decrease by 15% $12,640 $1,053 $1,158.62 Deprecation Equipment $20,000 $190,460 20% diminishing value $16,000 $1,333 Financial Expenses Bank Fees $990 $990 Increase by 10% $1,089 $91 Net Profit -$56,490 TOTALS $834,290 $226,318 Balance Sheet Current Assets Cash $4,810 Accounts Receivable $84,000 Fertiliser (Purchases) $5,000 $93,810 Non-Current Assets Land $2,400,000 Buildings $460,000 Equipment $250,000 Accumulated Depreciation Equipment -$170,000 $80,000 $2,940,000 Total Assets $3,033,810 Current Liabilities GST Payable $1,630 $1,630 Net Assets $3,032,180 Capital Opening Capital $ 3,088,670 -$ 56,490 $ 3,032,180 BANK LOAN 10000 600
YR Figures | Mth Figures | GST Included | ||||||
Income Statement | Budget for next year | |||||||
Revenue | $252,000 | Increase by 65% | $415,800 | $138,600 | ||||
Cost of Goods Sold | ||||||||
Pruning | $24,720 | Increase by 2% | $25,214 | $25,214 | Aug Only | |||
Fertiliser | $52,550 | Increase by 2.5% | $53,864 | $26,932 | 1/2 Oct & Nov | $29,625 | ||
Pickers | $15,350 | $92,620 | 5% of revenue | $20,790 | $6,930 | |||
Gross Profit | $159,380 | $99,868 | ||||||
Operating Expenses | ||||||||
Selling Expenses | ||||||||
Cartage | $4,420 | 2% of revenue | $8,316 | $2,772 | $3,049.20 | |||
Salesman Salary | $20,000 | $24,420 | No change | $20,000 | $10,000 | Feb & Mar | ||
Administration Expenses | ||||||||
Orchard Manager Salary | $60,000 | Increase by 5% | $63,000.00 | $5,250 | ||||
Orchard Staff Salaries | $80,000 | Increase by 2% | $81,600.00 | $6,800 | ||||
Utilities | $10,380 | Increase by 4% | $10,795.20 | $900 | $989.56 | |||
Rates | $5,210 | Increase by 2% | $5,314 | $443 | $487.14 | |||
Repairs/Maintenance | $14,870 | Decrease by 15% | $12,640 | $1,053 | $1,158.62 | |||
Deprecation Equipment | $20,000 | $190,460 | 20% diminishing value | $16,000 | $1,333 | |||
Financial Expenses | ||||||||
Bank Fees | $990 | $990 | Increase by 10% | $1,089 | $91 | |||
Net Profit | -$56,490 | |||||||
TOTALS | $834,290 | $226,318 | ||||||
Balance Sheet | ||||||||
Current Assets | ||||||||
Cash | $4,810 | |||||||
Accounts Receivable | $84,000 | |||||||
Fertiliser (Purchases) | $5,000 | $93,810 | ||||||
Non-Current Assets | ||||||||
Land | $2,400,000 | |||||||
Buildings | $460,000 | |||||||
Equipment | $250,000 | |||||||
Accumulated Depreciation Equipment | -$170,000 | $80,000 | $2,940,000 | |||||
Total Assets | $3,033,810 | |||||||
Current Liabilities | ||||||||
GST Payable | $1,630 | $1,630 | ||||||
Net Assets | $3,032,180 | |||||||
Capital | ||||||||
Opening Capital | $ 3,088,670 | |||||||
-$ 56,490 | $ 3,032,180 | |||||||
BANK LOAN | 10000 | 600 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started