Can you please use all this information to balance the balance sheet. I cannot figure out where I am off. Trial balance was in balance.

\begin{tabular}{|l|r|r|r|r|} \hline \multicolumn{5}{|c|}{ Retained Earnings Statement } \\ \hline Statement as of Dec. 31 & \multicolumn{1}{|c|}{ Year 1 } & \multicolumn{1}{c|}{ Year 2 } & \multicolumn{1}{c|}{ Year 3 } & Year 4 \\ \hline Retained Earnings BoP & - & 9,985 & 196,429 & 473,616 \\ \hline Add/(Less): Net Income/(Loss) & 9,985 & 186,445 & 277,187 & 2,423,341 \\ \hline Total & 9,985 & 196,429 & 473,616 & 2,896,958 \\ \hline Less: Dividends & - & - & - & - \\ \hline Retained Earnings EoP & 9,985 & 196,429 & 473,616 & 2,896,958 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Income Statement } \\ \hline Statement as of Dec. 31 & Year 1 & Year 2 & Year 3 & Year 4 \\ \hline \multicolumn{5}{|l|}{ Bevenues } \\ \hline Rental Revenue & 216,000 & 272,160 & 280,325 & \\ \hline Acquistrian Classes \& Horse Rental Reu, & 24,000 & 34,000 & 29,678 & \\ \hline Wine and Distillary Sales & - & 94,500 & 151,200 & \\ \hline Total Revenue & 240.000 & 400.660 & 461.203 & \\ \hline \multicolumn{5}{|l|}{ Dperating Empenses } \\ \hline Insurance Expense & (2,000) & (2,000) & (2,000) & \\ \hline Maintenance - Repairstreinvest Expense & {[35,000]} & (15,000) & (5,000) & \\ \hline Landscaping Expense & (7,000) & (4,200) & (6,000) & \\ \hline Trustee Fees & (12,000) & (12,000) & (12,000) & \\ \hline Land Lease Expense & (4,500) & (4,500) & (4,500) & \\ \hline Marketing Expense & (5,000) & (7,500) & (10,000) & \\ \hline Salaryl'Wage Expense & (25,000) & {[30,000]} & (7,000) & \\ \hline Horse Grooming Expense & (6,000) & (4,200) & (3,500) & \\ \hline Annual Grape Seedling Afforestation Exp & (50,000) & (50,000) & (50,000) & \\ \hline Utilities Expense & (3,200) & 14,500 & (3,700) & \\ \hline Total Operating Expenses & {[149.700]} & {[133.900]} & {[103.700]} & - \\ \hline Net Operating Income & 90,300 & 266.760 & 357,503 & - \\ \hline \multicolumn{5}{|l|}{ Non-Operating Empenses } \\ \hline Construction Loan Interest & {[13,935]} & {[13,935]} & {[13,935]} & {[13,495)} \\ \hline Trustee Loan Interest & (8,750) & (8,750) & (8,750) & (8,750) \\ \hline Depreciation Building Expense & (16,740) & (16,740) & (16,740) & \\ \hline Depreciation Building Improvements Expr & (16,891) & (16,891) & (16,891) & . \\ \hline Depreciation Equipment Expense & (24,000) & (24,000) & (24,000) & (24,000) \\ \hline Total Non-Operating Expenses & {[80.316]} & {[80.316]} & {[80.316]} & {[46.245]} \\ \hline \multicolumn{5}{|l|}{ Otherlncome (Losses) } \\ \hline Gain on Sale of Equipment & - & & & 9,000 \\ \hline Gain on Sale of Property & - & & & 2,460,586 \\ \hline Total Other Income I [Losses] & - & & - & 2.469 .586 \\ \hline Net Income I (Losses) & 9,985 & 186,445 & 277,187 & 2,423,341 \\ \hline \end{tabular} ies Debit Account Trustee Loan Interest Construction Loan Interest Accounts Payable Cash Depreciation Equipment Expense Cash Accumulated Depreciation Equipment \begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{l} Debit Account \\ Cash \end{tabular}} & Credit Account & \multirow{2}{*}{\begin{tabular}{l|} DR \\ 2,100,000 \end{tabular}} & \multirow[t]{2}{*}{ CR } \\ \hline & & & \\ \hline & Common Stock & & 2,100,000 \\ \hline Land & & 1,500,000 & \\ \hline \multirow[t]{3}{*}{ Building } & & 460,335 & \\ \hline & Trustee Loan & & 175,000 \\ \hline & Cash & & 1,785,335 \\ \hline \multirow[t]{2}{*}{ Building Improvements } & & 464,500 & \\ \hline & Trustee Construction L & & 464,500 \\ \hline \multirow[t]{2}{*}{ Cash } & & 216,000 & \\ \hline & Rental Revenue & & 216,000 \\ \hline \multirow[t]{2}{*}{ Insurance Expense } & & 2,000 & \\ \hline & Cash & & 2,000 \\ \hline \multirow[t]{2}{*}{ Maintenance - Repairstreinvest Expense } & & 35,000 & \\ \hline & Accounts Payable & & 35,000 \\ \hline \multirow[t]{2}{*}{ Landscaping Expense } & & 7,000 & \\ \hline & Accounts Payable & & 7,000 \\ \hline \multirow[t]{2}{*}{ Trustee Fees } & & 12,000 & \\ \hline & Cash & & 12,000 \\ \hline \multirow[t]{2}{*}{ Land Lease Expense } & & 4,500 & \\ \hline & Cash & & 4,500 \\ \hline \multirow[t]{2}{*}{ Marketing Expense } & & 5,000 & \\ \hline & Accounts Payable & & 5,000 \\ \hline \multirow[t]{2}{*}{ Salaryt'wage Expense } & & 25,000 & \\ \hline & Cash & & 25,000 \\ \hline \multirow[t]{2}{*}{ Horse Grooming Expense } & & 6,000 & \\ \hline & Accounts Payable & & 6,000 \\ \hline \multicolumn{2}{|c|}{ Annual Grape Seedling Afforestation Expense } & 50,000 & \\ \hline & Accounts Payable & & 50,000 \\ \hline \multirow[t]{2}{*}{ Utilities Expense } & & 3,200 & \\ \hline & Cash & & 3,200 \\ \hline \multirow[t]{2}{*}{ Trustee Loan Interest } & & 8,750 & \\ \hline & Cash & & 8,750 \\ \hline \multirow[t]{2}{*}{ Construction Loan Interest } & & 13,935 & \\ \hline & Cash & & 13,935 \\ \hline \multicolumn{2}{|l|}{ Acquistrian Classes \& Horse Rental Revenue } & 24,000 & \\ \hline & Accounts Receivable & & 24,000 \\ \hline \multirow[t]{2}{*}{ Accounts Receivable } & & 24,000 & \\ \hline & Cash & & 24,000 \\ \hline \multirow[t]{2}{*}{ Equipment } & & 181,000 & \\ \hline & Cash & & 181,000 \\ \hline \multirow[t]{2}{*}{ Depreciation Equipment Expense } & & 24,000 & \\ \hline & Accumulated Deprecia & pment & 24,000 \\ \hline \multicolumn{2}{|l|}{ Depreciation Building Improvements Expense } & 16,891 & \\ \hline & Accumulated Deprecia & fing Improve & 16,891 \\ \hline Depreciation Building Expense & & 16,740 & \\ \hline & Accumulated Deprecia & fing & 16,740 \\ \hline \end{tabular} \begin{tabular}{|rr|r|r|} \hline \multicolumn{4}{c|}{ Depreciation } \\ Asset Building & \multicolumn{3}{|c|}{ Building Improvemer Construction Equipment } \\ Cost & 460,335 & 464,500 & \\ Years & & & \\ Depreciate & 27.5 & 27.5 & \\ Depreciatio & & & \\ n & 16,739 & 16,891 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Gain/Loss Calcalculation } \\ \hline \multicolumn{5}{|c|}{ Construction Equipment } \\ \hline \multirow{2}{*}{\begin{tabular}{l} Total Costs \\ -A.cc. Dep \end{tabular}} & 181,000 & & & \\ \hline & 96,000 & & & \\ \hline Net Book & 85,000 & & & \\ \hline \multirow{2}{*}{\begin{tabular}{r} Sale \\ -Net Book \\ \end{tabular}} & 94,000 & & & \\ \hline & 85,000 & & & \\ \hline aind [Loss] & 9,000 & & & \\ \hline \multicolumn{5}{|c|}{ GainlLoss Calcalculation } \\ \hline & Land & Building & Building Improver & Totals \\ \hline \multirow{2}{*}{\begin{tabular}{l} Total Costs \\ -A.cc. Dep \end{tabular}} & 1,500,000 & 460,335 & 464,500 & 2,424,835 \\ \hline & 150,000 & 66,958 & 67,564 & 284,521 \\ \hline \multirow[t]{4}{*}{ Net Book } & 1,650,000 & 527,293 & 532,064 & 22,140,314 \\ \hline & & & Sale & 4,600,900 \\ \hline & & & -Net Book & 2,140,314 \\ \hline & & & Gain'[Loss] & 2,460,586 \\ \hline \end{tabular} Negative value represents a loss (Debit) Positive value represents a gain (Credit) \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Sources and Uses of Cash } \\ \hline & Year & Year 2 & Year 3 & Year 4 \\ \hline \multicolumn{5}{|l|}{UsesofCash} \\ \hline (A.cquisition) Land & 1,500,000 & & & \\ \hline (Asset Improvements) - Building & 440,335 & & & \\ \hline (Asset Improvements) - Barn & 20,000 & & & \\ \hline (A.cquistion) Bearer Plants & 4,500 & & & \\ \hline (Acquistion) Harvesting \& Bottling Equipment & 40,000 & & & \\ \hline (A.cquistion) Additional Supplies & 5,000 & & & \\ \hline (A.cqusition) - Horses & 60,000 & & & \\ \hline (Acqusition) - Horse Equipment & 8,000 & & & \\ \hline [Acquisition] - Furniture Equipment & 16,000 & & & \\ \hline \multicolumn{5}{|l|}{ [Ops Exp] Froperty Takes - Paid by Trustee } \\ \hline (Ops Exp] Insurance & 2,000 & 2,000 & 2,000 & \\ \hline [Ops Exp] Maintenance - Repairstreinvest & 35,000 & 15,000 & 5,000 & \\ \hline [Ops Exp] Maintenance - Landscape & 7,000 & 4,200 & 6,000 & \\ \hline (Ops Exp) Trustee Fees (Land Lease) & 12,000 & 12,000 & 12,000 & \\ \hline (Ops Exp) Land Lease Fees (Froperty Owned by Far & 4,500 & 4,500 & 4,500 & \\ \hline (Ops Exp] Marketing Fees & 5,000 & 7,500 & 10,000 & \\ \hline [Ops Exp] Salaries \& W'ages & 25,000 & 30,000 & 7,000 & \\ \hline (Ops Eyp) Horses Grooming Eypense & 6,000 & 4,200 & 3,500 & \\ \hline (Ops Exp) Afforestation - Grape Seedlings Replant & 50,000 & 50,000 & 50,000 & \\ \hline [Ops Exp] Utilities & 3,200 & 4,500 & 3,700 & \\ \hline Working Capital & 36,750 & & & \\ \hline (Interest) Trustee Loan & 8,750 & 8,750 & 8,750 & 8,750 \\ \hline \multirow{3}{*}{\begin{tabular}{l} Construction Loan \\ (Interest) Construction Loan \\ (Debt Riepayment) - Trustee Loan \end{tabular}} & & & & 464,500 \\ \hline & 13,935 & 13,935 & 13,935 & \\ \hline & & & & 175,000 \\ \hline Total Expected Cash Uses & 2,302,970 & 156,585 & 126,385 & 473,250 \\ \hline \multicolumn{5}{|l|}{ Sources of Cash } \\ \hline Rental Revenue & 216,000 & 272,160 & 280,325 & \\ \hline Construction Loan & 464,500 & & & \\ \hline Trustee Loan & 175,000 & 30,240 & 31,147 & \\ \hline Acquistrian Classes \& Horse Rental Revenue & 24,000 & 34,000 & 29,678 & \\ \hline Wine and Distillary Sales & . & 94,500 & 151,200 & \\ \hline Working Capital From Frior Year & . & 676,530 & 950,845 & 1,316,810 \\ \hline \multirow{2}{*}{\begin{tabular}{l} Cash from Sell \\ Total Expected Cash Sources \end{tabular}} & & & & 5,430,994 \\ \hline & 879,500 & 1,107,430 & 1,443,195 & 6,747,804 \\ \hline Net Cash Generated Before Equity & (1,423,470) & 950,845 & 1,316,810 & 6,274,554 \\ \hline \multirow{3}{*}{\begin{tabular}{l} Calculated Equity Fiequired (FPM Amount) \\ Calculated Equity Returned \\ Calculated Equity Dividend \end{tabular}} & 2,100,000 & & & \\ \hline & & & & 2,100,000 \\ \hline & & & & \\ \hline \multirow{2}{*}{\begin{tabular}{l} Net Equity \\ Expected Cash at year end \end{tabular}} & 2,100,000 & & & \\ \hline & 676,530 & 950,845 & 1,316,810 & 8,374,554 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Net Operating Income } \\ \hline & Year1 & Year 2 & Year3 & Year4 \\ \hline \multicolumn{5}{|l|}{Revenues} \\ \hline B\&B Rentals & 216,000 & 272,160 & 280,325 & 288,735 \\ \hline Acquistrian Classes \& Horse Rentals & 24,000 & 30,240 & 31,147 & 32,081 \\ \hline Total Revenue & 240,000 & 302,400 & 311,472 & 320,816 \\ \hline \multicolumn{5}{|l|}{OperatingExpenses} \\ \hline Property Taxes - Paid by Trustee & - & - & - & \\ \hline Insurance & (2,000) & (2,000) & (2,000) & (2,000) \\ \hline Maintenance - Repairs/reinvest & (35,000) & (15,000) & (5,000) & (7,300) \\ \hline Maintenance - Landscape & (7,000) & (4,200) & (6,000) & (3,200) \\ \hline Trustee Fees & (12,000) & (12,000) & (12,000) & 12,000 \\ \hline \multicolumn{5}{|l|}{ Land Lease Fees (Property Owned by } \\ \hline Family Trust) & (4,500) & (4,500) & (4,500) & 4,500 \\ \hline Marketing Fees & (5,000) & (7,500) & (10,000) & (15,000) \\ \hline Horse Maintaince \& Grooming Exp & (6,500) & (4,200) & (7,000) & (5,600) \\ \hline Salaries \& Wages & (25,000) & (30,000) & (35,000) & (42,000) \\ \hline Afforestation - grape seedlings & (50,000) & (50,000) & (50,000) & (50,000) \\ \hline Utilities & (3,200) & (4,500) & (3,700) & (5,600) \\ \hline Total Operating Expenses & (147,000) & (129,400) & (131,500) & (114,200) \\ \hline Net Operating Income & (145,000) & 95,700 & 110,472 & 212,716 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Value-Add Budget } \\ \hline & Units/SF & Cost per Unit / SF & Total Cost \\ \hline \multicolumn{4}{|l|}{ Purchase Price } \\ \hline Property & NA & NA & 1,500,000 \\ \hline \multicolumn{3}{|l|}{ Total Purchase Price } & 1,500,000 \\ \hline \multicolumn{4}{|l|}{ Improvements Costs } \\ \hline Mold Remediation & 3,500SF & $15 per SF & 52,500 \\ \hline Kitchen Renovations & 1,000SF & $50 per SF & 50,000 \\ \hline Bathroom Renovations & 400SF & $35 per SF & 14,000 \\ \hline Floor Install & 1,600SF & $8 per SF & 12,800 \\ \hline Hardwood Floor Resurface [ 1st Floo & 1,300SF & $12 per SF & 15,600 \\ \hline Courtyard Install & 1,000SF & $75 per SF & 75,000 \\ \hline Brickoven Install & 200SF & $22 per SF & 4,400 \\ \hline Tasting Room \& Hosting Addition & 2,000SF & $35 per SF & 70,000 \\ \hline Marble Countertops & 450SF & $40 per SF & 18,000 \\ \hline Marble Bathroom Floors & 120SF & $20 per SF & 2,400 \\ \hline Stable Addition to Barn & 2,400SF & $10 per SF & 24,000 \\ \hline Paint'Custom Wallpaper & 2,200SF & $3 per SF & 6,600 \\ \hline Window Resurfacing & 325SF & $7 per SF & 2,275 \\ \hline Brick Limewashing & 2,500SF & $2 per SF & 5,000 \\ \hline Wine Cellar & 400SF & $250 per SF & 100,000 \\ \hline Chimney Renewal \& Additions & 80SF & $12 per SF & 960 \\ \hline Crown Modeling & 1,800SF & $6 per SF & 10,800 \\ \hline \multicolumn{3}{|l|}{ Total Improvements } & 464,335 \\ \hline \multicolumn{4}{|l|}{ Appliances \& Gther } \\ \hline \multicolumn{2}{|l|}{ Stainless Steel Refrigerator } & 1,500EA & 3,000 \\ \hline \begin{tabular}{l} Stainless Steel Refrigerator \\ Antique Furniture Equipment \end{tabular} & 8 & 2,000EA & 16,000 \\ \hline Bearer Plants - Biological Asset & 10,000 & 4EA & 40,000 \\ \hline Horses & 4 & 15,000EA & 60,000 \\ \hline Horse Grooming Equipment & 4 & 2,000EA & 8,000 \\ \hline Harvesting \& Bottling Equipment & 20,000 & 2EA & 40,000 \\ \hline Additional Supplies Inventory & 10 & 500EA & 5,000 \\ \hline Wine Fridge Cooling Unit & 1 & 9,000 EA & 9,000 \\ \hline \multicolumn{2}{|l|}{ Total Appliances \& Other } & & 181,000 \\ \hline Total Budget & & & 2,145,335 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r|} \hline \multicolumn{5}{|c|}{ Retained Earnings Statement } \\ \hline Statement as of Dec. 31 & \multicolumn{1}{|c|}{ Year 1 } & \multicolumn{1}{c|}{ Year 2 } & \multicolumn{1}{c|}{ Year 3 } & Year 4 \\ \hline Retained Earnings BoP & - & 9,985 & 196,429 & 473,616 \\ \hline Add/(Less): Net Income/(Loss) & 9,985 & 186,445 & 277,187 & 2,423,341 \\ \hline Total & 9,985 & 196,429 & 473,616 & 2,896,958 \\ \hline Less: Dividends & - & - & - & - \\ \hline Retained Earnings EoP & 9,985 & 196,429 & 473,616 & 2,896,958 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Income Statement } \\ \hline Statement as of Dec. 31 & Year 1 & Year 2 & Year 3 & Year 4 \\ \hline \multicolumn{5}{|l|}{ Bevenues } \\ \hline Rental Revenue & 216,000 & 272,160 & 280,325 & \\ \hline Acquistrian Classes \& Horse Rental Reu, & 24,000 & 34,000 & 29,678 & \\ \hline Wine and Distillary Sales & - & 94,500 & 151,200 & \\ \hline Total Revenue & 240.000 & 400.660 & 461.203 & \\ \hline \multicolumn{5}{|l|}{ Dperating Empenses } \\ \hline Insurance Expense & (2,000) & (2,000) & (2,000) & \\ \hline Maintenance - Repairstreinvest Expense & {[35,000]} & (15,000) & (5,000) & \\ \hline Landscaping Expense & (7,000) & (4,200) & (6,000) & \\ \hline Trustee Fees & (12,000) & (12,000) & (12,000) & \\ \hline Land Lease Expense & (4,500) & (4,500) & (4,500) & \\ \hline Marketing Expense & (5,000) & (7,500) & (10,000) & \\ \hline Salaryl'Wage Expense & (25,000) & {[30,000]} & (7,000) & \\ \hline Horse Grooming Expense & (6,000) & (4,200) & (3,500) & \\ \hline Annual Grape Seedling Afforestation Exp & (50,000) & (50,000) & (50,000) & \\ \hline Utilities Expense & (3,200) & 14,500 & (3,700) & \\ \hline Total Operating Expenses & {[149.700]} & {[133.900]} & {[103.700]} & - \\ \hline Net Operating Income & 90,300 & 266.760 & 357,503 & - \\ \hline \multicolumn{5}{|l|}{ Non-Operating Empenses } \\ \hline Construction Loan Interest & {[13,935]} & {[13,935]} & {[13,935]} & {[13,495)} \\ \hline Trustee Loan Interest & (8,750) & (8,750) & (8,750) & (8,750) \\ \hline Depreciation Building Expense & (16,740) & (16,740) & (16,740) & \\ \hline Depreciation Building Improvements Expr & (16,891) & (16,891) & (16,891) & . \\ \hline Depreciation Equipment Expense & (24,000) & (24,000) & (24,000) & (24,000) \\ \hline Total Non-Operating Expenses & {[80.316]} & {[80.316]} & {[80.316]} & {[46.245]} \\ \hline \multicolumn{5}{|l|}{ Otherlncome (Losses) } \\ \hline Gain on Sale of Equipment & - & & & 9,000 \\ \hline Gain on Sale of Property & - & & & 2,460,586 \\ \hline Total Other Income I [Losses] & - & & - & 2.469 .586 \\ \hline Net Income I (Losses) & 9,985 & 186,445 & 277,187 & 2,423,341 \\ \hline \end{tabular} ies Debit Account Trustee Loan Interest Construction Loan Interest Accounts Payable Cash Depreciation Equipment Expense Cash Accumulated Depreciation Equipment \begin{tabular}{|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{l} Debit Account \\ Cash \end{tabular}} & Credit Account & \multirow{2}{*}{\begin{tabular}{l|} DR \\ 2,100,000 \end{tabular}} & \multirow[t]{2}{*}{ CR } \\ \hline & & & \\ \hline & Common Stock & & 2,100,000 \\ \hline Land & & 1,500,000 & \\ \hline \multirow[t]{3}{*}{ Building } & & 460,335 & \\ \hline & Trustee Loan & & 175,000 \\ \hline & Cash & & 1,785,335 \\ \hline \multirow[t]{2}{*}{ Building Improvements } & & 464,500 & \\ \hline & Trustee Construction L & & 464,500 \\ \hline \multirow[t]{2}{*}{ Cash } & & 216,000 & \\ \hline & Rental Revenue & & 216,000 \\ \hline \multirow[t]{2}{*}{ Insurance Expense } & & 2,000 & \\ \hline & Cash & & 2,000 \\ \hline \multirow[t]{2}{*}{ Maintenance - Repairstreinvest Expense } & & 35,000 & \\ \hline & Accounts Payable & & 35,000 \\ \hline \multirow[t]{2}{*}{ Landscaping Expense } & & 7,000 & \\ \hline & Accounts Payable & & 7,000 \\ \hline \multirow[t]{2}{*}{ Trustee Fees } & & 12,000 & \\ \hline & Cash & & 12,000 \\ \hline \multirow[t]{2}{*}{ Land Lease Expense } & & 4,500 & \\ \hline & Cash & & 4,500 \\ \hline \multirow[t]{2}{*}{ Marketing Expense } & & 5,000 & \\ \hline & Accounts Payable & & 5,000 \\ \hline \multirow[t]{2}{*}{ Salaryt'wage Expense } & & 25,000 & \\ \hline & Cash & & 25,000 \\ \hline \multirow[t]{2}{*}{ Horse Grooming Expense } & & 6,000 & \\ \hline & Accounts Payable & & 6,000 \\ \hline \multicolumn{2}{|c|}{ Annual Grape Seedling Afforestation Expense } & 50,000 & \\ \hline & Accounts Payable & & 50,000 \\ \hline \multirow[t]{2}{*}{ Utilities Expense } & & 3,200 & \\ \hline & Cash & & 3,200 \\ \hline \multirow[t]{2}{*}{ Trustee Loan Interest } & & 8,750 & \\ \hline & Cash & & 8,750 \\ \hline \multirow[t]{2}{*}{ Construction Loan Interest } & & 13,935 & \\ \hline & Cash & & 13,935 \\ \hline \multicolumn{2}{|l|}{ Acquistrian Classes \& Horse Rental Revenue } & 24,000 & \\ \hline & Accounts Receivable & & 24,000 \\ \hline \multirow[t]{2}{*}{ Accounts Receivable } & & 24,000 & \\ \hline & Cash & & 24,000 \\ \hline \multirow[t]{2}{*}{ Equipment } & & 181,000 & \\ \hline & Cash & & 181,000 \\ \hline \multirow[t]{2}{*}{ Depreciation Equipment Expense } & & 24,000 & \\ \hline & Accumulated Deprecia & pment & 24,000 \\ \hline \multicolumn{2}{|l|}{ Depreciation Building Improvements Expense } & 16,891 & \\ \hline & Accumulated Deprecia & fing Improve & 16,891 \\ \hline Depreciation Building Expense & & 16,740 & \\ \hline & Accumulated Deprecia & fing & 16,740 \\ \hline \end{tabular} \begin{tabular}{|rr|r|r|} \hline \multicolumn{4}{c|}{ Depreciation } \\ Asset Building & \multicolumn{3}{|c|}{ Building Improvemer Construction Equipment } \\ Cost & 460,335 & 464,500 & \\ Years & & & \\ Depreciate & 27.5 & 27.5 & \\ Depreciatio & & & \\ n & 16,739 & 16,891 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Gain/Loss Calcalculation } \\ \hline \multicolumn{5}{|c|}{ Construction Equipment } \\ \hline \multirow{2}{*}{\begin{tabular}{l} Total Costs \\ -A.cc. Dep \end{tabular}} & 181,000 & & & \\ \hline & 96,000 & & & \\ \hline Net Book & 85,000 & & & \\ \hline \multirow{2}{*}{\begin{tabular}{r} Sale \\ -Net Book \\ \end{tabular}} & 94,000 & & & \\ \hline & 85,000 & & & \\ \hline aind [Loss] & 9,000 & & & \\ \hline \multicolumn{5}{|c|}{ GainlLoss Calcalculation } \\ \hline & Land & Building & Building Improver & Totals \\ \hline \multirow{2}{*}{\begin{tabular}{l} Total Costs \\ -A.cc. Dep \end{tabular}} & 1,500,000 & 460,335 & 464,500 & 2,424,835 \\ \hline & 150,000 & 66,958 & 67,564 & 284,521 \\ \hline \multirow[t]{4}{*}{ Net Book } & 1,650,000 & 527,293 & 532,064 & 22,140,314 \\ \hline & & & Sale & 4,600,900 \\ \hline & & & -Net Book & 2,140,314 \\ \hline & & & Gain'[Loss] & 2,460,586 \\ \hline \end{tabular} Negative value represents a loss (Debit) Positive value represents a gain (Credit) \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Sources and Uses of Cash } \\ \hline & Year & Year 2 & Year 3 & Year 4 \\ \hline \multicolumn{5}{|l|}{UsesofCash} \\ \hline (A.cquisition) Land & 1,500,000 & & & \\ \hline (Asset Improvements) - Building & 440,335 & & & \\ \hline (Asset Improvements) - Barn & 20,000 & & & \\ \hline (A.cquistion) Bearer Plants & 4,500 & & & \\ \hline (Acquistion) Harvesting \& Bottling Equipment & 40,000 & & & \\ \hline (A.cquistion) Additional Supplies & 5,000 & & & \\ \hline (A.cqusition) - Horses & 60,000 & & & \\ \hline (Acqusition) - Horse Equipment & 8,000 & & & \\ \hline [Acquisition] - Furniture Equipment & 16,000 & & & \\ \hline \multicolumn{5}{|l|}{ [Ops Exp] Froperty Takes - Paid by Trustee } \\ \hline (Ops Exp] Insurance & 2,000 & 2,000 & 2,000 & \\ \hline [Ops Exp] Maintenance - Repairstreinvest & 35,000 & 15,000 & 5,000 & \\ \hline [Ops Exp] Maintenance - Landscape & 7,000 & 4,200 & 6,000 & \\ \hline (Ops Exp) Trustee Fees (Land Lease) & 12,000 & 12,000 & 12,000 & \\ \hline (Ops Exp) Land Lease Fees (Froperty Owned by Far & 4,500 & 4,500 & 4,500 & \\ \hline (Ops Exp] Marketing Fees & 5,000 & 7,500 & 10,000 & \\ \hline [Ops Exp] Salaries \& W'ages & 25,000 & 30,000 & 7,000 & \\ \hline (Ops Eyp) Horses Grooming Eypense & 6,000 & 4,200 & 3,500 & \\ \hline (Ops Exp) Afforestation - Grape Seedlings Replant & 50,000 & 50,000 & 50,000 & \\ \hline [Ops Exp] Utilities & 3,200 & 4,500 & 3,700 & \\ \hline Working Capital & 36,750 & & & \\ \hline (Interest) Trustee Loan & 8,750 & 8,750 & 8,750 & 8,750 \\ \hline \multirow{3}{*}{\begin{tabular}{l} Construction Loan \\ (Interest) Construction Loan \\ (Debt Riepayment) - Trustee Loan \end{tabular}} & & & & 464,500 \\ \hline & 13,935 & 13,935 & 13,935 & \\ \hline & & & & 175,000 \\ \hline Total Expected Cash Uses & 2,302,970 & 156,585 & 126,385 & 473,250 \\ \hline \multicolumn{5}{|l|}{ Sources of Cash } \\ \hline Rental Revenue & 216,000 & 272,160 & 280,325 & \\ \hline Construction Loan & 464,500 & & & \\ \hline Trustee Loan & 175,000 & 30,240 & 31,147 & \\ \hline Acquistrian Classes \& Horse Rental Revenue & 24,000 & 34,000 & 29,678 & \\ \hline Wine and Distillary Sales & . & 94,500 & 151,200 & \\ \hline Working Capital From Frior Year & . & 676,530 & 950,845 & 1,316,810 \\ \hline \multirow{2}{*}{\begin{tabular}{l} Cash from Sell \\ Total Expected Cash Sources \end{tabular}} & & & & 5,430,994 \\ \hline & 879,500 & 1,107,430 & 1,443,195 & 6,747,804 \\ \hline Net Cash Generated Before Equity & (1,423,470) & 950,845 & 1,316,810 & 6,274,554 \\ \hline \multirow{3}{*}{\begin{tabular}{l} Calculated Equity Fiequired (FPM Amount) \\ Calculated Equity Returned \\ Calculated Equity Dividend \end{tabular}} & 2,100,000 & & & \\ \hline & & & & 2,100,000 \\ \hline & & & & \\ \hline \multirow{2}{*}{\begin{tabular}{l} Net Equity \\ Expected Cash at year end \end{tabular}} & 2,100,000 & & & \\ \hline & 676,530 & 950,845 & 1,316,810 & 8,374,554 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Net Operating Income } \\ \hline & Year1 & Year 2 & Year3 & Year4 \\ \hline \multicolumn{5}{|l|}{Revenues} \\ \hline B\&B Rentals & 216,000 & 272,160 & 280,325 & 288,735 \\ \hline Acquistrian Classes \& Horse Rentals & 24,000 & 30,240 & 31,147 & 32,081 \\ \hline Total Revenue & 240,000 & 302,400 & 311,472 & 320,816 \\ \hline \multicolumn{5}{|l|}{OperatingExpenses} \\ \hline Property Taxes - Paid by Trustee & - & - & - & \\ \hline Insurance & (2,000) & (2,000) & (2,000) & (2,000) \\ \hline Maintenance - Repairs/reinvest & (35,000) & (15,000) & (5,000) & (7,300) \\ \hline Maintenance - Landscape & (7,000) & (4,200) & (6,000) & (3,200) \\ \hline Trustee Fees & (12,000) & (12,000) & (12,000) & 12,000 \\ \hline \multicolumn{5}{|l|}{ Land Lease Fees (Property Owned by } \\ \hline Family Trust) & (4,500) & (4,500) & (4,500) & 4,500 \\ \hline Marketing Fees & (5,000) & (7,500) & (10,000) & (15,000) \\ \hline Horse Maintaince \& Grooming Exp & (6,500) & (4,200) & (7,000) & (5,600) \\ \hline Salaries \& Wages & (25,000) & (30,000) & (35,000) & (42,000) \\ \hline Afforestation - grape seedlings & (50,000) & (50,000) & (50,000) & (50,000) \\ \hline Utilities & (3,200) & (4,500) & (3,700) & (5,600) \\ \hline Total Operating Expenses & (147,000) & (129,400) & (131,500) & (114,200) \\ \hline Net Operating Income & (145,000) & 95,700 & 110,472 & 212,716 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Value-Add Budget } \\ \hline & Units/SF & Cost per Unit / SF & Total Cost \\ \hline \multicolumn{4}{|l|}{ Purchase Price } \\ \hline Property & NA & NA & 1,500,000 \\ \hline \multicolumn{3}{|l|}{ Total Purchase Price } & 1,500,000 \\ \hline \multicolumn{4}{|l|}{ Improvements Costs } \\ \hline Mold Remediation & 3,500SF & $15 per SF & 52,500 \\ \hline Kitchen Renovations & 1,000SF & $50 per SF & 50,000 \\ \hline Bathroom Renovations & 400SF & $35 per SF & 14,000 \\ \hline Floor Install & 1,600SF & $8 per SF & 12,800 \\ \hline Hardwood Floor Resurface [ 1st Floo & 1,300SF & $12 per SF & 15,600 \\ \hline Courtyard Install & 1,000SF & $75 per SF & 75,000 \\ \hline Brickoven Install & 200SF & $22 per SF & 4,400 \\ \hline Tasting Room \& Hosting Addition & 2,000SF & $35 per SF & 70,000 \\ \hline Marble Countertops & 450SF & $40 per SF & 18,000 \\ \hline Marble Bathroom Floors & 120SF & $20 per SF & 2,400 \\ \hline Stable Addition to Barn & 2,400SF & $10 per SF & 24,000 \\ \hline Paint'Custom Wallpaper & 2,200SF & $3 per SF & 6,600 \\ \hline Window Resurfacing & 325SF & $7 per SF & 2,275 \\ \hline Brick Limewashing & 2,500SF & $2 per SF & 5,000 \\ \hline Wine Cellar & 400SF & $250 per SF & 100,000 \\ \hline Chimney Renewal \& Additions & 80SF & $12 per SF & 960 \\ \hline Crown Modeling & 1,800SF & $6 per SF & 10,800 \\ \hline \multicolumn{3}{|l|}{ Total Improvements } & 464,335 \\ \hline \multicolumn{4}{|l|}{ Appliances \& Gther } \\ \hline \multicolumn{2}{|l|}{ Stainless Steel Refrigerator } & 1,500EA & 3,000 \\ \hline \begin{tabular}{l} Stainless Steel Refrigerator \\ Antique Furniture Equipment \end{tabular} & 8 & 2,000EA & 16,000 \\ \hline Bearer Plants - Biological Asset & 10,000 & 4EA & 40,000 \\ \hline Horses & 4 & 15,000EA & 60,000 \\ \hline Horse Grooming Equipment & 4 & 2,000EA & 8,000 \\ \hline Harvesting \& Bottling Equipment & 20,000 & 2EA & 40,000 \\ \hline Additional Supplies Inventory & 10 & 500EA & 5,000 \\ \hline Wine Fridge Cooling Unit & 1 & 9,000 EA & 9,000 \\ \hline \multicolumn{2}{|l|}{ Total Appliances \& Other } & & 181,000 \\ \hline Total Budget & & & 2,145,335 \\ \hline \end{tabular}