Projected Cash Flow. As can be seen from the Cash Flow chart and table below, ABC Company will have enough cash and credit available to carry it through some rough periods. As an S-Corporation with no employees, the company has very few mandatory expenses other than the salary requirements of the owner and the office mortgage and utilities. Cash Pro Forma Cash Flow FY 2006 FY 2007 FY 2008 FY 2009 FY 2010 Cash Received Cash from Operations Cash Sales $117,500 $152,500 $177,500 $205,000 $230,000 Cash from Receivables $97,833 $146,642 $173,316 $200,397 $225,816 Subtotal Cash from Operations $215,333 $299,142 $350,816 $405,397 $455,816 Additional Cash Received Sales Tax, VAT, HST/GST $0 $0 $0 $0 $0 Received New Current Borrowing $0 $0 $0 $0 $0 New Other Liabilities (interest- $0 $0 $0 $0 $0 free) New Long-term Liabilities $0 $0 $0 $0 $0 Sales of Other Current Assets $0 $0 $0 $0 $0 Sales of Long-term Assets $0 $0 $0 $0 $0 New Investment Received $0 $0 $0 $0 $0 Subtotal Cash Received $215,333 $299,142 $350,816 $405,397 $455,816 Expenditures FY 2006 FY 2007 FY 2008 FY 2009 FY 2010 Expenditures from Operations Cash spending $108,000 $120,000 $120,000 $120,000 $120,000 Bill Payments $66,623 $96,475 $112,512 $129,092 $144,426 Subtotal Spent on Operations $174,623 $216,475 $232,512 $249,092 $264,426 Additional Cash Spent Sales Tax, VAT, HST/GST Paid $0 $0 $0 $0 $0 Out Principal Repayment of Current $0 $0 $0 $0 $0 Borrowing Other Liabilities Principal $0 $0 $0 $0 $0 Repayment Long-term Liabilities Principal $0 $0 $0 $0 $0 Repayment Purchase Other Current Assets $0 $0 $0 $0 $0 Purchase Long-term Assets $0 $0 $0 $0 $0 Dividends $0 $0 $0 $0 $0 Subtotal Cash Spent $174,623 $216,475 $232,512 $249,092 $264,426 Net Cash Flow $40,710 $82,666 $118,304 $156,305 $191,390 Cash Balance $188,210 $270,877 $389,181 $545,486 $736,875 22
Projected Cash Flow. Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 REVENUE Phase 1 19,963,800 18,648,900 7,459,500 Phase 2 Subtotal - - - 19,963,800 18,648,900 7,459,500 - - - - - - - - Lot Premiums 8,331,500 3,482,600 1,393,000 Upgrade Revenue 798,600 745,900 298,400 Model Recovery TOTAL REVENUE - - - 29,093,900 22,877,400 9,150,900 - - - - - - - - PROJECT COSTS Land Pre-acq Costs - - - - - - - - - - - - - - Site Consultants - - - - - - - - - - - - - - Site Fees - - - - - - 3,856,000 - - - - - - - Site Improvements - - - - - - - - - - - - - - Podium - - - - - - - - - - - - - - Common Area 18,600 18,600 18,600 18,600 18,600 18,600 11,100 11,100 11,100 11,100 11,100 11,000 11,000 11,000 Development Costs 18,600 18,600 18,600 18,600 18,600 18,600 3,867,100 11,100 11,100 11,100 11,100 11,000 11,000 11,000 Directs - Ph 1 3,069,900 1,023,200 1,023,200 - - - - - - - - - - - Directs - Ph 2 - - - - - - 3,949,400 5,924,100 7,898,600 3,949,400 3,949,400 3,949,400 3,949,400 1,974,600 Upgrade Costs - - - 559,000 522,200 208,900 - - - - - - - - Bldg Permits & Fees - - - 696,000 633,000 253,000 6,626,000 - - - - - - - House Consultants 50,000 30,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 General Conditions 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 85,000 Warranty - - - 290,900 228,800 91,500 - - - - - - - - Model / SO Startup 150,500 150,000 150,000 150,000 - - - - - - - - - - Prop Tax / HOA / Other Legal 30,000 30,000 462,000 10,000 10,000 10,000 10,000 10,000 10,000 390,000 10,000 10,000 10,000 10,000 Insurance - 1,103,800 - - - - - - - - - - - 1,103,700 Interest / Fees 208,860 212,330 254,940 262,010 91,660 675,000 630,000 79,280 118,760 180,040 206,310 243,900 274,880 276,440 House Costs 3,594,260 2,634,330 1,980,140 2,057,910 1,575,660 1,328,400 11,305,400 6,103,380 8,117,360 4,609,440 4,255,710 4,293,300 4,324,280 3,454,740 OTHER COSTS Mgmt Fee - Hillwood 33,450 33,450 33,450 178,920 147,840 79,200 33,450 33,450 33,450 33,450 33,450 33,450 33,450 33,450 Mgmt Fee - TNHC 100,350 100,350 100,350 536,760 443,510 237,610 100,350 100,350 100,350 100,350 100,350 100,350 100,350 100,350 Commissions - - - 377,900 300,500 120,100 - - - - - - - - Closing Costs - - - 87,300 68,600 27,500 - - - - - - - - Mktg & Advertising 60,000 90,000 120,000 90,000 90,000 28,000 28,000 28,000 28,000 28,000 28,000 28,000 28,0...
Projected Cash Flow. Rem Rem Rem Rem Rem Rem Rem Rem Rem TOTAL Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Ph 2 LOAN SUMMARY Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% Interest Accrued 331,260 341,230 370,640 - - - - - - 2,422,740 Loan Fee 1.00% 630,000 Exit Fee 1.50% 945,000 945,000 Balance Outstanding 51,184,670 53,803,300 - - - - - - - Interest Funded 331,260 341,230 370,640 - - - - - - 2,422,740 Loan Fee Funded - - - - - - - - - 630,000 Ph 2 Draws 2,767,400 2,277,400 3,663,470 2,683,140 919,180 532,970 - - - 58,919,960 Paydowns - - (57,837,410) (2,683,140) (919,180) (532,970) - - - (61,972,700) Cash From (To) Ph 1 Loan 3,098,660 2,618,630 (53,803,300) - - - - - - - Ph 2 Loan Draws Draw Land - - - - - - - - - - - Dev’t Costs - - - - - - - - - - - Directs - Ph 2 1.00 1,974,600 1,974,600 - - - - - - - 39,493,500 Upgrades 1.00 - - 1,407,800 975,500 326,100 163,000 - - - 2,872,400 Bldg Permits 1.00 - - 630,000 500,000 - 33,000 - - - 7,789,000 House Consult 1.00 5,000 5,000 5,000 5,000 5,000 3,600 - - - 68,600 General Cond 1.00 85,000 85,000 85,000 85,000 85,000 75,000 - - - 1,180,000 Model/SO Startup 1.00 - - - - - - - - - - Prop Tax/Legal/Ins 1.00 500,000 10,000 10,000 10,000 10,000 1,000 - - - 2,104,700 Mgmt Fees 1.00 133,800 133,800 1,457,170 1,066,640 452,080 216,370 - - - 4,530,260 Sales & Mktg Period 1.00 69,000 69,000 68,500 41,000 41,000 41,000 - - - 881,500 Ph 2 Draws 2,767,400 2,277,400 3,663,470 2,683,140 919,180 532,970 - - - 58,919,960 Ph 2 Payoffs Revenues - - 66,168,500 46,641,700 15,913,900 10,836,600 - - - 139,560,700 Comm/Closing 1.60% - - (1,058,700) (746,300) (254,600) (173,400) - - - (2,233,000) Net Proceeds - - 65,109,800 45,895,400 15,659,300 10,663,200 - - - 137,327,700 Release % 100% 100% 100% 100% 100% 100% 100% Ph 2 Paydowns - - 65,109,800 45,895,400 15,659,300 10,663,200 - - - 137,327,700 Cumulative Paydowns - - 65,109,800 111,005,200 126,664,500 137,327,700 137,327,700 137,327,700 137,327,700 Remaining Commitment - Ph 2 63,000,000 63,000,000 - - - - - - - INTEREST SUMMARY Phase 1 Loan - - - - - - - - - 1,566,020 Phase 2 Loan 331,260 341,230 370,640 - - - - - - 2,422,740 Fees / Other - - - 93,040 - 945,000 - - - 2,793,040 Total Interest/Fees 331,260 341,230 370,640 93,040 - 945,000 - - - 6,781,800 TNHC Newport LLC Projected Cash Flow Proposed Budget 2/15/13 Total Cash Flow Est Feb-13 Est Mar-13 Est Apr-13 Rem May-13 Rem Jun-13 Rem Jul-13 Rem Aug-13 Rem Sep-13 Rem Oct-13 Rem Nov-13 Rem Dec-13 Rem Jan-1...
Projected Cash Flow. As with any business cash flow will have to be carefully monitored. After initial investment and start-up costs are covered the business will be viable. We have put implementations in place to monitor this such as, the only employee with a cash drawer will be the bar tender on duty to be counted by shift manager and bar tender before and after each shift. The wait staff will start each shift with a broke bank of $20.00 in their pocket. Sales receipts will be printed out at end of shift to be calculated by server and shift manager. With the initial investment of $250,000 of operating capital XxXxxxxxx'x does not anticipate any cash flow shortages. December and January will have a heavier drain of cash due to certain accounts payable being due. Chart: Cash Table: Financials Financials Beginning Balance Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Opening Balance Cash & Checking $0 $250,000 $485,350 $531,200 $582,500 $640,500 $698,939 $759,439 $819,918 $879,534 $939,886 $1,004,435 $1,072,695 Plus Money Received New Investment $0 $250,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 New Loans $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sales $70,000 $84,000 $92,500 $101,250 $102,500 $105,550 $108,345 $104,300 $107,567 $115,435 $123,431 $127,498 Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Subtotal Money Received $0 $320,000 $84,000 $92,500 $101,250 $102,500 $105,550 $108,345 $104,300 $107,567 $115,435 $123,431 $127,498 Less Money Spent Direct Costs Direct Cost of Sales $0 $10,000 $13,000 $15,400 $17,100 $17,840 $18,200 $19,876 $17,100 $19,440 $21,002 $23,421 $26,112 Other Costs of Sales $0 $2,000 $2,500 $3,150 $3,500 $3,571 $4,200 $5,340 $4,934 $5,125 $7,234 $9,100 $9,800 Normal Operating Expenses Payroll and Payroll Taxes, Benefits, Etc. $0 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 Rent and Utilities $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 Sales and Marketing Expenses $0 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 Other Operating Expenses $0 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 Other Outflows Payments of Taxes $0 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 Debt Payments $0 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 Purchase of Assets $0 $50,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Subtotal Money Spent $0 $84,650 $38,150 $41,200 $43,250 $44,061 $45,050 $47,866 $44,68...
Projected Cash Flow. The projected Cash Flow for five years is detailed in the table and chart following. In addition, it should be noted that Tay will establish relationships with vendors and/or representatives to determine the following to maintain cash flow: · Average price points - this will help ensure that a good mix of prices are maintained. · Delivery time frame & reliability - this will be crucial to ensure maximization of profits during the key shopping time frames. For Italian designers who may live up to the Italian notoriety for being late in deliveries, Tay will request the earliest possible delivery from them and also ensure they will be open to discounts if deliveries are late. · Shipping and transportation policies. · Market demand and turn rates - typically the vendor should know their end customer and be able to share that information so it aligns with my target market as well as helps me determine how much is appropriate to buy. · Payment terms and agreements -The goal is to be at Net 30 but I expect vendors to understand that Tay is a new boutique and will work with Tay to get the store at Net 30 terms with them within one season. Table: Cash Flow Pro Forma Cash Flow Cash Received Year 1 Year 2 Year 3 Year 4 Year 5 Cash from Operations Cash Sales Tsh.513,503 Tsh.599,403 Tsh.609,402 Tsh.620,315 Tsh.630,937 Subtotal Cash from Operations Tsh.513,503 Tsh.599,403 Tsh.609,402 Tsh.620,315 Tsh.630,937 Additional Cash Received Sales Tax, VAT , HST /GST Received Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 New Current Borrowing Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 New Other Liabilities (interest-free) Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 New Long-term Liabilities Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 Sales of Other Current Assets Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 Sales of Long-term Assets Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 New Investment Received Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 Subtotal Cash Received Tsh.513,503 Tsh.599,403 Tsh.609,402 Tsh.620,315 Tsh.630,937 Expenditures Year 1 Year 2 Year 3 Year 4 Year 5 Expenditures from Operations Cash Spending Tsh.131,000 Tsh.122,000 Tsh.137,500 Tsh.139,500 Tsh.146,000 Xxxx Payments Tsh.275,075 Tsh.410,353 Tsh.396,631 Tsh.410,034 Tsh.413,797 Subtotal Spent on Operations Tsh.406,075 Tsh.532,353 Tsh.534,131 Tsh.549,534 Tsh.559,797 Additional Cash Spent Sales Tax, VAT , HST /GST Paid Out Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 Principal Repayment of Current Borrowing Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 Other Liabilities Principal Repayment Tsh.0 Tsh.0 Tsh.0 Tsh.0 Tsh.0 Long-term Liabilities Pr...
Projected Cash Flow. The projected cash flow is expected to be positive by the end of year one. Fundraising efforts and grants received will aid our ability to generate enough revenue to continue our facility. As a non-profit entity, House of Chance plans to generate enough cash flow to pay staff and maintain our care home. Chart: Cash House of Chance Year 1 Year 2 Year 3 Opening Balance Cash and Checking $500 $99,660 $53,820 New Investments $500,000 $250,000 $250,000 Subtotal Money Received $500,500 $349,660 $303,820 Operating Expenses Advertising $8,400 $8,400 $8,400 Other Operating Expenses $12,000 $12,000 $12,000 Payroll $212,000 $212,000 $300,000 Purchase of Assets $0 $50,000 $50,000 Rent Utilities $12,000 $12,000 $12,000 Taxes $1,440 $1,440 $1,440 Subtotal Money Spent $245,840 $295,840 $383,840 Ending Balance Cash and Checking $99,660 $53,820 $80,020
Projected Cash Flow. Rem Rem Rem Rem Rem Rem Rem Rem Rem TOTAL Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 CASH FLOW SUMMARY Project Cash Flow (3,098,660) (2,618,630) 60,409,290 42,650,220 14,580,420 9,078,730 - - - 37,837,500 Other Loan - - - - - - - - - - Xx 0 Xxxx - - - - - - - - - - Xx 0 Loan 3,098,660 2,618,630 (53,803,300) - - - - - - - Contrib (Distrib) - Hillwood - - (4,293,906) (27,547,562) (7,452,425) (4,689,350) - - - (20,857,600) Contrib (Distrib) - TNHC - - (2,312,094) (15,102,738) (7,327,975) (4,689,350) - - - (16,979,900) Accts Rec - - - - - - - - - - A/P - - - - - - - - - - Accrued Liab - - - - - - - - - - Ending Cash Balance 500,040 500,040 500,030 499,950 299,970 - - - - - INPUT: Cash Target 500,000 500,000 500,000 500,000 300,000 - INPUT: Cash Contrib Req - - - - - - - - - 49,735,100 INPUT: Cash Avail for Distrib - - (6,606,000) (42,650,300) (14,780,400) (9,378,700) - - - (87,572,600) Net Investment CF - - 6,606,000 42,650,300 14,780,400 9,378,700 - - - 37,837,500 HILLWOOD INVESTMENT SUMMARY 65% 65% 65% 65% 65% 65% 65% 65% 65% Capital Contrib - - - - - - - - - (32,327,815) Capital Distrib - - 1,035,236 26,963,787 - - - - - 32,327,815 HW Net Capital - - 1,035,236 26,963,787 - - - - - - Investment Bal (27,999,023) (27,999,023) (26,963,787) - - - - - - Pref Distrib - - 3,258,670 - 269,640 - - - - 8,401,690 Profit Distrib - - - 583,775 7,182,785 4,689,350 - - - 12,455,910 Total Hillwood CF - - 4,293,906 27,547,562 7,452,425 4,689,350 - - - 20,857,600 Cumulative CF (23,125,643) (23,125,643) (18,831,737) 8,715,825 16,168,250 20,857,600 20,857,600 20,857,600 20,857,600 Peak 29,763,890 TNHC JV INVESTMENT SUMMARY 35% 35% 35% 35% 35% 35% 35% 35% 35% Contributions - - - - - - - - - (17,407,285) Distributions - - 557,434 14,518,963 - - - - - 17,407,285 TNHC Net Capital - - 557,434 14,518,963 - - - - - - Investment Bal (15,076,397) (15,076,397) (14,518,963) - - - - - - Pref Distrib - - 1,754,660 - 145,190 - - - - 4,523,990 Profit Distrib - - - 583,775 7,182,785 4,689,350 - - - 12,455,910 Total TNHC CF - - 2,312,094 15,102,738 7,327,975 4,689,350 - - - 16,979,900 Cumulative CF (12,452,257) (12,452,257) (10,140,163) 4,962,575 12,290,550 16,979,900 16,979,900 16,979,900 16,979,900 Peak 16,026,710 35.0% 35.0% 35.0% 36.3% 43.2% 44.9% 44.9% 44.9% 44.9% 7 of 22 TNHC Newport LLC Projected Cash Flow Proposed Budget 2/15/13 Total Cash Flow Est Est Est Rem Rem Rem Rem Rem Rem Rem Rem Rem Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13...
Projected Cash Flow. Rem Rem Rem Rem Rem Rem Rem Rem Rem TOTAL Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 UNIT FLOW SALES Xxxxx 0 - - - - 0 - - - - 00 Xxxxx 0 5 4 4 4 3 - - - - 53 Total Sales 5 4 4 4 4 - - - - 79 STARTS Phase 1 - - - - - - - - - 26 Xxxxx 0 - - - - - - - - - 00 Total Starts - - - - - - - - - 79 CLOSINGS Xxxxx 0 - - - - - 0 - - - 00 Xxxxx 0 - - 26 18 6 3 - - - 53 Total Closings - - 26 18 6 4 - - - 79 Backlog Xxxxx 0 - - - - 0 - - - - Xxxxx 2 38 42 20 6 3 - - - - Total Backlog 38 42 20 6 4 - - - - Inventory Xxxxx 0 0 0 0 0 0 - - - - Xxxxx 2 53 53 27 9 3 - - - - Total Inventory 54 54 28 10 4 - - - - COST FORECAST Warranty 1.00% - - 661,700 466,400 159,100 108,400 - - - 2,006,800 Total Warranty - - 661,700 466,400 159,100 108,400 - - - 2,006,800 Closing Costs 0.30% - - 198,500 139,900 47,700 32,500 - - - 602,000 Total Closing Costs - - 198,500 139,900 47,700 32,500 - - - 602,000 Broker Co-op 1.00% - - 661,700 466,400 159,100 108,400 - - - 2,006,800 Comm - House 0.22% - - 142,900 100,800 34,400 23,600 - - - 433,700 Comm - Design 3.00% - - 60,300 41,800 14,000 7,000 - - - 178,400 Total Commissions - - 864,900 609,000 207,500 139,000 - - - 2,618,900 TNHC Newport LLC Projected Cash Flow Proposed Total Cash Flow Budget 2/15/13 Est Feb-13 Est Mar-13 Est Apr-13 Rem May-13 Rem Jun-13 Rem Jul-13 Rem Aug-13 Rem Sep-13 Rem Oct-13 Rem Nov-13 Rem Dec-13 Rem Jan-14 Ph 1 LOAN SUMMARY Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% Interest Accrued 1,566,020 n/a - - - - - - 30,580 56,560 118,140 147,130 183,810 Loan Fee 1.00% 450,000 450,000 Exit Fee 1.50% 675,000 Balance Outstanding - - - - - - 4,438,600 8,483,880 17,149,540 22,069,180 26,681,810 30,317,920 Interest Funded 1,566,020 - - - - - - - 30,580 56,560 118,140 147,130 183,810 Loan Fee Funded - - - - - - - - - - - - - Ph 1 Draws 43,421,440 - - - - - - 4,438,600 4,014,700 8,609,100 4,801,500 4,465,500 3,452,300 Paydowns (44,987,460 ) - - - - - - - - - - - - Cash From (To) Ph 1 Loan - - - - - - - 4,438,600 4,045,280 8,665,660 4,919,640 4,612,630 3,636,110 Ph 1 Loan Draws Draw Land 1.00 - - - - - - - - - - - - - - Dev’t Costs 1.00 - 10,257,200 - - - - - - 4,438,600 3,655,900 1,995,300 18,600 18,600 18,600 Directs - Ph 1 1.00 - 20,465,500 - - - - - - - - 4,093,100 4,093,100 4,093,100 3,069,900 Upgrades 1.00 - 1,290,100 - - - - - - - - - - - - Bldg Permits 1.00 - 3,765,000 - - - - - - - - 2,183,000 - - - House Consult 1.00 - 520,000 - - - - - - - 100,000 80,000 80,...
Projected Cash Flow. Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Rem Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Ph 1 LOAN SUMMARY Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% Interest Accrued 208,860 212,330 254,940 262,010 91,660 - - - - - - - - - Loan Fee 1.00% Exit Fee 1.50% 675,000 Balance Outstanding 34,124,580 37,007,510 39,301,050 13,304,940 - - - - - - - - - - Interest Funded 208,860 212,330 254,940 262,010 91,660 - - - - - - - - - Loan Fee Funded - - - - - - - - - - - - - - Ph 1 Draws 3,597,800 2,670,600 2,038,600 2,370,280 1,996,150 966,310 - - - - - - - - Paydowns - - - (28,628,400 ) (15,392,750 ) (966,310 ) - - - - - - - - Cash From (To) Ph 1 Loan 3,806,660 2,882,930 2,293,540 (25,996,110 ) (13,304,940 ) - - - - - - - - - Ph 1 Loan Draws Draw Land 1.00 - - - - - - - - - - - - - - Dev’t Costs 1.00 18,600 18,600 18,600 18,600 18,600 18,600 - - - - - - - - Directs - Ph 1 1.00 3,069,900 1,023,200 1,023,200 - - - - - - - - - - - Upgrades 1.00 - - - 559,000 522,200 208,900 - - - - - - - - Bldg Permits 1.00 - - - 696,000 633,000 253,000 - - - - - - - - House Consult 1.00 50,000 30,000 5,000 5,000 5,000 5,000 - - - - - - - - General Cond 1.00 85,000 85,000 85,000 85,000 85,000 85,000 - - - - - - - - Model/SO Startup 1.00 150,500 150,000 150,000 150,000 - - - - - - - - - - Prop Tax/Legal/Ins 1.00 30,000 1,133,800 462,000 10,000 10,000 10,000 - - - - - - - - Mgmt Fees 1.00 133,800 133,800 133,800 715,680 591,350 316,810 - - - - - - - - Sales & Mktg Period 1.00 60,000 96,200 161,000 131,000 131,000 69,000 - - - - - - - - Ph1 Draws 3,597,800 2,670,600 2,038,600 2,370,280 1,996,150 966,310 - - - - - - - - Cumulative Costs 79,124,580 82,007,510 84,301,050 87,689,440 90,375,150 92,255,560 107,630,860 113,948,140 122,279,400 127,102,740 131,572,350 136,079,450 140,617,530 144,286,070 Cumulative Ph 1 Draws 34,124,580 37,007,510 39,301,050 41,933,340 44,021,150 44,987,460 44,987,460 44,987,460 44,987,460 44,987,460 44,987,460 44,987,460 44,987,460 44,987,460 Cumulative Equity 45,000,000 45,000,000 45,000,000 45,756,100 46,354,000 47,268,100 62,643,400 68,960,680 77,291,940 82,115,280 86,584,890 91,091,990 95,630,070 99,298,610 Ph 1 Payoffs Revenues - - - 29,093,900 22,877,400 9,150,900 - - - - - - - - Comm/Closing 1.60% - - - (465,500 ) (366,000 ) (146,400 ) - - - - - - - - Net Proceeds - - - 28,628,400 22,511,400 9,004,500 - - - - - - - - Release % 100% 100% 100...
Projected Cash Flow. The Business Plan calls for rapid co-development several leading-edge nutrient products, endorsed by Xx. Xxxx. These products contain some combination of the special Green Coffee Extract made from our own organic coffee which we grow in Panama, Nano Silver 10 PPM and High CBD Hemp Oil. As part of the project, Stage II, we are developing an experimental Hemp growing and processing center in Chile that will include laboratory, extraction equipment and greenhouses. The facility will spearhead the development of additional products and the growing of very high grade, high CBD hemp cultivars for the world market. The sales projected are merely pro forma and need to take into account the actual amount and therefore value of the products produced. We assume $200,000 cash available at the start and a total investment of $600,000. Certain first year costs are amortized equally over the first year, although they may be expended at different times in the development, so must be available at start-up. These include the following First Year expenses: Stage I
