Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lost text & fill colors from worksheet | Excel Worksheet Functions | |||
Help! Lost sheets by using View Code on worksheet tab | Excel Discussion (Misc queries) | |||
Lost all my worksheet tabs on excel | Excel Worksheet Functions | |||
I lost my colour icon from the top of my worksheet | Excel Discussion (Misc queries) | |||
lost my password (worksheet protect) | Excel Discussion (Misc queries) |