Report this item to Etsy

Apartment Building Reserve Planner Excel | Planned Work, Contributions and Reserve Balance | Undated [DE]

Low in stock, only 1 left

Price:$29.39

Loading

You can only make an offer when buying a single item

Highlights

Product language: German.

Plan reserves for your apartment building using your own property, cost and contribution assumptions. Record up to 50 building components with condition, last renewal and estimated cost, plus up to 50 planned measures with target year and cost. Cumulative measure costs include all prepared rows.

Your floor area and chosen annual amount per square metre determine the target contribution. Compare it with your deposits. Across 30 prepared annual rows, the reserve balance carries forward opening funds, year-matched deposits and manually entered spending. The overview shows the last recorded closing balance and checks your minimum reserve and contribution shortfalls across all 30 rows.

Choose between three colour themes directly within each file. Navigation, inputs, results and both charts change together; your selection is retained when saved. Designated inputs remain editable while formulas and unused margins are protected. No macros, Office Scripts or additional account required.

The charts display the first three annual rows: target and actual contributions as bars, and the closing balance as a line. Further years remain available in the tables. Planned measures are not automatically posted as spending. Deposits are matched by year; each year must appear only once in the deposit table. From the second row, the opening balance follows the immediately preceding closing balance. Enter the annual sequence in ascending order without blank rows in between.

You receive a completed BEISPIEL workbook and a genuinely blank LEER file, each with eleven worksheets, plus a four-page PDF guide, the original PDF licence, LICENSE.txt and original business card. The blank inputs contain no sample components, building values, planned measures or payment amounts. The explanatory example sheet, euro currency note and theme selector remain included.

Use is undated. Historical sample years and source notes are retained. The workbook does not calculate remaining useful life, renewal years, the Peters formula, German II. BV values or interest. It supports your own planning and does not replace a technical condition assessment or individual advice.

Product content is in German. XLSX files for Microsoft Excel and LibreOffice Calc on a computer; a PDF reader is also required. Complete functionality in Google Sheets or other spreadsheet programs has not been verified. Digital download.

Private and own-business use are permitted. Resale, redistribution, publication and use for AI training are excluded. Suggestions and ideas are welcome. Support is available after purchase. Contact: hallo [!at] schattenspiel.eu.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

Be the first to review this item

No reviews yet. See what customers say about other items from this shop.

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 11, 2026