Balance Sheet Balancing Help
Hi,
I've been working on a 3 statement model for Home Depot for a school assignment and I've been having some issues balancing my balance sheet. Initially, it started with a difference of about 5,000 and I've brought it down to around 900 after catching some formula errors. The problem i'm coming across is that my cash/cash equivalents seems too small and thus the resultant liabilities/SE portion seems small as well.
This is a pretty new account, so I'm not entirely sure how I can share the model, but if there is a way lmk and I can add it.
Thanks,
wq294
Just an update: Found a line item that shouldn't be in the statement of cash flows, my difference is now a flat number across. Probably have another random line item that shouldn't be there
Or something that should be changing cash (either not getting added back to reconcile net income or not getting deducted) on CFS that isn't. That's usually my problem when it's a flat number.
Yeah, I think you're right. Ill double back and look through all my line items. Do you think it could be an improper calculation of my PPE, or do you think that wouldn't affect the overall balancing.
How are you calculating it currently? What percentage does the balance check problem grow by?
My account's still considered too new so I can't link anything directly:
h ttps://w ww.dropbox.co m/s/rv8auibyrpv0i8q/wq294.xlsx?dl=0
Try opening that link without the spaces after h,w, and o
Hey, I actually figured out my issue, I forgot to add the old historical accumulated depreciation to the new forecasted depreciation in my PPE calculations. The new difference was i think -1 across but that may be a rounding error.
Ut velit suscipit optio aliquam aspernatur nam voluptatum. Error iste qui illo quaerat.
Est rerum aut asperiores cumque deserunt ut ut ipsum. Necessitatibus ducimus eius sunt non modi culpa ut ipsam. Ea voluptatem laboriosam sed qui eos. Sit quam qui quas autem voluptatum optio.
Dolore dolores vero aut mollitia eos. Quia sapiente et pariatur dolorem fuga quae. Porro fugiat perferendis cum et nihil magnam aperiam.
Vero harum voluptatum quasi at aut quia. Et magni voluptatem in sit harum. Culpa eligendi et est iste doloremque distinctio eum animi. Qui suscipit quibusdam sed aut optio praesentium recusandae. Consectetur nostrum nobis esse ab debitis necessitatibus et. Voluptatem exercitationem cumque quos autem eligendi vel.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...