Reverse Mortgage Calculations

Jun 2, 2006

I set up a formula knowing only two variables?

1. Assuming I know how much per month one can pay in total, and
2. The percent interest rate

... I need the total amount that can be financed.

Example:

A. $3,900 maximum per month
B. 5.00% interest rate
C. = x (the amount to be financed)

View 8 Replies


ADVERTISEMENT

Mortgage Calculations With A Difference

May 16, 2007

Scenario - I started doodling with buying a property to let and then started thinking about adding the "shortfall" between the required bond payment and the income generated by the property back onto the loan each month as the shortfall arises. Let's assume that the financial institution will "pay" this shortfall from a previously agreed upon additional amount available on the property - understand?

While there is a shortfall between the income generated by the property and the bond payment, insurance, taxes etc., the outstanding capital will obviously increase as each new month arises and each specific shortfall is added onto the outstanding capital (loan at the bank).

Once the shortfall turns into surplusses, the surplusses are in turn paid into the account until the bond is paid in full.

With a normal, say 15 year, bond, the interest payments and principal payments of the constant mortgage payment (assume fixed interest rate) nicely works out to a balance of 0 in month 180, but not in the scenario I describe.

What happens in the scenario I described above is that, if I keep the payment constant (=PMT(and the rest - calculated on the original term and the original investment) each month's deficit is added to the outstanding capital but the payment stays constant. I want this payment to remain constant throughout the bond.........

View 5 Replies View Related

Reverse Calculations ..

Oct 4, 2007

I dont know if that is the correct title to use but here goes. I am trying to help my friend with some work that he is struggling with.

We have a model where we can change the % of the Service Level in field E8 and it will tell us the number of people required within field E17. Is their a way we can reverse this by creating another spreadsheet where we could put in the number of people we have for it to tell us the service level that would reach?

View 9 Replies View Related

Amortization Table For X Year Mortgage

Jun 1, 2008

I'm trying to make an amortization table with all the individual payments. I'm trying to avoid putting in the formula manually into each individual cell. I have a formula = ROUND(F11*0.12/12,0) and I want to insert that formula down an entire column, but increasing the F11 to F12, F13, etc.

View 4 Replies View Related

Canadian Mortgage Calulator - Interest Savings

Mar 29, 2009

I'm attempting to build a Mortgage payment calculator which calculates interest semi-annually. The goal of the calculator is to determine how much interest you would save if your payments were set to Accelerated Bi-weekly, and Accerlerated Weekly vs. Monthly.

I've already calculated what the payments would be for each payment type, however I'm not able to determine what the interest savings would be.

View 9 Replies View Related

Compound Interest After Mortgage Free Point

May 10, 2008

I've found this calc but it doesn't compare to my particular scenario/goals: http://dinkytown.net/java/InvestmentDebt.html. The major difference is that this dinkytown calc requires a new loan to be put in place and I am not in a position to refinance my current mortgage. My plan is to pay an extra $267 (b3) to the mtg (b4). It will take 128 months (b6) to pay off the mortgage. After that point, I need to calculate what the newly freed capital (b5) would do if I put in an account (i.e. a CD or a simple US savings account) that had an Annual Percentage Yield (APY) of 1, 2, and 3% for 20, 15, 10 and 5 years. I thought that I had the right formula in place for cells b7:b8 should the account earn a 0% rate of return, but I think it's faulty since it gives me a negative number for 10 and 5 year accumulation periods.

View 2 Replies View Related

Reverse Data In A Cell / Reverse Cell Contents

Dec 18, 2009

I am trying to write a formula to reverse data in a cell. Basically I am converting a number to hex then I want to take that hex string and reverse it. So it would be something like this my original number is 400001001 my hex number would be 17D787E9 because I am only allowing it to show 8 characters. I want to reverse the 17D787E9 to read 9E787D71.

My question is: How can I reverse that cell? I have searched google and this forum and can't seem to figure it out. I am sure I could do it in VB but I don't know any VB code.

View 5 Replies View Related

Reverse A List

Sep 11, 2008

I've written a list and I want it the other way around. Top at the bottom, bottom at the top.

There's no sortable column in it. If it gets sorted it'll be out of order. I just want the same order but reverse the whole thing.

I've looked around a lot and failed to find it so far.

I've got to do is add a column at the side, number it in order then sort on that column, remove it later, right?

View 7 Replies View Related

Reverse MID - Search From Right

Apr 27, 2009

I need a formula that would search a string in a cell for spaces starting from the right. similar to MID but with the start and end pos reversed.

eg. col A below stores the text. col B to D is where i need to write the formulaes and drop down for the number of rows in A (in this case 3)

A
33 444 555
444 55 666
666 777 98 88

here is what the result in cols B C and D should be after the formula and drop down:

B
555
666
88..................

View 4 Replies View Related

Sumproduct In Reverse

Feb 18, 2010

I'm fairly proficient in Excel, but this one has me stumped (I have attached a spreadsheet to show what I'm talking about): For example, take these two rows of data:

