Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Financial Numbers Game

Authors: Charles W Mulford, Eugene E Comiskey

1st Edition

0471770736, 9780471770732

More Books

Students also viewed these Accounting questions

Question

The background knowledge of the interpreter

Answered: 1 week ago