ICICI

Calculating Returns of Bid


Sri Priya   20 October 2019

Sri Priya

 1 likes  6 points

| My Other Post

A chit fund has 25 members. Each month they contribute Rs 2000 each. End of the month, the person who bids the lowest for the corpus, gets his bid. The group organizer gets paid a fixed commission of Rs 2500 each month (5% of 25*2000).It is deducted from the bid winner's corpus. The remaining amount is distributed among all the 25 customers equally.

Based on the above details calculate the following

 

1. What is the Annualized  Return of the person who bids in the last month ? 

2. What is the Annualized Return of the person who bids in the first month ?
3. Write an R scriptt which calculates the annualized return of chit fund participant ?- Show the Return % for each month's bid winner.

 

Herewith attached the excel file for calculation. Please provide a step by step process of calculating.


Attached File : 2950644 20191020065352 chit fund exercise.xlsx downloaded: 33 times

JITEN BHAVSAR (Accountant)     12 November 2019

JITEN BHAVSAR
Accountant 
 22 points

View Profile | My Other Post

Study material for income tax and return filling


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  



Popular Discussion


view more »





Download the latest Question Papers for free

click here