55 , 105 , 101
4 , 3 , 1

The first row represents the production level in years 1, 2, and 3 of production of the life of a unit. The second row represents the number of units added in a particular year. So, if you are in the third year, the one unit added that year will produce 55 widgets, the three units added the previous year will each produce 105 widgets, and the four units added two years ago will each produce 101 widgets.
So: 1*55 + 3*105 + 4*101. The result for this formula would go underneath the "1" (ie its the total production in year 3, from all those units added in years 1-3).

Then when we roll through to the fourth year, where 2 units are added (and where we have the extra info that in the fourth year of production, a unit produces 50 widgets) it looks like this:

55 , 105 , 101, 50
4 , 3 , 1, 2

2*55 + 1*105 + 3*101 + 4*50.
The result for this formula would go underneath the "2" (ie its the total production in year 4, from all those units added in years 1-4). I need to produce a single formula which I can drag across the row. Without having a single formula, I need to copy the formula across to the cell to the right (with "$" in the right places), then add a new element to it. Seems very inefficient (take a look at my attachment)

View 3 Replies View Related

Reverse A Dictionary

Oct 31, 2009

i have to reverse a very big wordlist containing four coulmns. Column A words, Column B Transcription, Column C Grammar and Column D Meanings. Now i would like to make the meanigs (seperator is ";") to words and words to meaning in another new worksheet added by a macro. For example English-French would then become French-English wordlist.

If the original worksheets name is "x" then a new worksheet should be added with name "Re-x". This new sheet should then contain the new wordlist. For example:

View 12 Replies View Related

Reverse Two-way Lookup

Oct 7, 2008

