Equipment Rental
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | |||||||||||||
Sales and Rentals | 0% | $10,000 | $10,000 | $11,200 | $14,400 | $17,500 | $20,400 | $28,000 | $29,000 | $26,000 | $18,500 | $15,000 | $10,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $10,000 | $10,000 | $11,200 | $14,400 | $17,500 | $20,400 | $28,000 | $29,000 | $26,000 | $18,500 | $15,000 | $10,000 | |
Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Sales and Rentals | $1,500 | $1,500 | $1,680 | $2,160 | $2,625 | $3,060 | $4,200 | $4,350 | $3,900 | $2,775 | $2,250 | $1,500 | |
Other | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Subtotal Direct Cost of Sales | $1,750 | $1,750 | $1,930 | $2,410 | $2,875 | $3,310 | $4,450 | $4,600 | $4,150 | $3,025 | $2,500 | $1,750 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales/Rental Associate | 0% | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Sales/Rental Associate | 0% | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Sales/Rental Associate | 0% | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Maintenance/Technician | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Maintenance Technician | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 |
Pro Forma Profit and Loss | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $10,000 | $10,000 | $11,200 | $14,400 | $17,500 | $20,400 | $28,000 | $29,000 | $26,000 | $18,500 | $15,000 | $10,000 | |
Direct Cost of Sales | $1,750 | $1,750 | $1,930 | $2,410 | $2,875 | $3,310 | $4,450 | $4,600 | $4,150 | $3,025 | $2,500 | $1,750 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 | $750 | $500 | $750 | |
Total Cost of Sales | $1,750 | $1,750 | $1,930 | $2,410 | $2,875 | $3,310 | $4,450 | $4,600 | $5,150 | $3,775 | $3,000 | $2,500 | |
Gross Margin | $8,250 | $8,250 | $9,270 | $11,990 | $14,625 | $17,090 | $23,550 | $24,400 | $20,850 | $14,725 | $12,000 | $7,500 | |
Gross Margin % | 82.50% | 82.50% | 82.77% | 83.26% | 83.57% | 83.77% | 84.11% | 84.14% | 80.19% | 79.59% | 80.00% | 75.00% | |
Expenses | |||||||||||||
Payroll | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | |
Sales and Marketing and Other Expenses | $917 | $917 | $917 | $2,417 | $2,417 | $917 | $917 | $917 | $917 | $917 | $917 | $917 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Supplies and equipment | $827 | $827 | $827 | $827 | $827 | $827 | $827 | $827 | $827 | $827 | $827 | $827 | |
Utilities | $134 | $134 | $134 | $134 | $134 | $134 | $134 | $134 | $134 | $134 | $134 | $134 | |
Telephone | $651 | $651 | $651 | $651 | $651 | $651 | $651 | $651 | $651 | $651 | $651 | $651 | |
Insurance | $1,204 | $1,204 | $1,204 | $1,204 | $1,204 | $1,204 | $1,204 | $1,204 | $1,204 | $1,204 | $1,204 | $1,204 | |
Repairs and Maintenance | $911 | $911 | $911 | $911 | $911 | $911 | $911 | $911 | $911 | $911 | $911 | $911 | |
Services | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | $236 | |
Rent | $1,035 | $1,035 | $1,035 | $1,035 | $1,035 | $1,035 | $1,035 | $1,035 | $1,035 | $1,035 | $1,035 | $1,035 | |
Payroll Taxes | 15% | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $11,434 | $11,434 | $11,434 | $12,934 | $12,934 | $11,434 | $11,434 | $11,434 | $11,434 | $11,434 | $11,434 | $11,434 | |
Profit Before Interest and Taxes | ($3,184) | ($3,184) | ($2,164) | ($944) | $1,691 | $5,656 | $12,116 | $12,966 | $9,416 | $3,291 | $566 | ($3,934) | |
EBITDA | ($3,184) | ($3,184) | ($2,164) | ($944) | $1,691 | $5,656 | $12,116 | $12,966 | $9,416 | $3,291 | $566 | ($3,934) | |
Interest Expense | $2,663 | $2,663 | $2,663 | $2,643 | $2,623 | $2,604 | $2,584 | $2,565 | $2,442 | $2,296 | $2,151 | $2,043 | |
Taxes Incurred | ($1,754) | ($1,754) | ($1,448) | ($1,076) | ($280) | $916 | $2,860 | $3,120 | $2,092 | $298 | ($476) | ($1,793) | |
Net Profit | ($4,093) | ($4,093) | ($3,379) | ($2,511) | ($653) | $2,136 | $6,672 | $7,281 | $4,882 | $696 | ($1,110) | ($4,184) | |
Net Profit/Sales | -40.93% | -40.93% | -30.17% | -17.44% | -3.73% | 10.47% | 23.83% | 25.11% | 18.78% | 3.76% | -7.40% | -41.84% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $2,000 | $2,000 | $2,240 | $2,880 | $3,500 | $4,080 | $5,600 | $5,800 | $5,200 | $3,700 | $3,000 | $2,000 | |
Cash from Receivables | $4,500 | $4,767 | $8,000 | $8,032 | $9,045 | $11,603 | $14,077 | $16,523 | $22,427 | $23,120 | $20,600 | $14,707 | |
Subtotal Cash from Operations | $6,500 | $6,767 | $10,240 | $10,912 | $12,545 | $15,683 | $19,677 | $22,323 | $27,627 | $26,820 | $23,600 | $16,707 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $149,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $151,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $306,500 | $6,767 | $10,240 | $10,912 | $12,545 | $15,683 | $19,677 | $22,323 | $27,627 | $26,820 | $23,600 | $16,707 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | |
Bill Payments | $9,251 | $7,543 | $7,553 | $7,910 | $9,727 | $10,467 | $10,363 | $16,469 | $17,042 | $15,688 | $11,732 | $10,662 | |
Subtotal Spent on Operations | $14,051 | $12,343 | $12,353 | $12,710 | $14,527 | $15,267 | $15,163 | $21,269 | $21,842 | $20,488 | $16,532 | $15,462 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Principal Repayment of Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $12,416 | $12,416 | $12,416 | $8,000 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $2,350 | $2,350 | $2,350 | $2,350 | $2,350 | $2,350 | $5,000 | $5,000 | $5,000 | |
Purchase Other Current Assets | $10,000 | $12,000 | $25,000 | $4,000 | $7,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $0 | $30,000 | $27,000 | $34,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | |
Subtotal Cash Spent | $29,468 | $59,759 | $69,770 | $58,477 | $29,294 | $23,034 | $22,930 | $29,036 | $42,025 | $43,320 | $39,365 | $33,879 | |
Net Cash Flow | $277,032 | ($52,993) | ($59,530) | ($47,565) | ($16,748) | ($7,351) | ($3,253) | ($6,713) | ($14,398) | ($16,500) | ($15,765) | ($17,172) | |
Cash Balance | $279,532 | $226,539 | $167,010 | $119,445 | $102,697 | $95,346 | $92,093 | $85,380 | $70,982 | $54,481 | $38,717 | $21,544 |
General Assumptions | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $2,500 | $279,532 | $226,539 | $167,010 | $119,445 | $102,697 | $95,346 | $92,093 | $85,380 | $70,982 | $54,481 | $38,717 | $21,544 |
Accounts Receivable | $9,000 | $12,500 | $15,733 | $16,693 | $20,181 | $25,136 | $29,853 | $38,176 | $44,853 | $43,227 | $34,907 | $26,307 | $19,600 |
Inventory | $19,000 | $17,250 | $15,500 | $13,570 | $11,160 | $8,285 | $4,975 | $4,895 | $5,060 | $4,565 | $3,328 | $2,750 | $2,000 |
Other Current Assets | $6,000 | $16,000 | $28,000 | $53,000 | $57,000 | $64,000 | $64,000 | $64,000 | $64,000 | $64,000 | $64,000 | $64,000 | $64,000 |
Total Current Assets | $36,500 | $325,282 | $285,773 | $250,273 | $207,786 | $200,118 | $194,174 | $199,164 | $199,293 | $182,773 | $156,716 | $131,773 | $107,144 |
Long-term Assets | |||||||||||||
Long-term Assets | $8,000 | $8,000 | $38,000 | $65,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $8,000 | $8,000 | $38,000 | $65,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 | $99,000 |
Total Assets | $44,500 | $333,282 | $323,773 | $315,273 | $306,786 | $299,118 | $293,174 | $298,164 | $298,293 | $281,773 | $255,716 | $230,773 | $206,144 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $9,000 | $7,291 | $7,291 | $7,587 | $9,378 | $10,128 | $9,815 | $15,900 | $16,515 | $15,296 | $11,374 | $10,375 | $8,346 |
Current Borrowing | $9,500 | $158,500 | $158,500 | $158,500 | $158,500 | $158,500 | $158,500 | $158,500 | $158,500 | $146,084 | $133,668 | $121,252 | $113,252 |
Other Current Liabilities | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 |
Subtotal Current Liabilities | $22,200 | $169,491 | $169,491 | $169,787 | $171,578 | $172,328 | $172,015 | $178,100 | $178,715 | $165,080 | $148,742 | $135,327 | $125,298 |
Long-term Liabilities | $10,000 | $161,000 | $161,000 | $161,000 | $158,650 | $156,300 | $153,950 | $151,600 | $149,250 | $146,900 | $141,900 | $136,900 | $131,900 |
Total Liabilities | $32,200 | $330,491 | $330,491 | $330,787 | $330,228 | $328,628 | $325,965 | $329,700 | $327,965 | $311,980 | $290,642 | $272,227 | $257,198 |
Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Retained Earnings | $12,300 | $6,883 | $1,467 | ($3,950) | ($9,367) | ($14,783) | ($20,200) | ($25,617) | ($31,033) | ($36,450) | ($41,867) | ($47,283) | ($52,700) |
Earnings | $0 | ($4,093) | ($8,185) | ($11,564) | ($14,075) | ($14,728) | ($12,591) | ($5,919) | $1,362 | $6,244 | $6,940 | $5,830 | $1,646 |
Total Capital | $12,300 | $2,791 | ($6,719) | ($15,514) | ($23,442) | ($29,511) | ($32,791) | ($31,536) | ($29,671) | ($30,206) | ($34,927) | ($41,453) | ($51,054) |
Total Liabilities and Capital | $44,500 | $333,282 | $323,773 | $315,273 | $306,786 | $299,118 | $293,174 | $298,164 | $298,293 | $281,773 | $255,716 | $230,773 | $206,144 |
Net Worth | $12,300 | $2,791 | ($6,719) | ($15,514) | ($23,442) | ($29,511) | ($32,791) | ($31,536) | ($29,671) | ($30,206) | ($34,927) | ($41,453) | ($51,054) |