Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Financial Statements Vertical Analysis, Common Size Statements 2018 2019 2020 2021 2022 BTOZ 2019 202 2021 2022 Assets Current Assets Cash and Cash Equivalents 3,686.00

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Financial Statements Vertical Analysis, Common Size Statements 2018 2019 2020 2021 2022 BTOZ 2019 202 2021 2022 Assets Current Assets Cash and Cash Equivalents 3,686.00 $ 6,268.00 $ 19,384.00 $ 17,576.00 $ 16,253.00 12.39% 18.27% 37.17% 28.29% Accounts Receivable Net 19.74% 949.00 $ 1,324.00 1,886.00 1,913.00 ,952.00 3.19% Inventory 3.86% 3,113.00 $ ,552.00 $ 3.62% 3.08% 3.59% 4,101.00 5,757.00 2,839.00 10.47% 10.35% Other Current Assets 7.86% 9.27% 559.00 $ 15.59% 959.00 1,346.00 ,854.00 $ 8,873.00 1.88% 2.80% 2.58% 2.98% Total Current Assets 10.78% 8,307.00 $ 12,103.00 $ 26,717.00 $ 27,100.00 $ 40,917.00 27.93% 35.28% 51.23% 62% 19.69% Non-Current Assets Property, Plant, and Equipment Net 11,330.00 $ 10,396.00 $ 12,747.00 $ 18,884.00 $ 23,548.00 38.10% 30.30% 24.44% Intangibles 30.39% 28.60% 282.00 $ 339.00 313.00 257.00 $ 215.00 0.95% Other Assets 0.99% 0.60% 9,821.00 $ 11,471.00 $ 0.41% 0.26% 12,371.00 $ 15,890.00 $ 17,658.00 Total Non-Current/Fixed Assets 33.02% 33.43% 23.72% 21,433.00 $ 22,206.00 $ 25.57% 21.45% 25,431.00 $ 35,031.00 $ 41,421.00 72.07% 64.72% 48.77% 56.38% 50.31% Total Assets 29,740.00 $ 34,309.00 $ 52,148.00 $ 62, 131.00 $ 82,338.00 100.00% 100.00% 100.00% 100.00% 100.00% Liabilities and Owners' Equity Current Liabilities Accounts Payable 3,405.00 $ 3,771.00 $ ,051.00 $ 10,025.00 $ 15,255.00 11.45% 6 Accrued Expenses and Other Current Liabilities 10.99% 11.60% 2,094.00 $ 2,905.00 $ 16.14% 3,855.00 5 18.53% 5,719.00 $ 7,142.00 7.04% 8.47% Current Portion of Debt and Leases 4,494.00 $ 3,991.00 $ 7.39% ,342.00 $ 9.20% 8.67% 3,961.00 $ 4,312.00 15.11% Total Current Liabilities 11.63% 8.33% 9,993.00 $ 10,667.00 5 5.38% 5.24% 14,248.00 $ 19,705.00 $ 26,709.00 33.60% 31.09% 27.32% 31.72% 32.44% Long-Term Liabilities Long-Term Debt and Lease Obligations $ 9,404.00 $ 11,634.00 $ 9,556.00 $ 5,245.00 $ 1,597.00 31.62% 33.91% 18.32% 8.44% Other Long-Term Liabilities 1.94% 4,030.00 $ 3,898.00 s 4,614.00 $ 5,598.00 3,134.00 13.55% Total Long-Term Liabilities 11.36% 3.85% 9.01% 9.889 13,434.00 $ 15,532.00 $ 14,170.00 $ 10,843.00 $ 9,731.00 45.17% 45.27% 27.17% 17.45% 11.82% Total Liabilities $ 23,427.00 $ 26,199.00 $ 28,418.00 $ 30,548.00 $ 36,440.00 78.77% 76.36% 54.49% 49.17% 44.26% Owners' Equity Common Stock, Less Treasury $ $ 1.00 $ 3.00 $ 3.00 0.00% 0.00% 0.00% Additional Paid in Capital 0.00% 0.00% 10,249.00 $ 12,737.00 S 27,260.00 29,803.00 32,177.00 34.46% 37.12% Retained Earning 52.27% S 47.97% 39.08% 329.00 $ 12,885.00 Other Equity 0.00% 0.00% 0.00% 0.53% 15.65% (3,936.00) | $ (4,627.00) | $ 3,531.00) | $ 1,448.00 | $ 833.00 Total Equity 13.23% 49% 6.77% 2.33% 5,313.00 $ 8,110.00 $ 1.01% 23,730.00 $ 31,583.00 $ 45,898.00 21.23% 23.64% 15.51% 50.83% 55.74% 5 Total Liabilities & Equity $ 29,740.00 $ 34,309.00 $ 52,148.00 $ 62,131.00 $ 32,338.00 100.00% 100.00% 100.00% 100.00% 100.00%Financial Statements 2018 Vertical Analysis, Common Size Statements 2019 2020 2021 2022 Total Revenue (or Sales) 2018 2019 $ 21,461.00 $ 2020 202: 24,578.00 $ 2022 31,536.00 $ 53,823.00 $ 81,462.00 Cost of Sales S 00.00% 100.00% 100.00% 17,419.00 $ 20,509.00 S 100.00% 100.00% 24,906.00 $ 40,217.00 $ 50,609.00 31.17% 3.44% 78.98% 74.72% 74.40% Gross Profit 4,042.00 $ 4,069.00 $ 6,630.00 $ 13,606.00 $ 20,853.00 18.83% 16.56% 21.02% 25.28% 25.60% Sales, General, and Administrative Expenses $ 4,430.00 $ 4,138.00 $ 4,636.00 $ 7,083.00 $ 7,197.00 20.64% 16.84% 14.70% 13.16% 8.839 Operating Income $ 388.00) $ (69.00) $ 1,994.00 $ 6,523.00 $ 13,656.00 -1.81% -0.28% 6.32% 12.12% 16.76% Other Income (Expense) *If expense is reported, enter as a negative number. Interest Income / (Expense) $ (639.00) $ (641.00) $ (718.00) $ (315.00) $ 106.00 2.98% Other Income (Expense) $ 2.61% 22.00 $ 2.28% 0.59% 45.00 $ 0.13% 122.00) $ 135.00 $ (43.00) 0.10% 0.18% 0.39% 0.25% 0.059 Net Income (Loss), Before Tax (1,005.00) $ 665.00) $ 1, 154.00 $ 6,343.00 $ 13,719.00 -4.68% -2.71% 3.66% 11.78% 16.84% Vertical Analysis on Revenue only 14.52% 28.31% 70.67% 51.35%Ratio Analysis 2018-2022 2018 2019 2020 2021 2022 Liquidity Ratios Current Ratio 0.83 1.13 1.88 1.38 1.53 Quick Ratio 0.46 0.71 1.49 0.99 0.72 Working Capital $ (1,686.00) $ 1,436.00 $ 12,469.00 $ 7,395.00 $ 14,208.00 Activity Ratios Receivable Turns 22.61 18.56 16.72 28.14 27.60 Days in Receivables 16.14 19.66 21.83 12.97 13.23 Revenues/Working Capital -12.73 17.12 2.53 7.28 5.73 Revenues/Fixed Assets 1.89 2.36 2.47 2.85 3.46 Revenues/Total Assets 0.72 0.72 0.60 0.87 0.99 Inventory Turns 0.18 0.17 0.16 6.99 4.72 Days in Inventory 2042.38 2107.48 2216.70 52.25 77.32 Payables Turns 5.12 5.44 4.12 4.01 3.97 Days in Payables 71.35 67.11 89'88 90.98 91.87 Coverage/Leverage Ratios Fixed Assets/Equity 1.79 1.28 0.54 0.60 0.51 Profitability Ratios Return on Equity -15.92% 8.20% 4.86% 20.08% 29.89% Return on Total Assets -3.38% -1.94% 2.21% 10.21% 16.66% Net Profit on Revenues -4.68% 2.71% 3.66% 11.78% 16.84%Tesla Project Income Statements 2023-2026 millions Financial Statements 2023 2024 2025 2026 2026 Terminal Total Revenue (or Sales) ! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Estimated Annual Revenue Growth Rate [insert value] insert value] [insert value] [insert value [insert value [insert value] Gross Profit #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Estimated Annual Gross Profit Margin [insert value] insert value] [insert value] [insert value] [insert value] [insert value] Sales, General, and Administrative Expenses (SG&A) #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Estimated Annual SG&A (% of Sales) [insert value] insert value] [insert value] [insert value] [insert value [insert value] Other Income (Expense) *If expense is reported, enter as a negative number. Interest Income / (Expense) [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] Other Income (Expense [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] Net Income (Loss) #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE

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

Advanced Financial Accounting An IFRS Standards Approach

Authors: Pearl Tan, Chu Yeong Lim, Ee Wen Kuah

4th Edition

9789814821278, 9814821276

More Books

Students also viewed these Accounting questions

Question

Personal role: This consists of service to family and friends.

Answered: 1 week ago

Question

The role of life: It consists of your own service to yourself.

Answered: 1 week ago