consistency

LDM Tutorial

Basics

Publisher

Purchase

Model Consistency

The model consistency section of the model is useful because it alerts you to inconsistencies as well as entry and non-entry errors. It also prompts and directs you as to how to correct the inconsistencies. See lines 57 through 71 below. The answers to all these questions must be 'Yes' or 'N/A' or you have made one or more entry errors.

The model consistency section here indicates that there are no entry errors, no non-entry errors, and no inconsistencies. See lines 57 through 71 below.

But you need to see how the model works when inadvertent entries are made or required entries are ommitted. We have made a few deliberate entry errors in the sample project so you can observe how this important portion of the model works. Click here to see the prompt column and model consistency section at work!

Use Browser's Back Button Or Scroll Up To Return to Text


Line #	Total Acres, Acres/Phase	Input Column	Prompt Column
	(Entries Not Mandatory for Profit Calculation)

47	Acres in Entire Project	54	< Enter Total Acres

48	If No Option Agreements, Total Acres	54	< Total Acres	Clear Acres Button
49	Acres in Phase 1		< Make No Entry
50	Acres in Ph 1 & Ph 2 Combined		< Make No Entry
51	Acres in Phase 2		< Make No Entry
52	Acres in Ph 2 & Ph 3 Combined		< Make No Entry
53	Acres in Phase 3		< Make No Entry
54	Acres in Entire Project	54	< OK

55	Beg Balance of A&D Loan	$754,925
56	Cash To Project By Developer/Investor	$245,075			Avg Annual ROE	63.54%


	Model Consistency?

57	Is Model Free from 'Make No Entry' Errors?	Yes	Model Consistency Results
58	Profit & Cash Flow Indicators' Consistent?	Yes	Must be 'Yes' or 'N/A'.
59	Total Lots & Total Acres Consistent?	Yes	If this is not the case,
60	If Applicable, is the Amt of Seller Financing OK?	Yes	observe the prompts.
61	If Applicable, is the Term of Seller Financing OK?	Yes
62	Are Entries Made to All Required Fields?	Yes
63	Are Absorption and Project Duration in Line?	Yes
64	Does Absorption Meet Model Parameters?	Yes
65	Is the Project Completed Within 5 Years?	Yes
66	Are Loans Paid Off By End of Project?	Yes
67	Are Interest Calculations Consistent?	Yes
68	Is a Target Profit Entered (Non-Mandatory Entry)?	Yes
69	Are Total Acres Consistent (Non-Mandatory Section)?	Yes
70	Are Total Acres Entered (Non-Mandatory)?	Yes
71	Is Sum of Total Acres Consistent (Non-Mandatory)?	Yes	To Top

If you wish to ask us a question about the model, 'Contact Us' and we will get back to you as soon as possible.

Home

Land Development Model, LLC
302 West Lafayette Road
Medina, OH 44256
330.441.1690