Excel sheet Formula

Closed

?

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 www.freddiemac.com.**][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: PHP

See more: www principal com, principal com, freddie mac, formula it, excel sheet formula, true life, sheet, line sheet, finance in excel, finance excel, finance calculator, Excel sheet, excel sheet an, excel formula, excel for mac, excel finance, excel calculator, line calculator, monthly mortgage payment, excel mortgage, mortgage monthly payment, excel adjustment, formula excel index, excel property, annual rate excel

About the Employer:
( 0 reviews ) United States

Project ID: #3871593

23 freelancers are bidding on average $47 for this job

pShankar2

See private message.

$85 USD in 5 days
(405 Reviews)
7.1
shikhamehta

See private message.

$63.75 USD in 5 days
(208 Reviews)
6.8
privateryanvw

See private message.

$68 USD in 5 days
(58 Reviews)
5.9
dev3dworx

See private message.

$21.25 USD in 5 days
(23 Reviews)
4.8
ranamohsin123sl

See private message.

$25.5 USD in 5 days
(38 Reviews)
4.8
Apogeesolutions

See private message.

$21.25 USD in 5 days
(70 Reviews)
4.6
ender81

See private message.

$34 USD in 5 days
(19 Reviews)
4.0
mraheelgujjar

See private message.

$42.5 USD in 5 days
(12 Reviews)
2.4
jx1981

See private message.

$25.5 USD in 5 days
(3 Reviews)
2.3
globetechie

See private message.

$85 USD in 5 days
(2 Reviews)
2.4
KreativeSys

See private message.

$59.5 USD in 5 days
(2 Reviews)
1.8
nilankasvw

See private message.

$34 USD in 5 days
(7 Reviews)
1.6
Byambajargal

See private message.

$38.25 USD in 5 days
(7 Reviews)
1.5
jawharavw

See private message.

$42.5 USD in 5 days
(3 Reviews)
1.4
pearlveera1

See private message.

$8.5 USD in 5 days
(0 Reviews)
0.0
shoffhei

See private message.

$85 USD in 5 days
(0 Reviews)
0.0
parthtrivedivw

See private message.

$17 USD in 5 days
(0 Reviews)
0.0
karnakk

See private message.

$85 USD in 5 days
(0 Reviews)
0.0
CrystalLogic

See private message.

$34 USD in 5 days
(0 Reviews)
0.0
waseemarid

See private message.

$85 USD in 5 days
(1 Review)
0.0