[HW 1.1c] Readings

Here are a few readings about spreadsheets and financial modeling that you should do.

Course Reader: please read the Burton G. Malkiel Chapter from “A Random Walk Down Wall Street”

In addition, please also read:

1a. Basics
A quick primer on spreadsheet given to me my first day on the job at Babcock & Brown. Called simply, Spreadsheet Rules.txt.

Stanford – Best Practices for Spreadsheeting has at least a few very good ideas in it: http://library.stanford.edu/research/data-management-services/case-studies/case-study-spreadsheets

1b. Number Formats
“1. Excel Custom Number Formats.docx” Source: http://www.ozgrid.com/Excel/excel-custom-number-formats.htm
Another good article on this subject is: http://peltiertech.com/Excel/NumberFormats.html

1c. NPV
The New Zealand Treasury prepared this a brief example of how to calculate a NPV.
http://www.treasury.govt.nz/publications/guidance/planning/costbenefitanalysis/primer/16.htm

Lynda
To the extent that you feel that you need some brushing up in basics, I would recommend watching parts of the Lynda.com Essential Training course, which can be found at:

http://www.lynda.com/sdk/Excel-tutorials/Excel-2013-Essential-Training/116478-2.html?src=c.r.su

At a minimum, it would be a good idea to make sure you understand the basics of formatting numbers, cells, columns, and rows.  To that end, you may want to watch the following movies in Section 4:

  • Exploring font styles and effects
  • Adjusting row heights and column widths
  • Working with alignment and Wrap Text
  • Exploring numeric and special formatting
  • Formatting numbers and dates

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: