Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge > Media Center

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 03-15-2005, 11:09 PM   Topic Starter
TRR TRR is offline
The Priest and I
 
TRR's Avatar
 
Join Date: Mar 2003
Location: CO
Casino cash: $5145
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: 6,588
TRR has disabled reputation
  Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump




All times are GMT -6. The time now is 09:06 PM.


This is a test for a client's site.
A new website that shows member-created construction site listings that need fill or have excess fill. Dirt Monkey @ https://DirtMonkey.net
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.