0% found this document useful (0 votes)
3 views4 pages

Goal Seek

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 4

Description Year-1 Year-2 Year-3 Year-4

1998 1999 2000 2001


Income 96000 114000 134000 148000
160000
Expense 72200 96000 120000 128000
140000
Balance 23800 18000 14000 20000
120000
100000
Axis Title 80000
60000
40000
20000
0
160000
140000
120000
100000
Row 2
Axis Title 80000
60000 Income
Expense
40000
Balance
20000
0
1 2 3 4
Axis Title
Price 131550
Down Payment 39465
Interest Rate 8%
Number of Year 5
Loan Amount 120000

Monthly Payment
$2,433.17 8 10 12 15
5%
7%
9%
10%
12%

You might also like