CODEWITHSUNDEEP
excelgoogle-apps-scriptgoogle-sheetsmathexcel-formula
Sophia Wilson
Sophia Wilson

Reputation: 477

How to calculate additional purchase

Let's consider a scenario where I own 100 shares, each initially purchased at an average price of $10 per share. However, the current market value of these shares has decreased, with the present market price for each share being $5. My objective is to determine the number of additional shares I should acquire at the current market price of $5 per share. The goal is that it will enable me to effectively reduce the average cost of all my acquired shares to $6 per share, through the use of an Excel formula.

I need to identify the closest number of share to be purchased as a output.

Googlesheet - https://docs.google.com/spreadsheets/d/1AcLg4YGfGxRxocjgSUhRfGtGY7Qxt5diK9BEpqRX28E/edit?usp=sharing

Upvotes: 0

Views: 76

Answers (1)

user11222393
user11222393

Reputation: 5501

It is more math than Excel or Sheets question, but here you go:

=(B3*B2-B3*B4)/(B1-B2)

Result:

enter image description here

Upvotes: 2

Related Questions