Rekayasa Tambang Indonesia

Start your own business plan »

Mining Software Business Plan

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
Geological Interpretation and Modeling 0% $15,750 $15,750 $15,750 $15,750 $15,750 $15,750 $15,750 $15,750 $15,750 $15,750 $15,750 $15,750
Mine Design 0% $50,400 $50,400 $50,400 $50,400 $50,400 $50,400 $50,400 $50,400 $50,400 $50,400 $50,400 $50,400
Mining Optimization 0% $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450
Mine Scheduling 0% $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200
Dump Design and Rehabilitation 0% $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
Total Sales $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000
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
Geological Interpretation and Modeling $2,930 $2,930 $2,930 $2,930 $2,930 $2,930 $2,930 $2,930 $2,930 $2,930 $2,930 $2,930
Mine Design $9,374 $9,374 $9,374 $9,374 $9,374 $9,374 $9,374 $9,374 $9,374 $9,374 $9,374 $9,374
Mining Optimization $17,577 $17,577 $17,577 $17,577 $17,577 $17,577 $17,577 $17,577 $17,577 $17,577 $17,577 $17,577
Mine Scheduling $4,687 $4,687 $4,687 $4,687 $4,687 $4,687 $4,687 $4,687 $4,687 $4,687 $4,687 $4,687
Dump Design and Rehabilitation $781 $781 $781 $781 $781 $781 $781 $781 $781 $781 $781 $781
Subtotal Direct Cost of Sales $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349
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
CEO, President and Managing Partner 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Vice President Operations 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Senior Field Engineer 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Senior Programmer/Researcher 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Vice President of Sales & Marketing 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Sales Manager - Mining Engineering 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Sales Manager - Geology 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
General Manager 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Administrative Officer 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total People 9 9 9 9 9 9 9 9 9 9 9 9
Total Payroll $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50%
Long-term Interest Rate 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
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 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000
Direct Cost of Sales $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349 $35,349
Gross Margin $69,651 $69,651 $69,651 $69,651 $69,651 $69,651 $69,651 $69,651 $69,651 $69,651 $69,651 $69,651
Gross Margin % 66.33% 66.33% 66.33% 66.33% 66.33% 66.33% 66.33% 66.33% 66.33% 66.33% 66.33% 66.33%
Expenses
Payroll $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
Sales and Marketing and Other Expenses $5,800 $9,800 $9,800 $11,500 $11,500 $9,400 $9,800 $9,800 $9,800 $9,800 $15,800 $9,400
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $180 $180 $180 $180 $180 $180 $180 $180 $180 $180 $180 $180
Rent $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Payroll Taxes 15% $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $30,780 $34,780 $34,780 $36,480 $36,480 $34,380 $34,780 $34,780 $34,780 $34,780 $40,780 $34,380
Profit Before Interest and Taxes $38,871 $34,871 $34,871 $33,171 $33,171 $35,271 $34,871 $34,871 $34,871 $34,871 $28,871 $35,271
EBITDA $38,871 $34,871 $34,871 $33,171 $33,171 $35,271 $34,871 $34,871 $34,871 $34,871 $28,871 $35,271
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $11,661 $8,718 $8,718 $8,293 $8,293 $8,818 $8,718 $8,718 $8,718 $8,718 $7,218 $8,818
Net Profit $27,209 $26,153 $26,153 $24,878 $24,878 $26,453 $26,153 $26,153 $26,153 $26,153 $21,653 $26,453
Net Profit/Sales 25.91% 24.91% 24.91% 23.69% 23.69% 25.19% 24.91% 24.91% 24.91% 24.91% 20.62% 25.19%
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 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500
Cash from Receivables $0 $1,750 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500 $52,500
Subtotal Cash from Operations $52,500 $54,250 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000
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 $0 $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 $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 $52,500 $54,250 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000
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 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
Bill Payments $6,993 $59,826 $60,847 $60,889 $62,122 $62,069 $60,557 $60,847 $60,847 $60,847 $60,997 $65,187
Subtotal Spent on Operations $24,993 $77,826 $78,847 $78,889 $80,122 $80,069 $78,557 $78,847 $78,847 $78,847 $78,997 $83,187
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 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $24,993 $77,826 $78,847 $78,889 $80,122 $80,069 $78,557 $78,847 $78,847 $78,847 $78,997 $83,187
Net Cash Flow $27,507 ($23,576) $26,153 $26,111 $24,878 $24,931 $26,443 $26,153 $26,153 $26,153 $26,003 $21,813
Cash Balance $127,507 $103,931 $130,084 $156,195 $181,073 $206,003 $232,446 $258,599 $284,752 $310,905 $336,908 $358,722
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 $100,000 $127,507 $103,931 $130,084 $156,195 $181,073 $206,003 $232,446 $258,599 $284,752 $310,905 $336,908 $358,722
Accounts Receivable $0 $52,500 $103,250 $103,250 $103,250 $103,250 $103,250 $103,250 $103,250 $103,250 $103,250 $103,250 $103,250
Other Current Assets $31,588 $31,588 $31,588 $31,588 $31,588 $31,588 $31,588 $31,588 $31,588 $31,588 $31,588 $31,588 $31,588
Total Current Assets $131,588 $211,594 $238,769 $264,922 $291,032 $315,910 $340,841 $367,284 $393,437 $419,590 $445,743 $471,746 $493,559
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $131,588 $211,594 $238,769 $264,922 $291,032 $315,910 $340,841 $367,284 $393,437 $419,590 $445,743 $471,746 $493,559
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 $5,000 $57,797 $58,819 $58,819 $60,051 $60,051 $58,529 $58,819 $58,819 $58,819 $58,819 $63,169 $58,529
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $5,000 $57,797 $58,819 $58,819 $60,051 $60,051 $58,529 $58,819 $58,819 $58,819 $58,819 $63,169 $58,529
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $5,000 $57,797 $58,819 $58,819 $60,051 $60,051 $58,529 $58,819 $58,819 $58,819 $58,819 $63,169 $58,529
Paid-in Capital $195,675 $195,675 $195,675 $195,675 $195,675 $195,675 $195,675 $195,675 $195,675 $195,675 $195,675 $195,675 $195,675
Retained Earnings ($69,088) ($69,088) ($69,088) ($69,088) ($69,088) ($69,088) ($69,088) ($69,088) ($69,088) ($69,088) ($69,088) ($69,088) ($69,088)
Earnings $0 $27,209 $53,363 $79,516 $104,394 $129,272 $155,725 $181,878 $208,031 $234,184 $260,337 $281,990 $308,443
Total Capital $126,588 $153,797 $179,950 $206,103 $230,981 $255,859 $282,312 $308,465 $334,618 $360,771 $386,924 $408,577 $435,030
Total Liabilities and Capital $131,588 $211,594 $238,769 $264,922 $291,032 $315,910 $340,841 $367,284 $393,437 $419,590 $445,743 $471,746 $493,559
Net Worth $126,588 $153,797 $179,950 $206,103 $230,981 $255,859 $282,312 $308,465 $334,618 $360,771 $386,924 $408,577 $435,030