Accounting Question

Copy the excel example to create an excel file about Tesla for the year 2023

Instructions
Copy this excel to create an excel file about Tesla for the year 2023, requiring the same content and
formatting as the example excel, just with different numbers.
Please use Tesla’s 23-year financial report to create this.
There are several numbers in it that must be calculated as these numbers below:
Require that the TOTAL REVENUE for year 23 is $96.773 BILLION, an increase of 18.8 per cent over
the previous year.
Gross margin for 2023 is 18.25%, down 28.71% from last year ROE for 2023 is 27.95%, down 16.82%
from last year.
Liquidity ratio for 2023 is 1.73.
It is required to retain the formulas in excel, address all the sections excel, and ensure all the key
numbers above are accurate.
It is only used as an attachment.
Excel Assignment
Language: English (UK)
Topic: Copy the excel example to create an excel file about Tesla for the year 2023