i am struggling with my financial models and their results for the rest of the year. i think i have done everything reasonably well but would like to hear what others think.
you may find the inventory evolution odd: it's because i am modeling tesla gaming the 200k cutoff for the us tax credit. that is, they intentionally build cars and withhold delivery to avoid crossing 200k, so inventory builds a bit in q2 and is worked off in q3.
those not familiar please understand there are massive inaccuracies trying to project cash flows and balance sheet items, getting close on the income statement is hard enough. so don't be surprised to see things that make you go "hmmmm?".
thank you in advance for any constructive feedback.
you may find the inventory evolution odd: it's because i am modeling tesla gaming the 200k cutoff for the us tax credit. that is, they intentionally build cars and withhold delivery to avoid crossing 200k, so inventory builds a bit in q2 and is worked off in q3.
those not familiar please understand there are massive inaccuracies trying to project cash flows and balance sheet items, getting close on the income statement is hard enough. so don't be surprised to see things that make you go "hmmmm?".
thank you in advance for any constructive feedback.
… |
s deliveries |
x deliveries |
s+x deliveries |
3 deliveries |
ls veh % total |
avg price s+x |
avg price model 3 |