How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Rakhi Vasavada Your Own Question

Rakhi Vasavada
Rakhi Vasavada, Financial Advisor
Category: Finance
Satisfied Customers: 4496
Experience:  Attorney and Financial Expert. Have specialization in Financial Laws.Practice experience of over 13 years
43581946
Type Your Finance Question Here...
Rakhi Vasavada is online now

Hi, I had a question regarding purchasing S&P500 stock index

Resolved Question:

Hi,
I had a question regarding purchasing S&P500 stock index lots, using leverage and a monthly deposit, with returns compounding on the initial deposit & monthly deposit on the S&P500 monthly return. The returns are listed monthly with this experiment.
I have a excel spreadsheet I built that takes an initial deposit to purchase S&P500 index lots say £10,000, but we leverage 6 times to purchase £60,000 worth of S&P500 index lots (using CFD derivatives). Then each month we add a monthly deposit say £400 to purchase an additional S&P500 lot. Each month we also reinvest our profits from the initial purchase as well as the monthly deposit.
I need an expert to tell if my calculation is correct.
Here is my calculation. With an example.
Lets say
We have £10,000 and we use this to purchase £65,000 worth of S&P 500 lot CFDs. We are leveraging 6.5 times our initial capital.
Month 1
We have balance of £10,000
Month 1 S&P500 return is 0.51% which is 0.51 x 6.5 = 3.32% return for us (we used leverage)
Total return profit is £331.50
Total balance is now £10,331.50
2nd month
We have a balance of £10,331.50
We add £400 at beginning of month
Balance is now £10,731.50 (we reinvest all our profits by purchasing more S&P500 lots)
Month 2 S&P500 return is 2.41% which is 2.41 x 6.5 = 15.67% return for us
Total profit is £1,681
New balance is £12,412.59
3rd month
We have a balance of £12,412.59
We add £400 at beginning of month
Balance is now £12,812 (we reinvest all our profits by purchasing more S&P500 lots)
Month 3 S&P500 return is -0.56% which is 0.56 x 6.5 = -3.64% return for us
Total loss is £-466.37
New balance is £12,346
Is this correct technique I am using? and could you explain if anything is wrong?
Thanks
Submitted: 2 years ago.
Category: Finance
Expert:  Rakhi Vasavada replied 2 years ago.
Dear Friend,

Hello and welcome. Thank you for providing an opportunity to assist you.

Yes, you are absolutely correct. There are no mistakes in it.

It is understood that you are using leverage so that an 0.50% gain or losses would translate into 3-4% of your capital because of this leverage. You keep ploughing your profit and in that case, the effect of the leverage would be perfectly correct as you have explained in your hypothetical example.

I am sure this would help.

You may please leave a positive rating if this helps as this is the only way we are compensated for assisting you. Alternatively, you may revert back with a reply if you need further assistance or if I have missed out on any aspect of your question,

Warm Regards
Customer: replied 2 years ago.

Hi Rakhi

Thanks for your answer.

Before I finish this answer, when I have finished building my spreadsheet model of this, could you check the spreadsheet for me? and how much will the charge be for this, if possible?

If this is possible, I know that justanswer do not allow attachments, so I do not know how to get this spreadsheet to you. If you could provide some way, that would be great.

Thanks

Nithin

Expert:  Rakhi Vasavada replied 2 years ago.
Dear Friend,

Hello and welcome again. Thank you for your follow up.

JustAnswer does allow attachments. Or else, you can get in touch with the customer care, mail them the attachment and they will send it to me.

You can try and use the "PIN" icon on your toolbar if available to attach. You can also use free file hosting service like https://www.mediafire.com/ to share file with me.

I am sure this would help.

You may please leave a positive rating if this helps as this is the only way we are compensated for assisting you. Alternatively, you may revert back with a reply if you need further assistance or if I have missed out on any aspect of your question,

Warm Regards
Rakhi Vasavada, Financial Advisor
Category: Finance
Satisfied Customers: 4496
Experience: Attorney and Financial Expert. Have specialization in Financial Laws.Practice experience of over 13 years
Rakhi Vasavada and other Finance Specialists are ready to help you
Customer: replied 2 years ago.

Hi Rakhi,

Thanks for email.

I will setup a new question in a week or 2 weeks with a spreadsheet of my model. So you can check this. So watch this space!

For now I will finish this question. Thanks for your help.

Thanks

Nithin

What Customers are Saying:

 
 
 
  • I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W
< Previous | Next >
  • I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W
  • I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight. Bonnie
  • Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation. John
  • Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with. Orville
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
 
 
 

Meet The Experts:

 
 
 
  • Rakhi Vasavada

    Rakhi Vasavada

    Financial Advisor

    Satisfied Customers:

    1795
    Attorney and Financial Expert. Have specialization in Financial Laws.Practice experience of over 13 years
< Previous | Next >
  • http://ww2.justanswer.com/uploads/RA/rakhi.v/2012-7-3_14374_RakhiVasavadaL.64x64.jpeg Rakhi Vasavada's Avatar

    Rakhi Vasavada

    Financial Advisor

    Satisfied Customers:

    1795
    Attorney and Financial Expert. Have specialization in Financial Laws.Practice experience of over 13 years
  • http://ww2.justanswer.com/uploads/MS/MsAM/2012-6-9_16426_anna.64x64.jpeg Anna's Avatar

    Anna

    Teacher, writer, biologist

    Satisfied Customers:

    270
    Great research skills, variety of work experiences, teaching experience.
  • http://ww2.justanswer.com/uploads/PD/pdheslin/2012-6-6_232056_pambig.64x64.jpg pdheslin's Avatar

    pdheslin

    Consultant

    Satisfied Customers:

    51
    20+ years of internet site creation and search engine optimization. Dozens of search tools at my disposal.
  • http://ww2.justanswer.com/uploads/BL/blueflowers1063/2013-10-10_35834_KimHolidays1.64x64.jpg Kim D.'s Avatar

    Kim D.

    Consultant

    Satisfied Customers:

    27
    Researcher 20+yrs in small and large institutions
  • http://ww2.justanswer.com/uploads/NU/nursescare4u/2013-3-31_03429_JApic.64x64.jpg findinganswers's Avatar

    findinganswers

    Internet Researcher

    Satisfied Customers:

    22
    Internet Researcher, Nurse for over 17 years, and can find answers for you!
  • http://ww2.justanswer.com/uploads/PR/ProMBA/2012-6-7_154051_beach.64x64.jpg ProMBA's Avatar

    ProMBA

    Internet Researcher

    Satisfied Customers:

    3
    I'm an owner of three businesses, with both undergraduate and graduate business degrees from top tier universities.
 
 
 

Related Finance Questions