Financial Formulas

[Marlon Tomera]

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

 

[Victor Delta]

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/excel/HP052001811033.aspx

V

 

[Niek Otten]

Hi Marlon,

You could start here:

http://office.microsoft.com/en-us/excel/HA011117451033.aspx