Calculation of break-even business

Description
This is simple way of finding break-even business

Computation of business for break-even for the fnancial year …….
Description
Average monthly HO expenses
Average monthly branch expenses
Total monthly expenses (A)
Yearly expenses (B) = (A) X 12 months
Income to be generated @ 18% ( C ) = (B)
Business to be achieved during …………... to earn the above income ( D ) = ( CX100/18)
Average yearly-loan receivables per branch ( D / No: of branches)
Please note:
Avearage monthly HO & expenses are considered based on the reported fgures of previous months.
Weighted avaerage interest rate of 18 % of all loan products have been considered for interest ( business income) calculation
Computation of business for break-even for the fnancial year …….
Rs.
1,323,427
792,000
2,115,427
25,385,124
25,385,124
141,028,466.67
7,834,915
Please note:
Avearage monthly HO & expenses are considered based on the reported fgures of previous months.

doc_951443393.xlsx
 

Attachments

Back
Top