Re: Balance Sheet Not Balancing
thank goodness for WST Forums! My model balances now, now I will make sure to avoid this nuance in the future. Thank you so much!

Corporate Valuation Methodologies: capital lease
Hi About the capital lease, the instructor mentioned in the lecture, his view of capital lease is not very positive, it shows more debt, less efficient for the asset turnover ratios, however, capitalized also means future depreciation, you can get the tax deduction for the capital lease, perhaps ... Hi

About the capital lease, the instructor mentioned in the lecture, his view of capital lease is not very positive, it shows more debt, less efficient for the asset turnover ratios, however, capitalized also means future depreciation, you can get the tax deduction for the capital lease, perhaps certain companies just want to take advantages of the tax shield. Read More

Accounting Bootcamp- Short term debt CFO or CFF
In the the Accounting Bootcamp video module, as part of our discussion of the Cash Flow Statement, we've outlined the following formula: CFO = change in CL - Change in other CA + R - Exp. (w. non-cash items added back). In the JPMC case, where we're applying the said formula, the instructor class... In the the Accounting Bootcamp video module, as part of our discussion of the Cash Flow Statement, we've outlined the following formula:
CFO = change in CL - Change in other CA + R - Exp. (w. non-cash items added back).

In the JPMC case, where we're applying the said formula, the instructor classified the change in short-term debt under CFF instead of CFO (being that Short term debt is a CL). While I understand that debt is a financing option, it eludes me as to why short term obligations, part of the core operating activity of a firm is not classified under CFO. Especially, considering that on the balance sheet, short term debt is included in the CL total. Moreover, doesn't GAAP state that obligation that mature w/i a year are CL? Am I missing something here? While the said classification of Short term Debt under CFF did not prevent me from finding the correct answer, it definitely negatively impacted my understanding of management's decision. So, Thank you for clarifying. Read More

Automatically Importing Formatted Data
I'm importing data from Microsoft Access, and one column is a list of dates. When I paste this data into Excel and apply a filter, so I can sort the dates chronologically, it only offers text filters. There are no date filters to sort by date. I have tried changing the format to Date using both t... I'm importing data from Microsoft Access, and one column is a list of dates. When I paste this data into Excel and apply a filter, so I can sort the dates chronologically, it only offers text filters. There are no date filters to sort by date.

I have tried changing the format to Date using both the wall street macros and the format menu. I have also tried creating a list of dummy dates, getting the filter to recognize it as a list of dates with the correct options, then paste my list below the dummy dates. None of this works.

How do I get excel to recognize the column as a list of dates and not as text? Read More

Corporate Valuation: DCF valuation
Just a quick question,, is it fair to conclude that the DCF Valuation is the most important method and the most popular one used by firms? At least, as a Beginning point to the valuation process? Thanks,

Noor