Project Detail

mortgage excel capital repayments formula  

mortgage excel capital repayments formula is project number 289555
posted at GetAFreelancer.com. Click here to post your own project.

 

Bookmark and Share
Free Trial For New Buyers
 

Status: Closed
(Project expired)

Selected Providers: -

Budget: $30-250

Created: 07/20/2008 at 9:50 EDT

Bid Count: 22

Average Bid: $ 94

07/21/2008 at 9:50 EDT

Project Creator: kozrak View PM Post PM
Employer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 (3 reviews)

Bid On This Project
 

Description

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




Additional files submitted:
loan capital payments column to be formulisedq.xls

Messages Posted: 2 View project clarification board Post message on project clarification board

Bid On This Project
 
If you are the project creator or one of the bidders Log In for more options

  View PM Post PM

100

2 days

07-20-2008 10:23 EDT

Hello,Please refer your PMB.Thank you.

help

  View PM Post PM

30

0 days

07-20-2008 13:08 EDT

ready for your work.

help

  View PM Post PM

30

1 day

07-20-2008 13:49 EDT

Kindly Check PM

help

  View PM Post PM

250

2 days

07-20-2008 09:54 EDT

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

help

  View PM Post PM

30

0 days

07-20-2008 14:23 EDT

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

help

  View PM Post PM

45

0 days

07-20-2008 13:07 EDT

Can start right now! Lot of Excel experience.

help

  View PM Post PM

200

7 days

07-20-2008 10:05 EDT

(No Feedback Yet)

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

help

  View PM Post PM

60

1 day

07-20-2008 11:02 EDT

(No Feedback Yet)

I'm good at Excel and am from the banking sector. Think I could do this for you.

help

  View PM Post PM

30

0 days

07-20-2008 12:46 EDT

(No Feedback Yet)

i can do it...

help

  View PM Post PM

31

4 days

07-20-2008 13:15 EDT

(No Feedback Yet)

I am ready to start this work asap.

help

  View PM Post PM

150

2 days

07-20-2008 13:40 EDT

(No Feedback Yet)

i complete this project with in 2 days

help

  View PM Post PM

30

0 days

07-20-2008 13:43 EDT

(No Feedback Yet)

Exp in macro programming

help

  View PM Post PM

30

1 day

07-20-2008 13:55 EDT

(No Feedback Yet)

See PM please

help

  View PM Post PM

35

0 days

07-20-2008 14:00 EDT

(No Feedback Yet)

I solved the fomula. See PM.

help

  View PM Post PM

175

21 days

07-20-2008 14:06 EDT

(No Feedback Yet)

I will do the work successfully

help

  View PM Post PM

70

1 day

07-20-2008 14:33 EDT

(No Feedback Yet)

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 interested.

help

  View PM Post PM

50

1 day

07-20-2008 14:51 EDT

(No Feedback Yet)

i can start right now with lot of expirence

help

  View PM Post PM

30

2 days

07-20-2008 15:13 EDT

(No Feedback Yet)

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

help

  View PM Post PM

250

2 days

07-20-2008 23:11 EDT

(No Feedback Yet)

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.

help

  View PM Post PM

200

2 days

07-21-2008 00:22 EDT

(No Feedback Yet)

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

help

  View PM Post PM

40

2 days

07-21-2008 04:31 EDT

(No Feedback Yet)

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

help

  View PM Post PM

200

6 days

07-21-2008 07:26 EDT

(No Feedback Yet)

Having perused the description of the project, I am confident that I can complete the required tasks to your utmost satisfaction using my expertise. Extremely capable and highly experienced at accounting projects of your project scope and possess multiple skills required to give added value to the project. I am a quick communicator as well. Please refer to my profile for more information. Available immediately to undertake your assignment if I am being awarded it. Best regards

help

    Bid on this Project