Don't bother with copy and paste.

Get this complete sample business plan as a free text document.

Download for free

Apps & Software icon Mining Software Business Plan

Start your plan

Rekayasa Tambang Indonesia

Executive Summary

PT. Rekayasa Tambang Indonesia (RTI) meets the needs of clients – private and government-owned mining companies – in virtually every sphere of geological interpretation and modeling, mine design and engineering, and mining productivity improvement activities. RTI is a subsidiary company of Mining Engineering Software Development and Technical Assistance (MINER DELTA), a U.S. software manufacturer who provides engineering software for full-service mining design and geological engineering and interpretation, and offering the managerial and technical resources that are vital to solving complex geological interpretation and modeling, mine design, mining optimization, mine scheduling, and dump design and rehabilitation in Indonesia as well as Southeast Asia Region.

The Products
RTI will be offering five distinct products and services. The first is geological interpretation and modeling software systems. This product and service provides the most comprehensive geological database, innovative interpretation tools, advanced modeling techniques and resource reporting for most types of deposits ranging from simple vein, stratiform, and massive deposits, to complex and highly deformed ore bodies. Mine design and engineering software systems will also be offered in addition to mining optimization and scheduling software systems. Lastly, dump design and rehabilitation will perform analysis regarding environmental impact, designing mine waste dump, designing acid drainage, designing ground water drainage, and environmental rehabilitation.

The Market
The total market value for open pit, underground, and quarry mining software technologies has grown at an average rate of 22% over the past five years. Since there is no local engineering software producer in Indonesia, the imported software technologies account for 100% of all open pit, underground, and quarry mining engineering and geological software technologies in Indonesian mining industries. Total imports of mining software technologies totaled $75 million last year, 23.7% greater than previous year’s levels of $60.6 million, which were in turn 26.3% greater than the year before’s imports, valued at $48 million.

Competitive Advantages
The key factors for RTI to create and maintain competitive advantages includes its access to intangible capital (business networks, leadership, talent, entrepreneurs, intellectual property and brand) and advanced technology. These two advantages are interrelated. The “intangible capital” to a large degree is intellectual capital that has been captured by the organization. RTI has been very careful to design systems to capture the human capital that has been developed by the members of the organization. This is indeed a huge advantage because even as some employees are transitory and move on to new companies, their contributions and knowledge are captured by RTI and leveraged by the current employees. This intellectual capital capture then fuels the advanced technology.

RTI is an exciting company that combines advanced technology in the form of software and consulting services serving the mining industry. RTI has forecasted strong revenue numbers for year one, growing steadily through year five. Gross margins will be a high % of sales with net profits improving each year.

Mining software business plan, executive summary chart image

1.1 Mission

The mission of RTI is to establish a strong presence in Indonesia to implement all provisions of the MINER DELTA mission statement with the specific mission of becoming the leading mining and geology software and consulting services provider in Indonesia. This will be done by creating customer value through facilitating optimal and efficient operations by developing the best techniques of image analysis. Also, as the commercial arm of the MINER DELTA, RTI will establish a reputation in the mining industry for exceeding customer expectations through exemplary consultative service.

1.2 Objectives

The financial and marketing objectives of RTI are summarized here.

  1. Healthy sales in the first year, growing steadily through by the fifth year of plan implementation.
  2. Top drawer average gross margin percent of sales revenue.
  3. Net income consistently improving each year.

The financial objectives are converted into marketing objectives. If the company wants to earn its targets for gross margin and sales revenue, then it must set a high average profit margin on sales. To achieve these targets, the company will have to set certain goals for customer awareness such as by proactively approaching the prospective client candidates, teaming-up with other technology providers (hardware manufacturers and platform developers), partnering with reputable local and regional mining contractors, and equipment suppliers to reduce competition, improve pricing as well as reducing risks.

Thus the marketing objective might read:

  • Achieve targeted sales revenue each year for the next five years.
  • Expand customer awareness over the planning period.
  • Reduce competition and risks while lowering price levels by teaming-up with other technology providers (hardware manufacturers and platform developers) and partnering with reputable local and regional mining contractors and equipment suppliers.

1.3 Keys to Success

The key factors for RTI to create a competitive advantage includes its access to intangible capital (business networks, leadership, talent, entrepreneurs, intellectual property and brand) and advanced technology, and its ability to customize its location.

In addition to intangible capital, RTI has a technological advantage with its advanced mining design, scheduling, and geological interpretation programs. Software performance is judged by how accurately the software calculates and produces visibility plots. Other qualitative measures, such as flexibility and ease of use, are important measures that RTI also excels in. To a sustain competitive advantage, RTI will focus on refining and improving the system with future software versions. RTI will continue to research image analysis issues.

