apr

Hi Friends I need a help for finding Distinct count unique value as follows : Product Month Salesman Merge A&B&C DistinctCount Apple Apr Alexandar AppleAprAlexandar 1 Apple May Alexandar AppleMayAlexandar 1 Apple Apr Alexandar AppleAprAlexandar 0 Apple Apr Mathew...

Hey mate....please help me i have to calculate duration for 2 date and time. Please help me with the formula on C. For example <tbody> A B C 1 Start End Duration 2 1 Jan 16 13:30 3 Apr 17 23:45 1 Year 3 Month 2 Days 10 Hours 15 Minutes 3 1 Apr 15 12:40 1 May 17 13:45 2...

Is it possible to change text like, <tbody> Apr 2017 FEB 2017 Feb 2017 To real dates? </tbody><colgroup><col></colgroup>

Hi Guys :), I am feeling like this: :rofl: Here's what I have: <tbody> VALUES LABELS NOTES/FUNCTIONS 500,000.00 Loan Amount 30 Term in Years 9.95% Interest Rate 4,369.39 Monthly Payment =-PMT(B4/12,B3*12,B2,0) 11,909.56 Finance Charge 488,090.44 Amount Financed =B2-B6...

I'm trying to build a function to calculate the closing costs associated with certain loan parameters. Example here is 30yr loan, note rate is 4.125, APR is 4.198, loan amount $200,000. I can figure out the APR using the =RATE function, having the total closing costs already on hand. In this...

I am trying to determine the amount of finance charges due based on 18% APR when I have the payment terms in one column (ie Net 15), the invoice date in one column (ie 1/15/12), the balance due in a column (ie $790.00), and the statement date in a column (ie 5/18/12). Suggestions? Also, to add...

(2 questions in this post btw) I'm purchasing new computer equipment for my dad's graphic company... The equipment costs $105,000 up front, but I can lease it for 3 years at $4,500 (monthly). The vendor I am going through is actually waiving the first month for me so it is 35 months, but he...

Is there a way with Excel to calculate the APR for an adjustbale rate loan? I'm trying to figure out how to calculate the APR for an ARM loan that has a rate set for three years (initial rate) then the rate adjusts to the index plus the margin (2.75+1.25=4.00%) for the remainiing 27 years...

Hi all, I just bought a Camry, and am financing through TFS (Toyota Financial Services). On the paperwork, it says the rate is 5.5% and I am borrowing $11,306 for 4 years, and that makes my monthly payment $263.54. However, when I enter these numbers in Excel and use the PMT formula, it...