Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,980 --> 00:00:08,020
In this way do you learn how to use common financial functions or formulas in Excel.
2
00:00:11,130 --> 00:00:14,790
Will you as a case study to learn how to use these functions.
3
00:00:15,980 --> 00:00:23,080
So what is the owner of a small scale manufacturing company he's planning to invest in a new machine
4
00:00:23,530 --> 00:00:31,630
that will double that production at its factory the investment in machinery will cost him 5 lakh rupees
5
00:00:33,000 --> 00:00:42,540
and he is negotiating with two banks for a loan the worksheet investment data provides details about
6
00:00:42,540 --> 00:00:54,370
these two bank loan offers column B has offer from banking and column B has offer from bank B the loan
7
00:00:54,370 --> 00:00:54,810
amount.
8
00:00:54,820 --> 00:01:03,150
In both cases is the same will be fine leg bank is offering loan for 48 months at 10 percent annual
9
00:01:03,220 --> 00:01:12,140
interest rate bank B is offering the loan for 60 month at twelve percent rate of interest that cash
10
00:01:12,140 --> 00:01:22,530
flow from investment in new machinery table shows cash flow from the investment in the new machinery
11
00:01:25,370 --> 00:01:29,610
at the start of this project or investment.
12
00:01:29,770 --> 00:01:36,720
So I promise to invest in 5 lack so it is shown as a negative cash flow.
13
00:01:36,810 --> 00:01:47,930
It is going out from Year 1 through year 5 the project is giving positive returns for start ups company
14
00:01:49,250 --> 00:01:57,810
the cash flow from the project I listed in column F to get Sara needs to decide which loan offer he
15
00:01:57,810 --> 00:02:02,620
should accept and which loan he'll be able to serve.
16
00:02:03,180 --> 00:02:10,410
Using the cash generated from the investment so he should be able to repay the entire loan repayments
17
00:02:11,280 --> 00:02:13,910
using cash generated from the investment.
18
00:02:15,460 --> 00:02:22,730
So the maximum amount as you can see he can repay in a year is one like forty thousand in Year 1 and
19
00:02:22,740 --> 00:02:32,110
2 1 like sixty thousand any three one like eighty thousand in the year full and black in your file since
20
00:02:32,110 --> 00:02:39,660
the loans are repaid in equated monthly installments the loan repayments are going to remain constant
21
00:02:39,660 --> 00:02:49,810
over the duration of the loan in effect sort of has to say which loan he can repay.
22
00:02:50,100 --> 00:02:54,710
Using the minimum cash flow or the five year period which is one like forty thousand.
2686
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
Afrikaans
Akan
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Faroese
Finnish
Galician
Georgian
German
Greek
Guarani
Haitian Creole
Hausa
Hawaiian
Hebrew
Hmong
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kyrgyz
Laothian
Latin
Latvian
Lithuanian
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Norwegian
Pashto
Persian
Polish
Portuguese (Brazil)
Quechua
Romanian
Romansh
Russian
Samoan
Scots Gaelic
Serbian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Swedish
Tajik
Thai
Tigrinya
Tonga
Turkish
Turkmen
Ukrainian
Uzbek
Vietnamese
Welsh
Wolof