Need tutoring!!! Writing a cumulative sum function (without calling vba function)

Hi guys,
I'm new to vba and recently I met a challenge in my work and I really appreciate if someone can give me some suggestions.

So I'm trying to write a function to calculate a Bond's Price.
Given values: coupon, maturity, yield.

It will be something like this BondPrice=(coupon,maturity,yield)
And this is the mathematics formula :

Price (yield)= ∑_(i=1)^(maturity)▒〖CF〗_i/〖( 1+yield)〗^i

note: 〖CF〗_i= (coupon)*100

The price is a sum from period i = 1 to maturity, given coupon, maturity and yield.
Specifically,
BondPrice=P.1+P.2+P.3+...+P.maturity

That sigma in the formula get me busted so hard because of the 'rule' we've given.

Rule:
Required to write the function without calling vba functions such as P=Sum(Range()). Yeah pure vba language!!!

-------------------------------------------------------------------------------------
Below is my 3-hours attempt and it wouldn't work as well as violated the rule.

Public Function BondPrice(alpha, beta, gama)

'alpha=coupon
'beta=maturity
'gama=yield

Dim matrix(10 To 10, 1 To 100) As Double

alpha = Cells(3, 3).Value
beta = Cells(4, 3).Value
gama = Cells(5, 3).Value

'their values are gathered from a subroutine that I wrote before, I put them here for testing purpose.


For i = 1 To beta

matrix(10, i) = ((alpha ) * 100) / (1 + (gama ) ^ i)

Next i

BondPrice = Application.Sum(Range(matrix(10, 1), matrix(10, beta )))


End Function

---------------------------------
The work is due next Thursday. That could mean I have a lot of time to enjoy my frustration here.
But I trust the community to be my salvation. Please help! And please don't forget the rule!

Hi, welcome to the forum

This sounds like a homework assignment?

OK, just checking

I see that you have already made some attempt at this, so that takes care of our "homework rule" ...

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

1. Why did you dimension your matrix with only 1 row with and index of ten, but 100 columns? Maybe just Dim Matrix(1 to 100) as Double?
Why a matrix?
Maybe:
temp=(alpha * 100) / (1 + (gama ) ^ i)
bondprice=bondprice + temp

Is that: (1 + (gama ) ^ i) or (1 + gama ) ^ i