Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
You can submit an excel file for this homework
Monte Carlo Simulation: Uber provides an app-based transportation service and it is one of the fastest growing companies with a strong investor backing. In this homework, you are going to be simulating a simplified version of Uber’s future cash flow in US for the coming 5 years, 2018 through 2022: Here is the information on the current numbers and future estimates for the US market: Annual revenue = 365*(Average Daily Rides * Average Price Per Ride) Average price per ride in 2017 = $4 Both variables (Average Daily Rides and Price Per Ride) are random variables for 2018 through 2022. You will need to come up with the probability distributions for each using the past data. Average Price Per Ride is expected to go up at the same rate as the inflation rate each year. Find a discrete probability distribution for inflation using the data provided here: https://www.usinflationcalculator.com/inflation/consumer-price-index-and-annual-percent-changes-from-1913-to-2008/ Use only the data provided in the last column from 1982 to 2017. Find the maximum and minimum inflation occurred during this period, divide the range into five equal sub-ranges and assign a probability to the mid-point of each range by using the frequency with which inflation occurred on this range in the past. Use this probability distribution for each of the years 2018 through 2022. Please assume that probability distribution is independent across years. Average Annual Rides Some of the major parameters Uber’s average annual ridership depends upon are GDP growth rate, unemployment rate, consumer confidence index, and the gas prices. You can think of other variables that would be instrumental in affecting UBER’s ridership. To keep things simple, I provided a highly stylized model where we assume the ridership depends only on GDP growth. Average Annual Rides = 900,000 + 8,000,000*annual GDP growth rate Again, find a discrete probability distribution for GDP growth rate using the data provided in an Excel file titled “World Bank GDP growth data” . (Use data from 1982 to 2016 for United States only) Employ the same approach as you did with the inflation probability distribution. Using the above information, answer the following: Due to its unconventional pricing (dynamic pricing, depending on supply and demand) and various claims on safety and regulation issues, company is expected to spend a considerable amount on legal settlements. Uber aims to be able to cover its settlement costs with the revenue it obtains from operations for the coming 5 years 90% of the time, on average. The settlement expense for 2018 through 2022 is expected to be a total of $X in today’s dollars. If the discount rate is 5%, estimate X by running a Monte Carlo Simulation 1,000 times.
The firm’s stock price increased 17 percent on the first day of trading. What was the total cost to the firm of issuing the securities?
Emily Morrison purchased a new house for ?$120,000 and paid ?$30,000 up front. How much does she need to borrow to purchase the? house?
A bank has duration of assets of 3.96, total assets of $181 million, duration of liabilities of 4.8, total equity equal to 9.5% of total assets, rate-sensitive assets of $76.75 million, and rate-sensitive liabilities of $50.8 million. What is the ban..
The state of Florida sold a total of $36.1 million worth of lottery tickets at $1 each during the first week of January 2007. As prize money, a total of $41 million will be distributed over the next 21 years ($1,952,381 at the beginning of each year)..
What is the cost of the stock offer? What is the cost of the cash offer? Which alternative should X Corporation pursue?
Permian Partners (PP) produces from aging oil fields in west Texas. Production is 1.92 million barrels per year in 2016,
The Black Bird Company plans an expansion. The expansion is to be financed by selling $87 million in new debt and $5 million in new common stock. The before-tax required rate of return on debt is 11.39% percent and the required rate of return on equi..
A property is leased for $24,000 per year although market rents are currently $27,500 per year and are expected to increase by 2% per year. The property is expected to be sold at the end of year 10 based on a 10% terminal cap rate applied to the elev..
Meyer & Co. expects its EBIT to be $89,000 every year forever. The firm can borrow at 5 percent. Meyer currently has no debt, and its cost of equity is 8 percent and the tax rate is 35 percent. The company borrows $102,000 and uses the proceeds to re..
We are evaluating a project that costs $800,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 60,000 units per year. Price per unit is $40, va..
A firm has 5 million shares outstanding with a market price of $20 per share. How many shares will remain after the repurchase?
Orca, Inc. announced today that it will begin paying annual dividends.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd