Need help with Excel worksheet....I'm lost.

[Theresa]

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]

Check one of your other posts.

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

 

[Don Guillett]

multi posting is a sin

 

[Theresa via OfficeKB.com]

Sorry, I was in a panic and didn't read the rules before I began. I hope the
God's of the website will forgive me!

multi posting is a sin

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 - 20 lines]

Thanks a million
Theresa

 

[Gord Dibben]

The website Gods will forgive but mollifying Stan is another matter<g>


Gord Dibben MS Excel MVP

Sorry, I was in a panic and didn't read the rules before I began. I hope the
God's of the website will forgive me!

multi posting is a sin

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 - 20 lines]

Thanks a million
Theresa