Steps for some
common car wash financial calculations
1.)
Calculate the monthly loan payments on your car wash loan.
- a.) In the first line, enter the dollar amount of the
loan.
- b.) In the second line, enter the interest rate, such as
6.0 (six percent), or 7.25 (seven-point-two-five percent), etc..
Do not enter the percentage sign.
- c.) In the third line enter the number of payments.
For example, if the loan is for twenty years, separately multiply 20
times 12 (months) for a total of 240 months. Enter this number of
payments.
- d.) In the fourth line enter the number of payments per
year, which is usually 12 (one per month).
- e.) In the fifth line, leave the entry field blank.
At the far right lower corner click the "Payment Amount".
The result is the dollar amount of the monthly loan payments.
2.)
Calculate an effective interest rate for a car wash equipment
lease.
Use this to compare leases. This only works if the last payment
(residual)
is essentially zero ($1).
- a.) For the lease amount (loan amount) use the gross
lease
amount, then subtract the portion of that which you must pay in
advance. This is the net lease amount. Fax a copy of the
lease to us if you need
help.
- b.) Enter
the number of payments that must be made after the initial 'first and
last' payments and after any other deposits. For example, if you
are getting a 60-month (5-year) lease you may be required to make, in
advance, a 'first and last payment' deposit. In that instance you
will have 48 monthly payments to make, beginning at the end of the
first month.
- c.) Enter the number of payments per year (usually
12).
- d.) Enter the dollar amount of
the monthly payment.
- e.) At the right of the interest rate blank field,
click on the "% Interest Rate" button. This will calculate your
effective interest rate.
3.)
Calculate the number of payments remaining on a car wash
loan.
- a.) Enter the remaining balance of the loan (line
one). (If
this is a new loan enter the loan amount.)
- b.) Enter the interest rate of the loan (line two).
- c.) Enter the number of payments per year, which is
usually 12 (line four).
- d.) Enter the dollar amount of the monthly payment (line
five).
- e.) To the right of the "...payments over the life of the
loan?" blank field, click on the "Total Payments" button. The
result is the number of payments remaining on your loan.
4.)
Calculate a car wash capitalization rate.
- a.) Separately,
calculate the EBITDA, which is the bottom line net earnings (or loss),
plus the historical interest
expense during the period (usually the
previous year), plus any income
taxes paid or incurred during the
previous year, plus depreciation
expense during the period, plus amortization
expense during the period.
If you are using a car
wash business tax
return to calculate EBITDA look for these expenses on the first page of
the return and on the supporting schedule for the Other Deductions that
are only totaled on the first page of the return. You can usually
find the supporting schedule
in the last few pages of the return.
Some car wash investors calculate EBITDA prior to owner
withdrawals or salaries, but also calculate it after a reasonable
withdrawal or salary for the genuine work that the owner has done (or
will do) at a reasonable market rate. To compare car washes you
may want to calculate EBITDA before the
owner withdrawal and/or salary.
- b.) In the "...amount of loan?" line (line one) enter the
anticipated purchase price. Business financial calculators from
companies like Texas Instruments also call this term "PV", which is
Present Value.
- c.) In the "...payments over the life of the loan?" line
(line three) enter 99. This is just for simplicity. After a
number of periodic payments (annual incomes) the capitalization rate
result becomes closer to the 'correct' number no matter how many
payments (incomes) are entered.
- d.) To simplify, in the fourth line, number of
"...payments...per year ?", enter 1 (one).
- e.) In the fifth line, enter the amount of annual EBITDA
(cash flow) that you expect.
- f.) To the right of the "...interest rate?" (line two)
blank field, click on the "% Interest Rate" button. The
result is the capitalization rate, commonly used to compare alternative
investments (car washes).
With this
calculator you can also determine your return on cash invested
(cash-on-cash rate of return) and the cash return on assets. Most
car wash investors calculate these numbers both before and after the
loan payment.
If you want to
do other calculations and need assistance, or want us to add the
step-by-step instructions for a calculation, please e-mail us and we
will help you.