The combination of human resources and advanced technology enables RTI to focus on its mission of becoming a customer driven company. Each system will be individually designed and installed by trained personnel. This type of personalized service is only available from RTI; and its ability to operate in a “turn key” fashion is highly valued in its target market. The close personal relationship between customers and RTI is vital to our mission: “to exceed customer expectations through exemplary consultative service.”

In order to effectively operate in this fashion, RTI’s location in Jakarta situates it close to the core of its target market. Further, RTI’s product and services distribution is aided by the locations in the major mining provinces in Indonesia (East Kalimantan, South Kalimantan, South Sumatra, Central Sulawesi). Sales demonstrations, installation and design, service, and maintenance will all be subject to a lower travel cost. As unit sales increase, the distribution cost advantages will be measurable cost competitive advantages. Being close to our customers will provide many intangible benefits: it will help consulting efforts and it will aid in our quest to be customer and market driven, rather than just a branch office, or even a representative of any software manufacturer or foreign consulting firm.

In a typical mine, the most important link in its value chain is clearly the primary activity of operations, to produce more product for a cheaper price. RTI provides value and benefit to its customers by targeting this specific activity in its customer’s value chain. The systems generated by RTI for its clients provide a quality assurance activity that monitors operations and is a guide to raising its customer’s operational performance.

Company Summary

RTI is a subsidiary company of MINER DELTA. Services provided include: geological interpretation and modeling, mine design, mining optimization, mine scheduling, and dump design and rehabilitation.

RTI develops compliance analysis and modeling (including simulation), engineering and design, and productivity improvement systems for every sphere of activity in the mining industry. These systems are designed to be user-friendly, accurate, and portable among computer platforms.

MINER DELTA’s management demands a good financial performance from RTI. As a subsidiary company of MINER DELTA, RTI sets the following objectives for the products and services lines of geological interpretation and modeling, mine design, mining optimization, mine scheduling, and dump design and rehabilitation:

  1. Expand customer awareness over the planning period.
  2. Reduce competition, reduce risks, and lower price level by teaming-up with technology providers (hardware manufacturers and platform developers), partnering with reputable local and regional mining contractors, and equipment suppliers.

2.1 Company Ownership

RTI was incorporated in Jakarta as an Indonesian “Perseroan Terbatas” (PT) corporation on August 4, 2000, under the Foreign Investment Laws of the Republic of Indonesia, with an authorized 1 million shares of common stock.

The company is owned in majority by MINER DELTA. There is one minority owner, an investor from Jakarta, Indonesia.

2.2 Start-up Summary

Total start-up expenses include legal costs, logo design, stationery, as well as start-up assets required, and cash to handle the first few months of consulting operations as sales and account receivable play through the cash flow. The details are included in the following chart and table.

Mining software business plan, company summary chart image

Start-up
Requirements
Start-up Expenses
Legal $5,500
Stationery etc. $3,000
Brochures $5,000
Consultants $48,000
Insurance $1,588
Rent $3,000
Expensed equipment $3,000
Total Start-up Expenses $69,088
Start-up Assets
Cash Required $100,000
Other Current Assets $31,588
Long-term Assets $0
Total Assets $131,588
Total Requirements $200,675
Start-up Funding
Start-up Expenses to Fund $69,088
Start-up Assets to Fund $131,588
Total Funding Required $200,675
Assets
Non-cash Assets from Start-up $31,588
Cash Requirements from Start-up $100,000
Additional Cash Raised $0
Cash Balance on Starting Date $100,000
Total Assets $131,588
Liabilities and Capital
Liabilities
Current Borrowing $0
Long-term Liabilities $0
Accounts Payable (Outstanding Bills) $5,000
Other Current Liabilities (interest-free) $0
Total Liabilities $5,000
Capital
Planned Investment
Investor 1 $70,000
Investor 2 $100,000
Other $25,675
Additional Investment Requirement $0
Total Planned Investment $195,675
Loss at Start-up (Start-up Expenses) ($69,088)
Total Capital $126,588
Total Capital and Liabilities $131,588
Total Funding $200,675

2.3 Company Locations and Facilities

The initial office will be established in the Kebayoran Baru area of South Jakarta, Indonesia, the heart of the Indonesian business area.

Products and Services

The company management team is capitalizing on the lucrative business opportunity of creating compliance analysis and modeling, design and engineering, and productivity improvement software systems to aid mining companies. RTI’s products and services will help companies gain competitive advantage in the marketplace since its products and services will shorten the time-to-market cycle for its clients. This, combined with the management team and business opportunity, has generated tremendous interest for RTI’s compliance systems in the Indonesian mining industry.

3.1 Competitive Comparison

Deposits and excavation images analysis is a developing technology and, as such, the industry lacks standardization.

In this digital image analysis market, no market leader exists, and only three other major players in Asia have developed and begun to market similar products and services. These companies are all in Australia: ECS International of Bowral, Runge Mining, and Mincom of Brisbane.

