Calculating current investment value, current mortgage balance

[Scott Meyers]

I'm trying to calculate the estimated current net value of a real estate
investment based on the simple assumption that it goes up in value at a
constant rate. I need to know how to make two calculations:

- The current value of the real estate given its initial value, how long
since I bought it, and the assumed appreciation rate.

- The remaining balance on the mortgage, given its initial amount and rate,
the number of payments, the amount of each payment, and how long I've had
it.

I'm sure both these calculations are simple, but though I've stared at the
list of Excel financial functions until I'm blue in the face, I can't figure
out which functions to use to make these calculations. FV or PV seem like
they're sort of in the ballpark, but I don't really know.

Help?

Thanks,

Scott

 

[Norman Harker]

Hi Scott!

Current value can be calculated using:

=InitialValue*(1+g)^n

Or you can use the FV function with the rate of interest being your
growth rate.

Remaining balance on a mortgage can be found using the Analysis
ToolPak CUMPRINC function:

Example:
10 year loan of 100000 @ 6% Nominal compounded monthly (APR12) after 2
years of monthly in arrears repayments.

Balance Outstanding:
=100000+CUMPRINC(6%/12,120,100000,1,24,0)
Returns: 84481.2932583179