Panic at the PC - Need Excel spreadsheet help!

[teeinno]

I have to complete this assignment in the next few hours and have no idea
where to begin....any help would be sincerely appreciated.

Here it is:

A man has 5 years remaining on a six year car loan, his interest rate is 8.25%
and his monthly payment is $525.00. His credit union is willing to accept the
present value (PV) of the loan as a payoff. Develop an amortization schedule
that shows how much he must pay at the end of each of the six years. Then
create a worksheet that includes the beginning and ending balance, the amount
paid on the principal and the interest paid for years two through six.
Because he has paid for the first year already, determine only the ending
balance (present value) for year one.

I know this may come easy to someone but I am completely lost here. Please
help!

Thanks a million
Theresa

 

[Guest]

hi,
you will need 2 formulas to create the amortization schedule'
=CUMPRINC()
=CUMIPMT()
Look them up in xl help for more detail explination.

regards
FSt1

 

[Stan Brown]

Theresa, you ignorant slut,

Please see the eight or ten other threads you started with the SAME
DAMN ARTICLE.

If you spent half the time on your homework that you do on abusing
Usenet, you'd be done already.

 

[Theresa via OfficeKB.com]

You sir, are very rude and judge people harshly. I may have been wrong not to
read the rules before I started but at least I do not occupy my time bashing
newbies to the website. How very helpful you are! I posted in the three
forums I thought my question applied to:
General Help
New Users
Worksheet Functions
not eight or ten other places. Go away.

Theresa, you ignorant slut,

Please see the eight or ten other threads you started with the SAME
DAMN ARTICLE.

If you spent half the time on your homework that you do on abusing
Usenet, you'd be done already.

I have to complete this assignment in the next few hours and have no idea
where to begin....any help would be sincerely appreciated.

[quoted text clipped - 15 lines]

Thanks a million
Theresa

 

[Dave Peterson]

This portion of USENet is usually pretty congenial.

Not very many people around here would respond this way. Of course, you're free
to do what you want.

 

[Gord Dibben]

Good bye Stan.


Gord Dibben MS Excel MVP

Theresa, you ignorant slut,

Please see the eight or ten other threads you started with the SAME
DAMN ARTICLE.

If you spent half the time on your homework that you do on abusing
Usenet, you'd be done already.

 

[Stan Brown]

Sun, 13 May 2007 10:04:54 -0500 from Dave Peterson

This portion of USENet is usually pretty congenial.

Not very many people around here would respond this way. Of course,
you're free to do what you want.

Point taken.

In mitigation I'll plead that it was the combination of three things:
posting the same article in multiple newsgroups, posting it multiple
times with different subject lines in the same newsgroup, and the
expectation that we would do her homework for her with zero attempt
on her part to do it.

 

[Theresa via OfficeKB.com]

Thanks a lot for your direction. I really do appreciate it.
Tee

hi,
you will need 2 formulas to create the amortization schedule'
=CUMPRINC()
=CUMIPMT()
Look them up in xl help for more detail explination.

regards
FSt1

I have to complete this assignment in the next few hours and have no idea
where to begin....any help would be sincerely appreciated.

[quoted text clipped - 15 lines]

Thanks a million
Theresa

 

[Theresa via OfficeKB.com]

Thanks. Everyone else here seems very congenial.
It's nice to know there are people here to help, not judge others.
Tee

This portion of USENet is usually pretty congenial.

Not very many people around here would respond this way. Of course, you're free
to do what you want.

Theresa, you ignorant slut,

[quoted text clipped - 24 lines]

 

[Theresa via OfficeKB.com]

You know nothing of my attempts to solve this problem. I never expected to
have it done for me, just get some tips on how to start it. What is a
judgemental person like yourself doing on a help forum anyway? What a
miserable person you are to treat others as you do. I am guessing you never
needed any help in your life? Thanks for making me feel so special.

Sun, 13 May 2007 10:04:54 -0500 from Dave Peterson

This portion of USENet is usually pretty congenial.

[quoted text clipped - 8 lines]
Point taken.

In mitigation I'll plead that it was the combination of three things:
posting the same article in multiple newsgroups, posting it multiple
times with different subject lines in the same newsgroup, and the
expectation that we would do her homework for her with zero attempt
on her part to do it.