JRKLEIN
asked on
Excel Financial Scenario
Is there a way of having excel compare 2 financial scenarios. Compound interest ie Future value of "x" dollars after say 10 years. Versus a receipt of payment of say "y" dollars every month for 10 years with interest on this increasing balance. Which investment would be better and where the break even would be.
Jerome Klein
Jerome Klein
ASKER
It has the first part of what I need.
2nd part is i receive a payment of 500 dollars every month and invest it at say 3% after say 10 years what does this amount to??
A tenant wants me to finance his $10,000 repairs by increasing his rent say $500 a month.
I wanted to see where and when the breakeven point would be by either leaving the money in my bank versus giving it to him and getting more rent back per month.
Jerome
2nd part is i receive a payment of 500 dollars every month and invest it at say 3% after say 10 years what does this amount to??
A tenant wants me to finance his $10,000 repairs by increasing his rent say $500 a month.
I wanted to see where and when the breakeven point would be by either leaving the money in my bank versus giving it to him and getting more rent back per month.
Jerome
That makes things a little more complicated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My email address is cilc@prodigy.net
Thanks
Jerome
Thanks
Jerome
I think you should look at the FV function in excel.
Sorry about that I did not see bkpchs237's answer until it was too late.
ASKER
Dear Sir:
This is wonderful and complex. I guess after seeing the chart the question
I should really be asking is what increase in rent does the Tenant have to pay for me to break even say after 5 years or after 10 years if I give him say
10,000 for upgrades or more if he asks for more.
Can you set up a spread sheet where i can plug in the variables and get the result.
Jerome
This is wonderful and complex. I guess after seeing the chart the question
I should really be asking is what increase in rent does the Tenant have to pay for me to break even say after 5 years or after 10 years if I give him say
10,000 for upgrades or more if he asks for more.
Can you set up a spread sheet where i can plug in the variables and get the result.
Jerome
http://www.webizz.com.au/help/Compound.xls
Is this what you need?