I have to create a data table with these numbers:

TERMS IN YEARS
15 20 25 30
100,000.00 7,500.02 7,500.00 7,500.00 7,500.00
105,000.00 7,875.02 7,875.00 7,875.00 7,875.00
110,000.00 8,250.02 8,250.00 8,250.00 8,250.00
115,000.00 8,625.02 8,625.00 8,625.00 8,625.00
120,000.00 9,000.02 9,000.00 9,000.00 9,000.00
125,000.00 9,375.02 9,375.00 9,375.00 9,375.00
130,000.00 9,750.02 9,750.00 9,750.00 9,750.00
135,000.00 10,125.02 10,125.00 10,125.00 10,125.00

What's the question?
--
Brevity is the soul of wit.


"ashley" wrote:

I have to create a data table with these numbers:

TERMS IN YEARS
15 20 25 30
100,000.00 7,500.02 7,500.00 7,500.00 7,500.00
105,000.00 7,875.02 7,875.00 7,875.00 7,875.00
110,000.00 8,250.02 8,250.00 8,250.00 8,250.00
115,000.00 8,625.02 8,625.00 8,625.00 8,625.00
120,000.00 9,000.02 9,000.00 9,000.00 9,000.00
125,000.00 9,375.02 9,375.00 9,375.00 9,375.00
130,000.00 9,750.02 9,750.00 9,750.00 9,750.00
135,000.00 10,125.02 10,125.00 10,125.00 10,125.00

I've set up a number of scenarios here, of which you select one (the upper
most left cell) and the top line calculates a return based on the selected
inputs. How do I set up the right-most column (table function?) to show the
returns for ALL of the scenarios?

Thanks for the help!

Select:
# Price INC1 INC2 ROI

15 $2,750,000 $11.00 $15.00 8.99%
1 $3,500,000 $9.00 $15.00
2 $3,500,000 $10.00 $15.00
3 $3,500,000 $11.00 $15.00
4 $3,500,000 $12.00 $15.00
5 $3,250,000 $9.00 $15.00
6 $3,250,000 $10.00 $15.00
7 $3,250,000 $11.00 $15.00
8 $3,250,000 $12.00 $15.00
9 $3,000,000 $9.00 $15.00
10 $3,000,000 $10.00 $15.00
11 $3,000,000 $11.00 $15.00
12 $3,000,000 $12.00 $15.00
13 $2,750,000 $9.00 $15.00
14 $2,750,000 $10.00 $15.00
15 $2,750,000 $11.00 $15.00
16 $2,750,000 $12.00 $15.00
17 $2,500,000 $9.00 $15.00
18 $2,500,000 $10.00 $15.00
19 $2,500,000 $11.00 $15.00
20 $2,500,000 $12.00 $15.00
21 $2,250,000 $9.00 $15.00
22 $2,250,000 $10.00 $15.00
23 $2,250,000 $11.00 $15.00
24 $2,250,000 $12.00 $15.00





"Dave F" wrote:

What's the question?
--
Brevity is the soul of wit.


"ashley" wrote:

I have to create a data table with these numbers:

TERMS IN YEARS
15 20 25 30
100,000.00 7,500.02 7,500.00 7,500.00 7,500.00
105,000.00 7,875.02 7,875.00 7,875.00 7,875.00
110,000.00 8,250.02 8,250.00 8,250.00 8,250.00
115,000.00 8,625.02 8,625.00 8,625.00 8,625.00
120,000.00 9,000.02 9,000.00 9,000.00 9,000.00
125,000.00 9,375.02 9,375.00 9,375.00 9,375.00
130,000.00 9,750.02 9,750.00 9,750.00 9,750.00
135,000.00 10,125.02 10,125.00 10,125.00 10,125.00