Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Revenue Budget Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Revenue Budget | ||||||||||||||||||||||||||||
Quarter | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |||||||||||||||||||||||
Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||||||||||||||||
Hours | 150 | 200 | 180 | 200 | 100 | 50 | 50 | 100 | 50 | 50 | 50 | 100 | 1,280 | |||||||||||||||
Price | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | ||||||||||||||||
Revenue | $22,500 | $30,000 | $27,000 | $30,000 | $15,000 | $7,500 | $7,500 | $15,000 | $7,500 | $7,500 | $7,500 | $15,000 | 192,000 | |||||||||||||||
Quarter Total | $79,500 | $52,500 | $30,000 | $30,000 | 192,000 | |||||||||||||||||||||||
Revenue / Sales | May | June | ||||||||||||||||||||||||||
7700 | 11000 | |||||||||||||||||||||||||||
Accounts Receivable Collection Schedule | ||||||||||||||||||||||||||||
Quarter | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |||||||||||||||||||||||
Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||||||||||||||||
Revenue | $24,750 | $33,000 | $29,700 | $33,000 | $16,500 | $8,250 | $8,250 | $16,500 | $8,250 | $8,250 | $8,250 | $16,500 | $211,200 | |||||||||||||||
GST | $2,250 | $3,000 | $2,700 | $3,000 | $1,500 | $750 | $750 | $1,500 | $750 | $750 | $750 | $1,500 | $19,200 | |||||||||||||||
Collections @ 50% | $12,375 | $16,500 | $14,850 | $16,500 | $8,250 | $4,125 | $4,125 | $8,250 | $4,125 | $4,125 | $4,125 | $8,250 | $105,600 | |||||||||||||||
Collections @ 40% | $4,400 | $9,900 | $13,200 | $11,880 | $13,200 | $6,600 | $3,300 | $3,300 | $6,600 | $3,300 | $3,300 | $3,300 | $82,280 | |||||||||||||||
Collections @ 10% | $770 | $1,100 | $2,475 | $3,300 | $2,970 | $3,300 | $1,650 | $825 | $825 | $1,650 | $825 | $825 | $20,515 | |||||||||||||||
Total cash collected | $17,545 | $27,500 | $30,525 | $31,680 | $24,420 | $14,025 | $9,075 | $12,375 | $11,550 | $9,075 | $8,250 | $12,375 | $208,395 | |||||||||||||||
Quarter Collections | $75,570 | $70,125 | $33,000 | $29,700 | $208,395 | |||||||||||||||||||||||
Operating Expenses Budget | ||||||||||||||||||||||||||||
Quarter | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |||||||||||||||||||||||
Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||||||||||||||||
Selling Expenses | ||||||||||||||||||||||||||||
Advertising | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $11,025 | |||||||||||||||
Total Selling | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $919 | $11,025 | |||||||||||||||
Admin Expenses | ||||||||||||||||||||||||||||
Depreciation | $993 | $993 | $993 | $993 | $993 | $993 | $993 | $993 | $993 | $993 | $993 | $993 | $11,916 | |||||||||||||||
Insurance | $498 | $498 | $498 | $498 | $498 | $498 | $498 | $498 | $498 | $498 | $498 | $498 | $5,974 | |||||||||||||||
Utilities | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $4,104 | |||||||||||||||
Rent | $3,366 | $3,366 | $3,366 | $3,366 | $3,366 | $3,366 | $3,366 | $3,366 | $3,366 | $3,366 | $3,366 | $3,366 | $40,392 | |||||||||||||||
Wages | $4,275 | $4,275 | $4,275 | $4,275 | $17,100 | |||||||||||||||||||||||
Office expenses | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $5,760 | |||||||||||||||
Total Admin | $8,961 | $8,961 | $8,961 | $8,961 | $4,686 | $4,686 | $4,686 | $4,686 | $4,686 | $4,686 | $4,686 | $4,686 | $73,330 | |||||||||||||||
Financial Expenses | ||||||||||||||||||||||||||||
Bank Fees | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $1,176 | |||||||||||||||
Interest on loan | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $26,400 | |||||||||||||||
Total Financial | $2,298 | $2,298 | $2,298 | $2,298 | $2,298 | $2,298 | $2,298 | $2,298 | $2,298 | $2,298 | $2,298 | $2,298 | $27,576 | |||||||||||||||
Total | $12,178 | $12,178 | $12,178 | $12,178 | $7,903 | $7,903 | $7,903 | $7,903 | $7,903 | $7,903 | $7,903 | $7,903 | $111,931 | |||||||||||||||
Quarter Total | $36,533 | $27,983 | $23,708 | $23,708 | $111,931 | |||||||||||||||||||||||
Cash Budget | ||||||||||||||||||||||||||||
Income Statement | Yearly Figures | Monthly Figures | GST Included Yearly | GST Included Monthly | ||||||||||||||||||||||||
Revenue | $160,000 | 192,000 | ||||||||||||||||||||||||||
Cash Budget | ||||||||||||||||||||||||||||
Quarter | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |||||||||||||||||||||||
Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Less Operating Expenses | |||||||||||||||
Cash Inflow | Selling Expenses | |||||||||||||||||||||||||||
Accounts Receivable | $17,545 | $27,500 | $30,525 | $31,680 | $24,420 | $14,025 | $9,075 | $12,375 | $11,550 | $9,075 | $8,250 | $12,375 | $208,395 | |||||||||||||||
Total Inflow | $17,545 | $27,500 | $30,525 | $31,680 | $24,420 | $14,025 | $9,075 | $12,375 | $11,550 | $9,075 | $8,250 | $12,375 | $208,395 | |||||||||||||||
Cash Outflow | ||||||||||||||||||||||||||||
Advertising | $1,092 | $1,092 | $1,092 | $1,092 | $1,092 | $1,092 | $1,092 | $1,092 | $1,092 | $1,092 | $1,092 | $1,092 | $13,108 | Advertising | $10,500 | $10,500 | $11,025 | $919 | ||||||||||
Insurance | $548 | $548 | $548 | $548 | $548 | $548 | $548 | $548 | $548 | $548 | $548 | $548 | $6,572 | Administration Expenses | ||||||||||||||
Utilities | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $376 | $4,514 | Depreciation | $14,000 | $79,400 | $993 | |||||||||||
Rent | $3,703 | $3,703 | $3,703 | $3,703 | $3,703 | $3,703 | $3,703 | $3,703 | $3,703 | $3,703 | $3,703 | $3,703 | $44,431 | Insurance | $5,800 | $5,974.00 | $498 | |||||||||||
Wages | $1,425 | $1,425 | $1,425 | $1,425 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $5,700 | Utilities | $3,800 | $4,104.00 | $342 | ||||||||||||
Office expenses | $528 | $528 | $528 | $528 | $528 | $528 | $528 | $528 | $528 | $528 | $528 | $528 | $6,336 | Rent | $39,600 | $40,392.00 | $3,366 | |||||||||||
Bank Fees | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $98 | $1,176 | Wages | $18,000 | $17,100.00 | $1,425 | |||||||||||
Interest on loan | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $26,400 | Office expenses | $15,261 | $96,461 | 5760 | $480 | ||||||||||
GST payable | $2,850 | $1,678 | $2,943 | $2,643 | $2,943 | $1,443 | $693 | $693 | $1,443 | $693 | $693 | $693 | $19,406 | Financial Expenses | ||||||||||||||
Total Outflow | $12,820 | $11,648 | $12,913 | $12,613 | $11,488 | $9,988 | $9,238 | $9,238 | $9,988 | $9,238 | $9,238 | $9,238 | $127,643 | |||||||||||||||
Net Inflow/Outflow | $4,725 | $15,852 | $17,612 | $19,067 | $12,932 | $4,037 | -$163 | $3,137 | $1,562 | -$163 | -$988 | $3,137 | $80,752 | Bank fees | $1,200 | $1,176.00 | $98 | |||||||||||
Quarter Inflow/Outflow | $38,190 | $36,037 | $4,537 | $1,987 | $80,752 | |||||||||||||||||||||||
Opening Cash | $50,000 | $54,725 | $70,577 | $88,190 | $107,257 | $120,190 | $124,227 | $124,065 | $127,202 | $128,765 | $128,602 | $127,614 | $50,000 | Interest on loan | $26,400 | $27,600 | $26,400 | $2,200 | ||||||||||
Net Inflow/Outflow | $4,725 | $15,852 | $17,612 | $19,067 | $12,932 | $4,037 | -$163 | $3,137 | $1,562 | -$163 | -$988 | $3,137 | $80,752 | Net Profit | $25,439 | |||||||||||||
Closing Cash | $54,725 | $70,577 | $88,190 | $107,257 | $120,190 | $124,227 | $124,065 | $127,202 | $128,765 | $128,602 | $127,614 | $130,752 | $130,752 | TOTALS | $191,331 | $10,321 | ||||||||||||
Balance Sheet: | ||||||||||||||||||||||||||||
Balance Sheet | ||||||||||||||||||||||||||||
Current Assets | ||||||||||||||||||||||||||||
Cash | $22,619 | |||||||||||||||||||||||||||
GST Budget | Accounts Receivable | $6,270 | $28,889 | |||||||||||||||||||||||||
Quarter | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | Non-Current Assets | ||||||||||||||||||||||
Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Equipment | $108,000 | ||||||||||||||
GST collected | $2,250 | $3,000 | $2,700 | $3,000 | $1,500 | $750 | $750 | $1,500 | $750 | $750 | $750 | $1,500 | $19,200 | Accumulated Depreciation Equipment | -$28,600 | $79,400 | ||||||||||||
Less GST Paid on: | Total Assets | $108,289 | ||||||||||||||||||||||||||
Advertising | $109 | $109 | $109 | $109 | $109 | $109 | $109 | $109 | $109 | $109 | $109 | $109 | $1,311 | Current Liabilities | ||||||||||||||
Insurance | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $657 | GST Payable | $2,850 | |||||||||||||
Utilities | $38 | $38 | $38 | $38 | $38 | $38 | $38 | $38 | $38 | $38 | $38 | $38 | $451 | Non-Current Liabilities | $30,000 | |||||||||||||
Rent | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $4,443 | Loan | ||||||||||||||
Total GST paid | $572 | $57 | $57 | $57 | $57 | $57 | $57 | $57 | $57 | $57 | $57 | $57 | $1,201 | Total Liabilities | $32,850 | |||||||||||||
Total GST Payable | $1,678 | $2,943 | $2,643 | $2,943 | $1,443 | $693 | $693 | $1,443 | $693 | $693 | $693 | $1,443 | $17,999 | Net Assets | $75,439 | |||||||||||||
Quarter GST Paid | $686 | $5,078 | $2,828 | $2,828 | $11,422 | |||||||||||||||||||||||
Capital | ||||||||||||||||||||||||||||
Opening Capital | $50,000 | |||||||||||||||||||||||||||
Income Statement Budget | Net Profit | 25439 | $75,439 | |||||||||||||||||||||||||
Quarter | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |||||||||||||||||||||||
Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||||||||||||||||
Revenue | $22,500 | $30,000 | $27,000 | $30,000 | $15,000 | $7,500 | $7,500 | $15,000 | $7,500 | $7,500 | $7,500 | $15,000 | $192,000 | |||||||||||||||
Less Operating Expenses | $12,178 | $12,178 | $12,178 | $12,178 | $7,903 | $7,903 | $7,903 | $7,903 | $7,903 | $7,903 | $7,903 | $7,903 | $111,931 | |||||||||||||||
Net Profit | $10,322 | $17,822 | $14,822 | $17,822 | $7,097 | -$403 | -$403 | $7,097 | -$403 | -$403 | -$403 | $7,097 | $80,069 | |||||||||||||||
Quarter Net Profit | $42,967 | $24,517 | $6,292 | $6,292 | $80,069 | |||||||||||||||||||||||
Balance Sheet | ||||||||||||||||||||||||||||
Current Assets | ||||||||||||||||||||||||||||
Cash | $130,752 | |||||||||||||||||||||||||||
Accounts Receivable | $208,395 | $339,147 | ||||||||||||||||||||||||||
Non-Current Assets | ||||||||||||||||||||||||||||
Equipment | $108,000 | |||||||||||||||||||||||||||
Accumulated Depreciation Equipment | $79,400 | $187,400 | ||||||||||||||||||||||||||
Total Assets | $526,547 | |||||||||||||||||||||||||||
Current Liabilities | ||||||||||||||||||||||||||||
GST Payable | $17,999 | |||||||||||||||||||||||||||
Non-Current Liabilities | $30,000 | |||||||||||||||||||||||||||
Loan | ||||||||||||||||||||||||||||
Total Liabilities | $47,999 | ALL FIGURES IN GST BUDGET AND INCOME STATEMENT AND BALANCE SHEET INCORRECT CALCULATIONS FROM INFORMATION ABOVE. PLEASE CHECK FIGURES | ||||||||||||||||||||||||||
Net Assets | $478,548 | |||||||||||||||||||||||||||
Capital | ||||||||||||||||||||||||||||
Opening Capital | $75,439 | |||||||||||||||||||||||||||
Net Profit | $80,069 | $155,508 | $323,040 | |||||||||||||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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