ChiefsPlanet - View Single Post - Question for you Microsoft Excel guru's...

TRR · 03-15-2005, 11:09 PM

I got a problem to do for a class, and I am struggling with it. Anyone care to help? Here is the problem....

Your looking to retire into a class one mobile home. For 10 years, you will make deposits. The account pays 7.25% annual interest. Create a worksheet that uses financial function to show future value on the investment and determine the percent of the mobile home cost saved.

Mobile Home Cost = $120,000
Rate (per month) = 7.25%/12
NPER = 10*12
PMT = $300
Percent of tuition saved = FV/Cost

Create a data table that shows the FV and percentage of Cost saved for monthly payments from $250 to $600 in 50 dollar increments.

Any help will get multiple rep!!

03-15-2005, 11:09 PM
TRR The Priest and I Join Date: Mar 2003 Location: CO Casino cash: $9870185	Question for you Microsoft Excel guru's... I got a problem to do for a class, and I am struggling with it. Anyone care to help? Here is the problem.... Your looking to retire into a class one mobile home. For 10 years, you will make deposits. The account pays 7.25% annual interest. Create a worksheet that uses financial function to show future value on the investment and determine the percent of the mobile home cost saved. Mobile Home Cost = $120,000 Rate (per month) = 7.25%/12 NPER = 10*12 PMT = $300 Percent of tuition saved = FV/Cost Create a data table that shows the FV and percentage of Cost saved for monthly payments from $250 to $600 in 50 dollar increments. Any help will get multiple rep!!
Posts: 7,261