Results 1 to 3 of 3

Thread: Help with Excel Macro to computer investment return

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Mar 2021
    Posts
    1
    Location

    Help with Excel Macro to computer investment return

    Beginning
    Claim Payments
    Expenses
    Return Premium
    Profit Share
    Taxes
    End of Period
    Avg Annual Balance
    Interest
    Investment Return

    I have the above and want to compute the investment return which is intereest x avg annual balance.

    Wrote the following UDF:

    Sub udf_investreturn()


    End Sub
    Function investreturn(rate, beginning)
    
    
    For i = 1 To 10
        average_bal = beginning + ending / 2
        investreturn = average_bal * rate
        Next i
    End Function

    But my investment return is slighly off. Why?
    Last edited by SamT; 03-14-2021 at 05:24 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •