Human Resources (HR)

Attrition Tracker: For Human Resource Planning

This excel tool was designed to better analyze expected headcounts over time. It is best used in tandem with a financial model that has headcount projections.

Price: $45.00

by Smarthelping

Good Product - Some Areas for Improvement

By TomH on Dec 24, 2019

I appreciated the follow up email from eFinancial which provided links to how to use the financial model. One helpful link was to "Financial Modeling Excel - Best Practices." I'd like to use those best practices to frame this review.The second worksheet in the model contains definitions for the acronyms it uses - an excellent idea. Unfortunately, two of the definitions were reversed (EBITDA and EBIT) but that was easily corrected.The logic of the model is fairly straightforward if you have some background in accounting. If not, I recommend that the user review the basics of accounting to understand the various financial schedules that the model produces.The model is also fairly simple, with many of the details of revenue and expense handled with summary inputs. If you have looked at the general ledger of a private school, you will notice that there are many more entries than are contained in this model, so the user needs to be prepared to do some pre-work to develop the basis for the many assumptions that the model uses for revenues, costs, capex, etc.Because the worksheets are laid out in the same way (that is, years are in horizontal rows, details for each of the financial schedules are grouped in order vertically. The program is also careful to note the units for all calculated values at the start of the row.From this point onward, the private school financial model begins to deviate from best practices. The assumptions are spread out over more than one worksheet, and a few assumptions are hard-coded into calculation cells. This makes tracing the calculation logic unnecessarily difficult. I believe the program could be improved by moving the assumptions out of the executive summary and combining them with the "school assumptions" worksheet or into a separate worksheet.Row F420 in School Assumptions (pre-operating expenses) appears to contain an incorrect formula. The next version should correct that. Also, "If" statements (or some other error trapping) should be added to cells that have divisors in case the user has a zero entry for a cell (e.g. having no students in the kindergarten results in an error in cell D42 of School Assumptions).Finally, there are a few places where the terms are not the same in the different worksheets even though they refer to the same value. For example, COGS is used in the executive summary, but links to Direct Cost in the School Financials worksheet.Overall, a fine product and I look forward to adapting it for my needs.

Really good for startup company

By Satish on Aug 19, 2019

Really user friendly and wanted to buy Normal version aswell and wrote email also

Finance Manager

By Najam on Nov 05, 2020

Excellent Template. It covers all the aspects of the company on which the valuation is carried out for. I really appreciate the efforts spent in making this template. It is easy to understand and easy to comprehend the results based on the information that is used in the DCF calculation.I would appreciate It if another option was also included in addition to Multiples of EBITDA, the Growth to perpetuity percentage for the terminal valuation.

Pretty Simple Review

By Avadhut Avadhut on Jan 13, 2018

Let me tell you this, you have done a great job in explaining the overall model for the Hair/Salon store. The article is written in a super easy language and even a layman can understand it very well.4 OUT OF 5 STARS from my side to this amazing review. Keep up the good work.

Product Feedback

By Muhammad Imran Muhammad Imran on Jul 04, 2019

The model itself is well made but it is unnecessarily complex and makes assumptions that are unrealistic and difficult to understand. I cannot get my head around the fact that everything is linked to the area. This makes very little sense. It could have been much easier to model based on assumptions independent from the area without losing the usefulness or aesthetics of the model.

Financial modeling spreadsheets and templates in Excel & Google Sheets

Human Resources (HR)

Attrition Tracker: For Human Resource Planning

Recurring To-Do List Manager – Google Sheets

Google Sheet Project Plan Template

Make Scheduling Easy – Excel Template

Hiring Plan – For SaaS + More: Sales Team, CS Reps, R&D and More

Salesmen Bonus Calculator

Vendor Contact Form

Reply

Attachments