Phaethon's Chariot Restorations
Appendix
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | |||||||||||||
Restoration Work | 0% | $5,000 | $5,750 | $6,613 | $7,604 | $8,745 | $10,057 | $11,565 | $13,300 | $15,295 | $17,589 | $20,228 | $23,262 |
Paint Work | 0% | $1,500 | $1,755 | $2,053 | $2,402 | $2,811 | $3,289 | $3,848 | $4,502 | $5,267 | $6,163 | $7,210 | $8,436 |
Parts | 0% | $3,000 | $3,360 | $3,763 | $4,215 | $4,721 | $5,287 | $5,921 | $6,632 | $7,428 | $8,319 | $9,318 | $10,436 |
Service | 0% | $3,600 | $3,600 | $3,000 | $3,900 | $3,900 | $3,600 | $3,600 | $3,900 | $3,900 | $3,900 | $3,900 | $3,600 |
Total Sales | $13,100 | $14,465 | $15,429 | $18,122 | $20,176 | $22,232 | $24,935 | $28,334 | $31,890 | $35,971 | $40,656 | $45,734 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Restoration Work | 0% | $675 | $810 | $972 | $1,166 | $1,400 | $1,680 | $2,016 | $2,419 | $2,902 | $3,483 | $4,179 | $5,015 |
Paint Work | 0% | $313 | $359 | $413 | $475 | $547 | $629 | $723 | $831 | $956 | $1,099 | $1,264 | $1,454 |
Parts | 0% | $0 | $3,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Service | 0% | $1,440 | $1,440 | $1,200 | $1,560 | $1,560 | $1,440 | $1,440 | $1,560 | $1,560 | $1,560 | $1,560 | $1,440 |
Subtotal Direct Cost of Sales | $2,428 | $5,609 | $3,585 | $4,202 | $4,506 | $4,748 | $5,178 | $5,810 | $6,418 | $7,142 | $8,004 | $8,909 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Owner | 0% | $1,000 | $1,000 | $1,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Foreman | 0% | $0 | $1,000 | $1,000 | $1,000 | $1,500 | $1,500 | $1,700 | $1,700 | $2,000 | $2,000 | $2,000 | $2,000 |
Sheet Metal & Body Technician(s) | 0% | $0 | $0 | $0 | $0 | $0 | $1,833 | $1,833 | $1,833 | $1,833 | $1,833 | $1,833 | $1,833 |
Automotive Mechanic(s) | 0% | $0 | $0 | $0 | $0 | $0 | $2,166 | $2,166 | $2,166 | $2,166 | $2,166 | $2,166 | $2,166 |
Painting Technician | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,500 | $1,500 | $1,750 | $2,000 |
Admin Asst. | 0% | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Total People | 1 | 2 | 2 | 3 | 3 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | |
Total Payroll | $1,000 | $2,000 | $2,000 | $4,000 | $4,500 | $8,499 | $8,699 | $8,699 | $10,499 | $10,499 | $10,749 | $10,999 |
Pro Forma Profit and Loss | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $13,100 | $14,465 | $15,429 | $18,122 | $20,176 | $22,232 | $24,935 | $28,334 | $31,890 | $35,971 | $40,656 | $45,734 | |
Direct Cost of Sales | $2,428 | $5,609 | $3,585 | $4,202 | $4,506 | $4,748 | $5,178 | $5,810 | $6,418 | $7,142 | $8,004 | $8,909 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $2,428 | $5,609 | $3,585 | $4,202 | $4,506 | $4,748 | $5,178 | $5,810 | $6,418 | $7,142 | $8,004 | $8,909 | |
Gross Margin | $10,673 | $8,856 | $11,844 | $13,920 | $15,670 | $17,484 | $19,756 | $22,524 | $25,472 | $28,829 | $32,652 | $36,824 | |
Gross Margin % | 81.47% | 61.22% | 76.76% | 76.81% | 77.67% | 78.64% | 79.23% | 79.49% | 79.87% | 80.14% | 80.31% | 80.52% | |
Expenses | |||||||||||||
Payroll | $1,000 | $2,000 | $2,000 | $4,000 | $4,500 | $8,499 | $8,699 | $8,699 | $10,499 | $10,499 | $10,749 | $10,999 | |
Marketing/Promotion | $0 | $1,000 | $1,000 | $1,500 | $1,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Depreciation | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | |
Rent | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | |
Utilities | $2,000 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
Insurance | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Fixtures | $1,000 | $1,000 | $1,200 | $300 | $300 | $300 | $300 | $300 | $300 | $1,000 | $1,000 | $1,000 | |
Total Operating Expenses | $9,466 | $10,666 | $10,866 | $12,466 | $12,966 | $17,965 | $18,165 | $18,165 | $19,965 | $20,665 | $20,915 | $21,165 | |
Profit Before Interest and Taxes | $1,207 | ($1,810) | $978 | $1,454 | $2,704 | ($481) | $1,591 | $4,359 | $5,507 | $8,164 | $11,737 | $15,659 | |
EBITDA | $2,873 | ($144) | $2,644 | $3,120 | $4,370 | $1,185 | $3,257 | $6,025 | $7,173 | $9,830 | $13,403 | $17,325 | |
Interest Expense | $588 | $590 | $587 | $572 | $561 | $554 | $548 | $549 | $534 | $527 | $536 | $525 | |
Taxes Incurred | $185 | ($720) | $117 | $264 | $643 | ($311) | $313 | $1,143 | $1,492 | $2,291 | $3,360 | $4,540 | |
Net Profit | $433 | ($1,680) | $273 | $617 | $1,500 | ($725) | $731 | $2,667 | $3,481 | $5,346 | $7,840 | $10,594 | |
Net Profit/Sales | 3.30% | -11.62% | 1.77% | 3.41% | 7.43% | -3.26% | 2.93% | 9.41% | 10.92% | 14.86% | 19.28% | 23.16% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $13,100 | $14,465 | $15,429 | $18,122 | $20,176 | $22,232 | $24,935 | $28,334 | $31,890 | $35,971 | $40,656 | $45,734 | |
Subtotal Cash from Operations | $13,100 | $14,465 | $15,429 | $18,122 | $20,176 | $22,232 | $24,935 | $28,334 | $31,890 | $35,971 | $40,656 | $45,734 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 6.66% | $872 | $963 | $1,028 | $1,207 | $1,344 | $1,481 | $1,661 | $1,887 | $2,124 | $2,396 | $2,708 | $3,046 |
New Current Borrowing | $0 | $1,000 | $1,000 | $0 | $0 | $0 | $0 | $1,000 | $0 | $0 | $2,000 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $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 | $13,972 | $16,428 | $17,457 | $19,328 | $21,520 | $23,713 | $26,595 | $31,221 | $34,014 | $38,367 | $45,363 | $48,779 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $1,000 | $2,000 | $2,000 | $4,000 | $4,500 | $8,499 | $8,699 | $8,699 | $10,499 | $10,499 | $10,749 | $10,999 | |
Bill Payments | $6,429 | $13,056 | $18,478 | $8,061 | $12,625 | $13,125 | $13,323 | $14,762 | $16,595 | $17,542 | $19,982 | $22,195 | |
Subtotal Spent on Operations | $7,429 | $15,056 | $20,478 | $12,061 | $17,125 | $21,624 | $22,022 | $23,461 | $27,094 | $28,041 | $30,731 | $33,194 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $872 | $963 | $1,028 | $1,207 | $1,344 | $1,481 | $1,661 | $1,887 | $2,124 | $2,396 | $2,708 | $3,046 | |
Principal Repayment of Current Borrowing | $0 | $0 | $500 | $1,000 | $500 | $0 | $0 | $0 | $1,000 | $0 | $0 | $500 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $1,336 | $1,342 | $1,349 | $1,356 | $1,363 | $1,370 | $1,376 | $1,383 | $1,390 | $1,397 | $1,404 | $1,410 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Dividends | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Subtotal Cash Spent | $9,837 | $17,561 | $23,555 | $16,824 | $21,532 | $25,674 | $26,259 | $27,931 | $32,808 | $33,034 | $36,042 | $39,350 | |
Net Cash Flow | $4,135 | ($1,133) | ($6,098) | $2,504 | ($12) | ($1,961) | $336 | $3,290 | $1,206 | $5,333 | $9,321 | $9,429 | |
Cash Balance | $14,135 | $13,003 | $6,904 | $9,409 | $9,397 | $7,435 | $7,772 | $11,062 | $12,268 | $17,601 | $26,922 | $36,352 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $10,000 | $14,135 | $13,003 | $6,904 | $9,409 | $9,397 | $7,435 | $7,772 | $11,062 | $12,268 | $17,601 | $26,922 | $36,352 |
Inventory | $2,000 | $4,855 | $11,219 | $7,633 | $8,403 | $9,012 | $9,496 | $10,357 | $11,620 | $12,837 | $14,284 | $16,007 | $17,818 |
Other Current Assets | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
Total Current Assets | $42,000 | $48,990 | $54,221 | $44,538 | $47,812 | $48,409 | $46,932 | $48,128 | $52,682 | $55,105 | $61,886 | $72,929 | $84,170 |
Long-term Assets | |||||||||||||
Long-term Assets | $100,000 | $100,200 | $100,400 | $100,600 | $100,800 | $101,000 | $101,200 | $101,400 | $101,600 | $101,800 | $102,000 | $102,200 | $102,400 |
Accumulated Depreciation | $0 | $1,666 | $3,332 | $4,998 | $6,664 | $8,330 | $9,996 | $11,662 | $13,328 | $14,994 | $16,660 | $18,326 | $19,992 |
Total Long-term Assets | $100,000 | $98,534 | $97,068 | $95,602 | $94,136 | $92,670 | $91,204 | $89,738 | $88,272 | $86,806 | $85,340 | $83,874 | $82,408 |
Total Assets | $142,000 | $147,524 | $151,289 | $140,140 | $141,948 | $141,079 | $138,136 | $137,866 | $140,954 | $141,911 | $147,226 | $156,803 | $166,578 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $6,000 | $12,428 | $18,215 | $7,641 | $12,188 | $12,682 | $12,833 | $14,209 | $16,013 | $16,879 | $19,244 | $21,386 | $23,476 |
Current Borrowing | $0 | $0 | $1,000 | $1,500 | $500 | $0 | $0 | $0 | $1,000 | $0 | $0 | $2,000 | $1,500 |
Other Current Liabilities | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 |
Subtotal Current Liabilities | $11,500 | $17,928 | $24,715 | $14,641 | $18,188 | $18,182 | $18,333 | $19,709 | $22,513 | $22,379 | $24,744 | $28,886 | $30,476 |
Long-term Liabilities | $119,000 | $117,664 | $116,322 | $114,973 | $113,617 | $112,254 | $110,884 | $109,508 | $108,125 | $106,735 | $105,338 | $103,934 | $102,524 |
Total Liabilities | $130,500 | $135,592 | $141,037 | $129,614 | $131,805 | $130,436 | $129,217 | $129,217 | $130,638 | $129,114 | $130,082 | $132,820 | $133,000 |
Paid-in Capital | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 |
Retained Earnings | ($23,500) | ($23,500) | ($23,500) | ($23,500) | ($24,500) | ($25,500) | ($26,500) | ($27,500) | ($28,500) | ($29,500) | ($30,500) | ($31,500) | ($32,500) |
Earnings | $0 | $433 | ($1,247) | ($974) | ($357) | $1,143 | $418 | $1,149 | $3,816 | $7,297 | $12,643 | $20,484 | $31,078 |
Total Capital | $11,500 | $11,933 | $10,253 | $10,526 | $10,143 | $10,643 | $8,918 | $8,649 | $10,316 | $12,797 | $17,143 | $23,984 | $33,578 |
Total Liabilities and Capital | $142,000 | $147,524 | $151,289 | $140,140 | $141,948 | $141,079 | $138,136 | $137,866 | $140,954 | $141,911 | $147,226 | $156,803 | $166,578 |
Net Worth | $11,500 | $11,933 | $10,253 | $10,526 | $10,143 | $10,643 | $8,918 | $8,649 | $10,316 | $12,797 | $17,143 | $23,984 | $33,578 |