ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Financial Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/237371-financial-formulas.html)

Marlon Tomera[_2_]

Financial Formulas
 
I am trying to set up a financial spreadsheet for (Simple Interest, compound
interest, continuous compound interest, annual percentage yield, annual
percentage yield continuous, future fale of an ordinary annuity, sinking
fund, present value of an ordinary annuity, and ammortization. I am looking
for the formulas to use so all I have to do is enter the basic known
variables and have the correct answer come up in a cell of my choosing? Can
anyone help me out here please, I'm flunking my business algebra class and in
need of some help? Thank you
--
Marlon Tomera

Victor Delta[_2_]

Financial Formulas
 
"Marlon Tomera" wrote in message
...
I am trying to set up a financial spreadsheet for (Simple Interest,
compound
interest, continuous compound interest, annual percentage yield, annual
percentage yield continuous, future fale of an ordinary annuity, sinking
fund, present value of an ordinary annuity, and ammortization. I am
looking
for the formulas to use so all I have to do is enter the basic known
variables and have the correct answer come up in a cell of my choosing?
Can
anyone help me out here please, I'm flunking my business algebra class and
in
need of some help? Thank you


Why not just use Excel's financial functions?

This may help as well
http://office.microsoft.com/en-gb/ex...001811033.aspx

V


Niek Otten

Financial Formulas
 
Hi Marlon,

You could start he

http://office.microsoft.com/en-us/ex...117451033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Marlon Tomera" wrote in message
...
I am trying to set up a financial spreadsheet for (Simple Interest,
compound
interest, continuous compound interest, annual percentage yield, annual
percentage yield continuous, future fale of an ordinary annuity, sinking
fund, present value of an ordinary annuity, and ammortization. I am
looking
for the formulas to use so all I have to do is enter the basic known
variables and have the correct answer come up in a cell of my choosing?
Can
anyone help me out here please, I'm flunking my business algebra class and
in
need of some help? Thank you
--
Marlon Tomera




All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com