SALES PROJECTIONS Thomas Custom Builders
Year 1 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Sales Budget Deposits - - 17,500 17,500 17,500 17,500 17,500 17,500 - - - - 105,000 House Sales - - - - 315,000 315,000 315,000 945,000 Lot Sales - - - - 87,500 87,500 87,500 262,500 Product/Service Category D - - - - Product/Service Category E - - - - Product/Service Category F - - - - Product/Service Category G - - - - Gross Sales - - 17,500 17,500 17,500 17,500 17,500 17,500 - 402,500 402,500 402,500 1,312,500 Less: Returns & Allowances - - - -
Net Sales - - 17,500 17,500 17,500 17,500 17,500 17,500 - 402,500 402,500 402,500 1,312,500 Other Income - - - - Total Income - - 17,500 17,500 17,500 17,500 17,500 17,500 - 402,500 402,500 402,500 1,312,500 Credit Management Sales (cash) - - 17,500 17,500 17,500 17,500 17,500 17,500 - 402,500 402,500 402,500 1,312,500 Sales (credit) - - - - Received on Account - - - -
Bad Debt Expense - - - -
Year 1 Assumptions Deposits House Sales Lot Sales Product/Service Category D Product/Service Category E Product/Service Category F Product/Service Category G Less: Returns & Allowances Other Income
Sales (cash) Sales (credit) Received on Account Bad Debt Expense
staged deposists on 3 houses
YEAR 1 YEAR 1 YEAR 1
closing on 3 houses @ $350,000 (deposits applied) closing on 3 lots @ $87,500
SALES PROJECTIONS Thomas Custom Builders
Year 2 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Sales Budget Deposits - - 35,000 35,000 35,000 35,000 35,000 35,000 - - - - 210,000 House Sales - - - - - 315,000 315,000 315,000 315,000 315,000 315,000 1,890,000 Lot Sales - - - - - 87,500 87,500 87,500 87,500 87,500 87,500 525,000 Product/Service Category D - - - - Product/Service Category E - - - - Product/Service Category F - - - - Product/Service Category G - - - - Gross Sales - - 35,000 35,000 35,000 35,000 437,500 437,500 402,500 402,500 402,500 402,500 2,625,000 Less: Returns & Allowances - - - -
Net Sales - - 35,000 35,000 35,000 35,000 437,500 437,500 402,500 402,500 402,500 402,500 2,625,000 Other Income - - - - Total Income - - 35,000 35,000 35,000 35,000 437,500 437,500 402,500 402,500 402,500 402,500 2,625,000 Credit Management Sales (cash) - - 35,000 35,000 35,000 35,000 437,500 437,500 402,500 402,500 402,500 402,500 2,625,000 Sales (credit) - - - - Received on Account - - - -
Bad Debt Expense - - - -
Year 2 Assumptions Deposits House Sales Lot Sales Product/Service Category D Product/Service Category E Product/Service Category F Product/Service Category G Less: Returns & Allowances Other Income
Sales (cash) Sales (credit) Received on Account Bad Debt Expense
closing on 6 houses @ $350,000 (deposits applied) closing on 6 lots @ $87,500
staged deposists on 6 houses
YEAR 2 YEAR 2 YEAR 2 YEAR 2
SALES PROJECTIONS Thomas Custom Builders
Year 3 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Sales Budget Deposits - - 35,000 35,000 - 35,000 70,000 35,000 - 35,000 35,000 - 280,000 House Sales - - - - - 315,000 630,000 315,000 315,000 315,000 315,000 315,000 2,520,000 Lot Sales - - - - - 87,500 175,000 87,500 87,500 87,500 87,500 87,500 700,000 Product/Service Category D - - - - Product/Service Category E - - - - Product/Service Category F - - - - Product/Service Category G - - - - Gross Sales - - 35,000 35,000 - 437,500 875,000 437,500 402,500 437,500 437,500 402,500 3,500,000 Less: Returns & Allowances - - - -
Net Sales - - 35,000 35,000 - 437,500 875,000 437,500 402,500 437,500 437,500 402,500 3,500,000 Other Income - - - - Total Income - - 35,000 35,000 - 437,500 875,000 437,500 402,500 437,500 437,500 402,500 3,500,000 Credit Management Sales (cash) - - 35,000 35,000 - 437,500 875,000 437,500 402,500 437,500 437,500 402,500 3,500,000 Sales (credit) - - - - Received on Account - - - -
Bad Debt Expense - - - -
Year 3 Assumptions Deposits House Sales Lot Sales Product/Service Category D Product/Service Category E Product/Service Category F Product/Service Category G Less: Returns & Allowances Other Income
Sales (cash) Sales (credit) Received on Account Bad Debt Expense
closing on 8 houses @ $350,000 (deposits applied) closing on 8 lots @ $87,500
YEAR 3 YEAR 3 YEAR 3 staged deposists on 8 houses
INVENTORY PROJECTIONS Thomas Custom Builders
Year 1 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Inventory Management
Inventory Purchases - 133,875 133,875 133,875 133,875 133,875 133,875 - - - - - 803,250
Inventory/ Raw Material Purchases (Cash) - 133,875 133,875 133,875 133,875 133,875 133,875 - - - - - 803,250
Inventory/ Raw Material Purchases (Credit) - - - -
Payment on Account - - - -
Production Expenses Freight-in & Trucking - - - -
Insurance - 8,925 8,925 8,925 8,925 8,925 8,925 - - - - - 53,550 Payroll Expenses - production Salaries & Wages - - - -
Employee Benefits - - - -
Payroll Taxes - - - -
Rent - - - -
Repairs & Maintenance - - - -
Rework - - - -
Subcontracting - 34,679 69,358 104,038 138,717 173,396 208,075 173,396 138,717 104,038 69,358 34,679 1,248,450 Utilities - - - -
Other Production Expenses - - - - 21,000 21,000 21,000 63,000 Inventory Production Expenses - 43,604 78,283 112,963 147,642 182,321 217,000 173,396 138,717 125,038 90,358 55,679 1,365,000 Inventory Balance Beginning Inventory Balance - - 177,479 374,763 606,725 873,367 1,174,688 1,510,688 1,669,208 1,807,925 1,590,838 1,339,071 - Inventory Purchased - 133,875 133,875 133,875 133,875 133,875 133,875 - - - - - 803,250 Inventory Production - 43,604 78,283 112,963 147,642 182,321 217,000 173,396 138,717 125,038 90,358 55,679 1,365,000 (Cost of Goods Sold) - - (14,875) (14,875) (14,875) (14,875) (14,875) (14,875) - (342,125) (342,125) (342,125) (1,115,625)
Ending Inventory Balance - 177,479 374,763 606,725 873,367 1,174,688 1,510,688 1,669,208 1,807,925 1,590,838 1,339,071 1,052,625 1,052,625
Year 1 Assumptions
Inventory/ Raw Material Purchases Freight-in & Trucking
Insurance
Payroll Expenses - production Salaries & Wages Employee Benefits Payroll Taxes Rent
Repairs & Maintenance Rework
Subcontracting Utilities
Other Production Expenses real estate commission at 6% of sale price - $21,000 per sale - 3 houses sold subcontracted construction and design labor estimated at 71% of house cost
YEAR 1 YEAR 1 YEAR 1 YEAR 1
YEAR 1 YEAR 1 YEAR 1 YEAR 1
budget to purchase 6 lots @ $74,375 plus materials for 6 houses @ 20% of house cost $59,500 per house builder's risk and warranty service--estimated at 3% of total cost to build each house--$8,925 per house - 6 houses
INVENTORY PROJECTIONS Thomas Custom Builders
Year 2 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Inventory Management
Inventory Purchases 133,875 133,875 133,875 133,875 133,875 133,875 - - - - 803,250
Inventory/ Raw Material Purchases (Cash) 133,875 133,875 133,875 133,875 133,875 133,875 - - - - 803,250
Inventory/ Raw Material Purchases (Credit) - - - -
Payment on Account - - - -
Production Expenses Freight-in & Trucking - - - -
Insurance 8,925 8,925 8,925 8,925 8,925 8,925 - - - - 53,550 Payroll Expenses - production Salaries & Wages - - - -
Employee Benefits - - - -
Payroll Taxes - - - -
Rent - - - -
Repairs & Maintenance - - - -
Rework - - - -
Subcontracting 34,679 69,358 104,038 138,717 173,396 208,075 173,396 138,717 104,038 69,358 34,679 - 1,248,450 Utilities - - - - Other Production Expenses - - - - 21,000 21,000 21,000 21,000 21,000 21,000 126,000
Inventory Production Expenses 43,604 78,283 112,963 147,642 182,321 217,000 194,396 159,717 125,038 90,358 55,679 21,000 1,428,000
Inventory Balance
Beginning Inventory Balance 1,052,625 1,230,104 1,442,263 1,659,350 1,911,117 2,197,563 2,518,688 2,341,208 2,129,050 1,911,963 1,660,196 1,373,750 1,052,625 Inventory Purchased 133,875 133,875 133,875 133,875 133,875 133,875 - - - - 803,250 Inventory Production 43,604 78,283 112,963 147,642 182,321 217,000 194,396 159,717 125,038 90,358 55,679 21,000 1,428,000 (Cost of Goods Sold) - - (29,750) (29,750) (29,750) (29,750) (371,875) (371,875) (342,125) (342,125) (342,125) (342,125) (2,231,250)
Ending Inventory Balance 1,230,104 1,442,263 1,659,350 1,911,117 2,197,563 2,518,688 2,341,208 2,129,050 1,911,963 1,660,196 1,373,750 1,052,625 1,052,625
Year 2 Assumptions
Inventory/ Raw Material Purchases Freight-in & Trucking
Insurance
Payroll Expenses - production Salaries & Wages Employee Benefits Payroll Taxes Rent
Repairs & Maintenance Rework
Subcontracting Utilities
Other Production Expenses real estate commission at 6% of sale price - $21,000 per sale - 6 houses sold subcontracted construction and design labor estimated at 71% of house cost
YEAR 2 YEAR 2 YEAR 2 YEAR 2
YEAR 2 YEAR 2 YEAR 2 YEAR 2
budget to purchase 6 lots @ $74,375 plus materials for 6 houses @ 20% of house cost $59,500 per house builder's risk and warranty service--estimated at 3% of total cost to build each house--$8,925 per house - 6 houses
INVENTORY PROJECTIONS Thomas Custom Builders
Year 3 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Inventory Management
Inventory Purchases 267,750 267,750 267,750 267,750 267,750 267,750 - - - - 1,606,500
Inventory/ Raw Material Purchases (Cash) 267,750 267,750 267,750 267,750 267,750 267,750 - - - - 1,606,500
Inventory/ Raw Material Purchases (Credit) - - - -
Payment on Account - - - -
Production Expenses Freight-in & Trucking - - - -
Insurance 17,850 17,850 17,850 17,850 17,850 17,850 - - - - 107,100 Payroll Expenses - production Salaries & Wages - - - -
Employee Benefits - - - -
Payroll Taxes - - - -
Rent - - - -
Repairs & Maintenance - - - -
Rework - - - -
Subcontracting 69,358 138,717 208,075 277,433 346,792 416,150 346,792 277,433 208,075 138,717 69,358 - 2,496,900 Utilities - - - - Other Production Expenses - - - - - 21,000 42,000 21,000 21,000 21,000 21,000 21,000 168,000
Inventory Production Expenses 87,208 156,567 225,925 295,283 364,642 455,000 388,792 298,433 229,075 159,717 90,358 21,000 2,772,000
Inventory Balance
Beginning Inventory Balance 1,052,625 1,407,583 1,831,900 2,295,825 2,829,108 3,461,500 3,812,375 3,457,417 3,383,975 3,270,925 3,058,767 2,777,250 1,052,625 Inventory Purchased 267,750 267,750 267,750 267,750 267,750 267,750 - - - - 1,606,500 Inventory Production 87,208 156,567 225,925 295,283 364,642 455,000 388,792 298,433 229,075 159,717 90,358 21,000 2,772,000 (Cost of Goods Sold) - - (29,750) (29,750) - (371,875) (743,750) (371,875) (342,125) (371,875) (371,875) (342,125) (2,975,000)
Ending Inventory Balance 1,407,583 1,831,900 2,295,825 2,829,108 3,461,500 3,812,375 3,457,417 3,383,975 3,270,925 3,058,767 2,777,250 2,456,125 2,456,125
Year 3 Assumptions
Inventory/ Raw Material Purchases Freight-in & Trucking
Insurance
Payroll Expenses - production Salaries & Wages Employee Benefits Payroll Taxes Rent
Repairs & Maintenance Rework
Subcontracting Utilities
Other Production Expenses real estate commission at 6% of sale price - $21,000 per sale - 8 houses sold subcontracted construction and design labor estimated at 71% of house cost
YEAR 3 YEAR 3 YEAR 3 YEAR 3
YEAR 3 YEAR 3 YEAR 3 YEAR 3
budget to purchase 12 lots @ $74,375 plus materials for 12 houses @ 20% of house cost $59,500 per house builder's risk and warranty service--estimated at 3% of total cost to build each house--$8,925 per house - 12 houses
OPERATING EXPENSE PROJECTIONS Thomas Custom Builders
Year 1 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Operating Expenses
Advertising - - 3,300 500 500 500 500 500 1,300 300 300 300 8,000
Bank Charges - - - -
Dues & Subscriptions - 250 - - 250 - - 250 - - 250 - 1,000 Insurance 833 833 834 833 833 834 833 833 834 833 833 834 10,000 Licenses & Fees 200 - - 100 - - 100 - - 100 - 500
Marketing & Promotion - 1,000 4,000 - - 1,000 1,000 1,000 1,000 - - 1,000 10,000 Meals & Entertainment - - 100 100 100 100 100 100 100 100 100 100 1,000 Miscellaneous - - - -
Office Expense (postage) 20 20 20 150 20 20 20 20 20 150 20 20 500
Office Supplies 83 83 84 83 83 84 83 83 84 83 83 84 1,000 Outside Services - - - -
Payroll Expenses Salaries & Wages - - - -
Payroll Taxes - - - -
Benefits - - - -
Professional Fees 750 - - 250 - 250 500 - 250 - - - 2,000 Property Taxes - - - -
Rent - - - -
Repairs & Maintenance - - - -
Shipping & Delivery - - - -
Telephone 166 167 166 167 167 167 166 167 166 167 167 167 2,000 Training & Development - - - -
Travel - - - -
Utilities - - - -
Vehicle 500 500 500 500 500 500 500 500 500 500 500 500 6,000 Other Supplies 25 50 50 25 50 50 25 50 50 25 50 50 500
Other General Expenses 42 41 42 42 41 42 42 41 42 41 42 42 500
Other Administrative 167 167 167 167 167 167 167 167 167 167 167 163 2,000
Total Operating Expenses 2,586 3,311 9,263 2,817 2,811 3,714 3,936 3,811 4,513 2,366 2,612 3,260 45,000
Assumptions - Year 1
Advertising Bank Charges Dues & Subscriptions Insurance
Licenses & Fees Marketing & Promotion Meals & Entertainment Miscellaneous Office Expense (postage) Office Supplies Outside Services Payroll Expenses Salaries & Wages Payroll Taxes Benefits Professional Fees Property Taxes Rent
Repairs & Maintenance Shipping & Delivery Telephone
Training & Development Travel
Utilities Vehicle Other Supplies Other General Expenses Other Administrative
YEAR 1 YEAR 1 YEAR 1 YEAR 1 YEAR 1 YEAR 1
postage budget
drafting supplies and general office suppliesbudget
YEAR 1 YEAR 1 YEAR 1 YEAR 1 YEAR 1 YEAR 1
newspaper and magazine advertising at strategic market cycles (prior to home shows and Tour of Homes) annual dues to the USA Associatin of Architects and the Residential Builders Association
general business liability (builder's risk is part of COGs) city taxes and business licenses
web site development and maintenance, brochures, trade shows, graphic design
little time is required for entertaining--budgeted amount covers special events with lenders, vendors & real estate professionals
outside accounting assistance, architectural licensing fees cell phone and one office line with cable modem access truck lease payments, insurance, maintenance and fuel contingency
contingency
OPERATING EXPENSE PROJECTIONS Thomas Custom Builders
Year 2 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Operating Expenses
Advertising - - 6,600 1,000 1,000 1,000 1,000 1,000 2,600 600 600 600 16,000
Bank Charges - - - -
Dues & Subscriptions - 250 - - 250 - - 250 - - 250 - 1,000 Insurance 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 15,000 Licenses & Fees - 400 - - 200 - - 200 - - 200 - 1,000 Marketing & Promotion - 2,000 8,000 - - 2,000 2,000 2,000 2,000 - - 2,000 20,000 Meals & Entertainment 250 250 250 250 250 250 250 250 250 250 250 250 3,000 Miscellaneous - - - -
Office Expense (postage) 20 20 20 150 20 20 20 20 20 150 20 20 500
Office Supplies 83 83 84 83 83 84 83 83 84 83 83 84 1,000 Outside Services - - - -
Payroll Expenses Salaries & Wages - - - -
Payroll Taxes - - - -
Benefits - - - -
Professional Fees 750 750 750 750 750 750 750 750 750 750 750 750 9,000 Property Taxes - - - -
Rent - - - -
Repairs & Maintenance - - - -
Shipping & Delivery - - - -
Telephone 166 167 166 167 167 167 166 167 166 167 167 167 2,000 Training & Development - - - -
Travel - - - -
Utilities - - - -
Vehicle 750 750 750 750 750 750 750 750 750 750 750 750 9,000 Other Supplies 25 50 50 25 50 50 25 50 50 25 50 50 500
Other General Expenses 92 91 92 92 91 92 92 91 92 91 92 92 1,100
Other Administrative 267 267 267 267 267 267 267 267 267 267 267 263 3,200
Total Operating Expenses 3,653 6,328 18,279 4,784 5,128 6,680 6,653 7,128 8,279 4,383 4,729 6,276 82,300
Assumptions - Year 2
Advertising Bank Charges Dues & Subscriptions Insurance
Licenses & Fees Marketing & Promotion Meals & Entertainment Miscellaneous Office Expense (postage) Office Supplies Outside Services Payroll Expenses Salaries & Wages Payroll Taxes Benefits Professional Fees Property Taxes Rent
Repairs & Maintenance Shipping & Delivery Telephone
Training & Development Travel
Utilities Vehicle Other Supplies Other General Expenses Other Administrative
YEAR 2 YEAR 2 YEAR 2 YEAR 2 YEAR 2 YEAR 2
YEAR 2 YEAR 2 YEAR 2 YEAR 2 YEAR 2 YEAR 2
newspaper and magazine advertising at strategic market cycles (prior to home shows and Tour of Homes) annual dues to the USA Associatin of Architects and the Residential Builders Association
general business liability (builder's risk is part of COGs) city taxes and business licenses
web site development and maintenance, brochures, trade shows, graphic design
little time is required for entertaining--budgeted amount covers special events with lenders, vendors & real estate professionals postage budget
drafting supplies and general office suppliesbudget outside accounting assistance, architectural licensing fees cell phone and one office line with cable modem access truck lease payments, insurance, maintenance and fuel contingency
contingency
OPERATING EXPENSE PROJECTIONS Thomas Custom Builders
Year 3 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Operating Expenses
Advertising - - 9,900 1,500 1,500 1,500 1,500 1,500 3,900 900 900 900 24,000
Bank Charges - - - -
Dues & Subscriptions - 250 - - 250 - - 250 - - 250 - 1,000 Insurance 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 Licenses & Fees - 800 - - 400 - - 400 - - 400 - 2,000 Marketing & Promotion - 4,000 16,000 - - 4,000 4,000 4,000 4,000 - - 4,000 40,000 Meals & Entertainment 300 300 300 300 300 300 300 300 300 300 300 300 3,600 Miscellaneous - - - -
Office Expense (postage) 30 30 30 200 30 30 30 30 30 200 30 30 700
Office Supplies 83 83 84 83 83 84 83 83 84 83 83 84 1,000 Outside Services - - - -
Payroll Expenses Salaries & Wages - - - -
Payroll Taxes - - - -
Benefits - - - -
Professional Fees 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 13,200 Property Taxes - - - -
Rent - - - -
Repairs & Maintenance - - - -
Shipping & Delivery - - - -
Telephone 166 167 166 167 167 167 166 167 166 167 167 167 2,000 Training & Development - - - -
Travel - - - -
Utilities - - - -
Vehicle 900 900 900 900 900 900 900 900 900 900 900 900 10,800 Other Supplies 30 60 60 30 60 60 30 60 60 30 60 60 600
Other General Expenses 125 125 125 125 125 125 125 125 125 125 125 125 1,500
Other Administrative 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Total Operating Expenses 4,534 9,615 30,465 6,205 6,715 10,066 10,034 10,715 12,465 5,605 6,115 9,466 122,000
Assumptions - Year 3
Advertising Bank Charges Dues & Subscriptions Insurance
Licenses & Fees Marketing & Promotion Meals & Entertainment Miscellaneous Office Expense (postage) Office Supplies Outside Services Payroll Expenses Salaries & Wages Payroll Taxes Benefits Professional Fees Property Taxes Rent
Repairs & Maintenance Shipping & Delivery Telephone
Training & Development Travel
Utilities Vehicle Other Supplies Other General Expenses Other Administrative
YEAR 3 YEAR 3 YEAR 3 YEAR 3 YEAR 3 YEAR 3
YEAR 3 YEAR 3 YEAR 3 YEAR 3 YEAR 3 YEAR 3
newspaper and magazine advertising at strategic market cycles (prior to home shows and Tour of Homes) annual dues to the USA Associatin of Architects and the Residential Builders Association
general business liability (builder's risk is part of COGs) city taxes and business licenses
web site development and maintenance, brochures, trade shows, graphic design
little time is required for entertaining--budgeted amount covers special events with lenders, vendors & real estate professionals postage budget
drafting supplies and general office suppliesbudget
contingency fund for unplanned expense
cell phone and one office line with cable modem access contingency
contingency
truck lease payments, insurance, maintenance and fuel outside accounting assistance, architectural licensing fees
CAPITAL BUDGET PROJECTIONS
Year 1 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Capital Budget Owner's Draw 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 Investor's Draw - - - - Dividends Paid - - - - Security Deposits - - - - Amortization - - - -
Depreciation (existing assets) - - - -
Capital Asset Purchases - - - -
Depreciation (new purchases) - - - -
Land - - - -
Year 1 Total Depreciation -
Assumptions - Year 1 Owner's Draw Investor's Draw Dividends Paid Security Deposits Amortization Equipment Equipment Depreciation Furniture Furniture Depreciation Leasehold Improvements Leasehold Depreciation Vehicles Vehicle Depreciation Building Building Depreciation Land
YEAR 1 YEAR 1 YEAR 1
CAPITAL BUDGET PROJECTIONS
Year 2 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Capital Budget Owner's Draw 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 Investor's Draw - - - - Dividends Paid - - - - Security Deposits - - - - Amortization - - - -
Depreciation (existing assets) - - - -
Capital Asset Purchases - - - -
Depreciation (new purchases) - - - -
Land - - - -
Year 2 Total Depreciation -
Assumptions - Year 2 Owner's Draw Investor's Draw Dividends Paid Security Deposits Amortization Equipment Equipment Depreciation Furniture Furniture Depreciation Leasehold Improvements Leasehold Depreciation Vehicles Vehicle Depreciation Building Building Depreciation Land
YEAR 2 YEAR 2 YEAR 2
CAPITAL BUDGET PROJECTIONS
Year 3 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Capital Budget Owner's Draw 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 Investor's Draw - - - - Dividends Paid - - - - Security Deposits - - - - Amortization - - - -
Depreciation (existing assets) - - - -
Capital Asset Purchases - - - -
Depreciation (new purchases) - - - -
Land - - - -
Year 3 Total Depreciation -
Assumptions - Year 3 Owner's Draw Investor's Draw Dividends Paid Security Deposits Amortization Equipment Equipment Depreciation Furniture Furniture Depreciation Leasehold Improvements Leasehold Depreciation Vehicles Vehicle Depreciation Building Building Depreciation Land
YEAR 3 YEAR 3 YEAR 3 YEAR 3
Equity Investment
Thomas Custom Builders JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Year 1 50,000 - - - - 50,000
Year 2 - - - -
Year 3 - - - -
Real Estate Loans Thomas Custom Builders Existing Balance -
New Borrowing JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL Year 1 - - - - Outstanding balance - - - - Year 2 - - - - Outstanding balance - - - - Year 3 - - - - Outstanding balance - - - -
Repayment JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL Year 1 - principal - - - - Year 1 - interest - - - - Year 2 - principal - - - - Year 2 - interest - - - - Year 3 - principal - - - - Year 3 - interest - - - -
Traditional Business Loan and/or other Long-term Loans Thomas Custom Builders Loan 1 Existing Balance -
New Borrowing JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL Year 1 - - - - Outstanding balance - - - - Year 2 - - - - Outstanding balance - - - - Year 3 - - - - Outstanding balance - - - -
Repayment JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL Year 1 - principal - - - - Year 1 - interest - - - - Year 2 - principal - - - - Year 2 - interest - - - - Year 3 - principal - - - - Year 3 - interest - - - - Loan 2 Borrowing JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL Year 1 - - - - Outstanding balance - - - - Year 2 - - - - Outstanding balance - - - - Year 3 - - - - Outstanding balance - - - -
Repayment JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL Year 1 - principal - - - - Year 1 - interest - - - - Year 2 - principal - - - - Year 2 - interest - - - - Year 3 - principal - - - - Year 3 - interest - - - - Line of Credit Thomas Custom Builders Existing Balance -
Borrowing JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Year 1 - 150,000 210,000 240,000 275,000 315,000 350,000 175,000 160,000 - - 25,000 1,900,000 Outstanding balance - 150,000 360,000 600,000 875,000 1,190,000 1,540,000 1,715,000 1,875,000 1,615,000 1,320,000 1,010,000 Year 2 190,000 230,000 245,000 270,000 310,000 330,000 - - - - - 30,000 1,605,000 Outstanding balance 1,200,000 1,430,000 1,675,000 1,945,000 2,255,000 2,585,000 2,375,000 2,125,000 1,875,000 1,585,000 1,255,000 925,000 Year 3 370,000 455,000 505,000 560,000 660,000 325,000 - - - - 2,875,000 Outstanding balance 1,295,000 1,750,000 2,255,000 2,815,000 3,475,000 3,800,000 3,350,000 3,245,000 3,125,000 2,880,000 2,554,000 2,234,000
Repayment JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Year 1 - principal - - - - 260,000 295,000 335,000 890,000 Year 1 - interest - 1,000 2,400 4,000 5,833 7,933 10,267 11,433 12,500 10,767 8,800 6,733 81,667 Year 2 - principal - - - - 210,000 250,000 250,000 290,000 330,000 360,000 1,690,000 Year 2 - interest 8,000 9,533 11,167 12,967 15,033 17,233 15,833 14,167 12,500 10,567 8,367 6,167 141,533 Year 3 - principal - - - - 450,000 105,000 120,000 245,000 326,000 320,000 1,566,000 Year 3 - interest 8,633 11,667 15,033 18,767 23,167 25,333 22,333 21,633 20,833 19,200 17,027 14,893 218,520
Year 1 - total principal paid 890,000 Year 1 - total interest paid 81,667 Year 2 - total principal paid 1,690,000 Year 2 - total interest paid 141,533 Year 3 - total principal paid 1,566,000 Year 3 - total interest paid 218,520