Question about Microsoft Excel for PC

# Help! calculate bank bills

Hi, I am considering borrowing using bank bills.
e.g. Face value of 100,000 payable in 60 days and has a settlement cost of say 90,000. how do I create a formula to calculate the interest rate?

Posted by on

71 x 5555

Posted on Jul 18, 2008

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How can I calculate the EMI of a business loan

Every borrower can calculate your loan EMI with three methods -
1. Formula Based:you can calculate your loan EMI with the help of given formula-

E = P x r x (1+r)n / ((1+r)n - 1)
where,
E = Each month payable EMI
P = Principal loan amount
r = Rate of interest
n = Duration of the loan

2. Excel Based:
You can also calculate your loan EMI with the help of excel sheet. But before calculating loan EMI, you need to set the above formula in excel sheet.

3.Online EMI calculator:
You can calculate your loan EMI with the help of online business loan EMI calculator . EMI calculators can calculate your loan EMI very easily without any cost.

Feb 21, 2018 | The Computers & Internet

### How can I calculate the EMI of a home loan of 90 lacs?

Banks and Non-Banking Financial Companies use the following formula to calculate EMI of a home loan. This is the formula for calculating compound interest. Applying the same formula for a home loan of Rs 90Lakhs, we get,

EMI = [P x R x (1+R)^N]/[(1+R)^N-1]

Where,
P= Amount borrowed- Here, it will be 90 lakhs
R= Rate of interest per month
N= Number of months in the home loan tenure

Going by the current lending rates followed by the financial institutions, we will consider R to be 9% per annum (to be converted to % per month) and for the loan tenure, we will take 20 years/240 months.

Substituting all values in the above formula, the home loan EMI comes out to be Rs 80,975 per month.

You can easily calculate the EMI for your home loan for any bank or NBFC using a free online Home Loan EMI calculator. You can also find this handy tool on the online portals of most banks and NBFCs. All you have to do is feed in the values in the respective fields and receive the answers.

Oct 09, 2017 | The Office Equipment & Supplies

### What Are Accounting Software Modules?

The Accounting software modules contain modules of different transactional and financial records, these modules functions together to make an Accounting Information System. All the accountants of Accounting services like an accountant in Tamworth, an accountant in sage, etc are professionals, who work in these modules to make complete the whole accounting process. Accounting Software Modules contains:
1. General Ledger Module
2. Chart of Accounts Module
3. Trial Balance Module
4. Balance Sheet Module
5. Accounts Receivable Module
6. Accounts Payable Module
7. The point of Sale Module.

Apr 14, 2017 | Computers & Internet

### What is home equity and what I need to do to find out I have home equity?

Call any local real estate broker to find out the value of your home. The "Equity" is the increased value of your home compared to what you paid for it. You can use that increase in value (Equity) to borrow money from a bank to pay bills do home improvements etc. This type of loan is called a "second" on your current mortgage. It will increase your house payment.

Jun 27, 2016 | Audio Players & Recorders

### Does bill consolidation loans for bad credit really work?

Aug 31, 2012 | Finance

### Hi i just sold an item and the money from the item was posted into my account however the money from the shipping and handling was not?

Hi there!
Once your item is sold, the system will generate a fee for that which is called the final value fee. It is a percentage eBay took for successful completed listings but it will be taken away in your bank or credit card at the end or mid of the month depending on your billing cycle. (please check your invoice in the Account tab, right side invoices)
But if the shipping cost is not included in the invoice sent to the buyer, check your listing and make sure that you didn't choose free shipping. If your shipping calculator is set but the buyer paid no shipping cost, you can then ask the buyer to pay for it. You can send the buyer a manual paypal invoice.
Here's how you can create a manual invoice using your PayPal account:

2. Click Request Money.
3. Click Create a Money Request or Create an Invoice.
4. Enter the required information.
5. Click Continue.
6. Review the information and click Request Money to send a money request or Send Invoice to send an invoice.

You can also ask several people at the same time. Just enter their email addresses, separated by commas.

I hope this helps. Have a great day!

Oct 14, 2010 | eBay Auctions

### Can I transfer money from my buisness company to my personal company?

Hi, I may be able to assist you here. If I remember my accounting procedures
Your quickbooks has 4 companies set up, you want to know if you can take money from one companies account and put it inmto another company account? Personally I have not USED Quickbooks but I have used other accounting software.. You will want to post a debit from account 1 to company 2 then for company 2 you will want to post a receipt from companyt 1 as a deposit into company 2 account.. Normally a range of numbers such as 1XXX may be used as receipts 2XXX may be used as debits..etc etc .. 4XXX accounts payable 5XXX accounts receivable as long as both accounts are kept in balance you shoiuldn't have too much difficulty I presume that your quickbooks uses the online banking for both companies?
I hope this helps

May 20, 2009 | Intuit QuickBooks® Premier Contractor...

### Accounts messed up

In my experience, if accounts payable shows them paid, then I would just delete the bill. The bills are just a bill. Once the payable shows them paid, then you would want to get the bills off the balance sheet. The accounts payable will show up on the P&L. I would try 1 transaction first and make sure everything is where it needs to be, and then go forward from there. I would discourge you away from creating bogus accounts. They can scew with the P&L.

I hope this helps.

If this helps, please rate me. Patty

Oct 29, 2007 | Intuit QuickBooks Pro 2003 Single User...

#### Related Topics:

100 people viewed this question

Level 3 Expert

Level 3 Expert