QuickBooks Online 2021. Make a loan amortization table, which we will then use to record loan payments within QuickBooks Online, making the loan amortization table with the help and use of Excel. Let’s get into it with Intuit QuickBooks Online 2021. Here we are, in our great guitars a practice problem, we’re going to be thinking about making payments on loans and breaking those payments out between interest and principal. As we do so, we’re going to be needing an amortization table. To help with that.
Advanced financial accounting PowerPoint presentation. In this presentation, we’re going to discuss foreign currency exchange rates get ready to account with advanced financial accounting, foreign currency exchange rates, let’s first define foreign currency transactions. So what are from foreign currency transactions? When are we going to need to account for foreign currency transactions. So from our perspective, we’re going to be looking at this from the perspective of a US company US company that is having their books then accounted for or measured in dollars. And when you think about the foreign currency transaction, it’s just like anything else, but it can be a little bit more confusing. So you want to remember, of course, that the dollar is basically the measuring tool.
Advanced financial accounting PowerPoint presentation. In this presentation we will discuss the remeasurement process for financial statements of a foreign subsidiary. Get ready to account with advanced financial accounting remeasurement financial statement of foreign subsidiary remeasurement overview so we’re going to go through the process of the remeasurement. As you think of the measurement process, you want to be comparing and contrasting it to the translation process. So you’re envisioning basically you got a parent company. The parent company has a subsidiary the subsidiary is a foreign subsidiary. The subsidiary then conducts their books. Typically we’re thinking in a foreign currency right, that subsidiary is conducting their books in a foreign currency. If we need to consolidate the subsidiary into the parents financial statements, the parent uses dollars to measure their books subsidiary uses a foreign currency on the bookkeeping side, how do we get them over $2 so we can do the consolidation process. two methods generally we can use a translation method or a remeasurement method, and we have to determine which method we’re going to use by determining what the functional currency is. And once we know what the functional currency is, then we can determine whether we need to use the translation method or the remeasurement method. And they’re going to be slightly different. Now note, there’s also a third kind of option where we might have to use translation and remeasurement if there was a situation where the foreign currency has the financial statements, and something other than the US dollars and then the functional currency was not the currency that their bookkeeping was in, and it’s not the US dollar.
Advanced financial accounting PowerPoint presentation. In this presentation, we will discuss translate financial statements of foreign subsidiary, get ready to account with advanced financial accounting, translate financial statements of foreign subsidiary. So we’ll go through the general process of the translation process for the revenue and expenses, the average exchange rate for the period covered by the statement is the rate that is generally going to be used. And again, this would make sense, because if we’re talking about the revenue and expenses, we can’t really pick one rate, because that is a statement of how the performance did over time from beginning to the end. And therefore we need to use some kind of rate that would be representative and it wouldn’t really make sense to use the rate at the end of the timeframe but possibly some average of it. So a single material transaction is translated using the rate in effect on the translation date. So then there could be an argument that could be made we could say okay, so We’re not going to use just one rate, like at the end of the time period like we’re using on the balance sheet generally, because that would make more sense on the balance sheet because it’s reported as of a point in time. But on the income statement, yeah, it makes more sense for us to use some rate that’s kind of reflective of the timeframe. So possibly we’ll use an average rate. But what if we have this really material type of transaction that’s really large transaction, maybe in that case, we should we should deviate from just an average rate and use the rate as of that point in time or like a historical rate at that point in time. assets, liabilities and equity. So now we’re talking about the balance sheet. So for the most part on the balance sheet, you would think all right, it would make more sense then for us to be using the current exchange rate, which would be as of the date of the balance sheet date. So which says as of the end of the time period, if we’re talking for the for 1231 income statements or financial statements for the year ended 1231 then we’re talking 1231. The end of the time period is when all the balance sheet accounts are reporting as Oh, As of that point in time, and therefore, for the most part, you would think that the current exchange rate, the rate as of that point in time would work. However, you can also think that the historical exchange rate might be used for some items, some, again, some kind of large items power, possibly for the property, plant and equipment.
Advanced financial accounting PowerPoint presentation. In this presentation we will discuss translation versus remeasurement. Get ready to account with advanced financial accounting, translation versus remeasurement methods to restate to foreign entities statements to US dollar. So the most straightforward methods can be translation of foreign entities functional currency statement to US dollars. So the translation is what we’ll use the most straightforward method when the entity statement is using the functional currency. So typically, if the if the entity is using the functional currency, and we need to translate it, then we’ll simply translate it from the functional currency to the US dollars. And then there’s remeasurement of foreign entities statement into its functional currency. So remeasurement means that the entity is running their bookkeeping in a currency that is not the functional currency. Right? So then we’re going to have to re measure we’re going to use this term re measure rather than translate the To the functional currency, so after we remeasure to the functional currency, after remeasurement statements need to be translated to the reporting currency if the functional currency is not the US dollar. So in other words, if we’re assuming, in this case, in the case of the remeasurement, or let’s say, we have an entity that we’re going to be consolidating a subsidiary entity in another country, and we’re in the US and we need to basically consolidate these data together in terms of US dollars at the end of the day, if the entity is using the functional currency as as their financial statements, their bookkeeping is in the functional currency, then we can simply use the term translate it to the US dollars, which will be the parent currency that we’re talking about here. If however, the foreign entity is having their books in some currency, that is not the functional currency, then what we’re going to have to do is re measure it. We want to use remeasurement To the functional currency, we want to make remeasure at first to the functional currency rather than straight to the US dollar. So we’re going to use remeasure to the functional currency. And after we re measure to the functional currency, if the functional currency is the US dollar, then then we should be able to stop there. That’s okay. If however, the functional currency is not the US dollar, then we would have to go from the functional currency and then translate to the US dollar. So we’ll talk a little bit more about that as we go. So let’s think about translation.
Advanced financial accounting PowerPoint presentation. In this presentation we will discuss functional currency get ready to account with advanced financial accounting, functional currency. When financial statements are restated from a foreign currency into US dollars, we must consider which exchange rate should be used to translate the foreign currency amounts to the domestic currency. So, when we translate the foreign currency to the domestic currency, we’ll have to determine what our exchange rate Are we going to be using in order to do so how will we account for translation gains and losses? So if there’s going to be a translation gain or loss, what are we going to do with that? In other words, should we put the translation gains and losses as part of the income statement reporting it on the income statement, the gains and losses that are due to the translation process exchange rates that may be used? So what kind of exchange rates might we use during this exchange process? Well, we could use the current rates probably the first thing that comes to mind you say, Hey, we got the financial status. As of the year ended of this time period, why don’t we just use the current rate. And that’s typically what we will do for the balance sheet amounts. And that typically makes sense for the balance sheet amounts, because remember, the financial statements, of course on the balance sheet represents where we are at a particular point in time. So simply converting them makes some sense on the balance sheet. But you also might think, Well, what about those things, you know, that we purchased, like fixed assets at a point in time, maybe we should use the point in time that we had the purchase took place. So you could argue on that on the balance sheet, but the current rate on the balance sheet and makes the most sense, but if you’re looking at the income statement, the current rate might not make as much sense because we’re measuring a timeframe that from a year will, let’s say, for a year’s timeframe from the beginning to the end, so maybe it doesn’t seem quite right to use simply the current rate, which would be the rate as of the end of the financial statements if we’re talking like December 31, rather than using some type of race. That would be representative of the period that would covered being January through December, we could use the historical rate, that’s gonna be the rate that exists at the time the initial transaction took place. And again, this one is often would make sense to us if we’re talking about a situation like if we bought equipment or something like that fixed assets, property, plant and equipment, large purchases that are on the books, we might say, well, maybe we should be putting those on the books at the rate that we should be using at the time, basically, the transaction took place. So maybe we would argue for the historical right there. And then we have the average rate for the period, generally a simple average for a period of time, usually the exchange rate used to measure revenues and expenses.
Advanced financial accounting a PowerPoint presentation. In this presentation, we will discuss forward exchange contracts get ready to account with advanced financial accounting, forward exchange contracts. Now we’re going to go over some of the components of the foreign exchange contracts here, we’ll go into them on a lot more detail as we work through practice problems related to the forward exchange contracts. But just to visualize the basic kind of layout of a foreign exchange contract as you think about these items, and there’ll be a lot more concrete once we look at practice problems, we’re basically have a setup where we’re going to be working with a bank or a dealer, typically a bank, and we’re going to be setting up a foreign exchange contract which is basically going to say, we have a receivable and payable on the books at this point in time and we’re either going to put the receivable or the payable that is going to be due to us or something that we will pay in foreign currency at the end of the time period. Whereas the other side the receivable or the payable, the other side that’s not in foreign currency will be in US dollars. In other words, we We will determine the amount that will that we’re talking about. And then we’ll use an exchange rate which we’ll talk a little bit more about the exchange rate that we will use to value it in today’s dollars will put either the receivable or the payable in US dollars and either the receivable or the payable and foreign dollars as of this point in time. And then as time changes, as the rate of the foreign currency changes, then that could result in the difference between, you know, what we thought the value would be, at the point in time we went into the forward contract between the US dollar and the foreign currency as that difference changes over time that could result in basically a gain or loss.
In this presentation, we will calculate the bond price explaining how this can be done using present value formulas within Excel. Remember that the bonds is going to be a great tool for both accounting and finance to describe the present value calculation. So that’s why it’s going to be used. Oftentimes It has two cash flows related to it, one’s going to be the face amount of the bond that’s going to be due at the end of the term of the bond. In our case, it’s going to be two years semiannual or four time periods. And the other is the flow of interest. So bonds are a great example because they have the two types of present value problems that we need in one area. So even if you’re not in an area where you’re dealing with bonds all the time, they’re still going to be used and useful to understand present value types of calculations. So here we’ve got the bond is going to have one cash flow of 100,000 at the end of four periods or two years, and we need to figure out what the present value is in order to price it back here at your at time period zero. And then we have these four payments in terms of the annuity 4000. And we need to take those and present value them, we could take each period and present value each payment and present value it. But the easier thing to do is to present value, an annuity when it’s applicable and present value, the one amount when it’s applicable. And therefore think of that about these as two basically separate cash flows that we’re going to have to present value separately. So we can do this multiple different ways. And it just depends on what you’re what tools you have. And where you are, in order to know how to do it. What you want to know is just that there’s different tools to do it. Anytime someone uses a different tool. What are they doing the same thing? And and when can you apply these tools and what’s actually happening here. So that’s what’s actually happening. We’re present valuing this information.
In this presentation, we will calculate the bond price using present value tables. Remember that the bonds is going to be a great tool for understanding the time value of money. Because of those two cash flow streams we have when with relation to bonds, meaning we’re going to pay the bond back the face amount of the bond, and we’re going to have the income stream. And those are going to be perfect for us to think about time value of money, how to calculate time value of money, our goal being to get a present value of those two streams. So we’re going to think of those two streams separately generally, and present value each of them to find out what the present value of the bond will be. We can do that at least three or four different ways. We can do that with a formula actually doing the math on it. We can do it now, which is probably more popular. Now. Do it with a calculator or with tables in Excel, I would prefer Excel or we can use just tables pre formatted tables. The goal here the point is to really understand what we’re doing in terms of what what is happening, what can it tell it? What can it tell us, and then understand that these different methods are all doing the same thing.
In this presentation, we will take a look at present value formulas related to bonds. One of the reasons bonds is so important to accounting and finance is because they’re a good example of the term of present value of money. We’re trying to look for an equal measure of money, when we think of bonds and bonds is going to have this relationship between market rates and the stated rate, which helps us to kind of look through and figure out these types of concepts. So even if we don’t work with bonds, in other words, if we’re not planning on issuing bonds, or buying bonds, or knowing anything about bonds not being important to us, the time value of money is a very important concept and bonds is going to be a major tool to help us with that. Why is bonds so useful for learning time value of money, because there’s two types of cash flows with bonds meaning at the end of the time period, we typically are going to get the face amount of the bond that 100,000 similar to a note and then we’ve got the interest payments that are going to happen on a periodic To basis, and therefore we have these two different types of cash flows, that we can use two different formulas for, to think about how to equalize.