| User | Post |
|
11:23 pm
July 4, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
As I mentioned, it would have to be up to the user.
The purpose of the spreadsheet is to limit the number of inputs and to keep it as simple as possible so that the learning curve remains very low.
If the spreadsheets were all locked up, I would strongly consider it but in this case, everyone is free to customize as they wish.
|
|
|
12:04 am
July 1, 2010
|
mals
| | |
| Member | posts 14 |
|
|
Hi Jae, given that the growth rate and the current year FCF assumption are the most important assumptions in DCF valuation, allowing user input in that portion of the sheet is perhaps useful for all your customers. What do you think?
|
|
|
9:44 pm
June 29, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
I decided not to add this to the spreadsheets.
Advanced users will want more control but the majority of users like to keep it simple.
The edit isn't difficult so I'll leave it up to the individual to customize this particular feature.
|
|
|
1:17 pm
June 28, 2010
|
DrSues02
| | |
| Member | posts 45 |
|
|
I would second the suggestion (as long as I'm understanding it correctly). Would be nice to select a different growth rate for years 1-3, 3-5, 5-10, etc. rather than a flat growth rate for all ten years.
|
|
|
8:46 pm
June 26, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
I'm working on a new version that lets you choose to use either the FCF or owner earnings numbers in the calculation.
The growth rate however is a different story. Thanks for your input by the way. Always good to know how people use it.
Let me think about the implementation because I want to keep it as simple as possible. Keeping the number of inputs low and providing ease of usability and low learning curve is the highest priority when I go about making spreadsheets.
|
|
|
7:27 pm
June 25, 2010
|
mals
| | |
| Member | posts 14 |
|
|
Hi Jae,
Lately I have been tinkering with your 10-year-valuation sheet, trying to really use them for valuation.
Great spreadsheets you have created. Thanks!
I have one big suggestion – can you create yellow user input boxes for Owner Earnings growth assumptions? Right now those future value figures are figures that are compounded at cell C7 rate. And then in later years, it applies 90% of cell C7.
Perhaps you should create 10 cells for growth assumptions for Yr 1-10. And instead of compounded growth formula, you can create annual growth formula.
And finally, if you do create the 10 growth assumptions (automatically based on C7), you can create 10 yellow boxes as well for user override option.
I think I will edit the sheet to enable the suggestion above. Will share that version here.
Thanks.
|
|
Home
