Sample Business Plan
Sample Business Plan
Sample Business Plan
PREPARED BY
DEPARTMENT: MATHEMATICS
FACULTY: SCIENCES
SEMESTER: 2019/1
LEVEL: 300
Table of Contents
Executive Summary ...................................................................................................................... 1
Chart: Highlights ........................................................................................................................ 2
Objectives ....................................................................................................................................... 2
Keys to Success............................................................................................................................... 2
Mission............................................................................................................................................ 3
Company Summary ...................................................................................................................... 3
Company Ownership ...................................................................................................................... 3
Start-up Summary ........................................................................................................................... 3
Table: Start-up ............................................................................................................................ 3
Table: Start-up Funding ............................................................................................................. 4
Chart: Start-up ............................................................................................................................ 7
Products ......................................................................................................................................... 7
i
The Discount Pharmacy
Table: Personnel............................................................................................................................. i
ii
The Discount Pharmacy
Executive Summary
The NeverSick Pharmacy's main goal is to provide prescription medications for our customers at
the lowest prices on the market. We will be able to sell prescriptions at reduced prices by
carefully maintaining efficiencies in our operations and by targeting a specific segment of the
market - those customers who pay for their prescription medications themselves. By focusing on
this segment it gives us additional efficiencies - we avoid disruptions in cash flow often
associated with insurance payments and we can eliminate unnecessary services for the type of
knowledgeable, repeat customer taking maintenance-type medication.
The NeverSick Pharmacy will operate from one store that will serve both mail order customers
and those who visit in person. We will thrive by employing friendly and knowledgeable
personnel, which, along with our great prices, will drive the repeat business that we will rely
upon. We only expect that as the price of medication continues to skyrocket, The NeverSick
Pharmacy will appeal more and more to the customer's sense of value and convenience.
Our advertising, mainly through ads in magazines targeted at the over-55 crowd, will be targeted
at those who are looking to save money on a pricey but necessary and regular expense.
The NeverSick Pharmacy will be led by John Reeleaf, an MBA with experience in the
pharmaceutical industry. Costs will be minimized by maintaining only one pharmacist and filling
the void with pharmaceutical techs. We expect to reach profitability by our second year and will
generate substantial sales by year three.
1
The Discount Pharmacy
Chart: Highlights
Objectives
The objectives for the first three years include:
Keys to Success
The keys to success are:
2
The Discount Pharmacy
Mission
The NeverSick Pharmacy's mission is to provide our customers with the best prices for their
prescription medications. Our convenience and services will exceed the expectations of our
customers.
Company Summary
The NeverSick Pharmacy is located in GWAGWA, Abuja and offers prescription medications at
discount prices to our customers by mail order or at the store front.
Company Ownership
The NeverSick Pharmacy is an Oregon limited liability corporation. The majority stock holder is
John Reeleaf.
Start-up Summary
The NeverSick Pharmacy will incur the following start-up equipment costs:
Please note that these items will be used for more than one year and will therefore be labeled
long-term assets, depreciated using G.A.A.P. approved straight-line depreciation.
Table: Start-up
3
The Discount Pharmacy
Start-up
Requirements
Start-up Expenses
Legal ₦1,000
Rent ₦2,000
Utilities ₦400
Telecom System ₦400
Insurance ₦300
Storefront Build-out ₦15,000
Expensed Equipment ₦4,000
Start-up Assets
Start-up Funding
Start-up Expenses to Fund ₦24,100
Start-up Assets to Fund ₦159,000
Total Funding Required ₦183,100
Assets
4
The Discount Pharmacy
Liabilities
Current Borrowing ₦0
Long-term Liabilities ₦0
Accounts Payable (Outstanding Bills) ₦0
Other Current Liabilities (interest-free) ₦0
Total Liabilities ₦0
Capital
Planned Investment
Seed Funding ₦50,000
John ₦51,000
Friends and Family ₦50,000
Additional Investment Requirement ₦32,100
Total Planned Investment ₦183,100
5
The Discount Pharmacy
Chart: Start-up
Products
The NeverSick Pharmacy offers a wide range of prescription drugs to patients based
in Oregon or nationally. Both generics and name brands are offered.
In order for a customer to purchase medications mail order, they must first contact The
NeverSick Pharmacy over the phone. The customer then needs to either mail in the prescription,
fax it, or email it. Once it is received and payment arrangements are complete, the medicines will
be sent out to the customer via U.S.P.S. or U.P.S. Local customers may stop by the store front to
pick up the medications.
The NeverSick Pharmacy will only service customers who self pay. The self pay customers will
be attracted to The NeverSick Pharmacy because of its superior prices. For many Americans that
do not have drug plans, including the vast majority of Americans over 65, a discount on drugs is
very welcome on today's increasingly tight monthly budgets.
The NeverSick Pharmacy will be able to survive on lower margins due to operating efficiencies
gained through national mail order operations and not accepting insurance policy drug plans
which hampers cash flow. The NeverSick Pharmacy will also save money by not paying for
customer's unlimited access to a pharmacist. If a customer has a question regarding a drug, the
pharmaceutical technician will attempt to answer it. As a last resort the pharmacist will provide
the answer. Generally, the technician or the accompanying printed literature will answer the
question.
This model of saving costs by not providing unlimited access to the pharmacist will be
successful because the majority of customers will be customers who have been taking said
drug for awhile, as opposed to a new prescription, and will not require their hand to be held
The Discount Pharmacy
during the transaction. They are interested in The Pharmacy as an inexpensive source for their
medication.
With each order a printout will accompany the medications providing directions on how to take
the medications, other drugs that should be avoided concurrently, and other useful information.
The NeverSick Pharmacy will be using computer print outs from industry software to reduce the
cost of providing this information.
Note--while the term "self pay" is typically associated with the notion that the customer is paying
for the medication out of pocket without insurance, it is used in this context as the
customer paying for the medications up front regardless if they have insurance. They may be
paying out of pocket, or they may be paying up front and then submitting to their insurance
company's drug plan to reimburse them later.
The NeverSick Pharmacy will employ two different strategies to reach these two diverse market
segments.
Market Segmentation
The NeverSick Pharmacy's customers can be broken down into two different groups, mail order
customers and walk-in customers:
Mail order customers. This group of customers orders their medication through the
mail in an effort to save money. Generally, the mail order customers are older in age,
typically over 50. In general, elderly customers consume more medication relative to
younger people. The mail order customer will typically purchase maintenance
medications - prescriptions for an ongoing ailment that requires regular treatment. This
group of customers will also be more likely to purchase several months of medication at
once.
Walk-in customers. This group of customers are also looking for the lowest prices for
their medication. However, they tend to purchase medications monthly at their local
pharmacy, often at a higher price. There is not a common demographic for this group of
people, other than living in the Portland metropolitan area. Some of these customers
will pay for the medications out of pocket and some will submit a claim to their insurance
company for reimbursement at a later date.
Market
Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Growt CAGR
Customer h
s
Walk-in 8% 345,887 373,558 403,443 435,718 470,575 8.00
customer %
s
Mail 9% 54,876,34 59,815,21 65,198,58 71,066,45 77,462,43 9.00
order 5 6 5 8 9 %
customer
s
Total 8.99% 55,222,23 60,188,77 65,602,02 71,502,17 77,933,01 8.99
2 4 8 6 4 %
We anticipate that by far our largest group of customers will be those who order through the
mail. These customers will be targeted through an advertising campaign in magazines and
newsletters that have an older (>55) audience who regularly need medication and are aware in
advance of their needs. For example, one of the main advertising vehicles will be the A.A.R.P
monthly newsletter.
Walk-in customers will be targeted through advertisements in the local paper, "The Oregonian."
Ads will raise awareness for the The NeverSick Pharmacy and our low prices.
The Discount Pharmacy
Chain pharmacies. These are state or national chains such as Rite-Aid. The advantage
to these chains are better prices through economies of scale, as well as personalized
service. The personalized service takes the form of the chain having a record of your
medication purchases as well as any allergies that you have disclosed to them.
Local pharmacies. These are the pharmacies where you typically know the pharmacist
and they know your medical history. This option is high in personalized service and
convenience, and high in price.
Mail order and Internet pharmacies. These are similar to The NeverSick Pharmacy.
Canadian pharmacies. These pharmacies are located in Canada where the cost of drugs
is lower than in the U.S. These pharmacies can be accessed through mail order, the
Internet, or via travel. Recently there has been the trend for trips arranged for senior
citizens in Northern States to travel up to Canada for the day to pick up their medicines.
Competitive Edge
The NeverSick Pharmacy's competitive edge is superior pricing. To do that we must maintain
our position as the low cost provider by painstakingly ensuring that costs are kept low through
operating efficiencies.
Finally, The NeverSick Pharmacy is not designed to hold the patient's hand during their
purchase. We expect that the vast majority of our customers will already be informed of how to
take the medication, and any side effects or drug interactions that should be avoided. We will
simply provide each patient with a print out of all the relevant information for consumption of
the medication.
The Discount Pharmacy
Marketing Strategy
The marketing strategy will be based on targeted advertisements, appealing to the customer's
sense of value. The marketing campaign's goal will to be increase awareness of The NeverSick
Pharmacy with their target market.
Sales Strategy
The sales strategy will be based on generating long-term relationships with customers. To
facilitate that, we will provide medications at superior prices, have medicines in stock for both
quick shipment and store front pick up, and provide superior customer service. All sales agents
will be trained to provide friendly, knowledgeable customer service. By keeping to these simple,
yet effective, business practices, we expect that our customers will make The NeverSick
Pharmacy their exclusive source for medications. For some, medications are an integral part of
their lives, so establishing long-term relationships will ensure a large, loyal customer base.
Sales Forecast
During the first month we will focus on setting up the store front and generating both local and
national visibility. Sales activity will begin in month two. Sales during months three through five
there will mainly consist of local business through the store front. In month six we expect to see
a jump in sales from mail order. Sales will grow steadily from month six on.
Sales Forecast
Year 1 Year 2 Year 3
Sales
The Discount Pharmacy
Milestones
Table: Milestones
Milestones
Development Requirements
The NeverSick Pharmacy will hire a recent college graduate with a major in computer science to
complete and maintain our simple website. This will keep costs down.
Management Summary
John Reeleaf has experience working with a major drug manufacturer, Eli Lilly, as a drug
representative. He was able to see first hand the profitability associated with the prescription
drug industry, as well as the inefficiencies with which most companies are plagued.
John graduated with an MBA from the University of Oregon's innovative entrepreneurship
program. While there he was awarded a ₦50,000 no interest loan through a business plan
competition. That seed money will be parlayed, along with some other investments, into start up
expenses for The NeverSick Pharmacy. John received an undergraduate degree in chemistry
from the University of Oregon.
Personnel Plan
The NeverSick Pharmacy will employ the following people:
Table: Personnel
Personnel Plan
Year 1 Year 2 Year 3
CEO (John) ₦48,000 ₦52,000 ₦60,000
Pharmacist ₦55,000 ₦60,000 ₦60,000
Pharmacist technician ₦27,500 ₦30,000 ₦30,000
Pharmacist technician ₦27,500 ₦30,000 ₦30,000
Pharmacist technician ₦17,500 ₦30,000 ₦30,000
Sales agent ₦19,200 ₦23,040 ₦23,040
Sales agent ₦19,200 ₦23,040 ₦23,040
Sales agent ₦11,520 ₦23,040 ₦23,040
Counter person/phone rep. ₦14,400 ₦17,280 ₦17,280
The Discount Pharmacy
Financial Plan
The following sections will outline important financial information.
Important Assumptions
The following table details important financial assumptions.
General Assumptions
Year 1 Year 2 Year 3
Plan Month 1 2 3
Current Interest Rate 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00%
Other 0 0 0
Chart: Cash
The Discount Pharmacy
SWOT Analysis
The Discount Pharmacy
Expenses
Payroll ₦268,620 ₦322,960 ₦330,960
Sales and Marketing and Other ₦8,400 ₦8,400 ₦8,400
Expenses
Depreciation ₦1,704 ₦1,704 ₦1,704
Leased Equipment ₦0 ₦0 ₦0
Utilities ₦4,800 ₦4,800 ₦4,800
Insurance ₦3,600 ₦3,600 ₦3,600
Rent ₦24,000 ₦24,000 ₦24,000
Payroll Taxes ₦40,293 ₦48,444 ₦49,644
Other ₦0 ₦0 ₦0
Current Assets
Cash ₦69,525 ₦149,765 ₦338,997
Inventory ₦28,838 ₦81,940 ₦45,962
Other Current Assets ₦0 ₦0 ₦0
Total Current Assets ₦98,364 ₦231,704 ₦384,958
Long-term Assets
Long-term Assets ₦8,500 ₦8,500 ₦8,500
Accumulated Depreciation ₦1,704 ₦3,408 ₦5,112
Total Long-term Assets ₦6,796 ₦5,092 ₦3,388
Total Assets ₦105,160 ₦236,796 ₦388,346
Current Liabilities
Accounts Payable ₦32,484 ₦47,604 ₦45,142
Current Borrowing ₦0 ₦0 ₦0
Other Current Liabilities ₦0 ₦0 ₦0
Subtotal Current Liabilities ₦32,484 ₦47,604 ₦45,142
Long-term Liabilities ₦0 ₦0 ₦0
Total Liabilities ₦32,484 ₦47,604 ₦45,142
Business Ratios
Business ratios for the years of this plan are shown below. Industry profile ratios based on
the NAICS code 446110, Pharmacies and Drug Stores, are shown for comparison.
Table: Ratios
Ratio Analysis
Year 1 Year 2 Year 3 Industry
Profile
Sales Growth n.a. 118.93% 10.82% 11.07%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 60.00% 60.00% 60.00% 14.44%
Selling, General & 93.39% 44.47% 42.20% 2.35%
Administrative Expenses
Advertising Expenses 1.28% 0.50% 0.45% 0.38%
Profit Before Interest and Taxes -19.54% 17.21% 20.53% 1.99%
Main Ratios
Current 3.03 4.87 8.53 1.74
Quick 2.14 3.15 7.51 0.86
Total Debt to Total Assets 30.89% 20.10% 11.62% 63.63%
Pre-tax Return on Net Worth -118.78% 87.98% 64.11% 5.59%
Pre-tax Return on Assets -82.09% 70.29% 56.66% 15.37%
Activity Ratios
Inventory Turnover 10.34 6.99 6.70 n.a
Accounts Payable Turnover 8.52 12.17 12.17 n.a
Payment Days 27 25 31 n.a
Total Asset Turnover 4.20 4.08 2.76 n.a
Debt Ratios
Debt to Net Worth 0.45 0.25 0.13 n.a
Current Liab. to Liab. 1.00 1.00 1.00 n.a
The Discount Pharmacy
Liquidity Ratios
Net Working Capital ₦65,880 ₦184,100 ₦339,817 n.a
Interest Coverage 0.00 0.00 0.00 n.a
Additional Ratios
Assets to Sales 0.24 0.24 0.36 n.a
Current Debt/Total Assets 31% 20% 12% n.a
Acid Test 2.14 3.15 7.51 n.a
Sales/Net Worth 6.08 5.11 3.12 n.a
Dividend Payout 0.00 0.00 0.00 n.a
.
The Discount Pharmacy
Appendix
Table: Sales Forecast
Sales Forecast
Month Month Month Month Month Month Month Month Month Month Month Month
1 2 3 4 5 6 7 8 9 10 11 12
Sales
Walk-in 40% ₦0 ₦8,765 ₦10,987 ₦12,554 ₦16,776 ₦18,443 ₦20,001 ₦21,332 ₦22,343 ₦25,311 ₦26,544 ₦26,544
customers
Mail order 40% ₦0 ₦2,245 ₦5,543 ₦6,543 ₦12,344 ₦15,454 ₦19,877 ₦26,765 ₦31,223 ₦34,232 ₦38,998 ₦38,998
customers
Total Sales ₦0 ₦11,010 ₦16,530 ₦19,097 ₦29,120 ₦33,897 ₦39,878 ₦48,097 ₦53,566 ₦59,543 ₦65,542 ₦65,542
Direct Cost of Month Month Month Month Month Month Month Month Month Month Month Month
Sales 1 2 3 4 5 6 7 8 9 10 11 12
Walk-in ₦0 ₦3,506 ₦4,395 ₦5,022 ₦6,710 ₦7,377 ₦8,000 ₦8,533 ₦8,937 ₦10,124 ₦10,618 ₦10,618
customers
Mail order ₦0 ₦898 ₦2,217 ₦2,617 ₦4,938 ₦6,182 ₦7,951 ₦10,706 ₦12,489 ₦13,693 ₦15,599 ₦15,599
customers
Subtotal Direct ₦0 ₦4,404 ₦6,612 ₦7,639 ₦11,648 ₦13,559 ₦15,951 ₦19,239 ₦21,426 ₦23,817 ₦26,217 ₦26,217
Cost of Sales
Table: Personnel
Personnel Plan
The Discount Pharmacy
Month Month Month Month Month Month Month Month Month Month Month Month
1 2 3 4 5 6 7 8 9 10 11 12
CEO (John) 0% ₦4,000 ₦4,000 ₦4,000 ₦4,000 ₦4,000 ₦4,000 ₦4,000 ₦4,000 ₦4,000 ₦4,000 ₦4,000 ₦4,000
Pharmacist 0% ₦0 ₦5,000 ₦5,000 ₦5,000 ₦5,000 ₦5,000 ₦5,000 ₦5,000 ₦5,000 ₦5,000 ₦5,000 ₦5,000
Pharmacist 0% ₦0 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500
technician
Pharmacist 0% ₦0 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500
technician
Pharmacist 0% ₦0 ₦0 ₦0 ₦0 ₦0 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500 ₦2,500
technician
Sales agent 0% ₦0 ₦0 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920
Sales agent 0% ₦0 ₦0 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920
Sales agent 0% ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920 ₦1,920
Counter 0% ₦0 ₦0 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440
person/phone rep.
Counter 0% ₦0 ₦0 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440
person/phone rep.
Order fulfillment 0% ₦0 ₦0 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440 ₦1,440
Total People 1 4 9 9 9 10 11 11 11 11 11 11
Total Payroll ₦4,000 ₦14,000 ₦22,160 ₦22,160 ₦22,160 ₦24,660 ₦26,580 ₦26,580 ₦26,580 ₦26,580 ₦26,580 ₦26,580
General
Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month Month Month
10 11 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Rate
Long-term 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Interest Rate
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
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 ₦0 ₦11,010 ₦16,530 ₦19,097 ₦29,120 ₦33,897 ₦39,878 ₦48,097 ₦53,566 ₦59,543 ₦65,542 ₦65,542
Direct Cost of Sales ₦0 ₦4,404 ₦6,612 ₦7,639 ₦11,648 ₦13,559 ₦15,951 ₦19,239 ₦21,426 ₦23,817 ₦26,217 ₦26,217
Other Production ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Expenses
Total Cost of Sales ₦0 ₦4,404 ₦6,612 ₦7,639 ₦11,648 ₦13,559 ₦15,951 ₦19,239 ₦21,426 ₦23,817 ₦26,217 ₦26,217
Gross Margin ₦0 ₦6,606 ₦9,918 ₦11,458 ₦17,472 ₦20,338 ₦23,927 ₦28,858 ₦32,140 ₦35,726 ₦39,325 ₦39,325
Gross Margin % 0.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00%
Expenses
Payroll ₦4,000 ₦14,000 ₦22,160 ₦22,160 ₦22,160 ₦24,660 ₦26,580 ₦26,580 ₦26,580 ₦26,580 ₦26,580 ₦26,580
Sales and Marketing ₦700 ₦700 ₦700 ₦700 ₦700 ₦700 ₦700 ₦700 ₦700 ₦700 ₦700 ₦700
and Other Expenses
Depreciation ₦142 ₦142 ₦142 ₦142 ₦142 ₦142 ₦142 ₦142 ₦142 ₦142 ₦142 ₦142
Leased Equipment ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Utilities ₦400 ₦400 ₦400 ₦400 ₦400 ₦400 ₦400 ₦400 ₦400 ₦400 ₦400 ₦400
Insurance ₦300 ₦300 ₦300 ₦300 ₦300 ₦300 ₦300 ₦300 ₦300 ₦300 ₦300 ₦300
Rent ₦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% ₦600 ₦2,100 ₦3,324 ₦3,324 ₦3,324 ₦3,699 ₦3,987 ₦3,987 ₦3,987 ₦3,987 ₦3,987 ₦3,987
Other ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Total Operating ₦8,142 ₦19,642 ₦29,026 ₦29,026 ₦29,026 ₦31,901 ₦34,109 ₦34,109 ₦34,109 ₦34,109 ₦34,109 ₦34,109
Expenses
Profit Before Interest (₦8,142) (₦13,036) (₦19,108) (₦17,568) (₦11,554) (₦11,563) (₦10,182) (₦5,251) (₦1,969) ₦1,617 ₦5,216 ₦5,216
and Taxes
EBITDA (₦8,000) (₦12,894) (₦18,966) (₦17,426) (₦11,412) (₦11,421) (₦10,040) (₦5,109) (₦1,827) ₦1,759 ₦5,358 ₦5,358
Interest Expense ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Taxes Incurred ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Net Profit (₦8,142) (₦13,036) (₦19,108) (₦17,568) (₦11,554) (₦11,563) (₦10,182) (₦5,251) (₦1,969) ₦1,617 ₦5,216 ₦5,216
Net Profit/Sales 0.00% -118.40% -115.60% -91.99% -39.68% -34.11% -25.53% -10.92% -3.68% 2.72% 7.96% 7.96%
Received
New Current Borrowing ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
New Other Liabilities ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
(interest-free)
New Long-term Liabilities ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Sales of Other Current ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Assets
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 ₦0 ₦11,010 ₦16,530 ₦19,097 ₦29,120 ₦33,897 ₦39,878 ₦48,097 ₦53,566 ₦59,543 ₦65,542 ₦65,542
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month Month Month
10 11 12
Expenditures from
Operations
Cash Spending ₦4,000 ₦14,000 ₦22,160 ₦22,160 ₦22,160 ₦24,660 ₦26,580 ₦26,580 ₦26,580 ₦26,580 ₦26,580 ₦26,580
Bill Payments ₦133 ₦4,050 ₦5,817 ₦15,029 ₦15,735 ₦22,781 ₦22,867 ₦26,112 ₦30,275 ₦31,307 ₦33,914 ₦36,155
Subtotal Spent on ₦4,133 ₦18,050 ₦27,977 ₦37,189 ₦37,895 ₦47,441 ₦49,447 ₦52,692 ₦56,855 ₦57,887 ₦60,494 ₦62,735
Operations
Net Cash Flow (₦4,133) (₦7,040) (₦11,447) (₦18,092) (₦8,775) (₦13,544) (₦9,569) (₦4,595) (₦3,289) ₦1,656 ₦5,048 ₦2,807
Cash Balance ₦136,367 ₦129,327 ₦117,880 ₦99,787 ₦91,012 ₦77,468 ₦67,899 ₦63,304 ₦60,015 ₦61,671 ₦66,719 ₦69,525
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 ₦140,500 ₦136,367 ₦129,327 ₦117,880 ₦99,787 ₦91,012 ₦77,468 ₦67,899 ₦63,304 ₦60,015 ₦61,671 ₦66,719 ₦69,525
Inventory ₦10,000 ₦10,000 ₦5,596 ₦7,273 ₦8,403 ₦12,813 ₦14,915 ₦17,546 ₦21,163 ₦23,569 ₦26,199 ₦28,838 ₦28,838
Other Current ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Assets
Total Current ₦150,500 ₦146,367 ₦134,923 ₦125,153 ₦108,190 ₦103,825 ₦92,382 ₦85,445 ₦84,466 ₦83,584 ₦87,870 ₦95,557 ₦98,364
Assets
Long-term Assets
The Discount Pharmacy
Long-term Assets ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500 ₦8,500
Accumulated ₦0 ₦142 ₦284 ₦426 ₦568 ₦710 ₦852 ₦994 ₦1,136 ₦1,278 ₦1,420 ₦1,562 ₦1,704
Depreciation
Total Long-term ₦8,500 ₦8,358 ₦8,216 ₦8,074 ₦7,932 ₦7,790 ₦7,648 ₦7,506 ₦7,364 ₦7,222 ₦7,080 ₦6,938 ₦6,796
Assets
Total Assets ₦159,000 ₦154,725 ₦143,139 ₦133,227 ₦116,122 ₦111,615 ₦100,030 ₦92,951 ₦91,830 ₦90,806 ₦94,950 ₦102,495 ₦105,160
Liabilities and Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Capital
Current
Liabilities
Accounts Payable ₦0 ₦3,867 ₦5,317 ₦14,513 ₦14,976 ₦22,023 ₦22,001 ₦25,104 ₦29,234 ₦30,179 ₦32,706 ₦35,035 ₦32,484
Current ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Borrowing
Other Current ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Liabilities
Subtotal Current ₦0 ₦3,867 ₦5,317 ₦14,513 ₦14,976 ₦22,023 ₦22,001 ₦25,104 ₦29,234 ₦30,179 ₦32,706 ₦35,035 ₦32,484
Liabilities
Long-term ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0 ₦0
Liabilities
Total Liabilities ₦0 ₦3,867 ₦5,317 ₦14,513 ₦14,976 ₦22,023 ₦22,001 ₦25,104 ₦29,234 ₦30,179 ₦32,706 ₦35,035 ₦32,484
Paid-in Capital ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100 ₦183,100
Retained (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100) (₦24,100)
Earnings
Earnings ₦0 (₦8,142) (₦21,178) (₦40,286) (₦57,854) (₦69,408) (₦80,971) (₦91,153) (₦96,404) (₦98,373) (₦96,756) (₦91,540) (₦86,324)
Total Capital ₦159,000 ₦150,858 ₦137,822 ₦118,714 ₦101,146 ₦89,592 ₦78,029 ₦67,847 ₦62,596 ₦60,627 ₦62,244 ₦67,460 ₦72,676
Total Liabilities ₦159,000 ₦154,725 ₦143,139 ₦133,227 ₦116,122 ₦111,615 ₦100,030 ₦92,951 ₦91,830 ₦90,806 ₦94,950 ₦102,495 ₦105,160
and Capital
Net Worth ₦159,000 ₦150,858 ₦137,822 ₦118,714 ₦101,146 ₦89,592 ₦78,029 ₦67,847 ₦62,596 ₦60,627 ₦62,244 ₦67,460 ₦72,676