Business active plan

Enter Your Business Name Here
Projected Income Statement – Year One

            Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10    Month 11    Month 12    Totals

Income
Tuna 200,000 204,000 200,000 196,000 200,000 212,000 214,000 208,000 204,000 200,000 200,000 198,000 2,436,000
Salmo 120,000 120,000 120,000 120,000 123,000 147,000 153,000 141,000 135,000 123,000 120,000 120,000 1,542,000
–
–
Total Income 320,000 324,000 320,000 316,000 323,000 359,000 367,000 349,000 339,000 323,000 320,000 318,000 3,978,000

Cost of Sales
Tuna 75,000 76,500 75,000 73,500 75,000 79,500 80,250 78,000 76,500 75,000 75,000 74,250 913,500
Salmo 40,000 40,000 40,000 40,000 41,000 49,000 51,000 47,000 45,000 41,000 40,000 40,000 514,000
–
–
Total Cost of Sales 115,000 116,500 115,000 113,500 116,000 128,500 131,250 125,000 121,500 116,000 115,000 114,250 1,427,500

Gross Margin 205,000 207,500 205,000 202,500 207,000 230,500 235,750 224,000 217,500 207,000 205,000 203,750 2,550,500

Total Salary and Wages 96,927 96,927 96,927 96,927 96,927 96,927 96,927 96,927 96,927 96,927 96,927 96,927 1,163,128

Fixed Business Expenses
Advertising 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000
Car and Truck Expenses 700 700 700 700 700 700 700 700 700 700 700 700 8,400
Commissions and Fees 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
Contract Labor 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000
Credit Card and Bank Charges 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 18,000
Customer Discounts and Refunds 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
Dues and Subscriptions 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Entertainment 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Insurance (Liability and Property) 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Internet 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Legal and Professional Fees 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
Office Expenses 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
Postage and Delivery 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
Rent (on business property) 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000
Rent of Vehicles and Equipment 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
Repairs and Maintenance 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Supplies 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
Telephone and Communications 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
Travel 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Utilities 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
Total Fixed Business Expenses 31,300 31,300 31,300 31,300 31,300 31,300 31,300 31,300 31,300 31,300 31,300 31,300 375,600

Other Expenses
Amortized Start-up Expenses 3,314 3,314 3,314 3,314 3,314 3,314 3,314 3,314 3,314 3,314 3,314 3,314 39,767
Depreciation 3,940 3,940 3,940 3,940 3,940 3,940 3,940 3,940 3,940 3,940 3,940 3,940 47,286
Interest
Commercial Loan 1,195 1,184 1,174 1,164 1,153 1,143 1,132 1,121 1,110 1,100 1,089 1,078 13,642
Commercial Mortgage 1,200 1,198 1,196 1,195 1,193 1,191 1,189 1,187 1,185 1,183 1,181 1,179 14,278
Line of Credit – – – – – – – – – – – – –
Taxes – – – – – – – – – – – – –
Total Other Expenses 9,649 9,637 9,625 9,613 9,600 9,588 9,575 9,563 9,550 9,537 9,524 9,511 114,973

Net Income 67,124 69,636 67,148 64,660 69,172 92,685 97,947 86,210 79,723 69,235 67,248 66,011 896,799

             70,437      72,950      70,462      67,974      72,486      95,999      101,261     89,524      83,036      72,549      70,562      69,325     
             70,437      143,387     213,849     281,823     354,309     450,307     551,569     641,092     724,129     796,678     867,240     936,566    

Description

Please read the business plan and the comment doc.

1. Edit the entry in Excel according to each comment.
2. Answer the comment 1,3,4,6,7&9

Sample Solution