Valuation Spreadsheet
Yes, all of that is possible with google sheets... In general spreadsheets can do all of what you ask. Have a try of some online training like these to get started.
Whether you're self-employed or not, knowing exactly how much tax you will pay is not always an easy task.  Various actions you can take (e.g., charitable donations, IRA contributions, selling stocks) may increase or reduce your tax liability. One tool I've found useful for estimating federal taxes is the Excel 1040 spreadsheet.  This is a spreadsheet version of the income tax return form.  It is not official and is not created by the IRS, but is maintained as a labor of love by a private individual.  In practice, however, it is pretty much an accurate implementation of the tax calculation algorithms encoded in the tax forms and instructions. The nice thing about it is that it's a spreadsheet.  You can plug numbers into various slots in the spreadsheet and see how they affect your federal tax liability.  (You may also owe state taxes depending on what state you live in.)  Of course, the estimates you get by doing this are only (at most) as accurate as your estimates of the various numbers you plug in.  Still, I think it's a free and useful way to get a ballpark estimate of your tax liability based on numbers that you can more easily estimate (e.g., how much money you expect to earn). No. The long-term valuation of currencies has to do with Purchasing Power Parity.  The long-term valuation of stocks has to do with revenues, expenses, market sizes, growth rates, and interest rates. In the short term, currency and stock prices change for many reasons, including interest rate changes, demand for goods and services, asset price changes, political fears, and momentum investing.  In any given time window, a currency or stock might be: The Relative Strength Index tries to say whether a currency or stock has recently been rising or falling; it does not inherently say anything about whether the current value is high or low. The Finance functions in spreadsheet software will calculate this for you.  The basic functions are for Rate, Payment, PV (present value), FV (Future value), and NPER, the number of periods.  The single calculation faces a couple issues, dealing with inflation, and with a changing deposit. If you plan to save for 30 years, and today are saving $500/mo, for example, in ten years I hope the deposits have risen as well. I suggest you use a spreadsheet, a full sheet, to let you adjust for this.  Last, there's a strange effect that happens. Precision without accuracy. See the results for 30-40 years of compounding today's deposit given a return of 6%, 7%, up to 10% or so. Your forecast will be as weak as the variable with the greatest range. And there's more than one, return, inflation, percent you'll increase deposits, all unknown, and really unknowable.  The best advice I can offer is to save till it hurts, plan for the return to be at the lower end of the range, and every so often, re-evaluate where you stand. Better to turn 40, and see you are on track to retire early, than to plan on too high a return, and at 60 realize you missed it, badly.  As far as the spreadsheet goes, this is for the Google Sheets -  Type this into a cell =nper(0.01,-100,0,1000,0) It represents 1% interest per month, a payment (deposit) of $100, a starting value of $0, a goal of $1000, and interest added at month end. For whatever reason, a starting balance must be entered as a negative number, for example - =nper(0.01,-100,-500,1000,0) Will return 4.675, the number of months to get you from $500 to $1000 with a $100/mo deposit and 1%/mo return. Someone smarter than I (Chris Degnen comes to mind) can explain why the starting balance needs to be entered this way. But it does show the correct result. As confirmed by my TI BA-35 financial calculator, which doesn't need $500 to be negative. Welcome to Kirk Kleckner, Our company provides the best valuation services in the United States, Such as automotive valuation, business valuation, and dealership valuation.  If you required the valuation services, then you can come to our office. And We will do our best business valuation services in our own way. Automotive dealer valuation businesses require understanding and analysis of a variety of complex factors including detailed. And technical knowledge of dealership valuation firm and in-depth industry knowledge. "Thanks for the response.   I am using WRDS database and we are currently filtering through various variables like operating income, free cash flow etc.  Main issue right now is that the database seems to only go up to 2015...is there a similar database that has 2016 info?  filtering out the ""recent equity issuance or M&amp;A activity exceeding 10% of total assets"" is another story, namely, how can I identify M&amp;A activity? I suppose we can filter it with algorithm stating if company's equity suddenly jumps 10% or more, it get's flagged" About 10 years ago, I used to use MetaStock Trader which was a very sound tool, with a large number of indicators, but it has been a number of years since I have used it, so my comments on it will be out of date. At the time it relied upon me purchasing trading data myself, which is why I switched to Incredible Charts. I currently use Incredible Charts which I have done for a number of years, initially on the free adware service, now on the $10/year for EOD data access. There are quicker levels of data access, which might suit you, but I can't comment on these. It is web-based which is key for me. The data quality is very good and the number of inbuilt indicators is excellent. You can build search routines on the basis of specific indicators which is very effective. I'm looking at VectorVest, as a replacement for (or in addition to) Incredible Charts, as it has very powerful backtesting routines and the ability to run test portfolios with specific buy/sell criteria that can simulate and backtest a number of trading scenarios at the same time. The advantage of all of these is they are not tied to a particular broker. Not sure you are going to find anything like this in Excel - with the automatic lookup in specific. Microsoft has a template available; but it looks to be a pretty busy page. Why not look at other software?  If you have a PC, Quicken and Microsoft Money are of course the big guns.  You don't mention why you switched away from MS Money... There are many other packages as well.  The one that I use (but have no other financial interest in) is Moneydance as it was the best on Mac at the time I was looking.  It also runs on Windows and Linux. depends entirely on the scope and where your chokepoints are.   if its a question of ginormeous amounts of data being stored in your spreadsheet and then extracted/joined with a mess of index match functions, that can quickly run up in size, and can be deftly replaced with a powerquery setup.   If it's a computation that requires a few iterative steps or complex nested lookups, but with simple inputs, then a few simply scripted UDFs can lower the complexity (and workload and size) of the workbook.   OP also mentions that the workbook is used for the display. If there is a lot of repeated deletion and adding of formats, sometimes workbook size can be seriously affected by these things cluttering up the sheet, and it can be useful to just clear those outs.   I'd say it makes sense to move away from workbooks and into something more technical if you the organizational support to do so. If one person sits and codes models in python but none of his colleagues can work on it or fix it, and it's not documented correctly, and there's no support structure, then I'd be cautious of transferring something business critical to that structure, rather than optimizing the solution that people are familiar with and can modify themselves.   But if it's a tech-savvy organization that recruits accordingly and has the technical support structures to implement changes and modifications as required by the business, I don't see any problem in using other tools.