|
03-15-2005, 11:09 PM | Topic Starter |
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
|
|
|