Home
Videos uploaded by user “Subjectmoney” for the 2012

04:30
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this financial statement analysis tutorial we are covering liquidity measures or short term solvency ratios. Here you will learn about the current ratio, the quick ratio (acid test) and the cash ratio. Short-term solvency measures are used to determine whether or not a company would be able to pay off its short-term liabilities if they were to come due within the near future. Please don't forget to subscribe, rate and share our videos. Please also visit our website at http://www.subjectmoney.com and http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=G8v9hF0k3gI
Views: 62552 Subjectmoney

06:37
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Time%20Value%20of%20Money:%20Present%20Value%20and%20Future%20Value What is future value? Future value is the value that money today will be worth at some point in the future if invested for a return. For example, we have \$100 today, and we invest it for 1 year at 10% interest, then in 1 year the Investment will be worth \$110. In other words, the future value of \$100 invest for 1 year at 10% is \$110. This is because we will still own the original \$100 and we also earned 10%, an additional \$10. In total our \$100 investment will be worth \$110 in 1 year. The future value formula is shown below. What is present value? Present value is today's value of a future Cash Flow . For example, everyone knows that \$100 today is more valuable than \$100 in the future, but what about \$110, \$120 or even \$200 in the future. How do we calculate what they are worth today? To calculate the present value of a future cash flow we would need a few pieces of information. We need to know when to expect the cash flow, the value (future value) of the cash flow, and the Discount rate . What is the discount rate? The discount rate is the Opportunity Cost s that you have foregone to receive funds in the future. I know, this may sound confusing but it should eventually click. An easy way to understand the discount rate is to ask yourself this question. What kind of investment returns are available to me? If I had \$100,000 today, what would the return be on my investment one year for today? Whatever that rate is would be your opportunity cost and would therefore be your discount rate. (It can be more complicated that this when comparing risk but this is a simplified lesson.) https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=XF_3Dt-8OPE http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 54025 Subjectmoney

03:36
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this lesson we are introducing you to financial statement analysis. We cover common size standardized statements, we cover measures of income and also financial ratios that can be used to analyze the way a company operates along with other features such as the companies financial structure. Please be sure to subscribe, rate, share and don't forget to visit our website at http://subjectmoney.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=TjZCpmtg1Kw
Views: 42193 Subjectmoney

04:30
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Financial%20Statement%20Analysis%20and%20Ratios In this financial statement analysis tutorial we cover long-term solvency measure also known as leverage ratios. In this tutorial we cover the total debt ratio, the debt to equity ratio, the equity multiplier the TIE ratio and the cash coverage ratio. Please don't forget to subscribe, rate, & share our videos. Please also visit our websites http://www.subjectmoney.com & http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=qg1N9_CQtyk
Views: 37081 Subjectmoney

07:18
Views: 21301 Subjectmoney

08:50
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20Types%20of%20Data%20and%20How%20to%20Enter%20Data%20into%20Excel In this Excel tutorial we are covering the different types of data that can be entered into a cell in Excel. The three different types of data is text, numeric values and formulas. In this Excel tutorial we also go into a little detail about these types of data by explaining how Excel recognizes dates and times. We also cover some problems that people may experience with data in Excel and then show you the solutions to those problems. Please don't forget to subscribe, rate and share. Please also visit our website at http://Excelfornoobs.com for a text version of this tutorial. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=e-iIi-alYjI
Views: 15161 Subjectmoney

04:16
How to enter large numbers in Excel How to enter credit card numbers in Excel How to enter numbers larger than 15 digits into Microsoft Excel http://www.excelfornoobs.com http://www.subjectmoney.com This is just a quick Excel 2010 tutorial that teaches how to enter in credit card number into Excel. You wouldn't think that there would need to be an Excel tutorial made on this subject but the problem is that if a cell is not formatted correctly then Excel cannot handle a number as large as a credit card number. Watch this tutorial and hopefully it will save you some trouble in the future if you have to enter in a number that contains more than 15 digits or is larger that 9999999999999999. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=FEroTcfM0vA
Views: 94895 Subjectmoney

