please help answer #4 loan 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 Dercription You are the CFO of a start up company called Trucks2 60 . 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 truciss (pickups, vans, and even larger vehicles like moving vans) with people who need a shortterm rental. Your task in this assignment is mainly concemed with the revenue model of Trucks26o, which takes data input from other elements of Truck2 G0 's business model. Your company provides detalled descriptions of Truks 2GO 's value proposition, competitive anslysis, 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 need to provide detalied justification and calculations for any numbers you have in your cost-benefit analysis, based on your volue proposition, marketing research/strategies and your competitive analysis. A. Cost Assumptions: The initial target market for the business is the city of los Angeles. Trucks 2 go needs funding for setting up its Inspection Center (for interviewing its gig.workers and inspecting their vehicles), the Trucks2:60 app, the webrite. 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 Trucks260 app development will cost $400,000. 4. The initial ecommerce backend Database System development including cloud hosting services will cost $700,000 in the first year. 5. The operation cost of the Trucksz 6 o system, including website/app/backend 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 40% (cost for year 3 is 400 increase from year 2 , and year 4 is 40 . increase from year 3 ). 6. Additional infrastructure costs (such as bullding rental, office equipment, etc): first year will be $100,000, and this is projected to increase by 300 per year over the previous year for Years 2,3,4, and 5 . 7. Personnel costs: the first year will be just 5200,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: Trucks2Go has already done substantial market analysis and surveys. Eased on this research there are two major revenue streams anticipated: 1. Transaction fees: Trucks 2 Go's major source of revenue will be eamed by taking a 3535 cut of the transaction amount (which is on par with Uber and tytt's cut). Based on their extensive marketing research for the Southern California region, the transaction total is estimated to be $350,000 in the first vear as the company is testing out the market, recruiting users, and rolling out the app. The second year is estimated to be $5 milion, and will continue to increase: by 605 over year 2 for year 3 , by 60 os over Year 3 for year 4 , and by 40 over year 4 for year 5 . 2. Affilsate marketing revenue: it is estimated that the company will begin to have affiliate marketing revenue of $10,000 in Year 2 and this 6 estimated to increase esch year over the previous year by 25% Assignment Delluerables You will create your analysis using 5 worksheets contained in a single spreadsheet. You must parameterize each variable (es. 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 workheets, and your final recommendation to investors in terms of whether this is a good investment. Also, 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 indude: - an appropriate titie for this analysis and, on the second line, type "8us312, cyour names, ctoday's dates". The title should be centered and large. - the structure of the cost-benefit analysis should be similar to-but not exoctly the same as-the one on page 353 of the course text book. - the interest cost for each vear in your calculation, (Hint: your monthyy 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 "Breakeven year" below that cell anly. - 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 Dercription You are the CFO of a start up company called Trucks2 60 . 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 truciss (pickups, vans, and even larger vehicles like moving vans) with people who need a shortterm rental. Your task in this assignment is mainly concemed with the revenue model of Trucks26o, which takes data input from other elements of Truck2 G0 's business model. Your company provides detalled descriptions of Truks 2GO 's value proposition, competitive anslysis, 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 need to provide detalied justification and calculations for any numbers you have in your cost-benefit analysis, based on your volue proposition, marketing research/strategies and your competitive analysis. A. Cost Assumptions: The initial target market for the business is the city of los Angeles. Trucks 2 go needs funding for setting up its Inspection Center (for interviewing its gig.workers and inspecting their vehicles), the Trucks2:60 app, the webrite. 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 Trucks260 app development will cost $400,000. 4. The initial ecommerce backend Database System development including cloud hosting services will cost $700,000 in the first year. 5. The operation cost of the Trucksz 6 o system, including website/app/backend 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 40% (cost for year 3 is 400 increase from year 2 , and year 4 is 40 . increase from year 3 ). 6. Additional infrastructure costs (such as bullding rental, office equipment, etc): first year will be $100,000, and this is projected to increase by 300 per year over the previous year for Years 2,3,4, and 5 . 7. Personnel costs: the first year will be just 5200,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: Trucks2Go has already done substantial market analysis and surveys. Eased on this research there are two major revenue streams anticipated: 1. Transaction fees: Trucks 2 Go's major source of revenue will be eamed by taking a 3535 cut of the transaction amount (which is on par with Uber and tytt's cut). Based on their extensive marketing research for the Southern California region, the transaction total is estimated to be $350,000 in the first vear as the company is testing out the market, recruiting users, and rolling out the app. The second year is estimated to be $5 milion, and will continue to increase: by 605 over year 2 for year 3 , by 60 os over Year 3 for year 4 , and by 40 over year 4 for year 5 . 2. Affilsate marketing revenue: it is estimated that the company will begin to have affiliate marketing revenue of $10,000 in Year 2 and this 6 estimated to increase esch year over the previous year by 25% Assignment Delluerables You will create your analysis using 5 worksheets contained in a single spreadsheet. You must parameterize each variable (es. 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 workheets, and your final recommendation to investors in terms of whether this is a good investment. Also, 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 indude: - an appropriate titie for this analysis and, on the second line, type "8us312, cyour names, ctoday's dates". The title should be centered and large. - the structure of the cost-benefit analysis should be similar to-but not exoctly the same as-the one on page 353 of the course text book. - the interest cost for each vear in your calculation, (Hint: your monthyy 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 "Breakeven year" below that cell anly. - 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