EMI BY NEW METHOD
I am presenting a new method of arriving EMI.
I have prepared the calculator sheet, butnot know to attach.
the details are copied as text.
Pl help to attach the calculator.
In the meanwhile pl examine the underfurnished details
Method of arriving EMI other than PMT or algebraic formula.
I am presenting a methodology by which we can arrive the EMI, BY
which is different from our PMT function.
Please click the FORMULA SHEET.
Fill the green cells.
The calculator arrives figures of FD cumulative and RD value.
The formula can be put as:
EMI for amount A for period N and interest rate R, will be
=Maturity value of Amount A for N + 1 months at rate R /
A METHOD TO ARRIVE EMI BY USING FD CUMULATIVE AND RECURRING DEPOSIT
LOAN AMOUNT 500000 presented by :
PERIOD 120 (MONTHS) (N) RAMA_51
INTEREST RATE 11 (MONTHLY RESTS)
E M I Rs.
THE METHOD EXPLANATION:
A fixed deposit - cumulative interest.
ARRIVE THE MATURITY VALUE OF THE LOAN AMOUNT
Amount 500000 FOR '(N + 1)' MONTHS (see value against A1(cell A16))
period 121 (months) (N +1)
interest 11 ARRIVE THE MATURITY VALUE OF RD FOR Rs.1/-
AT THE SAME RATE FOR ' N' MONTHS
A1 maturity value 1508275.07 (d5*(1+d7%/12)^d6)
see value against B1(cellA23)
B Recurring deposit - using the function FV
amount 1 E M I , will be (A1) / (B1)
period 120 ( N)
interest 11 Thus:
EMI, for an amount A , period N, and interest R, will be:
B1 maturity value 218.99 =Maturity value of A for N+1 months at interest R
EMI WILL BE A1/B1
maturity value of RD for period N at same interest for Rs1/-
LIABILITY AFTER A PERIOD
DATA FROM FORMULA SHEET BROUGHT FORWARD presented by:
LOAN AMOUNT 500000 RAMA_51
PERIOD 120 (MONTHS) (N) Please fill the green cell to arrive
INTEREST RATE 11 (MONTHLY RESTS) a liability after a period run
E M I 6887.500565
TO ARRIVE THE LIABILITY OF THE LOAN AFTER A PERIOD LESS THAN THE TERM OF THE LOAN
(INTEREST RATE IS TAKEN SAME AS ABOVE
PERIOD RUN 80 MONTHS <<
the loan period,
FD VALUE FOR 81 MONTHS 1047043.37
A the liability reads
RD VALUE FOR
EMI AMOUNT 80 MONTHS 815169.55 B
Liability after 80 months will be >> 231873.81
Anwsers to the Problem EMI BY NEW METHOD
Manually editing the Windows registry to fix Error EMI BY NEW METHOD
Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.
- Click the Start button.
- Type "command" in the search box... DO NOT hit ENTER yet!
- While holding CTRL-Shift on your keyboard, hit ENTER.
- You will be prompted with a permission dialog box.
- Click Yes.
- A black box will open with a blinking cursor.
- Type "regedit" and hit ENTER.
- In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
- From the File menu, choose Export.
- In the Save In list, select the folder where you want to save the Windows Operating System backup key.
- In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
- In the Export Range box, be sure that "Selected branch" is selected.
- Click Save.
- The file is then saved with a .reg file extension.
- You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.
Another Safe way to Repair the Problem: EMI BY NEW METHOD:
How to Fix EMI BY NEW METHOD with SmartPCFixer?
1. Download SmartPCFixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.
Related: Startup Error Failed to connect to a Windows service System Event Notification Service sic Task Scheduler not always closing down program text wrap not working in Word Upgraded my computer from Windows Vista to Windows 7 Now my Lexmark Z515 printer will not work Can someone please help me The drivers for USB 2 0 arent showing up and dont seem to be usable I have ServicePack s 1 thru 3 The drivers used to show and work but not any more Is there a way I can get them back so my 2 0 items will work properly Symbols are not displayed in PDF when word is converted to pdf using Save As PDF Microsoft Addin The Security Center has not recorded an antivirus product when tried to generate System Health Report When conducting a search on Google or Bin search results are not visible I get a blank white page Ulead Photo Express 5 SE does not work with Win7 USB 2 0 devices plugged into USB 3 0 do NOT appear in Safely Remove HW VBA Excel find matching list files and copy to another folder What can I do to eliminate the not responding message I constantly get Web Proxy Not Responding USB Microsoft Mouse Not working upon boot whatsapp not connecting What should I do if my CD Drive reads some CDs but not others,Issues With Downloads And Installations Since Fresh Install Of Windows 7 64bit,Windows 8 - Browsers Font Rendering Issue! Blocky Fonts Text,Why Some Of Links Are Not Functioning In Web Pages (IE8)?,Internet Stops Working,Nesting Functions???,IMesh Is Not Working Only Minimizes,I Can't Uninstall ITunes And SupportSolutionsFramework.msi,I Have 3 Columns Out Of Many Columns Of Data Each With Hundreds Of Rows, I Need To Identify The Lowest Number In Each Row For These Three Columns Only And Reference The Column Title For That Particular Number.,Divide Information Into Two Columns,My Asus T100 Transformer Wont Turn On
Read More: How to Resolve - If statement with 2 criteria requirements?,How to Resolve - .mht Files Can Not Be Opened in Vista?,[Anwsered] How do I configure Windows Live Mail? My problem is that inline pictures do not forward.,Troubleshoot:why does my windows 7 not support themes or how to make it support themes Error,How to Fix - Index page duplicates?,Alps pointing device stops working and resumes.,Attempting to use Conditional Formating with a variable,internet options not opening on IE 10,cannot open my emails. they are there but will not open,Microsoft Works 9 does not keep History items.