04:33
http://www.subjectmoney.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Align%20Text,%20Merge%20Cells,%20and%20Format%20Numbers This is an Excel tutorial covering how to format cells in Excel. In this formatting tutorial we walk you through different ways to align your content, merge cells, format numbers and also add borders and fill colors. Please don't forget to subscribe, rate & share. Please also visit our website at http://www.excelfornoobs.com & http://www.subjectmoney.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Po01-TB40Fw
Views: 5608 Subjectmoney

04:54
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20A%20Step%20by%20Step%20Creation%20of%20a%20Sales%20Report%20and%20Forecast In this Microsoft Excel tutorial we will walk you through creating an Excel workbook by showing you step by step how to create a sales report and sales forecast. In this tutorial you will use different cell formats such as fill color and borders, you will learn number formats, text formats and formulas. You will also learn how to merge cells and align text. Please don't forget to subscribe, rate, share and check out our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Up5gJzmcjT0
Views: 22939 Subjectmoney

03:57
Views: 7838 Subjectmoney

05:17
http://www.subjectmoney.com http://www.subjectmoney.com/articledisplay.php?title=Saving%20for%20Retirement:%20Roth%20IRA%20vs%20Traditional%20IRA This is a video explaining the differences of a Roth IRA and a Traditional IRA. In this video we also cover a little about 401k plans and explain the benefits such as the tax benefits and disadvantages such as the difficulty of withdrawing money. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=B3ARR1okoEU
Views: 11414 Subjectmoney

02:06
Views: 11946 Subjectmoney

02:43
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20Order%20of%20Operation In this tutorial we are covering the order of operation for math equations. The reason why we are covering this is because of how important it is for formulas in Excel. Please don't forget to subscribe, rate and share. Please also visit our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=jmrSG30aOHA
Views: 8014 Subjectmoney

04:04
Views: 7266 Subjectmoney

04:37
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Erase%20Edit%20and%20Replace%20Data%20in%20Excel In this tutorial we show you all the different ways to erase, edit and replace data in Microsoft Excel 2007, 2010 & 2013. We show you how to use the clear command in the ribbon, the shortcut menus and then the basic ways with your mouse and keyboard. Please be sure to subscribe, rate and share our videos. Please also visit our website at http://www.excelfornoobs.com. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=SpkZCrJYI3U
Views: 9740 Subjectmoney

03:15
Views: 14867 Subjectmoney

04:09
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Format%20Font%20in%20Microsoft%20Excel In this tutorial I am going to cover a few different ways to format your content in Excel. Excel has made formatting very easy so if you have already played with Excel then you could probably skip this lesson. I will cover how to edit the color of you content by using the font color command, how to change the size of your content by using the font size command, how change the style of your content by using the font face command and finally how to make your content italicized, bold, and underlined. Thanks for watching our tutorials. Please don't forget to subscribe, rate & share. Please also visit out website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=a7h-H2tF2i4
Views: 5719 Subjectmoney

04:52
http://www.excelfornoobs.com http://www.subjectmoney.com This is a Microsoft Excel 2010 tutorial data entry tip show how you can use AutoCorrect to enter in long words, names or other long sequences of data without having to type them in manually. The way you do this is by using autoCorrect to replace a smaller word, acronym or sequence of numbers with the word, or data sequence you want it to represent. Make sure to check out all of out other Excel Tips and Tutorial Videos. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=NfGtszHm9rA
Views: 2979 Subjectmoney

10:02
http://www.excelfornoobs.com http://www.subjectmoney.com This is a tutorial on the If Function in Microsoft Excel. In this tutorial we cover how to use the if function in 3 different examples with the 3rd example going over how to use the If function for a range of values. For example, If X is greater than A and less than B then true, if not then false. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Shd73tVVPVw http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Views: 66119 Subjectmoney

