Закрыт

mortgage excel capital repayments formula

Hi

What we want is a formula put in column F to automatically calculate the capital repayments figures.

This is a mortgage account put on an excel spreadsheet

column C is the interest rate charged, D is the capital owed or current balance and column E is the interest charged and column F is the capital payments.

Of course in a repayment (interest and capital) mortgage the monthly premium is made up of the interest and a portion of the capital. The capital amount starts of small and towards the end of the mortgage it is a greater part of the payments and is caluclated according to an accounting formula.

This is what we want we want a formula put into column F that will automatically calculate the capital repayments.

This mortgage started off in dec 1988 for a term of 25 years, and started off as an interest only. In january 1995 the mortgage was changed to a capital and interest formula, therefore from that point there were capital payments calculated to make sure the balance was paid off not just the interest.

Therefore as we have said we only want column F formulised to automatically calculate the capital repayments

everything in blue is irrelevant to the calculation and should be ignored

Квалификация: Бухгалтерия, Обработка данных, Excel

Показать больше capital repayment formula excel, capital interest repayment spreadsheet, excel capital repayment formula, capital interest formula, excel mortgage formula, mortgage capital interest formula excel, calculate repayment mortgage capital repayments excel, capital repayment formula, calculate percent mortgage paid excel, find formula calculate capital repayment, mortgage formula excel, formula calculating repayment mortgage, mortgage capital repayment, mortgage ecxel, mortgage repayments accounting, what is bookkeeping, what bookkeeping, we excel, spreadsheet accounting, formula it

О работодателе:
( 3 отзыв(-а, -ов) ) torquay, United Kingdom

ID проекта: #289555

22 фрилансеров(-а) в среднем готовы выполнить эту работу за $94

MAnkita

Hello,Please refer your [login to view URL] you.

$100 USD за 2 дней(-я)
(91 отзывов(-а))
6.3
imranamin

Kindly Check PM

$30 USD за 1 день
(51 отзывов(-а))
6.0
expertMan

ready for your work.

$30 USD за 0 дней(-я)
(4 отзывов(-а))
5.0
Pedri

Hi, I can compleate this task now. Please see pm for a sample of the values. High performance delivered. Pedri Cronje

$30 USD за 0 дней(-я)
(1 отзыв)
0.9
ATop

Hi Sir: I am proficent at office developing and VBA developing. I can do it for you. Look forward to working for you. Thanks, ATop

$250 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
bindu0201

I will do the work successfully

$175 USD за 21 дней(-я)
(0 отзывов(-а))
0.0
ddrops

Long Experience In Accounts & Excell. We Can Do it very fastly & correctly. Pls. Alloe us to Strat the job.

$40 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
mddcfreelance

As an accountant, I believe I can do the job. Thank you for the opportunity. Looking forward.

$200 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
barkatakhoda

I will be able to do the work perfectly. Because I am working as an Assistant Accounting Manager in a large group of industries. So You can give me the project.

$250 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
bressr

I can easily complete the prokect for you based on my many year's exprience with Excel and mortgage modeling.

$30 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
sunnad

i can start right now with lot of expirence

$50 USD за 1 день
(0 отзывов(-а))
0.0
alphiya

Hi! I'm the mathematician that has also experience in programming on C++, Delphi, VB, Maple, Surfer and Excel. Have graduated the Lomonosov Moscow State University the Maths department. Please contact if you're interes Больше

$70 USD за 1 день
(0 отзывов(-а))
0.0
farrukhz

See PM please

$30 USD за 1 день
(0 отзывов(-а))
0.0
rolsen28

I solved the fomula. See PM.

$35 USD за 0 дней(-я)
(0 отзывов(-а))
0.0
sundarmsb

Hi I am an expert in excl formulisation. I can do justice to your job

$200 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
erpurohit

Exp in macro programming

$30 USD за 0 дней(-я)
(0 отзывов(-а))
0.0
raghavaav

i complete this project with in 2 days

$150 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
victor1983

I am ready to start this work asap.

$31 USD за 4 дней(-я)
(0 отзывов(-а))
0.0
makemoney24

Can start right now! Lot of Excel experience.

$45 USD за 0 дней(-я)
(0 отзывов(-а))
0.0
harvi

i can do it...

$30 USD за 0 дней(-я)
(0 отзывов(-а))
0.0