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

6ya6ya
  • 2 Answers

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

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

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

Are There Any Fees When I Apply For A Business Loan?


The interest rate you will pay on your Business overdraft is linked to the Bank of England Bank Rate, which may change from time to time.
Based on our assessment of your individual circumstances, we may offer you a rate of 10.31% per annum (10.06% plus the current Bank of England Bank Rate). This is correct as at 4th August 2016.
If it is not prearranged, the Unauthorised Borrowing Interest rate is 26.4%.
The unauthorised borrowing interest rate has been effective from 01/08/2005 and was last reviewed on 09/03/2009.

The Unauthorised Borrowing interest rate is not linked to the Bank of England Bank Rate and can be changed by the bank at any time. In accordance to account terms and conditions, notice will be provided for changes to the unauthorised borrowing interest rate.

You'll pay an arrangement fee of up to 1.5% on your overdraft, which is related to the amount you borrow. We'll also discuss the terms with you before any overdraft is taken out.

To cover our administration costs for smaller facilities, there will be a minimum scale charge of between £100 and £250 resulting in the overall charge being more than 1.5%.

Aug 16, 2016 | The Business & Productivity Software

2 Answers

What Is Equity Financing Program?


An equity financing program is a government funding in your business enterprise. Unlike banks and investors, the government is much less worrying approximately the returns on their investments, so your business is under much less stress to deliver profits.

Feb 16, 2016 | Business & Productivity Software

3 Answers

I have an Accounting problem I have an Accounting problem that I am not understanding, need help with it. Preparing a work sheet, adjusting and closing entries, and financial statements. This is the...


Hi,

Download the answer from the file i have already uploaded for you.

http://rapidshare.com/files/407376727/2009-08-24_110929_Taran.xls

Let me know,if needed further assistance.

Hope i helped you.

Thanks for using ' Fixya ' and have a nice day!!

Jul 16, 2010 | Microsoft Office Accounting Professional...

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

Calculate Quarters between any two dates


not sure if this is what you are after entirely but should at least help you out some what

=DATEDIF(A3,C3,"m")/3

As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates

May 09, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Multiply a value by a minimum amount


You need a cell to put these numbers first. Lets say A1 is your reference cell where the numbers are going to be input. B1 is the cell that you are going to see the calculation. Type the following formula in B1

=IF(A1<4,4*60,A1*60)

after doing this you can put any number in A1 and it will give you the calculation in B1 as the way you wanted.

Feb 24, 2009 | Microsoft Excel for PC

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

1 Answer

Emi using excel


The function in Excel for calculating EMI is not EMI but PMT. It requires minimum three arguments. They are 1. Rate of interest (Rate), 2. Number of periods (Nper) and 3. Value of loan or present value (Pv) in that order, that is, PMT (Rate, Nper, Pv) If you want to find EMI for 1 lakh at 10% annual interest for 10 years you enter the following in one of the cells: = pmt(10%/12, 10*12, 100000)

Borrowed from http://www.hindu.com/pp/2004/02/28/stories/2004022800160500.htm

Oct 13, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

99 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...