Question: 5. (32 points) Submit an excel le for this question ONLY: Tesla, a tribute to electrical engineer Nikola Tesla, is an American electric vehicle and

5. (32 points) Submit an excel le for this question ONLY: Tesla, a tribute to electrical engineer Nikola Tesla, is an American electric vehicle and clean energy company founded in 2003. Please nd Tesla's Consolidated Statements of Operations from 2008 to 2020 in a separate excel le. Calculate the annual percentage change from one year to the next for each year for: X1: Total Revenues X2: Total Cost of Revenues X3: Total Operating Expenses You should have 12 percentages for each variable. Treat X1, X2, X3 as random variables for 2021. Assume that each of these variables will increase from 2020 to 2021 by a random percentage that is picked from among the percentages calculated earlier with equal probability. Estimate the Income(Loss) from Operations for 2021. Run the simulation for 1000 times and provide a probability distribution for the Income(Loss) from operations for 2021. Excel Help: You need to generate random variables. Enter "=RANDO\" in, say, cell A1, and Excel will return a random variable between 0 and 1. Each time you press enter on cell A1, this number will change. Entering "=IF(A14.25,100,IF(A3<.5 will return one of the following numbers with equal probability: or>
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
