Home

Using Excel to compare FV of loan payment

%3CLINGO-SUB%20id%3D%22lingo-sub-417284%22%20slang%3D%22en-US%22%3EUsing%20Excel%20to%20compare%20FV%20of%20loan%20payment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-417284%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20use%20excel%20to%20show%20how%20a%20future%20loan%20payment%20(fixed%20APR%2Ffixed%20payment%2Ffixed%20%23%20of%20payments)%20decreases%20in%20value%20over%20time%20based%20on%20present%20value%20theory.%26nbsp%3B%20For%20example%2C%20if%20I'm%20interested%20in%20investing%20in%20a%20rental%20property%20and%20take%20a%2030%20year%20fixed%20mortgage%2C%20I%20would%20like%20to%20see%20what%20my%20mortgage%20payment%20is%20valued%20in%20the%20future%20but%20in%20today's%20currency.%26nbsp%3B%20I%20will%20use%20simple%20inflation%20rates%20as%20the%20discount.%26nbsp%3B%20In%20other%20words%2C%20if%20my%20monthly%20payment%20is%20%241%2C000%20-%20what%20will%20%241%2C000%20actually%20look%20like%2010%2C%2015%20or%2020%20years%20from%20now%20(obviously%20the%20payment%20will%20be%20%241%2C000%2C%20but%20what%20is%20that%20actually%20worth%20in%20today's%20money).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-417284%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efuture%20value%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
brianbogumil
Occasional Visitor

I would like to use excel to show how a future loan payment (fixed APR/fixed payment/fixed # of payments) decreases in value over time based on present value theory.  For example, if I'm interested in investing in a rental property and take a 30 year fixed mortgage, I would like to see what my mortgage payment is valued in the future but in today's currency.  I will use simple inflation rates as the discount.  In other words, if my monthly payment is $1,000 - what will $1,000 actually look like 10, 15 or 20 years from now (obviously the payment will be $1,000, but what is that actually worth in today's money).

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies