Can somebody please help me with this business question? I have provided the pictures of the question and the formulas required to answer it please. Please help if you can thank you very much!

Required Information INSTRUCTIONS: Before completing each of the activities that follow, read the following Closer Look on Voluntrip, which describes the company's financial projections. Also, before submitting each chart, be sure to print the screen or copy and paste each chart into an Excel spreadsheet, as you will need to refer to these charts throughout A Closer Look: Voluntrip Voluntrip-Financial Projections An, 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 Unt$ _ one day of travel; average length of travel 1421 days) Monthly Sales Projection: 50 trips (over a period of 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 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 am to 5:00p.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 Income Statement Formula Cost Cost Units Sold Units Sold Selling Price per Unit Selling Price per Unit Total Sales (units sold selling price) Total Sales (units sold selling price) COGS per unit (from economics of one unit chart) COGS per unit (from economics of one unit chart) Total COGS (from COGS per unit units solid) Total COGS (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 (from same chart as fixed costa) Variable Costs (from same chart 2: fixed costs) Total Operating costs (fixed + variable costs) Total Operating costs (fixed-variable costs) Profit Before taxes (gross profit - Operating costs) Profit Before taxes gross profit - operating costs) Estimated taxes @ 25% (profit before taxes * 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) Required Information INSTRUCTIONS: Before completing each of the activities that follow, read the following Closer Look on Voluntrip, which describes the company's financial projections. Also, before submitting each chart, be sure to print the screen or copy and paste each chart into an Excel spreadsheet, as you will need to refer to these charts throughout A Closer Look: Voluntrip Voluntrip-Financial Projections An, 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 Unt$ _ one day of travel; average length of travel 1421 days) Monthly Sales Projection: 50 trips (over a period of 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 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 am to 5:00p.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 Income Statement Formula Cost Cost Units Sold Units Sold Selling Price per Unit Selling Price per Unit Total Sales (units sold selling price) Total Sales (units sold selling price) COGS per unit (from economics of one unit chart) COGS per unit (from economics of one unit chart) Total COGS (from COGS per unit units solid) Total COGS (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 (from same chart as fixed costa) Variable Costs (from same chart 2: fixed costs) Total Operating costs (fixed + variable costs) Total Operating costs (fixed-variable costs) Profit Before taxes (gross profit - Operating costs) Profit Before taxes gross profit - operating costs) Estimated taxes @ 25% (profit before taxes * 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)