02:34
Views: 4647 Subjectmoney

11:08
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=The%20Current%20Ratio This is the first video of a video series that covers fundamental analysis of publicly traded companies with a focus of financial ratio analysis. In this video we give an introduction to fundamental analysis, cover liquidity ratios in broad terms and cover the current ratio. Please visit our page at subjectmoney.com for even more insight on similar subjects. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=4m23_Qpjdxg
Views: 9645 Subjectmoney

01:50
http://www.subjectmoney.com http://www.subjectmoney.com/Exceldisplay.php?title=Microsoft%20Excel%202010%20Tutorial%20Part%2012:%20Printing%20Your%20Excel%20Worksheet This is part 12 of Subjectmoney's Excel For Dummies Tutorial Series. In this tutorial we cover how to print you Excel worksheet. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=uuXQANA9S_Q
Views: 948 Subjectmoney

01:28
Views: 1581 Subjectmoney

09:51
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Use%20and%20Combine%20Formulas%20in%20Excel In this Excel 2007, 2010 & 2013 tutorial for beginners we introduce the most commonly used Excel formulas or functions and we show you how to enter and combine them into cells. Please remember to subscribe, rate & share this video. Please also check out all of our other Excel tutorial videos along with our videos on finance lessons. You can visit our website for contextual versions of our videos at http://www.excelfornoobs.com and http://www.subjectmoney.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=68IO1xn8W-E
Views: 9931 Subjectmoney

00:58
http://www.excelfornoobs.com http://www/subjectmoney.com http://www.subjectmoney.com/Exceldisplay.php?title=Microsoft%20Excel%202010%20Tutorial%20Part%204:%20Introducing%20the%20Ribbon%20Contextual%20Tabs The ribbon also has contextual tabs which only appear when certain objects (charts, equations, wordart etc...), are selected. In these contextual tabs tools appear which are specifically related to the selected object. In the image below we began to insert an equation. Once we clicked the insert equation button two contextual tabs popped up in the ribbon. These contextual tabs are titled "Drawing Tools/Format" and "Equation Tools/Design" and are specifically related to the format and design of the equation being inserted. Just as contextual tabs were made available when inserting an equation, so will they be made available when inserting other objects such as charts, clipart, wordart etc... The key to really understanding Excel is to play with it to see for yourself what we are teaching you. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=yYMXRmyzudA
Views: 2210 Subjectmoney

01:55
http://www.excelfornoobs.com http://www.subjectmoney.com This is a quick Excel Video Tutorial showing a quick data entry technique that can be used to enter in the current date and the current time into a cell. This method is done by pressing CTRL+; to enter the current date and CTRL+; for the current time. The reason this is a better data-entry technique is because it eliminates any possibility of error and ultimately is more efficient. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=eR4LPA7p_DU
Views: 16011 Subjectmoney

01:24
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=Microeconomics Welcome to Subjectmoney.com's video dictionary. In this video we are covering the definition of Microeconomics. We built this video dictionary for people to use to study when listening makes more sense than reading. The best way to use our video dictionary is to create a playlist in your Youtube account and add only the terms that you need to learn. Then you can play your playlist using a computer or your mobile device while cooking, resting, driving, walking etc...
Views: 775 Subjectmoney

04:49
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=Quick%20Ratio This is part 2 of our Fundamental Analysis video tutorial series which is focusing more specifically of financial ratio analysis. In this video we cover the quick ratio aka the acid test ratio. The quick ratio (acid test ratio) fundamental analysis tool which is a liquidity ratio that describes a firm's short term solvency. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=OrFgbyxOyB4
Views: 3425 Subjectmoney

04:46
http://www.excelfornoobs.com http://www.excelfornoobs.com/exceltutorial.php?title=Excel%20For%20Noobs%20Tutorial:%20How%20to%20Navigate%20Through%20an%20Excel%20Workbook This is an Excel Tutorial that will work for Microsoft Excel 2003, 2007, 2010 and 2013. In this tutorial we cover different ways to navigate through Excel. The most common way to navigate through Excel is with your mouse and keyboard however the most informative information in this tutorial is how we get you started learning how to use Excel without a mouse or touch pad using only your keyboard. Although throughout these tutorials we cover some very basic functions of Excel, it is important to follow them all the way through if you want to become thoroughly knowledgeable about Excel. In many of these tutorial there are certain part where we teach something that could be very useful but you may have never known. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=rsQdPW0alD8
Views: 20647 Subjectmoney

10:01
http://www.excelfornoobs.com http://www.subjectmoney.com Welcome to http://www.Subjectmoney.com. http://www.Subjectmoney.com is an interactive website meant to help, business students, business professionals and everyone in-between. Our website has a business dictionary with examples and calculations, tutorials on business models and excel, study guides for specific college courses and much more... This is a beginners excel tutorial, obviously because it is for beginners I am only covering some of the most basic functions of excel. These tutorials are very useful but it is important to just experiment and navigate through excel to really get a good feel for it. Excel tutorial,beginners, Excel, Microsoft excel, excel for beginners, excel for dummies, Microsoft excel 2010, how to use excel, tutorial, Microsoft excel, How do I in excel, www.subjectmoney.com Follow the link below for another basic Excel tutorial for beginners https://www.youtube.com/watch?v=CapdrHxv18c https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=DCohsM9Fk2o
Views: 31768 Subjectmoney

01:40
http://www.excelfornoobs.com In this tutorial we are showing you how to add a background image to your Excel workbook. This would be useful if you were creating a report and the company required the company logo to be inserted into the background of the report. Please be sure to visit our website at http://www.excelfornoobs.com https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=pP03IjOXfEk
Views: 24987 Subjectmoney

01:14
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=A%20Useless%20Good A Useless Good is exactly as it is named, a good with no added benefit to society. If you were stranded on a deserted island and had a choice between dollar bills and food, you would not be willing to trade food for dollar bills because dollar bills would be of no use on a deserted island. Your Indifference Curve (curve showing a combination of goods that all give the same level of happiness) among these two goods would be a vertical line because it doesn't matter how many dollar bills you are offered, you would still rather have the food. If you had enough energy to collect either 20 pounds of food per week you would want to use your energy to gain 20 pounds of food no matter how many dollar bills you might be able to use that energy finding. If you could find 1 dollar bill or \$1 million dollar bills, you would still rather gather 20 pounds of food because dollar bills are useless.
Views: 705 Subjectmoney

03:46
Views: 1999 Subjectmoney

02:59
Views: 2647 Subjectmoney

05:37
http://www.subjectmoney.com http://www.subjectmoney.com/Exceldisplay.php?title=Microsoft%20Excel%202010%20Tutorial%20Part%201:%20A%20Description%20of%20Excel%20Workbooks%20and%20Worksheets The work you perform in Microsoft Excel is done in a workbook file. You can open as many workbook files as you would like and Excel uses .xlsx as the file extension. Each workbook is made of worksheets which are made up of individual cells where you can add content, data, numbers, equations or whatever else you may want to add. You are also able to add content outside of the individual cells by using tools such as charts, text, wordart and many other features that Microsoft Excel 2010 has to offer. In this simple excel tutorial we are going to help make you familiar with excel workbooks and worksheets which will be necessary to successfully understand all of the other Excel tutorials that we offer. In the image below we show the excel screen labeling the parts that you need to know along with a description of what they are. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=Aw9bKVfZdrI
Views: 3730 Subjectmoney

00:41
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=Liquidity Welcome to Subjectmoney.com's video dictionary. In this video we are covering the definition of Liquidity. We built this video dictionary for people to use to study when listening makes more sense than reading. The best way to use our video dictionary is to create a playlist in your Youtube account and add only the terms that you need to learn. Then you can play your playlist using a computer or your mobile device while cooking, resting, driving, walking etc... https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=bPeDudbbAGU
Views: 1335 Subjectmoney

