A project report is one of the key documents that an entrepreneur is asked to present when approaching a bank for funding. It is an opportunity for the lender to assess the proposed venture, including investment, capacity utilization, cost structure, sales volumes, profitability, cash flows, and repayment capability.
Of these, gross margin calculation helps in understanding how much value (after direct production or purchase) is likely to be retained from sales. However, many reports contain errors or unrealistic assumptions that raise questions in the minds of lenders.
The report might look good on paper, but there is always a risk that a lender will dismiss your application due to doubts about the accuracy of the financial projections.
Read on to avoid making some of the most common mistakes when calculating gross margin in your project report.
What Is Gross Margin in a Project Report?
Gross margin is the excess of revenue from sales over the direct costs associated with producing or acquiring goods.
Specifically, for a manufacturing entity, direct Expenditure may include raw materials, direct labor, production consumables, power, and other production-specific expenses. For a trading entity, the purchase cost of goods is included. The resulting gross profit from sales is usually expressed as a percentage of sales volume. It shows how much revenue is available for meeting other expenses, interest, taxes, and profits.
A bank would typically not expect a business to have exceptionally high margins. However, the calculation should reflect realistic assumptions.
1. Unrealistic Assumptions About Selling Price
One of the most common mistakes is to assume that proposed sales prices for units produced by a venture are significantly higher than similar products sold by competitors.
An entrepreneur may estimate a theoretically plausible selling price for his product. However, if other companies sell comparable goods at lower prices, the bank will question the assumptions about the selling price and Gains margin.
To arrive at realistic selling prices, one should conduct market research. A fair approximation is to use quotations from distributors or dealers, prevailing market prices, negotiations with buyers, and other methods:
• Comparative analysis
• Distributor/dealer quotations
• Market rates
• Negotiations with buyers
• Product quality and differentiation
• Local demand
• Price trends
It’s crucial to keep in mind that selling prices should be comparable to the product’s positioning and market.
2. Underestimated Raw Material Purchase Costs
Raw materials are usually the largest single item in the direct cost of a manufacturing entity. Accordingly, even a small error in the projected price will result in substantially lower Gains.
Some entrepreneurs may rely on a supplier’s quotation from several years ago or assume that the prices have remained stable. A bank will be concerned about the accuracy of the projected purchase costs of raw materials. It is important to remember that the cost of procuring materials is only part of the cost, and such expenses as transportation, import duties, losses due to waste or defective goods must also be taken into account.
A competent analysis should take into account at least the following factors:
• Current supplier quotations
• Transportation Expenditure
• Import duties
• Waste and losses
• Material characteristics
• Price variations
• Minimum order sizes
If any of these factors are not considered, the final profit may be significantly lower than projected.
3. Overlooked Production Wastage
During production, some of the materials may be lost due to various causes. The amount of waste depends on the industry, equipment, and production technology. For example, if an entrepreneur assumes that the amount of raw materials purchased is equal to the amount of finished product, the bank will want to see the report about the technology and product characteristics. In other cases, the entrepreneur should carefully consider the possibility of loss of materials due to trimming, evaporation, or rejection of defective products.
4. Confusing Gross Margin With Net Profit
A common mistake is to confuse gross profit with net income. Even if an entrepreneur calculates realistic gross margins, he may significantly underestimate net profit because he does not consider overhead expenses. Such expenses include salaries, rent, advertising costs, transportation, maintenance, and many other items.
It is important to understand the difference between revenue, direct Expenditure, gross profit, overhead expenses, and net profit. The following profit structure should be reflected in the report:
Revenue
– Direct Expenditure
= Gross profit
– Overhead costs
= Net profit (or profit before taxes)
Therefore, the entrepreneur should explain how exactly the expected profit was obtained.
5. Using the Same Assumptions for Different Products
When different products are sold, some entrepreneurs make the mistake of using the same selling prices and costs for all of them. In reality, costs and prices can vary significantly for different products. An accurate project report should calculate the expected gross margins for each product.
For example:
Product Selling price Direct costs Approx. margin
Product A ₹100 ₹65 35%
Product B ₹150 ₹105 30%
Product C ₹200 ₹130 35%
After determining the margins for each product, the entrepreneur should calculate the weighted average margin for the product mix.
6. Ignoring Capacity Utilisation in Financial Projections
When a manufacturing unit is launched for the first time, it typically operates at less than full capacity. This is explained by the need to build markets, find buyers, train workers, familiarize customers with the product, and so on. Accordingly, it is wrong to assume that production volumes will be the same in year one as they are expected to be in year five.
The entrepreneur should realistically estimate the time it will take to achieve full capacity utilisation and indicate this in the report. This will help the loan officer understand the projected cash flows and profit margins.
7. Forgetting Logistics and Other Direct Costs
When determining the direct costs of a product, some entrepreneurs forget about expenses related to its delivery to the buyer. These may include packaging, transportation, loading and unloading, commissions to intermediaries, and other expenses. If these costs are directly related to sales, they should be explicitly indicated in the report.
It is important to distinguish between direct and indirect costs. The former are associated directly with the production or sale of goods and should be shown separately in the report.
8. Using Unrealistic Industry Comparisons
Industry comparisons can be a useful tool for estimating margins. At the same time, many entrepreneurs make the mistake of using industry averages without considering specific differences between their proposed project and existing businesses.
For example, if a bank asks how the entrepreneur knows that the proposed project has a profit margin of 30%, he should be prepared to answer based on specific calculations and not industry averages. The following questions should be considered:
• What is the source of information about industry margins?
• What type of product is being compared?
• Is the technology comparable?
• Is the proposed production scale similar to that of comparable companies?
• Are the assumptions about raw material costs realistic?
• Does the proposed selling price match the market?
Industry comparisons are useful, but they should be used in combination with other methods.
9. Lack of Scenario Analysis
A detailed description of the best-case scenario is not enough for a bank. It is important to consider alternative scenarios in which, for example, raw material prices rise, selling prices fall, or production volumes decrease.
Such an approach will help to determine how sensitive the profitability of the project is to changes in key variables. This is particularly important when it comes to assumptions about revenue, volume, and expenses.
10. Ignoring the Link Between Profit and Working Capital
A bank will be interested in the entrepreneur’s ability to repay a loan, which means profit and cash flow. In many cases, however, profitability is artificially inflated while the need for working capital is underestimated.
For example, if a company sells its products on credit, but pays for raw materials in advance, its profit margin may be lower than projected. The entrepreneur should be aware that the bank will look at working capital requirements, including inventory, receivables, payables, and cash balances.
How to Avoid Common Mistakes in Project Reports
Before preparing a report, entrepreneurs must review all calculations to identify any inconsistencies. At a minimum, they should check:
- Do the sales prices seem realistic?
- Are the raw materials costs based on reliable information?
- Are the production yields realistic?
- Have all wastes and losses been taken into account?
- Have product-specific margins been calculated?
- Is the utilisation of capacity realistic?
- Are direct and overhead costs correctly separated?
- Are working capital requirements consistent with sales volumes and profit margins?
- Have alternative scenarios been considered?
- Are all components of the report consistent with each other?
It is also important that the production capacity, machinery, manpower, raw materials, sales volumes, and profit margins are all consistent with each other.
Why Accuracy in Financial Calculations Matters
A bank uses information from a project report to evaluate an application, which means that calculation errors can be fatal. If the bank notices that the report contains contradictory information, it will certainly request clarification before approving the loan.
For example, if the report shows extraordinarily high margins, but the raw material costs are significantly lower than expected, the bank will scrutinise the sales volumes as well. On the other hand, if the projected production volumes greatly exceed the capacity of the proposed equipment, the bank will question the accuracy of the report as a whole. Accordingly, it is important to ensure consistency of all calculations.
Final Thoughts on Gross Margin Calculations
Gross margin calculations are an important part of any project report, but they should not be exaggerated. When preparing a report, an entrepreneur should strive to create a realistic and sustainable financial model.
It is important to back up key assumptions with supporting information, such as market research, quotations from suppliers, production costs, and industry comparisons. At the same time, it is necessary to take into account overhead costs, working capital financing, and cash flows. A competent financial model will allow the entrepreneur to convince the bank of the feasibility of the project.
Frequently Asked Questions About Project Report Margins
1. What Do Banks Look for in a Project Report?
Banks review project reports to evaluate the repayment capacity of a loan applicant, including the relationship between sales and direct costs.
2. What Makes Margins Seem Unrealistic?
Unrealistic assumptions about the selling price, purchase cost of materials, production losses, and capacity utilisation can make margins seem too high.
3. Can a New Manufacturing Unit Operate at Full Capacity?
When launching a new manufacturing unit, an entrepreneur should realistically assess the time it will take to reach full capacity utilisation. In most cases, it is wiser to use a step-wise capacity utilisation schedule.
4. Can a Bank Use Industry Averages to Evaluate a Project Report?
Industry comparisons can be a helpful tool, but entrepreneurs should be prepared to defend their assumptions.
5. How Do Raw Material Costs Affect Profit?
Raw materials are often the largest component of direct costs, which means that even small errors in their estimation can have a significant impact on profit.
