Hello,

I'm trying to figure out a lease payment for a client of mine. I am leasing them equipment for 3 years, with a present value of $27,023, a residual value of $1, and a 15% rate of return. That part is simple, but I'm trying to account for the 8% cost of money to me. I'm getting that $27,023 from an investor expecting an 8% return. I am charging my client a 15% return and I make my money on the 7% margin. How can I calculate my client's payment using Microsoft Excel?

Thanks.

I'm trying to figure out a lease payment for a client of mine. I am leasing them equipment for 3 years, with a present value of $27,023, a residual value of $1, and a 15% rate of return. That part is simple, but I'm trying to account for the 8% cost of money to me. I'm getting that $27,023 from an investor expecting an 8% return. I am charging my client a 15% return and I make my money on the 7% margin. How can I calculate my client's payment using Microsoft Excel?

Thanks.

- Rental Lease Payments Schedule
- Does anyone have a formula to calculate the car lease payments
- Lease Car vs Buy Calculator - Please Comment
- USD $10.00 Inputting Formulas Into Userform Calculator - Relatively Simple
- Monthly mortgage payment calculator
- Payment calculation
- Payment calculator
- Car loan payment calculations
- Payment Calculations
- Night payment calculator
- Payment Calculator not working correctly
- I need a loan payment calculator/balance sheet w/missed or infrequent payments
- Lease expire calculation
- Sum: Many Conditions-Criteria
- Payment function giving negative $ result
- Vlookup help with multiple values
- APR Calculator
- Vlookup & Hair Removal
- Rate formula
- Credit card Calculation
- Payment formula problem..
- Payment calculation w/ back interest
- Payment calculation w/ back interest
- Subtracting

Just thought I share my new rental lease payments schedule. I am sure there better way to do this. I have broke it into few steps but it works.

Biz

I am just looking for a formula that will allow me to calculate the monthly

repayments for a car lease. Thanks in advance

See the attached and let me know what I'm neglecting or what else I should be considering. I threw this together this morning and look forward to help/comments.

I had someone create a Excel Spreadsheet for me with a userform for calculating something for me.

Everything is in completion EXCEPT for the formula's represented by the particular fields in the userfield.

Since I'm not THAT familiar with VBA I was wondering if someone could help input the formula's for me. I have the formula's on hand and exactly where they need to go, I just don't know how to do them via VBA.

Any help would be appreciated and if it helps the thought process at all the calculator is based off of: http://www.baileycapitalfund.com/Lea...calculator.php.

Please look below if you can help (the red highlighted portion will be the user input and the blue highlighted portion will be the output after "calculate" is pressed):

[MOD EDIT]...... removed image

**Please note the difference between "Tax Rate (GST/PST)" and "Tax Rate" below, they are both different user inputs, I apologize the person who created the userform made it a bit confusing**

Cost of Equipment (Cash, Loan, Lease)= Equipment Cost (User Input)

Bank Interest (Loan)= (Cost of Equipment * 0.032)

Bank Interest (Cash & Lease)= N/A

Monthly Lease Payment Before Taxes (Cash & Loan)= N/A

Monthly Lease Payment Before Taxes (Lease)= ((Equipment Cost/(Preferred Term *12)) * (1+(Lease Rate Quoted/100)))

Taxes (Cash & Loan)= (Equipment Cost * (Tax Rate (GST/PST)/100))

Taxes (Lease)= (Monthly Lease Payment Before Taxes * (Tax Rate (GST/PST)/100))

Lease Buyout (Cash & Loan)= N/A

Lease Buyout (Lease)= (0.1 * Equipment Cost)

Total Equipment Cost Before Tax Savings and Future Value(Cash, Loan & Lease)= Equipment Cost (User Input) + Taxes + Bank Interest

Depreciation (Cash & Loan)= ((100%-(Lease Amount Buyout Rate))/100)*(Equipment Cost)

Depreciation (Lease)= N/A

Bank Interest (Loan)= (Cost of Equipment * 0.032)

Bank Interest (Cash & Lease)= N/A

Lease Payments Plus Buyout (Cash & Loan)= N/A

Lease Payments Plus Buyout (Lease)= Total Equipment Cost Before Tax Savings and Future Value

Total Deductions (Cash)= N/A

Total Deductions (Loan & Lease)= Depreciation + Bank Interest + Lease Payments Plus Buyout

Deductions x Tax Rate (Cash)= N/A

Deductions x Tax Rate (Loan & Lease)= ((Tax Rate/100) * Total Deductions)

Interest Earned On Capital Over Term (Corporate ROI) (Cash, Loan & Lease)= (Cost of Equipment *0.08)

Total Equipment Cost (Cash, Loan & Lease)= Total Equipment Cost Before Tax Savings and Future Value

Less Corporate Tax Savings (Cash)= N/A

Less Corporate Tax Savings (Loan & Lease)= Deductions x Tax Rate

Less Interest Earned (Cash, Loan & Lease)= Interest Earned on Capital Over Term

Less GST Tax Credit (Cash & Loan)= (Equipment Cost * 0.05)

