Question
ASSETS = LIABILITIES & OWNERS' EQUITY Cash Filters Vehicles Prepaid Costs Debt Paid-in Capital Retained Earnings YEAR 2 Opening Balances ($18,164) $18,667 $16,000 $87,333 $0
ASSETS | = | LIABILITIES & OWNERS' EQUITY | ||||||||||
Cash | Filters | Vehicles | Prepaid Costs | Debt | Paid-in Capital | Retained Earnings | ||||||
YEAR 2 | ||||||||||||
Opening Balances | ($18,164) | $18,667 | $16,000 | $87,333 | $0 | $225,000 | ($121,164) | |||||
Beginning-of-year activities | ||||||||||||
1 | Debt | $1,000,000 | $1,000,000 | |||||||||
2 | Slowsand Filters | ($487,500) | $487,500 | |||||||||
3 | Motorcycles and Trucks | ($492,500) | $492,500 | |||||||||
Through-the-year activities | ||||||||||||
7 | Revenues | $8,760,000 | $8,760,000 | |||||||||
Revenue Underreporting | ($13,140,000) | ($1,314,000) | ||||||||||
Cost of Revenue, Vendor Compensation | ($1,489,200) | ($1,489,200) | ||||||||||
8 | Technicians' Wages | ($120,000) | ($120,000) | |||||||||
9 | Local Management Salaries | ($325,000) | ($325,000) | |||||||||
10 | Sales Staff Salaries | ($36,000) | ($36,000) | |||||||||
11 | Water Testing & Filter Maintenance | ($408,000) | ($408,000) | |||||||||
12 | Marketing Expenses | ($25,000) | ($50,000) | ($75,000) | ||||||||
13 | Vehicle Expenses | ($65,000) | ($65,000) | |||||||||
14 | Other Costs | ($1,191,360) | ($1,191,360) | |||||||||
Year-closing activities | ||||||||||||
15 | Depreciation | |||||||||||
Blue Future Contract | ($2,667) | ($2,667) | ||||||||||
Slowsand Filters | ($33,833) | ($33,833) | ||||||||||
Motorcycles and Trucks | ($102,500) | ($102,500) | ||||||||||
16 | Repay Debt | ($1,000,000) | ($1,000,000) | |||||||||
17 | Interest Charge | ($100,000) | ($100,000) | |||||||||
YEAR 2 CLOSING TOTALS | ($9,137,724) | $472,334 | $406,000 | $34,666 | $0 | $225,000 | $3,376,276 | |||||
ASSETS | = | LIABILITIES & OWNERS' EQUITY | ||||||||||
Cash | Filters | Vehicles | Prepaid Costs | Debt | Paid-in Capital | Retained Earnings | ||||||
YEAR 3 | ||||||||||||
Opening Balances | ($9,137,724) | $472,334 | $406,000 | $34,666 | $0 | $225,000 | $3,376,276 | |||||
Beginning-of-year activities | ||||||||||||
1 | Slowsand Filters | ($250,000) | $250,000 | |||||||||
2 | Motorcycles and Trucks | ($237,500) | $237,500 | |||||||||
Through-the-year activities | ||||||||||||
7 | Revenues | $19,710,000 | ||||||||||
Revenue Underreporting | $19,710,000 | ($2,956,500) | ||||||||||
Cost of Revenue, Vendor Compensation | ($3,350,700) | ($3,350,700) | ||||||||||
8 | Technicians' Wages | ($180,000) | ($180,000) | |||||||||
9 | Local Management Salaries | ($400,000) | ($400,000) | |||||||||
10 | Sales Staff Salaries | ($36,000) | ($36,000) | |||||||||
11 | Water Testing & Filter Maintenance | ($612,000) | ($612,000) | |||||||||
12 | Marketing Expenses | ($40,000) | ($40,000) | |||||||||
13 | Vehicle Expenses | ($110,000) | ($110,000) | |||||||||
14 | Other Costs | ($275,940) | ($2,759,400) | |||||||||
Year-closing activities | ||||||||||||
15 | Depreciation | |||||||||||
Blue Future Contract | ($2,667) | ($2,667) | ||||||||||
Slowsand Filters | ($33,833) | ($33,833) | ||||||||||
Motorcycles and Trucks | ($102,500) | ($102,500) | ||||||||||
YEAR 3 CLOSING TOTALS | $2,724,276 | $688,501 | $541,000 | $31,999 | $0 | $225,000 | $12,502,676 |
Can you please help me create a balance sheet, net cash flow t and income statement for year 2 and 3
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