Valuation Workbook.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
This spreadsheet is for educational and informational purposes only. Please read our terms and financial services guide (www.raskfinance.com) for more information.
3
4
HOW TO DOWNLOAD:
5
6
1. Click "File" in the TOP LEFT CORNER
7
2. Click "Download As" then "Microsoft Excel"
8
3. Open the file.
9
10
HOW TO UPLOAD TO YOUR GOOGLE DRIVE:
11
1. Open your Google Drive in a web browser.
12
2. Find the Valuation Spreadsheet file in your Downloads, click and drag the file into Google Drive
13
3. There is no step 3, just open it!
14
15
NOTE FOR EXCEL & APPLE NUMBERS USERS:
16
17
Owen here: If you are using Microsoft Excel or Apple Numbers, the GoogleFinance() function which pulls in financial information (e.g. share price) from Google Finance will not work like it does in the tutorials. That means, anything in a Yellow Box will NOT work automatically -- so you have to type/enter it in manually. See below.
18
19
20
My Google Sheets Tutorials
21
22
Here is a link to some Google Sheets tutorials:
23
How to create a Google Account:
https://www.youtube.com/watch?v=BVlXBE8VKD0&list=PLvt7DNSBYW6ja6MA6GFPzliXKcPO4tr1c
24
How to save Google Sheets in Drive:
https://www.youtube.com/watch?v=JiBL5lTxfEg&list=PLvt7DNSBYW6ja6MA6GFPzliXKcPO4tr1c&index=2
25
How the GoogleFinance() function works:
https://www.youtube.com/watch?v=QRoui16xIGQ&index=11&list=PLvt7DNSBYW6ja6MA6GFPzliXKcPO4tr1c
26
Common errors in Google Sheets:
https://www.youtube.com/watch?v=vgj4Po6PZak&index=13&list=PLvt7DNSBYW6ja6MA6GFPzliXKcPO4tr1c
27
28
29
30
What do the Colours Mean?
31
32
Data pulled from Google, or your manual entries.<< I recommended creating a Google Drive account (free) so you upload the spreadsheet to your Drive account and make full use of the automatic data feeds.
33
34
Data from the case study's annual report<< In these cells you will need to put in the company's details yourself. You can follow the tutorials to see which numbers I have used.
35
36
37
38
Questions (chances are, you'll have a few!)
39
40
41
The BEST way:
https://www.raskfinance.com/contact/
42
43
On Twitter:
https://twitter.com/OwenRask
44
On Twitter:
https://twitter.com/RaskFinance
45
46
47
48
Copyright The Rask Group Pty Ltd
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu