Annulleret

excel morgage payment formula

we have a morgage spread sheet that can be run for different senerios ie different payment amounts different interest rates etc

so all columms are formulaised for this effect

except cannot work out how to formulise columm j capitol payments

This calculation should be a standard accounting one for a repayment or captial and interest mortgage...ie the monthly payments have a component of interest which is I and capital repayments which is column J. There is a formula for calculating this which we think is based on the interest charging balance of column F, adjusted for the number of months in the mortgage etc

This may be complicated in this instance because the interest rate column C only applies to anything over £30,000. The interest rate for the first £30,000 has miras which is a old uk discount allowance which starts at 25% of column C,

please dont bid if you dont have the answer to this as this is what the job is

ie to correctly formalise that columm J

Færdigheder: Regnskab, Databehandling, Excel

Se mere: morgage payment formula, morgage formula, excel payment formula, morgage excel, payment formula excel, payment formula, excel monthly payment formula, morgage equation, morgage repayment, formula morgage payment, interest payment formula excel, what bookkeeping, we excel, that payment, mortgage job, job bookkeeping, first capital, captial one, capitol one, capital one, can capital, balance accounting, excel count payment, payment formula actual days, formula morgage

Om arbejdsgiveren:
( 3 bedømmelser ) torquay, United Kingdom

Projekt-ID: #287622

11 freelancere byder i gennemsnit $45 for dette job

MAnkita

Hello,Please refer your PMB.Thank you.

$100 USD in 2 dage
(91 bedømmelser)
6.3
imranamin

Kindly check PM for details

$30 USD på 1 dag
(51 bedømmelser)
6.0
cykwong

I would like to know more first. Please take a look in PMB

$30 USD på 1 dag
(1 bedømmelse)
1.6
sbinfo

Check the PM for details

$50 USD in 3 dage
(0 bedømmelser)
0.0
jenarthananks

Since i have vast years of exp. in MS-Excel i can help to complete this project you as mentioned above.

$30 USD på 1 dag
(0 bedømmelser)
0.0
rolsen28

Please respond to PM. Thanks.

$50 USD på 1 dag
(0 bedømmelser)
0.0
karish

I have experience in this work am sure you will not be dissapointed.

$50 USD in 2 dage
(0 bedømmelser)
0.0
bluekart

Hi, Please check PM board, Thanks

$30 USD på 1 dag
(0 bedømmelser)
0.0
kalyanibaji

Ready to d0

$30 USD på 1 dag
(0 bedømmelser)
0.0
dkosala82

I have done this type of project before. Exactly like this one. I can do this in a perfect manner.

$50 USD in 2 dage
(0 bedømmelser)
0.0
rrashell

i want to do this job.please reply.

$48 USD in 2 dage
(0 bedømmelser)
0.0