Question: Create Excel Model a. Use an average percentage increase in housing prices g=3% per year b. Use an average interest rate earned on the sinking
Create Excel Model a. Use an average percentage increase in housing prices g=3% per year b. Use an average interest rate earned on the sinking fund r=5% per year c. Initially, assume it will take t=4 years to accumulate FV. (t will be varied in parts 3&4 below.) Use $130,000 as starting deposit. Make a 1-way Data Table in which the time to accumulate FV varies from 2 to 6 years in 1year increments, and the output columns are D and FV. Create Excel Model a. Use an average percentage increase in housing prices g=3% per year b. Use an average interest rate earned on the sinking fund r=5% per year c. Initially, assume it will take t=4 years to accumulate FV. (t will be varied in parts 3&4 below.) Use $130,000 as starting deposit. Make a 1-way Data Table in which the time to accumulate FV varies from 2 to 6 years in 1year increments, and the output columns are D and FV
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
