homework

profileKassy001
tf55778751_win321.xlsx
Home>English homework help>homework

Startup Overview

STARTUP OVERVIEW Budget Actual (Under) / Over
Total Expenses $ 583,910.00 $ 582,860.00 $ (1,050.00)
Administrative / General $ 10,200.00 $ 9,150.00 $ (1,050.00)
Location / Office $ 354,910.00 $ 354,910.00 $ - 0
Marketing $ 13,300.00 $ 13,300.00 $ - 0
Labor $ 205,000.00 $ 205,000.00 $ - 0
Other $ 500.00 $ 500.00 $ - 0
Total Funding $ 600,000.00 $ 620,000.00 $ 20,000.00
Investors $ 80,000.00 $ 80,000.00 $ - 0
Loans $ 500,000.00 $ 495,000.00 $ (5,000.00)
Additional Funding $ 20,000.00 $ 45,000.00 $ 25,000.00
Funding Less Expenses $ 16,090.00 $ 37,140.00 $ 21,050.00
STARTUP FUNDING Budget Actual (Under) / Over
Investors
Owner 1 $ 50,000.00 $ 50,000.00 $ - 0
Owner 2 $ 30,000.00 $ 30,000.00 $ - 0
Owner 3 $ - 0 $ - 0 $ - 0
Other $ - 0 $ - 0 $ - 0
Total $ 80,000.00 $ 80,000.00 $ - 0
Loans
Bank Loan $ 450,000.00 $ 450,000.00 $ - 0
Non-Bank Loan $ 50,000.00 $ 45,000.00 $ (5,000.00)
Other $ - 0 $ - 0 $ - 0
Total $ 500,000.00 $ 495,000.00 $ (5,000.00)
Additional Funding
Grant $ 20,000.00 $ 45,000.00 $ 25,000.00
Other $ - 0 $ - 0 $ - 0
Total $ 20,000.00 $ 45,000.00 $ 25,000.00
Total Startup Funding $ 600,000.00 $ 620,000.00 $ 20,000.00

Medical Office Startup Overview

Expenses

STARTUP EXPENSES Date Due Budget Actual (Under) / Over
Administrative / General
Permits $ 1,500.00 $ 1,500.00 $ - 0
Insurance $ 3,400.00 $ 3,200.00 $ (200.00)
Legal $ 300.00 $ 450.00 $ 150.00
Business Consultant $ 2,500.00 $ 2,000.00 $ (500.00)
Training $ 2,000.00 $ 1,500.00 $ (500.00)
Software (General) $ 500.00 $ 500.00 $ - 0
Other $ - 0 $ - 0 $ - 0
Total $ 10,200.00 $ 9,150.00 $ (1,050.00)
Location / Office
Space Rental / Lease $ 50,000.00 $ 50,000.00 $ - 0
Utility Costs $ 2,500.00 $ 2,500.00 $ - 0
Telephone Set-Up & Annual Cost $ 410.00 $ 410.00 $ - 0
Furniture $ 15,000.00 $ 15,000.00 $ - 0
Medical Equipment $ 150,000.00 $ 150,000.00 $ - 0
Hardware $ 10,000.00 $ 10,000.00 $ - 0
Software (CRM, etc) $ 7,000.00 $ 7,000.00 $ - 0
Installation Fees $ 5,000.00 $ 5,000.00 $ - 0
Start Up Inventory (Pharma) $ 100,000.00 $ 100,000.00 $ - 0
Medical Supplies (Gloves, Etc) $ 5,000.00 $ 5,000.00 $ - 0
Miscellaneous $ 10,000.00 $ 10,000.00 $ - 0
Other $ - 0 $ - 0 $ - 0
Total $ 354,910.00 $ 354,910.00 $ - 0
Marketing
Logo Design $ 300.00 $ 300.00 $ - 0
Branding / Identity Development $ 200.00 $ 200.00 $ - 0
Launch Advertising $ 10,000.00 $ 10,000.00 $ - 0
Website $ 700.00 $ 700.00 $ - 0
Printed Marketing Pieces $ 500.00 $ 500.00 $ - 0
Promo Materials $ 500.00 $ 500.00 $ - 0
Listing Fees $ 300.00 $ 300.00 $ - 0
Internet Marketing $ 100.00 $ 100.00 $ - 0
Trade Shows $ 500.00 $ 500.00 $ - 0
Networking Events $ 200.00 $ 200.00 $ - 0
Other $ - 0 $ - 0 $ - 0
Total $ 13,300.00 $ 13,300.00 $ - 0
Labor Expenses
Job-Listing Fees $ - 0 $ - 0 $ - 0
Payroll $ 200,000.00 $ 200,000.00 $ - 0
Training $ 5,000.00 $ 5,000.00 $ - 0
Other $ - 0 $ - 0 $ - 0
Other $ - 0 $ - 0 $ - 0
Other $ - 0 $ - 0 $ - 0
Total $ 205,000.00 $ 205,000.00 $ - 0
Other
Contingencies Reserve $ - 0 $ - 0 $ - 0
Launch Party $ 500.00 $ 500.00 $ - 0
Other $ - 0 $ - 0 $ - 0
Other $ - 0 $ - 0 $ - 0
Other $ - 0 $ - 0 $ - 0
Total $ 500.00 $ 500.00
Total Startup Expenses $ 583,910.00 $ 582,860.00 $ (1,050.00)

Medical Office Startup Overview

Company Name

Profit & Loss

REVENUE January February March April May June July August September October November December YTD
Estimated Sales $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 960,000.00
Less (Discounts, Errors, etc) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (60,000.00)
Service Revenue $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Revenue $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Net Sales $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 $ 900,000.00
Cost of Goods Sold $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 12,000.00
Gross Profit $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 74,000.00 $ 888,000.00
EXPENSES January February March April May June July August September October November December YTD
Administrative General $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 912.50 $ 10,950.00
Location / Office $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 29,575.00 $ 354,900.00
Marketing $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 1,108.00 $ 13,296.00
Labor $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 17,083.33 $ 204,999.96
Other $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 6,000.00
Total Expenses $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 49,178.83 $ 590,145.96
Income Before Taxes $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 24,821.17 $ 297,854.04
Income Tax Expense $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 3,723.18 $ 44,678.11
NET INCOME $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 21,097.99 $ 253,175.93

Profit & Loss Sheet

Company Name

image1.jpeg

image2.png