Less GST Tax Credit (Lease)= (Equipment Cost * (Lease Rate Quoted/100))

Net Cost of Equipment (Cash, Loan & Lease)= (+(Less Interest Earned) + (Total Equipment Cost))- (Less GST Tax Credit)

Cash On Hand At End of Term (Cash)= N/A

Cash On Hand At End of Term (Loan & Lease)= (Cost of Equipment + Interest Earned on Capital over Term) - Bank Interest

[MOD EDIT] - Removed attachment

realtors web sites. My formula= (100,000*.06)/12 does not include the

interest so my calculations were too low.

How would I figure out a monthly payment for a $100,000 loan at 6% over 30

years? Is there a special formula?

Thanks.

-Raza

a payment and how regular financial software calculates it. Take an

example:-

Term: 60 months

Amount: $25,266

Rate: 6.29% pa

Payment Function: PMT(6.29/360, 60*30, -25266) returns $441.

My financial software gives me $491. That is $50 difference! Why? The

software I am using is Auto loan calculation software and I know it is

right, because it is used by banks.

TIA!

Loan amount

Rate

Term in months

Note date

First payment date

and excel calculate:

monthly payment

APR

Is there any templets out there, I can't find one? The simplier the better.

Thanks

Hi,

How do we calculate the interest and payments of car loan?

Any help please.

Thanks

Saziz

How do we calculate the interest and payments of car loan?

Any help please.

Thanks

Saziz

Then I would like to enter a misc field for Yes/No answer. If the answer is yes, I want to cancel out step one and then enter the new average from another category of averages. Then have another field to enter a number "1 to 100". I want this number to be multiplied automatically by $5.15. Then this answer to be added onto the averages.

Can anyone give me any help! It would be appreciated!

Not sure if this is the correct section for this kind of query but I'd like some assistance with a calculation that I can't seem to figure out.

Essentially it's for calculating night payments for our employee time-sheets. Our staff have very sporadic shifts and are paid extra for working between the hours of 00:00 and 06:00, basically when employee's enter their start and end times I'd like the spreadsheet to automatically calculate how many hours they have worked between those hours, I imagine it's very simple but I cannot figure out which function to use.

To complicate matters, because staff can work shifts which start on one day and finish the next we work on a 48:00 clock basis so its' not only between the hours of 00:00 - 06:00 where they qualify for night payments but also from 24:00 - 30:00 if that makes sense?

Any assistance in working out this query will be greatly appreciated.

Payment using the =PMT(Rate/12,Term,Loan Amount)*-1 formula that I have used

on many other spreadsheets. These older spreadsheets all work properly, but

they were all written on another computer and imported into the one I am now

using. The formula â€ś=PMT(10/12, 360,100000)*-1â€ť should give me a payment of

$877.57, but it gives me $83,333.33 instead! Is their a flaw in the newer

Excel versions, or a patch I donâ€™t have? Any help would be appreciated.

--

SwimBob

I am VERY new to Excel and not familar with a whole lot yet.

Any help and patience is very much appreciated.

Thanks for your time!!

Lisae

I am trying to calculate the expire date in the format of Day/Month/Year of the lease agreement. This lease agreement need to be reviwed on every 10 years and started from year 2001.

I am trying this: =A+(365*10).

However, i have problem with the month of Febuary as sometime it finishes on 28th, and sometime on 29th.

Your advise will be very much appreciated.

Thanks,

I have recently started using formulas in Excel therefore cannot really crack this problem down. In my worksheet, I have a column (A2:A200) which stores dates starting from Jaunuary 1st 2006 to January 1st 2007. The second column (B2:B200) stores the expense type (i.e: Maintanence, gas, lease payment), and the third column (C3:C200) stores the amount spent on the given date and expense type. What I would like to do is to create a formula which calculates the amount spent on maintanence, gas, lease payment during January, February, etc:

Thanks for all the help I can get

Is this file corrupted or have I put something in incorrectly?

Lease 1

Payment

Payment70750-xxxSalesTotalPrincipalDateAmountInterestPrincipalTaxPrincipalBalanceAt Inception35,240.00 4/2006729.00 262.27 412.73 54.00 466.73 34,773.27 5/2006729.00 258.81 416.19 54.00 470.19 34,303.08 6/2006729.00 255.33 419.67 54.00 473.67 33,829.41

Lease 2

28039-001PaymentPayment70750-xxxSalesTotalPrincipal DateAmountInterestPrincipalTaxPrincipalBalanceAt Inception35,240.005/2006729.00262.27412.73 54.00 466.73 34,773.27 6/2006729.00258.81416.19 54.00 470.19 34,303.08 7/2006729.00255.33419.67 54.00 473.67 33,829.41 8/2006729.00251.81423.19 54.00 477.19 33,352.22

Summary sheet for all leases

PaymentPayment70750-xxxSalesTotalPrincipalDateAmountInterestPrincipalTaxPrincipalBalanceAt Inception4/2006This is where I need the formula5/2006.6/2006

I am recalculating APR's of a loan. I first determine the monthly payment given the up front fees with the formula:

=PMT(L9/12,Q9,F9+Z9,0,0) where

