Please show work and formula for finding interest rate on Excel!
Calibri
11 AA
EB Paste
BIUFA Alignment Number Conditional Format as Cell FormattingTableStyles
Cells
Editing
Clipboard
Font
Styles
A1
X
fx
A
B
C
D
E
F
G
H
1
J
K A
1 2
According to the Census Bureau, in January 2013, the average house price in the United States was $306,900. In January 2000, the average price was $200,300. What was the annual increase in selling price?
3
4 5 6 7 8 9 10 11 12 13
Complete the following analysis. Do not hard code values in your calculations.
Present value $200,300
Years Interest rate Future value 13 $306,900