Voluntrip-Financial Projections Ari, Luiz, and Sarita are extremely excited about getting Voluntrip underway. Each owner has agreed to invest $5,000 to start the business, but each also understands that additional capital will be required to sustain the business in the long run. The owners have identified some of the financial needs of the business, and would like your help in capturing the capital needed into the appropriate financial components. The following line items have been identified by Voluntrip, but each item will have to be broken down further to display individual cost components. Startup Capital: $ 15,000 Cost of Supplies: $4.15 (each unit); this will vary based on actual calculations Economics of One Unit: $_ (one day of travel; average length of travel 1421 days) Monthly Sales Projection: 50 trips (over a period of 6 months) Operating Costs: ___ (Based on economics of one unit; fixed and variable) Startup Investment Needed: 25%-35% of projected annual profit . Each Voluntrip tour package will include: . Customized travel itineraries Hotel/hostel accommodations Travel concierge services (point-to-point) Native tour guides Online customer account management Passport and Customs services Currency conversion and currency exchange services Meal package 0 O Air travel package Convenient online booking options Virtual travel meeting services Ground transportation options Convenient payment options AAA, military, AARP discounts Extended Customer Service Hours (6:00 a.m. to midnight EST, Monday - Friday; 8:00 a.m. to 5:00 p.m. Saturday and Sunday) 7. PRACTICE: Create a projected monthly/annual income statement. INSTRUCTIONS: After reading Voluntrip's financial projections, create a projected monthly/annual income statement. Refer back to the numbers determined in Practice Activities 2, 3, 4, 5, 6, and 7 as needed. You will need to calculate all items. The formula for each item has been provided in the Formula columns. Note, too, that you need to multiply the monthly amounts by 12 to calculate the projected yearly income statement. Do not assume that all amounts are constant. Before submitting the chart, be sure to print the screen or copy and paste the chart into an Excel spreadsheet, as you will need to refer to this chart again later. Projected Monthly Projected Yearly Income Statement Formula Cost Income Statement Formula Cost Units Sold Units Sold Selling Price per Unit Selling Price per Unit Total Sales (units sold x selling price) Total Sales (units sold x selling price) COGS per unit (from economics of one unit chart) COGS per unit (from economics of one unit chart) Total COGS Total COGS (from COGS per unit x units solid) (from COGS per unit x units solid) Gross Profit (sales - COGS) Gross Profit (sales COGS) Fixed Costs Fixed Costs (from monthly operating costs chart) (from monthly operating costs chart) Variable Costs Variable Costs (from same chart as fixed costs) (from same chart as fixed costs) Total Operating Costs (fixed + variable costs) Total Operating Costs (fixed + variable costs) Profit Before taxes Profit Before taxes (gross profit - operating costs) (gross profit - operating costs) Estimated taxes @ 25% (profit before taxes x 25%) Estimated taxes @ 25% (profit before taxes x 25%) Net Profit / Net Loss (profit before taxes taxes) Net Profit / Net Loss (profit before taxes taxes) Voluntrip-Financial Projections Ari, Luiz, and Sarita are extremely excited about getting Voluntrip underway. Each owner has agreed to invest $5,000 to start the business, but each also understands that additional capital will be required to sustain the business in the long run. The owners have identified some of the financial needs of the business, and would like your help in capturing the capital needed into the appropriate financial components. The following line items have been identified by Voluntrip, but each item will have to be broken down further to display individual cost components. Startup Capital: $ 15,000 Cost of Supplies: $4.15 (each unit); this will vary based on actual calculations Economics of One Unit: $_ (one day of travel; average length of travel 1421 days) Monthly Sales Projection: 50 trips (over a period of 6 months) Operating Costs: ___ (Based on economics of one unit; fixed and variable) Startup Investment Needed: 25%-35% of projected annual profit . Each Voluntrip tour package will include: . Customized travel itineraries Hotel/hostel accommodations Travel concierge services (point-to-point) Native tour guides Online customer account management Passport and Customs services Currency conversion and currency exchange services Meal package 0 O Air travel package Convenient online booking options Virtual travel meeting services Ground transportation options Convenient payment options AAA, military, AARP discounts Extended Customer Service Hours (6:00 a.m. to midnight EST, Monday - Friday; 8:00 a.m. to 5:00 p.m. Saturday and Sunday) 7. PRACTICE: Create a projected monthly/annual income statement. INSTRUCTIONS: After reading Voluntrip's financial projections, create a projected monthly/annual income statement. Refer back to the numbers determined in Practice Activities 2, 3, 4, 5, 6, and 7 as needed. You will need to calculate all items. The formula for each item has been provided in the Formula columns. Note, too, that you need to multiply the monthly amounts by 12 to calculate the projected yearly income statement. Do not assume that all amounts are constant. Before submitting the chart, be sure to print the screen or copy and paste the chart into an Excel spreadsheet, as you will need to refer to this chart again later. Projected Monthly Projected Yearly Income Statement Formula Cost Income Statement Formula Cost Units Sold Units Sold Selling Price per Unit Selling Price per Unit Total Sales (units sold x selling price) Total Sales (units sold x selling price) COGS per unit (from economics of one unit chart) COGS per unit (from economics of one unit chart) Total COGS Total COGS (from COGS per unit x units solid) (from COGS per unit x units solid) Gross Profit (sales - COGS) Gross Profit (sales COGS) Fixed Costs Fixed Costs (from monthly operating costs chart) (from monthly operating costs chart) Variable Costs Variable Costs (from same chart as fixed costs) (from same chart as fixed costs) Total Operating Costs (fixed + variable costs) Total Operating Costs (fixed + variable costs) Profit Before taxes Profit Before taxes (gross profit - operating costs) (gross profit - operating costs) Estimated taxes @ 25% (profit before taxes x 25%) Estimated taxes @ 25% (profit before taxes x 25%) Net Profit / Net Loss (profit before taxes taxes) Net Profit / Net Loss (profit before taxes taxes)