RTI’s sustainable competitive advantages are its patentable advanced technology and custom system design/installations, human capital, and strategic location.

3.2 Product and Service Description

  1. Geological interpretation and modeling software systems: This product and service provides the most comprehensive geological database, innovative interpretation tools, advanced modeling techniques and resource reporting for most types of deposits ranging from simple vein, stratiform, and massive deposits, to complex and highly deformed orebodies.
  2. Mine design and engineering software systems: Design and engineering software systems for open pit, underground, and quarry mining.
  3. Mining optimisation software systems: Installing a Productivity Improvement System, a total productivity control system to increase productivity level as well as shorten the time-to-market cycle for the clients.
  4. Mine scheduling software systems: Mine scheduling for open pit, underground, and quarry mining.
  5. Dump design and rehabilitation: Performing analysis regarding environmental impact, designing mine waste dump, designing acid drainage, designing ground water drainage, and environmental rehabilitation.

3.3 Fulfillment

The key fulfillment and delivery will be provided by the principals of the business. The real core value is professional expertise, provided by a combination of experience, relationships and connections in the market (quangxi), discipline, smart work, hard work, confidence, and education.

RTI will work with computer hardware, peripherals, accessories and add-ons manufacturers, and platform developers under project-by-project basis. RTI will not exclusively represent any of these companies in order to keep its position as partner for every supplier and technology provider rather than competitor of any of them.

3.4 Technology

MINER DELTA is a recognized leader in supplying integrated geological and mining software technologies and computerized consulting services to the mining industries. As the commercial arm of MINER DELTA in Indonesia, RTI will focus on providing its clients with rapid, non-disruptive, and accurate analysis of deposits and excavations images using the integrated software technologies developed by the parent company. The technologies employ digital image analysis to calculate deposits’ size, orientation/position, and distributions, as well as provide options of mining methods, create value through monitoring mine works-in-progress, and empower mining engineers with crucial operational data.

3.5 Services and Supports

RTI’s services and support are truly done at the client’s site. In essence, the service begins with the technical presentation and on-site demonstration of the technology. Through these initial communications with the potential buyer, RTI will assign its Vice President of Sales and Marketing to conduct an analysis on the client’s operation and begin to customize the system to fill their needs and solve their problem. Once it knows what the prospective client wants, it will then send a technical proposal to the prospective client with a draft contract. A commercial meeting schedule will be arranged with the prospective client to open negotiations with the client’s decision board, and then to close the selling cycle by having the client sign the contract.

Within one working week after contract signing, RTI will submit a document of its project design proposal to the client for approval. Upon project design approval, it will then go to the mine and install the site specific system. Along with the installation it will provide one month of on-site training of MINER DELTA to the supervisors/engineers selected by the client. Besides providing a one year warranty, RTI will also offer the client long-term technical support called “Project Perpetuation Assistance.”

In keeping with its mission to provide market driven products and services, RTI will keep in close contact with all clients and solicit ideas on improvements and necessary changes. This contact will be achieved through consulting for the mines, sending out questionnaires, and maintaining daily emails, as well as weekly telephone contacts, with each client.

3.6 Sales Literature

The business will begin with general corporate and technical brochures establishing the positioning and defining the company’s intangible capital to be transformed into clients’ benefits. These brochures will be developed as part of the start-up expenses.

Literature and mailings for the initial market forums will be very important.

Market Analysis Summary

The total market value for open pit, underground, and quarry mining software technologies has grown at an average rate of 22% over the past five years. Since there is no local engineering software producer in Indonesia, the imported software technologies account for 100% of all open pit, underground, and quarry mining engineering and geological software technologies in Indonesian mining industries. Total imports of mining software technologies totaled $75 million in 2000, 23.7% greater than 1999 levels of $60.6 million, which were in turn 26.3% greater than 1998 imports, valued at $48 million.

The demand for open pit, underground, and quarry mining software technologies is projected to grow at an average rate of 16.89% annually over the next five years. Demand will result from the expansion programs of existing mines and establishment of new mines, particularly for coal, gold, and quarry products. In the coal mine sector, the establishment of a new generation of coal mine companies is expected to be very active during the next few years. Growth in other mining sectors, such as quarry activities for clay, limestone, feldspar, kaolin, marble and other stones, ore and sand iron, will also have an effect on the demand for mining and geology software technologies.

Aside from the coal sector, there is continuous growth in civil construction activities, which requires increased production of building materials such as cement, sands, stones, and various products made from kaolin, limestone, and other quarry materials, such as tiles, bricks, etc. Export growth of these materials is also expected to fuel demand.

Future growth in the mining and geology software technologies market will depend on continued growth in the coal consumption in both global and domestic markets. Government policies will also play a role as the government has sought to support the mining industry through investment incentives and lowering tariff on technologies and equipment imports.

