• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Net Recurring Balances for 3 FY

Yogendra Bharti

Yogendra Bharti

New Member
Hi, I have three different values ie RD ticket size, RD term and total RD customers for 3 financial years. Now I need to calculate how much Balance I would mobilize in these 3 FYs (spreaded out monthly) if considered that In given RD term withdrawals will also happen and in next year respective RD ticket size and term would be used.
 

Attachments

  • Recurrinf Deposts Balance.xlsx
    11.6 KB · Views: 8
Hi ,

I doubt if too many members would have understood your requirement. I haven't.

I suggest you describe your problem in greater detail , clearly specifying :

1. What is your input data like , and which cells in the worksheet will have the input data

2. What is the output you are looking for , and which cells in the worksheet should have the formula to generate this output

3. What is the logic by which the output will be derived using the input ; if possible , upload a workbook which has enough data in it , and manually work out at least a few examples of how the output can be derived from the input.

Problems which are described in detail , which have a sample workbook attached , and where examples have been given of what the Excel formulae should replicate , get answers much faster.

Narayan
 
You must log in or register to reply here.
Back
Top