Please balance the balance sheet

C D E F G H K M N P ies Debit Account Credit Account DR CR Balanced No spelling errors Trustee Loan Interest 8,750 Cash 3,750 Directions for use: Construction Loan Interest 13.495 Cash 13,495 Delete Example before use. Accounts Payable 69.000 Cash 69,000 Enter Date (last day of the year) in Column B (Only one date per journal entry). Try to Cash 161,000 sequence the transactions in the natual order they'd be in. For example, your very first Accounts Receivable 161,000 journal entry should be raising capital. Depreciation Equipment Expense 24.000 Enter account(s) to be debited in Column C Accumulated Depreciation Equipment 24,000 Enter the value to be debited in Coumn E of the same row where the account name was Cash 94,000 entered. Accumulated Depreciation Equipment 96.000 Equipment 181,000 Enter account(s) to be credited in Column D Gain on Sale of Equipment 9,000 Enter the value to be debited in Coumn F of the same row where the account name was Cash 4,600,900 entered. Accumulated Depreciation Property 284.521 DO NOT: Land 1,500,000 Change the layout on any of the journal entry sheets Building 460,335 Drag and drop cells on any of the Journal Entry (JE#) or Chart of Accounts sheets Building Improvements 464,500 Gain on Sale of Property 2.460,586 Accounts Receivable 161,000 Cash 161,000Balance Sheet Statement as of Dec. 31 Year 1 Year 2 Year 3 Year 4 TRIAL BALANCE CASH FLOWS TRIAL BALANCE SHEET STATEMENT BALANCE Assets BALANCE SHEET Cash 256,280 143.440 390,427 4,603,655 Land 1,500,000 1,500,000 1,500,000 CASH ASSETS Building 460,335 460,335 460,335 DIVIDENDS DIVIDENDS SHORT TERM Building Improvements 64,500 464,500 464,500 PAID PAID ACCOUNTS RETAINED RECEIVABLE CASH Accumulated Depreciation Property STATEMENT ACCOUNTS Equipment 181,000 LAND RECEIVABLE Accumulated Depreciation Equipment (24,000 (48,000) (72,000) Accumulated Depreciation Building Imp (16.891 (33,782) (50,673) BUILDING ACCUMULATED LONG TERM Accumulated Depreciation Building (16,740) (33.479) (50,219) DEPRECIATION Cash Equivalents LAND INCOME STATEMENT BUILDING BUILDING EQUIPMENT BUILDING ACCUMULATED DEPRECIATION EQUIPMENT ACCUMULATED EQUIPMENT DEPRECIATION EQUIPMENT NOTES ACCUMULATED #0 80 2.453.014 2.642.371 0 PAYABLE DEPRECIATION Total Assets ACCOUNTS PAYABLE TOTAL ASSETS Liabilities Accounts Payable COMMON Trustee Loan STOCK 464,500 LIABILITIES Trustee Construction Loan Unearned Rent REVENUES SHORT TERM Insurance Expense 2,000 2,000 2.000 ACCOUNTS Maintenance - Repairs/reinvest Expens 35,000 15,000 5,000 OPERATING PAYABLE Landscaping Expense 7,000 .200 0no'9 INCOME EXPENSES Trustee Fees 2,000 12,000 12.000 STATEMENT NON-OPERATING LONG TERM Land Lease Expense 4,500 4,500 4.500 EXPENSES Marketing Expense 10,000 NOTES 5,000 7.500 PAYABLE Salary/Wage Expense 25,000 30,000 7.000 GAIN ON SALE OF EQUIPMENT Horse Grooming Expense 6,000 4.200 3.500 Annual Grape Seedling Afforestation E 50,000 50,000 TOTAL LIABILITIES 0,000 DIVIDENDS Utilities Expense 3.200 4,500 3.700 Construction Loan Interest 13,935 13,935 13,935 Trustee Loan Interest 8,750 8,750 8,750 EQUITY Depreciation Building Expense 16,740 16,740 16,740 RETAINED COMMON Depreciation Building Improvements E: 16.891 16.891 16,891 EARNINGS STOCK Depreciation Equipment Expense 24,000 24,000 24,000 STATEMENT RETAINED EARNINGS Total Liabilities 694.516 184.016 TOTAL EQUITY Stockholders Equity Common Stock 2,100,000 2,100,000 2,100,000 2,100,000 Retained Earnings 9,985 196,429 473,616 2.896,958 Total Stockholders Equity 2.109.969 ##80# 2.573.616 Total Liabilities and Stockhold THE #VALUE! 0 #VALUE! -115261 -393303 If Balanced, this row will read "0"Depreciation Asset Building Building Improvemer Construction Equipment Cost 460,335 464.500 Years Depreciate 27.5 27.5 Depreciation n 16,735 16,89 Gain/Loss Calcalculation Construction Equipment Total Costs 181,000 -Acc. Dep 96,000 Net Book 85.000 Sale 34,000 -Net Book 85,000 Gain[Loss] 3.000 GairdLoss Calcalculation Land Building Building Improver Totals Total Costs 500,000 460.335 464.500 2.424.835 -Acc. Dep 150,000 66,958 67.564 184.521 Net Book 650,000 527 293 532,064 2.140,314 Sale 4,600,900 -Net Book 2.140,314 Gain[Loss] 2.460,586 Negative value represents a loss (Debit) Positive value represents a gain (Credit)Income Statement Statement as of Dec. 31 Year 1 Year 2 Year 3 Year 4 INCOME TRIAL Revenues STATEMENT BALANCE Rental Revenue 216,000 272,160 280,325 Acquistrian Classes & Horse Rental Revi 24,000 34,000 29,678 REVENUES CASH Wine and Distillary Sales 94,500 151,200 Total Revenue 240.00 0 400.660 461.203 OPERATING ACCOUNTS EXPENSES RECEIVABLE Operating Expenses Insurance Expense (2,000) [2,000) (2,000) OPERATING LAND INCOME Maintenance - Repairs/reinvest Expense 35,000) 15,000 (5,000) Landscaping Ex (7,000) (4,200 (6,000) 12,000) (12,000) NON-OPERATING BUILDING Trustee Fees 12,000) EXPENSES ACCUMULATED Land Lease Expense (4.500) (4.500) (4.500) DEPRECIATION Marketing Expense 5,000 (7,500) (10,000) Salary/Wage Expense (25,000) (30,000) (7,000) OTHER (3,500) INCOME/LOSS BUILDING Horse Grooming Expense (6,000) (4,200) Annual Grape Seedling Afforestation Exp (50,000) 50,000) (50,000) Jtilities Expense (3,200) (4.500) (3,700) NET INCOME EQUIPMENT EQUIPMENT ACCUMULATED DEPRECIATION Total Operating Expenses [149.700) (133.900) (103.700) NOTES PAYABLE Net Operating Income 90.300 266.760 357.503 ACCOUNTS PAYABLE Non-Operating Expenses Construction Loan Interest (13,935) (13,935) (13,935) (13,495) COMMON Trustee Loan Interest (8,750) (8,750 (8,750) (8,750) STOCK Depreciation Building Expense (16,740) (16,740) [16,740) BALANCE Depreciation Building Improvements Expi (16,891) [16,891) [16,891) REVENUES SHEET Depreciation Equipment Expense [24,000) (24,000) [24,000) (24,000) OPERATING EXPENSES NON-OPERATING EXPENSES Total Non-Operating Expenses (80.316) (80.316] (80.316) (46.245) RETAINED EARNINGS GAIN ON SALE Other Incomer ( Losses OF EQUIPMENT Gain on Sale of Equipment 9.000 STATEMENT Gain on Sale of Property 2,460,58 DIVIDENDS Total Other Income / [Losses] 2.469.586 Net Income / (Losses] 9.985 186.445 277.187 2.423.341C G H Debit Account Credit Account OR CR Balanced No spelling errors Cast 2,100,000 Common Stock 2,100,000 Directions for use: Land 1,500,000 Delete Example before use. Building 460,335 Enter Date (last day of the year) in Column B (Only one date per journal entry). Try to Trustee Loan 175,000 sequence the transactions in the natual order they'd be in. For example, your very first Cast 1785,335 journal entry should be raising capital. Building Improvements 464,500 Trustee Construction Loan 464,500 Enter account(s) to be debited in Column C Cash 216,000 Enter the value to be debited in Coumn E of the same row where the account name was ntal Revenue 216,000 entered. Insurance Expense 2,000 Enter accounts) to be credited in Column D Cash 2,000 Enter the value to be debited in Coumn F of the same row where the account name was Maintenance - Repairs/reinvest Expense 35,000 entered. Accounts Payable 35,000 Landscaping Expense 7,000 DO NOT: Accounts Payable 7,000 - Change the layout on any of the journal entry sheets - Drag and drop cells on any of the Journal Entry (JE#) or Chart of Accounts sheets Trustee Fees 12,000 Cash 12,000 Land Lease Expense 4,500 Cash .500 Marketing Expense 5,000 Accounts Payable 5.000 Salary/Wage Expense 25,000 Cash 25,000 Horse Grooming Expense 3.000 Accounts Payable 5,000 Annual Grape Seedling Afforestation Expense 50,000 Accounts Payable 50,000 Utilities Expense 3,200 Cash 3,200 Trustee Loan Interest 8,750 Cast 8,750 Construction Loan Interest 13,935 Cash 13,935 Acquistrian Classes & Horse Rental Revenue 24,000 Accounts Receivable 24,000 Accounts Receivable 24,000 Cash 24,000 Equipment 181,000 Cash 181,000 Depreciation Equipment Expense 24,000 Accumulated Depreciation Equipmen 24,000 Depreciation Building Improvements Expense 16,891 Accumulated Depreciation Building Improve 16,891 Depreciation Building Expense 16,740 Accumulated Depreciation Building 16,740rie Debit Account Credit Account DR CR Balanced No spelling errors Accounts Payable 103,000 Cash 103,000 Directions for use: Insurance Expense 2,000 Accounts Payable 2,000 Delete Example before use. Maintenance - Repairs/reinvest Expense 15,000 Accounts Payable 15,000 Enter Date (last day of the year) in Column B (Only one date per journal entry). Try to Landscaping Expense 4,200 sequence the transactions in the natual order they'd be in. For example, your very first journal entry should be raising capital. Cash +,200 Trustee Fees 12,000 Enter account(s) to be debited in Column C Cash 12,000 Enter the value to be debited in Coumn E of the same row where the account name was Land Lease Expense 4,500 entered. Cash 50 Enter account(s) to be credited in Column D Marketing Expense 7,500 Enter the value to be debited in Coumn F of the same row where the account name was Accounts Payable 7,500 entered. Accounts Receivable 24,000 Cash 24,000 DO NOT: Cash 272,160 Change the layout on any of the journal entry sheets Rental Revenue 272,160 -Drag and drop cells on any of the Journal Entry (JEB) or Chart of Accounts sheets Salary/Wage Expense 30,000 Cash 30,000 Horse Grooming Expense 4,200 Accounts Payable 4,200 Wine and Distillary Sales 47,250 Accounts Receivable 47,250 Annual Grape Seedling Afforestation Expense 50,000 Accounts Payable 50,000 Utilities Expense 4,500 Cash 4,500 Trustee Loan 3,750 Cash 8,750 Construction Loan Interest 13,935 Cash 13.935 Cash 24,300 Accounts Payable 24.300 Accounts Receivable 10,000 Acquistrian Classes & Horse Rental Revenue 10,000 Cash 24,000 Accounts Receivable 24,000 Cash 10,00 Accounts Receivable 10,000 Cash 47,250 Accounts Receive 47,250 Depreciation Equipment Expense 48,000 Accumulated Depreciation Equipment 48,000 Depreciation Building Expense 33,782 Accumulated Depreciation Building 33,782 Depreciation Building Improvements Expense 33,480 Accumulated Depreciation Building Improvements 33,480D G Debit Account Credit Account DR CA Balanced No spelling errors Insurance Expense 2,000 Accounts Payable 2,000 Directions for use: Cash 235,000 Accounts Receivable 45.000 Delete Example before use. Rental Revenue 280,000 Maintenance - Repairsreinvest Expense 5,000 Enter Date (last day of the year) in Column B (Only one date per journal entry). Try to Cash 5,000 sequence the transactions in the natual order they'd be in. For example, your very first 6,000 journal entry should be raising capital. Landscaping Expense Cash 6.000 Enter account(s) to be debited in Column C Land Lease Expense 4,500 Enter the value to be debited in Coumn E of the same row where the account name was Cash 4,500 entered. Marketing Expense 10,000 Accounts Payable 10,000 Enter account(s) to be credited in Column D SalaryWage Expense 7.000 Enter the value to be debited in Coumn F of the same row where the account name was Accounts Payable 7.000 entered. Horse Grooming Expense 3,500 Cash 3,500 DO NOT: - Change the layout on any of the journal entry sheets Annual Grape Seedling Afforestation Expense 50,000 - Drag and drop cells on any of the Journal Entry (JE#) or Chart of Accounts sheets Accounts Payable 50,000 Accounts Receivable 45.000 Cash 45.000 Rental Revenue Accounts Receivable Acquistrian Classes & Horse Rental Revenue 29.000 Accounts Receivable 29,000 Utilities Expense 3,700 Cash 3,700 Cash 51,200 Accounts Receivable 100,000 Wine and Distillary Sales 151,200 Construction Loan Interest 13,935 Cash 13.935 Trustee Loan Interest 8,750 Cash 8,750 Depreciation Equipment Expense 72,000 Accumulated Depreciation Equipment 72,000 Depreciation Building Expense 50.673 Accumulated Depreciation Building 50.673 Depreciation Building Improvements Expense 50,220 Accumulated Depreciation Building Improvements 50,220 Trustee Fees 12,000 Cash 12.000Net Operating Income Year 1 Year 2 Year 3 Year 4 Revenues B&B Rentals 216,000 272,160 280,325 288,735 Acquistrian Classes & Horse Rentals 24,000 30,240 31,147 32,081 Total Revenue 240,000 302,400 311,472 320,816 Operating Expenses Property Taxes - Paid by Trustee Insurance (2,000) (2,000) (2,000) (2,000) Maintenance - Repairs/reinvest (35,000) (15,000) (5,000) (7,300 Maintenance - Landscape (7,000) (4,200) (6,000) (3,200) Trustee Fees (12,000) (12,000) (12,000) 12,000 Land Lease Fees (Property Owned by 8 Family Trust) (4,500) (4,500) (4,500) 4,500 Marketing Fees (5,000) (7,500) (10,000) (15,000) 0 Horse Maintaince & Grooming Exp (6,500) (4,200) (7,000) (5,600 Salaries & Wages (25,000) (30,000) (35,000) (42,000) Afforestation - grape seedlings (50,000) (50,000) (50,000) (50,000 13 Utilities (3,200) (4,500 (3,700) (5,600 Total Operating Expenses (147,000) (129,400) (131,500) (114,200 15 6 Net Operating Income (145,000) 95,700 110,472 212,716Retained Earnings Statement Statement as of Dec. 31 Year 1 Year 2 Year 3 Year 4 Retained Earnings Bop 9,985 196,429 473,616 Add/(Less): Net Income/(Loss) 9,985 186,445 277,187 2,423,341 Total 9,985 196,429 473,616 2,896,958 Less: Dividends Retained Earnings EoP 9,985 196,429 473,616 2,896,958Sources and Uses of Cash CHART Year 1 Year 2 Year 3 Year 4 PROPERTY Uses of Cash ACQUISITION FINANCING ACCOUNTS [Acquisition) Land 1,500,000 VALUE [ Asset Improvements) - Building 140,335 ADD [Asset Improvements) - Barn 20,000 SOURCES 4,500 JOURNAL TRIAL BALANCE Acquistion) Bearer Plants CASH FLOWS & Acquistion) Harvesting & Bottling Equipment ENTRIES BALANCE SHEET STATEMENT 40,000 USES Acquistion) Additional Supplies 5,000 [Acqusition) - Horses 60,000 NOI Acqusition) - Horse Equipment 8,000 PAID DIVIDENDS GAINLOSS PAID [Acquisition) - Furniture Equipment 16,000 CAPITAL VALUATION CALCULATION RETAINED [Ops Exp) Property Taxes - Paid by Trustee EARNINGS STATEMENT [Ops Exp) Insurance 2,000 2,000 2.000 (Ops Exp) Maintenance - Repairs/reinvest 35,000 15,000 5,000 [Ops Exp) Maintenance - Landscape 7,000 4,200 6,000 Ops Exp) Trustee Fees [Land Lease) 12,000 2.00 12,000 [Ops Exp) Land Lease Fees (Property Owned by Far 4,500 4,500 4,500 INCOME [Ops Exp) Marketing Fees 5,000 7,500 0,000 STATEMENT (Ops Exp) Salaries & Wage: 25,000 30,000 7,000 Ops Exp) Horses Grooming Expense 6,000 4,200 3,500 [Ops Exp) Afforestation - Grape Seedlings Replant 50,000 50,000 50,000 [Ops Exp) Utilities 3,200 4,500 3,700 Working Capital 36,750 [Interest) Trustee Loan 8,750 3,750 8,750 8,750 Construction Loan 464,500 [Interest) Construction Loan 13,935 13,935 13,935 ASSETS LIABILITIES ADR CRI + EQUITY [Debt Repayment) -Trustee Loan 175,000 | DR CRA J DR CRA Total Expected Cash Uses 2,302,970 156,585 126.385 473,250 CASH NOTES COMMON Sources of Cash PAYABLE STOCK Rental Revenue 216,000 272,160 280,325 BALANCE LAND ACCOUNTS RETAINED PAYABLE EARNINGS Construction Loan 464.500 SHEET Trustee Loan 75,000 30,240 31,147 ACCOUNTS RECEIVABLE Acquistrian Classes & Horse Rental Revenue 24,000 34,000 29,678 Wine and Distillary Sales 94.500 151,200 ng Capital 676,530 950,845 1,316,810 CASH FLOWS DR CRA ADR CRY Cash from Sell 5,430,994 STATEMENT INCOME Total Expected Cash Sources 879,500 1,107,430 1,443,195 6,747,804 STATEMENT REVENUES EXPENSES CASH FLOWS FROM OPERATIONS Net Cash Generated Before Equity [1,423,470) 950,845 1,316,810 6,274.554 CASH FLOWS FROM RETAINED INVESTING ADR CRV EARNINGS DIVIDENDS 2,100,000 CASH FLOWS FROM Calculated Equity Required [PPM Amount) FINANCING STATEMENT Calculated Equity Returned 2,100,000 Calculated Equity Dividend Net Equity 2,100,000 Expected Cash at year end 676,530 950,845 1,316,810 8,374.554Trial Balance mmm mmm Cul ASSET 384, 13 GENERAL LABRITY JOURNAL TRIAL EQUITY BALANCE EVENT DR CR CASH DR CR Raised can CASH 25,000 DR CR . . . . . . . . . . . . . . CASH . . . . . . . .. . . from brewton . . . . . . . . . . COMMON STOCK 25,000 COMMISH STOCK 25,900 Took out a loan CASH NOTES to purchase PATABLE property NOTES PAYABLE 21.008 LAND LAND 5.080 13,000 Purchased BUILDING BULDING 15,000 . . CASH 26,000 . . . . . . . . . . 34, 1 : . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16,241 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . .. . . .... . . . . . . . . . . . . . . . . . . . . . . . . . ... . . . .Value-Add Budget Units / SE Cost per Unit / SE Total Cost Purchase Price Property NA NA 1,500,000 Total Purchase Price 1.500,000 Improvements Costs Mold Remediation 3,500 SF $15 per SF 52,500 Kitchen Renovations 1,000 SF $50 per SF 50,000 Bathroom Renovations 400 SF $35 per SF 14.000 Floor Install 1,600 SF $8 per SF 12,800 Hardwood Floor Resurface (1st Floo 1,300 SF $12 per SF 15.600 Courtyard Install 1,000 SF $75 per SF 75,000 Brickoven Install 200 SF $22 per SF 4.400 Tasting Room & Hosting Addition 2.000 SF $35 per SF 70.000 Marble Countertops 450 SF $40 per SF 18,000 Marble Bathroom Floors 120 SF $20 per SF 2.400 Stable Addition to Barn 2 400 SF $10 per SF 24,000 Paint Custom Wallpaper 2.200 SF $3 per SF 6.600 Window Resurfacing 325 SF 17 per SF 2.275 Brick Limewashing 2,500 SF $2 per SF 5.000 Wine Cellar 400 SF $250 per SF 100,000 Chimney Renewal & Additions 80 SF $12 per SF 360 Crown Modeling 1,800 SF $6 per SF 10,800 Total Improvements 464.335 Appliances & Other Stainless Steel Refrigerator 1,500 EA 3.000 Antique Furniture Equipment 2.000 EA 16.000 Bearer Plants - Biological Asset 10,000 4 EA 40,000 Horses 4 15,000 EA 60,000 Horse Grooming Equipment 4 2,000 EA 8,000 Harvesting & Bottling Equipment 20,000 2 EA 40,000 Additional Supplies Inventory 10 500 EA 5.000 Wine Fridge Cooling Unit 9.000 EA 9,000 Total Appliances & Other 181,000 Total Budget 2.145.335