I know how to do two-way lookup with the INDEX and MATCH functions (example, =INDEX(B2:H11,MATCH(A6,A2:A11,0),MATCH(E1,B1:H1,0)) to lookup a value in a table given a value in the row range and a value in the column range. I also know how to use the space intersector to do a two-way lookup (example, =A6:H6 E1:E11).

My question is, is it possible to do the reverse. Instead of finding the row and column positional and then returning the value at the intersection of the two, is it possible to have the value at the intersection and then find the two values in the row and column positions? So this would mean somehow returning two values in two cells.

View 9 Replies View Related

Reverse VLookup

Jan 7, 2009

I have a column, call it E.

I have table, call it Cities. It has a column of, um, cities, but entered in various ways; and a column of regions:

South Cumberland SW
So. Cumberland SW
So. Cumb. SW
Cumberland SW
Galveston S
Rangeley NE
Galv S

If any one of the entries in Column 1 is contained in column E, I want my formula to return the appropriate region code for each row of E.

Note that E8 may or may not be an exact match for the table entry - it may have additional text before and/or after the match text. It may also not appear in the table at all.

I could contruct a whole sequence of "Find" formulae, but I'm thinking there has to be a better way. Also, if I find I need to add another city permutation, it's way easier - & less error-prone - to just extend the table than to create a whole new "Find" calculation column, and then add that column into the calculation that extracts the region.

View 9 Replies View Related

Another Reverse Concatenation

May 22, 2009

I need to reverse concatenate a column of addresses, but text to columns won't work. I'd like to have a formula that takes into account each of the following scenarios (basically any standard address you can think of):

102 Bart St
104 Homer Simpson Ave
106 US HWY BSN 805 W
108 N Springfield Rd

What I need is to have the result in four columns. The first field would the house number. The second column would be the prefix (direction) of the street name, IF PRESENT (so the first three examples would have no value in the second column, but the fourth one would have an "N". The FOURTH column would have the suffix, whether that is a street type (like Rd or Ave), or a post-directional like in the third example ("W"). The THIRD column would have everything else (whatever is between the prefix and the suffix). In other words, using the examples above (* indicating a new column):

102**Bart*St
104**Homer Simpson*Ave
106**US HWY BSN 805*W
108*N*Springfield*Rd

View 9 Replies View Related

Reverse A String

Oct 8, 2009

I have a cell (a1) that contains "Kent; Andrew George" and I want a formula to change this to "Andrew George Kent" (b1)

View 9 Replies View Related

Reverse Ranking

Jul 28, 2006

I have a column of events,there are 7000 in my sheet.The scores for each contestant in the event are in col.2. In col 4 I have the rank printed for each contestant in each event in ascending order.I want to know how to print them in opposite order i.e highest in each event is ranked 1 etc into column 5.

View 9 Replies View Related

Reverse To Concatenate

May 15, 2007

a way in which to split the following line into say 5 separate pieces

George Julius Aaronson (81) 12th Feb 1945 D 9th Jan 1948.jpg
George Julius Aaronson
(81)
12th Feb 1945
D
9th Jan 1948

so that they are in 5 separate cells on a row. just to make things harder no name in the first colum has the same number of forenames or the same number of digits.there are possibly 600+ of these lines of which the next one is below
(Hanna Auerbach (73) 2nd Oct 1949 D 13th Feb 1955.jpg)

View 9 Replies View Related

Reverse Match

Jul 3, 2007

I am trying to find a way to use the match function to return the last matching value in an unsorted row. For example if I have (with each individual number representing a new column):

A: 4 5 4 3 6 7 5 4 5 0 2 6 3
B: 5

I would like to get a formula similar to this one =match(B1,A1:13,FALSE) to return 9 instead of 2 like it does now.

View 4 Replies View Related

Reverse Entries In A 3D Chart?

Jun 16, 2014

how to reverse the entries in a 3D chart. I want to have the blue ones appearing before the red ones visually, not the other way around?

View 1 Replies View Related

Reverse Order Of Cells?

May 12, 2014

Okay, say I have a spreadsheet like this:

Cell1 Cell2 Cell3
Cell4 Cell5 Cell6

How do I make it:

Cell6 Cell5 Cell4
Cell3 Cell2 Cell1

View 1 Replies View Related

Paste In A Reverse Order

Sep 5, 2008

I have a list like this

Dog
Elephant
Hippo
Cat
Morris Minor
Yak
Jaguar
+ about 300 others

I need to copy these and then paste then in another column in the reverse order. Is this possible ?

View 2 Replies View Related

Reverse Data In Columns

May 16, 2009

I have a list of search words in column A and in column B is the products that address that particular search word and the products are separated by a comma in column B. Each product is listed multiple times under various search words.

What I am hoping to do is reverse this so that the product is listed in column A and the related search words are listed under that product in column B.

View 5 Replies View Related

Export Access, Or Reverse.

Jan 19, 2009

Excel has a DATA - IMPORT EXTERNAL DATA - NEW DATABASE QUERY Function built into the toolbar. I need to lookup a table in access **TableTest**. Find the Record with a **Door_Number** Equal to an input I change everytime. Then I need to lookup a table in access **TableTest2**.

Find a Record with a **Door_Number** Equal to an input I change everytime And then paste the records in a line going DOWNWARDS not Right to Left. To summarise. Hit button, Type Key1/2 input, find record(s) paste into excel. Im afraid providing a sample is gonna be a little hard on this one, my files are HUGE

View 4 Replies View Related

Reverse Engineering Function

Jan 2, 2010

I am half way through my VBA for beginners book and did one Excel VBA tutorial lesson online. I am trying to learn by reverse engineering the 2 written functioning programs I have now. Today am posting the 2nd program

View 14 Replies View Related

Reverse Order Of Cell

Oct 23, 2012

Is it possible to have a formula for cells B1 to B10 in order to reverse the order of cell A1:A10 as you can see below.

A
B

1
BO
RENT

2
BOS
WALL

[Code] .........

View 8 Replies View Related

Can Reverse Form Control

Dec 1, 2012

I have a control sheet that I am building and my sliderbar is making my data just disapear and not replacing it with any new data. Can this be fixed if I am able to reverse the sliderbar

View 2 Replies View Related

Macro To Reverse Number

Aug 26, 2013

I need a macro to reverse a number in the cell, suppose a user inputs the number the 48596, after running the macro it should show the output in other cell as 69584.

View 6 Replies View Related

Reverse Date (month & Day)

Mar 24, 2008

I have the following date problem, for example I need to reverse the following date:

8/02/2003 (which is recognised as a date) to:

2/08/2003 (the real date).

Is there an easy way to do this using a formula?

View 9 Replies View Related

CAPS/non Cap Reverse Order

Oct 10, 2008

I have a column of cells which looks like this:
"JUMPING LAZY brown fox"

I need to put the non capitals in the front as so:
"brown fox JUMPING LAZY"

View 9 Replies View Related

Reverse Index/Match

Dec 4, 2009

I've got a chess board in B2:I9, and would like a function that returns the location of a particular piece.

Say I have Q1 in cell B9, I'd like to return A-1

B1:I1 = A ---> H
A2:A9 = 8 ---> 1

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved