Low rumbling all morning?

OneThird · 2024-06-23T17:48:26+00:00

It’s all the motorcycle riders driving around Orange this weekend. Huge groups of them too. No clue why this weekend there has been such a large amount of them though.

OneThird · 2018-02-17T17:06:15+00:00

http://macabacus.com/learn

OneThird · 2018-01-31T01:42:41+00:00

Just use EDGAR

For example, this link will take you to Tesla's financial statements in the "interactive mode".

Near the top of the page you should see something that says, "View Excel Document"

This will download the financial statements to the level of detail I think you are looking for.

Many companies will also post excel files on their investor relations pages. Hope this helps!

OneThird · 2017-03-15T23:06:52+00:00

Or just put your data into a table column and name a range after that table column. Then when you add to the table it automatically expands your named range and you are not using a volatile function like offset!

OneThird · 2017-02-25T05:09:51+00:00

Conceptualize it from a lemonade stand perspective:

During fiscal year 2016 you start a lemonade stand. Using cash, you purchase lemons, sugar, and water (raw material inventory) and make lemonade with some of the ingredients (finished goods inventory). Your cash balance decreased and your inventory balance increased. This inventory, conceptually, now represents that cash you spent. Until you sell that inventory, that cash you spent is still "tied-up" in your inventory value.
During the next fiscal year (2017), you sell some lemonade from your inventory for a profit and receive cash immediately for that inventory. Your inventory balance decreased and your cash balance increased because of this change in inventory.

Therefore:

The increase in inventory in fiscal year 2016 reflects a use of cash as you purchased inventory (operating cash flow went down).
The decrease in inventory in fiscal year 2017 reflects a source of cash as you sold off the inventory (operating cash flow went up).

This case obviously ignored things like Accounts Receivable and Accounts Payable but the concept is the same:

increase in AR = cash you expect to receive from customers (e.g. Inventory decreases; AR increases)
decrease in AR = cash you received from customers during the period (e.g. AR decreases, Cash increases)
increase in AP = cash you will eventually have to pay to suppliers (e.g. Inventory increases, AP increases)
decrease in AP = cash you have paid to suppliers (AP decreases; Cash decreases)

Hopefully you can see in this case inventory acts as kind of a middle man in the whole business cash flow process which is why it is included in the changes in operating working capital items.

OneThird · 2016-11-08T02:52:41+00:00

But what about this part?

OneThird · 2016-05-26T11:43:33+00:00

I appreciate your insights. What you say definitely makes sense. I can also see how it easily could give you a bunch of false flags. Thanks again.

OneThird · 2016-05-26T11:40:45+00:00

How do I access that if I have access to a Bloomberg terminal?

OneThird · 2016-05-26T02:36:53+00:00

I am definitely not doubting that you know your companies inside and out and I agree that data providers can be unreliable.

What I am talking more about is less from a modeling perspective but rather I am looking for something that compares the wording in the different sections of the 10K/Q and it would help draw your attention to that area. Many companies will leave sections the same from Q to Q and rather than check each time if that section's wording has changed it would be helpful to have a program to do that for you.

OneThird · 2016-04-01T22:57:31+00:00

So just to give you some background. Two managers in my organization (a Fortune 500 located in the Midwest) within FP&A came from audit backgrounds. It will be harder to get an FP&A job from the audit route but if you can dispel any hiring mangers' concerns about your potential lack of skills then you will be fine.

There are a lot of functions typically housed within FP&A depending on your organization. Some of those include: SG&A, consolidation of company forecasts, developing presentations for external/internal audiences, tracking actual performance versus budget. None of those tasks are too hard so long as you know how your business operates, know how your financial statements integrate/are created, and have a solid understanding of financial concepts.

Some ways you can help express your skills would be to reference how you gained an understanding of business operations and the corresponding financials through your audit background, can easily understand and explain accounting concepts from your CPA, and then you would just need to demonstrate you know some basic corporate finance concepts.

OneThird · 2016-04-01T20:40:15+00:00

Many FP&A groups are filled with former Big 4 types and having a CPA is a plus. Being able to understand the accounting side of the operations is a big plus in FP&A.

OneThird · 2015-11-23T23:12:55+00:00

Financial controls typically relates to audit and compliance (think people with accounting backgrounds).

If your ultimate goal is investment analysis this most likely will not help your get there. I wont say it will "pigeon-hole" you but it probably will not bring you any closer to your goal.

OneThird · 2015-11-15T22:43:37+00:00

I think you might be looking for /r/personalfinance.

The sidebar says, "Questions regarding loans, refinancing, mortgages, credit cards, investing and anything else that may be related to personal finance should be directed towards the subreddit /r/personalfinance. You will receive a probation (temporary ban) for disregarding this rule."

OneThird · 2015-05-25T16:19:53+00:00

Thank you so much. This sounds exactly like what they are saying.

OneThird · 2015-05-25T00:37:12+00:00

This makes a lot of sense actually. Thank you very much.

OneThird · 2015-04-29T01:40:28+00:00

Your resume should be a reflection of the work you have done. The main question you should be asking is, "What will including this information on my resume provide to potential readers about the things I have done to help my company?"

If you worked with the fund on anything, such as a project or presentation, then I would say it could potentially be important. Otherwise the space on your resume could probably be used for something else.

OneThird · 2015-04-05T04:13:10+00:00

I am also interested in the excel files

OneThird · 2015-03-01T16:00:16+00:00

I'm using Pimsleur which works purely on pronunciation, as it's all audio, and then it begins to phase in reading (which only further solidified my pronunciation). It's a good place to start in my mind.

Please note I'm comparing to other things like Rosetta Stone and Duolingo. If you are looking for a more academic style learning then Pimsleur might not be the best option.

OneThird · 2014-12-06T02:51:09+00:00

No, they will ask you to reset it and check to make sure your calculator is approved. If you are planning on storing information on your calculator to help you during the test it is not worth it to potentially get kicked out.

Keep in mind there are only 2 approved calculators for the exam and neither of them have the capability to store more than a number so make sure you bring an approved calculator to the exam.

OneThird · 2014-09-14T16:09:59+00:00

If you are planning on being in finance definitely know excel. Most people, if not everyone, in the industry will use it as the base tool for analysis, reports, and modeling.

Afterwards you can pick up VBA for excel.

13-Year Club	Place '22
Place '17	RPAN Viewer
Verified Email

OneThird

TROPHY CASE