James Register

Tide Mill Resort Tide Mill Project Budget Starting Balance Total Income Total Expenses NET (Income - Expenses) Projected End Balance INCOME MONTHLY Current and After Repair Rents Room Rentals Dry Storage Daily Use Fees Retail Sales Subtotal 3,400,000 6,100 1,800,000 (1,793,900) 1,606,100 0 6,000 10,100 133,400 (123,300) 1,482,800 14,100 111,500 (97,400) 1,385,400 17,100 227,400 (210,300) 1,175,100 26,600 381,500 (354,900) 820,200 33,150 373,000 (339,850) 480,350 39,700 272,000 (232,300) 248,050 1 2 3 4 5 6 100 11,000 3,000 100 14,000 3,000 100 16,000 3,000 100 18,500 3,000 150 21,- 6,100 10,100 14,100 17,100 19,100 21,650 Subtotal -0 Total INCOME 6,100 EXPENSES MONTHLY 0 Loan payoff and closing costs Lynk Financial Rialto Capital Payment Impound Closing cost allowance 1% court fee Subtotal Drawings and Permits: Lodge RV Campsites Marina Septic Building 7, pool Subtotal Fences and Gates 2 Entry Gates Gate openers 300 feet metal fence Car posts Dry storage fence Labor Subtotal Demolition Lodge Tank removal Tree removal Labor Subtotal Septic Repair Building 2 RV Campsites Building 7 and 8 rough in Lodge tank and pipe to lot 92 Building 5 and 6 Subtotal Building Remodel Building 2 Brick house Building 4 Garage Building 5 Block house deck Building 6 Villa deck Building 8 Pier House Building 1 Lodge Building 7 Clubhouse Building 3 Boathouse 7 8,500 1,500 100 Lodge Leases Boat Slips RV Campsites Event sales 1,100,000 300,000 300,000 86,000 14,000 1,800,000 -0 -0 -0 55,300 78,200 (22,900) 225,150 64,200 92,900 (28,700) 196,450 8 67,700 94,000 (26,300) 170,150 9 70,100 80,000 (9,900) 160,250 10 72,600 71,500 1,100 161,350 11 87,400 50,000 37,400 198,750 12 Total 21,700 23,-,800 26,-,000 27,700 28,-,000 31,200 31,-,000 33,600 33,500 1,-,000 37,100 47,800 3,-,000 52,900 285,300 20,500 1,850 9,500 317,150 7,500 2,000 9,500 6,500 11,500 10,000 6,500 14,000 7,500 11,500 18,000 30,500 10,000 6,500 15,000 5,000 36,500 10,000 6,500 15,000 5,000 36,500 10,000 6,500 15,000 5,000 36,500 10,000 6,500 14,000 5,000 35,500 10,000 2,000 12,500 10,000 34,500 60,000 43,000 114,000 30,000 247,000 564,150 10,100 14,100 17,100 26,600 33,150 39,700 55,300 64,200 67,700 70,100 72,600 87,400 1 2 3 4 5 6 7 8 9 10 11 12 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 Total -0 1,100,000 300,000 300,000 86,000 14,000 1,800,000 -0 19,000 19,000 9,000 9,000 18,000 -0 74,000 -0 5,000 3,000 12,000 3,900 12,500 8,000 44,400 -0 36,000 1,500 4,000 5,000 46,500 -0 18,000 15,000 18,900 20,500 8,000 80,400 19,000 19,000 9,000 9,000 18,000 -0 74,000 -0 5,000 3,000 12,000 3,900 12,500 8,000 44,400 -0 -0 36,000 1,500 4,000 5,000 46,500 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 18,000 15,000 18,900 20,500 -0 ► More Business Templates ► Project Management Templates ► More Budget Templates -0 33,000 18,900 20,500 15,000 15,000 15,000 10,000 8,000 8,000 -0 -0 -0 -0 -0 -0 21,000 9,000 8,000 202,000 38,000 198,000 198,000 90,000 13,200 1 80,000 71,500 55,000 21,000 9,000 8,000 38,000 598,000 241,500 13,200 -0 Subtotal Site Amenities RV utilities and pads RV site showers Pool and spa Gazebo at the point Grading and paving Labor and equipment rental -0 Subtotal Marina repairs Bulkheads Boat slips Piers Gas pumps Jetty Floating docks -0 Subtotal 10% construction contingency ($334,600) Total EXPENSES 1,800,000 15,000 32,000 15,000 212,000 236,000 198,000 34,200 -0 90,000 80,000 71,500 -0 55,000 9,500 50,000 3,900 -0 -0 4,000 68,500 50,000 4,000 54,000 45,000 4,000 49,000 4,000 4,000 4,000 4,000 4,000 7,900 4,000 4,000 -0 -0 50,000 125,000 95,000 80,000 70,000 40,000 -0 133,400 -0 111,500 125,000 95,000 80,000 70,000 40,000 85,000 85,000 227,400 381,500 373,000 272,000 78,200 92,900 2 -0 94,000 -0 80,000 -0 71,500 -0 334,600 384,600 983,700 55,000 9,500 -0 3,900 95,000 28,000 241,400 125,000 95,000 80,000 70,000 40,000 85,000 495,000 4,100,000 This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel. Numbers Sheet Name Numbers Table Name Excel Worksheet Name Table 1 Tide Mill Project Budget Table 1 Help Tide Mill Project Budget Help 1 HELP https://www.vertex42.com/ExcelTemplates/project-budget.html Terms of Use Do not submit copies or modifications of this template to any website or online template gallery. Please review the following license agreement to learn how you may or may not use this template. Thank you. See License Agreement https://www.vertex42.com/licensing/EULA_privateuse.html Instructions / Tips This project budget is for recording how much you will be spending each month of the project. You can add or remove columns, depending on the length of your project. When adding columns, copy an existing column and insert the copied column. This will help ensure that the subtotal formulas are copied correctly. Check the formulas in the Total column to make sure the that SUM() formulas reference the correct range of cells. The column labels (1, 2, 3, 4, ...) are arbitrary, so you could change them to be "Jan, Feb, ..." if you want to. When adding new rows, copy an existing row and insert the copied row, so that the formulas in the grey Total column is copied also. Always check the formulas for the Subtotals to ensure that the SUM() formula is referencing the correct range of cells. Any time you add or remove a major category, you will need to update the formulas for the Total Income and Total Expenses, to make sure that the Total correctly adds all the appropriate category subtotals. After adding appending new categories to the bottom of the worksheet, you may need to redefine the print area to include the new rows. (File > Print Area > Set Print Area) If you see "#####" in a cell, it means you need to widen the column to see the value. 1 2 ©- Vertex42.com lates/project-budget.html 3 4