Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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. n= total number on months makng deposits| FV=$154,321(1+g)t The interest rate earned per month is i=r/12. The monthly deposit D needed to reach your goal in t years is D=(iF)/[(1+i)n1], where n is the total number of months over which you'll be making deposits

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurial Finance

Authors: M. J. Alhabeeb

1st Edition

1118691512, 978-1118691519

More Books

Students also viewed these Finance questions

Question

Define Administration and Management

Answered: 1 week ago

Question

Define organisational structure

Answered: 1 week ago

Question

Define line and staff authority

Answered: 1 week ago

Question

Define the process of communication

Answered: 1 week ago

Question

Explain the importance of effective communication

Answered: 1 week ago

Question

What are negative messages? (Objective 1)

Answered: 1 week ago