Panic at the PC - Need Excel spreadsheet help!
 

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

Panic at the PC - Need Excel spreadsheet help!
 

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

"teeinno" wrote:

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

Panic at the PC - Need Excel spreadsheet help!
 

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.

Sun, 13 May 2007 01:54:59 GMT from teeinno <u34137@uwe:
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

Panic at the PC - Need Excel spreadsheet help!
 

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.

Stan Brown wrote:
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.

Sun, 13 May 2007 01:54:59 GMT from teeinno <u34137@uwe:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1

Panic at the PC - Need Excel spreadsheet help!
 

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.

Stan Brown wrote:

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.

Sun, 13 May 2007 01:54:59 GMT from teeinno <u34137@uwe:
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



--

Dave Peterson

Panic at the PC - Need Excel spreadsheet help!
 

Good bye Stan.


Gord Dibben MS Excel MVP

On Sun, 13 May 2007 10:40:39 -0400, Stan Brown
wrote:

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.

Sun, 13 May 2007 01:54:59 GMT from teeinno <u34137@uwe:
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

Panic at the PC - Need Excel spreadsheet help!
 

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.

Stan Brown wrote:

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.

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Panic at the PC - Need Excel spreadsheet help!
 

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

FSt1 wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1

Panic at the PC - Need Excel spreadsheet help!
 

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

Dave Peterson wrote:
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]
Thanks a million
Theresa


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1

Panic at the PC - Need Excel spreadsheet help!
 

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.

Stan Brown wrote:
Sun, 13 May 2007 10:04:54 -0500 from Dave Peterson
:
This portion of USENet is usually pretty congenial.

[quoted text clipped - 8 lines]
If you spent half the time on your homework that you do on abusing
Usenet, you'd be done already.

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.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1