Make a Balance Sheet and Income Statement from above information.
AMOUNT TOTAL ANECULARS REVENUES SALES FORECAST Employee Salaries Employee Payroll Taxes and Benefits Consultant(s) Rent/Lease Payments Mortgage Payments Advertising/Promotion/Web Site Postage/Shipping Supplies Communication/Telephone Utilities Insurance Bank Service Charges Repairs & Maintenance Professional Services - Legal, Accounting Miscellaneous Profit $ 54,000.00 $ 12,000.00 $4,000.00 $3,600.00 $ 2,600.00 $ 500.00 $ 400.00 $ 10,800.00 $285.00 $ 500.00 $3,300.00 $ 15,000.00 $ 4,250.00 $3,000.00 $ 1,500.00 Sheet1 F52 X D $ 10,600.00 17,000 25,000 4,000 1,200 300 45,000 2,500 28 29 ONE-TIME COSTS 30 Land 31 Building(s) 32 Machinery & Equipment 33 Furniture & Fixtures 34 Computer Equipment 35 Computer Software 36 Leasehold Improvements 37 Security Deposit(s) 38 Business Licenses/Permits/Fees 39 Consultant(s) 20 Advertising/Promotion/Web Site 11 Inventory 2 Supplies 3 Professional Services - Legal, Accounting -4 Cash-On-Hand (Working Capital) -5 Miscellaneous -6 Total One-Time 6,000 2,000 250 3,500 6,000 2,500 4,500 1,500 1,31,850 $ S = 2,47,585 -8 Total Startup Costs - = Custe Copy - Calibri BIU Paste -111-AA 1.A.A. E Font E ce Wrap lex E Merge & Center - Alignment S. - 3 Format Painter Clipboard - 012 f =IF(B12>0,(B12*C12),"") DEF SINGH FLOWER NURSEY 4 Enter your Company Name here 5 [Month] (DayL [Year] of Months Monthly Cost One-Time Cost Total Cost 12 s 54,000 12,000 3,600 2,600 4,500 $ 1,000 $ 2,000 $ 600S 650 S 250 $ 100 S 900 $ 95 $ 250 $ 54,000 S 12,000 $ 4,000 $ 3,600 IS 2,600 $ 500 $ 400 $ 10,800 $ 285 $ 500 $ 500 7. Cost Item 8 MONTHLY COSTS 9 Employee Salaries 10 Employee Payroll Taxes and Benefits 11 Consultants) 12 Rent/Lease Payments 13 Mortgage Payments 14 Advertising/Promotion/Web Site 15 Postage/Shipping 16 Supplies 17 Communication/Telephone 18 Utilities 19 Other Taxes 20 Insurance 21 Interest Expense 22 Bank Service Charges 23 Repairs & Maintenance 24 Professional Services - Legal Accounting 25 Travel & Entertainment 26 Miscellaneous 27 Total Monthly Costs 400 10,800 285 500 660 3,300 $ 3,300 5,000 $ 850 $ 1,500 $ 15,000 4,250 3,000 S $ $ 15,000 4,250 3,000 1,500 $ $ 1.500 1,15,735 Blank Template Example Ng pa e Spa wi AMOUNT TOTAL ANECULARS REVENUES SALES FORECAST Employee Salaries Employee Payroll Taxes and Benefits Consultant(s) Rent/Lease Payments Mortgage Payments Advertising/Promotion/Web Site Postage/Shipping Supplies Communication/Telephone Utilities Insurance Bank Service Charges Repairs & Maintenance Professional Services - Legal, Accounting Miscellaneous Profit $ 54,000.00 $ 12,000.00 $4,000.00 $3,600.00 $ 2,600.00 $ 500.00 $ 400.00 $ 10,800.00 $285.00 $ 500.00 $3,300.00 $ 15,000.00 $ 4,250.00 $3,000.00 $ 1,500.00 Sheet1 F52 X D $ 10,600.00 17,000 25,000 4,000 1,200 300 45,000 2,500 28 29 ONE-TIME COSTS 30 Land 31 Building(s) 32 Machinery & Equipment 33 Furniture & Fixtures 34 Computer Equipment 35 Computer Software 36 Leasehold Improvements 37 Security Deposit(s) 38 Business Licenses/Permits/Fees 39 Consultant(s) 20 Advertising/Promotion/Web Site 11 Inventory 2 Supplies 3 Professional Services - Legal, Accounting -4 Cash-On-Hand (Working Capital) -5 Miscellaneous -6 Total One-Time 6,000 2,000 250 3,500 6,000 2,500 4,500 1,500 1,31,850 $ S = 2,47,585 -8 Total Startup Costs - = Custe Copy - Calibri BIU Paste -111-AA 1.A.A. E Font E ce Wrap lex E Merge & Center - Alignment S. - 3 Format Painter Clipboard - 012 f =IF(B12>0,(B12*C12),"") DEF SINGH FLOWER NURSEY 4 Enter your Company Name here 5 [Month] (DayL [Year] of Months Monthly Cost One-Time Cost Total Cost 12 s 54,000 12,000 3,600 2,600 4,500 $ 1,000 $ 2,000 $ 600S 650 S 250 $ 100 S 900 $ 95 $ 250 $ 54,000 S 12,000 $ 4,000 $ 3,600 IS 2,600 $ 500 $ 400 $ 10,800 $ 285 $ 500 $ 500 7. Cost Item 8 MONTHLY COSTS 9 Employee Salaries 10 Employee Payroll Taxes and Benefits 11 Consultants) 12 Rent/Lease Payments 13 Mortgage Payments 14 Advertising/Promotion/Web Site 15 Postage/Shipping 16 Supplies 17 Communication/Telephone 18 Utilities 19 Other Taxes 20 Insurance 21 Interest Expense 22 Bank Service Charges 23 Repairs & Maintenance 24 Professional Services - Legal Accounting 25 Travel & Entertainment 26 Miscellaneous 27 Total Monthly Costs 400 10,800 285 500 660 3,300 $ 3,300 5,000 $ 850 $ 1,500 $ 15,000 4,250 3,000 S $ $ 15,000 4,250 3,000 1,500 $ $ 1.500 1,15,735 Blank Template Example Ng pa e Spa wi