What about if your starting off with a loan that already has accumulated unpaid interest? How do you calculate the monthly payment without the added interest affecting the rate that is only charged based on the principal and not the principal + interest?
The PMT is calculating the period with 30 days per month, which is 360 days per year, I think this is the problem, there should be a solution for this, let me know if you have any.
Thank you for the excellent & concise explanation!
Good job: quick, informative, even covered some theory--"shows up negative because it's shown as a cash outflow. . , something like that. thanks,
wow, you have really helped me in one of my assignments, thank you sir
Excellent explanation, Thank You.
Glad you liked it
Awesome!!
Very good, congratulations.
Thanks!
EXCELLENT
nice
Thanks
Welcome
What about if your starting off with a loan that already has accumulated unpaid interest? How do you calculate the monthly payment without the added interest affecting the rate that is only charged based on the principal and not the principal + interest?
i do the same but get a #VALUE! error
i hv a questions... if loan amount is 10k, annual int is 4%, tenure 5 yrs... montly should be 200... why pmt value is 184.xx is the formula wrong...
The PMT is calculating the period with 30 days per month, which is 360 days per year, I think this is the problem, there should be a solution for this, let me know if you have any.