| Computing desk | ||
|---|---|---|
| < March 17 | << Feb | March | Apr >> | March 19 > |
| Welcome to the Wikipedia Computing Reference Desk Archives |
|---|
| The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
(I'm not sure if this belongs here or in the maths section).
Excel has a number of financial functions (e.g. FV) to calculate interest on accounts and debts and so forth. The help file for the FV function states the following:
Is this correct? This appears to be treating a 12% apr as equivilent to a 1% monthly rate. But doesn't 1% monthly interest correspond to an anual equivilent of (1.01)^12 - 1, which comes to 12.68%. In this case, the difference is small (for one year only), but with periods or larger rates (e.g. Payday loans with 1000% or more arp) it could become really significant. Is Excel giving incorrect instructions, or am I getting my maths/accounting wrong? Iapetus (talk) 14:38, 18 March 2015 (UTC)
Let's consider the example of £100 put in a savings account that pays 5% annual interest. In the scenario of simple interest, your expression of =FV(.05,1,0,-100) is correct, and gives the correct answer, 105. I don't know about the UK, but in the US, it is not typical for a bank to pay simple interest at 1 year intervals. It is more typical to pay monthly interest. So if you put the money in January 1, you could go to the bank on February 1 and withdraw £0.42. Strictly speaking, some months you would get £0.42 and some you would get £0.41 so it averages out to the correct interest rate. At the end of the year you would have withdrawn £5. Your other choice would be to leave the money in the account, so the principle for the February interest calculation is £100.42, and so on. The Excel formula becomes =FV(.05/12,12,0,-100) and the result is £105.12. Jc3s5h (talk) 15:20, 18 March 2015 (UTC)
Hello... I wanted to know which are the advantages and disadvantages of a barebone computer. Can anybody help me? Miss Bono [hello, hello!] 12:47, 18 March 2015 (UTC)
If I am to call android phone to android phone via wifi, how can I do it if there is no any apps installed in the receiver. Apps like skype, viber all need both caller and receiver install the apps. How can I call only through wifi with no such apps installed in the receiver ? I am from Nepal.
Learnerktm 14:29, 18 March 2015 (UTC)
I went on to W3schools aiming to find an explanation which is enough ordered, clear, concrete, and didactic, but unfortunately, I couldn't find such for that matter...
Can some please explain, with a Generous hand, and in a simple, ordered way, what actually does this "Clear" Command?... What is being "Cleared" at the screen and where does the "mess" go to?...
Thanks. Ben-Natan (talk) 15:01, 18 March 2015 (UTC)