how to do it?

A

aiden

can anybody tell me how to use the excel functions to do the following table?

(capital required providing $10 per month for a specific period)
Interest
Year 2.00% 3.00% 4.00% ...
1 119 118 118
2 235 233 230
....
 
H

Harlan Grove

can anybody tell me how to use the excel functions to do the following table?

(capital required providing $10 per month for a specific period)
Interest
Year 2.00% 3.00% 4.00% ...
1 119 118 118
2 235 233 230
...
Click to expand...

I generated the following table

_____2%______3%______4%______5%
1 118.71 118.07 117.44 116.81
2 235.07 232.66 230.28 227.94
3 349.13 343.86 338.71 333.66
4 460.93 451.79 442.89 434.23

in A1:E5 by entering the rates in B1:E1 and the years in A2:A5, selecting B2:E5
with B2 active, typing the formula

=PV(B$1/12,$A2*12,-10)

and pressing [Ctrl]+[Enter].
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

relective formula 0
Which functions and Procedure to use to have desired result? 0
Adding intermittent rows to a spread sheet 2
The fourth conditional format 8
Very easy question! (But not sure what to call it - maybe transpos 3
Calculating interest due on late loan payments 1
Automatic entering of information from another worksheet if given 0
income protection calculation table 1

Top