please help answer #3 cost-benefit analysis with the all of the information given above. it is supposed to be done on an excel sheet. if u can provide equations that would be perfect. thank u, i appreciate your help.

Assignment 2: Cost-Benefit Analysis Using Excel Task Description You are the CFO of a start-up company called Trucks260, Your company is preparing a business plan to get investment from angel investors and other venture capitalists, and you are responsible for the cost benefit analysis portion of the business plan. The company's business model is essentially serving as an "Uber" platform for truck rentals, pairing people who have trucks (pickups, vans, and even larger vehicles like moving vans) with people who need a short-term rental. Your task in this assignment is mainly concerned with the revenue model of Trucksz.6o, which takes data input from other elements of Truckz. Go's business model. Your company provides detailed descriptions of Truks 260 's value proposition, competitive analysis, and marketing strategies in other sections of the business plan. Note: all numbers and required calculations in this assignment are simplified to suit the purpose of this assignment. In your group project, you will nced to provide detalled justification and calculations for any numbers you have in your cost-benefit analysis, based on your value proposition, marketing research/strategies and your competitive analysis. A. Cost Assumptions: The initial target market for the business is the city of Los Angeles. Truckszgo needs funding for scting up its Inspection Center (for interviewing its gig-workers and inspecting their vehicles), the Trucks 260 app, the website development, marketing, personnel, etc. The following are the cost assumptions: 1. An inspection Center needs to be created, which will cost $100,000 in the first year. 2. The initial website development will cost $200,000 in the first year. 3. The initial Trucks 260 app development will cost $400,000. 4. The initial eCommerce back-end Database System development including cloud hosting services will cost $700,000 in the first year. 5. The operation cost of the Trucks 26 o system, including website/app/back-end upkeep and admin personnel will be a total of $300,000 in the first year, it is this low because it will only be operational for 3 months in a small test market. The operation cost will increase to $500,000 for Year 2 . After that the annual increase will be 40x (cost for year 3 is 40 sincrease from year 2 , and year 4 is 40% increase from year 3 ). 6. Additional infrastructure costs (such as building rental, office equipment, etc): first ycar will be $100,000, and this is projected to increase by 30s per year over the previous year for years 2,3,4, and 5 . 7. Personnel costs: the first year will be just $200,000 (as all executives are not initially taking salary), the second year will be $500,000. After that the annual increase will be 35% for year 3 , 30% for year 4 , and 20% for Year 5 . 8. Marketing costs: these are estimated to be $500,000 for the first year. After that the annual increases will be 10% for Year 2, 15% for Year 3,20% for Year 4 , and 20% for Year 5 . The founders of the company have secured a small business startup loan to help start the company. The loan is secured on the physical assets of the inspection Center and a founder's personal assets. The loan will cover the initial investment of $100,000 in the inspection Center and initial app development of $400,000 (which is planned to be outsourced). This is a 5 year loan, with an annual interest rate of 6% and a monthly payment is scheduled for payback. 8. Revenue Stream Assumptions: Trucks2 6 o has already done substantial market analysis and survers. Based on this research there are two major revenue streams anticipated: 1. Transaction fees: Trucks 260 's major source of revenue will be eamed by taking a 35% cut of the transaction amount (which is on par with Uber and tytt's cut). Eased on their extensive marketing reseatch for the Southern California region, the transaction total is estimuted to be $350,000 in the first year as the company is testing out the market, recruiting users, and roiling out the app. The second year is estimated to be $5 mition, and will continue to increase: by 605 over year 2 for year 3 , by 60 over ovear 3 for Year 4 , and by 40 os over year 4 for Year 5 . 2. Affiliate marketing revenue: it is estimated that the compary will begin to have affillate marketing revenue of $10,000 in Year 2 and this ts estimated to increase each year over the previous year by 25%. Assignment Dellverables You will create your analysis using 5 worksheets contained in a single spreadsheet. You must parameterize each variable (e g., define and document each varlable outside of a formula) in the spreadsheet for easy "what if" analysis and also for readability of your spreadsheet. 1. Cover Page: Use a textbox for specitying the titie of your report, your name and the date. 2. Executive Summary: Summarize the purpose of the analysis, the content of your worksheets, and your final recommendation to investors in terms of whether this is a good investment. Aso, indicate-based on your what if analysis (see below) what would be the effects on the breakeven point if the marketing costs were $800.000 in the first year, resulting in transaction revenue of $6 million in year 2 , and if this would change your recommendation to investors. 3. Cost-benefit Analysis: This sheet should include: - an appropriate titie for this analysis and, on the second line, type '8us312, cyour names, ctoday's date>". The title should be centered and large. - the structure of the cost-benefit analysis should be similar to-but not exoctly the same os-the one on page 353 of the course text book: - the interest cost for each vear in your calculation, (Hint: your monthly payment is not your cost). - a break-even analysis chart. In your spreadsheet, you should indicate which year is the breakeven year by using the if function in Excel. Print "Greakeven year" below that cell only. - a professional recommendation regarding your proposal based on the cost benefit analysis (and this should atso be included in the Executive Summary). 4. Loan: - the calculation of the monthly payment for the loan - an amortization table including the vearly interest cost for the ioan. You can use Excel's PMr function for this purpose. Assignment 2: Cost-Benefit Analysis Using Excel Task Description You are the CFO of a start-up company called Trucks260, Your company is preparing a business plan to get investment from angel investors and other venture capitalists, and you are responsible for the cost benefit analysis portion of the business plan. The company's business model is essentially serving as an "Uber" platform for truck rentals, pairing people who have trucks (pickups, vans, and even larger vehicles like moving vans) with people who need a short-term rental. Your task in this assignment is mainly concerned with the revenue model of Trucksz.6o, which takes data input from other elements of Truckz. Go's business model. Your company provides detailed descriptions of Truks 260 's value proposition, competitive analysis, and marketing strategies in other sections of the business plan. Note: all numbers and required calculations in this assignment are simplified to suit the purpose of this assignment. In your group project, you will nced to provide detalled justification and calculations for any numbers you have in your cost-benefit analysis, based on your value proposition, marketing research/strategies and your competitive analysis. A. Cost Assumptions: The initial target market for the business is the city of Los Angeles. Truckszgo needs funding for scting up its Inspection Center (for interviewing its gig-workers and inspecting their vehicles), the Trucks 260 app, the website development, marketing, personnel, etc. The following are the cost assumptions: 1. An inspection Center needs to be created, which will cost $100,000 in the first year. 2. The initial website development will cost $200,000 in the first year. 3. The initial Trucks 260 app development will cost $400,000. 4. The initial eCommerce back-end Database System development including cloud hosting services will cost $700,000 in the first year. 5. The operation cost of the Trucks 26 o system, including website/app/back-end upkeep and admin personnel will be a total of $300,000 in the first year, it is this low because it will only be operational for 3 months in a small test market. The operation cost will increase to $500,000 for Year 2 . After that the annual increase will be 40x (cost for year 3 is 40 sincrease from year 2 , and year 4 is 40% increase from year 3 ). 6. Additional infrastructure costs (such as building rental, office equipment, etc): first ycar will be $100,000, and this is projected to increase by 30s per year over the previous year for years 2,3,4, and 5 . 7. Personnel costs: the first year will be just $200,000 (as all executives are not initially taking salary), the second year will be $500,000. After that the annual increase will be 35% for year 3 , 30% for year 4 , and 20% for Year 5 . 8. Marketing costs: these are estimated to be $500,000 for the first year. After that the annual increases will be 10% for Year 2, 15% for Year 3,20% for Year 4 , and 20% for Year 5 . The founders of the company have secured a small business startup loan to help start the company. The loan is secured on the physical assets of the inspection Center and a founder's personal assets. The loan will cover the initial investment of $100,000 in the inspection Center and initial app development of $400,000 (which is planned to be outsourced). This is a 5 year loan, with an annual interest rate of 6% and a monthly payment is scheduled for payback. 8. Revenue Stream Assumptions: Trucks2 6 o has already done substantial market analysis and survers. Based on this research there are two major revenue streams anticipated: 1. Transaction fees: Trucks 260 's major source of revenue will be eamed by taking a 35% cut of the transaction amount (which is on par with Uber and tytt's cut). Eased on their extensive marketing reseatch for the Southern California region, the transaction total is estimuted to be $350,000 in the first year as the company is testing out the market, recruiting users, and roiling out the app. The second year is estimated to be $5 mition, and will continue to increase: by 605 over year 2 for year 3 , by 60 over ovear 3 for Year 4 , and by 40 os over year 4 for Year 5 . 2. Affiliate marketing revenue: it is estimated that the compary will begin to have affillate marketing revenue of $10,000 in Year 2 and this ts estimated to increase each year over the previous year by 25%. Assignment Dellverables You will create your analysis using 5 worksheets contained in a single spreadsheet. You must parameterize each variable (e g., define and document each varlable outside of a formula) in the spreadsheet for easy "what if" analysis and also for readability of your spreadsheet. 1. Cover Page: Use a textbox for specitying the titie of your report, your name and the date. 2. Executive Summary: Summarize the purpose of the analysis, the content of your worksheets, and your final recommendation to investors in terms of whether this is a good investment. Aso, indicate-based on your what if analysis (see below) what would be the effects on the breakeven point if the marketing costs were $800.000 in the first year, resulting in transaction revenue of $6 million in year 2 , and if this would change your recommendation to investors. 3. Cost-benefit Analysis: This sheet should include: - an appropriate titie for this analysis and, on the second line, type '8us312, cyour names, ctoday's date>". The title should be centered and large. - the structure of the cost-benefit analysis should be similar to-but not exoctly the same os-the one on page 353 of the course text book: - the interest cost for each vear in your calculation, (Hint: your monthly payment is not your cost). - a break-even analysis chart. In your spreadsheet, you should indicate which year is the breakeven year by using the if function in Excel. Print "Greakeven year" below that cell only. - a professional recommendation regarding your proposal based on the cost benefit analysis (and this should atso be included in the Executive Summary). 4. Loan: - the calculation of the monthly payment for the loan - an amortization table including the vearly interest cost for the ioan. You can use Excel's PMr function for this purpose