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.
Perspiciatis autem asperiores sunt et. Beatae non maiores ea in dicta illum.
Et perferendis at corporis et. Autem accusamus doloremque recusandae praesentium magnam. Nulla iure et vitae rerum aut maxime perspiciatis.
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...