4.1 Market Segmentation

Demographics: During its first five years of operations, RTI will target large domestic coal, base metal, precious metal, and quarry mines. After five years of operations, it will expand to service smaller coal, metal mines, and quarries. This industry is comprised of local companies within every province.

Geographic: RTI will operate regionally in the Southeast Asia region, but will focus initially on the Indonesian mining market.

Technographic: In all cases, the target market is comprised of open pit coal mines, open pit metal mines, underground coal mines, underground metal mines, and quarry mines.

Mining software business plan, market analysis summary chart image

Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Customers Growth CAGR
Open Pit Coal Mining 20% 49,410,000 59,292,000 71,150,400 85,380,480 102,456,576 20.00%
Open Pit Metal Mining 13% 24,705,000 27,793,125 31,267,266 35,175,674 39,572,633 12.50%
Underground Coal Mining 15% 4,575,000 5,261,250 6,050,438 6,958,004 8,001,705 15.00%
Underground Metal Mining 12% 9,150,000 10,248,000 11,477,760 12,855,091 14,397,702 12.00%
Quarry 15% 3,660,000 4,209,000 4,840,350 5,566,403 6,401,363 15.00%
Total 16.89% 91,500,000 106,803,375 124,786,214 145,935,652 170,829,979 16.89%

4.2 Target Market Segment Strategy

In its first five years, RTI will be focusing on large, domestic open pit coal mines, open pit metal mines, underground coal mines, underground metal mines, and quarry mines.

4.2.1 Customer Benefits

Clients do not buy features, they buy benefits. In selling and marketing its products and services, RTI will demonstrate its capability in delivering benefits (4Cs) rather than presenting the company’s marketing mix (4Ps):

  1. Customer needs and wants: Mining companies are typically conservative and fiscally prudent. These companies are interested in cutting costs to improve the “bottom line” since it is difficult for them to manage the “top line” given that their final product is a commodity. Mine companies prefer a vendor to operate in a turn key fashion. They do not have the additional human resources to design, procure equipment, and install a complex system, such as the one RTI offers. They would prefer that an expert come in and do it for them. However, the MINER DELTA software system is an integrated system, so customers do have the choice to procure their own equipment and do have a large say in how to design and install the system.
  2. Cost to the customer: RTI’s products and services costs reflect the advanced technology and comprehensive design and support. Mines operate in large volumes, not only of mined product, but also in dollars. The costs spent on the MINER DELTA software will quickly be earned back in the data generation and mining operations monitoring. The return on investment depends on the adjustments made by the mine operators once given the data. Payback period can be achieved within a few months.
  3. Convenience: As an integrator, RTI installs the custom system and provides the design and installation know-how, as well as the specialized software.
  4. Communication: In order to truly succeed, RTI will have to appeal to the heart of the market: the middle 70% of the market that will buy the product after its perceived risk is mitigated through colleague’s purchase and communication of satisfaction. Another important method to enhance MINER DELTA’s brand awareness will be technical papers by researchers involved in the development of the systems and mine engineers discussing process improvements made possible by the program. In addition, RTI will also offer the client long-term technical support, called the Productivity Improvement Perpetuation Program, and, in keeping with its mission to provide market driven products and services, RTI will keep in close contact with all clients and solicit ideas on improvements and necessary changes.

4.3 Service Business Analysis

The mining and geology software market in Indonesia is one of the fastest growing segments of the computer industry and is estimated to have totaled $91.5 million in 2001. The greatest factors bearing on a software developer’s performance is the underlying strength of the markets in which the company’s products compete and the position of a given product in its life cycle. Interestingly, underlying markets that are experiencing downsizing pressures and networking pressures are the strongest markets for software. The mining industry is experiencing pressures to further automate and increase efficiency, so RTI is in an advantageous position. The fact that the MINER DELTA program is early in its development life cycle also indicates that revenue growth is promising, since its installed base has not even been established. The industry is characterized by rapid innovation and high gross margins.

4.3.1 Main Competitors

There are three other major players in the Indonesian mining industry that have developed and begun to market similar products and services. These companies are ECS International Pty Ltd of Bowral, Australia, Runge Mining of Australia, and Mincom of Brisbane, Australia.

4.3.2 Competition and Buying Patterns

Mining companies operate in large volumes, not only of mined products, but also in dollars. A small percentage increase in mineral recovery translates to hundreds of millions of dollars in increased revenue per year. Since mined products fetch fixed commodity prices, reductions in costs translate directly to the bottom-line. Any procedure or mechanism that can generate value through increased mineral recovery or decreased operating costs is of great interest to mine operators.

RTI must compete against the idea that mining companies should buy mining and geology software, and can get trained to operate it in one or two days; that they don’t need ongoing services, support, and intensive training to integrate the software system operation with the productivity control and improvement systems.

It is vital to build perception in the market that as an integration system, the MINER DELTA system is unique and improves upon current methods because of its three distinct characteristics;

  1. Automatic
  2. Non-disruptive
  3. Accurate

Also, the MINER DELTA system saves money and increases mineral recovery by providing equipment operators with real-time data to monitor and adjust their work-in-progress production, as well as empowering mine engineers with a continuous operational data log with which to make operations adjustments of larger scope.

Strategy and Implementation Summary

Purchases will ultimately occur through direct sales. Mine engineers and geologists who have the most influence on the purchase decision will need to see demonstrations or will need a technical sales presentation. These individuals are usually members of a clients’ decision board who have the authority to purchase this system.

Initial contact will be made by either telephone or a combination of telephone, email, and fax. In this initial contact, the Sales Manager will make an arrangement for a technical presentation in front of the clients’ decision board. To avoid misinterpretation, all the information on the offered products and services will not be sent to prospects, but hand-delivered by the Sales Manager during his/her technical presentation. When the Sales Manager of RTI is visiting the prospect’s site, he/she will bring a demo system that is able to be set up and operated so the client can get a feel for the type of system and for the type of data the system generates.

All promotion efforts will be congruent with the mission to establish a quality reputation in the industry and truly create a quality brand image with RTI products and services. Industrial marketing is dissimilar to traditional consumer marketing. It is an interactive and time intensive process to establish a relationship and reputation. Establishing the relationship is beneficial for the obvious reason, it provides RTI with sales revenue, but, even more importantly, it provides RTI with an information conduit to the industry. A healthy relationship with the customer base will generate ideas, innovations, and other immeasurable intangibles.

Also, since long-term customer satisfaction is the most important key factor to its survival, RTI will offer the client the Productivity Improvement Perpetuation Program and keep in close contact with all clients and solicit ideas on improvements and necessary changes.

5.1 Competitive Edge

The President and Vice President Sales and Marketing of RTI have been working with the prospective clients in the Indonesian mining industry for more than 14 years, maintaining close and effective relationships with the prospective clients’ decision boards at the senior level, and are fully familiar with, and have a good knowledge about, Indonesia as well as the Asia–Pacific business environment.

MINER DELTA is a recognized leader in supplying integrated geological and mining software technologies and computerized consulting services to the mining industries.

The MINER DELTA system is unique and improves upon current methods because of its three distinct characteristics. Also, the MINER DELTA system saves money and increases mineral recovery by providing equipment operators with real-time data to monitor and adjust their work-in-progress production, as well as empowering mine engineers with a continuous operational data log with which to make operations adjustments of larger scope.

5.2 Sales Strategy

RTI’s sales strategy focuses first on building the identity of the company with the large domestic open pit coal mines, open pit metal mines, underground coal mines, underground metal mines and quarry mines who are interested in cutting costs to improve the bottom line. The President and the Vice President of Sales and Marketing of RTI have been able to find these customers using direct sales approaches.

RTI has to sell integration systems which are unique and improve upon current methods because of their three distinct characteristics, i.e. automatic, non-disruptive, and accurate. These systems save money and increase mineral recovery by providing equipment operators with real-time data to monitor and adjust their work-in-progress production as well as empowering mine engineers with a continuous operational data log with which to make operations adjustments of larger scope.

The targeted monthly sales between January and May, 2001 is the result of the intensive direct sales approaches, including technical presentations, mine operations studies, and project proposals which have been done between August and December, 2000.

5.2.1 Sales Forecast

The yearly total sales chart summarizes RTI’s ambitious sales forecast.

Mining software business plan, strategy and implementation summary chart image

Mining software business plan, strategy and implementation summary chart image

Sales Forecast
Year 1 Year 2 Year 3 Year 4 Year 5
Sales
Geological Interpretation and Modeling $189,000 $220,922 $258,236 $301,852 $352,835
Mine Design $604,800 $706,951 $826,355 $965,926 $1,129,071
Mining Optimization $113,400 $132,553 $154,941 $181,111 $211,701
Mine Scheduling $302,400 $353,475 $413,177 $482,963 $564,535
Dump Design and Rehabilitation $50,400 $58,913 $68,863 $80,494 $94,089
Total Sales $1,260,000 $1,472,814 $1,721,572 $2,012,346 $2,352,231
Direct Cost of Sales Year 1 Year 2 Year 3 Year 4 Year 5
Geological Interpretation and Modeling $35,154 $41,092 $48,032 $56,145 $65,628
Mine Design $112,493 $131,493 $153,702 $179,662 $210,007
Mining Optimization $210,924 $246,549 $288,191 $336,866 $393,763
Mine Scheduling $56,246 $65,746 $78,850 $92,168 $107,735
Dump Design and Rehabilitation $9,374 $10,957 $12,808 $14,971 $17,500
Subtotal Direct Cost of Sales $424,192 $495,837 $581,584 $679,812 $794,632

