Sample Reports & Screen Shots
REPORTS (PDF)All reports have buttons which take you to detailed explanations of the report (these buttons can't be seen on printed reports) Cover Sheetyou can also create your own cover sheet Table of Contentslikewise, you can create your own if desired Assumptions (Input Data)the inputs are the yellow boxes Executive Summaryexplained in detail in documentation Income StatementA traditional format with separate tax page Balance Sheetone cost based, a second market based Sources and Uses of Cashone page in dollars, one page in %'s Statement of Cash Flowspage 1 from operations, page 2 from sale Net Worth Analysisaccounting analysis and economic analysis Valuation Analysismultiple methods of valuation Ratio Analysisincludes highlight data outlier feature Tax Reportfrom operations and from sale Asset Detail Reporthelpful for detailed analyses Loan Detail Reporthelpful for detailed analyses |
Operation & Navigation SCREEN SHOTS (GIF)Control Center This is the Main Menu from which you can operate the model. There are, however, alternative ways of performing various tasks, such as from the input sheet, from the side command bar, and with keyboard shortcuts. Report MenuAgain, there are many ways of printing reports. All explained in documentation. Input Data ScreenThe Input Data is shown in the PDF report, but the reports don't show the non-printing buttons which I provide throughout to help you with the analysis. Documentation IncludedTop page of the Documentation that is provided within the model. |
OTHER INCLUDED PROGRAMS (PDF)Developer Assistant Useful for large construction projects. It develops a Building Component Construction Cost Estimate (calculated by "Comparative Units Method"). It then uses one of five supplied or a user defined "S-Curve" to spread costs over the construction period (up to 25 months). It also provides a 25 consecutive task table from which to apply "CPM" (Critical Path Method) and "PERT" statistics for ascertaining confidence levels for completing the project by a specific date. Task Manager & Scheduler (GANTT Charts)Second part of "Developer Assistant". Very useful for project management of any construction or renovation project (includes a component designed for flippers). Note that option buttons such as sorting by date and delaying project do not show up on the PDF. Lease vs Buy to OccupyShould you lease, or should you buy Lease Roll-UpAllows grouping of like leases. Can expand to accommodate. The Total Group at top stays on screen while the detail scrolls up (can't be seen in PDF). Also, you can't see action buttons on PDF. Loan CalculatorUseful for looking at ad hoc loan analyses External Factor Analysisa simple but useful check on non-financial parameters Comparable Property Analysisa simple but useful assumption check which compares comparable properties Marketing Flyera single sheet flyer for handing out to prospective buyer Sensitivity Analysispessimistic, most likely, optimistic Advanced Sensitivity Analysisextremely powerful means of incrementing input variables for effect |
[ Return to Top ]