Skip to main content
Message Font: Serif | Sans-Serif
 
No. of Recommendations: 1
Jim,

What data to enter...

Certainly the 5 minute test is DIY. Croesus test - exactly what you said.

PIV-EV test nothing required but the bright yellow cells are override cells.

Footnote section really does affect the Enterprising income part of the test. You need to input advertising, for sure. The cost of equity and debt rates are user entered. The R&D and tax rate are pulled from the net but may need to be corrected. All the lease information is user entered.

The intermediate yellow columns are user override columns. Use those to override the internet values (all those values should be checked, for sure). When you save it will keep those overrides you make and move the rest of the data to those columns to keep it static.

There are a couple marked override rows in the Enterprising sheet.

Pretty much all tabs that are yellow are override or user entered cells. Play with it a little bit - the overrides should be obvious once you try them.

Any more questions just ask - I'll check here off and on.

Print the post  

Announcements

What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.