Use the Chart attached in this question to get Income Statement, Cash Flow and Balance Sheet. you can also assume data if it is not included in the chart.

Tourism venture development Should be for either 6 or 12 months Services fees Less Cost of sales Cost of goods sold Gross Profit ANNUAL January February March April 440,000 100,000 20,000 40,000 20,000 60,000 380,000 20,000 80,000 5,000 15,000 10,000 30,000 5,000 15,000 52,000 432,000 25,000 105,000 3,000 18,000 6,000 36,000 3,000 18,000 Less Expenses Administrative Expenses Wages Rent Phone Insurance 80,000 16,000 1,600 4,000 10,000 2,000 200 500 10,000 2,000 200 500 10,000 2,000 200 500 10,000 2,000 200 500 Selling & Distribution Expenses Sales salaries Commission paid Delivery or tourism van expenses Advertising 800 300 22,500 650 100 100 10000 200 100 25 500 50 100 50 5000 100 100 25 500 50 Plus other income Commission Received Gross Earnings Financial Expenses Bad debts Interest Total Expenses Net Profit - 125,850 306,150 23,100 81,900 13,375 4,625 17,950 18,050 13,375 4,625 May June July Aug Sept Oct Nov Dec 20,000 20,000 20,000 40,000 20,000 20,000 20,000 100,000 5,000 15,000 5,000 15,000 5,000 15,000 5,000 35,000 5,000 15,000 5,000 15,000 5,000 15,000 20,000 80,000 3,000 18,000 3,000 18,000 3,000 18,000 6,000 41,000 3,000 18,000 3,000 18,000 3,000 18,000 25,000 105,000 10,000 2,000 200 500 10,000 2,000 200 500 10,000 2,000 200 500 10,000 2,000 200 500 10,000 2,000 200 500 10,000 2,000 200 500 10,000 2,000 200 500 10,000 2,000 200 500 100 25 500 50 100 25 500 50 100 25 500 50 100 25 5000 100 100 25 500 50 100 25 500 50 100 25 500 50 100 100 10000 200 - 13,375 4,625 13,375 4,625 13,375 4,625 17,925 23,075 13,375 4,625 13,375 4,625 13,375 4,625 23,100 81,900 Capital budget - new business venture Costs to purchase business Deposit or capital to finance acquisition of business Funds required to be financed by various sources Funding; Bank (bank may lend you up to 70% on exisiting business operations for new start ups they may lower Investors/friends (We, the team of this business is the investors and we invest NZD 20,000 each of us. ) NOTE 1: If the bank decided they want to lower the LVR to 50:50 or 60:40...it means you need to find additional NOTE 2: Deposit funded by each partner contributing approximately 50% of the deposit as capital - $250,000 pe Students should explain how much partners need to provide and also how the remaining funds are to be obtain Students should also explain how the loan is to be funded -from the bank or some from silent investors Establishment start-up budget List all things required to run and manage your business Assets Vehicle (new vehicle purchase) - signage Furniture and fixtures eg chairs/desks Office equipment eg photocopier/printer Computers Cost to buy - programme for online odering of sales ticketing (Sabre) Legal requirements - lawyer to plan partnership agreement Accounting fees (to prepare pro-forma budgest for lending from banks) Amount required to finance new business 4 1 4 80,000 80,000 0 erations for new start ups they may lower the LVR - loan to value ratio) 00 each of us. ) :40...it means you need to find additional funds from alternative investors. 0% of the deposit as capital - $250,000 per partner. how the remaining funds are to be obtained ank or some from silent investors - Total 200 500 1000 4000 5000 5000 800 500 4,000 4,000 5000 5000 19,300 Tourism venture development - cash flow budget ANNUAL January Cash balance at beg Income from operating revenue Ticket sales Accommodation sales Other operating revenue Event sales Cruises sales Total operating revenue Other sources of cash inflow Funds borrowed bank loan Tax refunds Total other sources of funds TOTAL MONTHLY CASH IN February March April May 0 10,000 27,000 31,000 26,000 150,000 300,000 40,000 80,000 5,000 10,000 10,000 20,000 5,000 10,000 5,000 10,000 150,000 95,000 695,000 40000 40000 200,000 5000 5000 25,000 10000 10000 50,000 5000 5000 25,000 5000 5000 25,000 - - - 2,000 2,000 - - 1,500 1,500 - 695,000 200,000 27,000 50,000 26,500 25,000 4,000 500 500 500 500 500 80,000 30,000 114,000 10,000 5,000 15,500 10,000 5,000 15,500 10,000 5,000 15,500 10,000 5,000 15,500 10,000 5,000 15,500 4,000 1,600 24,000 29,600 500 200 2,000 2,700 500 200 2,000 2,700 500 200 2,000 2,700 500 200 2,000 2,700 500 200 2,000 2,700 TOTAL MONTHLY CASH OUT 143,600 18,700 18,700 18,700 18,700 18,700 Net difference 551,400 181,300 8,300 31,300 7,800 6,300 Cash out Costs of operational software (SABR Labour cashflow outwards Wages PAYE Total operating cost Other expenses Power/water/rates Phone/internet Building/office rent Total other expenses June July Aug Sept Oct Nov Dec 15,000 15,000 16,000 16,000 16,000 16,000 16,000 - 5,000 10,000 5,000 10,000 20,000 40,000 5,000 10,000 5,000 10,000 5,000 10,000 40,000 80,000 5000 5000 25,000 5000 5000 25,000 20000 20000 100,000 5000 5000 25,000 5000 5000 25,000 5000 5000 25,000 40000 40000 200,000 1,000 1,000 - - 2,000 -2,000 -- - 1,500 1,500 - 1,000 1,000 26,000 25,000 102,000 25,000 26,500 25,000 201,000 500 500 500 500 500 500 500 10,000 5,000 15,500 10,000 5,000 15,500 10,000 5,000 15,500 10,000 5,000 15,500 10,000 5,000 15,500 10,000 5,000 15,500 10,000 5,000 15,500 500 200 2,000 2,700 500 200 2,000 2,700 500 200 2,000 2,700 500 200 2,000 2,700 500 200 2,000 2,700 500 200 2,000 2,700 500 200 2,000 2,700 18,700 18,700 18,700 18,700 18,700 18,700 16,000 7,300 6,300 83,300 6,300 7,800 6,300 185,000 AnnuallyExpected Customers Dec Jan Aug Mar AnnuallyExpected Customers 400 400 200 100 Tourism venture development Cash Flow Statement For year ended $ Cash from Operating Activites Ticket sales 150,000.00 Accommodation 300,000.00 Event sales 150,000.00 Cruises sales Total Operating Activites Cash from Investing Activites Cost of operational software wages Paye 95,000.00 695,000.00 4,000.00 80,000.00 30,000.00 114,000.00 Cash from Financing Activites Power/water/rates payable Phone/internet payable Building/Office rent payable 4,000.00 1,600.00 24,000.00 29,600.00 Tourism venture development Income Statement For the year Sales $ 440,000.00 Cost of goods sold Gross profit (60,000.00) 380,000.00 Commision Received Gross earining 52,000.00 432,000.00 Administative Expenses Administartative expenses Wages Phone (80,000.00) (16,000.00) (1,600.00) Insurance Selling & Distrubition Expenses Sales salaries Commision Paid Delivery or tourism van expenses Advertisment Net Profit (4,000.00) (800.00) (300.00) (22,500.00) (650.00) 306,150.00 Tourism venture development Balance Sheet As at ............ $ Assets Furniture & Fitting Office Equipment 800.00 500.00 Computers Total Current Assets Accounts Payable 4,000.00 5,300.00 14,000.00 Other Assest Total Assets 60,700.00 80,000.00 LIBILITIES AND SHAREHOLDERS EQUITY Total Shareholders' Equity Total Liabilities and Shareholders Equity 80,000.00 80,000.00