Question: How would you respond to this post? I would like to finish the basement in my home to increase my living space. To do so,

How would you respond to this post?

I would like to finish the basement in my home to increase my living space. To do so, I would plan to spend $15,000 using an investment with an 8% return. Using the support of Excel's PV formula as indicated in the text, calculations are as follows (Byrd, Hickman, and McPherson, 2013) :

PV(RATE, NPER, PMT, FV, TYPE) PV(8%, 12, ?, 15000,0) PV= $5,556.71 would be the initial investment required to earn the $15,000 return desired for the completion of the project at the end of 12 years.

Perpetual Party:

The opportunity to leave the legacy of a perpetual party for family is a nice gesture. I currently host my family's Christmas each year, and this would be a great way to keep that tradition alive will into the future! I would invest $10,000 to dedicate to this tradition. In doing so, the perpetuity calculation, PV = CF/r would yield: PV= 10,000/.06 = $166,667 at the end of 50 years. To achieve this amount, I will need to make an annual investment. The annual investment will be: PMT =(6%, 50, ?, 166,667, 0) which indicates $564.05 will be needed for the funding.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!