Compradores, intermediarios y prestamistas utilizan este libro para valorar con rapidez y de forma coherente una empresa objetivo. Su finalidad es la comparación: se rellenan los mismos campos para cada empresa que se examina, y la hoja convierte las cifras dispersas en un perfil comparable. El trabajo lo hacen dos paneles. El panel «Five-Year Review» sigue el comportamiento de los ingresos y los costes a lo largo de cinco ejercicios consecutivos, numerando automáticamente los años a partir de un único valor inicial que se escribe una sola vez. El beneficio bruto, la renta imponible y el flujo de caja neto se calculan en lugar de teclearse, lo que elimina los errores aritméticos que se cuelan en las comparaciones hechas a mano. El panel «Net Worth» funciona como un balance compacto: ocho líneas de activo corriente se subtotalizan automáticamente, tres líneas de activo fijo se registran a coste, valor de mercado y valor contable, y ocho líneas de pasivo se suman en un total. El activo total combina el subtotal del activo corriente con el valor contable del activo fijo, y el patrimonio neto resulta de restar el pasivo al activo. Un bloque de notas de texto libre se sitúa junto a los datos de contacto para comentarios sobre la operación, afirmaciones del vendedor o cuestiones pendientes. El diseño coloca una cabecera sólida en la parte superior de la página, con un subtítulo debajo. Los encabezados y las barras de sección comparten un estilo coherente, mientras que las celdas de entrada se mantienen sencillas para que sea evidente dónde escribir. La hoja se imprime en una página horizontal y está íntegramente traducida a inglés empresarial.
Azul agua, Azul cielo, Azul real, Azul pervinca, Violeta, Amatista, Magenta, Carmesí, Turquesa, Verde azulado, Verde azulado oscuro, Cian pizarra, Grafito, Carbón
light theme, Excel template, xlsx, Periwinkle, Violet, Amethyst, Magenta, Crimson, Turquoise, Teal, dark background, dark theme, Graphite, Charcoal, aqua blue, aqua, business English, sky blue, royal blue, corporate blue, purple, indigo, pink, fuchsia, red, burgundy, blue green, deep teal, dark mode, presentation ready, cyan, grey, print friendly, dark grey, slate cyan, accounting number format, azure, high contrast, statement of financial position, current assets, fixed assets, cash, accounts receivable, inventory, prepaid expenses, liabilities, accounts payable, total assets, formula driven totals, hot pink, cyan green, restrained palette, projector friendly, screen reading, monochrome, black and white, understated design, near black, screen optimised, lavender, formula driven, business acquisition worksheet, header banner, acquisition analysis, company valuation, target screening, five year trading review, balance sheet snapshot, net worth, gross sales, other income, total expenses, taxable income, net cash flow, add backs, interest, depreciation, current assets subtotal, fixed assets cost market book, total liabilities, notes payable owner, accrued taxes, deal notes, broker worksheet, lender pack, buy side, small business acquisition, side by side comparison, automatic year numbering, live formulas, landscape print, one page layout, white input fields, ready to use template, due diligence, business valuation, buying a business, five year review, net worth statement, gross profit, cost of sales, depreciation add-back, officer compensation, cost market book, notes payable, accrued payroll, seller discretionary earnings, acquisition checklist, deal analysis, M&A worksheet, small business purchase, broker template, financial snapshot, printable one page, automatic formulas, banded rows, editable spreadsheet, professional template, banner header, corporate finance, acquisition screening, first pass review, target company analysis, five year trading history, balance sheet panel, owner notes, advances, equipment, real estate, cost market book valuation, reusable template, auto incrementing years, live recalculation, single page landscape, wide typeface, professional layout, soft violet, cash generation analysis, balance sheet review, acquisition due diligence, five year panel, depreciation add back, interest add back, deal notes area, qualitative observations, rolling year headers, single entry start year, thin borders, light banding, screen friendly, calm palette, printable landscape, business broker file, buyer worksheet, company purchase, valuation template, editable xlsx, purple blue, no vertical gridlines, seller analysis, deal file, five year trading results, auditable add backs, statement of what the business owns and owes, spare rows, target specific items, typographic hierarchy, lilac banding, close reading document, due diligence worksheet, acquisition template, professional finance, deep violet, saturated masthead, designed look, advisory firm, deal document, acquisition model, review year, five column headings, normalisation, owner managed business pricing, cash to inventory, three valuation bases, payables, accruals, net worth residual, open rows, hatched unused cells, boxed cells, tabular finish, violet wash banding, landscape one page, bold accent, pitch pack, five trading years, receivables, blank rows for custom items, formula protected totals, horizontal rules, row banding, striking design, rose accent, minimal rules, acquisition pricing, earning power, asset backing, add back schedule, owner notes receivable, cost basis, market value, book value, short term notes, long term notes, net worth calculation, business broker, seller financials, buyer analysis, valuation input sheet, hairline borders, subtle banding, accounting format, professional spreadsheet, analyst working file, small business valuation, mid market, trading history, financial position, self indexing years, gross profit calculation, owner operated earnings, internal consistency, pale banding, accent section bars, buyer checklist, ledger style, boxed borders, sustainable cash flow, net asset backing, acquisition decision, income summary, transparent add backs, notes receivable owner, contact strip, notes block, dense numeric grid, compact typeface, one page landscape, due diligence template, presentation slide, five year trading panel, net worth panel, no hardcoded values, saturated header band, near white text, lighter input cells, modern look, high ink usage if printed, buy a business, landscape layout, serif title, classical treatment, reference edition, single page instrument, what a business earns, what a business is worth, purchase negotiation, seven inputs per year, visible add backs, eight liability lines, report date field, timestamp snapshot, notes panel, formula linked year headings, rolls forward, accounting notation, valuation worksheet, greyscale, photocopy safe, minimalist design, five year financial review, gross profit formula, adviser template, pdf report, business purchase, neutral palette, neutral accents, header strip, five year block, twenty six formulas, instant recalculation, silver grey bars, pale input cells, dark deck, high toner use, due diligence file