Agriculture Product Export Project Feasibility Analysis
Originally published: 29/11/2021 09:08
Publication number: ELQ-28014-1
View all versions & Certificate
certified

Agriculture Product Export Project Feasibility Analysis

Financial analysis of date export project on the basis of IRR, Cash on Cash Multiplier, Net Casg Inflows and Sensitivity Analysis

Description
This excel sheet is for financial analysis of a project for the purchase of dates and selling high-grade dates into export and low grade dates into the local market. This excel sheet does a financial appraisal of the project on the basis of IRR, Net Cash Flows, and Equity Multiplier, This excel sheet contains the following tabs:
1. Inputs: Assumptions like volume, local price, export price, currencies, farm expenses, packaging expenses, shipping & storage expenses, general & admin expenses, financing assumption, and cash collection cycle.
2. Cash Flows & IRR: Various cash inflows and cash outflows related to the project and calculation of IRR and free cash flows.
3. Graph: It shows various important metrics like revenue, expenses, net profit, revenue break-up, expenses break-up, financing break-up, and margins per lbs.
4. Sensitivity Analysis: Levered and unlevered IRR at different export and local price levels.
5. Margin: Margin per lbs for export sale, local sale, and total sale.
6. Revenue & Expenses(Export Cur.) and Revenue & Expenses (Local Cur.): Month-wise units of the dates purchased, packed, stored, shipped for local sales, and shipped for export sale. It also includes revenues and expenses projections.
7. Loan amortization: Repayment of loan and interest on the loan financed in local currency

This Best Practice includes
1 Excel Sheet

Acquire business license for $89.00

Add to cart

Add to bookmarks

Discuss

Further information

To provide a template for a financial analysis of a project of trading in products

It will help in identifying various inputs that drive the profitability and coming out with key financial statements required by investors.

It will help in identifying various inputs that drive the profitability and coming out with key financial statements required by investors.


0.0 / 5 (0 votes)

please wait...