Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Need help with Excel worksheet....I'm lost.

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

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default Need help with Excel worksheet....I'm lost.

Check one of your other posts.

Theresa 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


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Need help with Excel worksheet....I'm lost.

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!




Don Guillett wrote:
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


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

  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default Need help with Excel worksheet....I'm lost.

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


Gord Dibben MS Excel MVP

On Sun, 13 May 2007 14:40:28 GMT, "Theresa via OfficeKB.com" <u34137@uwe wrote:

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!




Don Guillett wrote:
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost text & fill colors from worksheet Basher Bates Excel Worksheet Functions 1 February 14th 07 07:03 PM
Help! Lost sheets by using View Code on worksheet tab Michele Excel Discussion (Misc queries) 3 November 29th 06 08:16 AM
Lost all my worksheet tabs on excel cutsy Excel Worksheet Functions 2 November 4th 06 09:36 PM
I lost my colour icon from the top of my worksheet Bill van Wel Excel Discussion (Misc queries) 1 September 2nd 06 03:39 AM
lost my password (worksheet protect) Dan Winterton Excel Discussion (Misc queries) 1 January 18th 05 07:09 PM


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"