|
03-15-2005, 11:12 PM | #2 |
The Insider
Join Date: Jan 2004
Location: Lake of the Ozarks
Casino cash: $1958752
|
Don't you just hate excel?
|
Posts: 49,806
|
03-15-2005, 11:14 PM | #3 |
The Priest and I
Join Date: Mar 2003
Location: CO
Casino cash: $9870185
|
I just don't freakin' get it. I'm not one to ask for HW help, but I am clueless on this one.
|
Posts: 7,262
|
03-15-2005, 11:26 PM | #4 |
The Priest and I
Join Date: Mar 2003
Location: CO
Casino cash: $9870185
|
bump
|
Posts: 7,262
|
03-15-2005, 11:27 PM | #5 |
The Insider
Join Date: Jan 2004
Location: Lake of the Ozarks
Casino cash: $1958752
|
wish i could help
|
Posts: 49,806
|
03-15-2005, 11:28 PM | #6 |
NFL's #1 Ermines Fan
Join Date: Jul 2001
Location: My house
Casino cash: $2958491
VARSITY
|
What's the tuition statement about?
I think that all this problem is about is identifying how much you would need to save to earn the cost of the mobile home in ten years, along with the future value of each month's savings. I just don't know what they're talking about with tuition.
__________________
I'm putting random letters here as a celebration of free speech: xigrakgrah misorojeq rkemeseit. |
Posts: 141,710
|
03-15-2005, 11:31 PM | #7 | |
The Priest and I
Join Date: Mar 2003
Location: CO
Casino cash: $9870185
|
Quote:
Are you talking about the percentage of tuition saved? I believe it's what you said. Basically, what you will save on the investment if you pay into it monthly over a 10 year period. Basically, I think he is saying at the end, you take your calculated FV and divide it by your actual cost of the motor home (120,000) to get you ending figure. |
|
Posts: 7,262
|
03-15-2005, 11:39 PM | #8 |
The Priest and I
Join Date: Mar 2003
Location: CO
Casino cash: $9870185
|
Here was his example problem...
Price $154,000.00 Rate 8.25% Down_Pmt $32,000.00 Years 15 Loan_Amt $122,000.00 Monthly_Pmt $1,183.57 Total_Int $91,042.82 Total_Cost $245,042.82 Rate Monthly Pmt Total Interest Total Cost $1,183.57 $91,042.82 $245,042.82 7.50% $1,130.96 $81,571.91 $235,571.91 7.75% $1,148.36 $84,704.16 $238,704.16 8.00% $1,165.90 $87,861.20 $241,861.20 8.25% $1,183.57 $91,042.82 $245,042.82 8.50% $1,201.38 $94,248.81 $248,248.81 8.75% $1,219.33 $97,478.92 $251,478.92 9.00% $1,237.41 $100,732.94 $254,732.94 9.25% $1,255.61 $104,010.63 $258,010.63 9.50% $1,273.95 $107,311.74 $261,311.74 9.75% $1,292.42 $110,636.04 $264,636.04 10.00% $1,311.02 $113,983.28 $267,983.28 |
Posts: 7,262
|
03-15-2005, 11:52 PM | #9 |
NFL's #1 Ermines Fan
Join Date: Jul 2001
Location: My house
Casino cash: $2958491
VARSITY
|
Here's how I'd do it. I didn't bother to separate out the principal and interest, though that would be easy to do.
I used two methods - one using Excel's FV function, and the other calculated manually. The manual method is using a continuous growth assumption, so it's off a tad bit, I'll bet.
__________________
I'm putting random letters here as a celebration of free speech: xigrakgrah misorojeq rkemeseit. Last edited by Rain Man; 05-13-2008 at 06:29 PM.. |
Posts: 141,710
|
03-15-2005, 11:57 PM | #10 | |
The Priest and I
Join Date: Mar 2003
Location: CO
Casino cash: $9870185
|
Quote:
|
|
Posts: 7,262
|
03-15-2005, 11:59 PM | #11 |
NFL's #1 Ermines Fan
Join Date: Jul 2001
Location: My house
Casino cash: $2958491
VARSITY
|
Hopefully it's right. I think I understand what he's looking for, though.
__________________
I'm putting random letters here as a celebration of free speech: xigrakgrah misorojeq rkemeseit. |
Posts: 141,710
|
03-16-2005, 12:03 AM | #12 | |
The Priest and I
Join Date: Mar 2003
Location: CO
Casino cash: $9870185
|
Quote:
|
|
Posts: 7,262
|
|
|