Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider how theGreen Cars Corporation business that you are developing a business plan for will manage cash-flow, financial controls, and financial planning. Post your plans
Consider how theGreen Cars Corporation business that you are developing a business plan for will manage cash-flow, financial controls, and financial planning. Post your plans on the discussion board and respond to at least two others' results.
Green Cars Corporation | |
Balance Sheet | |
At December 31, 2024 | |
Assets | 2024 |
Current Assets | |
Cash in Bank | $18,587 |
Prepaid Insurance (80% ops, 20% adm) | $33,000 |
Total Current Assets | $51,587 |
Fixed Assets | |
Machinery & Equipment (10 EV's) | $400,000 |
Acc Dep, Machinery and Equip | $40,000 |
App | $15,000 |
Business Permits and Licences | $2,160 |
Total Fixed Assets | $377,160 |
Total Assets | $428,747 |
Liabilities & Net Worth | |
Current Liabilities | |
Accounts payable | $152 |
Taxes Payable | $1,011 |
Total Current Liabilities | $1,163 |
Long-Term Liabilities | |
Bank Loans Payable (10 years, 12% interest rate) | $329,719 |
Short-Term Portion | $36,635 |
Total Bank Loan | $366,354 |
Total Liabilities | $367,517 |
Owners' Equity (Net Worth) | $50,000 |
Retained earnings | $11,230 |
Total Liabilities & Net Worth | $428,747 |
12-Month Income Statement (Profit & Loss Statement) | |||||||||||||
Green Cars Corporation | |||||||||||||
Insert Year: | 2024 | ||||||||||||
January | February | March | April | May | June | July | August | September | October | November | December | YEARLY | |
Revenue (Sales) | |||||||||||||
Membership | 3,000 | 3,300 | 3,600 | 3,900 | 4,200 | 4,500 | 4,800 | 5,100 | 5,400 | 5,700 | 6,000 | 6,300 | 55,800 |
Kilometers | 3,600 | 3,960 | 4,320 | 4,680 | 5,040 | 5,400 | 5,760 | 6,120 | 6,480 | 6,840 | 7,200 | 7,560 | 66,960 |
Hours | 2,160 | 2,376 | 2,592 | 2,808 | 3,024 | 3,240 | 3,456 | 3,672 | 3,888 | 4,104 | 4,320 | 4,536 | 40,176 |
Total Revenue (Sales) | 8,760 | 9,636 | 10,512 | 11,388 | 12,264 | 13,140 | 14,016 | 14,892 | 15,768 | 16,644 | 17,520 | 18,396 | 162,936 |
Cost of Goods Sold | |||||||||||||
Electricity | 72.00 | 79.20 | 86.40 | 93.60 | 100.80 | 108.00 | 115.20 | 122.40 | 129.60 | 136.80 | 144.00 | 151.20 | 1,339 |
Parking | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 14,400 |
Insurance | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 24,000 |
Total Cost of Goods Sold | 3,272 | 3,279 | 3,286 | 3,294 | 3,301 | 3,308 | 3,315 | 3,322 | 3,330 | 3,337 | 3,344 | 3,351 | 39,739 |
Gross Profit | 5,488 | 6,357 | 7,226 | 8,094 | 8,963 | 9,832 | 10,701 | 11,570 | 12,438 | 13,307 | 14,176 | 15,045 | 123,197 |
Operating Expenses | |||||||||||||
Rent Expense / App maintenance fee | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1,200 |
Salary/Wage Expenses | 3,396 | 3,396 | 3,396 | 3,396 | 3,396 | 3,396 | 3,396 | 3,396 | 3,396 | 3,396 | 3,396 | 3,396 | 40,752 |
Maintenance Expense | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 12,000 |
Advertising Expense | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2,400 |
Telephone/Internet Expense | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 768 |
Insurance Expense | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 6,000 |
Interest from Loans (if applicable) | 4,071 | 4,071 | 4,071 | 4,071 | 4,071 | 4,071 | 4,071 | 4,071 | 4,071 | 4,071 | 4,071 | 4,071 | 48,847 |
Total Expenses | 9,331 | 9,331 | 9,331 | 9,331 | 9,331 | 9,331 | 9,331 | 9,331 | 9,331 | 9,331 | 9,331 | 9,331 | 111,967 |
Net Profit | -3,843 | -2,974 | -2,105 | -1,236 | -367 | 501 | 1,370 | 2,239 | 3,108 | 3,977 | 4,845 | 5,714 | 11,230 |
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