Balance Sheet Budget vs Actual
Wild Water Sports Ch 10A
Balance Sheet Budget vs. Actual
As of April 30, 2016
Apr 30, 16
ASSETS
Current Assets
Checking/Savings
Bank of Florida
Short-Term Investments
$ Over Budget
% of Budget
76,237.45
19,600.00
60,000.00
30,000.00
16,237.45
-10,400.00
127.1%
65.3%
Total Checking/Savings
95,837.45
90,000.00
5,837.45
106.5%
Accounts Receivable
Accounts Receivable
492,017.50
500,000.00
-7,982.50
98.4%
Total Accounts Receivable
492,017.50
500,000.00
-7,982.50
98.4%
Other Current Assets
Inventory Boats
Inventory Parts
Prepaid Advertising
Prepaid Insurance
Undeposited Funds
273,000.00
2,052.00
18,000.00
14,667.00
0.00
290,000.00
2,000.00
18,000.00
14,250.00
-17,000.00
52.00
0.00
417.00
94.1%
102.6%
100.0%
102.9%
Total Other Current Assets
307,719.00
324,250.00
-16,531.00
94.9%
Total Current Assets
895,573.95
914,250.00
-18,676.05
98.0%
Fixed Assets
Furniture and Equipment
Accumulated Depreciation
307,000.00
-21,703.00
307,000.00
-21,250.00
0.00
-453.00
100.0%
102.1%
Total Fixed Assets
285,297.00
285,750.00
-453.00
99.8%
1,180,870.95
1,200,000.00
-19,129.05
98.4%
297,000.00
345,200.00
-48,200.00
86.0%
297,000.00
345,200.00
-48,200.00
86.0%
TOTAL ASSETS
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Accounts Payable
Accounts Payable
Total Accounts Payable
Credit Cards
MasterCard
0.00
Total Credit Cards
0.00
Other Current Liabilities
Unearned Revenue
Accrued Liabilities
Payroll Liabilities
Sales Tax Payable
16,250.00
1,995.52
3,370.36
26,044.85
2,000.00
3,000.00
30,000.00
-4.48
370.36
-3,955.15
99.8%
112.3%
86.8%
Total Other Current Liabilities
47,660.73
35,000.00
12,660.73
136.2%
Total Current Liabilities
344,660.73
380,200.00
-35,539.27
90.7%
Long Term Liabilities
Loan Payable
305,925.56
300,000.00
5,925.56
102.0%
Total Long Term Liabilities
305,925.56
300,000.00
5,925.56
102.0%
Total Liabilities
650,586.29
680,200.00
-29,613.71
95.6%
Equity
Capital Stock
Opening Balance
Balance Sheet Budget vs. Actual
As of April 30, 2016
Apr 30, 16
ASSETS
Current Assets
Checking/Savings
Bank of Florida
Short-Term Investments
$ Over Budget
% of Budget
76,237.45
19,600.00
60,000.00
30,000.00
16,237.45
-10,400.00
127.1%
65.3%
Total Checking/Savings
95,837.45
90,000.00
5,837.45
106.5%
Accounts Receivable
Accounts Receivable
492,017.50
500,000.00
-7,982.50
98.4%
Total Accounts Receivable
492,017.50
500,000.00
-7,982.50
98.4%
Other Current Assets
Inventory Boats
Inventory Parts
Prepaid Advertising
Prepaid Insurance
Undeposited Funds
273,000.00
2,052.00
18,000.00
14,667.00
0.00
290,000.00
2,000.00
18,000.00
14,250.00
-17,000.00
52.00
0.00
417.00
94.1%
102.6%
100.0%
102.9%
Total Other Current Assets
307,719.00
324,250.00
-16,531.00
94.9%
Total Current Assets
895,573.95
914,250.00
-18,676.05
98.0%
Fixed Assets
Furniture and Equipment
Accumulated Depreciation
307,000.00
-21,703.00
307,000.00
-21,250.00
0.00
-453.00
100.0%
102.1%
Total Fixed Assets
285,297.00
285,750.00
-453.00
99.8%
1,180,870.95
1,200,000.00
-19,129.05
98.4%
297,000.00
345,200.00
-48,200.00
86.0%
297,000.00
345,200.00
-48,200.00
86.0%
TOTAL ASSETS
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Accounts Payable
Accounts Payable
Total Accounts Payable
Credit Cards
MasterCard
0.00
Total Credit Cards
0.00
Other Current Liabilities
Unearned Revenue
Accrued Liabilities
Payroll Liabilities
Sales Tax Payable
16,250.00
1,995.52
3,370.36
26,044.85
2,000.00
3,000.00
30,000.00
-4.48
370.36
-3,955.15
99.8%
112.3%
86.8%
Total Other Current Liabilities
47,660.73
35,000.00
12,660.73
136.2%
Total Current Liabilities
344,660.73
380,200.00
-35,539.27
90.7%
Long Term Liabilities
Loan Payable
305,925.56
300,000.00
5,925.56
102.0%
Total Long Term Liabilities
305,925.56
300,000.00
5,925.56
102.0%
Total Liabilities
650,586.29
680,200.00
-29,613.71
95.6%
Equity
Capital Stock
Opening Balance