5.3 Milestones

The accompanying bar chart and table show specific milestones, with responsibilities assigned, dates, and (in most cases) budgets. RTI is focusing in this plan on a few key milestones to be accomplished.

Mining software business plan, strategy and implementation summary chart image

Milestones
Milestone Start Date End Date Budget Manager Department
Business Plan 11/1/2000 12/23/2000 $5,000 Managing Partner CEO, President
Stationery 11/6/2000 11/18/2000 $3,000 Administrative Officer Administration
Brochures 11/1/2000 11/30/2000 $5,000 Administrative Officer Administration
Office Equipment 12/1/2000 12/22/2000 $3,000 Administrative Officer Administration
Technical Presentation at …. in East Kalimantan 1/2/2001 1/12/2001 $1,700 Sales Manager – Mining Sales & Marketing
Technical Presentation at …. in East Kalimantan 1/2/2001 1/12/2001 $1,700 Sales Manager – Geology Sales & Marketing
Technical Presentation at …. in South Sumatra 2/5/2001 2/17/2001 $1,700 Sales Manager – Mining Sales & Marketing
Technical Presentation at …. in South Sumatra 2/5/2001 2/17/2001 $1,700 Sales Manager – Geology Sales & Marketing
Technical Presentation at … in Central Sumatra 3/5/2001 3/17/2001 $1,700 Sales Manager – Mining Sales & Marketing
Technical Presentation at …. in Central Sumatra 3/5/2001 3/17/2001 $1,700 Sales Manager – Geology Sales & Marketing
Technical Presentation at …. in Central Sulawesi 4/2/2001 4/13/2001 $1,700 Sales Manager – Mining Sales & Marketing
Technical Presentation at …. in Central Sulawesi 4/2/2001 4/13/2001 $1,700 Sales Manager – Geology Sales & Marketing
Technical Presentation at …. in Irian Jaya 4/23/2001 5/4/2001 $1,700 Sales Manager – Mining Sales & Marketing
Technical Presentation at …. in Irian Jaya 4/23/2001 5/4/2001 $1,700 Sales Manager – Geology Sales & Marketing
Technical Presentation at …. in West Java 5/14/2001 5/25/2001 $1,700 Sales Manager – Mining Sales & Marketing
Technical Presentation at … in West Java 5/14/2001 5/25/2001 $1,700 Sales Manager – Geology Sales & Marketing
Operations Analysis at the most Prospective Clients’ Site 1/8/2001 5/25/2001 $12,000 VP Sales & Marketing Department
Technical Proposals to the Prospective Clients 2/5/2001 6/25/2001 $2,000 VP Sales & Marketing Sales & Marketing
Participating in Indonesia Mining Exhibition 11/1/2001 11/14/2001 $6,000 General Manager Operations
Totals $56,400

Management Summary

RTI is operated and managed by the President and Vice President of Sales and Marketing. When projects have been secured, personnel and staff will be recruited to fill the remaining necessary positions.

6.1 Personnel Plan

As noted in the previous section, the start-up team includes only two persons, i.e. the President and VP Sales & Marketing. When projects have been secured, another vice president (i.e. VP Operations), a General/Office Manager, and five employees will be recruited.

The accompanying table summarizes RTI’s personnel plan between 2001 and 2005.

Personnel Plan
Year 1 Year 2 Year 3 Year 4 Year 5
CEO, President and Managing Partner $60,000 $66,000 $72,600 $79,860 $87,846
Vice President Operations $36,000 $39,600 $43,560 $47,916 $52,708
Senior Field Engineer $12,000 $13,200 $14,520 $15,972 $17,569
Senior Programmer/Researcher $12,000 $13,200 $14,520 $15,972 $17,569
Vice President of Sales & Marketing $36,000 $39,600 $43,560 $47,916 $52,708
Sales Manager – Mining Engineering $12,000 $13,200 $14,520 $15,972 $17,569
Sales Manager – Geology $12,000 $13,200 $14,520 $15,972 $17,569
General Manager $24,000 $26,400 $29,040 $31,944 $35,138
Administrative Officer $12,000 $13,200 $14,520 $15,972 $17,569
Total People 9 9 9 9 9
Total Payroll $216,000 $237,600 $261,360 $287,496 $316,246

Financial Plan

The following table shows the projected revenue of RTI over the period of 2001-2005. The most important elements in the financial plan can be listed as follows:

  1. The company must keep a high gross margin.
  2. In order to take advantage of the market demand growth to increase the yearly sales as well as the profit margin, the company must increase the frequency of business visits to the prospective clients’ sites by 10%. This will result in steady increases in net profits from sales in 2001 through 2005.

7.1 Important Assumptions

The accompanying table lists the main assumptions of RTI for developing its financial projections. The most sensitive assumption is collection days. RTI would like to improve collection days to take pressure off of its working capital.

General Assumptions
Year 1 Year 2 Year 3 Year 4 Year 5
Plan Month 1 2 3 4 5
Current Interest Rate 8.50% 8.50% 8.50% 8.50% 8.50%
Long-term Interest Rate 9.00% 9.00% 9.00% 9.00% 9.00%
Tax Rate 25.42% 25.00% 25.42% 25.00% 25.42%
Other 0 0 0 0 0

7.2 Business Ratios

The following table contains important business ratios for the prepackaged software industry, as determined by the Standard Industry Classification (SIC) Index, 7372.

Ratio Analysis
Year 1 Year 2 Year 3 Year 4 Year 5 Industry Profile
Sales Growth 0.00% 16.89% 16.89% 16.89% 16.89% 9.70%
Percent of Total Assets
Accounts Receivable 20.92% 13.57% 10.29% 8.41% 7.20% 21.50%
Other Current Assets 6.40% 3.55% 2.30% 1.61% 1.18% 45.70%
Total Current Assets 100.00% 100.00% 100.00% 100.00% 100.00% 70.20%
Long-term Assets 0.00% 0.00% 0.00% 0.00% 0.00% 29.80%
Total Assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Current Liabilities 11.86% 7.86% 5.94% 4.80% 4.10% 42.40%
Long-term Liabilities 0.00% 0.00% 0.00% 0.00% 0.00% 19.20%
Total Liabilities 11.86% 7.86% 5.94% 4.80% 4.10% 61.60%
Net Worth 88.14% 92.14% 94.06% 95.20% 95.90% 38.40%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Gross Margin 66.33% 66.33% 66.22% 66.22% 66.22% 100.00%
Selling, General & Administrative Expenses 41.70% 40.22% 38.80% 37.49% 36.25% 79.40%
Advertising Expenses 0.48% 0.45% 0.42% 0.40% 0.37% 1.30%
Profit Before Interest and Taxes 32.85% 34.82% 36.56% 38.31% 39.95% 2.20%
Main Ratios
Current 8.43 12.72 16.83 20.81 24.40 1.51
Quick 8.43 12.72 16.83 20.81 24.40 1.16
Total Debt to Total Assets 11.86% 7.86% 5.94% 4.80% 4.10% 61.60%
Pre-tax Return on Net Worth 95.13% 62.57% 48.83% 41.29% 36.59% 3.50%
Pre-tax Return on Assets 83.85% 57.65% 45.93% 39.30% 35.09% 9.20%
Additional Ratios Year 1 Year 2 Year 3 Year 4 Year 5
Net Profit Margin 24.48% 26.11% 27.27% 28.73% 29.80% n.a
Return on Equity 70.90% 46.92% 36.42% 30.96% 27.29% n.a
Activity Ratios
Accounts Receivable Turnover 6.10 6.10 6.10 6.10 6.10 n.a
Collection Days 57 55 55 55 55 n.a
Accounts Payable Turnover 12.57 12.17 12.17 12.17 12.17 n.a
Payment Days 27 28 28 28 28 n.a
Total Asset Turnover 2.55 1.66 1.26 1.03 0.88 n.a
Debt Ratios
Debt to Net Worth 0.13 0.09 0.06 0.05 0.04 n.a
Current Liab. to Liab. 1.00 1.00 1.00 1.00 1.00 n.a
Liquidity Ratios
Net Working Capital $435,030 $819,646 $1,289,086 $1,867,265 $2,568,205 n.a
Interest Coverage 0.00 0.00 0.00 0.00 0.00 n.a
Additional Ratios
Assets to Sales 0.39 0.60 0.80 0.97 1.14 n.a
Current Debt/Total Assets 12% 8% 6% 5% 4% n.a
Acid Test 6.67 11.00 15.10 19.06 22.65 n.a
Sales/Net Worth 2.90 1.80 1.34 1.08 0.92 n.a
Dividend Payout 0.00 0.00 0.00 0.00 0.00 n.a

7.3 Break-even Analysis

The following table and chart summarize the Break-even Analysis, including the assumed monthly running costs and sales break-even points.

Mining software business plan, financial plan chart image

Break-even Analysis
Monthly Revenue Break-even $53,010
Assumptions:
Average Percent Variable Cost 34%
Estimated Monthly Fixed Cost $35,163

7.4 Projected Profit and Loss

The most important and strategic component in the Projected Profit and Loss statement is the net profit, which is planned and targeted to increase. Month-by-month assumptions for profit and loss are included in the appendix.

Mining software business plan, financial plan chart image

Mining software business plan, financial plan chart image

Mining software business plan, financial plan chart image

Mining software business plan, financial plan chart image

