##### Financial Mathematics - Please can any one help me to solve this problem?

label Mathematics
account_circle Unassigned
schedule 1 Day
account_balance_wallet \$5

May 3rd, 2015

Attached is the detailed solution in excel Repayment.xlsx

Here is the method for your reference -

1.  We need to find a value of P for which the total amount of 40,000 gets repaid under given conditions. Therefore

Present value (PV) = 40000

Future value (FV) = 0 (to repay all)

Time period = 12*5 = 60

2. I have used the discounting formula to find out the present value of all future payments and equated it to 40,000. Then I have found out for what value of P this equation holds true.

Answer: P = 4640.025

Let me know if you need further help

May 3rd, 2015

Thank you for your prompt response.

I have a question please clarify, why you used "i" - Interest value as is which is 12%, while in problem it says, nominal interest rate of 12%  compounded monthly. Does this mean that, we have to determine the monthly effective interest, which will equal to 12/12=1% !!!

May 4th, 2015

I have use total number of periods = 60 which is to say I have considered each month as an individual payment period. Thus it is perfectly okay to use 12% and there is NO NEED to find effective rate.

Don't get confused with notations. In this solution, a month is a period with 12% interest rates.

May 4th, 2015

I got your point.

Why I am asking, because, I need to submit the solution, and show the approach i used, I mean I must use the "formula" , when I am using formula, I was considering  monthly effective interest as 1% in the "Increasing Annuity-Immediate Present Value"..

If I want to use your figures, which formula I will have to use, if we want to solve it other than excel?

May 4th, 2015

The way I solve such questions is to assume a random value for payment P to begin with, find the sum of PV of all payments and then use Goal seek tool of excel to find exact value of P.

If we look at formula based approach then we have to go for 'Annuities whose payments follow an arithmetic progression'. There is a paper which explains this technique, if you want I will share the link with you, but it is not my work.

Attached is the formula for the same taken from third party paper inc annuity 1.png

Let me know if you want me to share the link of the paper with you.

May 4th, 2015

...
May 3rd, 2015
...
May 3rd, 2015
Aug 21st, 2017
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle