It is the end of 2023 . You're a financial analyst working for Tesla Motors....

70.2K

Verified Solution

Question

Finance

image

It is the end of 2023 . You're a financial analyst working for Tesla Motors. The company is considering producing the new Model Z car and is predicting the following sales (in \$ million). Assume all cash flows occur at the end of the year. COGS and SG\&A are expected to add up to 70% of sales. After 2028, production will end and the factory will shut down. To start production at the beginning of 2025 , Tesla has to invest $200 million now and $100 million in 2024 to build a new factory. After completion at the end of 2024, the factory can be depreciated straight to zero over 10 years. The factory is expected to be worth $100 million at the end of 2028 . Net working capital consists mainly of inventory of car components, minus some current liabilities. Net working capital is expected to be always 15% of sales, until the last year of the project when it will all be recouped. Tesla has a weighted average cost of capital of 11% and a marginal tax rate is 20%. Part 1 Attempt 1/10 for 10 pts. Open a spreadsheet with a blank tab and name it 'CF', for cash flows. Duplicate the table above and extend it to find the operating cash flow for each year. What is the operating cash flow for 2028 (in $ million)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students