Write a Program to Calculate Time Value of Money and get Paid

@manish-r2Hoep • Oct 22, 2024

Oct 22, 2024

1.5K

Hello Friends

i am in great need of computer program for following scenario

I want to make 50 payment of 200$ with interest rate of 16.50$ and increase rate of 5% Semi annually

If not Program then at least I need a formula so I can develop program myself

Calculate the Final Amount

Like 0 Replies 10

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Manish Goyal

@manish-r2Hoep • Feb 26, 2014

no one??

Come on Guys Please help me I have already developed the logic the only thing that I am not able to crack is this increase rate,

Please I am ready to pay even, your efforts and time will be compensated

Thanks in advance
0
ManojKiran Eda

@manojkiran-Cse2se • Feb 26, 2014

can u please explain me the question more elaborately so that i can help u...as i am good as these type of problems..
0
Manish Goyal

@manish-r2Hoep • Feb 26, 2014

you can google this, the only difference is increase rate on payment, i just need change for that in the actual formula for time value of money
0
Kaustubh Katdare

@thebigk • Feb 26, 2014

Looks like we'll have to tag a few people: @#-Link-Snipped-# , @#-Link-Snipped-#

0
Manish Goyal

@manish-r2Hoep • Feb 26, 2014

I think here only a guy with great knowledge of finance related formula can help me, I can develop program myself, only I need formula for this type of calcultion

Anyone here in CE???
0
ManojKiran Eda

@manojkiran-Cse2se • Feb 27, 2014

Hai #-Link-Snipped-#,
I have ur code ready ..I am a beginner so I wrote the code in C (gcc in Linux)language....

Code#
####################################################################

#include<stdio.h>
#include<math.h>
void main(void)
{float pay_per,pay,rate,inc_rate,incr_per_months,amount,t;
int u,i;
printf("Enter the total amount to be paid :");//given pay=200$
scanf("%f",&pay);
printf("Enter the amount that u want to pay per time :");//given u will pay 50$
scanf("%f",&pay_per);
printf("Interest amount per time:");//interest rate=16.5$
scanf("%f",&rate);
printf("Time after which the rate is increased (months):");// half year(6 months) rate is increased
scanf("%f",&incr_per_months);//incr_per_months=6
printf("Increse in rate in(%):");//Increased in rate=5%
scanf("%f",&inc_rate);//inc_rate=5
rate=(rate*100)/pay;//conversion of interest rate=16.5$ interms of percentage
t=0.0;
incr_per_months=incr_per_months/12;//converting months into years
u=pay/pay_per;
for(i=0;i<=(u-1);i++)
{t=t+((pay-(i*pay_per))*pow((1+(inc_rate/100)),i));
}
amount=pay+(incr_per_months*(rate/100)*t);
printf("Total Amount is :%f\n",amount);
}

##########################################################################

I have attached the output screen...

If u have any further clarification ask me...

0
simplycoder

@simplycoder-NsBEdD • Feb 27, 2014

@BigK, Thanks for tagging me.

Hi Manish,
For semi annual rate of increase, you can divide the rate by 2 and multiply the period by 2.
Hence amount=pow(P*[1+r/2], (2*n))

Share your thoughts here. It would be more helpful if you can share a complete use-case with us with input and the expected output values.

Thanks.
0

Uday Bidkar

@uday-bidkar-X1y63x • Feb 27, 2014

public class TimeValueOfMoney {
    public static void main(String[] args){
        double futureValue = 0;
        float monthlyPayment = 200, monthlyInterestRate = 16.5f/12, incrementInMonthlyInterest = 5.0f/12;
        int totalPayments = 50;
        int incrementIntervalInMonths = 6;
        for(int i=1; i<=totalPayments;i++){
            futureValue += monthlyPayment;
            futureValue = futureValue + (futureValue*(monthlyInterestRate/100));
            if((i % incrementIntervalInMonths) == 0){
                monthlyInterestRate += incrementInMonthlyInterest;
            }
        }
        System.out.println("Final amount = " + futureValue);
    }
}

Uday Bidkar

@uday-bidkar-X1y63x • Feb 27, 2014

@#-Link-Snipped-# , I think amount=pow(P*[1+r/2], (2*n)) won't work as it doesn't take into account the increase in interest rate after every six months. It will work only when the interest rate is constant and interest is calculated and accumulated every six months.

0
Manish Goyal

@manish-r2Hoep • Feb 27, 2014

OK Here is one test case

Assuming I gave someone loan (of amount ?)on date : 2/21/2014

and he started returning me payment back on 12/12/2014 in installments of 25

At nominal rate 16.50 and increase rate of 5% Semi annually.

Now I want to calculate loan amount?

For the above case it will be 1972.05

For more information: Please refer this link : #-Link-Snipped-#

I am trying to develop web version of this software

Thanks

0