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
Get step-by-step solutions from verified subject matter experts
