I literally plucked all the remaining hair (as if much was left) doing this. To the best of my understanding, I arrived at the numbers for Mar 20X6. My profit numbers still wound not tally with the balance sheet (off by 60). Adding insult to injury was the next accounting period. I am sure I got it all messed up with the second one. A crushing blow to my confidence on this subject…. I am sharing the work (err… the mess) I have done as a part of this. More than doing it as a part of the assignment, I would appreciate if the experts help me put together the answer to this puzzle… Lingering Questions (on the second period, how do we account for depreciation, interest amount, Loan value of the Overdraft – 70% of current asset – which value do we take, depreciated value?).
Accountants.. anyone?… Phew…..
http://spreadsheets.google.com/ccc?key=pFjLyBrmhza_jlNIV7cYCfg&hl=en