Excel sheet Formula

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

Get free quotes for a project like this
Project Budget
Total Bids
Project Description


Looking for a mortgage payment calculator in an excel sheet. I need it to be part on an PP presentation.

## Deliverables

Looking for a mortgage payment calculator in an excel sheet.

1. **Loan Amount**

2. **Term (in years):**

3. **Estimated annual property taxes**

4. **Estimated annual homeowners insurance**

**? **

**About Your ARM**

**1.? ? ? ? **Length of initial rate term (in months****

**2.? ? ? ? ***Index** **(%)** **

**3.? ? ? ? **Margin** **(%)** **

**4.? ? ? ? **Expected amount of index adjustment** **(%)** **

**5.? ? ? ? **Lifetime Cap** **(%)** **

**? **

**Home Equity Payment Calculator**

**What will your monthly home equity loan payments be?**

This calculator helps you determine how much your monthly payments will be for a home equity loan or line of credit based on different combinations of loan amount, home equity interest rate, and term.


**X - Please select a loan type.**

***Loan type:**

<option value="0" selected="true">Select One</option> <option value="FixedRate">Fixed-Rate Loan</option> <option value="InterestOnly">Interest Only Loan</option>

[Tip**Loan Type** **- The payments on a fixed-rate loan will stay the same for the life of your loan. The payments on an interest-only loan do not include principal.**][1]

**X - This field is required.** **X - Please enter a valid dollar amount greater than zero.**

***Loan Amount:**

[Tip**Loan Amount** **- Enter the amount you plan to finance. For example, if you are buying a $300,000 home with a 20% down payment, your loan amount would be $240,000.**][1]

**X - This field is required.** **X - Please enter a valid number.**

***Interest rate:** **(%)**

[Tip**Interest rate** **- Enter the interest rate that you will pay. You can find current mortgage rates from Freddie Mac at**][1]

**Loan Term (in years):**

<option value="2" selected="true">2 Years</option> <option value="3">3 Years</option> <option value="5">5 Years</option> <option value="7">7 Years</option> <option value="10">10 Years</option> <option value="15">15 Years</option> <option value="20">20 Years</option> <option value="25">25 Years</option> <option value="30">30 Years</option> <option value="40">40 Years</option> <option value="50">50 Years</option>

[Tip**Term** **- "Enter the term you desire for your loan. Common mortgage terms are 15, 25 and 30 years.**][1]

**? **

Skills Required

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