PLEASE REVIEW ASSIGNMENT ATTACHMENTS PRIOR TO BIDDING!!!!? The business that I decided to start is an HVAC company. My mai
PLEASE REVIEW ASSIGNMENT ATTACHMENTS PRIOR TO BIDDING!!!!
The business that I decided to start is an HVAC company. My main reason for starting the business would be because I've watched so many shady contractors take advantage of people. The financial information and everything would be made up. I need all of the attached documents completed.
Sheet1
Projected 6 Month Statement of Cash Flows | ||||||||
For BUSINESS NAME | ||||||||
For the period ending DATE | ||||||||
month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | TOTAL | ||
Cash flow from operating activities | ||||||||
Receipts from customers | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Payments to suppliers (enter as a negative number by place a munus sign before the dollar figure) | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Payments to employees (enter as a negative number by place a munus sign before the dollar figure) | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Interest payments (enter as a negative number by place a munus sign before the dollar figure) | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Interest received | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Taxes paid (enter as a negative number by place a munus sign before the dollar figure) | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Other | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Other | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Net cash flow from operating activities | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Cash flow from investing activities | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Purchases of equipment (enter as a negative number by place a munus sign before the dollar figure) | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Purchases of property | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Proceeds from sale of equipment | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Proceeds from sale of property | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Other | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Other | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Net cash flow from investing activities | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Cash flow from financing activities | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Proceeds from borrowings | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Payments of borrowings (repayment of principal) | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Investment into business | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Drawings from business investment | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Other | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Other | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Net cash flow from financing activities | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Net increase (decrease) in cash held | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Cash at beginning of period | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |
Cash at end of period | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 |
Sheet2
Sheet3
,
Sheet1
Breakeven Analysis – Monthly | ||||
Fixed Costs | Average Selling Price Per Unit | Cost of Goods Sold/Variable Costs Per Unit | Gross Profit Per Unit | Break-Even Units |
$4,660.00 | $75.00 | $55.00 | $20.00 | 233.00 |
Fixed Monthly Operating Costs | Amount | Variable Costs | Per Unit Amount | |
EXAMPLE | EXAMPLE | |||
Storage | $600.00 | Labor | $30.00 | |
Insurance | $10.00 | Materials | $20.00 | |
Accountant | $250.00 | Shipping | $5.00 | |
Rent | $750.00 | |||
Insurance | $250.00 | |||
Payroll | $2,500.00 | |||
Equipment Lease | $300.00 | |||
Total | $4,660.00 | Total | $55.00 | |
,
StartupCosts
[ENTER YOUR BUSINESS NAME] | STARTUP BUDGET | |||
FUNDING | Estimated | Actual | Under/(Over) | |
Investor Funding | {42} | |||
Owner 1 | ||||
Owner 2 | ||||
Other | ||||
Total Investment | – | – | – | |
Loans | ||||
Bank Loan 1 | ||||
Bank Loan 2 | ||||
Non Bank Loan 1 | ||||
Total Loans | – | – | – | |
Other Funding | ||||
Grant 1 | ||||
Other | ||||
Total Other Funding | – | – | – | |
Total FUNDING | – | – | – | |
COSTS | Estimated | Actual | Under/(Over) | |
Fixed Costs | ||||
Advertising for Opening | ||||
Basic Website | ||||
Brand Development | ||||
Building Down Payment | ||||
Building Improvements/Remodeling | ||||
Business Cards/Stationery | ||||
Business Entity | ||||
Business Licenses/Permits | ||||
Computer Hardware/Software | ||||
Decorating | ||||
Franchise Start Up Fees | ||||
Internet Setup Deposit | ||||
Lease Security Deposit | ||||
Legal/Professional Fees | ||||
Machines & Equipment | ||||
Office Furniture/Fixtures | ||||
Operating Cash (Working Capital) | ||||
Point of Sale Hardware/Software | ||||
Prepaid Insurance | ||||
Public Utilities Deposits | ||||
Reserve for Contingencies | ||||
Security System Installation | ||||
Setup, installation and consulting fees | ||||
Signage | ||||
Starting Inventory | ||||
Telephone | ||||
Tools & Supplies | ||||
Travel | ||||
Truck & Vehicle | ||||
Other 1 (specify) | ||||
Other 2 (specify) | ||||
[42] | Total Fixed Costs | – | – | – |
Average Monthly Costs | ||||
Advertising (print, broadcast and Internet) | ||||
Business Insurance | ||||
Business Vehicle Insurance | ||||
Employee Salaries and Commissions | ||||
Equipment Lease Payments | ||||
Inventory, raw materials, parts | ||||
Franchise Fee | ||||
Health Insurance | ||||
Internet Connection | ||||
Loan and Credit Card Interest & Principal | ||||
Legal/Accounting Fees | ||||
Merchant Account Fees | ||||
Miscellaneous Expenses | ||||
Mortgage Payments | ||||
Lease Payment | ||||
Owner Salary | ||||
Payroll taxes or Self-employment tax | ||||
Postage/Shipping Costs | ||||
Security System Monthly Payment | ||||
Supplies | ||||
Telephone | ||||
Travel | ||||
Public Utilities | ||||
Website Hosting/Maintenance | ||||
Other 1 (specify) | ||||
Other 2 (specify) | ||||
Total Average Monthly Costs | – | – | – | |
x Number of Months | ||||
Total Monthly Costs | – | – | – | |
Total COSTS | – | – | – | |
SURPLUS/(DEFICIT) | – | – | – |
Sheet1
©
Business Budget Template |
http://www.vertex42.com/ExcelTemplates/business-budget.html |
© 2009 Vertex42 LLC. All Rights Reserved. |
,
BalanceSheet
[Company Name] | Balance Sheet | |||
Date: | ||||
Assets | 2020 | 2019 | ||
Current Assets | ||||
Cash | ||||
Accounts receivable | ||||
Inventory | ||||
Prepaid expenses | ||||
Short-term investments | ||||
Total current assets | $ – | $ – | ||
Fixed (Long-Term) Assets | ||||
Long-term investments | ||||
Property, plant, and equipment | ||||
(Less accumulated depreciation) | ||||
Intangible assets | ||||
Total fixed assets | $ – | $ – | ||
Other Assets | ||||
Deferred income tax | ||||
Other | ||||
Total Other Assets | $ – | $ – | ||
Total Assets | $ – | $ – | ||
[42] | Liabilities and Owner's Equity | |||
Current Liabilities | ||||
Accounts payable | ||||
Short-term loans | ||||
Income taxes payable | ||||
Accrued salaries and wages | ||||
Unearned revenue | ||||
Current portion of long-term debt | ||||
Total current liabilities | $ – | $ – | ||
Long-Term Liabilities | ||||
Long-term debt | ||||
Deferred income tax | ||||
Other | ||||
Total long-term liabilities | $ – | $ – | ||
Owner's Equity | ||||
Owner's investment | ||||
Retained earnings | ||||
Other | ||||
Total owner's equity | $ – | $ – | ||
Total Liabilities and Owner's Equity | $ – | $ – | ||
{42} | ||||
Common Financial Ratios | ||||
Debt Ratio (Total Liabilities / Total Assets) | ||||
Current Ratio (Current Assets / Current Liabilities) | ||||
Working Capital (Current Assets – Current Liabilities) | – | – | ||
Assets-to-Equity Ratio (Total Assets / Owner's Equity) | ||||
Debt-to-Equity Ratio (Total Liabilities / Owner's Equity) |
©
Balance Sheet Template | |
By Vertex42.com | |
https://www.vertex42.com/ExcelTemplates/balance-sheet.html | |
© 2008-2019 Vertex42 LLC | |
This spreadsheet, including all worksheets and associated content is a copyrighted work under the United States and other copyright laws. | |
Do not submit copies or modifications of this template to any website or online template gallery. | |
Please review the following license agreement to learn how you may or may not use this template. Thank you. | |
License Agreement | |
https://www.vertex42.com/licensing/EULA_privateuse.html | |
Do not delete this worksheet | |
https://www.vertex42.com/licensing/EULA_privateuse.html https://www.vertex42.com/ExcelTemplates/balance-sheet.html
,
Monthly P $ L
[Insert Company Name] | 6-Month and 3-year Profit and Loss Projections | ||||||||||||||||
INCOME | Month 1 | % of TS | Month 2 | % of TS | Month 3 | % of TS | Month 4 | % of TS | Month 5 | % of TS | Month 6 | % of TS | |||||
Sales | |||||||||||||||||
Product Revenue | – | – | – | – | – | – | – | – | |||||||||
Service Revenue | – | – | – | – | – | – | – | – | |||||||||
Commission Revenue | – | – | – | – | – | – | – | – | |||||||||
Other | – | – | – | – | – | – | – | – | |||||||||
Other | – | – | – | – | – | – | |||||||||||
Total Sales (TS) | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | |||||
Cost of Goods | |||||||||||||||||
Materials | – | – | – | – | – | – | – | – | |||||||||
Shipping and Delivery | – | – | – | – | – | – | – | – | |||||||||
Labor (direct wages and payroll) | – | – | – | – | – | – | – | – | |||||||||
Other | – | – | – | – | – | – | – | ||||||||||
Total Cost of Goods Sold | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | |||||
Gross Profit | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | |||||
Non-Operating Income | |||||||||||||||||
Interest Income | |||||||||||||||||
Rental Income | |||||||||||||||||
Other | |||||||||||||||||
Total Non-Operating Income | $ – | $ – | $ – | $ – | $ – | $ – | |||||||||||
Total INCOME | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | |||||
EXPENSES | |||||||||||||||||
Operating Expenses | |||||||||||||||||
Accounting and Legal | – | – | – | – | – | – | |||||||||||
Advertising & Marketing | – | – | – | – | – | – | |||||||||||
Bank Fees | – | ||||||||||||||||
Depreciation | – | – | – | – | – | – | |||||||||||
Dues and Subscriptions | – | – | – | – | – | – | |||||||||||
Insurance (commercial, health etc.) | – | – | – | – | – | – | – | ||||||||||
Leases | |||||||||||||||||
Interest Expense | – | – | – | – | – | – | |||||||||||
Maintenance and Repairs | – | – | – | – | – | – | |||||||||||
Office Supplies | – | – | – | – | – | – | – | ||||||||||
Payroll Expenses | – | – | – | – | – | – | |||||||||||
Postage/shipping expense | – | – | – | – | – | – | |||||||||||
Rent | – | – | – | – | – | – | |||||||||||
Research and Development | – | – | – | – | – | – | |||||||||||
Salaries and Wages | – | – | – | – | – | – | – | ||||||||||
Taxes and Licenses | – | – | – | – | – | – | |||||||||||
Automobile | |||||||||||||||||
Fuel/Gas | |||||||||||||||||
Telephone | – | – | – | – | – | – | |||||||||||
Travel | – | – | – | – | – | – | |||||||||||
Utilities | – | – | – | – | – | – | |||||||||||
Web Hosting and Domains | – | – | – | – | – | – | |||||||||||
Other | – | – | – | – | – | – | |||||||||||
Total Operating Expenses | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | |||||
Non-Recurring Expenses (one-time/infrequent) | |||||||||||||||||
Furniture, Equipment and Software | – | – | – | – | – | – | |||||||||||
Gifts Given | – | – | – | – | – | – | |||||||||||
Other | – | – | – | – | – | – | |||||||||||
Total Non-Recurring Expenses | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | |||||
Total EXPENSES | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | $ – | – | |||||
Net Income Before Taxes | $ – | $ – | $ – | $ – | $ – | $ – | |||||||||||
Interest Expenses | |||||||||||||||||
Income Tax Expense | |||||||||||||||||
NET INCOME | $ – | $ – | $ – | $ – | $ – | $ – | |||||||||||
Owner Distributions / Dividends | |||||||||||||||||
Adjustment to Retained Earnings | $ – | $ – | $ – | $ – | $ – | $ – | |||||||||||
Annual P & L
[Insert Company Name] | 2-Year Profit and Loss Projection | ||||||||
NOTE: If you are already in business, enter your actual data for 2019, and your projected annual profit and loss for 2020 and 2021 | |||||||||
If you are not yet in business, just forecast for 2020 and 2021. | |||||||||
INCOME | 2019 Actual) | % of TS | 2020 | % of TS | 2021 | % of TS | |||
Sales | |||||||||
Product Revenue | – | – | – | – | – | ||||
Service Revenue | – | – | – | – | – | ||||
Commission Revenue | – | – | – | – | – | ||||
Other | – | – | – | – | – | ||||
Other | – | – | – | ||||||
Total Sales (TS) | $ – | – | $ – | – | $ – | – | |||
Cost of Goods | |||||||||
Materials | – | – | – | – | – | ||||
Shipping and Delivery | – | – | – | – | – | ||||
Labor (direct wages and payroll) | – | – | – | – | – | ||||
Other | – | – | – | – | |||||
Total Cost of Goods Sold | $ – | – | $ – | – | $ – | – | |||
Gross Profit | $ – | – | $ – | – | $ – | – | |||
Non-Operating Income | |||||||||
Interest Income | |||||||||
Rental Income | |||||||||
Other | |||||||||
Total Non-Operating Income | $ – | $ – | $ – | ||||||
</
Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. All Rights Reserved Terms and Conditions |