excel morgage payment formula

This project received 11 bids from talented freelancers with an average bid price of $45 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
Total Bids
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online