Re: Loan accounts

"Edward A. Melia, C.P.A./Attorney" <[email protected]> Fri, 14 Oct 2011 14:42:57 -0700
Newsgroups gmane.comp.finance.moneydance.general
Message-ID <[email protected]>
John,

APR is the interest rate (annual percentage rate).

The amount borrowed is the original principal of 10,300 (or 10,370 if 
the 70 fee was added to the borrowed amount).

With a loan of 10,300 and 96 monthly payments of 230.95, the only 
unknown is the interest rate.  If you enter either of the rates in your 
email (14.4% or 25%) into Moneydance, the program will not compute a 
monthly payment of 230.95.  Using 10,300 and 96 payments of 230.95 a 
loan amortization program that I use, calculated an interest rate of 
22.320%  If you enter 22.320% into Moneydance it computes monthly 
payments of 230.96 - close to your actual payment.  Unfortunately the 
Moneydance program is a simple program in that it will not solve for 
unknowns.

In addition, when additional principal payments of 4,000 & 3,000 were 
made, the loan must be recalculated by adding the payments in the Extra 
Principal column for Moneydance.

If you know the principal amount borrowed, the fixed monthly payments 
and the term of the loan then, the interest rate (APR) might have to be 
computed for the Moneydance program.  Normally, if you have a good APR 
the Moneydance calculation should be close.  If not, then keep changing 
the APR until you get the actual monthly payment.

In addition, the method the lender uses to compute the compounding of 
interest will impact the calculations.  Generally, monthly compounding 
is utilized which, I believe, is the method Moneydance uses.

   Ed Melia, Sacramento, CA

On 10/14/2011 1:02 PM, John Sampson wrote:
> I see there are both an APR and an interest rate but I don't know why. 
> I expect this is what led to the confusion -
> perhaps the APR, whatever that is, is the figure to use in 
> calculations, not the interest rate. Moneydance's loan
> calculator probably applies to a particular type of loan extant in the 
> USA.
>
> I had paid lump sums during the period of the loan as well as monthly 
> payments. I have paid off the loan now.
> I did not understand the terms "points" and "rates". I see in the loan 
> calculator a space for APR, but none
> for interest rate. It may be that "Amount borrowed" is the total 
> charge for credit rather than the amount of credit.
>
> For what it is worth, the figures were:
>
> Total cash price £11,445
> Deposit £1,145
> Total charge for credit £11,941.20
> comprising interest £ 11,871 and document fee £70.
> Interest rate was 14.4% p.a.
> There were to be 96 monthly payments of £230.95.
> Interest was calculated in advance on what would be the daily 
> outstanding balance
> of the amount of credit (£10,300) on the assumption that I kept up the 
> payments.
> APR was 25% FWIW.
> I paid two lump sums during the course of the loan, £4,000 and £3,000. 
> The timings
> of these would presumably affect the final settlement figure.
> I made twelve monthy payments in the event before settling with a sum 
> of £2377.16 which
> included a settlement fee of 30 days interest.
>
> Regards
>
> _John Sampson_
>
>
>
> On 14/10/2011 19:50, Edward A. Melia, C.P.A./Attorney wrote:
>> Yes, you are correct.  I saw 800 pounds in John Sampson's email and 
>> jumped to the conclusion (incorrectly) that he also used the term 
>> fortnightly.  Careless of me not to have checked the postings.  
>> Looking back over the emails, I did not see any details regarding 
>> John Sampson's problem other than an 800 pounds difference.
>
> _______________________________________________
> For Moneydance customer support, please visit 
> http://help.infinitekind.com
> [email protected]
> http://moneydance.com/mailman/listinfo/moneydance-info
>
_______________________________________________
For Moneydance customer support, please visit http://help.infinitekind.com
[email protected]
http://moneydance.com/mailman/listinfo/moneydance-info