Yield on return

[Vishesh Shah]

How to calculate yield on return in excel with formulae if I have no of days (Holding period, amount invested and amount on settlement date, amt of gain or loss.
For Eg- Amt invested Rs. 4124
Amt on settlement date- Rs. 4803
No of days - 602
Hw to calculate yield/ return on investment by excel formuale ?

 

[Hui]

Vishesh

Firstly, Welcome to the Chandoo.org Forums

In you example
The Gain is Amt on settlement date less Amt invested
= 4803 - 4124
= 699

The period is 609 Days

the Gain oper Day is 699/609
= 1.14 Rs per day
or
= 100*1.14/699Rs per day
= 0.1642 %/day

If you use these in Excel
B1: Amt invested
B2: Amt on settlement date
B3: No days

Then the Gain per Day =(B2-B1)/B3

As a percentage =100*((B2-B1)/B3)/B2