\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{aengland2490} \pdfinfo{ /Title (accounting-for-homebuilders.pdf) /Creator (Cheatography) /Author (aengland2490) /Subject (Accounting for Homebuilders Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{53C95B} \definecolor{LightBackground}{HTML}{F4FBF4} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Accounting for Homebuilders Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{aengland2490} via \textcolor{DarkBackground}{\uline{cheatography.com/38639/cs/12035/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}aengland2490 \\ \uline{cheatography.com/aengland2490} \\ \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Published 9th June, 2017.\\ Updated 9th June, 2017.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{3} \begin{tabularx}{5.377cm}{x{1.34379 cm} x{3.63321 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{{\bf{Key Definitions}}}} \tn % Row 0 \SetRowColor{LightBackground} Start & Event at which time construction begins on a fully developed lot \tn % Row Count 3 (+ 3) % Row 1 \SetRowColor{white} Sale & Event in which home or lot goes "under contract" with a buyer, meaning the buyer has made a commitment to purchase the asset \tn % Row Count 8 (+ 5) % Row 2 \SetRowColor{LightBackground} Closing & Event preceding sale where title of the asset changes from the seller to buyer and consideration (cash) is received by the seller. This is the point that revenue is recognized. \tn % Row Count 15 (+ 7) % Row 3 \SetRowColor{white} HUD & Short for Dept of Housing and Urban Development Settlement Statement 1, this form is generated for every closing (lots and homes) \tn % Row Count 20 (+ 5) % Row 4 \SetRowColor{LightBackground} IRR & Short for internal rate of return, this metric is commonly seen in land deals to guarantee the seller a specific return based on cash flows \tn % Row Count 25 (+ 5) % Row 5 \SetRowColor{white} Escalator & Gradual increases in lot prices by a set percentage over time. Commonly seen in land deals and used by the seller to incentivize the buyer to purchase lots more quickly \tn % Row Count 31 (+ 6) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{x{1.34379 cm} x{3.63321 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{{\bf{Key Definitions}} (cont)}} \tn % Row 6 \SetRowColor{LightBackground} Draw & Request for funding/ cash based on work performed. Seen in construction lending and mechanics lien jobs \tn % Row Count 4 (+ 4) % Row 7 \SetRowColor{white} EM & Earnest money or up-front deposits made by a buyer prior to a purchase which are typically credited at closing \tn % Row Count 8 (+ 4) % Row 8 \SetRowColor{LightBackground} Option Contract & Contract guaranteeing a buyer's right to purchase property. Homebuilders commonly supplement their lot inventory by optioning lots from third-party developers \tn % Row Count 14 (+ 6) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Average Costs of a Home}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{p{5.377cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/aengland2490_1496957696_Homebuidling Costs.PNG}}} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Housing Trends}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{p{5.377cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/aengland2490_1497025976_Home Trends.PNG}}} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.69218 cm} x{3.28482 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Construction Cycle}} \tn % Row 0 \SetRowColor{LightBackground} Acquisition & Raw undeveloped land is purchased by a developer. \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} Development & Process of clearing and grading the land so that construction can begin. Other tasks included in this stage include zoning changes, development of site plans, environmental impact studies, and construction of common area features (roads, green spaces, border walls, etc.). Time to complete this stage varies depending on the size of the property, but generally takes longer than one year. Large parcels of land are developed in phases. \tn % Row Count 19 (+ 17) % Row 2 \SetRowColor{LightBackground} \seqsplit{Recordation/Plat} & Site plan for community or specific phase is filed with the city \tn % Row Count 22 (+ 3) % Row 3 \SetRowColor{white} Sale of Finished Lots & Sale of Finished Lots \tn % Row Count 24 (+ 2) % Row 4 \SetRowColor{LightBackground} Home Construction & Homebuilder builds home on lot according to agreed upon elevations and model. Lead time can take anywere from 6 - 12 months depending on the type of home. \tn % Row Count 30 (+ 6) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{x{1.69218 cm} x{3.28482 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Construction Cycle (cont)}} \tn % Row 5 \SetRowColor{LightBackground} Sale/ Closing & Buyer commits to buying finished home. Generally after a 30-day window, home is closed to the buyer. \tn % Row Count 4 (+ 4) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.59264 cm} x{3.38436 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Margin Definitions}} \tn % Row 0 \SetRowColor{LightBackground} Gross Margin & Sales revenue less all cost of sales items except for commission, warranty, and interest expenses \tn % Row Count 4 (+ 4) % Row 1 \SetRowColor{white} Direct Margin & Sales revenue less all cost of sales items except for warranty and interest expenses \tn % Row Count 8 (+ 4) % Row 2 \SetRowColor{LightBackground} \seqsplit{Contribution} Margin & Sales revenue less all applicable cost of sales amounts \tn % Row Count 11 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Market Cycle}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{p{5.377cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/aengland2490_1497035912_Homebuilding Cycle.PNG}}} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.59264 cm} x{3.38436 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Inventory Classifications}} \tn % Row 0 \SetRowColor{LightBackground} Build-Job & Home where buyer selects floor plan and various interior and exterior details of the home \tn % Row Count 4 (+ 4) % Row 1 \SetRowColor{white} Mechanic's Lien Job & Home where the buyer purchases the lot prior to starting construction. The homebuilder then provides construction services at a "cost-plus" arrangement supported by regular draws or payments from the owner of the lot. \tn % Row Count 13 (+ 9) % Row 2 \SetRowColor{LightBackground} Spec & Homes that are either finished or under construction where no valid sales contract exists \tn % Row Count 17 (+ 4) % Row 3 \SetRowColor{white} Backlog & Cumulative value of all completed homes and homes under construction where a valid sales contract exists \tn % Row Count 21 (+ 4) % Row 4 \SetRowColor{LightBackground} QI Date & Short for quality inspection, this final inspection of the home signifies that it is substantially complete (ie. no longer under construction) \tn % Row Count 27 (+ 6) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Construction Lead Times}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{p{5.377cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/aengland2490_1497028781_Construction times.PNG}}} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}