Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please provide the formula view of Excel also. Fast forward to the year 2028. Humankind has made huge progress in the field of artificial intelligence.

Please provide the formula view of Excel also.

image text in transcribed

image text in transcribed

Fast forward to the year 2028. Humankind has made huge progress in the field of artificial intelligence. In particular, autonomous self-driving vehicle technology has matured and has proven to be safe. Singapore, one of the first few cities to test-bed the technology, has beern keeping pace. Lion City Autonomous Taxi (LCAT) Company has just won a Govemment tender to provide the first autonomous taxi service in Singapore. Its CEO, Mr Alan Mas, is visibly excited. Successes in this small city state can easily be replicated in the other regional cities in South East Asia. It has the first-mover advantage! Under the terms of the tender, LCAT has to put at least 400 taxis on the road. And these must comprise a basket of 3 car models from Tesla, a smat electric vehicle manufacturer. Specifically, Tesla Models A, B and C costing $150,000, $180,000 and $250,000 each respectively are required. At least 20% of the total fleet size must be Model C cars. A minimum of 30% must be Model B. The rest can be the cheaper Model A. This is to ensure that there is some variety of services that will cater to the needs of the commuting public. In tendering for the project, LCAT has set aside a maximum budget of $80 million to invest in the fleet of Tesla autonomous taxis The initial investment in buying the autonomous vehicles is only a start. LCAT expects to incur another 40% of the investment costs over a period of 10 years to operate and maintain its autonomous fleet. This period of 10 years also happens to be the statutory life-span of a vehicle in Singapore. LCAT is prepared to write-off the full value of its fleet at the end of this period. For investment purposes, the company uses a return rate (ROI) of 5% per annum. LCAT expects this to be a profitable business. It surmises that there will be a preference for autonomous services versus regular taxi services. Firstly, computer-controlled rides have proven to be safer. Secondly, its market research has shown that many taxi customers prefer a quiet ride rather than to have to bear with talkative taxi drivers! Alan Mas has good reasons to cheer. To him, life is about the future. And the future is here today

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Finance With Excel

Authors: Simon Benninga

1st Edition

0195301501, 978-0195301502

More Books

Students also viewed these Finance questions

Question

8 2 (3t 1) = 7t

Answered: 1 week ago