Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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/ |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import excel spreadsheet into an excel spreadsheet | Excel Worksheet Functions | |||
In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |