mdg1
asked on
Creating a spreadsheet that makes calculations based the timing of certain variables
I'll try to explain as simply as possible. See the attached spreadsheet. I have variables written on tab one that i refer to in tab two. simply say someone is investing $1k every month for 120 months and the variables indicate what and when the return on the investment will be paid back. You'll see that i manually calculated the first investment over the 10 year payback period but I need something written so that if the variables change - namely the timing of payback changes than i don't have to go back and manually make changes to the model.
Model.xlsx
Model.xlsx
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER