Objective
- Team member responsible for providing financial modelling for a Feasibility Study and Business Plan to Annhu Ntem Farms, with the focus on the Pineapple Value Chain. The feasibility study and business was done suing the following guideline: staffing requirements, review of past audited financials, Investment schedules, revenue stream analysis using input & output, project cost break-down and financing, Break-even analysis, working capital schedules, Depreciation, Amortization, and Insurance schedules, discounted cash-flow analysis using NPV and IRR, Projected cash flow analysis to establish EBITDA, Risk assessment using sensitivity analysis based on revenue, costs and expenses scenarios, Projected Income Statement, Projected balance sheet, Funds Flow Statement, Debt Service Coverage, staffing requirements, Market and Industry Considerations, Technical considerations, Environmental and social impact assessment
- Assess the operational capacity of the company to off-take a $800,000 loan facility from Barclays Bank for primary production.
- Determine the project financial viability using the NPV and IRR with discounted cash flow analysis.
- Determined the financial analysis backed with sensitivity analysis to establish the project robustness over a 5-year period.
- Determined the right loan structure to ascertain the repayment period required to enable the client pay back the facility considering repeated loans for primary production activities over the period.
- Determined the project Cash flows to facilitate the repayment of the facility.
- Determined out-grower scheme profitability as well as the nucleus farmer to pay back the loan using the Crop Calendar with focus on “with” and “Without” the right agronomical protocol’s analysis.
Result
The client secured $800K to support its commercial activities to meet demands from Blue Skies, a major fruit processing factory in Ghana focusing on both local and export markets
Project Details
- Category: Agricultural Value Chain
- Client: Annhu Ntem Farms, a commercial Pineapple farmer based in Ghana
- Location: Ghana
- Completed Date: March 2010 to May, 2010