Pro Forma Profit and Loss
Year 1 Year 2 Year 3 Year 4 Year 5
Sales $1,260,000 $1,472,814 $1,721,572 $2,012,346 $2,352,231
Direct Cost of Sales $424,192 $495,837 $581,584 $679,812 $794,632
Other $0 $0 $0 $0 $0
Total Cost of Sales $424,192 $495,837 $581,584 $679,812 $794,632
Gross Margin $835,808 $976,977 $1,139,988 $1,332,534 $1,557,599
Gross Margin % 66.33% 66.33% 66.22% 66.22% 66.22%
Expenses
Payroll $216,000 $237,600 $261,360 $287,496 $316,246
Sales and Marketing and Other Expenses $122,200 $134,420 $147,862 $162,648 $178,913
Depreciation $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0
Utilities $7,200 $7,920 $8,712 $9,583 $10,541
Insurance $2,160 $2,376 $2,614 $2,875 $3,163
Rent $42,000 $46,200 $50,820 $55,902 $61,492
Payroll Taxes $32,400 $35,640 $39,204 $43,124 $47,437
Other $0 $0 $0 $0 $0
Total Operating Expenses $421,960 $464,156 $510,572 $561,629 $617,791
Profit Before Interest and Taxes $413,848 $512,821 $629,417 $770,905 $939,807
EBITDA $413,848 $512,821 $629,417 $770,905 $939,807
Interest Expense $0 $0 $0 $0 $0
Taxes Incurred $105,406 $128,205 $159,977 $192,726 $238,868
Net Profit $308,443 $384,616 $469,440 $578,179 $700,940
Net Profit/Sales 24.48% 26.11% 27.27% 28.73% 29.80%

7.5 Projected Cash Flow

Cash flow projections are critical to RTI’s success. The monthly cash flow is shown in the illustration, with one bar representing the cash flow per month and the other representing the monthly balance. The annual cash flow figures are included here in the following table. Detailed monthly numbers are included in the appendix.

Mining software business plan, financial plan chart image

Pro Forma Cash Flow
Year 1 Year 2 Year 3 Year 4 Year 5
Cash Received
Cash from Operations
Cash Sales $630,000 $736,407 $860,786 $1,006,173 $1,176,116
Cash from Receivables $526,750 $718,968 $840,402 $982,346 $1,148,264
Subtotal Cash from Operations $1,156,750 $1,455,375 $1,701,188 $1,988,519 $2,324,379
Additional Cash Received
Sales Tax, VAT, HST/GST Received $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0
Subtotal Cash Received $1,156,750 $1,455,375 $1,701,188 $1,988,519 $2,324,379
Expenditures Year 1 Year 2 Year 3 Year 4 Year 5
Expenditures from Operations
Cash Spending $216,000 $237,600 $261,360 $287,496 $316,246
Bill Payments $682,028 $839,215 $979,251 $1,133,858 $1,319,563
Subtotal Spent on Operations $898,028 $1,076,815 $1,240,611 $1,421,354 $1,635,809
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0
Subtotal Cash Spent $898,028 $1,076,815 $1,240,611 $1,421,354 $1,635,809
Net Cash Flow $258,722 $378,560 $460,577 $567,165 $688,571
Cash Balance $358,722 $737,282 $1,197,859 $1,765,024 $2,453,595

7.6 Projected Balance Sheet

The following Balance Sheet shows healthy growth of Net Worth and a strong financial position. The monthly estimates are included in the appendix.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3 Year 4 Year 5
Assets
Current Assets
Cash $358,722 $737,282 $1,197,859 $1,765,024 $2,453,595
Accounts Receivable $103,250 $120,689 $141,073 $164,901 $192,752
Other Current Assets $31,588 $31,588 $31,588 $31,588 $31,588
Total Current Assets $493,559 $889,558 $1,370,519 $1,961,512 $2,677,934
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0
Total Assets $493,559 $889,558 $1,370,519 $1,961,512 $2,677,934
Liabilities and Capital Year 1 Year 2 Year 3 Year 4 Year 5
Current Liabilities
Accounts Payable $58,529 $69,912 $81,433 $94,247 $109,730
Current Borrowing $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0
Subtotal Current Liabilities $58,529 $69,912 $81,433 $94,247 $109,730
Long-term Liabilities $0 $0 $0 $0 $0
Total Liabilities $58,529 $69,912 $81,433 $94,247 $109,730
Paid-in Capital $195,675 $195,675 $195,675 $195,675 $195,675
Retained Earnings ($69,088) $239,355 $623,971 $1,093,411 $1,671,590
Earnings $308,443 $384,616 $469,440 $578,179 $700,940
Total Capital $435,030 $819,646 $1,289,086 $1,867,265 $2,568,205
Total Liabilities and Capital $493,559 $889,558 $1,370,519 $1,961,512 $2,677,934
Net Worth $435,030 $819,646 $1,289,086 $1,867,265 $2,568,205

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