WEBVTT 1 00:00:01.260 --> 00:00:12.120 William Rosener: hello, this is Dr bill roesner and this video you're going to learn how to create balance sheet using Google sheets to start by taking a look at what you learn how to create and then we'll go ahead and start from scratch here. 2 00:00:12.630 --> 00:00:24.030 William Rosener: So we're going to have some assets monetary assets and tangible assets we're going to go ahead and write a formula to have these up same thing with the tangible assets. 3 00:00:24.540 --> 00:00:33.600 William Rosener: And we're going to have liabilities short term liabilities and we're going to use a formula to have those up along with formula and up the long term, the more compute. 4 00:00:34.290 --> 00:00:44.820 William Rosener: For some up all the assets or some at birth, the short and long term liabilities and we'll find a net worth and know that we know what wouldn't do let's get started there. 5 00:00:45.990 --> 00:00:57.480 William Rosener: So the first thing you want to do is I go to Google COM and hopefully you've already got an account If not you don't have to create one they're going to press on these little icons right here and i'm going to press on a drive icon. 6 00:00:59.370 --> 00:01:11.730 William Rosener: And i'm going to come right up here i'm going to press on new, let me come on down and press on Google sheets that's going to open up a blank document for us to begin typing. 7 00:01:12.510 --> 00:01:26.040 William Rosener: In i'm going to go ahead and kind of begin creating this thing, and maybe i'll fast forward to in the digital copy and paste or something here to speed up the process there So the first thing you want to do is sell he one we're going to type in balance. 8 00:01:27.690 --> 00:01:28.320 William Rosener: sheet. 9 00:01:29.370 --> 00:01:30.870 William Rosener: And then go ahead and put your name. 10 00:01:33.750 --> 00:01:45.540 William Rosener: Then they wanted this information to go from a one through H1 somehow on all those cells going to come right up here to format i'm going to choose merge cells and hit merge all. 11 00:01:46.320 --> 00:01:55.680 William Rosener: The moment turn around and come back up here and let's get that information Center and then I believe I have that shaded so maybe I will add a little full color. 12 00:01:57.750 --> 00:02:01.230 William Rosener: And then maybe even a nice thick border around the outside there. 13 00:02:02.610 --> 00:02:06.870 William Rosener: Okay, then come on over here next thing was assets i'm going to type that. 14 00:02:08.400 --> 00:02:23.430 William Rosener: In a two and that information needed that span or cells it's going to span a 232 so i'm going to come right up here to format versus the cells merge and then go ahead and glide that. 15 00:02:26.760 --> 00:02:41.550 William Rosener: And then we'll tell you what maybe i'll highlight all of this information, right here, and like this, some light shade of, say, green that i'm going to go ahead and come over here and we'll make this sunlight shade, maybe think care. 16 00:02:42.870 --> 00:02:44.700 William Rosener: Then, these are the liabilities. 17 00:02:47.760 --> 00:03:00.600 William Rosener: And, just like I did a second ago i'm going to go ahead and highlight eat to through H2 i'm going to format it merge those cells and then turn right around and set of that. 18 00:03:01.950 --> 00:03:04.440 William Rosener: Then we're going to have monetary assets. 19 00:03:10.320 --> 00:03:12.840 William Rosener: And then over here we're going to type in tangible. 20 00:03:16.140 --> 00:03:20.700 William Rosener: And this information, right here merge those two cells. 21 00:03:27.930 --> 00:03:33.300 William Rosener: And the same thing here and we'll highlight those two and merge. 22 00:03:34.410 --> 00:03:35.430 William Rosener: In turn, right around. 23 00:03:36.990 --> 00:03:38.850 William Rosener: and get the information Center of town. 24 00:03:45.690 --> 00:03:50.310 William Rosener: Okay, maybe at this point, I could go ahead and put some nice thick border some borders on it. 25 00:03:52.410 --> 00:03:57.450 William Rosener: right there Okay, then i'm going to go ahead and begin typing in a savings account. 26 00:04:00.570 --> 00:04:06.900 William Rosener: And then, with this format it as currency so i'm going to highlight this information will come right up here to data. 27 00:04:07.980 --> 00:04:24.150 William Rosener: And we can right over here to format number and i'm going to choose currency so format number currency, so now, when I enter a value like 1750 it's going to automatically put the dollar sign and the decimal points. 28 00:04:25.170 --> 00:04:26.670 William Rosener: Let me create a checking account. 29 00:04:30.300 --> 00:04:31.800 William Rosener: And i'll enter a value. 30 00:04:35.100 --> 00:04:42.540 William Rosener: and development go ahead and increase the width of that column there, and maybe I could even decrease with a beam. 31 00:04:44.040 --> 00:04:49.080 William Rosener: Okay, then i'm gonna come on down here i'm going to type in total assets. 32 00:04:52.650 --> 00:05:07.500 William Rosener: and liabilities and network them but i'm gonna i'm gonna go ahead and jump over to another sheet so here was the finished one, so you can see how it began working with formatting it entering in data and now i'm going to go ahead and jump here to. 33 00:05:11.910 --> 00:05:27.600 William Rosener: right here, I think it's assignment to just kind of save a little time, so you have to watch this video and just let you know i've got this video over here of May I think it's occupied some valuable real estate so i'm not sure you're going to see the picture meeting on future videos. 34 00:05:28.740 --> 00:05:40.560 William Rosener: So anyway first thing we want to do is go ahead and we want to compute the total assets, all we want to do is add a call these values up something to position my cursor in the south and i'm going to type equals. 35 00:05:42.030 --> 00:05:45.960 William Rosener: Some that i'm going to go before your be seven. 36 00:05:50.970 --> 00:05:58.710 William Rosener: And hit enter insurance that has added up those values and i'm going to come over here and I want to add up intangible assets. 37 00:05:59.070 --> 00:06:15.090 William Rosener: So i'm just going to some those up people some and I could specify these one, at a time, I could go D for comma defined comedy comedy seven or I can specify range, which is not what i'm going to do and that's going to be D for colon the seven. 38 00:06:16.650 --> 00:06:17.760 William Rosener: And I can see. 39 00:06:19.080 --> 00:06:31.530 William Rosener: In the Google sheets there there's a little dots around the area i'm just going to hit enter and that's going to sum this all up there, I can see the 700 but i'm going to add month and i'm also going to keep on coming down here through. 40 00:06:32.550 --> 00:06:37.830 William Rosener: Seven that when I add some more short term liabilities they'll get included as well, some of those some. 41 00:06:39.210 --> 00:06:40.590 William Rosener: And it's going to be a form. 42 00:06:42.780 --> 00:06:46.290 William Rosener: On f7 they could press a tacky or type it in. 43 00:06:48.270 --> 00:07:01.440 William Rosener: And and 700 and then come over here and get my long term liabilities and that's going to be eat walls of hormones start with the equal sign, whether in Google sheets or within Microsoft excel and i'm going to some. 44 00:07:03.450 --> 00:07:06.870 William Rosener: And it's going to be page four to eight seven. 45 00:07:12.390 --> 00:07:18.030 William Rosener: Okay, and there we go so we've added up those now what i'm gonna do is get the total assets, I want to add up. 46 00:07:19.110 --> 00:07:26.970 William Rosener: This value plus this value so what's going to come right here i'm type equals some that's going to be be eight. 47 00:07:32.130 --> 00:07:34.860 William Rosener: and comma there and then D eight. 48 00:07:37.920 --> 00:07:48.510 William Rosener: OK so i'm going to add up this value and this value that's going to give me 77,825 that i'm going to come along and get the total liabilities i'm going to add up these two numbers. 49 00:07:51.330 --> 00:07:54.270 William Rosener: In the personal is going to be F hate. 50 00:07:57.060 --> 00:07:58.860 William Rosener: And then he ate. 51 00:08:02.580 --> 00:08:12.270 William Rosener: him before and I can see the little dashes around f8 and also around a change in this point not simply go ahead and enter. 52 00:08:13.560 --> 00:08:21.030 William Rosener: Okay, so it's looking good now i'm going to get my net worth was simply do a little subtraction here and i'm just going to simply take what's in be 10. 53 00:08:22.320 --> 00:08:25.590 William Rosener: And minus what's in the 11. 54 00:08:26.940 --> 00:08:28.230 William Rosener: Okay, and there we go. 55 00:08:29.310 --> 00:08:37.950 William Rosener: Okay, so one more a couple more steps here, so, in addition to completing this on assignments, are going to have you finished some type of. 56 00:08:38.340 --> 00:08:50.640 William Rosener: Have you walked through another tutorial maybe learn a few more formulas etc there and what you're going to do to do that simply press on the add sheet and just simply come on and type this tutorial. 57 00:08:52.260 --> 00:09:01.350 William Rosener: And here's where you're going to enter if you're going to do a summary on one of them, and you could, if you wanted to hide a bunch of cells come up here and hit merge all. 58 00:09:02.850 --> 00:09:12.690 William Rosener: Or maybe you'll want to insert some formulas here to demonstrate that you understand this tutorial or maybe some tips some more details, except for them. 59 00:09:13.470 --> 00:09:23.460 William Rosener: Okay, finally, the last step here is a share on this so i'm going to go ahead and hit the share price i'll come back here to sheet one i'm going to hit that share. 60 00:09:24.870 --> 00:09:34.530 William Rosener: And this was me right here this this imagine this is you, so this is not my initial account so now, what I want to do is, I want to share it with right there. 61 00:09:36.660 --> 00:09:57.090 William Rosener: bill rose her Dr William roaster but notice the math make sure you get that spelled correctly seven characters are O s E n er roesner at initial k.edu and i'm going to highlight that and send which point I am going to receive an email notifying me that this document has been shared. 62 00:09:58.290 --> 00:10:09.450 William Rosener: What you're going to do is there's gonna be another document on this is later on you're going to upload your Microsoft excel files and you're also going to upload a link to your. 63 00:10:09.960 --> 00:10:23.880 William Rosener: Google sheets so they're all in the same area and what you're going to do, then, is you're going to open up this document and you're going to hit copy the link and that's going to copy the URL for this particular assignment. 64 00:10:25.260 --> 00:10:35.970 William Rosener: you're then going to go ahead and paste that and on your website so that when i'm grading your work when I pray I can press on, for example, Microsoft excel file it's going to open up. 65 00:10:36.360 --> 00:10:43.350 William Rosener: Then I can press on this case assignment to and it's going to instantly open up your Google sheets assignment. 66 00:10:44.580 --> 00:10:50.700 William Rosener: Hopefully that kind of wraps up this video, so this video hopefully you learned a little bit about Google sheets. 67 00:10:52.020 --> 00:11:02.130 William Rosener: merging cells centering information aligning information, creating us some basic formulas make sure those are formulas there same thing here. 68 00:11:02.610 --> 00:11:10.320 William Rosener: Then you're going to create a tab where you're going to insert some additional information from another tutorial and then finally make sure you share. 69 00:11:11.550 --> 00:11:13.830 William Rosener: And you're going to share that with. 70 00:11:15.120 --> 00:11:25.200 William Rosener: roesner at initio k.edu and eventually again you'll press on the copy link when you want to upload this and that's what you're going to upload to your website, hopefully. 71 00:11:26.610 --> 00:11:29.460 William Rosener: get a good grasp on this and i'll catch the next video thanks bye.