R help - Oct 2019 - Calculating returns of bid using R

Dear R Users,

I am practicing problems in the field of finance and economics. While
searching, I got problem like this. And I want to solve the following
problem using R. I dont have any clue how to incorporate this in R. Please
help me!!

Question:

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 using R

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 script 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.

Thanks
Sripriya

Hello,

See inline.

On Sat, Oct 19, 2019 at 01:48:44PM +0530, Sri Priya
wrote:
> Dear R Users,
> Question:
> 
> 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 using R
> 
> 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 script which calculates the annualized return of chit fund
> participant ?- Show the Return % for each month's bid winner.
This list has a no homework policy.

Please provide at least some preliminary works.
> Herewith attached the excel file for calculation.
File got stripped by the list.

See more on the posting guide which is included in the footer of every
mail.

-- 
Beno?t

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 866 bytes
Desc: not available
URL:
<https://stat.ethz.ch/pipermail/r-help/attachments/20191019/32d19c41/attachment.sig>