L=INTEREST RATE

Q=TERM IN MONTHS

F=LOAN AMOUNT

Z=UPFRONT FEES

the result is in column I.

Then to recalc the APR I use=

=RATE(Q9,I9,F9,0,0)*12 where

Q=TERM IN MONTHS

I=MONTHLY PAYMENT CALCULATED ABOVE

F=LOAN AMOUNT

The difference are relatively small but not from an audit standpoint...any ideas to why these numbers might be slightly off?

Here is the formula in Cell D288

=VLOOKUP(C288,$M$1:$AM$500,$B$2)

& Here is the formula in cell D289

=VLOOKUP(C289,$M$1:$AM$500,$B$2)

The value in B2 is currently "2"

Everything on and before D288 work, and everything on and after D289 does not work. I get a "0" return from the formula, even if the target cell is greater.

Anyone know what my problem might be? Is excel finicky when you are looking for letter and number combinations? I have tried checking the formatting of the table, and everything is consistent. I'm at a loss here.

Anyway, here's the formula side of the sheet:

******** ******************** ************************************************************************>Microsoft Excel - SRO Enterprise Report 2008.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutC274D274C275D275C276D276C277D277C278D278C279D279C280D280C281D281C282D282C283D283C284D284C285D285C286D286C287D287C288D288C289D289C290D290C291D291C292D292=

ABCDE273GL*Account*#:Description:Concatenate:Total:*2745800.000Hedman*Cherry*ExpensesX58000*2755810.000Hedman*Cherry*LaborX58100*2765811.800Hedman*Cherry*WagesX5811.84690.25*2775812.800Hedman*Cherry*TaxesX5812.8387.23*2785813.800HDCH*HaulingX5813.80*2795814.800Cherry*SuppliesX5814.8580.19*2805820.220Cherry*Lease*PaymentX5820.22155*2815849.000Hedman*Cherry*ExpensesX58490*2825860.000Ricks*PearsX58600*2835861.000Rick's*Pears*LaborX58610*2845861.110SuppliesX5861.112259.9*2855862.110Rick's*Pears*WagesX5862.110*2865864.110Rick's*Pears*TaxesX5864.110*2875869.000Rick's*Pears*LaborX58690*2885870.000Dork*PL*ExpensesX58700*2895871.000Dork*ChemicalsX58710*2905872.230Dork*LeaseX5872.230*2915875.000Dork*PL*LaborX58750*2925876.230Dork*PL*WagesX5876.230*Calculator*

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box

PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

I am trying to calculate the interest rate for a lease that does not have

constant payments. I have to pay 1 and last lease payment in advance and some

loan origination fees.

Loan - 500000

payment -19860

up front fees 19000

any suggestions on how to use formula with variable payments and how to

deduct up from fees

thanks

I was wondering if anyone could help me with a minimum payment calculation

on my spreadsheet for my Credit card

I have the following Cells

Credit Limit (L2) ÂŁ4300

Credit Card Amount Owed (L4) ÂŁ3300

Minimum Amount (L6) 2%

And then I have a cell (L8) Minimum Payment and it is in this Cell I want it

to say what my minimum payment will be if you could help with this that would

be great

Regards Joel

Amount Owed (L6) ÂŁ3000

--

N/A

total financed amount. Two of the fields that are added to the total financed

amount calculates the credit life and disability premium respectively. If the

credit life and/or the disability Insurance is not selected they return a

blank field.

As long as both Life and disability are both selected the payment

calculates fine. But if either one is not selected and therefore "blank" then

the payment = "blank".

How can I correct this problem? Thanks.

account unpaid/back interest. There is no interest on the interest so I

can't capitilize it. Any suggestions on how to setup a formula so that I can

figure out a monthly payment for a fixed term? Thanks in advance

account unpaid/back interest. There is no interest on the interest so I

can't capitilize it. Any suggestions on how to setup a formula so that I can

figure out a monthly payment for a fixed term? Thanks in advance

I have a Amortization Schedule that I downloaded from Microsoft. It almost

does everything I want it to but one thing, so I added my own calculator

that subtracts dates and sums the amount remaining on a loan without interest.

I would like to modify the form section in a way that I can manipulate the

total cost of the loan.

example: I would like to have the loan amount be the final with interest

included (which is the remaining D12) all of D is my calculator. And the

scheduled payment to be the same as the lease payment (D10).

date lease started l D5 l loan amount l H5 l scheduled payment

l K5 l

todays date l D6 l interest rate l H6 l scheduled no.of

payments l K6 l

term of lease l D7 l loan period/yrs l H7 l actual no. of

payments l K7 l

months elapsed l D8 l payments/year l H8 l total early payments

l K8 l

months remaining l D9 l start date l H9 l total interest

l K9 l

lease payment l D10 l extra payments l H10l

amount remaining l D12 l

I would like H5 and K9 to equal D12, K7 to equal D9 and K5 to equal D10

without screwing up the amortization schedule.

I know this is a biggy, but if someone or anyone could help, I'd be in debted

Thanks in advance,

Paul M

No luck finding an answer? You could always try Google.