Option Explicit


Sub ConvertRates_Module1()

    

    Dim ws As Worksheet

    Dim rInput As Double

    Dim rateType As String

    Dim m As Long

    

    Dim i_eff As Double      ' effective annual rate

    Dim j_nom As Double      ' nominal annual rate (convertible m-thly)

    Dim delta As Double      ' force of interest

    

    Set ws = ThisWorkbook.Sheets("Rates")

    

    ' ---- Read inputs ----

    rInput = ws.Range("B2").Value          ' rate value entered by user

    rateType = UCase(ws.Range("B3").Value) ' EFF / NOM / DELTA

    m = ws.Range("B4").Value               ' compounding frequency

    

    ' ---- Determine all three forms ----

    Select Case rateType

    

        Case "EFF"

            ' rInput is effective annual rate

            i_eff = rInput

            j_nom = m * ((1 + i_eff) ^ (1 / m) - 1)

            delta = Log(1 + i_eff)

        

        Case "NOM"

            ' rInput is nominal annual rate j, convertible m-thly

            j_nom = rInput

            i_eff = (1 + j_nom / m) ^ m - 1

            delta = Log(1 + i_eff)

        

        Case "DELTA"

            ' rInput is force of interest δ

            delta = rInput

            i_eff = Exp(delta) - 1

            j_nom = m * ((1 + i_eff) ^ (1 / m) - 1)

        

        Case Else

            MsgBox "Invalid rate type in B3. Use EFF, NOM or DELTA.", vbExclamation

            Exit Sub

    End Select

    

    ' ---- Write outputs ----

    ws.Range("B6").Value = i_eff

    ws.Range("B7").Value = j_nom

    ws.Range("B8").Value = delta

    

End Sub


Comments

Post a Comment

Popular posts from this blog

LEARNING DISABILITY THROUGH ASTROLOGY

Image
The Cosmic Connection: My Journey with Depression, ADD, and a Pisces Moon A word of caution: I'm still taking baby steps in my astrology journey and don't intend to pursue it as a career or side hustle. I'm learning simply to satisfy my own curiosity. During my sophomore year of college, I was diagnosed with clinical depression and Attention Deficit Disorder (ADD) . My school days were traumatic, filled with verbal abuse and bullying at school and at home. I was told these conditions were incurable. And while they might be, I've learned that they're not insurmountable. My birth chart offers some fascinating insights into my experience. I'm a Pisces moon with an Aries Ascendant , which places my moon in the 12th house . This house, along with the 6th and 8th, is considered a Dusthana , or a dreaded house in astrology. Planets in these houses are said to struggle to deliver their optimal results. The 12th house specifically represents far-off lands, dreams, and ...
Read more

What Failed Surjit? A Story of Caste Pride and Cowardice

 What shook Tamil Nadu, the southernmost state of India, was the honor killing of Kavin Selvaganesh, a 27-year-old by the brother of his girlfriend. Kavin, a brilliant mind, had earned a gold medal for his academic performance at the university and was employed at TCS, with a monthly salary of more than a lakh. He had known and been in love with Subhashini, a medical doctor and the daughter of two police officers, since they attended the same school in Tuticorin. Subhashini belonged to a community categorized as "Most Backward," while Kavin was a member of the Scheduled Caste. Because of their differing backgrounds, Subhashini's parents did not approve of the relationship, fearing social ostracization if their daughter married Kavin. What happened next is truly chilling. Kavin traveled to Tirunelveli to take his ailing grandfather to the clinic where Subhashini worked. Her 21-year-old brother, Surjit, learned of the situation and met with Kavin. After exchanging friendly...
Read more

The Unseen Value of Struggle

Image
A few might be unaware, but the name Turbo C++ isn't unfamiliar to many. How can I forget the bright blue screen in front of me as I took my first steps into something called 'programming' at 17?                                Courtesy : GeeksforGeeks The "Hello, World!" program is perhaps the first kind of code that makes you feel like you've stepped into the shoes of Ada Lovelace. Later, I got into a mesh of data structures that I couldn't comprehend at the time. As a beginner, I was expected to write lengthy pieces of code for the course, which made me despise the whole process. How I got back into it would compel me to tell a chunk of my life story, which is a less interesting one. Since I learned programming the hard way some 10 to 12 years ago, a relatively new tech—regenerative AI—fills my eyes with tears and me with a sense of gratitude that leaves me speechless. Regenerative AI could be one of human...
Read more