02:30
Although bonds normally promise a fixed flow of income, this does not mean that they are riskless investments. Although U.S. government bonds are treated as risk-free, this is not the case for corporate bonds. If a company goes bankrupt then the bondholders will not receive the payments that they have been promised and therefore there is some uncertainty surrounding future bond payments. This uncertainty is called default risk. The default risk is measured by Moody's Investors Services, Standard & Poor's Corporation, and Fitch Investors Service. All three of these entities provide financial information on firms as well as well as ratings on corporate and municipal bonds. Investment Grade Bonds Bonds that are rated BBB or above by Standard & Poor's, or Baa or above by Moody's are called investment grade bonds. Speculative Grade or Junk Bonds Bonds that are rated BB or lower by Standard and Poor's, Ba or lower by Moody's, or bonds that are unrated are considered junk bonds or speculative grade bonds. Bond rating agencies use financial ratios to grade bonds. The key ratios used are show below as follows Coverage ratios Leverage ratio Liquidity ratios Profitability ratios Cash flow-to-debt ratio https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=7a7b8v6Mz7A
Views: 1861 Subjectmoney

03:52
Views: 3228 Subjectmoney

04:37
Views: 812 Subjectmoney

03:50
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=Negligence Welcome to Subjectmoney.com's video dictionary. In this video we are covering the definition of Negligence (Law). We built this video dictionary for people to use to study when listening makes more sense than reading. The best way to use our video dictionary is to create a playlist in your Youtube account and add only the terms that you need to learn. Then you can play your playlist using a computer or your mobile device while cooking, resting, driving, walking etc...
Views: 585 Subjectmoney

02:46
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=AARP%20(American%20Association%20of%20Retired%20Persons) Welcome to Subjectmoney.com's video dictionary. In this video we are covering the definition of AARP. We built this video dictionary for people to use to study when listening makes more sense than reading. The best way to use our video dictionary is to create a playlist in your Youtube account and add only the terms that you need to learn. Then you can play your playlist using a computer or your mobile device while cooking, resting, driving, walking etc... https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=wzGwUtAzs2s
Views: 3887 Subjectmoney

04:14
http://www.subjectmoney.com This is a video teaching a method I use to find the future value or depreciation of a vehicle. This is a simple valuation method. I simply alter 2 major variables that determine the value or depretiation of a vehicle and then use KBB or NADA to find a rough estimate of what the vehicle will be in the future. In this method I change the year or the vehicle and the mileage. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=ZGigr8o84cg
Views: 3311 Subjectmoney

03:22
Contractual Capacity - Contractual Capacity is the ability for an individual to have the capacity to enter into a contract. A contract cannot be binding if a party does not have the capacity. For example, one could not enter into a contract with an infant because the infant would not have the contractual capacity to enter into a contract. Minors -- In most states a minor is an individual under the age of 18. Minors have the option of making a contract void. Disaffirmation -- Minors have the right to avoid a contract in their minority and for a limited amount of time after they reach their majority. If a minor does not disaffirm the contract within a reasonable amount of time after they reach majority, then the contract may be ratified. For example: If they take part in a contract and it continues two years after their majority, the contract would be ratified. If the minor lied about his or her age on the contract they may still disaffirm it without facing tort charges. Minors cannot disaffirm a partial contract; they must disaffirm the entire contract. Some states don't allow disaffirmance in the case where a consideration cannot be returned. Obligations -- Minors must return the considerations (goods) to the other party if they are in the minor's possession. These goods are required by many states to be in the original condition and if not the minor could be held liable for the damages. Liabilitities Liabilities of Necessaries -- A minor can be held liable for items that are necessary for their existence (food, clothing, shelter etc...). The values of the items cannot be excessive. They must be reasonable compared to the economic living standard. The minor must not be under the guardianship of a parent or guardian who is required to supply the items. Liabilities of misrepresentation of age -- Generally a minor may disaffirm a contract even if he or she lied about their age. Liability of Tort Connection -- If a contract is so intertwined with a tort that by enforcing the tort the court will therefore be enforcing the contract then the minor will not be held liable for the tort. Incompetent and Intoxicated Persons -- A person must be able to have the capacity to know what they are agreeing to and to have the capacity to carry out the contract. Mental Illness or Defect -- If a person that is mentally incapable of entering into a contract then if he or she enters into a contract the contract will not be enforced by the courts. Intoxicated Person -- A contract is voidable is one party was impaired or intoxicated therefore not having the ability to understand the consequences and nature of the agreement. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=hLkcgYjtw00
Views: 7464 Subjectmoney

01:28
Discount Bonds are sold at a price which is lower than their face value. Bonds sell at a discount when their coupon rate is lower than that which is offered by the market. This is because investor could purchase similar bonds and receive bigger interest payments so there is selling pressure on the lower rate bonds until they reach the correct price. If interest rates remained the same then the market value of discount bonds would rise the close they got to maturity.
Views: 331 Subjectmoney

01:19
http://www.subjectmoney.com http://www.subjectmoney.com/Exceldisplay.php?title=Microsoft%20Excel%202010%20Tutorial%20Part%206:%20How%20to%20Use%20the%20Excel%20Ribbon%20without%20a%20Mouse%20only%20the%20Keyboard Although most people like using a combination of a mouse and a keyboard to navigate through the ribbon, it is possible for people who prefer using a keyboard to access commands on the ribbon. Knowing how to navigate through excel using only the keyboard could also be useful if your mouse or touch-pad suddenly quit working, that may even be how you found this tutorial. All that you have to do to navigate the Excel ribbon using the keyboard is press the ALT button. After you press the ALT button you will see that letters and numbers representing keys will display themselves over the different tabs in the ribbon. For example, M is displayed over formulas. If you press M, Excel will activate the formula tab and then designated keys over all of the commands available under the formula tab. You can continue using the keyboard to access all commands and options within each command. The keyboard can even be used for functions under the File tab. You are able to save projects, open new files, access options and anything else that you are able to do with a mouse and keyboard. The key is to experiment with this yourself and even if you prefer to use a mouse, knowing how to use only the keyboard in excel could come in very useful. Below we have an illustration so that you can see what we are talking about. Remember, it takes practice, so open up Excel and start messing around. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=TW_2K14cLMM
Views: 2923 Subjectmoney

01:09
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=A%20Perfect%20Compliment Perfect complement goods are goods that consumers like to consume together. For example, consumers would not only want to purchase a left shoe. For a consumer to be happy with a left shoe he would also need a right shoe to compliment the left shoe. If a consumer was offered two left shoes and one right shoe then he would have the same utility as if he was offered one left shoe and one right shoe. However, if he was offered two left shoes and two right shoes then the consumer would have a higher utility than if he was offered only one left and one right shoe. The Indifference Curve would be L-shaped.
Views: 933 Subjectmoney

01:53
http://www.subjectmoney.com http://www.subjectmoney.com/definitiondisplay.php?word=International%20Bonds http://www.subjectmoney.com/definitiondisplay.php?word=International%20Bonds
Views: 877 Subjectmoney

01:16
Fraud in the Inducement is when a party intentionally deceives a person into executing a decision that would benefit the other party at their own expense. An example would be is someone encouraged another party to deed away their property telling them that they would receive tax benefits when in reality the decision would make that person worse off financially.
Views: 1078 Subjectmoney

02:32
http://www.subjectmoney.com Realized Compound Return - The realized compound return is the rate of return that one would earn if all coupon payments were reinvested. Example Let's assume that we purchased a bond for \$900 that has exactly 3 years until maturity. This bond has a face value of \$1000 and annual coupon payments of \$100. We will be receiving our first coupon payment one year from today. Now let's assume that the reinvestment rate is different than the coupon rate. Let's assume that the reinvestment rate it 9%. Ok so we already know that we are receiving \$1000 in a final payment for the bond and we know that we spent \$900 for this bond. Now we need to figure out how much we will receive from reinvesting our payments at 9% for the next 3 years. We will then add that amount to the \$1000 payment of the face value to find out what our total realized return will be 3 years from now. First let's find out what our payments will be worth if reinvested at 9% 100(1.09^2) + 100(1.09) + 100 = \$327.81 If we reinvest our coupon payments at 9% then they will be worth \$327.81 3 years from today at maturity. We know we will also be receiving the payment for the face value of \$1000 at maturity so 3 years from today our investment will be worth the face value plus the reinvestment of the coupon payments. \$1000 + \$327.81 = \$1327.81. Remember that we paid \$900 for this bond so we just need to figure out the rate of return that \$900 is earning to be worth \$1327.81 3 years from today. \$900(1+ r)^3 = \$1327.81 The best way to calculate this would be to use your financial calculator. N=3 I/Y = ? PV= (\$900) PMT = 0 FV= \$1327.81 Now you would just compute the I/Y to get your Realized Compound Return Realized Compound Return = 13.84% Reinvestment Rate Risk Reinvestment rate risk is the uncertainty surrounding the reinvestment rate of the coupon payments. If rates were to rise then the market value of the bond would lose value however the reinvestment rate that the coupon payments could earn would go up, so there is a tradeoff. If rates were to drop then the market value of the bond would go up but the rate at which the coupons could be reinvested would go up. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=AS_5_VLGmxo
Views: 14949 Subjectmoney

04:04
Considerations -- Considerations are a legal concept pertaining to contract law. In order for a contract to be formed there must be a promise or promises of something of value such as goods, funds, services, performances, non-performances etc... These are the considerations of the contract. In a bilateral contract, if Bob offers Tim \$500 to paint his house, the considerations would be Bob giving Tim \$500 and Tim painting Bob's house. In a unilateral contract if a radio station promises 2 game tickets to the 1st caller to answer a question correctly, the considerations are the tickets given by the radio station and the 1st person to correctly answered questions. In common law considerations are a requirement for forming a contract. Legal Sufficiency -- The considerations must have value that is recognized by law to make them legally sufficient. These considerations must be either a benefit or a detriment to a party involved in the contract. A legal benefit is when a party receives something of value that they previously didn't have the right to. A legal detriment is when someone performs an act that they were not previously obligated to do or not perform an act that they previously were obligated to do. Preexisting Obligations: Preexisting public obligations - preexisting public obligations are obligations that are imposed by a tort or criminal law. These obligations are neither a legal detriment or a legal benefit. Preexisting Contractual Obligations: These are performances from a preexisting contract and cannot be used as considerations. Modification of a Preexisting Contract - Under Common Law a modification must be supported by mutual consideration, under that code a contract can be modified without new consideration. s. 672.209. Substituted Contracts - This is when the parties agree to rescind their original contract and enter into a new contract. This is supported by considerations. Settlement of Undisputed Debt - settling for a lesser sum of money to clear an undisputed debt does not constitute a legally sufficient consideration. Settlement of a Disputed Debt - Settling for a lesser sum of money to discharge a disputed debt is a legally sufficient consideration. Past Consideration - A past consideration is a performance that completed prior to the contract being formed and will not be a legally sufficient consideration. Promise to Perform Unenforceable Obligation May Be Enforced Promise to Pay Debt Barred by the Statute of Limitations -- a new promise by the debtor to pay the debt renews the running of the statute for a second statutory period. Promise to Pay Debt Discharged in Bankruptcy -- may be enforceable without consideration. Voidable Promises -- a new promise to perform a voidable obligation that has not been previously avoided is enforceable. Moral Obligation -- a promise made to satisfy a preexisting moral obligation is generally unenforceable for lack of consideration. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=pd2y-2w64SA
Views: 6077 Subjectmoney