Dear All
I prepared the VARIABLE PROFIT AND LOSS STATEMENT as shown in the attachment below, where the EXPENSES ACTUAL values should be obtained and other values should be adjusted according to the BUDGET RATIO. It has been prepared by me as below attachment. The problem I have is that when taking the value of NET PROFIT, it is not the value divided according to the BUDGET RATIO, but the GROSS PROFIT (this should be the gross frofit divided according to the budget ratio) should be subtracted from ACTUAL EXPENSES and added to it INVESTMENT INCOME. This should be done in the Discount_Budget field of my attachment. Can you please help me to calculate the NET PROFIT.
Thanking You
SANKA
