Overview
Upload assignment here. Upload XLS or similar Excel format only. PDF, CSV, NUMBERS formats are not accepted. EXPORT or SAVE AS format to be and upload XLS (or similar excel extension) for credit.
The files section of canvas has the template and case study student data set (2025) details for preparation.
First, please watch the videos - especially if you did not attend class on 11/20. There is a version in the files section and another at this link https://app.box.com/s/utf79z71qwlgllmv77bk2s3y5xy8hv30 (Links to an external site.)
The two versions are substantially the same (just broken down to three parts in files section). These were prepared by a former colleague of mine and do pretty well at presenting the spreadsheet and how to start using it.
Second, familiarize yourself with the STUDENT DATA set for 2025. This is in the files section and is the Balance sheet and income statement and other data you need to prepare the statement of cash flows
Third, start playing with and filling out the template tool - also in the files section.
Download CF_worksheet case study template.The template is just a template - it is going to need a lot of editing to be ready to use it for "your client" (i.e. the STUDENT DATA) as it was never intended to be used for "your client", we are actually taking it from another client and using it for this one (the editing required is part of the excel learning objectives of this case study). You're going to need to insert row and columns and also edit headers and titles. You'll need to type in your DR balances and (CR) balances in the balance sheet rows at the top and re-label appropriately. There is much more to do too.... I highly recommend you think through things and familiarize yourself with the formulas that the excel template has. I also suggest making a copy of the tab to start doing your work so you have a reference point on how it was originally built-out before you started editing it.
I recommend spending time attempting to complete the cash flow worksheet before our tutorial sessions on Tuesday next week (TP's will offer drop in support at 8am class time via zoom). You will also need to hear my expectations on what a full credit submission will look like and you can only get that by attending Thursday's lecture.
It is acceptable to collaborate and troubleshoot with a classmate or two (really, it is encouraged). I just require that you do your own work on the spreadsheet It is impossible that 2 spreadsheets would be identical, so don't share yours and risk someone submitting an exact copy of your work. Aside from this, please feel confident to collaborate and help each other, just do your own work on your own spreadsheet.
Check your work before uploading. Check formatting, etc. Check that all of your "checks" in the worksheet are working and zero. Delete extra and unused rows in your statement of cash flows. Review your headings and captions for accuracy.