Chart of Accounts

Chart of Accounts is a list of account names a company uses in its general ledger

by Itillect

Professional Financial Model in Excel

Excel professional financial model to make financial projections for your business.

Starting at: $0.00

by Jair Almeida

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.

Excellent modelling

By MH SA on Aug 27, 2019

I highly recommend the custom modelling service. Results are delivered in a timely, efficient manner and it is clear that the great quality of work and ability to synthesize a customer's complex requirements across different industries and sectors is a reflection of the excellent caliber of banking expertise.

Nice

By Mirketa Mirketa on Nov 12, 2019

Thanks for sharing

Financial Controller

By Chalermsak Ninchauwong on Jul 04, 2019

Great template.

Manager

By Henry Chou on May 05, 2019

How to calculate the Residual Land Value

Financial modeling spreadsheets and templates in Excel & Google Sheets

Chart of Accounts

Professional Financial Model in Excel

Management Accounting and Corporate Budget Report

Recurring To-Do List Manager – Google Sheets

Ratio-Based SaaS Model – Smarter Scaling Logic

Make Scheduling Easy – Excel Template

SaaS & E-Commerce Financial Models Bundle

SaaS Financial Model (5 – Year) Up to 4 Pricing Tiers

Vendor Contact Form

Reply

Attachments