Question about Microsoft Excel for PC

1 Answer

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


1 Answer

71 x 5555

Posted on Jul 18, 2008


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

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)
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

1 Answer

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]

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

3 Answers

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

1 Answer

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

2 Answers

Does bill consolidation loans for bad credit really work?

If you have bad credit at that point you won't qualify for actual credit where you pay off your financial obligations with a loan from a bank as well as salary that back in month-to-month installments. Debt consolidation typically describes a high-risk practice of financial debt settlement: purposely skipping on your charge card to attempt to force your creditors to settle for less. Stay away from any sort of "financial debt consolidation" professional that guarantees to slash your financial debt as well as repayments in half with debt settlement deal ... This is a high-risk strategy of purposely stopping all payments to creditors as well as requiring your accounts into default to try settlements. You pay a monthly cost to a debt consolidator ... this entire fee goes to building a negotiation account as well as to the consolidator's charges to "settle" your accounts in the future. Your charge card business will deliberately not be paid so that all the accounts will default/charge-off so that they can try settlement deals at around 50 %. If you are present on your accounts, this process will definitely ruin your credit ranking for sure. Financial debt settlement is like a roll off the cubes with your financial resources ... You could never anticipate just how your creditors will answer the thoughtful skipping of your accounts ... they might settle at 50 % ... or they might serve you a summons, take you to court ... and if they earn, you might be considering wage garnishment.

Aug 31, 2012 | Finance

1 Answer

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:

1. Log in to 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

2 Answers

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...

1 Answer

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...

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

100 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18419 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides