What is the correct explanation for why the ocean’s crust co…
Questions
Whаt is the cоrrect explаnаtiоn fоr why the ocean’s crust contains alternating strong and weak magnetic stripes?
Yоu will need Excel fоr this Questiоn. Downloаd the stаrter sheet from the link аnd save your file with the following file format Question 3 Blank Starter Sheet TBone's Scooter Company is kicking butt! and you have been asked to evaluate another derivative product called "The KelceSwift." It will be a licensed product with Taylor Swift (famous singer in case you hadn't heard...) and her "fiancé" Travis Kelce. Taylor wants to have all her music loaded in the control module with a speaker and LED lights so you can blast her music while riding for ALL to hear. Oh yeah, the color of the scooter is RED with a Kansas City Chiefs #87 painted on the side with a heart around it. Awe... So cute! The new eScooter has the following projections: 1.25 Years of development prior to launch: $550,000 in first year, $7,350,000 in the partial second year (we expect lots of volume, and therefor; lots of tooling and machinery to make the product). The license fee to be given to Taylor will be $45.663294 (she is a very detailed negotiator) per eScooter sold. Sales after launch of: 50,000 units in Year 1 100,000 units in Year 2 90,000 units in Year 3 100,000 units in Year 4 80,000 units in Year 5 The price of each unit is $769 for all sales and you sell direct to your customers (i.e. no discounts). The cost per unit at launch is $570 at launch, but you get a cost reduction from your suppliers starting the year after launch and resulting in a 5% cost reduction. The following year, the suppliers gives you a 3% reduction. There are no other cost reductions planned after that. President TBone's team has given you a moderate hurdle (interest) rate since the risk of the upfront capital spend makes him nervous... but hey - it's good KARMA! Use 8.25% Interest Rate for the Cost of Capital. In addition, President TBone knows how these Hollywood affairs end.... so he wants you to model a reinvestment in the product in the 3rd year of the product's life (what year is that in your model?) of $350,000 to take the Kelce number off the unit and make a bunch of updates. He expects the new updated Scooter will be called the "WE ARE NEVER EVER GETTING BACK TOGETHER" Scooter. Calculate the NPV of this opportunity. You must have your formula's in the cells of your worksheet for partial credit. You must show the discount rate per year and multiply this by your Cash Flow (CF). Check your work by using the NPV formula (built into Excel) of the Cash Flows. Use the format in the blank starter spreadsheet. To submit: Upload your file to Canvas Check your formatting! I will take off for poorly formatted excel spreadsheets.